category_2_x_IATA_code.id,category_2.id,category_2.ts,category_2.title,category_1.id,category_1.ts,category_1.title,IATA_code.id,IATA_code.ts,IATA_code.code,IATA_code.city,IATA_code.airport,IATA_code.country
1,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",1,"2017-11-20 02:05:11",AAA,Anaa,Anaa,"French Polynesia"
2,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",2,"2017-11-20 02:05:11",AAB,Arrabury,Arrabury,Australia
3,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",3,"2017-11-20 02:05:11",AAC,Arish,"El Arish International Airport",Egypt
4,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",4,"2017-11-20 02:05:11",AAD,Ad-Dabbah,Ad-Dabbah,Sudan
5,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",5,"2017-11-20 02:05:11",AAE,Annaba,"Les Salines",Algeria
6,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",6,"2017-11-20 02:05:11",AAF,"Apalachicola (FL)",Municipal,USA
7,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",7,"2017-11-20 02:05:11",AAG,Arapoti,Arapoti,Brazil
8,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",8,"2017-11-20 02:05:11",AAH,Aachen,Aachen/Merzbrück,Germany
9,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",9,"2017-11-20 02:05:11",AAI,Arraias,Arraias,Brazil
10,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",10,"2017-11-20 02:05:11",AAJ,Awaradam,"Cayana Airstrip",Suriname
11,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",11,"2017-11-20 02:05:11",AAK,Aranuka,Aranuka,Kiribati
12,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",12,"2017-11-20 02:05:11",AAL,Aalborg,"Aalborg Airport (Aalborg Lufthavn)",Denmark
13,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",13,"2017-11-20 02:05:11",AAM,"Mala Mala","Mala Mala","South Africa"
14,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",14,"2017-11-20 02:05:11",AAN,"Al Ain","Al Ain International Airport","United Arab Emirates"
15,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",15,"2017-11-20 02:05:11",AAO,Anaco,Anzualegui,Venezuela
16,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",16,"2017-11-20 02:05:11",AAP,"Houston (TX)","Andrau Airpark (closed 1998)","Houston (TX) Andrau Airpark (closed 1998) USA"
17,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",17,"2017-11-20 02:05:11",AAQ,Anapa,"Vityazevo Airport",Russia
18,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",18,"2017-11-20 02:05:11",AAR,Aarhus,Tirstrup,Denmark
19,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",19,"2017-11-20 02:05:11",AAS,Apalapsili,Apalapsili,Indonesia
20,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",20,"2017-11-20 02:05:11",AAT,Altay,"Altay Airport","PR China"
21,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",21,"2017-11-20 02:05:11",AAU,Asau,Asau,Samoa
22,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",22,"2017-11-20 02:05:11",AAV,Alah,Alah,Philippines
23,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",23,"2017-11-20 02:05:11",AAW,Abbottabad,Abbottabad,Abbottabad
24,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",24,"2017-11-20 02:05:11",AAX,Araxa,Araxa,Brazil
25,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",25,"2017-11-20 02:05:11",AAY,"Al Ghaydah","Al Ghaydah",Yemen
26,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",26,"2017-11-20 02:05:11",AAZ,Quetzaltenango,"Quetzaltenango Airport",Guatemala
27,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",27,"2017-11-20 02:05:11",ABA,Abakan,Abakan,Russia
28,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",28,"2017-11-20 02:05:11",ABB,Abingdon,"RAF Station","United Kingdom"
29,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",29,"2017-11-20 02:05:11",ABC,Albacete,"Los Llanos",Spain
30,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",30,"2017-11-20 02:05:11",ABD,Abadan,Abadan,Iran
31,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",31,"2017-11-20 02:05:11",ABE,"Allentown (PA)","Lehigh Valley International",USA
32,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",32,"2017-11-20 02:05:11",ABE,"Bethlehem (PA)","Lehigh Valley International",USA
33,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",33,"2017-11-20 02:05:11",ABE,"Easton (PA)","Lehigh Valley International",USA
34,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",34,"2017-11-20 02:05:11",ABF,Abaiang,Abaiang,Kiribati
35,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",35,"2017-11-20 02:05:11",ABG,Abingdon,Abingdon,Australia
36,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",36,"2017-11-20 02:05:11",ABH,Alpha,Alpha,Australia
37,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",37,"2017-11-20 02:05:11",ABI,Abilene,Municipal,USA
38,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",38,"2017-11-20 02:05:11",ABJ,Abidjan,"Felix Houphouet Boigny International",Abidjan
39,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",39,"2017-11-20 02:05:11",ABK,"Kabri Dar","Kabri Dar",Ethiopia
40,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",40,"2017-11-20 02:05:11",ABL,"Ambler (AK)",Ambler,USA
41,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",41,"2017-11-20 02:05:11",ABM,Bamaga,Bamaga,Australia
42,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",42,"2017-11-20 02:05:11",ABN,Albina,Albina,Suriname
43,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",43,"2017-11-20 02:05:11",ABO,Aboisso,Aboisso,"Cote d'Ivoire"
44,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",44,"2017-11-20 02:05:11",ABP,Atkamba,Atkamba,"Papua New Guinea"
45,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",45,"2017-11-20 02:05:11",ABQ,"Albuquerque (NM)","Albuquerque International Sunport",USA
46,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",46,"2017-11-20 02:05:11",ABR,"Aberdeen (SD)",Municipal,USA
47,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",47,"2017-11-20 02:05:11",ABS,"Abu Simbel","Abu Simbel Airport",Egypt
48,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",48,"2017-11-20 02:05:11",ABT,Al-Baha,Al-Aqiq,"Saudi Arabia"
49,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",49,"2017-11-20 02:05:11",ABU,Atambua,Atambua,Indonesia
50,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",50,"2017-11-20 02:05:11",ABV,Abuja,"Nnamdi Azikiwe International Airport",Abuja
51,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",51,"2017-11-20 02:05:11",ABW,Abau,Abau,"Papua New Guinea"
52,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",52,"2017-11-20 02:05:11",ABX,Albury,Albury,Australia
53,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",53,"2017-11-20 02:05:11",ABY,"Albany (GA)","Dougherty County","Albany (GA) Dougherty County USA"
54,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",54,"2017-11-20 02:05:11",ABZ,Aberdeen,Dyce,"United Kingdom"
55,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",55,"2017-11-20 02:05:11",ACA,Acapulco,"Acapulco International Airport",Mexico
56,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",56,"2017-11-20 02:05:11",ACB,Bellaire,"Antrim County",
57,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",57,"2017-11-20 02:05:11",ACC,Accra,"Kotoka International Airport",Accra
58,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",58,"2017-11-20 02:05:11",ACD,Acandi,Acandi,Colombia
59,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",59,"2017-11-20 02:05:11",ACE,Lanzarote,Lanzarote,
60,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",60,"2017-11-20 02:05:11",ACH,Altenrhein,Altenrhein,Switzerland
61,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",61,"2017-11-20 02:05:11",ACI,"Alderney (one of the Channel Islands)","Alderney Airport - The Blaye","United Kingdom"
62,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",62,"2017-11-20 02:05:11",ACK,"Nantucket (MA)",Memorial,USA
63,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",63,"2017-11-20 02:05:11",ACL,Aguaclara,Aguaclara,Colombia
64,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",64,"2017-11-20 02:05:11",ACM,Arica,Arica,Colombia
65,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",65,"2017-11-20 02:05:11",ACN,"Ciudad Acuna",International,Mexico
66,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",66,"2017-11-20 02:05:11",ACO,Ascona,Ascona,Switzerland
67,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",67,"2017-11-20 02:05:11",ACR,Araracuara,Araracuara,Colombia
68,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",68,"2017-11-20 02:05:11",ACS,Achinsk,Achinsk,Russia
69,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",69,"2017-11-20 02:05:11",ACT,"Waco (TX)",Municipal,USA
70,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",70,"2017-11-20 02:05:11",ACU,Achutupo,Achutupo,Panama
71,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",71,"2017-11-20 02:05:11",ACV,"Arcata (CA)",Arcata,USA
72,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",72,"2017-11-20 02:05:11",ACY,"Atlantic City (NJ)","Atlantic City International","Atlantic City (NJ) Atlantic City International USA"
73,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",73,"2017-11-20 02:05:11",ACZ,Zabol,"Zabol A/P",Iran
74,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",74,"2017-11-20 02:05:11",ADA,Adana,Adana,Turkey
75,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",75,"2017-11-20 02:05:11",ADB,Izmir,"Adnan Menderes Airport",Turkey
76,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",76,"2017-11-20 02:05:11",ADC,Andakombe,Andakombe,"Papua New Guinea"
77,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",77,"2017-11-20 02:05:11",ADD,"Addis Ababa","Bole International Airport","Addis Ababa"
78,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",78,"2017-11-20 02:05:11",ADE,Aden,"Aden International Airport",Aden
79,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",79,"2017-11-20 02:05:11",ADF,Adiyaman,Adiyaman,Turkey
80,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",80,"2017-11-20 02:05:11",ADG,"Adrian (MI)","Lenawee County",USA
81,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",81,"2017-11-20 02:05:11",ADH,Aldan,Aldan,Russia
82,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",82,"2017-11-20 02:05:11",ADI,Arandis,Arandis,Namibia
83,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",83,"2017-11-20 02:05:11",ADJ,Amman,"Marka International Airport",Amman
84,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",84,"2017-11-20 02:05:11",ADK,"Adak Island (AK)","Adak Island NS",USA
85,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",85,"2017-11-20 02:05:11",ADL,Adelaide,"Adelaide International Airport",Adelaide
86,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",86,"2017-11-20 02:05:11",ADM,"Ardmore (OK)","Municipal Airport",USA
87,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",87,"2017-11-20 02:05:11",ADN,Andes,Andes,Colombia
88,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",88,"2017-11-20 02:05:11",ADO,Andamooka,Andamooka,Australia
89,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",89,"2017-11-20 02:05:11",ADP,Anuradhapura,Anuradhapura,"Sri Lanka"
90,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",90,"2017-11-20 02:05:11",ADQ,"Kodiak (AK)","Kodiak Airport",USA
91,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",91,"2017-11-20 02:05:11",ADR,"Andrews (SC)",Andrews,USA
92,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",92,"2017-11-20 02:05:11",ADS,"Dallas, Addison (TX)","Addison Airport","Dallas, Addison (TX) Addison Airport USA"
93,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",93,"2017-11-20 02:05:11",ADT,"Ada (OK)",Ada,USA
94,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",94,"2017-11-20 02:05:11",ADU,Ardabil,Ardabil,Iran
95,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",95,"2017-11-20 02:05:11",ADV,Andover,Andover,"United Kingdom"
96,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",96,"2017-11-20 02:05:11",ADW,"Camp Springs (MD)","Andrews AFB",USA
97,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",97,"2017-11-20 02:05:11",ADX,"St Andrews","RAF Leuchars","Scotland, United Kingdom"
98,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",98,"2017-11-20 02:05:11",ADY,Alldays,Alldays,"South Africa"
99,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",99,"2017-11-20 02:05:11",ADZ,"San Andres Island","Sesquicentenario International Airport",Colombia
100,1,"2017-11-20 01:45:19",A,1,"2017-11-20 01:45:19","Order by Code",100,"2017-11-20 02:05:11",AEA,"Abemama Atoll","Abemama Atoll",Kiribati