airline_code.id,airline_code.ts,airline_code.title,airline_code.iata,airline_code.icao,airline_code.callsign,airline_code.country,airline_code.website,alphabet.id,alphabet.ts,alphabet.lowercase,alphabet.uppercase
1,"2017-10-26 04:11:55","Ansett Australia",AN,AAA,ANSETT,Australia,http://www.ansett.com.au,1,"2017-10-25 05:51:42",a,A
2,"2017-10-26 04:12:02","Abelag Aviation",W9,AAB,ABG,Belgium,http://www.abelag.com,1,"2017-10-25 05:51:42",a,A
3,"2017-10-26 04:12:08","Army Air Corps",,AAC,ARMYAIR,"United Kingdom",,1,"2017-10-25 05:51:42",a,A
4,"2017-10-26 04:12:17","Aero Aviation Centre Ltd.",,AAD,SUNRISE,Canada,,1,"2017-10-25 05:51:42",a,A
5,"2017-10-26 04:12:24","Aigle Azur",ZI,AAF,"AIGLE AZUR",France,http://www.aigle-azur.fr,1,"2017-10-25 05:51:42",a,A
6,"2017-10-26 04:12:29","Air Atlantique",,AAG,ATLANTIC,"United Kingdom",http://www.airatlantique.co.uk,1,"2017-10-25 05:51:42",a,A
7,"2017-10-26 04:12:30","Aloha Air Cargo",KH,AAH,ALOHA,US,http://www.alohaaircargo.com,1,"2017-10-25 05:51:42",a,A
8,"2017-10-26 04:12:32","Air Aurora",,AAI,BOREALIS,US,,1,"2017-10-25 05:51:42",a,A
9,"2017-10-26 04:12:38","Air Alma",,AAJ,"AIR ALMA",Canada,,1,"2017-10-25 05:51:42",a,A
10,"2017-10-26 04:12:39","Alaska Island Air",,AAK,"ALASKA ISLAND",US,,1,"2017-10-25 05:51:42",a,A
11,"2017-10-26 04:12:42","American Airlines",AA,AAL,AMERICAN,US,http://www.aa.com,1,"2017-10-25 05:51:42",a,A
12,"2017-10-26 04:12:51","Aviation Management Corporation",,AAM,"AM CORP",US,,1,"2017-10-25 05:51:42",a,A
13,"2017-10-26 04:12:59","Atlantis Airlines (USA)",,AAO,"ATLANTIS AIR",US,,1,"2017-10-25 05:51:42",a,A
14,"2017-10-26 04:13:00","Aerovista Airlines",,AAP,"AEROVISTA GROUP","United Arab Emirates",http://www.aerovista.net,1,"2017-10-25 05:51:42",a,A
15,"2017-10-26 04:13:06",Copterline,,AAQ,COPTERLINE,Finland,http://www.copterline.com/en,1,"2017-10-25 05:51:42",a,A
16,"2017-10-26 04:13:13","Asiana Airlines",OZ,AAR,ASIANA,"Republic of Korea",http://flyasiana.com,1,"2017-10-25 05:51:42",a,A
17,"2017-10-26 04:13:14","Askari Aviation",4K,AAS,AL-AAS,Pakistan,,1,"2017-10-25 05:51:42",a,A
18,"2017-10-26 04:13:25","Australia Asia Airlines",,AAU,AUSTASIA,Australia,,1,"2017-10-25 05:51:42",a,A
19,"2017-10-26 04:13:28","Astro Air International",,AAV,ASTRO-PHIL,US,,1,"2017-10-25 05:51:42",a,A
20,"2017-10-26 04:13:38","Afriqiyah Airways",8U,AAW,AFRIQIYAH,Libya,http://www.afriqiyah.aero/,1,"2017-10-25 05:51:42",a,A
21,"2017-10-26 04:13:45","Allegiant Air",G4,AAY,ALLEGIANT,US,http://www.allegiantair.com,1,"2017-10-25 05:51:42",a,A
22,"2017-10-26 04:13:49","Angus Aviation",,AAZ,ANGUS,Canada,,1,"2017-10-25 05:51:42",a,A
23,"2017-10-26 04:13:55",Artem-Avia,,ABA,ARTEM-AVIA,Ukraine,,1,"2017-10-25 05:51:42",a,A
24,"2017-10-26 04:14:01","African Business and Transportations",,ABB,"AFRICAN BUSINESS-","Democratic Republic of the Congo",,1,"2017-10-25 05:51:42",a,A
25,"2017-10-26 04:14:04","Air Atlanta Icelandic",CC,ABD,ATLANTA,Iceland,http://www.airatlanta.is,1,"2017-10-25 05:51:42",a,A
26,"2017-10-26 04:14:08","Aban Air",K5,ABE,ABAN,Iran,,1,"2017-10-25 05:51:42",a,A
27,"2017-10-26 04:14:12","Aerial Oy",,ABF,SKYWINGS,Finland,,1,"2017-10-25 05:51:42",a,A
28,"2017-10-26 04:14:20","Royal Flight",RL,ABG,"ROYAL FLIGHT",Russia,http://www.royalflight.ru,1,"2017-10-25 05:51:42",a,A
29,"2017-10-26 04:14:22","Hokuriki-Koukuu Company",,ABH,,Japan,,1,"2017-10-25 05:51:42",a,A
30,"2017-10-26 04:14:31","Abaeté Linhas Aéreas",,ABJ,Abaeté,Brazil,http://www.abaete.com.br,1,"2017-10-25 05:51:42",a,A
31,"2017-10-26 04:14:41","Alberta Citylink",,ABK,"ALBERTA CITYLINK",Canada,,1,"2017-10-25 05:51:42",a,A
32,"2017-10-26 04:14:44","Air BC",,ABL,AIRCOACH,Canada,,1,"2017-10-25 05:51:42",a,A
33,"2017-10-26 04:14:47","Aero Albatros",,ABM,"ALBATROS ESPANA",Spain,,1,"2017-10-25 05:51:42",a,A
34,"2017-10-26 04:14:57","Air Fret Senegal",,ABN, ,Senegal,,1,"2017-10-25 05:51:42",a,A
35,"2017-10-26 04:14:59","APSA Colombia",,ABO,AEROEXPRESO,Colombia,http://www.apsa.com.co,1,"2017-10-25 05:51:42",a,A
36,"2017-10-26 04:15:09","Aba Air",,ABP,BAIR,"Czech Republic",,1,"2017-10-25 05:51:42",a,A
37,"2017-10-26 04:15:17",Airblue,ED,ABQ,PAKBLUE,Pakistan,http://www.airblue.com,1,"2017-10-25 05:51:42",a,A
38,"2017-10-26 04:15:23","Air Contractors",AG,ABR,CONTRACT,Ireland,http://www.aircontractors.com,1,"2017-10-25 05:51:42",a,A
39,"2017-10-26 04:15:31","Transwest Air",9T,ABS,ATHABASKA,Canada,http://www.transwestair.com,1,"2017-10-25 05:51:42",a,A
40,"2017-10-26 04:15:32","Air Brousse",,ABT,"AIR BROUSSE",Canada,,1,"2017-10-25 05:51:42",a,A
41,"2017-10-26 04:15:42","Aerovias Bueno",,ABU,AEROBUENO,Colombia,,1,"2017-10-25 05:51:42",a,A
42,"2017-10-26 04:15:47","Antrak Air",04,ABV,ANTRAK,Ghana,http://www.antrakair.com,1,"2017-10-25 05:51:42",a,A
43,"2017-10-26 04:15:54","AirBridge Cargo",RU,ABW,"AIRBRIDGE CARGO",Russia,http://www.airbridgecargo.com,1,"2017-10-25 05:51:42",a,A
44,"2017-10-26 04:16:00","ABX Air",GB,ABX,ABEX,US,http://www.abxair.com,1,"2017-10-25 05:51:42",a,A
45,"2017-10-26 04:16:01","Air Arabia",G9,ABY,ARABIA,"United Arab Emirates",http://www.airarabia.com,1,"2017-10-25 05:51:42",a,A
46,"2017-10-26 04:16:11","ATA Brasil",,ABZ,ATA-BRAZIL,Brazil,,1,"2017-10-25 05:51:42",a,A
47,"2017-10-26 04:16:13","Air Canada",AC,ACA,"AIR CANADA",Canada,http://www.aircanada.com,1,"2017-10-25 05:51:42",a,A
48,"2017-10-26 04:16:14","Avcard Services",,ACC,,"United Kingdom",,1,"2017-10-25 05:51:42",a,A
49,"2017-10-26 04:16:17","Academy Airlines",,ACD,ACADEMY,US,,1,"2017-10-25 05:51:42",a,A
50,"2017-10-26 04:16:17","Race Cargo Airlines",,ACE,Fastcargo,Ghana,,1,"2017-10-25 05:51:42",a,A
51,"2017-10-26 04:16:19","Centro de Formacion Aeronautica de Canarias",,ACF,FORCAN,Spain,,1,"2017-10-25 05:51:42",a,A
52,"2017-10-26 04:16:24","Air Partner",,ACG,"AIR PARTNER","United Kingdom",,1,"2017-10-25 05:51:42",a,A
53,"2017-10-26 04:16:27","Air Caledonie International",SB,ACI,AIRCALIN,France,http://www.aircalin.com,1,"2017-10-25 05:51:42",a,A
54,"2017-10-26 04:16:32","Nantucket Airlines",DV,ACK,"ACK AIR",US,http://www.nantucketairlines.com,1,"2017-10-25 05:51:42",a,A
55,"2017-10-26 04:16:36","Itali Airlines",9X,ACL,ITALI,Italy,http://www.italiweb.it,1,"2017-10-25 05:51:42",a,A
56,"2017-10-26 04:16:44","Air Caledonia",,ACM,"WEST CAL",Canada,,1,"2017-10-25 05:51:42",a,A
57,"2017-10-26 04:16:50","Central American Airlines",,ACN,AEROCENTRO,Nicaragua,,1,"2017-10-25 05:51:42",a,A
58,"2017-10-26 04:16:58","Aero Comondu",,ACO,"AERO COMONDU",Mexico,,1,"2017-10-25 05:51:42",a,A
59,"2017-10-26 04:17:05","Astral Aviation",8V,ACP,"ASTRAL CARGO",Kenya,http://www.astral-aviation.com,1,"2017-10-25 05:51:42",a,A
60,"2017-10-26 04:17:11","Nuevo Continente",N6,ACQ,"AERO CONTINENTE",Peru,,1,"2017-10-25 05:51:42",a,A
61,"2017-10-26 04:17:17","Aerocenter, Escuela de Formacion de Pioltos Privad",,ACR,AEROCENTER,Spain,,1,"2017-10-25 05:51:42",a,A
62,"2017-10-26 04:17:23","Air Cess",,ACS,,Liberia,,1,"2017-10-25 05:51:42",a,A
63,"2017-10-26 04:17:32","Air Cargo Transportation System",,ACU,AFRISPIRIT,Kenya,,1,"2017-10-25 05:51:42",a,A
64,"2017-10-26 04:17:36","Air Charter Service",,ACV,,"United Kingdom",,1,"2017-10-25 05:51:42",a,A
65,"2017-10-26 04:17:36","Royal Air Force",,ACW,"AIR CADET","United Kingdom",,1,"2017-10-25 05:51:42",a,A
66,"2017-10-26 04:17:43","Air Charters",,ACX,PARAIR,Canada,,1,"2017-10-25 05:51:42",a,A
67,"2017-10-26 04:17:50","Atlas Cargo Lines",,ACY,"ATLAS CARGOLINES",Morocco,,1,"2017-10-25 05:51:42",a,A
68,"2017-10-26 04:18:01","Airservices Australia",,ADA,AUSCAL,Australia,,1,"2017-10-25 05:51:42",a,A
69,"2017-10-26 04:18:10","Antonov Airlines",,ADB,"ANTONOV BUREAU",Ukraine,http://www.antonov.com/products/aircompany/,1,"2017-10-25 05:51:42",a,A
70,"2017-10-26 04:18:11","Air Atlantic Dominicana",,ADC,ATLAN-DOMINICAN,"Dominican Republic",,1,"2017-10-25 05:51:42",a,A
71,"2017-10-26 04:18:14","Advanced Air Co.",,ADD,,Japan,,1,"2017-10-25 05:51:42",a,A
72,"2017-10-26 04:18:15","Aerea Flying Training Organization",,ADG,"AEREA TRAINING",Spain,,1,"2017-10-25 05:51:42",a,A
73,"2017-10-26 04:18:18","Air One",AP,ADH,HERON,Italy,http://www.flyairone.it,1,"2017-10-25 05:51:42",a,A
74,"2017-10-26 04:18:26","Audeli Air",,ADI,AUDELI,Spain,,1,"2017-10-25 05:51:42",a,A
75,"2017-10-26 04:18:36",Abicar,,ADJ,ABICAR,"Ivory Coast",,1,"2017-10-25 05:51:42",a,A
76,"2017-10-26 04:18:38","ADC Airlines",Z7,ADK,ADCO,Nigeria,http://www.adcairlines.com,1,"2017-10-25 05:51:42",a,A
77,"2017-10-26 04:18:41","Aero Dynamics",,ADL,COTSWOLD,"United Kingdom",,1,"2017-10-25 05:51:42",a,A
78,"2017-10-26 04:18:52","Aerolineas Dominicanas",,ADM,DOMINAIR,"Dominican Republic",,1,"2017-10-25 05:51:42",a,A
79,"2017-10-26 04:18:56","Aerodienst GmbH",,ADN,AERODIENST,Germany,,1,"2017-10-25 05:51:42",a,A
80,"2017-10-26 04:19:06","Air Do",HD,ADO,"AIR DO",Japan,http://www.airdo.jp/share/eng/index.html,1,"2017-10-25 05:51:42",a,A
81,"2017-10-26 04:19:11",Aerodiplomatic,,ADP,AERODIPLOMATIC,Mexico,,1,"2017-10-25 05:51:42",a,A
82,"2017-10-26 04:19:12","Avion Taxi",,ADQ,"AIR DATA",Canada,,1,"2017-10-25 05:51:42",a,A
83,"2017-10-26 04:19:21","Adria Airways",JP,ADR,ADRIA,Slovenia,http://www.adria.si,1,"2017-10-25 05:51:42",a,A
84,"2017-10-26 04:19:26","Aviones de Sonora",,ADS,SONORAV,Mexico,,1,"2017-10-25 05:51:42",a,A
85,"2017-10-26 04:19:36","Air Dorval",,ADT,"AIR DORVAL",Canada,,1,"2017-10-25 05:51:42",a,A
86,"2017-10-26 04:19:39","Airdeal Oy",,ADU,AIRDEAL,Finland,,1,"2017-10-25 05:51:42",a,A
87,"2017-10-26 04:19:45","Advance Air Charters",,ADV,ADVANCE,Canada,,1,"2017-10-25 05:51:42",a,A
88,"2017-10-26 04:19:52","Air Andaman",,ADW,"AIR ANDAMAN",Thailand,,1,"2017-10-25 05:51:42",a,A
89,"2017-10-26 04:20:02","Anderson Aviation",,ADX,ANDAX,US,,1,"2017-10-25 05:51:42",a,A
90,"2017-10-26 04:20:12",Aerodyne,,ADY,AERODYNE,US,,1,"2017-10-25 05:51:42",a,A
91,"2017-10-26 04:20:13","Air Europa",UX,AEA,EUROPA,Spain,http://www.aireuropa.com,1,"2017-10-25 05:51:42",a,A
92,"2017-10-26 04:20:17","Aero Benin",EM,AEB,AEROBEN,Benin,,1,"2017-10-25 05:51:42",a,A
93,"2017-10-26 04:20:27","Aerocesar, Aerovias Del Cesar",,AEC,AEROCESAR,Colombia,,1,"2017-10-25 05:51:42",a,A
94,"2017-10-26 04:20:37","Aerotrans Airlines",,AED,,Russia,,1,"2017-10-25 05:51:42",a,A
95,"2017-10-26 04:20:43","Aegean Airlines",A3,AEE,AEGEAN,Greece,http://www.aegeanair.com,1,"2017-10-25 05:51:42",a,A
96,"2017-10-26 04:20:45","Aerofumigaciones Sam",,AEG,"FUMIGACIONES SAM",Chile,,1,"2017-10-25 05:51:42",a,A
97,"2017-10-26 04:20:56",Aviaexpress,RX,AEH,Avex,Hungary,,1,"2017-10-25 05:51:42",a,A
98,"2017-10-26 04:21:06","Aeroexpreso Interamericano",,AEI,INTERAM,Colombia,,1,"2017-10-25 05:51:42",a,A
99,"2017-10-26 04:21:09","Air Express",,AEJ,"KHAKI EXPRESS",Tanzania,,1,"2017-10-25 05:51:42",a,A
100,"2017-10-26 04:21:19",Aerocon,,AEK,AEROCON,Bolivia,,1,"2017-10-25 05:51:42",a,A