CREATE TABLE airports (

`name` VARCHAR(56) CHARACTER SET utf8,

`code` VARCHAR(3) CHARACTER SET utf8,

`stateCode` VARCHAR(2) CHARACTER SET utf8,

`countryCode` VARCHAR(2) CHARACTER SET utf8,

`countryName` VARCHAR(32) CHARACTER SET utf8

);

INSERT INTO airports VALUES ('Anaa','AAA',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Annaba Les Salines','AAE',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Aalborg','AAL',NULL,'DK','Denmark');

INSERT INTO airports VALUES ('Mala Mala','AAM',NULL,'ZA','South Africa');

INSERT INTO airports VALUES ('Al Ain','AAN',NULL,'AE','United Arab Emirates');

INSERT INTO airports VALUES ('Anapa','AAQ',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Aarhus Tirstrup','AAR',NULL,'DK','Denmark');

INSERT INTO airports VALUES ('Altay','AAT',NULL,'CN','China');

INSERT INTO airports VALUES ('Araxa','AAX','MG','BR','Brazil');

INSERT INTO airports VALUES ('Al Ghaydah','AAY',NULL,'YE','Yemen');

INSERT INTO airports VALUES ('Abakan','ABA',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Albacete Los Llanos','ABC',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Abadan','ABD',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Allentown Bethlehem Easton Lehigh Valley Intl','ABE','PA','US','United States');

INSERT INTO airports VALUES ('Abilene Regional Airport','ABI','TX','US','United States');

INSERT INTO airports VALUES ('Abidjan Felix Houphouet Boigny','ABJ',NULL,'CI','Ivory Coast');

INSERT INTO airports VALUES ('Kabri Dar','ABK',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Ambler','ABL','AK','US','United States');

INSERT INTO airports VALUES ('Bamaga','ABM','QL','AU','Australia');

INSERT INTO airports VALUES ('Albuquerque International','ABQ','NM','US','United States');

INSERT INTO airports VALUES ('Aberdeen Municipal','ABR','SD','US','United States');

INSERT INTO airports VALUES ('Abu Simbel','ABS',NULL,'EG','Egypt');

INSERT INTO airports VALUES ('Al Baha Al Aqiq','ABT',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Abuja International','ABV',NULL,'NG','Nigeria');

INSERT INTO airports VALUES ('Albury','ABX','NS','AU','Australia');

INSERT INTO airports VALUES ('Albany Dougherty County','ABY','GA','US','United States');

INSERT INTO airports VALUES ('Aberdeen Dyce','ABZ',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Acapulco Juan Alvarez International','ACA',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Accra Kotoka','ACC',NULL,'GH','Ghana');

INSERT INTO airports VALUES ('Lanzarote','ACE',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Altenrhein','ACH',NULL,'CH','Switzerland');

INSERT INTO airports VALUES ('Alderney The Blaye','ACI',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Nantucket Memorial','ACK','MA','US','United States');

INSERT INTO airports VALUES ('Achinsk','ACS',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Waco Metropolitan Area','ACT','TX','US','United States');

INSERT INTO airports VALUES ('Eureka Arcata','ACV','CA','US','United States');

INSERT INTO airports VALUES ('Atlantic City Intl','ACY','NJ','US','United States');

INSERT INTO airports VALUES ('P Zabol A','ACZ',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Adana','ADA',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Izmir Adnan Menderes Arpt','ADB',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Addis Ababa Bole','ADD',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Aden International','ADE',NULL,'YE','Yemen');

INSERT INTO airports VALUES ('Adiyaman','ADF',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Amman Civil Marka Airport','ADJ',NULL,'JO','Jordan');

INSERT INTO airports VALUES ('Adak Island NS','ADK','AK','US','United States');

INSERT INTO airports VALUES ('Adelaide','ADL','SA','AU','Australia');

INSERT INTO airports VALUES ('Kodiak Airport','ADQ','AK','US','United States');

INSERT INTO airports VALUES ('Ardabil','ADU',NULL,'IR','Iran');

INSERT INTO airports VALUES ('St Andrews Leuchars','ADX',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('San Andres Island','ADZ',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Abecher','AEH',NULL,'TD','Chad');

INSERT INTO airports VALUES ('Buenos Aires Arpt Jorge Newbery','AEP','BA','AR','Argentina');

INSERT INTO airports VALUES ('Sochi International Airport','AER',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Aalesund Vigra','AES',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Allakaket','AET','AK','US','United States');

INSERT INTO airports VALUES ('Alexandria Internation','AEX','LA','US','United States');

INSERT INTO airports VALUES ('Akureyri','AEY',NULL,'IS','Iceland');

INSERT INTO airports VALUES ('San Rafael','AFA','MD','AR','Argentina');

INSERT INTO airports VALUES ('Alta Floresta','AFL','MT','BR','Brazil');

INSERT INTO airports VALUES ('Afutara Aerodrome','AFT',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Agadir Almassira','AGA',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Agen La Garenne','AGF',NULL,'FR','France');

INSERT INTO airports VALUES ('Helsingborg Angelholm','AGH',NULL,'SE','Sweden');

INSERT INTO airports VALUES ('Tasiilaq','AGM',NULL,'GL','Greenland');

INSERT INTO airports VALUES ('Angoon','AGN','AK','US','United States');

INSERT INTO airports VALUES ('Malaga','AGP',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Agra Kheria','AGR',NULL,'IN','India');

INSERT INTO airports VALUES ('Augusta Bush Field','AGS','GA','US','United States');

INSERT INTO airports VALUES ('Ciudad del Este Alejo Garcia','AGT',NULL,'PY','Paraguay');

INSERT INTO airports VALUES ('Aguascalientes','AGU',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Acarigua','AGV',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Agatti Island','AGX',NULL,'IN','India');

INSERT INTO airports VALUES ('Abha','AHB',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Herlong Amedee AAF','AHC','CA','US','United States');

INSERT INTO airports VALUES ('Ahe Airport','AHE',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Alghero Fertilia','AHO',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Ahuas','AHS',NULL,'HN','Honduras');

INSERT INTO airports VALUES ('Al Hoceima Charif Al Idrissi','AHU',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Alliance','AIA','NE','US','United States');

INSERT INTO airports VALUES ('Wainwright','AIN','AK','US','United States');

INSERT INTO airports VALUES ('Aitutaki','AIT',NULL,'CK','Cook Islands');

INSERT INTO airports VALUES ('Atiu Island','AIU',NULL,'CK','Cook Islands');

INSERT INTO airports VALUES ('Atlantic City Bader Field','AIY','NJ','US','United States');

INSERT INTO airports VALUES ('Ajaccio Campo Dell Oro','AJA',NULL,'FR','France');

INSERT INTO airports VALUES ('Jouf','AJF',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Agri','AJI',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Aizawl','AJL',NULL,'IN','India');

INSERT INTO airports VALUES ('Anjouan Ouani','AJN',NULL,'KM','Comoros');

INSERT INTO airports VALUES ('Sabre Tech Off line Point','AJP','TX','US','United States');

INSERT INTO airports VALUES ('Arvidsjaur','AJR',NULL,'SE','Sweden');

INSERT INTO airports VALUES ('Aracaju','AJU','SE','BR','Brazil');

INSERT INTO airports VALUES ('Ankang','AKA',NULL,'CN','China');

INSERT INTO airports VALUES ('Atka','AKB','AK','US','United States');

INSERT INTO airports VALUES ('Kufrah','AKF',NULL,'LY','Libya');

INSERT INTO airports VALUES ('Akiak','AKI','AK','US','United States');

INSERT INTO airports VALUES ('Asahikawa','AKJ',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Akhiok SPB','AKK','AK','US','United States');

INSERT INTO airports VALUES ('Auckland Jean Batten','AKL',NULL,'NZ','New Zealand');

INSERT INTO airports VALUES ('King Salmon','AKN','AK','US','United States');

INSERT INTO airports VALUES ('Anaktuvuk','AKP','AK','US','United States');

INSERT INTO airports VALUES ('Auki Gwaunaruu','AKS',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Aksu','AKU',NULL,'CN','China');

INSERT INTO airports VALUES ('Akulivik','AKV','QC','CA','Canada');

INSERT INTO airports VALUES ('Aktyubinsk','AKX',NULL,'KZ','Kazakhstan');

INSERT INTO airports VALUES ('Sittwe Civil','AKY',NULL,'MM','Myanmar');

INSERT INTO airports VALUES ('Almaty','ALA',NULL,'KZ','Kazakhstan');

INSERT INTO airports VALUES ('Albany International','ALB','NY','US','United States');

INSERT INTO airports VALUES ('Alicante','ALC',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Alta','ALF',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Algiers Houari Boumediene','ALG',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Albany','ALH','WA','AU','Australia');

INSERT INTO airports VALUES ('Alamogordo Municipal','ALM','NM','US','United States');

INSERT INTO airports VALUES ('Waterloo','ALO','IA','US','United States');

INSERT INTO airports VALUES ('Aleppo Nejrab','ALP',NULL,'SY','Syrian Arab Republic');

INSERT INTO airports VALUES ('Alamosa Municipal','ALS','CO','US','United States');

INSERT INTO airports VALUES ('Walla Walla','ALW','WA','US','United States');

INSERT INTO airports VALUES ('Alexandria El Nohza','ALY',NULL,'EG','Egypt');

INSERT INTO airports VALUES ('Alitak SPB','ALZ','AK','US','United States');

INSERT INTO airports VALUES ('Amarillo International','AMA','TX','US','United States');

INSERT INTO airports VALUES ('Ahmedabad','AMD',NULL,'IN','India');

INSERT INTO airports VALUES ('Arba Mintch','AMH',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Mataram Selaparang','AMI',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Amman Queen Alia Intl','AMM',NULL,'JO','Jordan');

INSERT INTO airports VALUES ('Ambon Pattimura','AMQ',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Amsterdam Schiphol','AMS',NULL,'NL','Netherlands');

INSERT INTO airports VALUES ('Amderma','AMV',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Ambatomainty','AMY',NULL,'MG','Madagascar');

INSERT INTO airports VALUES ('Anchorage International','ANC','AK','US','United States');

INSERT INTO airports VALUES ('Angers Marce','ANE',NULL,'FR','France');

INSERT INTO airports VALUES ('Antofagasta Cerro Moreno','ANF',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Aniak','ANI','AK','US','United States');

INSERT INTO airports VALUES ('Ankara Etimesgut','ANK',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Antalaha Antsirabato','ANM',NULL,'MG','Madagascar');

INSERT INTO airports VALUES ('Antwerp Deurne','ANR',NULL,'BE','Belgium');

INSERT INTO airports VALUES ('Andahuaylas','ANS',NULL,'PE','Peru');

INSERT INTO airports VALUES ('Antigua VC Bird Intl','ANU',NULL,'AG','Antigua And Barbuda');

INSERT INTO airports VALUES ('Anvik','ANV','AK','US','United States');

INSERT INTO airports VALUES ('Andenes','ANX',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Eskisehir Anadolu University','AOE',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Ancona Falconara','AOI',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Aomori','AOJ',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Karpathos','AOK',NULL,'GR','Greece');

INSERT INTO airports VALUES ('Altoona Martinsburg','AOO','PA','US','United States');

INSERT INTO airports VALUES ('Alor Setar','AOR',NULL,'MY','Malaysia');

INSERT INTO airports VALUES ('Amook','AOS','AK','US','United States');

INSERT INTO airports VALUES ('Denver Arapahoe Co','APA','CO','US','United States');

INSERT INTO airports VALUES ('Naples','APF','FL','US','United States');

INSERT INTO airports VALUES ('Apataki','APK',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Nampula','APL',NULL,'MZ','Mozambique');

INSERT INTO airports VALUES ('Alpena County Regional','APN','MI','US','United States');

INSERT INTO airports VALUES ('Apartado','APO',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Apia Faleolo','APW',NULL,'WS','Samoa');

INSERT INTO airports VALUES ('Anqing','AQG',NULL,'CN','China');

INSERT INTO airports VALUES ('Qaisumah','AQI',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Aqaba King Hussein Intl','AQJ',NULL,'JO','Jordan');

INSERT INTO airports VALUES ('Arequipa Rodriguez Ballon','AQP',NULL,'PE','Peru');

INSERT INTO airports VALUES ('New Iberia Acadiana Regional','ARA','LA','US','United States');

INSERT INTO airports VALUES ('Arctic Village','ARC','AK','US','United States');

INSERT INTO airports VALUES ('Arkhangelsk','ARH',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Arica Chacalluta','ARI',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Arusha','ARK',NULL,'TZ','Tanzania');

INSERT INTO airports VALUES ('Armidale','ARM','NS','AU','Australia');

INSERT INTO airports VALUES ('Stockholm Arlanda','ARN',NULL,'SE','Sweden');

INSERT INTO airports VALUES ('Watertown','ART','NY','US','United States');

INSERT INTO airports VALUES ('Aracatuba','ARU','SP','BR','Brazil');

INSERT INTO airports VALUES ('Minocqua Noble F Lee','ARV','WI','US','United States');

INSERT INTO airports VALUES ('Arad','ARW',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Assab','ASA',NULL,'ER','Eritrea');

INSERT INTO airports VALUES ('Ashgabat','ASB',NULL,'TM','Turkmenistan');

INSERT INTO airports VALUES ('Andros Town','ASD',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Aspen','ASE','CO','US','United States');

INSERT INTO airports VALUES ('Astrakhan','ASF',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Georgetown Wideawake Fld','ASI',NULL,'SH','Saint Helena');

INSERT INTO airports VALUES ('Amami O Shima','ASJ',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Asmara International','ASM',NULL,'ER','Eritrea');

INSERT INTO airports VALUES ('Asosa','ASO',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Alice Springs','ASP','NT','AU','Australia');

INSERT INTO airports VALUES ('Kayseri','ASR',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Asuncion Silvio Pettirossi','ASU',NULL,'PY','Paraguay');

INSERT INTO airports VALUES ('Amboseli','ASV',NULL,'KE','Kenya');

INSERT INTO airports VALUES ('Aswan','ASW',NULL,'EG','Egypt');

INSERT INTO airports VALUES ('Atbara','ATB',NULL,'SD','Sudan');

INSERT INTO airports VALUES ('Arthurs Town','ATC',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Atoifi','ATD',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Athens Eleftherios Venizelos','ATH',NULL,'GR','Greece');

INSERT INTO airports VALUES ('Atqasuk','ATK','AK','US','United States');

INSERT INTO airports VALUES ('Atlanta Hartsfield Jackson','ATL','GA','US','United States');

INSERT INTO airports VALUES ('Altamira','ATM','PA','BR','Brazil');

INSERT INTO airports VALUES ('Amritsar Raja Sansi','ATQ',NULL,'IN','India');

INSERT INTO airports VALUES ('Atar Mouakchott','ATR',NULL,'MR','Mauritania');

INSERT INTO airports VALUES ('Atmautluak','ATT','AK','US','United States');

INSERT INTO airports VALUES ('Appleton International Airport','ATW','WI','US','United States');

INSERT INTO airports VALUES ('Watertown','ATY','SD','US','United States');

INSERT INTO airports VALUES ('Assiut','ATZ',NULL,'EG','Egypt');

INSERT INTO airports VALUES ('Aruba Reina Beatrix','AUA',NULL,'AW','Aruba');

INSERT INTO airports VALUES ('Arauca','AUC',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Augusta','AUG','ME','US','United States');

INSERT INTO airports VALUES ('Abu Dhabi Intl','AUH',NULL,'AE','United Arab Emirates');

INSERT INTO airports VALUES ('Alakanuk','AUK','AK','US','United States');

INSERT INTO airports VALUES ('Atuona','AUQ',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Aurillac','AUR',NULL,'FR','France');

INSERT INTO airports VALUES ('Austin Bergstrom Intl','AUS','TX','US','United States');

INSERT INTO airports VALUES ('Aurukun Mission','AUU','QL','AU','Australia');

INSERT INTO airports VALUES ('Wausau','AUW','WI','US','United States');

INSERT INTO airports VALUES ('Araguaina','AUX','TO','BR','Brazil');

INSERT INTO airports VALUES ('Aneityum','AUY',NULL,'VU','Vanuatu');

INSERT INTO airports VALUES ('Asheville Asheville Regional Hendersonville','AVL','NC','US','United States');

INSERT INTO airports VALUES ('Avignon Caum','AVN',NULL,'FR','France');

INSERT INTO airports VALUES ('Scranton Wilkes Barre International','AVP','PA','US','United States');

INSERT INTO airports VALUES ('Avu Avu','AVU',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Melbourne Avalon','AVV','VI','AU','Australia');

INSERT INTO airports VALUES ('Awaba','AWB',NULL,'PG','Papua New Guinea');

INSERT INTO airports VALUES ('Aniwa','AWD',NULL,'VU','Vanuatu');

INSERT INTO airports VALUES ('Ahwaz','AWZ',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Anguilla Wallblake','AXA',NULL,'AI','Anguilla');

INSERT INTO airports VALUES ('Alexandroupolis Demokritos Airport','AXD',NULL,'GR','Greece');

INSERT INTO airports VALUES ('Armenia El Eden','AXM',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Spring Point Springpoint Arpt','AXP',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Arutua','AXR',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Akita','AXT',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Axum','AXU',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Ayacucho Yanamilla','AYP',NULL,'PE','Peru');

INSERT INTO airports VALUES ('Ayers Rock Connellan','AYQ','NT','AU','Australia');

INSERT INTO airports VALUES ('Antalya','AYT',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Yazd','AZD',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Andizhan','AZN',NULL,'UZ','Uzbekistan');

INSERT INTO airports VALUES ('Kalamazoo Battle Creek Intl','AZO','MI','US','United States');

INSERT INTO airports VALUES ('Adrar','AZR',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Samana International','AZS',NULL,'DO','Dominican Republic');

INSERT INTO airports VALUES ('Baguio Loakan','BAG',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Bahrain International','BAH',NULL,'BH','Bahrain');

INSERT INTO airports VALUES ('Batman','BAL',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Barranquilla E Cortissoz','BAQ',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Balalae','BAS',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Bauru','BAU','SP','BR','Brazil');

INSERT INTO airports VALUES ('Baotou','BAV',NULL,'CN','China');

INSERT INTO airports VALUES ('Barnaul','BAX',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Baia Mare','BAY',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Balmaceda Teniente Vidal','BBA',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Bhubaneswar','BBI',NULL,'IN','India');

INSERT INTO airports VALUES ('Kasane','BBK',NULL,'BW','Botswana');

INSERT INTO airports VALUES ('Bario','BBN',NULL,'MY','Malaysia');

INSERT INTO airports VALUES ('Berbera','BBO',NULL,'SO','Somalia');

INSERT INTO airports VALUES ('Blackbush','BBS',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Bucharest Baneasa','BBU',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Baracoa','BCA',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Bacolod','BCD',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Barcaldine','BCI','QL','AU','Australia');

INSERT INTO airports VALUES ('Barra Colorado','BCL',NULL,'CR','Costa Rica');

INSERT INTO airports VALUES ('Bacau','BCM',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Barcelona','BCN',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Bermuda Bermuda International Hamilton','BDA',NULL,'BM','Bermuda');

INSERT INTO airports VALUES ('Bundaberg','BDB','QL','AU','Australia');

INSERT INTO airports VALUES ('Badu Island','BDD','QL','AU','Australia');

INSERT INTO airports VALUES ('Bandar Lengeh','BDH',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Banjarmasin Sjamsudin Noor','BDJ',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Hartford Springfield Windsor Locks Bradley International','BDL','CT','US','United States');

INSERT INTO airports VALUES ('Bandung Husein Sastranegara','BDO',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Bhadrapur','BDP',NULL,'NP','Nepal');

INSERT INTO airports VALUES ('Vadodara','BDQ',NULL,'IN','India');

INSERT INTO airports VALUES ('Bridgeport Igor I Sikorsky Mem','BDR','CT','US','United States');

INSERT INTO airports VALUES ('Brindisi Papola Casale','BDS',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Benbecula','BEB',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Belgrade Beograd','BEG',NULL,'RS','Serbia');

INSERT INTO airports VALUES ('Belem Val De Cans','BEL','PA','BR','Brazil');

INSERT INTO airports VALUES ('Benghazi Benina Intl','BEN',NULL,'LY','Libya');

INSERT INTO airports VALUES ('Bellary','BEP',NULL,'IN','India');

INSERT INTO airports VALUES ('Berlin','BER',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Brest Guipavas','BES',NULL,'FR','France');

INSERT INTO airports VALUES ('Bethel Airport','BET','AK','US','United States');

INSERT INTO airports VALUES ('Bedourie','BEU','QL','AU','Australia');

INSERT INTO airports VALUES ('Beira','BEW',NULL,'MZ','Mozambique');

INSERT INTO airports VALUES ('Beirut International','BEY',NULL,'LB','Lebanon');

INSERT INTO airports VALUES ('Bradford','BFD','PA','US','United States');

INSERT INTO airports VALUES ('Bielefeld','BFE',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Scottsbluff Scotts Bluff County','BFF','NE','US','United States');

INSERT INTO airports VALUES ('Seattle Boeing Fld Intl','BFI','WA','US','United States');

INSERT INTO airports VALUES ('Bakersfield Meadows Field','BFL','CA','US','United States');

INSERT INTO airports VALUES ('Bloemfontein Intl','BFN',NULL,'ZA','South Africa');

INSERT INTO airports VALUES ('Belfast Intl Arpt','BFS',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Buri Ram','BFV',NULL,'TH','Thailand');

INSERT INTO airports VALUES ('Bucaramanga Palo Negro','BGA',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Bangui','BGF',NULL,'CF','Central African Republic');

INSERT INTO airports VALUES ('Bridgetown Grantley Adams Intl','BGI',NULL,'BB','Barbados');

INSERT INTO airports VALUES ('Binghamton Endicott Johnson City','BGM','NY','US','United States');

INSERT INTO airports VALUES ('Bergen Flesland','BGO',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Bangor International','BGR','ME','US','United States');

INSERT INTO airports VALUES ('Baghdad Al Muthana','BGW',NULL,'IQ','Iraq');

INSERT INTO airports VALUES ('Milan Orio Al Serio','BGY',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Bar Harbor','BHB','ME','US','United States');

INSERT INTO airports VALUES ('Belfast City Airport','BHD',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Blenheim','BHE',NULL,'NZ','New Zealand');

INSERT INTO airports VALUES ('Brus Laguna','BHG',NULL,'HN','Honduras');

INSERT INTO airports VALUES ('Bisha','BHH',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Bahia Blanca Comandante','BHI','BA','AR','Argentina');

INSERT INTO airports VALUES ('Bhuj Rudra Mata','BHJ',NULL,'IN','India');

INSERT INTO airports VALUES ('Bukhara','BHK',NULL,'UZ','Uzbekistan');

INSERT INTO airports VALUES ('Birmingham','BHM','AL','US','United States');

INSERT INTO airports VALUES ('Bhopal','BHO',NULL,'IN','India');

INSERT INTO airports VALUES ('Broken Hill','BHQ','NS','AU','Australia');

INSERT INTO airports VALUES ('Bharatpur','BHR',NULL,'NP','Nepal');

INSERT INTO airports VALUES ('Bathurst Raglan','BHS','NS','AU','Australia');

INSERT INTO airports VALUES ('Bhavnagar','BHU',NULL,'IN','India');

INSERT INTO airports VALUES ('Bahawalpur','BHV',NULL,'PK','Pakistan');

INSERT INTO airports VALUES ('Birmingham','BHX',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Beihai','BHY',NULL,'CN','China');

INSERT INTO airports VALUES ('Belo Horizonte','BHZ','MG','BR','Brazil');

INSERT INTO airports VALUES ('Bastia Poretta','BIA',NULL,'FR','France');

INSERT INTO airports VALUES ('Block Island','BID','RI','US','United States');

INSERT INTO airports VALUES ('Bikini Atoll Enyu Airfield','BII',NULL,'MH','Marshall Islands');

INSERT INTO airports VALUES ('Biak Mokmer','BIK',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Billings','BIL','MT','US','United States');

INSERT INTO airports VALUES ('Bimini International','BIM',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Bilbao','BIO',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Biarritz Parme','BIQ',NULL,'FR','France');

INSERT INTO airports VALUES ('Biratnagar','BIR',NULL,'NP','Nepal');

INSERT INTO airports VALUES ('Bismarck','BIS','ND','US','United States');

INSERT INTO airports VALUES ('Bejaia','BJA',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Bojnord','BJB',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Batsfjord','BJF',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Bemidji','BJI','MN','US','United States');

INSERT INTO airports VALUES ('Banjul Yundum International','BJL',NULL,'GM','Gambia');

INSERT INTO airports VALUES ('Bujumbura International','BJM',NULL,'BI','Burundi');

INSERT INTO airports VALUES ('Bahar Dar','BJR',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Beijing','BJS',NULL,'CN','China');

INSERT INTO airports VALUES ('Bodrum Milas Airport','BJV',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Guanajuato Leon Del Bajio','BJX',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Badajoz Talaveral La Real','BJZ',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Moscow Bykovo','BKA',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Buckland','BKC','AK','US','United States');

INSERT INTO airports VALUES ('Kota Kinabalu','BKI',NULL,'MY','Malaysia');

INSERT INTO airports VALUES ('Bangkok International','BKK',NULL,'TH','Thailand');

INSERT INTO airports VALUES ('Cleveland Burke Lakefront','BKL','OH','US','United States');

INSERT INTO airports VALUES ('Bakalalan','BKM',NULL,'MY','Malaysia');

INSERT INTO airports VALUES ('Bamako','BKO',NULL,'ML','Mali');

INSERT INTO airports VALUES ('Blackall','BKQ','QL','AU','Australia');

INSERT INTO airports VALUES ('Bengkulu Padangkemiling','BKS',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Beckley','BKW','WV','US','United States');

INSERT INTO airports VALUES ('Bukavu Kamenbe','BKY',NULL,'CD','Congo (kinshasa)');

INSERT INTO airports VALUES ('Barcelona Gen J A Anzoategui','BLA',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Boulder City','BLD','NV','US','United States');

INSERT INTO airports VALUES ('Borlange Falun Dala','BLE',NULL,'SE','Sweden');

INSERT INTO airports VALUES ('Bellingham','BLI','WA','US','United States');

INSERT INTO airports VALUES ('Batna','BLJ',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Blackpool','BLK',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Billund','BLL',NULL,'DK','Denmark');

INSERT INTO airports VALUES ('Bologna Guglielmo Marconi','BLQ',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Bangalore Hindustan','BLR',NULL,'IN','India');

INSERT INTO airports VALUES ('Blackwater','BLT','QL','AU','Australia');

INSERT INTO airports VALUES ('Belleville','BLV','IL','US','United States');

INSERT INTO airports VALUES ('Blantyre Chileka','BLZ',NULL,'MW','Malawi');

INSERT INTO airports VALUES ('Stockholm Bromma','BMA',NULL,'SE','Sweden');

INSERT INTO airports VALUES ('Broome','BME','WA','AU','Australia');

INSERT INTO airports VALUES ('Bloomington Normal','BMI','IL','US','United States');

INSERT INTO airports VALUES ('Borkum','BMK',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Bhamo','BMO',NULL,'MM','Myanmar');

INSERT INTO airports VALUES ('Bima','BMU',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Banmethuot Phung Duc','BMV',NULL,'VN','Vietnam');

INSERT INTO airports VALUES ('Bordj Badji Mokhtar','BMW',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Belep Island','BMY',NULL,'NC','New Caledonia');

INSERT INTO airports VALUES ('Nashville International','BNA','TN','US','United States');

INSERT INTO airports VALUES ('Bandar Abbas','BND',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Brisbane International','BNE','QL','AU','Australia');

INSERT INTO airports VALUES ('Benin City','BNI',NULL,'NG','Nigeria');

INSERT INTO airports VALUES ('Cologne Bonn Off line Point','BNJ',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Ballina Byron Gateway','BNK','NS','AU','Australia');

INSERT INTO airports VALUES ('Bronnoysund Bronnoy','BNN',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Barinas','BNS',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Banja Luka','BNX',NULL,'BA','Bosnia And Herzegovina');

INSERT INTO airports VALUES ('Bellona','BNY',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Bora Bora Motu mute','BOB',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Bocas Del Toro','BOC',NULL,'PA','Panama');

INSERT INTO airports VALUES ('Bordeaux Airport','BOD',NULL,'FR','France');

INSERT INTO airports VALUES ('Bogota Eldorado','BOG',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Bournemouth International','BOH',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Boise Air Term Gowen Fld','BOI','ID','US','United States');

INSERT INTO airports VALUES ('Bourgas','BOJ',NULL,'BG','Bulgaria');

INSERT INTO airports VALUES ('Mumbai Chhatrapati Shivaji','BOM',NULL,'IN','India');

INSERT INTO airports VALUES ('Bonaire Flamingo International','BON',NULL,'BQ','Bes Islands');

INSERT INTO airports VALUES ('Bodo','BOO',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Boston Logan International','BOS','MA','US','United States');

INSERT INTO airports VALUES ('Bartow','BOW','FL','US','United States');

INSERT INTO airports VALUES ('Bobo Dioulasso Borgo','BOY',NULL,'BF','Burkina Faso');

INSERT INTO airports VALUES ('Balikpapan Sepingan','BPN',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Porto Seguro','BPS','BA','BR','Brazil');

INSERT INTO airports VALUES ('Beaumont Jefferson County','BPT','TX','US','United States');

INSERT INTO airports VALUES ('Bangda','BPX',NULL,'CN','China');

INSERT INTO airports VALUES ('Besalampy','BPY',NULL,'MG','Madagascar');

INSERT INTO airports VALUES ('Brunswick Glynco Jetport','BQK','GA','US','United States');

INSERT INTO airports VALUES ('Boulia','BQL','QL','AU','Australia');

INSERT INTO airports VALUES ('Aguadilla Borinquen','BQN',NULL,'PR','Puerto Rico');

INSERT INTO airports VALUES ('Blagoveschensk','BQS',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Barreiras','BRA','BA','BR','Brazil');

INSERT INTO airports VALUES ('San Carlos DeBariloche International','BRC','RN','AR','Argentina');

INSERT INTO airports VALUES ('Brainerd Crow Wing County','BRD','MN','US','United States');

INSERT INTO airports VALUES ('Bremen','BRE',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Bradford','BRF',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Bari Palese','BRI',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Bourke','BRK','NS','AU','Australia');

INSERT INTO airports VALUES ('Burlington','BRL','IA','US','United States');

INSERT INTO airports VALUES ('Barquisimeto','BRM',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Berne Belp','BRN',NULL,'CH','Switzerland');

INSERT INTO airports VALUES ('Brownsville South Padre Is Intl','BRO','TX','US','United States');

INSERT INTO airports VALUES ('Brno Turany','BRQ',NULL,'CZ','Czech Republic');

INSERT INTO airports VALUES ('Barra North Bay','BRR',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Bristol','BRS',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Brussels National','BRU',NULL,'BE','Belgium');

INSERT INTO airports VALUES ('Bremerhaven','BRV',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Barrow WRogers M Wiley Post','BRW','AK','US','United States');

INSERT INTO airports VALUES ('Bossaso','BSA',NULL,'SO','Somalia');

INSERT INTO airports VALUES ('Brasilia International','BSB','DF','BR','Brazil');

INSERT INTO airports VALUES ('Bahia Solano','BSC',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Baoshan','BSD',NULL,'CN','China');

INSERT INTO airports VALUES ('Bata','BSG',NULL,'GQ','Equatorial Guinea');

INSERT INTO airports VALUES ('Brighton','BSH',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Biskra','BSK',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Basel Mulhouse EuroAirport Swiss','BSL',NULL,'CH','Switzerland');

INSERT INTO airports VALUES ('Basco','BSO',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Basra International','BSR',NULL,'IQ','Iraq');

INSERT INTO airports VALUES ('Bassein','BSX',NULL,'MM','Myanmar');

INSERT INTO airports VALUES ('Batam Hang Nadim','BTH',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Barter Island','BTI','AK','US','United States');

INSERT INTO airports VALUES ('Banda Aceh Blang Bintang','BTJ',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Bratsk','BTK',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Battle Creek WK Kellogg Regional','BTL','MI','US','United States');

INSERT INTO airports VALUES ('Butte','BTM','MT','US','United States');

INSERT INTO airports VALUES ('Baton Rouge Ryan','BTR','LA','US','United States');

INSERT INTO airports VALUES ('Bratislava Ivanka','BTS',NULL,'SK','Slovakia');

INSERT INTO airports VALUES ('Bettles','BTT','AK','US','United States');

INSERT INTO airports VALUES ('Bintulu','BTU',NULL,'MY','Malaysia');

INSERT INTO airports VALUES ('Burlington International','BTV','VT','US','United States');

INSERT INTO airports VALUES ('Bursa Airport','BTZ',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Buka','BUA',NULL,'PG','Papua New Guinea');

INSERT INTO airports VALUES ('Burketown','BUC','QL','AU','Australia');

INSERT INTO airports VALUES ('Budapest Ferihegy','BUD',NULL,'HU','Hungary');

INSERT INTO airports VALUES ('Buenos Aires','BUE','BA','AR','Argentina');

INSERT INTO airports VALUES ('Buffalo Niagara Intl','BUF','NY','US','United States');

INSERT INTO airports VALUES ('Bucharest','BUH',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Buenaventura','BUN',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Burao','BUO',NULL,'SO','Somalia');

INSERT INTO airports VALUES ('Bulawayo','BUQ',NULL,'ZW','Zimbabwe');

INSERT INTO airports VALUES ('Hollywood Burbank Airport','BUR','CA','US','United States');

INSERT INTO airports VALUES ('Batumi','BUS',NULL,'GE','Georgia');

INSERT INTO airports VALUES ('Bunia','BUX',NULL,'CD','Congo (kinshasa)');

INSERT INTO airports VALUES ('Bushehr','BUZ',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Paris Beauvais Tille Beauvais Tille Airport','BVA',NULL,'FR','France');

INSERT INTO airports VALUES ('Boa Vista','BVB','RR','BR','Brazil');

INSERT INTO airports VALUES ('Brive La Gaillarde Laroche','BVE',NULL,'FR','France');

INSERT INTO airports VALUES ('Berlevag','BVG',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Vilhena','BVH','RO','BR','Brazil');

INSERT INTO airports VALUES ('Birdsville','BVI','QL','AU','Australia');

INSERT INTO airports VALUES ('Bhairawa','BWA',NULL,'NP','Nepal');

INSERT INTO airports VALUES ('Braunschweig','BWE',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Barrow In Furness Walney Island','BWF',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Baltimore Washington International Airport','BWI','MD','US','United States');

INSERT INTO airports VALUES ('Bol','BWK',NULL,'HR','Croatia');

INSERT INTO airports VALUES ('Bandar Seri Begawan Brunei International','BWN',NULL,'BN','Brunei');

INSERT INTO airports VALUES ('Burnie Wynyard','BWT','TS','AU','Australia');

INSERT INTO airports VALUES ('Bam','BXR',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Butuan','BXU',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Bayamo CM de Cespedes','BYM',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Bayankhongor','BYN',NULL,'MN','Mongolia');

INSERT INTO airports VALUES ('Belize City Philip SWGoldson Int','BZE',NULL,'BZ','Belize');

INSERT INTO airports VALUES ('Bydgoszcz','BZG',NULL,'PL','Poland');

INSERT INTO airports VALUES ('Briansk','BZK',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Barisal','BZL',NULL,'BD','Bangladesh');

INSERT INTO airports VALUES ('Bozeman Gallatin Field','BZN','MT','US','United States');

INSERT INTO airports VALUES ('Bolzano','BZO',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Beziers Vias','BZR',NULL,'FR','France');

INSERT INTO airports VALUES ('Brazzaville Maya Maya','BZV',NULL,'CG','Congo (brazzaville)');

INSERT INTO airports VALUES ('Brize Norton RAF Station','BZZ',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Cabinda','CAB',NULL,'AO','Angola');

INSERT INTO airports VALUES ('Cascavel','CAC','PR','BR','Brazil');

INSERT INTO airports VALUES ('Columbia Metropolitan Airport','CAE','SC','US','United States');

INSERT INTO airports VALUES ('Cagliari Elmas','CAG',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Ca Mau','CAH',NULL,'VN','Vietnam');

INSERT INTO airports VALUES ('Cairo International','CAI',NULL,'EG','Egypt');

INSERT INTO airports VALUES ('Akron Canton Regional','CAK','OH','US','United States');

INSERT INTO airports VALUES ('Campbeltown Machrihanish','CAL',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Guangzhou Baiyun','CAN',NULL,'CN','China');

INSERT INTO airports VALUES ('Cap Haitien','CAP',NULL,'HT','Haiti');

INSERT INTO airports VALUES ('Casablanca Anfa','CAS',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Carlisle','CAX',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Cayenne Rochambeau','CAY',NULL,'GF','French Guiana');

INSERT INTO airports VALUES ('Cobar','CAZ','NS','AU','Australia');

INSERT INTO airports VALUES ('Cochabamba J Wilsterman','CBB',NULL,'BO','Bolivia');

INSERT INTO airports VALUES ('Cambridge','CBG',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Bechar Leger','CBH',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Cotabato Awang','CBO',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Calabar','CBQ',NULL,'NG','Nigeria');

INSERT INTO airports VALUES ('Canberra','CBR','AC','AU','Australia');

INSERT INTO airports VALUES ('Catumbela','CBT',NULL,'AO','Angola');

INSERT INTO airports VALUES ('Cayo Coco','CCC',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Kozhikode','CCJ',NULL,'IN','India');

INSERT INTO airports VALUES ('Cocos Islands','CCK',NULL,'CC','Cocos (keeling) Islands');

INSERT INTO airports VALUES ('Criciuma','CCM','SC','BR','Brazil');

INSERT INTO airports VALUES ('Concepcion Carriel Sur','CCP',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Caracas Simon Bolivar','CCS',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Kolkata Netaji Subhas Chandra','CCU',NULL,'IN','India');

INSERT INTO airports VALUES ('Craig Cove','CCV',NULL,'VU','Vanuatu');

INSERT INTO airports VALUES ('Chub Cay','CCZ',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Cold Bay','CDB','AK','US','United States');

INSERT INTO airports VALUES ('Cedar City','CDC','UT','US','United States');

INSERT INTO airports VALUES ('Paris Ch De Gaulle','CDG',NULL,'FR','France');

INSERT INTO airports VALUES ('Chadron','CDR','NE','US','United States');

INSERT INTO airports VALUES ('Cordova Mudhole Smith','CDV','AK','US','United States');

INSERT INTO airports VALUES ('Caldwell Wright','CDW','NJ','US','United States');

INSERT INTO airports VALUES ('Cebu Mactan International','CEB',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Crescent City Mc Namara Fld','CEC','CA','US','United States');

INSERT INTO airports VALUES ('Ceduna','CED','SA','AU','Australia');

INSERT INTO airports VALUES ('Cherepovets','CEE',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Chester','CEG',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Chiang Rai','CEI',NULL,'TH','Thailand');

INSERT INTO airports VALUES ('Chelyabinsk','CEK',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Central','CEM','AK','US','United States');

INSERT INTO airports VALUES ('Ciudad Obregon','CEN',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Cortez Montezuma County','CEZ','CO','US','United States');

INSERT INTO airports VALUES ('Cacador','CFC','SC','BR','Brazil');

INSERT INTO airports VALUES ('Clermont Ferrand Aulnat','CFE',NULL,'FR','France');

INSERT INTO airports VALUES ('Cienfuegos','CFG',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Chlef','CFK',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Donegal','CFN',NULL,'IE','Ireland');

INSERT INTO airports VALUES ('Caen Carpiquet','CFR',NULL,'FR','France');

INSERT INTO airports VALUES ('Coffs Harbour','CFS','NS','AU','Australia');

INSERT INTO airports VALUES ('Kerkyra I Kapodistrias','CFU',NULL,'GR','Greece');

INSERT INTO airports VALUES ('Craig SPB','CGA','AK','US','United States');

INSERT INTO airports VALUES ('Cuiaba Marechal Rondon','CGB','MT','BR','Brazil');

INSERT INTO airports VALUES ('Changde','CGD',NULL,'CN','China');

INSERT INTO airports VALUES ('Sao Paulo Congonhas','CGH','SP','BR','Brazil');

INSERT INTO airports VALUES ('Cape Girardeau','CGI','MO','US','United States');

INSERT INTO airports VALUES ('Jakarta Soekarno Hatta Intl','CGK',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Camiguin Mambajao','CGM',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Bonn Cologne','CGN',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Zhengzhou','CGO',NULL,'CN','China');

INSERT INTO airports VALUES ('Chittagong Patenga','CGP',NULL,'BD','Bangladesh');

INSERT INTO airports VALUES ('Changchun','CGQ',NULL,'CN','China');

INSERT INTO airports VALUES ('Campo Grande Internacional','CGR','MS','BR','Brazil');

INSERT INTO airports VALUES ('Cagayan De Oro Lumbia','CGY',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Chattanooga Lovell Field','CHA','TN','US','United States');

INSERT INTO airports VALUES ('Christchurch International','CHC',NULL,'NZ','New Zealand');

INSERT INTO airports VALUES ('Charlottesville Albemarle','CHO','VA','US','United States');

INSERT INTO airports VALUES ('Chania Souda','CHQ',NULL,'GR','Greece');

INSERT INTO airports VALUES ('Charleston AFB International Airport','CHS','SC','US','United States');

INSERT INTO airports VALUES ('Chatham Island Karewa','CHT',NULL,'NZ','New Zealand');

INSERT INTO airports VALUES ('Chuathbaluk','CHU','AK','US','United States');

INSERT INTO airports VALUES ('Choiseul Bay','CHY',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Rome Ciampino','CIA',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Chico','CIC','CA','US','United States');

INSERT INTO airports VALUES ('Cedar Rapids','CID','IA','US','United States');

INSERT INTO airports VALUES ('Chifeng','CIF',NULL,'CN','China');

INSERT INTO airports VALUES ('Changzhi','CIH',NULL,'CN','China');

INSERT INTO airports VALUES ('Cobija E Beltram','CIJ',NULL,'BO','Bolivia');

INSERT INTO airports VALUES ('Chalkyitsik','CIK','AK','US','United States');

INSERT INTO airports VALUES ('Chipata','CIP',NULL,'ZM','Zambia');

INSERT INTO airports VALUES ('Shimkent','CIT',NULL,'KZ','Kazakhstan');

INSERT INTO airports VALUES ('Sault Ste Marie Chippewa County','CIU','MI','US','United States');

INSERT INTO airports VALUES ('Canouan Island','CIW',NULL,'VC','Saint Vincent And The Grenadines');

INSERT INTO airports VALUES ('Chiclayo Cornel Ruiz','CIX',NULL,'PE','Peru');

INSERT INTO airports VALUES ('Cajamarca','CJA',NULL,'PE','Peru');

INSERT INTO airports VALUES ('Coimbatore Peelamedu','CJB',NULL,'IN','India');

INSERT INTO airports VALUES ('Calama El Loa','CJC',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Cheongju','CJJ',NULL,'KR','South Korea');

INSERT INTO airports VALUES ('Chitral','CJL',NULL,'PK','Pakistan');

INSERT INTO airports VALUES ('Ciudad Juarez Intl Abraham Gonzalez','CJS',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Jeju Airport','CJU',NULL,'KR','South Korea');

INSERT INTO airports VALUES ('Clarksburg Benedum','CKB','WV','US','United States');

INSERT INTO airports VALUES ('Crooked Creek','CKD','AK','US','United States');

INSERT INTO airports VALUES ('Chongqing','CKG',NULL,'CN','China');

INSERT INTO airports VALUES ('Chokurdah','CKH',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Carajas','CKS','PA','BR','Brazil');

INSERT INTO airports VALUES ('Chicken','CKX','AK','US','United States');

INSERT INTO airports VALUES ('Conakry','CKY',NULL,'GN','Guinea');

INSERT INTO airports VALUES ('Canakkale','CKZ',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('San Diego Carlsbad','CLD','CA','US','United States');

INSERT INTO airports VALUES ('Cleveland Hopkins International','CLE','OH','US','United States');

INSERT INTO airports VALUES ('Cluj Napoca','CLJ',NULL,'RO','Romania');

INSERT INTO airports VALUES ('College Station Easterwood Field','CLL','TX','US','United States');

INSERT INTO airports VALUES ('Port Angeles Fairchild Intl','CLM','WA','US','United States');

INSERT INTO airports VALUES ('Cali Alfonso B Aragon','CLO',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Clarks Point','CLP','AK','US','United States');

INSERT INTO airports VALUES ('Colima','CLQ',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Charlotte Douglas International Airport','CLT','NC','US','United States');

INSERT INTO airports VALUES ('Clearwater Executive','CLW','FL','US','United States');

INSERT INTO airports VALUES ('Calvi Ste Catherine','CLY',NULL,'FR','France');

INSERT INTO airports VALUES ('Cunnamulla','CMA','QL','AU','Australia');

INSERT INTO airports VALUES ('Colombo Bandaranayake Intl','CMB',NULL,'LK','Sri Lanka');

INSERT INTO airports VALUES ('Ciudad Del Carmen','CME',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Chambery','CMF',NULL,'FR','France');

INSERT INTO airports VALUES ('Corumba Internacional','CMG','MS','BR','Brazil');

INSERT INTO airports VALUES ('Port Columbus Intl','CMH','OH','US','United States');

INSERT INTO airports VALUES ('Champaign Willard University','CMI','IL','US','United States');

INSERT INTO airports VALUES ('Casablanca Mohamed V','CMN',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Kundiawa Chimbu','CMU',NULL,'PG','Papua New Guinea');

INSERT INTO airports VALUES ('Camaguey Ign Agramonte Intl','CMW',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Hancock Houghton County','CMX','MI','US','United States');

INSERT INTO airports VALUES ('Coonamble','CNB','NS','AU','Australia');

INSERT INTO airports VALUES ('Coconut Island','CNC','QL','AU','Australia');

INSERT INTO airports VALUES ('Constanta Kogalniceanu','CND',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Belo Horizonte Tancredo Neves Intl','CNF','MG','BR','Brazil');

INSERT INTO airports VALUES ('Cloncurry','CNJ','QL','AU','Australia');

INSERT INTO airports VALUES ('Carlsbad','CNM','NM','US','United States');

INSERT INTO airports VALUES ('Neerlerit Inaat','CNP',NULL,'GL','Greenland');

INSERT INTO airports VALUES ('Corrientes Camba Punta','CNQ','CR','AR','Argentina');

INSERT INTO airports VALUES ('Cairns','CNS','QL','AU','Australia');

INSERT INTO airports VALUES ('Chiang Mai International','CNX',NULL,'TH','Thailand');

INSERT INTO airports VALUES ('Moab Canyonlands Field','CNY','UT','US','United States');

INSERT INTO airports VALUES ('Cody Yellowstone Yellowstone Regional','COD','WY','US','United States');

INSERT INTO airports VALUES ('Kochi','COK',NULL,'IN','India');

INSERT INTO airports VALUES ('Coll Island','COL',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Cotonou','COO',NULL,'BJ','Benin');

INSERT INTO airports VALUES ('Choibalsan','COQ',NULL,'MN','Mongolia');

INSERT INTO airports VALUES ('Cordoba Pajas Blancas','COR','CD','AR','Argentina');

INSERT INTO airports VALUES ('Colorado Springs Municipal','COS','CO','US','United States');

INSERT INTO airports VALUES ('Columbia Regional','COU','MO','US','United States');

INSERT INTO airports VALUES ('San Martin DeLos Andes Chapelco','CPC','NE','AR','Argentina');

INSERT INTO airports VALUES ('Coober Pedy','CPD','SA','AU','Australia');

INSERT INTO airports VALUES ('Campeche International','CPE',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Copenhagen Airport','CPH',NULL,'DK','Denmark');

INSERT INTO airports VALUES ('Copiapo Chamonate','CPO',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Campinas International','CPQ','SP','BR','Brazil');

INSERT INTO airports VALUES ('Casper','CPR','WY','US','United States');

INSERT INTO airports VALUES ('Cape Town International','CPT',NULL,'ZA','South Africa');

INSERT INTO airports VALUES ('Campina Grande Joao Suassuna','CPV','PB','BR','Brazil');

INSERT INTO airports VALUES ('Culebra','CPX',NULL,'PR','Puerto Rico');

INSERT INTO airports VALUES ('Shahre Kord','CQD',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Calais','CQF',NULL,'FR','France');

INSERT INTO airports VALUES ('Craiova','CRA',NULL,'RO','Romania');

INSERT INTO airports VALUES ('Comodoro Rivadavia','CRD','CB','AR','Argentina');

INSERT INTO airports VALUES ('Crooked Island','CRI',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Luzon Is Clark Field','CRK',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Charleroi Brussels So','CRL',NULL,'BE','Belgium');

INSERT INTO airports VALUES ('Catarman National','CRM',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Corpus Christi International','CRP','TX','US','United States');

INSERT INTO airports VALUES ('Charleston Yeager','CRW','WV','US','United States');

INSERT INTO airports VALUES ('Colonsay Is','CSA',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Columbus Metropolitan','CSG','GA','US','United States');

INSERT INTO airports VALUES ('Cap Skirring','CSK',NULL,'SN','Senegal');

INSERT INTO airports VALUES ('San Luis Obispo OSullivan AAF','CSL','CA','US','United States');

INSERT INTO airports VALUES ('Changsha','CSX',NULL,'CN','China');

INSERT INTO airports VALUES ('Cheboksary','CSY',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Catania Fontanarossa','CTA',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Catamarca','CTC','CA','AR','Argentina');

INSERT INTO airports VALUES ('Cartagena Rafael Nunez','CTG',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Charleville','CTL','QL','AU','Australia');

INSERT INTO airports VALUES ('Chetumal','CTM',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Cooktown','CTN','QL','AU','Australia');

INSERT INTO airports VALUES ('Sapporo Chitose','CTS',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Chengdu','CTU',NULL,'CN','China');

INSERT INTO airports VALUES ('Cucuta Camilo Dazo','CUC',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Cuenca','CUE',NULL,'EC','Ecuador');

INSERT INTO airports VALUES ('Cuneo Levaldigi','CUF',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Caye Caulker','CUK',NULL,'BZ','Belize');

INSERT INTO airports VALUES ('Culiacan Fedl De Bachigualato','CUL',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Cumana','CUM',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Cancun','CUN',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Carupano','CUP',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Coen','CUQ','QL','AU','Australia');

INSERT INTO airports VALUES ('Curacao Aeropuerto Hato','CUR',NULL,'CW','Curacao');

INSERT INTO airports VALUES ('Chihuahua Gen Fierro Villalobos','CUU',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Cuzco Velazco Astete','CUZ',NULL,'PE','Peru');

INSERT INTO airports VALUES ('Cincinnati Cinci/Nrthrn Kentucky','CVG','OH','US','United States');

INSERT INTO airports VALUES ('Ciudad Victoria','CVM',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Clovis Metropolitan Area','CVN','NM','US','United States');

INSERT INTO airports VALUES ('Carnarvon','CVQ','WA','AU','Australia');

INSERT INTO airports VALUES ('Coventry Baginton','CVT',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Corvo Island','CVU',NULL,'PT','Portugal');

INSERT INTO airports VALUES ('Wausau Central Wisconsin','CWA','WI','US','United States');

INSERT INTO airports VALUES ('Curitiba Afonso Pena','CWB','PR','BR','Brazil');

INSERT INTO airports VALUES ('Chernovtsy','CWC',NULL,'UA','Ukraine');

INSERT INTO airports VALUES ('Cardiff Wales Arpt','CWL',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Coxs Bazar','CXB',NULL,'BD','Bangladesh');

INSERT INTO airports VALUES ('Vancouver Coal Harbour','CXH','BC','CA','Canada');

INSERT INTO airports VALUES ('Christmas Island','CXI',NULL,'KI','Kiribati');

INSERT INTO airports VALUES ('Caxias Do Sul Campo Dos Bugres','CXJ','RS','BR','Brazil');

INSERT INTO airports VALUES ('Cayman Brac Is Gerrard Smith','CYB',NULL,'KY','Cayman Islands');

INSERT INTO airports VALUES ('Chefornak SPB','CYF','AK','US','United States');

INSERT INTO airports VALUES ('Chiayi','CYI',NULL,'TW','Taiwan');

INSERT INTO airports VALUES ('Cayo Largo Del Sur','CYO',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Calbayog','CYP',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Cheyenne','CYS','WY','US','United States');

INSERT INTO airports VALUES ('Cuyo','CYU',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Cherskiy','CYX',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Cauayan','CYZ',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Coro','CZE',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Corozal','CZH',NULL,'BZ','Belize');

INSERT INTO airports VALUES ('Constantine Ain El Bey','CZL',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Cozumel','CZM',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Chisana Field','CZN','AK','US','United States');

INSERT INTO airports VALUES ('Cruzeiro Do Sul Campo Internacional','CZS','AC','BR','Brazil');

INSERT INTO airports VALUES ('Corozal','CZU',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Changzhou','CZX',NULL,'CN','China');

INSERT INTO airports VALUES ('Daytona Beach International','DAB','FL','US','United States');

INSERT INTO airports VALUES ('Dhaka Zia International','DAC',NULL,'BD','Bangladesh');

INSERT INTO airports VALUES ('Da Nang','DAD',NULL,'VN','Vietnam');

INSERT INTO airports VALUES ('Dallas Love Field','DAL','TX','US','United States');

INSERT INTO airports VALUES ('Damascus International','DAM',NULL,'SY','Syrian Arab Republic');

INSERT INTO airports VALUES ('Dar Es Salaam International','DAR',NULL,'TZ','Tanzania');

INSERT INTO airports VALUES ('Datong','DAT',NULL,'CN','China');

INSERT INTO airports VALUES ('Daru','DAU',NULL,'PG','Papua New Guinea');

INSERT INTO airports VALUES ('David Enrique Malek','DAV',NULL,'PA','Panama');

INSERT INTO airports VALUES ('Daxian','DAX',NULL,'CN','China');

INSERT INTO airports VALUES ('Dayton International Airport','DAY','OH','US','United States');

INSERT INTO airports VALUES ('Dalbandin','DBA',NULL,'PK','Pakistan');

INSERT INTO airports VALUES ('Dubbo','DBO','NS','AU','Australia');

INSERT INTO airports VALUES ('Dubuque Regional Airport','DBQ','IA','US','United States');

INSERT INTO airports VALUES ('Dubrovnik','DBV',NULL,'HR','Croatia');

INSERT INTO airports VALUES ('Washington Ronald Reagan National','DCA','DC','US','United States');

INSERT INTO airports VALUES ('Dominica Cane Field','DCF',NULL,'DM','Dominica');

INSERT INTO airports VALUES ('Castres Mazamet','DCM',NULL,'FR','France');

INSERT INTO airports VALUES ('Dodge City Municipal','DDC','KS','US','United States');

INSERT INTO airports VALUES ('Dandong','DDG',NULL,'CN','China');

INSERT INTO airports VALUES ('Dera Ghazi Khan','DEA',NULL,'PK','Pakistan');

INSERT INTO airports VALUES ('Decatur Arpt','DEC','IL','US','United States');

INSERT INTO airports VALUES ('Dehra Dun','DED',NULL,'IN','India');

INSERT INTO airports VALUES ('Delhi Indira Gandhi Intl','DEL',NULL,'IN','India');

INSERT INTO airports VALUES ('Denver International','DEN','CO','US','United States');

INSERT INTO airports VALUES ('Deirezzor Al Jafrah','DEZ',NULL,'SY','Syrian Arab Republic');

INSERT INTO airports VALUES ('Dallas Fort Worth International','DFW','TX','US','United States');

INSERT INTO airports VALUES ('Dangriga','DGA',NULL,'BZ','Belize');

INSERT INTO airports VALUES ('Mudgee','DGE','NS','AU','Australia');

INSERT INTO airports VALUES ('Dongguan','DGM',NULL,'CN','China');

INSERT INTO airports VALUES ('Durango Guadalupe Victoria','DGO',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Dumaguete','DGT',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Dharamsala Gaggal Airport','DHM',NULL,'IN','India');

INSERT INTO airports VALUES ('Dothan Arpt','DHN','AL','US','United States');

INSERT INTO airports VALUES ('Dibrugarh Chabua','DIB',NULL,'IN','India');

INSERT INTO airports VALUES ('Antsiranana Arrachart','DIE',NULL,'MG','Madagascar');

INSERT INTO airports VALUES ('Diqing','DIG',NULL,'CN','China');

INSERT INTO airports VALUES ('Dickinson','DIK','ND','US','United States');

INSERT INTO airports VALUES ('Dili Comoro','DIL',NULL,'TL','East Timor');

INSERT INTO airports VALUES ('Dien Bien Phu Dien Bien','DIN',NULL,'VN','Vietnam');

INSERT INTO airports VALUES ('Dire Dawa Aba Tenna D Yilma','DIR',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Loubomo','DIS',NULL,'CG','Congo (brazzaville)');

INSERT INTO airports VALUES ('Diu','DIU',NULL,'IN','India');

INSERT INTO airports VALUES ('Diyarbakir','DIY',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Jambi Sultan Taha Syarifudn','DJB',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Djerba Melita','DJE',NULL,'TN','Tunisia');

INSERT INTO airports VALUES ('Djanet Inedbirenne','DJG',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Jayapura Sentani','DJJ',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Dakar Yoff','DKR',NULL,'SN','Senegal');

INSERT INTO airports VALUES ('Douala','DLA',NULL,'CM','Cameroon');

INSERT INTO airports VALUES ('Dalian','DLC',NULL,'CN','China');

INSERT INTO airports VALUES ('Dillingham Municipal','DLG','AK','US','United States');

INSERT INTO airports VALUES ('Duluth International','DLH','MN','US','United States');

INSERT INTO airports VALUES ('Dalat Lienkhang','DLI',NULL,'VN','Vietnam');

INSERT INTO airports VALUES ('Dalaman','DLM',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Disneyland Paris','DLP',NULL,'FR','France');

INSERT INTO airports VALUES ('Dali City Dali','DLU',NULL,'CN','China');

INSERT INTO airports VALUES ('Dillons Bay','DLY',NULL,'VU','Vanuatu');

INSERT INTO airports VALUES ('Dalanzadgad','DLZ',NULL,'MN','Mongolia');

INSERT INTO airports VALUES ('Doomadgee','DMD','QL','AU','Australia');

INSERT INTO airports VALUES ('Moscow Domodedovo','DME',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Dammam King Fahad Intl','DMM',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Dimapur','DMU',NULL,'IN','India');

INSERT INTO airports VALUES ('Dundee','DND',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Dunhuang','DNH',NULL,'CN','China');

INSERT INTO airports VALUES ('Dnepropetrovsk','DNK',NULL,'UA','Ukraine');

INSERT INTO airports VALUES ('Dinard Pleurtuit','DNR',NULL,'FR','France');

INSERT INTO airports VALUES ('Denizli Cardak','DNZ',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Dongola','DOG',NULL,'SD','Sudan');

INSERT INTO airports VALUES ('Doha','DOH',NULL,'QA','Qatar');

INSERT INTO airports VALUES ('Donetsk','DOK',NULL,'UA','Ukraine');

INSERT INTO airports VALUES ('Dominica Melville Hall','DOM',NULL,'DM','Dominica');

INSERT INTO airports VALUES ('Dolpa','DOP',NULL,'NP','Nepal');

INSERT INTO airports VALUES ('Dourados','DOU','MS','BR','Brazil');

INSERT INTO airports VALUES ('Dongying','DOY',NULL,'CN','China');

INSERT INTO airports VALUES ('Dipolog','DPL',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Devonport','DPO','TS','AU','Australia');

INSERT INTO airports VALUES ('Denpasar Bali Ngurah Rai','DPS',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Deering','DRG','AK','US','United States');

INSERT INTO airports VALUES ('Durango La Plata','DRO','CO','US','United States');

INSERT INTO airports VALUES ('Dresden Arpt','DRS',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Del Rio International','DRT','TX','US','United States');

INSERT INTO airports VALUES ('Darwin','DRW','NT','AU','Australia');

INSERT INTO airports VALUES ('Des Moines','DSM','IA','US','United States');

INSERT INTO airports VALUES ('Dongsheng','DSN',NULL,'CN','China');

INSERT INTO airports VALUES ('Dortmund','DTM',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Detroit','DTT','MI','US','United States');

INSERT INTO airports VALUES ('Detroit Metropolitan Wayne County Airport','DTW','MI','US','United States');

INSERT INTO airports VALUES ('Dublin','DUB',NULL,'IE','Ireland');

INSERT INTO airports VALUES ('Dunedin','DUD',NULL,'NZ','New Zealand');

INSERT INTO airports VALUES ('Dundo','DUE',NULL,'AO','Angola');

INSERT INTO airports VALUES ('Duisburg','DUI',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Dubois Jefferson County','DUJ','PA','US','United States');

INSERT INTO airports VALUES ('Durban International','DUR',NULL,'ZA','South Africa');

INSERT INTO airports VALUES ('Dusseldorf International','DUS',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Dutch Harbor Emergency Field','DUT','AK','US','United States');

INSERT INTO airports VALUES ('Devils Lake','DVL','ND','US','United States');

INSERT INTO airports VALUES ('Davao Mati','DVO',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Soalala','DWB',NULL,'MG','Madagascar');

INSERT INTO airports VALUES ('Dubai','DXB',NULL,'AE','United Arab Emirates');

INSERT INTO airports VALUES ('Dayong','DYG',NULL,'CN','China');

INSERT INTO airports VALUES ('Anadyr','DYR',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Dushanbe dyu','DYU',NULL,'TJ','Tajikistan');

INSERT INTO airports VALUES ('Dzaoudzi','DZA',NULL,'YT','Mayotte');

INSERT INTO airports VALUES ('Zhezkazgan Zhezhazgan','DZN',NULL,'KZ','Kazakhstan');

INSERT INTO airports VALUES ('Eagle','EAA','AK','US','United States');

INSERT INTO airports VALUES ('Emae','EAE',NULL,'VU','Vanuatu');

INSERT INTO airports VALUES ('Nejran','EAM',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Basel Basel Mulhouse Mulhouse','EAP',NULL,'CH','Switzerland');

INSERT INTO airports VALUES ('Kearney','EAR','NE','US','United States');

INSERT INTO airports VALUES ('San Sebastian','EAS',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Wenatchee Pangborn Field','EAT','WA','US','United States');

INSERT INTO airports VALUES ('Eau Claire','EAU','WI','US','United States');

INSERT INTO airports VALUES ('Elba Island Marina Di Campo','EBA',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Entebbe','EBB',NULL,'UG','Uganda');

INSERT INTO airports VALUES ('El Obeid','EBD',NULL,'SD','Sudan');

INSERT INTO airports VALUES ('Esbjerg','EBJ',NULL,'DK','Denmark');

INSERT INTO airports VALUES ('Erbil','EBL',NULL,'IQ','Iraq');

INSERT INTO airports VALUES ('Ercan','ECN',NULL,'CY','Cyprus');

INSERT INTO airports VALUES ('Northwest Florida Beaches International Airport','ECP','FL','US','United States');

INSERT INTO airports VALUES ('Edna Bay','EDA','AK','US','United States');

INSERT INTO airports VALUES ('Edinburgh','EDI',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Eldoret','EDL',NULL,'KE','Kenya');

INSERT INTO airports VALUES ('Edremit Korfez','EDO',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Edward River','EDR','QL','AU','Australia');

INSERT INTO airports VALUES ('Eek','EEK','AK','US','United States');

INSERT INTO airports VALUES ('Kefallinia Argostolion','EFL',NULL,'GR','Greece');

INSERT INTO airports VALUES ('Bergerac Roumanieres','EGC',NULL,'FR','France');

INSERT INTO airports VALUES ('Eagle Vail Eagle County','EGE','CO','US','United States');

INSERT INTO airports VALUES ('Geneina','EGN',NULL,'SD','Sudan');

INSERT INTO airports VALUES ('Belgorod','EGO',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Egilsstadir','EGS',NULL,'IS','Iceland');

INSERT INTO airports VALUES ('Eagle River','EGV','WI','US','United States');

INSERT INTO airports VALUES ('Egegik','EGX','AK','US','United States');

INSERT INTO airports VALUES ('Eisenach','EIB',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Eniseysk','EIE',NULL,'RU','Russia');

INSERT INTO airports VALUES ('Eindhoven','EIN',NULL,'NL','Netherlands');

INSERT INTO airports VALUES ('Beef Island Airport','EIS',NULL,'VG','Virgin Islands, British');

INSERT INTO airports VALUES ('Barrancabermeja Variguies','EJA',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Wedjh','EJH',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('Elko','EKO','NV','US','United States');

INSERT INTO airports VALUES ('Eskilstuna','EKT',NULL,'SE','Sweden');

INSERT INTO airports VALUES ('Elcho Island','ELC','NT','AU','Australia');

INSERT INTO airports VALUES ('El Fasher','ELF',NULL,'SD','Sudan');

INSERT INTO airports VALUES ('El Golea','ELG',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('North Eleuthera International','ELH',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Elim','ELI','AK','US','United States');

INSERT INTO airports VALUES ('Elmira Corning Regional Airport','ELM','NY','US','United States');

INSERT INTO airports VALUES ('El Paso International','ELP','TX','US','United States');

INSERT INTO airports VALUES ('Gassim','ELQ',NULL,'SA','Saudi Arabia');

INSERT INTO airports VALUES ('East London','ELS',NULL,'ZA','South Africa');

INSERT INTO airports VALUES ('El Oued Guemar','ELU',NULL,'DZ','Algeria');

INSERT INTO airports VALUES ('Elfin Cove SPB','ELV','AK','US','United States');

INSERT INTO airports VALUES ('Ely Yelland','ELY','NV','US','United States');

INSERT INTO airports VALUES ('Nottingham E Midlands','EMA',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Emerald','EMD','QL','AU','Australia');

INSERT INTO airports VALUES ('Emden','EME',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Emmonak','EMK','AK','US','United States');

INSERT INTO airports VALUES ('Kenai','ENA','AK','US','United States');

INSERT INTO airports VALUES ('Ende','ENE',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Enontekio','ENF',NULL,'FI','Finland');

INSERT INTO airports VALUES ('Enshi','ENH',NULL,'CN','China');

INSERT INTO airports VALUES ('El Nido','ENI',NULL,'PH','Philippines');

INSERT INTO airports VALUES ('Enschede Twente','ENS',NULL,'NL','Netherlands');

INSERT INTO airports VALUES ('Enugu','ENU',NULL,'NG','Nigeria');

INSERT INTO airports VALUES ('Kenosha','ENW','WI','US','United States');

INSERT INTO airports VALUES ('Yanan','ENY',NULL,'CN','China');

INSERT INTO airports VALUES ('Medellin Enrique Olaya Herrera','EOH',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Elorza','EOZ',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Esperance','EPR','WA','AU','Australia');

INSERT INTO airports VALUES ('Esquel','EQS','CB','AR','Argentina');

INSERT INTO airports VALUES ('Erzincan','ERC',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Erfurt','ERF',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Errachidia','ERH',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Erie International','ERI','PA','US','United States');

INSERT INTO airports VALUES ('Erechim Comandante Kraemer','ERM','RS','BR','Brazil');

INSERT INTO airports VALUES ('ERO','ERO','AK','US','United States');

INSERT INTO airports VALUES ('Windhoek Eros','ERS',NULL,'NA','Namibia');

INSERT INTO airports VALUES ('Erzurum','ERZ',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Ankara Esenboga','ESB',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Escanaba Delta County Arpt','ESC','MI','US','United States');

INSERT INTO airports VALUES ('Eastsound Orcas Island','ESD','WA','US','United States');

INSERT INTO airports VALUES ('Esmeraldas','ESM',NULL,'EC','Ecuador');

INSERT INTO airports VALUES ('El Salvador','ESR',NULL,'CL','Chile');

INSERT INTO airports VALUES ('Essen','ESS',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Essaouira','ESU',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Elat','ETH',NULL,'IL','Israel');

INSERT INTO airports VALUES ('Metz Nancy Metz Nancy Lorraine','ETZ',NULL,'FR','France');

INSERT INTO airports VALUES ('Eua Kaufana','EUA',NULL,'TO','Tonga');

INSERT INTO airports VALUES ('Eugene','EUG','OR','US','United States');

INSERT INTO airports VALUES ('Neumuenster','EUM',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Laayoune Hassan I','EUN',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('St Eustatius F D Roosevelt','EUX',NULL,'BQ','Bes Islands');

INSERT INTO airports VALUES ('Harstad Narvik Evenes','EVE',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Yerevan','EVN',NULL,'AM','Armenia');

INSERT INTO airports VALUES ('Evansville Dress Regional','EVV','IN','US','United States');

INSERT INTO airports VALUES ('Fall River New Bedford','EWB','MA','US','United States');

INSERT INTO airports VALUES ('New Bern Simmons Nott','EWN','NC','US','United States');

INSERT INTO airports VALUES ('Newark Liberty Intl','EWR','NJ','US','United States');

INSERT INTO airports VALUES ('Excursion Inlet SPB','EXI','AK','US','United States');

INSERT INTO airports VALUES ('Exeter','EXT',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('El Yopal','EYP',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Key West International','EYW','FL','US','United States');

INSERT INTO airports VALUES ('Buenos Aires Ministro Pistarini','EZE','BA','AR','Argentina');

INSERT INTO airports VALUES ('Elazig','EZS',NULL,'TR','Turkey');

INSERT INTO airports VALUES ('Farnborough','FAB',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Faroe Islands Vagar','FAE',NULL,'FO','Faroe Islands');

INSERT INTO airports VALUES ('Fairbanks International','FAI','AK','US','United States');

INSERT INTO airports VALUES ('Faro','FAO',NULL,'PT','Portugal');

INSERT INTO airports VALUES ('Fargo Hector Field','FAR','ND','US','United States');

INSERT INTO airports VALUES ('Fresno Airterminal','FAT','CA','US','United States');

INSERT INTO airports VALUES ('Fakarava','FAV',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Fayetteville','FAY','NC','US','United States');

INSERT INTO airports VALUES ('Lubumbashi Luano','FBM',NULL,'CD','Congo (kinshasa)');

INSERT INTO airports VALUES ('Kalispell Glacier National Park','FCA','MT','US','United States');

INSERT INTO airports VALUES ('Rome Intercontinental Airport Leonardo da Vinci','FCO',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Forde Bringeland','FDE',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Fort De France Lamentin','FDF',NULL,'MQ','Martinique');

INSERT INTO airports VALUES ('Friedrichshafen','FDH',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Fergana','FEG',NULL,'UZ','Uzbekistan');

INSERT INTO airports VALUES ('Fernando De Noronha','FEN','FN','BR','Brazil');

INSERT INTO airports VALUES ('Fez Sais','FEZ',NULL,'MA','Morocco');

INSERT INTO airports VALUES ('Fangatau','FGU',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Fakahina','FHZ',NULL,'PF','French Polynesia');

INSERT INTO airports VALUES ('Kinshasa NDjili','FIH',NULL,'CD','Congo (kinshasa)');

INSERT INTO airports VALUES ('Al Fujairah Fujairah Intl Arpt','FJR',NULL,'AE','United Arab Emirates');

INSERT INTO airports VALUES ('Baden Baden Karlsruhe Soellingen','FKB',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Kisangani','FKI',NULL,'CD','Congo (kinshasa)');

INSERT INTO airports VALUES ('Franklin Chess Lambertin','FKL','PA','US','United States');

INSERT INTO airports VALUES ('Fak Fak','FKQ',NULL,'ID','Indonesia');

INSERT INTO airports VALUES ('Fukushima Airport','FKS',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Florencia Capitolio','FLA',NULL,'CO','Colombia');

INSERT INTO airports VALUES ('Flagstaff Pulliam Field','FLG','AZ','US','United States');

INSERT INTO airports VALUES ('Fort Lauderdale International','FLL','FL','US','United States');

INSERT INTO airports VALUES ('Florianopolis Hercilio Luz','FLN','SC','BR','Brazil');

INSERT INTO airports VALUES ('Florence','FLO','SC','US','United States');

INSERT INTO airports VALUES ('Florence Peretola','FLR',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Flores Island Santa Cruz','FLW',NULL,'PT','Portugal');

INSERT INTO airports VALUES ('Formosa El Pucu','FMA','FO','AR','Argentina');

INSERT INTO airports VALUES ('Farmington Municipal','FMN','NM','US','United States');

INSERT INTO airports VALUES ('Muenster','FMO',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Freetown Lungi International','FNA',NULL,'SL','Sierra Leone');

INSERT INTO airports VALUES ('Madeira','FNC',NULL,'PT','Portugal');

INSERT INTO airports VALUES ('Nimes Garons','FNI',NULL,'FR','France');

INSERT INTO airports VALUES ('Pyongyang Sunan','FNJ',NULL,'KP','North Korea');

INSERT INTO airports VALUES ('Fort Collins Loveland Municipal Airport','FNL','CO','US','United States');

INSERT INTO airports VALUES ('Flint Bishop','FNT','MI','US','United States');

INSERT INTO airports VALUES ('Fuzhou','FOC',NULL,'CN','China');

INSERT INTO airports VALUES ('Fort Dodge','FOD','IA','US','United States');

INSERT INTO airports VALUES ('Foggia Gino Lisa','FOG',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Fortaleza Pinto Martins','FOR','CE','BR','Brazil');

INSERT INTO airports VALUES ('Freeport Grand Bahama Intl','FPO',NULL,'BS','Bahamas');

INSERT INTO airports VALUES ('Frankfurt International','FRA',NULL,'DE','Germany');

INSERT INTO airports VALUES ('Franca','FRC','SP','BR','Brazil');

INSERT INTO airports VALUES ('Friday Harbor','FRD','WA','US','United States');

INSERT INTO airports VALUES ('Fera Island','FRE',NULL,'SB','Solomon Islands');

INSERT INTO airports VALUES ('Forli Luigi Ridolfi','FRL',NULL,'IT','Italy');

INSERT INTO airports VALUES ('Floro Flora','FRO',NULL,'NO','Norway');

INSERT INTO airports VALUES ('Flores Santa Elena','FRS',NULL,'GT','Guatemala');

INSERT INTO airports VALUES ('Bishkek','FRU',NULL,'KG','Kyrgyzstan');

INSERT INTO airports VALUES ('Francistown','FRW',NULL,'BW','Botswana');

INSERT INTO airports VALUES ('Figari Sud Corse','FSC',NULL,'FR','France');

INSERT INTO airports VALUES ('Sioux Falls RegionalJo Foss Fld','FSD','SD','US','United States');

INSERT INTO airports VALUES ('Fort Smith Regional Airport','FSM','AR','US','United States');

INSERT INTO airports VALUES ('St Pierre','FSP',NULL,'PM','Saint Pierre And Miquelon');

INSERT INTO airports VALUES ('Futuna Island Futuna Airport','FTA',NULL,'VU','Vanuatu');

INSERT INTO airports VALUES ('El Calafate','FTE','SC','AR','Argentina');

INSERT INTO airports VALUES ('Fort Dauphin Marillac','FTU',NULL,'MG','Madagascar');

INSERT INTO airports VALUES ('Fuerteventura Puerto del Rosario','FUE',NULL,'ES','Spain');

INSERT INTO airports VALUES ('Fuyang','FUG',NULL,'CN','China');

INSERT INTO airports VALUES ('Fukue','FUJ',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Fukuoka','FUK',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Funafuti Atol International','FUN',NULL,'TV','Tuvalu');

INSERT INTO airports VALUES ('Futuna Island','FUT',NULL,'WF','Wallis And Futuna');

INSERT INTO airports VALUES ('Fort Wayne International Airport','FWA','IN','US','United States');

INSERT INTO airports VALUES ('Fort William Heliport','FWM',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Fort Yukon','FYU','AK','US','United States');

INSERT INTO airports VALUES ('Fayetteville Municipal Drake Fld','FYV','AR','US','United States');

INSERT INTO airports VALUES ('Filton','FZO',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Gabes','GAE',NULL,'TN','Tunisia');

INSERT INTO airports VALUES ('Gafsa','GAF',NULL,'TN','Tunisia');

INSERT INTO airports VALUES ('Yamagata Junmachi','GAJ',NULL,'JP','Japan');

INSERT INTO airports VALUES ('Galena','GAL','AK','US','United States');

INSERT INTO airports VALUES ('Gambell','GAM','AK','US','United States');

INSERT INTO airports VALUES ('Gan Island Gan Seenu','GAN',NULL,'MV','Maldives');

INSERT INTO airports VALUES ('Guantanamo Los Canos','GAO',NULL,'CU','Cuba');

INSERT INTO airports VALUES ('Gawahati Borjhar','GAU',NULL,'IN','India');

INSERT INTO airports VALUES ('Gamba','GAX',NULL,'GA','Gabon');

INSERT INTO airports VALUES ('Gaya','GAY',NULL,'IN','India');

INSERT INTO airports VALUES ('Great Bend','GBD','KS','US','United States');

INSERT INTO airports VALUES ('Gaborone Sir Seretse Khama Int','GBE',NULL,'BW','Botswana');

INSERT INTO airports VALUES ('Marie Galante Les Bases','GBJ',NULL,'GP','Guadeloupe');

INSERT INTO airports VALUES ('Gorgan','GBT',NULL,'IR','Iran');

INSERT INTO airports VALUES ('Gillette Campbell County','GCC','WY','US','United States');

INSERT INTO airports VALUES ('Guernsey','GCI',NULL,'GB','United Kingdom');

INSERT INTO airports VALUES ('Garden City Municipal Airport','GCK','KS','US','United States');

INSERT INTO airports VALUES ('Grand Cayman Island Owen Roberts Intl','GCM',NULL,'KY','Cayman Islands');

INSERT INTO airports VALUES ('Gode Iddidole','GDE',NULL,'ET','Ethiopia');

INSERT INTO airports VALUES ('Guadalajara Miguel Hidalgo','GDL',NULL,'MX','Mexico');

INSERT INTO airports VALUES ('Gdansk Rebiechowo','GDN',NULL,'PL','Poland');

INSERT INTO airports VALUES ('Guasdualito Vare Maria','GDO',NULL,'VE','Venezuela');

INSERT INTO airports VALUES ('Gondar','GDQ',NULL,'ET','Ethiopia');