INSERT INTO airport VALUES ('HEA','Herat','AFG','Herat','Afghanistan',NULL,34.210017,62.2283,977,5);
 INSERT INTO airport VALUES ('KBL','Kabul Intl','AFG','Kabul','Afghanistan',NULL,34.565853,69.212328,1792,5);
 INSERT INTO airport VALUES ('TIA','Tirana Rinas','AL','Tirana','Albania',NULL,41.414742,19.720561,38,1);
 INSERT INTO airport VALUES ('TEE','Cheikh Larbi Tebessi','DZ','Tébessa','Algeria',NULL,35.431611,8.120717,811,1);
 INSERT INTO airport VALUES ('BLJ','Batna Airport','DZ','Batna','Algeria',NULL,35.752106,6.308589,822,1);
 INSERT INTO airport VALUES ('BJA','Soummam','DZ','Bejaïa','Algeria',NULL,36.711997,5.069922,6,1);
 INSERT INTO airport VALUES ('TMR','Tamanrasset','DZ','Tamanrasset','Algeria',NULL,22.811461,5.451075,1377,1);
 INSERT INTO airport VALUES ('BSK','Biskra','DZ','Biskra','Algeria',NULL,34.793289,5.738231,88,1);
 INSERT INTO airport VALUES ('CZL','Mohamed Boudiaf Intl','DZ','Constantine','Algeria',NULL,36.276028,6.620386,691,1);
 INSERT INTO airport VALUES ('QSF','Ain Arnat Airport','DZ','Sétif','Algeria',NULL,36.1781,5.32449,1024,1);
 INSERT INTO airport VALUES ('ORN','Es Senia','DZ','Oran','Algeria',NULL,35.623858,-0.621183,90,1);
 INSERT INTO airport VALUES ('GHA','Noumerat','DZ','Ghardaïa','Algeria',NULL,32.384106,3.794114,461,1);
 INSERT INTO airport VALUES ('AAE','Annaba','DZ','Annaba','Algeria',NULL,36.822225,7.809167,5,1);
 INSERT INTO airport VALUES ('ALG','Houari Boumediene','DZ','Algiers','Algeria',NULL,36.691014,3.215408,25,1);
 INSERT INTO airport VALUES ('TLM','Zenata','DZ','Tlemcen','Algeria',NULL,35.016667,-1.45,248,1);
 INSERT INTO airport VALUES ('PPG','Pago Pago Intl','AMSA','Pago Pago','American Samoa','Tutuila',-14.2794,-170.7006,10,-11);
 INSERT INTO airport VALUES ('VPE','Ondjiva Pereira Airport','ANG','Ngiva','Cunene',NULL,-17.043464,15.683822,1087,1);
 INSERT INTO airport VALUES ('SDD','Lubango','ANG','Lubango','Huíla',NULL,-14.924733,13.575022,1762,1);
 INSERT INTO airport VALUES ('CAB','Cabinda','ANG','Cabinda','Cabinda',NULL,-5.596992,12.188353,20,1);
 INSERT INTO airport VALUES ('SPP','Menongue','ANG','Menongue','Cuando Cubango',NULL,-14.657583,17.719833,1363,1);
 INSERT INTO airport VALUES ('LAD','Luanda 4 De Fevereiro','ANG','Luanda','Luanda',NULL,-8.858375,13.231178,74,1);
 INSERT INTO airport VALUES ('NOV','Huambo','ANG','Huambo','Huambo',NULL,-12.808878,15.760547,1703,1);
 INSERT INTO airport VALUES ('AXA','Wallblake','AXA','The Valley','Anguilla','Anguilla',18.204834,-63.055084,39,-4);
 INSERT INTO airport VALUES ('ANU','V C Bird Intl','AG','Saint Johns','Antigua and Barbuda','Antigua',17.136749,-61.792667,19,-4);
 INSERT INTO airport VALUES ('IRJ','La Rioja','RA','La Rioja','La Rioja',NULL,-29.381636,-66.795839,438,-3);
 INSERT INTO airport VALUES ('JUJ','Jujuy','RA','San Salvador de Jujuy','Jujuy',NULL,-24.392778,-65.097778,920,-3);
 INSERT INTO airport VALUES ('BHI','Comandante Espora','RA','Bahía Blanca','Buenos Aires',NULL,-38.724967,-62.169317,75,-3);
 INSERT INTO airport VALUES ('TUC','Teniente Benjamin Matienzo','RA','San Miguel de Tucumán','Tucumán',NULL,-26.840861,-65.104944,456,-3);
 INSERT INTO airport VALUES ('LUQ','San Luis','RA','San Luis','San Luis',NULL,-33.273192,-66.356422,710,-3);
 INSERT INTO airport VALUES ('SDE','Santiago del Estero','RA','Santiago del Estero','Santiago de Estero',NULL,-27.765617,-64.310122,200,-3);
 INSERT INTO airport VALUES ('SFN','Sauce Viejo','RA','Santa Fe','Santa Fe',NULL,-31.711666,-60.811668,17,-3);
 INSERT INTO airport VALUES ('CNQ','Corrientes','RA','Corrientes','Corrientes',NULL,-27.445503,-58.761864,62,-3);
 INSERT INTO airport VALUES ('NQN','Presidente Peron','RA','Neuquén','Neuquén',NULL,-38.949,-68.155711,273,-3);
 INSERT INTO airport VALUES ('SLA','Salta','RA','Salta','Salta',NULL,-24.855978,-65.486169,1246,-3);
 INSERT INTO airport VALUES ('AEP','Aeroparque Jorge Newbery','RA','Buenos Aires','Distrito Federal',NULL,-34.559175,-58.415606,5,-3);
 INSERT INTO airport VALUES ('EZE','Ministro Pistarini','RA','Buenos Aires','Distrito Federal',NULL,-34.822222,-58.535833,20,-3);
 INSERT INTO airport VALUES ('USH','Ushuaia Malvinas Argentinas','RA','Ushuaia','Tierra del Fuego',NULL,-54.843278,-68.29575,22,-3);
 INSERT INTO airport VALUES ('FMA','Formosa','RA','Formosa','Formosa',NULL,-26.212722,-58.228111,59,-3);
 INSERT INTO airport VALUES ('PSS','Posadas','RA','Posadas','Misiones',NULL,-27.385839,-55.970728,131,-3);
 INSERT INTO airport VALUES ('ROS','Rosario','RA','Rosario','Santa Fe',NULL,-32.903611,-60.785,26,-3);
 INSERT INTO airport VALUES ('RES','Resistencia','RA','Resistencia','Chaco',NULL,-27.449986,-59.056125,53,-3);
 INSERT INTO airport VALUES ('RGL','Rio Gallegos','RA','Río Gallegos','Santa Cruz',NULL,-51.608875,-69.312636,19,-3);
 INSERT INTO airport VALUES ('CRD','Comodoro Rivadavia','RA','Comodoro Rivadavia','Chubut',NULL,-45.785347,-67.465508,58,-3);
 INSERT INTO airport VALUES ('MDQ','Mar Del Plata','RA','Mar del Plata','Buenos Aires',NULL,-37.934167,-57.573333,22,-3);
 INSERT INTO airport VALUES ('MDZ','El Plumerillo','RA','Mendoza','Mendoza',NULL,-32.831717,-68.792856,704,-3);
 INSERT INTO airport VALUES ('COR','Ambrosio L V Taravella','RA','Córdoba','Córdoba',NULL,-31.323619,-64.207953,489,-3);
 INSERT INTO airport VALUES ('EVN','Zvartnots','ARM','Yerevan','Armenia',NULL,40.147275,44.395881,865,4);
 INSERT INTO airport VALUES ('AUA','Reina Beatrix Intl','ARU','Oranjestad','Aruba','Aruba',12.501389,-70.015221,18,-4);
 INSERT INTO airport VALUES ('MEL','Melbourne Intl','AUS','Melbourne','Victoria',NULL,-37.673333,144.843333,132,10);
 INSERT INTO airport VALUES ('SYD','Sydney Intl','AUS','Sydney','New South Wales',NULL,-33.946111,151.177222,6,10);
 INSERT INTO airport VALUES ('CNS','Cairns Intl','AUS','Cairns','Queensland',NULL,-16.885833,145.755278,3,10);
 INSERT INTO airport VALUES ('TSV','Townsville','AUS','Townsville','Queensland',NULL,-19.2525,146.765278,5,10);
 INSERT INTO airport VALUES ('BNE','Brisbane Intl','AUS','Brisbane','Queensland',NULL,-27.384167,153.1175,4,10);
 INSERT INTO airport VALUES ('CBR','Canberra','AUS','Canberra','Australia Capital Territory',NULL,-35.306944,149.195,575,10);
 INSERT INTO airport VALUES ('ADL','Adelaide Intl','AUS','Adelaide','South Australia',NULL,-34.945,138.530556,6,9.5);
 INSERT INTO airport VALUES ('NTL','Newcastle Airport','AUS','Newcastle','New South Wales',NULL,-32.78,151.83,9,10);
 INSERT INTO airport VALUES ('DRW','Darwin Intl','AUS','Darwin','Northern Territory',NULL,-12.4083333,130.87266,31,9.5);
 INSERT INTO airport VALUES ('PER','Perth Intl','AUS','Perth','Western Australia',NULL,-31.940278,115.966944,20,8);
 INSERT INTO airport VALUES ('HBA','Hobart','AUS','Hobart','Tasmania','Tasmania',-42.836111,147.510278,4,10);
 INSERT INTO airport VALUES ('SZG','Salzburg','A','Salzburg','Salzburg',NULL,47.793304,13.004333,430,1);
 INSERT INTO airport VALUES ('LNZ','Linz','A','Linz','Oberösterreich',NULL,48.233219,14.187511,298,1);
 INSERT INTO airport VALUES ('INN','Innsbruck','A','Innsbruck','Tirol',NULL,47.260219,11.343964,581,1);
 INSERT INTO airport VALUES ('VIE','Schwechat','A','Wien','Wien',NULL,48.110278,16.569722,183,1);
 INSERT INTO airport VALUES ('GRZ','Graz','A','Graz','Steiermark',NULL,46.991067,15.439628,340,1);
 INSERT INTO airport VALUES ('KLU','Woerthersee International Airport','A','Klagenfurt','Kärnten',NULL,46.642514,14.337739,138,1);
 INSERT INTO airport VALUES ('GYD','Heydar Aliyev','AZ','Baku','Azerbaijan',NULL,40.4675,50.046667,3,4);
 INSERT INTO airport VALUES ('NAS','Lynden Pindling Intl','BS','Nassau','Bahamas','New Providence',25.038958,-77.466231,5,-5);
 INSERT INTO airport VALUES ('BAH','Bahrain Intl','BRN','Al Manāmah','Bahrain','Bahrain',26.270834,50.63361,2,3);
 INSERT INTO airport VALUES ('DAC','Zia Intl','BD','Dhaka','Dhaka',NULL,23.843333,90.397781,9,6);
 INSERT INTO airport VALUES ('CGP','Shah Amanat Intl','BD','Chittagong','Chittagong',NULL,22.249611,91.813286,4,6);
 INSERT INTO airport VALUES ('BGI','Grantley Adams Intl','BDS','Bridgetown','Barbados','Barbados',13.074603,-59.492456,52,-4);
 INSERT INTO airport VALUES ('MSQ','Minsk National','BY','Minsk','Minsk City',NULL,53.882469,28.030731,204,3);
 INSERT INTO airport VALUES ('ANR','Deurne','B','Antwerpen','Antwerpen',NULL,51.189444,4.460278,12,1);
 INSERT INTO airport VALUES ('CRL','Brussels South','B','Charleroi','Hainaut',NULL,50.459197,4.453817,187,1);
 INSERT INTO airport VALUES ('LGG','Aéroport de Liège','B','Liège','Liège',NULL,50.6375,5.4433,201,1);
 INSERT INTO airport VALUES ('BRU','Brussels Natl','B','Bruxelles','Bruxelles',NULL,50.901389,4.484444,56,1);
 INSERT INTO airport VALUES ('BZE','Philip S W Goldson Intl','BZ','Belize City','Belize',NULL,17.539144,-88.308203,5,-6);
 INSERT INTO airport VALUES ('COO','Cadjehoun','BEN','Cotonou','Benin',NULL,6.357228,2.384353,6,1);
 INSERT INTO airport VALUES ('BDA','Bermuda Intl','BERM','Hamilton','Bermuda','Grand Bermuda',32.364042,-64.678703,4,-4);
 INSERT INTO airport VALUES ('PBH','Paro','BHT','Thimphu','Bhutan',NULL,27.403192,89.424606,2235,6);
 INSERT INTO airport VALUES ('CIJ','Heroes Del Acre','BOL','Cobija','Pando',NULL,-11.040436,-68.782972,272,-4);
 INSERT INTO airport VALUES ('LPB','El Alto Intl','BOL','La Paz','La Paz',NULL,-16.513339,-68.192256,4063,-4);
 INSERT INTO airport VALUES ('VVI','Viru Viru Intl','BOL','Santa Cruz de la Sierra','Santa Cruz',NULL,-17.644756,-63.135364,373,-4);
 INSERT INTO airport VALUES ('SRE','Juana Azurduy De Padilla','BOL','Sucre','Chuquisaca',NULL,-19.007083,-65.288747,2905,-4);
 INSERT INTO airport VALUES ('TDD','Tte Av Jorge Henrich Arauz','BOL','Trinidad','Beni',NULL,-14.818739,-64.918019,155,-4);
 INSERT INTO airport VALUES ('TJA','Capitan Oriel Lea Plaza','BOL','Tarija','Tarija',NULL,-21.555736,-64.701325,1855,-4);
 INSERT INTO airport VALUES ('CBB','Jorge Wilsterman','BOL','Cochabamba','Cochabamba',NULL,-17.421058,-66.177114,2549,-4);
 INSERT INTO airport VALUES ('SJJ','Sarajevo','BIH','Sarajevo','Federacija Bosne i Hercegovine',NULL,43.824583,18.331467,521,1);
 INSERT INTO airport VALUES ('GBE','Sir Seretse Khama Intl','RB','Gaborone','Botswana',NULL,-24.555225,25.918208,1006,2);
 INSERT INTO airport VALUES ('REC','Guararapes Gilberto Freyre Intl','BR','Recife','Pernambuco',NULL,-8.126794,-34.923039,10,-3);
 INSERT INTO airport VALUES ('BSB','Presidente Juscelino Kubitschek','BR','Brasília','Distrito Federal',NULL,-15.8711,-47.918625,1061,-3);
 INSERT INTO airport VALUES ('BVB','Boa Vista','BR','Boa Vista','Roraima',NULL,2.846311,-60.690069,84,-4);
 INSERT INTO airport VALUES ('RBR','Rio Branco','BR','Rio Branco','Acre',NULL,-9.87,-67.89,193,-5);
 INSERT INTO airport VALUES ('UDI','Ten Cel Av Cesar Bombonato','BR','Uberlândia','Minas Gerais',NULL,-18.882844,-48.225594,943,-3);
 INSERT INTO airport VALUES ('MCZ','Zumbi Dos Palmares','BR','Maceió','Alagoas',NULL,-9.510808,-35.791678,118,-3);
 INSERT INTO airport VALUES ('MCP','Macapa','BR','Macapá','Amapá',NULL,.050664,-51.072178,17,-3);
 INSERT INTO airport VALUES ('MAO','Eduardo Gomes Intl','BR','Manaus','Amazonas',NULL,-3.038611,-60.049721,80,-4);
 INSERT INTO airport VALUES ('VIX','Goiabeiras','BR','Vitória','Espírito Santo',NULL,-20.258056,-40.286389,3,-3);
 INSERT INTO airport VALUES ('CWB','Afonso Pena','BR','Curitiba','Paraná',NULL,-25.528475,-49.175775,911,-3);
 INSERT INTO airport VALUES ('STM','Santarem','BR','Santarém','Pará',NULL,-2.422431,-54.792789,60,-3);
 INSERT INTO airport VALUES ('LDB','Londrina','BR','Londrina','Paraná',NULL,-23.333625,-51.130072,569,-3);
 INSERT INTO airport VALUES ('CGB','Marechal Rondon','BR','Cuiabá','Mato Grosso',NULL,-15.652931,-56.116719,188,-4);
 INSERT INTO airport VALUES ('CGR','Campo Grande','BR','Campo Grande','Mato Grosso do Sul',NULL,-20.468667,-54.6725,559,-4);
 INSERT INTO airport VALUES ('CGH','Congonhas','BR','São Paulo','São Paulo',NULL,-23.626692,-46.655375,802,-3);
 INSERT INTO airport VALUES ('SDU','Santos Dumont','BR','Rio de Janeiro','Rio de Janeiro',NULL,-22.910461,-43.163133,3,-3);
 INSERT INTO airport VALUES ('SSA','Deputado Luis Eduardo Magalhaes','BR','Salvador','Bahia',NULL,-12.910994,-38.331044,20,-3);
 INSERT INTO airport VALUES ('CNF','Tancredo Neves Intl','BR','Belo Horizonte','Minas Gerais',NULL,-19.63375,-43.968856,828,-3);
 INSERT INTO airport VALUES ('SLZ','Marechal Cunha Machado Intl','BR','São Luís','Maranhão',NULL,-2.585361,-44.234139,54,-3);
 INSERT INTO airport VALUES ('CPQ','Amarais Airport','BR','Campinas','São Paulo',NULL,-22.8592,-47.1082,612,-3);
 INSERT INTO airport VALUES ('VCP','Viracopos','BR','Campinas','São Paulo',NULL,-23.0075,-47.134444,662,-3);
 INSERT INTO airport VALUES ('AJU','Santa Maria','BR','Aracaju','Sergipe',NULL,-10.984,-37.070333,7,-3);
 INSERT INTO airport VALUES ('UBA','Uberaba','BR','Uberaba','Minas Gerais',NULL,-19.765,-47.964778,809,-3);
 INSERT INTO airport VALUES ('BEL','Val De Cans Intl','BR','Belém','Pará',NULL,-1.37925,-48.476292,16,-3);
 INSERT INTO airport VALUES ('THE','Senador Petronio Portella','BR','Teresina','Piauí',NULL,-5.059942,-42.823478,67,-3);
 INSERT INTO airport VALUES ('NAT','Augusto Severo','BR','Natal','Rio Grande do Norte',NULL,-5.911417,-35.247717,52,-3);
 INSERT INTO airport VALUES ('PET','Pelotas','BR','Pelotas','Rio Grande do Sul',NULL,-31.718353,-52.327689,18,-3);
 INSERT INTO airport VALUES ('RAO','Leite Lopes','BR','Ribeirão Preto','São Paulo',NULL,-21.134167,-47.774189,549,-3);
 INSERT INTO airport VALUES ('RVD','General Leite de Castro Airport','BR','Rio Verde','Goiás',NULL,-17.790278,-50.918333,684,-3);
 INSERT INTO airport VALUES ('GVR','Governador Valadares Airport','BR','Governador Valadares','Minas Gerais',NULL,-18.8952,-41.9822,171,-3);
 INSERT INTO airport VALUES ('IPN','Usiminas','BR','Ipatinga','Minas Gerais',NULL,-19.470722,-42.487583,239,-3);
 INSERT INTO airport VALUES ('CXJ','Campo Dos Bugres','BR','Caxias do Sul','Rio Grande do Sul',NULL,-29.197064,-51.187536,754,-3);
 INSERT INTO airport VALUES ('GIG','Galeao Antonio Carlos Jobim','BR','Rio de Janeiro','Rio de Janeiro',NULL,-22.808903,-43.243647,9,-3);
 INSERT INTO airport VALUES ('FOR','Pinto Martins Intl','BR','Fortaleza','Ceará',NULL,-3.776283,-38.532556,25,-3);
 INSERT INTO airport VALUES ('PLU','Pampulha Carlos Drummond De Andrade','BR','Belo Horizonte','Minas Gerais',NULL,-19.851181,-43.950628,789,-3);
 INSERT INTO airport VALUES ('PVH','Governador Jorge Teixeira De Oliveira','BR','Porto Velho','Rondônia',NULL,-8.709294,-63.902281,90,-4);
 INSERT INTO airport VALUES ('GYN','Santa Genoveva','BR','Goiânia','Goiás',NULL,-16.632033,-49.220686,747,-3);
 INSERT INTO airport VALUES ('POA','Salgado Filho','BR','Porto Alegre','Rio Grande do Sul',NULL,-29.994428,-51.171428,3,-3);
 INSERT INTO airport VALUES ('GRU','Guarulhos Gov Andre Franco Montouro','BR','São Paulo','São Paulo',NULL,-23.432075,-46.469511,750,-3);
 INSERT INTO airport VALUES ('IMP','Prefeito Renato Moreira','BR','Imperatriz','Maranhão',NULL,-5.531292,-47.46005,131,-3);
 INSERT INTO airport VALUES ('IOS','Ilheus','BR','Ilhéus','Bahia',NULL,-14.815964,-39.033197,5,-3);
 INSERT INTO airport VALUES ('EIS','Terrance B Lettsome Intl','BVIR','Road Town','British Virgin Islands','Tortola',18.444834,-64.542975,5,-4);
 INSERT INTO airport VALUES ('BWN','Brunei Intl','BRU','Bandar Seri Begawan','Brunei','Borneo',4.9442,114.928353,22,8);
 INSERT INTO airport VALUES ('BOJ','Burgas','BG','Burgas','Bulgaria',NULL,42.569583,27.515236,41,2);
 INSERT INTO airport VALUES ('VAR','Varna','BG','Varna','Bulgaria',NULL,43.232072,27.825106,70,2);
 INSERT INTO airport VALUES ('PDV','Plovdiv','BG','Plovdiv','Bulgaria',NULL,42.067806,24.850833,182,2);
 INSERT INTO airport VALUES ('SOF','Sofia','BG','Sofia','Bulgaria',NULL,42.695194,23.406167,531,2);
 INSERT INTO airport VALUES ('BOY','Bobo Dioulasso','BF','Bobo Dioulasso','Burkina Faso',NULL,11.160056,-4.330969,461,0);
 INSERT INTO airport VALUES ('OUA','Ouagadougou','BF','Ouagadougou','Burkina Faso',NULL, 12.353194,-1.512417,316,0);
 INSERT INTO airport VALUES ('MDL','Mandalay Intl','MYA','Mandalay','Mandalay',NULL,21.702156,95.977928,91,6.5);
 INSERT INTO airport VALUES ('RGN','Yangon Intl','MYA','Yangon','Yangon',NULL,16.907305,96.133222,33,6.5);
 INSERT INTO airport VALUES ('BJM','Bujumbura Intl','BI','Bujumbura','Burundi',NULL,-3.324019,29.318519,787,2);
 INSERT INTO airport VALUES ('PNH','Phnom Penh Intl','K','Phnom Penh','Cambodia',NULL,11.546556,104.844139,12,7);
 INSERT INTO airport VALUES ('DLA','Douala','CAM','Douala','Littoral',NULL,4.006081,9.719481,10,1);
 INSERT INTO airport VALUES ('NSI','Yaounde Nsimalen','CAM','Yaoundé','Centre',NULL,3.722556,11.553269,695,1);
 INSERT INTO airport VALUES ('YQX','Gander Intl','CDN','Gander','Newfoundland and Labrador','Newfoundland',48.936944,-54.568056,151,-4);
 INSERT INTO airport VALUES ('YXY','Whitehorse Intl','CDN','Whitehorse','Yukon',NULL,60.709553,-135.067269,706,-8);
 INSERT INTO airport VALUES ('YFB','Iqaluit','CDN','Iqaluit','Nunavut','Baffin Island',63.75639,-68.555832,34,-5);
 INSERT INTO airport VALUES ('YYT','St Johns Intl','CDN','St. John''s','Newfoundland and Labrador','Newfoundland',47.61861,-52.751945,141,-3.5);
 INSERT INTO airport VALUES ('YYZ','Lester B Pearson Intl','CDN','Toronto','Ontario',NULL,43.677223,-79.630556,173,-5);
 INSERT INTO airport VALUES ('YYC','Calgary Intl','CDN','Calgary','Alberta',NULL,51.113888,-114.020278,1084,-7);
 INSERT INTO airport VALUES ('YYJ','Victoria Intl','CDN','Victoria','British Columbia','Vancouver Island',48.646944,-123.425833,19,-8);
 INSERT INTO airport VALUES ('YXU','London','CDN','London','Ontario',NULL,43.033056,-81.151111,278,-5);
 INSERT INTO airport VALUES ('YXE','Saskatoon J G Diefenbaker Intl','CDN','Saskatoon','Saskatchewan',NULL,52.170834,-106.699722,504,-6);
 INSERT INTO airport VALUES ('YZF','Yellowknife','CDN','Yellowknife','Northwest Territories',NULL,62.462778,-114.440278,206,-7);
 INSERT INTO airport VALUES ('YQB','Quebec Jean Lesage Intl','CDN','Quebec','Quebec',NULL,46.791111,-71.393333,74,-5);
 INSERT INTO airport VALUES ('YQT','Thunder Bay','CDN','Thunder Bay','Ontario',NULL,48.371944,-89.323889,199,-5);
 INSERT INTO airport VALUES ('YQR','Regina Intl','CDN','Regina','Saskatchewan',NULL,50.431944,-104.665833,577,-6);
 INSERT INTO airport VALUES ('YOW','Ottawa Macdonald Cartier Intl','CDN','Ottawa','Ontario',NULL,45.3225,-75.669167,114,-5);
 INSERT INTO airport VALUES ('YUL','Pierre Elliott Trudeau Intl','CDN','Montréal','Quebec',NULL,45.470556,-73.740833,36,-5);
 INSERT INTO airport VALUES ('YTZ','City Centre','CDN','Toronto','Ontario',NULL,43.627499,-79.396167,77,-5);
 INSERT INTO airport VALUES ('YWG','Winnipeg Intl','CDN','Winnipeg','Manitoba',NULL,49.910036,-97.239886,239,-6);
 INSERT INTO airport VALUES ('YVR','Vancouver Intl','CDN','Vancouver','British Columbia',NULL,49.193889,-123.184444,4,-8);
 INSERT INTO airport VALUES ('YHM','Hamilton','CDN','Hamilton','Ontario',NULL,43.173611,-79.935,238,-5);
 INSERT INTO airport VALUES ('YHZ','Halifax Intl','CDN','Halifax','Nova Scotia',NULL,44.880833,-63.50861,145,-4);
 INSERT INTO airport VALUES ('YEG','Edmonton Intl','CDN','Edmonton','Alberta',NULL,53.309723,-113.579722,723,-7);
 INSERT INTO airport VALUES ('RAI','Praia International Airport','CV','Praia','Cape Verde','Santiago',14.9245,-23.4935,70,-1);
 INSERT INTO airport VALUES ('LYB','Edward Bodden Airfield','CAYM',NULL,NULL,'Little Cayman',19.6591666667,-80.09083333,1,-5);
 INSERT INTO airport VALUES ('GCM','Owen Roberts Intl','CAYM','George Town','Cayman Islands','Grand Cayman',19.292778,-81.35775,2,-5);
 INSERT INTO airport VALUES ('CYB','Gerrard Smith Intl','CAYM',NULL,NULL,'Cayman Brac',19.686981,-79.882789,2,-5);
 INSERT INTO airport VALUES ('BGF','Bangui M Poko','RCA','Bangui','Central African Republic',NULL,4.398475,18.518786,368,1);
 INSERT INTO airport VALUES ('NDJ','Ndjamena Hassan Djamous','TCH','N''Djamena','Chad',NULL,12.133689,15.034019,295,1);
 INSERT INTO airport VALUES ('ANF','Cerro Moreno Intl','RCH','Antofagasta','Antofagasta',NULL,-23.444478,-70.4451,139,-4);
 INSERT INTO airport VALUES ('ZAL','Pichoy','RCH','Valdivia','Ríos',NULL,-39.649956,-73.086111,18,-4);
 INSERT INTO airport VALUES ('LSC','La Florida','RCH','La Serena','Coquimbo',NULL,-29.916233,-71.199522,147,-4);
 INSERT INTO airport VALUES ('CPO','Copiapo','RCH','Copiapó','Atacama',NULL,-27,-70,305,-4);
 INSERT INTO airport VALUES ('CCP','Carriel Sur Intl','RCH','Concepción','Bío-Bío',NULL,-36.77265,-73.063106,8,-4);
 INSERT INTO airport VALUES ('ZCO','Maquehue','RCH','Temuco','Araucanía',NULL,-38.766819,-72.637097,93,-4);
 INSERT INTO airport VALUES ('SCL','Arturo Merino Benitez Intl','RCH','Santiago','Santiago',NULL,-33.392975,-70.785803,474,-4);
 INSERT INTO airport VALUES ('IQQ','Diego Aracena Intl','RCH','Iquique','Tarapacá',NULL,-20.535222,-70.181275,47,-4);
 INSERT INTO airport VALUES ('ARI','Chacalluta','RCH','Arica','Arica y Parinacota',NULL,-18.348531,-70.338742,51,-4);
 INSERT INTO airport VALUES ('PMC','El Tepual Intl','RCH','Puerto Montt','Lagos',NULL,-41.438886,-73.093953,90,-4);
 INSERT INTO airport VALUES ('PUQ','Carlos Ibanez Del Campo Intl','RCH','Punta Arenas','Magallanes',NULL,-53.002642,-70.854586,42,-4);
 INSERT INTO airport VALUES ('HGH','Xiaoshan','CN','Hangzhou','Zhejiang',NULL,30.229503,120.434453,7,8);
 INSERT INTO airport VALUES ('XMN','Gaoqi','CN','Xiamen','Fujian',NULL,24.544036,118.127739,18,8);
 INSERT INTO airport VALUES ('HLD','Dongshan','CN','Hailar','Nei Mongol',NULL,49.204997,119.825,661,8);
 INSERT INTO airport VALUES ('XFN','Xiangfan Airport','CN','Xiangyang','Hubei',NULL,32.1506,112.291,NULL,8);
 INSERT INTO airport VALUES ('XIC','Qingshan','CN','Xichang','Sichuan',NULL,27.989083,102.184361,1559,8);
 INSERT INTO airport VALUES ('HAK','Meilan','CN','Haikou','Hainan','Hainan',19.934856,110.458961,23,8);
 INSERT INTO airport VALUES ('HET','Baita Airport','CN','Hohhot','Nei Mongol',NULL,40.851422,111.824103,1084,8);
 INSERT INTO airport VALUES ('PEK','Capital Intl','CN','Beijing','Beijing',NULL,40.080111,116.584556,35,8);
 INSERT INTO airport VALUES ('PVG','Pudong','CN','Shanghai','Shanghai',NULL,31.143378,121.805214,4,8);
 INSERT INTO airport VALUES ('NGB','Ningbo Lishe','CN','Ningbo','Zhejiang',NULL,29.82,121.46,4,8);
 INSERT INTO airport VALUES ('WXN','Wanzhou Wuqiao Airport','CN','Wanxian','Sichuan',NULL,30.8361,108.406,567,8);
 INSERT INTO airport VALUES ('WUH','Tianhe','CN','Wuhan','Hubei',NULL,30.783758,114.2081,34,8);
 INSERT INTO airport VALUES ('WUX','Wuxi Airport','CN','Wuxi','Jiangsu',NULL,31.4944,120.429,5,8);
 INSERT INTO airport VALUES ('FOC','Fuzhou Changle','CN','Fuzhou','Fujian',NULL,25.93,119.65,14,8);
 INSERT INTO airport VALUES ('WNZ','Wenzhou Longwan Airport','CN','Wenzhou','Zhejiang',NULL,27.9122,120.852,NULL,8);
 INSERT INTO airport VALUES ('INC','Yinchuan','CN','Yinchuan','Ningxia',NULL,38.481944,106.009167,1098,8);
 INSERT INTO airport VALUES ('ZUH','Zhuhai Airport','CN','Zhuhai','Guangdong',NULL,22.0064,113.376,7,8);
 INSERT INTO airport VALUES ('HRB','Taiping','CN','Harbin','Heilongjiang',NULL,45.623403,126.250328,139,8);
 INSERT INTO airport VALUES ('JMU','Jiamusi Airport','CN','Jiamusi','Heilongjiang',NULL,46.843394,130.465389,80,8);
 INSERT INTO airport VALUES ('CGQ','Changchun','CN','Changchun','Jilin',NULL,43.5412,125.1201,69,8);
 INSERT INTO airport VALUES ('CGO','Xinzheng','CN','Zhengzhou','Henan',NULL,34.519672,113.840889,151,8);
 INSERT INTO airport VALUES ('LHW','Lanzhou Airport','CN','Lanzhou','Gansu',NULL,36.117,103.617,1948,8);
 INSERT INTO airport VALUES ('SJW','Shijiazhuang Daguocun International Airport','CN','Shijiazhuang','Hebei',NULL,38.280686,114.6973,71,8);
 INSERT INTO airport VALUES ('CKG','Jiangbei','CN','Chongqing','Chongqing',NULL,29.719217,106.641678,416,8);
 INSERT INTO airport VALUES ('CSX','Huanghua','CN','Changsha','Hunan',NULL,28.189158,113.219633,66,8);
 INSERT INTO airport VALUES ('BHY','Beihai Airport','CN','Beihai','Guangxi',NULL,21.5394,109.294,NULL,8);
 INSERT INTO airport VALUES ('TGO','Tongliao Airport','CN','Tongliao','Nei Mongol',NULL,43.5567,122.2,730,8);
 INSERT INTO airport VALUES ('KHN','Changbei Intl','CN','Nanchang','Jiangxi',NULL,28.865,115.9,44,8);
 INSERT INTO airport VALUES ('KMG','Wujiaba','CN','Kunming','Yunnan',NULL,24.992364,102.743536,1895,8);
 INSERT INTO airport VALUES ('TSN','Binhai','CN','Tianjin','Tianjin',NULL,39.124353,117.346183,3,8);
 INSERT INTO airport VALUES ('BAV','Baotou Airport','CN','Baotou','Nei Mongol',NULL,40.56,109.997,1013,8);
 INSERT INTO airport VALUES ('NDG','Qiqihar Sanjiazi Airport','CN','Qiqihar','Heilongjiang',NULL,47.239628,123.918131,145,8);
 INSERT INTO airport VALUES ('NNG','Wuxu','CN','Nanning','Guangxi',NULL,22.608267,108.172442,128,8);
 INSERT INTO airport VALUES ('NKG','Lukou','CN','Nanjing','Jiangsu',NULL,31.742042,118.862025,15,8);
 INSERT INTO airport VALUES ('URC','Diwopu','CN','Wulumuqi','Xinjiang',NULL,43.907106,87.474244,648,8);
 INSERT INTO airport VALUES ('NTG','Nantong Airport','CN','Nantong','Jiangsu',NULL,32.0708,120.976,NULL,8);
 INSERT INTO airport VALUES ('MIG','Mianyang Airport','CN','Mianyang','Sichuan',NULL,31.4281,104.741,NULL,8);
 INSERT INTO airport VALUES ('TYN','Wusu','CN','Taiyuan','Shanxi',NULL,37.746897,112.628428,785,8);
 INSERT INTO airport VALUES ('CAN','Baiyun Intl','CN','Guangzhou','Guangdong',NULL,23.392436,113.298786,15,8);
 INSERT INTO airport VALUES ('LZO','Luzhou Airport','CN','Luzhou','Sichuan',NULL,28.8522,105.393,NULL,8);
 INSERT INTO airport VALUES ('LYI','Shubuling Airport','CN','Linyi','Shandong',NULL,35.0461,118.412,NULL,8);
 INSERT INTO airport VALUES ('LXA','Lhasa-Gonggar','CN','Lhasa','Xizang',NULL,29.297778,90.911944,4005,8);
 INSERT INTO airport VALUES ('WEH','Weihai Airport','CN','Weihai','Shandong',NULL,37.1871,122.229,44,8);
 INSERT INTO airport VALUES ('MDG','Mudanjiang','CN','Mudanjiang','Heilongjiang',NULL,44.523889,129.568889,269,8);
 INSERT INTO airport VALUES ('DLC','Zhoushuizi','CN','Dalian','Liaoning',NULL,38.965667,121.5386,33,8);
 INSERT INTO airport VALUES ('TNA','Jinan','CN','Jinan','Shandong',NULL,36.857214,117.215992,23,8);
 INSERT INTO airport VALUES ('SYX','Phoenix International','CN','Sanya','Hainan','Hainan',18.302897,109.412272,28,8);
 INSERT INTO airport VALUES ('KWE','Longdongbao','CN','Guiyang','Guizhou',NULL,26.538522,106.800703,1139,8);
 INSERT INTO airport VALUES ('SZX','Baoan Intl','CN','Shenzhen','Guangdong',NULL,22.639258,113.810664,4,8);
 INSERT INTO airport VALUES ('CTU','Shuangliu','CN','Chengdu','Sichuan',NULL,30.578528,103.947086,495,8);
 INSERT INTO airport VALUES ('YNJ','Yanji Airport','CN','Yanji','Jilin',NULL,42.8828,129.451258,190,8);
 INSERT INTO airport VALUES ('YNT','Laishan','CN','Yantai','Shandong',NULL,37.401667,121.371667,18,8);
 INSERT INTO airport VALUES ('YNZ','Yancheng Airport','CN','Yancheng','Jiangsu',NULL,33.3856,120.125,NULL,8);
 INSERT INTO airport VALUES ('YIH','Yichang Airport','CN','Yichang','Hubei',NULL,30.671,111.441,205,8);
 INSERT INTO airport VALUES ('YBP','Yibin','CN','Yibin','Sichuan',NULL,28.800278,104.544444,305,8);
 INSERT INTO airport VALUES ('XUZ','Xuzhou Guanyin Airport','CN','Xuzhou','Jiangsu',NULL,34.16,117.11,43,8);
 INSERT INTO airport VALUES ('FOC','Changle','CN','Fuzhou','Fujian',NULL,25.935064,119.663272,14,8);
 INSERT INTO airport VALUES ('XNN','Xining Caojiabao Airport','CN','Xining','Qinghai',NULL,36.5275,102.043,2170,8);
 INSERT INTO airport VALUES ('XIY','Xianyang','CN','Xi''an','Shaanxi',NULL,34.447119,108.751592,479,8);
 INSERT INTO airport VALUES ('HFE','Luogang','CN','Hefei','Anhui',NULL,31.780019,117.298436,33,8);
 INSERT INTO airport VALUES ('NNY','Nanyang Airport','CN','Nanyang','Henan',NULL,32.9808,112.615,NULL,8);
 INSERT INTO airport VALUES ('NZH','Manzhouli','CN','Manzhouli','Nei Mongol',NULL,49.57,117.329444,NULL,8);
 INSERT INTO airport VALUES ('YUS','Yushu Batang','CN','Yushu','Qinghai',NULL,32.825,97.125,3963,8);
 INSERT INTO airport VALUES ('AQG','Anqing Airport','CN','Anqing','Anhui',NULL,30.5822,117.0502,NULL,8);
 INSERT INTO airport VALUES ('CGD','Changde Airport','CN','Changde','Hunan',NULL,28.9189,111.64,NULL,8);
 INSERT INTO airport VALUES ('KHG','Kashi','CN','Kashgar','Xinjiang',NULL,39.542922,76.019956,1381,8);
 INSERT INTO airport VALUES ('KOW','Ganzhou Airport','CN','Ganzhou','Jiangxi',NULL,25.8258,114.912,NULL,8);
 INSERT INTO airport VALUES ('AKU','Aksu Airport','CN','Aksu','Xinjiang',NULL,41.2625,80.2917,1163,8);
 INSERT INTO airport VALUES ('KRL','Korla Airport','CN','Korla','Xinjiang',NULL,41.6978,86.1289,927,8);
 INSERT INTO airport VALUES ('LYA','Luoyang Airport','CN','Luoyang','Henan',NULL,34.41,112.28,64,8);
 INSERT INTO airport VALUES ('LYG','Lianyungang Airport','CN','Lianyungang','Jiangsu',NULL,34.55,119.25,NULL,8);
 INSERT INTO airport VALUES ('LZH','Bailian Airport','CN','Liuzhou','Guangxi',NULL,24.2075,109.391,90,8);
 INSERT INTO airport VALUES ('WEF','Weifang Airport','CN','Weifang','Shandong',NULL,36.6467,119.119,NULL,8);
 INSERT INTO airport VALUES ('CHG','Chaoyang Airport','CN','Chaoyang','Liaoning',NULL,41.5381,120.435,173,8);
 INSERT INTO airport VALUES ('CIH','Changzhi Airport','CN','Changzhi','Shanxi',NULL,36.2475,113.126,NULL,8);
 INSERT INTO airport VALUES ('CIF','Chifeng Airport','CN','Chifeng','Nei Mongol',NULL,42.235,118.908,NULL,8);
 INSERT INTO airport VALUES ('DOY','Dongying Airport','CN','Dongying','Shandong',NULL,37.2716,118.2819,26,8);
 INSERT INTO airport VALUES ('NAO','Nanchong Airport','CN','Nanchong','Sichuan',NULL,30.754,106.062,NULL,8);
 INSERT INTO airport VALUES ('JIU','Jiujiang Lushan Airport','CN','Jiujiang','Jiangxi',NULL,29.733,115.983,NULL,8);
 INSERT INTO airport VALUES ('JDZ','Jingdezhen Airport','CN','Jingdezhen','Jiangxi',NULL,29.3386,117.176,34,8);
 INSERT INTO airport VALUES ('ZHA','Zhanjiang Airport','CN','Zhanjiang','Guangdong',NULL,21.2144,110.358,38,8);
 INSERT INTO airport VALUES ('WUA','Wuhai','CN','Wuhai','Nei Mongol',NULL,39.794444,106.799444,NULL,8);
 INSERT INTO airport VALUES ('GYS','Guangyuan Airport','CN','Guangyuan','Sichuan',NULL,32.3911,105.702,NULL,8);
 INSERT INTO airport VALUES ('HSN','Zhoushan Airport','CN','Zhoushan','Zhejiang','Zhoushan',29.9342,122.362,9,8);
 INSERT INTO airport VALUES ('JNZ','Jinzhou Airport','CN','Jinzhou','Liaoning',NULL,41.1014,121.062,NULL,8);
 INSERT INTO airport VALUES ('JNG','Jining Airport','CN','Jining','Shandong',NULL,35.417,116.533,470,8);
 INSERT INTO airport VALUES ('JUZ','Quzhou Airport','CN','Quzhou','Hebei',NULL,28.9658,118.899,NULL,8);
 INSERT INTO airport VALUES ('HLH','Ulanhot Airport','CN','Ulanhot','Nei Mongol',NULL,46.083,122.017,NULL,8);
 INSERT INTO airport VALUES ('HMI','Hami Airport','CN','Hami','Xinjiang',NULL,42.8414,93.6692,824,8);
 INSERT INTO airport VALUES ('YIN','Yining Airport','CN','Yining','Xinjiang',NULL,43.9558,81.3303,666,8);
 INSERT INTO airport VALUES ('KWL','Liangjiang','CN','Guilin','Guangxi',NULL,25.218106,110.039197,174,8);
 INSERT INTO airport VALUES ('CZX','Changzhou','CN','Changzhou','Jiangsu',NULL,31.941667,119.711667,12,8);
 INSERT INTO airport VALUES ('SWA','Jieyang Chaoshan International Airport','CN','Shantou','Guangdong',NULL,23.55,116.5,NULL,8);
 INSERT INTO airport VALUES ('DAT','Datong Airport','CN','Datong','Shanxi',NULL,40.0603,113.482,1049,8);
 INSERT INTO airport VALUES ('TAO','Liuting','CN','Qingdao','Shandong',NULL,36.266108,120.374436,10,8);
 INSERT INTO airport VALUES ('DDG','Dandong','CN','Dandong','Liaoning',NULL,40.0255,124.2866,9,8);
 INSERT INTO airport VALUES ('SHE','Shenyang Taoxian International Airport','CN','Shenyang','Liaoning',NULL,41.3824,123.2901,60,8);
 INSERT INTO airport VALUES ('SHA','Hongqiao Intl','CN','Shanghai','Shanghai',NULL,31.197875,121.336319,3,8);
 INSERT INTO airport VALUES ('XCH','Christmas Island','XMAS','Flying Fish Cove','Christmas Island','Christmas Island',-10.450556,105.690278,279,7);
 INSERT INTO airport VALUES ('CCK','Cocos Keeling Island Airport','COCO','West Island','Cocos Islands','Pulau Panjang',-12.1883,96.8339,3,6.5);
 INSERT INTO airport VALUES ('BOG','Eldorado Intl','CO','Bogotá','Santa Fe de Bogotá',NULL,4.701594,-74.146947,2549,-5);
 INSERT INTO airport VALUES ('IBE','Perales','CO','Ibagué','Tolima',NULL,4.421608,-75.1333,914,-5);
 INSERT INTO airport VALUES ('FLA','Gustavo Artunduaga Paredes','CO','Florencia','Caquetá',NULL,1.589189,-75.564372,245,-5);
 INSERT INTO airport VALUES ('AXM','El Eden','CO','Armenia','Quindío',NULL,4.452775,-75.766447,1216,-5);
 INSERT INTO airport VALUES ('MZL','La Nubia','CO','Manizales','Caldas',NULL,5.029597,-75.464708,2095,-5);
 INSERT INTO airport VALUES ('EJA','Yariguies','CO','Barrancabermeja','Santander',NULL,7.024331,-73.8068,126,-5);
 INSERT INTO airport VALUES ('TCO','La Florida','CO','San Andres de Tumaco','Nariño',NULL,1.814417,-78.749228,2,-5);
 INSERT INTO airport VALUES ('CLO','Alfonso Bonilla Aragon Intl','CO','Cali','Valle de Cauca',NULL,3.543222,-76.381583,964,-5);
 INSERT INTO airport VALUES ('CTG','Rafael Nunez','CO','Cartagena','Bolívar',NULL,10.442381,-75.512961,1,-5);
 INSERT INTO airport VALUES ('SMR','Simon Bolivar','CO','Santa Marta','Magdalena',NULL,11.11965,-74.230647,7,-5);
 INSERT INTO airport VALUES ('BAQ','Ernesto Cortissoz','CO','Barranquilla','Atlántico',NULL,10.889589,-74.780819,30,-5);
 INSERT INTO airport VALUES ('PEI','Matecana','CO','Pereira','Risaralda',NULL,4.812675,-75.739519,1346,-5);
 INSERT INTO airport VALUES ('CUC','Camilo Daza','CO','Cúcuta','Norte de Santander',NULL,7.927567,-72.511547,334,-5);
 INSERT INTO airport VALUES ('BGA','Palonegro','CO','Bucaramanga','Santander',NULL,7.1265,-73.184778,1188,-5);
 INSERT INTO airport VALUES ('ADZ','Gustavo Rojas Pinilla','CO','San Andres','San Andrés, Providencia y Santa Catalina','San Andres',12.583594,-81.711192,6,-5);
 INSERT INTO airport VALUES ('EOH','Olaya Herrera','CO','Medellín','Antioquia',NULL,6.219958,-75.590519,1506,-5);
 INSERT INTO airport VALUES ('HAH','Prince Said Ibrahim','COM','Moroni','Comoros','Grand Comoro',-11.533661,43.27185,28,3);
 INSERT INTO airport VALUES ('PNR','Pointe Noire','RCB','Pointe-Noire','Pointe-Noire',NULL,-4.816028,11.886597,17,1);
 INSERT INTO airport VALUES ('BZV','Maya Maya','RCB','Brazzaville','Brazzaville',NULL,-4.2517,15.253031,320,1);
 INSERT INTO airport VALUES ('CUR','Hato','CUR','Willemstad','Curacao','Curacao',12.188853,-68.959803,9,-4);
 INSERT INTO airport VALUES ('FIH','Ndjili Intl','ZRE','Kinshasa','Kinshasa',NULL,-4.38575,15.444569,313,1);
 INSERT INTO airport VALUES ('MJM','Mbuji Mayi','ZRE','Mbuji-Mayi','Kasai-Oriental',NULL,-6.121236,23.569008,677,2);
 INSERT INTO airport VALUES ('FBM','Lubumbashi Intl','ZRE','Lubumbashi','Haut-Katanga',NULL,-11.591333,27.530889,1309,2);
 INSERT INTO airport VALUES ('RAR','Rarotonga Intl','COOK','Avarua','Cook Islands','Rarotonga',-21.202739,-159.805556,6,-10);
 INSERT INTO airport VALUES ('SYQ','Tobias Bolanos International Airport','CR','San José','San José',NULL,9.957053,-84.139797,1002,-6);
 INSERT INTO airport VALUES ('LIR','Daniel Oduber Quiros Intl','CR','Liberia','Guanacaste',NULL,10.593289,-85.544408,82,-6);
 INSERT INTO airport VALUES ('SJO','Juan Santamaria Intl','CR','San José','San José',NULL,9.993861,-84.208806,921,-6);
 INSERT INTO airport VALUES ('ABJ','Abidjan Felix Houphouet Boigny Intl','CI','Abidjan','Abidjan',NULL,5.261386,-3.926294,6,0);
 INSERT INTO airport VALUES ('SPU','Split','HR','Split','Croatia',NULL,43.538944,16.297964,24,1);
 INSERT INTO airport VALUES ('ZAG','Zagreb','HR','Zagreb','Croatia',NULL,45.742931,16.068778,108,1);
 INSERT INTO airport VALUES ('RJK','Rijeka','HR','Rijeka','Croatia',NULL,45.216889,14.570267,85,1);
 INSERT INTO airport VALUES ('ZAD','Zadar','HR','Zadar','Croatia',NULL,44.108269,15.346697,88,1);
 INSERT INTO airport VALUES ('SCU','Antonio Maceo Intl','C','Santiago de Cuba','Santiago de Cuba','Cuba',19.969769,-75.835414,76,-5);
 INSERT INTO airport VALUES ('CMW','Ignacio Agramonte Intl','C','Camagüey','Camagüey','Cuba',21.420428,-77.847433,126,-5);
 INSERT INTO airport VALUES ('HOG','Frank Pais Intl','C','Holguín','Holguín','Cuba',20.785589,-76.315108,110,-5);
 INSERT INTO airport VALUES ('GER','Rafael Cabrera','C','Nueva Gerona','Isla de la Juventud','Cuba',21.834689,-82.783819,24,-5);
 INSERT INTO airport VALUES ('HAV','Jose Marti Intl','C','La Habana','La Habana','Cuba',22.989153,-82.409086,64,-5);
 INSERT INTO airport VALUES ('LCA','Larnaca','CY','Larnaka','Cyprus','Cyprus',34.875117,33.62485,2,2);
 INSERT INTO airport VALUES ('ECN','Ercan International Airport','CY','Lefkosia','Cyprus','Cyprus',35.1547,33.4961,123,2);
 INSERT INTO airport VALUES ('KLV','Karlovy Vary','CZ','Karlovy Vary','Karlovarský',NULL,50.202978,12.914983,606,1);
 INSERT INTO airport VALUES ('PED','Pardubice','CZ','Pardubice','Pardubický',NULL,50.013419,15.738647,226,1);
 INSERT INTO airport VALUES ('PRG','Vaclav Havel Airport','CZ','Praha','Praha',NULL,50.100833,14.26,380,1);
 INSERT INTO airport VALUES ('OSR','Mosnov','CZ','Ostrava','Moravskoslezský',NULL,49.696292,18.111053,257,1);
 INSERT INTO airport VALUES ('BRQ','Brno-Tuřany','CZ','Brno','Jihomoravský',NULL,49.1514,16.6944,235,1);
 INSERT INTO airport VALUES ('CPH','Kastrup','DK','Copenhagen','Hovedstaden','Seeland',55.617917,12.655972,5,1);
 INSERT INTO airport VALUES ('AAL','Aalborg','DK','Ålborg','Nordjylland',NULL,57.092789,9.849164,3,1);
 INSERT INTO airport VALUES ('AAR','Aarhus','DK','Århus','Midtjylland',NULL,56.300017,10.619008,25,1);
 INSERT INTO airport VALUES ('RNN','Bornholm Ronne','DK','Ronne','Hovedstaden','Bornholm',55.063267,14.759558,16,1);
 INSERT INTO airport VALUES ('EBJ','Esbjerg','DK','Esbjerg','Syddanmark',NULL,55.525942,8.553403,30,1);
 INSERT INTO airport VALUES ('JIB','Ambouli International Airport','DJI','Djibouti','Djibouti',NULL,11.5472,43.1594,15,3);
 INSERT INTO airport VALUES ('DOM','Melville Hall','WD','Roseau','Dominica','Dominica',15.547028,-61.3,22,-4);
 INSERT INTO airport VALUES ('SDQ','Las Americas Intl','DOM','Santo Domingo','Dominican Republic','Hispaniola',18.429664,-69.668925,18,-4);
 INSERT INTO airport VALUES ('STI','Cibao Intl','DOM','Santiago','Dominican Republic','Hispaniola',19.406092,-70.604689,172,-4);
 INSERT INTO airport VALUES ('DIL','Presidente Nicolau Lobato Intl','TL','Dili','Timor-Leste','Timor',-8.546553,125.524719,8,8);
 INSERT INTO airport VALUES ('GPS','Seymour','EC',NULL,NULL,'Isabela',-0.453758,-90.265914,63,-6);
 INSERT INTO airport VALUES ('GYE','Jose Joaquin De Olmedo Intl','EC','Guayaquil','Ecuador',NULL,-2.157419,-79.883558,6,-5);
 INSERT INTO airport VALUES ('UIO','Mariscal Sucre Intl','EC','Quito','Ecuador',NULL,-0.141144,-78.488214,2813,-5);
 INSERT INTO airport VALUES ('CUE','Mariscal Lamar','EC','Cuenca','Ecuador',NULL,-2.889467,-78.984397,2532,-5);
 INSERT INTO airport VALUES ('HRG','Hurghada Intl','ET','Hurghada','Egypt',NULL,27.178317,33.799436,16,2);
 INSERT INTO airport VALUES ('ASW','Aswan Intl','ET','Aswan','Egypt',NULL,23.964356,32.819975,202,2);
 INSERT INTO airport VALUES ('ATZ','Asyut International Airport','ET','Asyut','Egypt',NULL,27.046508,31.011983,235,2);
 INSERT INTO airport VALUES ('HBE','Borg El Arab Intl','ET','Al Iskandariyah','Egypt',NULL,30.917669,29.696408,54,2);
 INSERT INTO airport VALUES ('CAI','Cairo Intl','ET','Al Qahirah','Egypt',NULL,30.121944,31.405556,116,2);
 INSERT INTO airport VALUES ('LXR','Luxor Intl','ET','Al Uqsur','Egypt',NULL,25.671028,32.706583,90,2);
 INSERT INTO airport VALUES ('ALY','Alexandria Intl','ET','Al Iskandariyah','Egypt',NULL,31.183903,29.948889,-2,2);
 INSERT INTO airport VALUES ('SAL','El Salvador Intl','ES','San Salvador','El Salvador',NULL,13.440947,-89.055728,31,-6);
 INSERT INTO airport VALUES ('SSG','Malabo','GQ','Malabo','Insular','Bioko',3.755267,8.708717,23,1);
 INSERT INTO airport VALUES ('BSG','Bata','GQ','Bata','Continental',NULL,1.9056,9.8056,11,1);
 INSERT INTO airport VALUES ('ASM','Asmara Intl','ER','Asmara','Eritrea',NULL,15.291853,38.910667,2336,3);
 INSERT INTO airport VALUES ('TLL','Tallinn-Ulemiste International','EW','Tallinn','Estonia',NULL,59.413317,24.832844,40,2);
 INSERT INTO airport VALUES ('GDQ','Gondar','ETH','Gondar','Amhara',NULL,12.5199,37.434047,1994,3);
 INSERT INTO airport VALUES ('DIR','Dire Dawa Intl','ETH','Dire Dawa','Dire Dawa',NULL,9.6247,41.854203,1167,3);
 INSERT INTO airport VALUES ('ADD','Bole Intl','ETH','Addis Ababa','Addis Ababa',NULL,8.977889,38.799319,2334,3);
 INSERT INTO airport VALUES ('GMB','Gambella','ETH','Gambella','Gambella',NULL,8.128764,34.563131,540,3);
 INSERT INTO airport VALUES ('PSY','Port Stanley','FALK','Stanley','Falkland Islands','East Falkland',-51.6857,-57.7776,23,-3);
 INSERT INTO airport VALUES ('FAE','Vagar','FARX','Tórshavn','Faroe Islands','Streymoy',62.063628,-7.277219,85,0);
 INSERT INTO airport VALUES ('SUV','Nausori Intl','FJI','Suva','Fiji','Viti Levu',-18.043267,178.559228,5,12);
 INSERT INTO airport VALUES ('MHQ','Mariehamn','SF','Mariehamn','Åland',NULL,60.122203,19.898156,5,2);
 INSERT INTO airport VALUES ('OUL','Oulu','SF','Oulu','Pohjois-Pohjanmaa',NULL,64.930061,25.354564,14,2);
 INSERT INTO airport VALUES ('HEL','Helsinki Vantaa','SF','Helsinki','Uusimaa',NULL,60.317222,24.963333,55,2);
 INSERT INTO airport VALUES ('POR','Pori','SF','Pori','Satakunta',NULL,61.461686,21.799983,13,2);
 INSERT INTO airport VALUES ('JOE','Joensuu','SF','Joensuu','Pohjols-Karjala',NULL,62.662906,29.60755,121,2);
 INSERT INTO airport VALUES ('RVN','Rovaniemi','SF','Rovaniemi','Lappia',NULL,66.564822,25.830411,196,2);
 INSERT INTO airport VALUES ('JYV','Jyväskylä','SF','Jyväskylä','Keski-Suomi',NULL,62.399453,25.678253,140,2);
 INSERT INTO airport VALUES ('KUO','Kuopio','SF','Kuopio','Pohjois-Savo',NULL,63.00715,27.797756,98,2);
 INSERT INTO airport VALUES ('LPP','Lappeenranta','SF','Lappeenranta','Etelä-Karjala',NULL,61.044553,28.144397,106,2);
 INSERT INTO airport VALUES ('TMP','Tampere Pirkkala','SF','Tampere','Pirkanmaa',NULL,61.414147,23.604392,119,2);
 INSERT INTO airport VALUES ('TKU','Turku','SF','Turku','Varsinais-Suomi',NULL,60.514142,22.262808,49,2);
 INSERT INTO airport VALUES ('VAA','Vaasa','SF','Vaasa','Pohjanmaa',NULL,63.05065,21.762175,6,2);
 INSERT INTO airport VALUES ('MLH','Basel Mulhouse','F','Mulhouse','Alsace',NULL,47.589583,7.529914,270,1);
 INSERT INTO airport VALUES ('MRS','Provence','F','Marseille','Provence-Alpes-Côte d''Azur',NULL,43.435555,5.213611,23,1);
 INSERT INTO airport VALUES ('MPL','Mediterranee','F','Montpellier','Languedoc-Roussillon',NULL,43.576194,3.963014,5,1);
 INSERT INTO airport VALUES ('CFR','Carpiquet','F','Caen','Basse Normandie',NULL,49.173333,-0.45,78,1);
 INSERT INTO airport VALUES ('ANE','Angers-Loire Airport','F','Angers','Pays de la Loire',NULL,47.5603,-0.312222,59,1);
 INSERT INTO airport VALUES ('ETZ','Metz Nancy Lorraine','F','Metz','Lorraine',NULL,48.982142,6.251319,265,1);
 INSERT INTO airport VALUES ('ORY','Orly','F','Paris','Île-de-France',NULL,48.725278,2.359444,89,1);
 INSERT INTO airport VALUES ('FNI','Garons','F','Nîmes','Languedoc-Roussillon',NULL,43.757444,4.416347,94,1);
 INSERT INTO airport VALUES ('PGF','Rivesaltes','F','Perpignan','Languedoc-Roussillon',NULL,42.740442,2.870667,44,1);
 INSERT INTO airport VALUES ('PIS','Biard','F','Poitiers','Poitou Charentes',NULL,46.587745,.306666,129,1);
 INSERT INTO airport VALUES ('RNS','St Jacques','F','Rennes','Bretagne',NULL,48.069508,-1.734794,38,1);
 INSERT INTO airport VALUES ('LYS','Saint Exupery','F','Lyon','Rhône-Alpes',NULL,45.726387,5.090833,250,1);
 INSERT INTO airport VALUES ('BOD','Merignac','F','Bordeaux','Aquitaine',NULL,44.828335,-0.715556,49,1);
 INSERT INTO airport VALUES ('SXB','Entzheim','F','Strasbourg','Alsace',NULL,48.538319,7.628233,154,1);
 INSERT INTO airport VALUES ('CFE','Auvergne','F','Clermont-Ferrand','Auvergne',NULL,45.786661,3.169169,332,1);
 INSERT INTO airport VALUES ('LIG','Bellegarde','F','Limoges','Limousin',NULL,45.862778,1.179444,396,1);
 INSERT INTO airport VALUES ('LIL','Lesquin','F','Lille','Nord-Pas-de-Calais',NULL,50.561942,3.089444,48,1);
 INSERT INTO airport VALUES ('CDG','Charles De Gaulle','F','Paris','Île-de-France',NULL,49.012779,2.55,120,1);
 INSERT INTO airport VALUES ('AJA','Campo Dell Oro','F','Ajaccio','Corse','Corse',41.923637,8.802917,5,1);
 INSERT INTO airport VALUES ('TUF','Val De Loire','F','Tours','Centre',NULL,47.432222,.727606,109,1);
 INSERT INTO airport VALUES ('TLS','Blagnac','F','Toulouse','Midi-Pyrénées',NULL,43.629075,1.363819,152,1);
 INSERT INTO airport VALUES ('BES','Guipavas','F','Brest','Bretagne',NULL,48.447911,-4.418539,99,1);
 INSERT INTO airport VALUES ('NCE','Cote d''Azur','F','Nice','Provence-Alpes-Côte d''Azur',NULL,43.658411,7.215872,4,1);
 INSERT INTO airport VALUES ('NTE','Nantes Atlantique','F','Nantes','Pays de la Loire',NULL,47.153189,-1.610725,27,1);
 INSERT INTO airport VALUES ('SBH','Saint Barthelemy','SBAR','Gustavia','Saint Barthelemy','St. Barthelemy',17.9023,-62.8324,15,-4);
 INSERT INTO airport VALUES ('CAY','Rochambeau','FGU','Cayenne','French Guiana',NULL,4.819808,-52.360447,8,-3);
 INSERT INTO airport VALUES ('PPT','Faa''a International','FPOL','Papeete','French Polynesia','Tahiti',-17.556667,-149.611389,2,-10);
 INSERT INTO airport VALUES ('LBV','Leon M Ba','G','Libreville','Gabon',NULL,.4586,9.412283,12,1);
 INSERT INTO airport VALUES ('BJL','Banjul Intl','WAG','Banjul','Gambia',NULL,13.337961,-16.652206,29,0);
 INSERT INTO airport VALUES ('TBS','Tbilisi','GE','Tbilisi','Georgia',NULL,41.669167,44.954722,495,4);
 INSERT INTO airport VALUES ('BUS','Batumi','GE','Batumi','Georgia',NULL,41.610278,41.599694,32,4);
 INSERT INTO airport VALUES ('KUT','Kopitnari','GE','Kutaisi','Georgia',NULL,42.176653,42.482583,68,4);
 INSERT INTO airport VALUES ('HAJ','Hannover','D','Hannover','Niedersachsen',NULL,52.461056,9.685078,56,1);
 INSERT INTO airport VALUES ('HAM','Hamburg','D','Hamburg','Hamburg',NULL,53.630389,9.988228,16,1);
 INSERT INTO airport VALUES ('PAD','Paderborn Lippstadt','D','Paderborn','Nordrhein-Westfalen',NULL,51.614089,8.616317,213,1);
 INSERT INTO airport VALUES ('GWT','Westerland Sylt','D',NULL,NULL,'Sylt',54.91325,8.340472,16,1);
 INSERT INTO airport VALUES ('SCN','Saarbrücken','D','Saarbrücken','Saarland',NULL,49.214553,7.109508,323,1);
 INSERT INTO airport VALUES ('TXL','Tegel','D','Berlin','Berlin',NULL,52.559686,13.287711,37,1);
 INSERT INTO airport VALUES ('BRE','Neuenland','D','Bremen','Bremen',NULL,53.0475,8.786667,4,1);
 INSERT INTO airport VALUES ('SXF','Schönefeld','D','Berlin','Berlin',NULL,52.380001,13.5225,48,1);
 INSERT INTO airport VALUES ('STR','Stuttgart','D','Stuttgart','Baden-Württemberg',NULL,48.689878,9.221964,389,1);
 INSERT INTO airport VALUES ('LBC','Lübeck','D','Lübeck','Schleswig-Holstein',NULL,53.805367,10.719222,16,1);
 INSERT INTO airport VALUES ('LEJ','Leipzig Halle','D','Leipzig','Sachsen',NULL,51.432447,12.241633,142,1);
 INSERT INTO airport VALUES ('CGN','Köln Bonn','D','Köln','Nordrhein-Westfalen',NULL,50.865917,7.142744,92,1);
 INSERT INTO airport VALUES ('HHN','Frankfurt Hahn','D','Frankfurt am Main','Hessen',NULL,49.948672,7.263892,503,1);
 INSERT INTO airport VALUES ('FRA','Frankfurt Main','D','Frankfurt am Main','Hessen',NULL,50.026421,8.543125,111,1);
 INSERT INTO airport VALUES ('FMO','Münster Osnabrück','D','Münster','Nordrhein-Westfalen',NULL,52.134642,7.684831,49,1);
 INSERT INTO airport VALUES ('FKB','Baden Airpark','D','Karlsruhe','Baden-Württemberg',NULL,48.7793,8.08048,124,1);
 INSERT INTO airport VALUES ('DUS','Düsseldorf','D','Düsseldorf','Nordrhein-Westfalen',NULL,51.289453,6.766775,45,1);
 INSERT INTO airport VALUES ('NUE','Nürnberg','D','Nürnberg','Bayern',NULL,49.4987,11.066897,319,1);
 INSERT INTO airport VALUES ('DRS','Dresden','D','Dresden','Sachsen',NULL,51.132767,13.767161,230,1);
 INSERT INTO airport VALUES ('DTM','Dortmund','D','Dortmund','Nordrhein-Westfalen',NULL,51.518314,7.612242,130,1);
 INSERT INTO airport VALUES ('MUC','Franz Josef Strauss','D','München','Bayern',NULL,48.353783,11.786086,453,1);
 INSERT INTO airport VALUES ('ACC','Kotoka Intl','GH','Accra','Greater Accra',NULL,5.605186,-0.166786,63,0);
 INSERT INTO airport VALUES ('GIB','Gibraltar','GBZ','Gibraltar','Gibraltar',NULL,36.151219,-5.349664,5,1);
 INSERT INTO airport VALUES ('HER','Nikos Kazantzakis','GR','Iraklio','Kritis','Crete',35.339719,25.180297,35,2);
 INSERT INTO airport VALUES ('IOA','Ioannina','GR','Ioannina','Ipeiroy',NULL,39.696388,20.8225,475,2);
 INSERT INTO airport VALUES ('JMK','Mikonos','GR',NULL,NULL,'Mykonos',37.435128,25.348103,123,2);
 INSERT INTO airport VALUES ('JKH','Chios','GR',NULL,NULL,'Chios',38.343175,26.140572,5,2);
 INSERT INTO airport VALUES ('RHO','Rhodes Diagoras','GR','Rhodes','Notioy Aigaioy','Rhodos',36.405419,28.086192,5,2);
 INSERT INTO airport VALUES ('ATH','Eleftherios Venizelos Intl','GR','Athina','Attikis',NULL,37.936358,23.944467,94,2);
 INSERT INTO airport VALUES ('EFL','Kefallinia','GR',NULL,NULL,'Kefallinia',38.120069,20.500481,18,2);
 INSERT INTO airport VALUES ('KVA','Megas Alexandros Intl','GR','Kavala','Anatolikis Makedonias kai Thrakis',NULL,40.913306,24.619223,5,2);
 INSERT INTO airport VALUES ('CFU','Ioannis Kapodistrias Intl','GR','Kerkyra','Ionion Nison','Korfu',39.601944,19.911667,2,2);
 INSERT INTO airport VALUES ('SKG','Makedonia','GR','Thessaloniki','Kentrikis Makedonias',NULL,40.519725,22.97095,7,2);
 INSERT INTO airport VALUES ('CHQ','Souda','GR','Chania','Kritis','Crete',35.531747,24.149678,149,2);
 INSERT INTO airport VALUES ('SMI','Samos','GR',NULL,NULL,'Samos',37.689999,26.911667,6,2);
 INSERT INTO airport VALUES ('KGS','Kos','GR',NULL,NULL,'Kos',36.793335,27.091667,126,2);
 INSERT INTO airport VALUES ('MJT','Mitilini','GR','Mytilini','Boreioy Aigaioy','Lesbos',39.056667,26.598333,18,2);
 INSERT INTO airport VALUES ('GPA','Araxos','GR','Patra','Dytikis Elladas',NULL,38.151111,21.425556,14,2);
 INSERT INTO airport VALUES ('ZTH','Dionysios Solomos','GR',NULL,NULL,'Zakynthos',37.750853,20.88425,5,2);
 INSERT INTO airport VALUES ('JIK','Ikaria','GR',NULL,NULL,'Ikaria',37.682717,26.347061,24,2);
 INSERT INTO airport VALUES ('JSY','Syros','GR','Ermoupoli','Notioy Aigaioy','Syros',37.422792,24.950936,72,2);
 INSERT INTO airport VALUES ('GOH','Nuuk','GROX','Nuuk','Greenland','Greenland',64.190922,-51.678064,86,-3);
 INSERT INTO airport VALUES ('GND','Point Salines Intl','WG','Saint George''s','Grenada','Grenada',12.004247,-61.786192,13,-4);
 INSERT INTO airport VALUES ('PTP','Le Raizet','GUAD','Basse-Terre','Guadeloupe','Basse-Terre',16.265306,-61.531806,11,-4);
 INSERT INTO airport VALUES ('GUM','Guam Intl','GUAM','Hagåtña','Guam','Guam',13.48345,144.795983,91,10);
 INSERT INTO airport VALUES ('GUA','La Aurora','GCA','Ciudad de Guatemala','Guatemala',NULL,14.583272,-90.527475,1510,-6);
 INSERT INTO airport VALUES ('GCI','Guernsey','GBG','Saint Peter Port','Guernsey','Guernsey',49.434956,-2.601969,102,0);
 INSERT INTO airport VALUES ('CKY','Conakry','RG','Conakry','Guinea',NULL,9.576889,-13.611961,22,0);
 INSERT INTO airport VALUES ('OXB','Osvaldo Vieira Intl','GNB','Bissau','Guinea-Bissau',NULL,11.8947,-15.6536,39,0);
 INSERT INTO airport VALUES ('GEO','Cheddi Jagan Intl','GUY','Georgetown','Guyana',NULL,6.498553,-58.254119,29,-4);
 INSERT INTO airport VALUES ('PAP','Toussaint Louverture Intl','RH','Port-au-Prince','Haiti','Hispaniola',18.58005,-72.292542,37,-5);
 INSERT INTO airport VALUES ('TGU','Toncontin Intl','HCA','Tegucigalpa','Francisco Morazán',NULL,14.060883,-87.217197,1004,-6);
 INSERT INTO airport VALUES ('HKG','Hong Kong Intl','HONX','Hong Kong','Hong Kong',NULL,22.308919,113.914603,9,8);
 INSERT INTO airport VALUES ('BUD','Ferihegy','H','Budapest','Budapest',NULL,47.436933,19.255592,151,1);
 INSERT INTO airport VALUES ('KEF','Keflavik International Airport','IS','Keflavik','Iceland','Iceland',63.985,-22.605556,52,0);
 INSERT INTO airport VALUES ('SXR','Srinagar','IND','Srinagar','Jammu and Kashmir',NULL,33.987139,74.77425,1655,5.5);
 INSERT INTO airport VALUES ('STV','Surat','IND','Surat','Gujarat',NULL,21.114061,72.741792,5,5.5);
 INSERT INTO airport VALUES ('DED','Dehradun','IND','Dehra Dun','Uttarakhand',NULL,30.189689,78.180256,558,5.5);
 INSERT INTO airport VALUES ('DEL','Indira Gandhi Intl','IND','Delhi','Delhi',NULL,28.5665,77.103088,237,5.5);
 INSERT INTO airport VALUES ('LKO','Lucknow','IND','Lucknow','Uttar Pradesh',NULL,26.760594,80.889339,125,5.5);
 INSERT INTO airport VALUES ('CJB','Coimbatore','IND','Coimbatore','Tamil Nadu',NULL,11.030031,77.043383,404,5.5);
 INSERT INTO airport VALUES ('COK','Cochin','IND','Kochi','Kerala',NULL,10.155556,76.391389,2,5.5);
 INSERT INTO airport VALUES ('BHO','Bhopal','IND','Bhopal','Madhya Pradesh',NULL,23.287467,77.337375,524,5.5);
 INSERT INTO airport VALUES ('BLR','Bangalore','IND','Bangalore','Karnataka',NULL,12.949986,77.668206,888,5.5);
 INSERT INTO airport VALUES ('TRZ','Trichy','IND','Tiruchirappalli','Tamil Nadu',NULL,10.765364,78.709722,88,5.5);
 INSERT INTO airport VALUES ('TRV','Thiruvananthapuram Intl','IND','Trivandrum','Kerala',NULL,8.482122,76.920114,5,5.5);
 INSERT INTO airport VALUES ('AJL','Aizawl','IND','Aijal','Mizoram',NULL,23.746603,92.802767,305,5.5);
 INSERT INTO airport VALUES ('CCJ','Calicut','IND','Kozhikode','Kerala',NULL,11.136839,75.9553,104,5.5);
 INSERT INTO airport VALUES ('CCU','Netaji Subhash Chandra Bose Intl','IND','Kolkata','West Bengal',NULL,22.654739,88.446722,5,5.5);
 INSERT INTO airport VALUES ('BBI','Bhubaneshwar','IND','Bhubaneswar','Odisha',NULL,20.244364,85.817781,42,5.5);
 INSERT INTO airport VALUES ('VGA','Vijayawada','IND','Vijayawada','Andhra Pradesh',NULL,16.530433,80.796847,25,5.5);
 INSERT INTO airport VALUES ('VNS','Varanasi','IND','Varanasi','Uttar Pradesh',NULL,25.452358,82.859342,81,5.5);
 INSERT INTO airport VALUES ('DIU','Diu Airport','IND','Daman','Daman and Diu',NULL,20.7131,70.9211,9,5.5);
 INSERT INTO airport VALUES ('VTZ','Visakhapatnam','IND','Visakhapatnam','Andhra Pradesh',NULL,17.721167,83.224483,5,5.5);
 INSERT INTO airport VALUES ('NAG','Dr Ambedkar Intl','IND','Nagpur','Maharashtra',NULL,21.092192,79.047183,315,5.5);
 INSERT INTO airport VALUES ('GOP','Gorakhpur Airport','IND','Gorakhpur','Uttar Pradesh',NULL,26.739708,83.449708,79,5.5);
 INSERT INTO airport VALUES ('GAU','Lokpriya Gopinath Bordoloi International Airport','IND','Gauhati','Assam',NULL,26.106092,91.585939,49,5.5);
 INSERT INTO airport VALUES ('PNQ','Pune','IND','Pune','Maharashtra',NULL,18.582111,73.919697,592,5.5);
 INSERT INTO airport VALUES ('GOI','Goa','IND','Panaji','Goa',NULL,15.380833,73.831422,56,5.5);
 INSERT INTO airport VALUES ('IMF','Imphal','IND','Imphal','Manipur',NULL,24.75995,93.896697,774,5.5);
 INSERT INTO airport VALUES ('IDR','Devi Ahilyabai Holkar','IND','Indore','Madhya Pradesh',NULL,22.721786,75.801086,564,5.5);
 INSERT INTO airport VALUES ('RAJ','Rajkot','IND','Rajkot','Gujarat',NULL,22.309183,70.779525,134,5.5);
 INSERT INTO airport VALUES ('HYD','Hyderabad','IND','Hyderabad','Telangana',NULL,17.453117,78.467586,531,5.5);
 INSERT INTO airport VALUES ('RPR','Raipur','IND','Raipur','Chhattisgarh',NULL,21.180406,81.738753,317,5.5);
 INSERT INTO airport VALUES ('JLR','Jabalpur','IND','Jabalpur','Madhya Pradesh',NULL,23.177817,80.052047,495,5.5);
 INSERT INTO airport VALUES ('RJA','Rajahmundry','IND','Rajahmundry','Andhra Pradesh',NULL,17.110361,81.818208,46,5.5);
 INSERT INTO airport VALUES ('JGA','Jamnagar','IND','Jamnagar','Gujarat',NULL,22.465522,70.012556,21,5.5);
 INSERT INTO airport VALUES ('JDH','Jodhpur','IND','Jodhpur','Rajasthan',NULL,26.251092,73.048869,219,5.5);
 INSERT INTO airport VALUES ('JAI','Jaipur','IND','Jaipur','Rajasthan',NULL,26.824192,75.812161,385,5.5);
 INSERT INTO airport VALUES ('IXZ','Port Blair','IND','Port Blair','Andaman and Nicobar Islands','South Andaman Island',11.641161,92.729744,4,5.5);
 INSERT INTO airport VALUES ('IXR','Birsa Munda','IND','Ranchi','Jharkhand',NULL,23.31425,85.321675,655,5.5);
 INSERT INTO airport VALUES ('IXU','Aurangabad','IND','Aurangabad','Maharashtra',NULL,19.862728,75.398114,583,5.5);
 INSERT INTO airport VALUES ('IXC','Chandigarh','IND','Chandigarh','Chandigarh',NULL,30.673469,76.788542,309,5.5);
 INSERT INTO airport VALUES ('IXA','Agartala','IND','Agartala','Tripura',NULL,23.886978,91.24045,14,5.5);
 INSERT INTO airport VALUES ('IXM','Madurai','IND','Madurai','Tamil Nadu',NULL,9.834508,78.093378,140,5.5);
 INSERT INTO airport VALUES ('IXJ','Jammu','IND','Jammu','Jammu and Kashmir',NULL,32.689142,74.837389,314,5.5);
 INSERT INTO airport VALUES ('ATQ','Amritsar','IND','Amritsar','Punjab',NULL,31.709594,74.797264,230,5.5);
 INSERT INTO airport VALUES ('MAA','Chennai Intl','IND','Chennai','Tamil Nadu',NULL,12.994414,80.180517,16,5.5);
 INSERT INTO airport VALUES ('BOM','Chhatrapati Shivaji Intl','IND','Mumbai','Maharashtra',NULL,19.088686,72.867919,11,5.5);
 INSERT INTO airport VALUES ('AMD','Ahmedabad','IND','Ahmadabad','Gujarat',NULL,23.077242,72.63465,58,5.5);
 INSERT INTO airport VALUES ('IXD','Allahabad','IND','Allahabad','Uttar Pradesh',NULL,25.440064,81.733872,98,5.5);
 INSERT INTO airport VALUES ('BDJ','Syamsudin Noor','RI','Bandjarmasin','Kalimantan Selatan','Borneo',-3.442356,114.762553,20,8);
 INSERT INTO airport VALUES ('KDI','Wolter Monginsidi','RI','Kendari','Sulawesi Tenggara','Sulawesi',-4.081608,122.418231,164,8);
 INSERT INTO airport VALUES ('TKG','Radin Inten II (Branti) Airport','RI','Bandar Lampung','Lampung','Sumatra',-5.242339,105.178939,86,7);
 INSERT INTO airport VALUES ('BTH','Hang Nadim','RI','Batam','Kepulauan Riau','Batam',1.121028,104.118753,38,7);
 INSERT INTO airport VALUES ('KOE','El Tari','RI','Kupang','Nusa Tenggara Timur','Timor',-10.171583,123.671136,102,8);
 INSERT INTO airport VALUES ('TTE','Sultan Babullah','RI','Ternate','Maluku Utara','Ternate',.831414,127.381486,15,9);
 INSERT INTO airport VALUES ('BKS','Fatmawati Soekarno','RI','Bengkulu','Bengkulu','Sumatra',-3.8637,102.339036,15,7);
 INSERT INTO airport VALUES ('AMQ','Pattimura','RI','Ambon','Maluku','Ambon',-3.710264,128.089136,10,9);
 INSERT INTO airport VALUES ('BPN','Sepinggan','RI','Balikpapan','Kalimantan Timur','Borneo',-1.268272,116.894478,4,8);
 INSERT INTO airport VALUES ('MLG','Abdul Rachman Saleh','RI','Malang','Jawa Timur','Java',-7.926556,112.714514,526,7);
 INSERT INTO airport VALUES ('MDC','Sam Ratulangi','RI','Manado','Sulawesi Utara','Sulawesi',1.549447,124.925878,80,8);
 INSERT INTO airport VALUES ('DJJ','Sentani','RI','Jayapura','Papua','New Guinea',-2.576953,140.516372,88,9);
 INSERT INTO airport VALUES ('LOP','Lombok International Airport','RI','Mataram','Nusa Tenggara Barat','Lombok',-8.7573222,116.276675,16,8);
 INSERT INTO airport VALUES ('SRG','Achmad Yani','RI','Semarang','Jawa Tengah','Java',-6.971447,110.374122,4,7);
 INSERT INTO airport VALUES ('DJB','Sultan Thaha','RI','Jambi','Jambi','Sumatra',-1.638017,103.644378,25,7);
 INSERT INTO airport VALUES ('CGK','Soekarno Hatta Intl','RI','Jakarta','DKI Jakarta','Java',-6.125567,106.655897,10,7);
 INSERT INTO airport VALUES ('BDO','Husein Sastranegara','RI','Bandung','Jawa Barat','Java',-6.900625,107.576294,743,7);
 INSERT INTO airport VALUES ('UPG','Hasanuddin','RI','Makassar','Sulawesi Selatan','Sulawesi',-5.061631,119.554042,14,8);
 INSERT INTO airport VALUES ('DPS','Bali Ngurah Rai','RI','Denpasar','Bali','Bali',-8.748169,115.167172,4,8);
 INSERT INTO airport VALUES ('PLW','Mutiara','RI','Palu','Sulawesi Tengah','Sulawesi',-0.918542,119.909642,87,8);
 INSERT INTO airport VALUES ('PGK','Depati Amir','RI','Pangkal Pinang','Kepulauan Bangka Belitung','Bangka',-2.1622,106.139064,33,7);
 INSERT INTO airport VALUES ('PKY','Tjilik Riwut','RI','Palangkaraya','Kalimantan Tengah','Borneo',-2.225128,113.942661,25,7);
 INSERT INTO airport VALUES ('PLM','Sultan Mahmud Badaruddin Ii','RI','Palembang','Sumatera Selatan','Sumatra',-2.89825,104.699903,15,7);
 INSERT INTO airport VALUES ('GTO','Jalaluddin','RI','Gorontalo','Gorontalo','Sulawesi',.637119,122.849858,32,8);
 INSERT INTO airport VALUES ('PNK','Supadio','RI','Pontianak','Kalimantan Barat','Borneo',-0.150711,109.403892,3,7);
 INSERT INTO airport VALUES ('PKU','Sultan Syarif Kasim Ii','RI','Pekanbaru','Riau','Sumatra',.460786,101.444539,31,7);
 INSERT INTO airport VALUES ('PDG','Tabing','RI','Padang','Sumatera Barat','Sumatra',-0.874989,100.351881,3,7);
 INSERT INTO airport VALUES ('JOG','Adi Sutjipto','RI','Yogyakarta','DI Yogyakarta','Java',-7.788181,110.431758,107,7);
 INSERT INTO airport VALUES ('BTJ','Sultan Iskandarmuda','RI','Banda Aceh','Aceh','Sumatra',5.523522,95.420372,20,7);
 INSERT INTO airport VALUES ('MES','Polonia','RI','Medan','Sumatera Utara','Sumatra',3.558056,98.671722,35,7);
 INSERT INTO airport VALUES ('SUB','Juanda','RI','Surabaya','Jawa Timur','Java',-7.379831,112.786858,3,7);
 INSERT INTO airport VALUES ('AWZ','Ahwaz','IR','Ahvaz','Khuzestan',NULL,31.337431,48.76195,20,3.5);
 INSERT INTO airport VALUES ('ABD','Abadan','IR','Abadan','Khuzestan',NULL,30.371111,48.228333,6,3.5);
 INSERT INTO airport VALUES ('SYZ','Shiraz Shahid Dastghaib Intl','IR','Shiraz','Fars',NULL,29.539242,52.589786,1500,3.5);
 INSERT INTO airport VALUES ('IFN','Esfahan Shahid Beheshti Intl','IR','Esfahan','Esfahan',NULL,32.750836,51.861267,1542,3.5);
 INSERT INTO airport VALUES ('IKA','Imam Khomeini','IR','Tehran','Tehran',NULL,35,51,1008,3.5);
 INSERT INTO airport VALUES ('BUZ','Bushehr','IR','Bushehr','Bushehr',NULL,28.944811,50.834637,21,3.5);
 INSERT INTO airport VALUES ('MHD','Mashhad','IR','Mashhad','Khorasan-e-Razavi',NULL,36,59,995,3.5);
 INSERT INTO airport VALUES ('TBZ','Tabriz Intl','IR','Tabriz','East Azarbayejan',NULL,38.133889,46.235,1359,3.5);
 INSERT INTO airport VALUES ('BND','Bandar Abbas Intl','IR','Bandar Abbas','Hormozgan',NULL,27.218317,56.37785,7,3.5);
 INSERT INTO airport VALUES ('NJF','Al Najaf International Airport','IRQ','An Najaf','al-Najaf',NULL,31.991667,44.404167,152,3);
 INSERT INTO airport VALUES ('BSR','Basrah Intl','IRQ','Al Basrah','Basrah',NULL,30.549069,47.662142,3,3);
 INSERT INTO airport VALUES ('EBL','Erbil Intl','IRQ','Erbil','Erbil',NULL,36.237611,43.963158,409,3);
 INSERT INTO airport VALUES ('BGW','Baghdad International Airport','IRQ','Baghdad','Baghdad',NULL,33.262539,44.234578,35,3);
 INSERT INTO airport VALUES ('ISU','Sulaymaniyah International Airport','IRQ','As Sulaymaniyah','As Sulaymaniyah',NULL,35.5608,45.3147,760,3);
 INSERT INTO airport VALUES ('SNN','Shannon','IRL','Limerick','Ireland','Ireland',52.701978,-8.924817,14,0);
 INSERT INTO airport VALUES ('ORK','Cork','IRL','Cork','Ireland','Ireland',51.841269,-8.491111,153,0);
 INSERT INTO airport VALUES ('DUB','Dublin','IRL','Dublin','Ireland','Ireland',53.421333,-6.270075,74,0);
 INSERT INTO airport VALUES ('IOM','Isle Of Man','GBM','Douglas','Isle of Man','Isle of Man',54.083333,-4.623889,16,0);
 INSERT INTO airport VALUES ('TLV','Ben Gurion','IL','Tel Aviv-Yafo','Tel Aviv',NULL,32.011389,34.886667,41,2);
 INSERT INTO airport VALUES ('MXP','Malpensa','I','Milano','Lombardia',NULL,45.630606,8.728111,234,1);
 INSERT INTO airport VALUES ('FLR','Firenze','I','Firenze','Toscana',NULL,43.809953,11.2051,43,1);
 INSERT INTO airport VALUES ('PMF','Parma','I','Parma','Emilia-Romagna',NULL,44.824483,10.296367,49,1);
 INSERT INTO airport VALUES ('PMO','Palermo','I','Palermo','Sicilia','Sicilia',38.175958,13.091019,20,1);
 INSERT INTO airport VALUES ('PEG','Perugia','I','Perúgia','Umbria',NULL,43.095906,12.513222,211,1);
 INSERT INTO airport VALUES ('GOA','Genova Sestri','I','Génova','Liguria',NULL,44.413333,8.8375,4,1);
 INSERT INTO airport VALUES ('PSA','Pisa','I','Pisa','Toscana',NULL,43.683917,10.39275,2,1);
 INSERT INTO airport VALUES ('PSR','Pescara','I','Pescara','Abruzzo',NULL,42.431656,14.181067,15,1);
 INSERT INTO airport VALUES ('AOI','Falconara','I','Ancona','Marche',NULL,43.616389,13.362222,3,1);
 INSERT INTO airport VALUES ('BRI','Bari','I','Bari','Puglia',NULL,41.138856,16.760594,54,1);
 INSERT INTO airport VALUES ('CAG','Elmas','I','Cágliari','Sardegna','Sardegna',39.251469,9.054283,4,1);
 INSERT INTO airport VALUES ('BZO','Bolzano','I','Bolzano','Trentino-Alto Adige',NULL,46.460194,11.326383,241,1);
 INSERT INTO airport VALUES ('REG','Reggio Calabria','I','Réggio di Calabria','Calabria',NULL,38.071206,15.651556,29,1);
 INSERT INTO airport VALUES ('RMI','Rimini','I','Rímini','Emilia-Romagna',NULL,44.020292,12.611747,13,1);
 INSERT INTO airport VALUES ('NAP','Capodichino','I','Nápoli','Campania',NULL,40.886033,14.290781,90,1);
 INSERT INTO airport VALUES ('VRN','Villafranca','I','Verona','Veneto',NULL,45.395706,10.888533,73,1);
 INSERT INTO airport VALUES ('FCO','Fiumicino','I','Roma','Lazio',NULL,41.804475,12.250797,5,1);
 INSERT INTO airport VALUES ('VCE','Venezia Tessera','I','Venézia','Veneto',NULL,45.505278,12.351944,2,1);
 INSERT INTO airport VALUES ('BGY','Bergamo Orio Al Serio','I','Bérgamo','Lombardia',NULL,45.673889,9.704166,238,1);
 INSERT INTO airport VALUES ('TRN','Torino','I','Torino','Piemonte',NULL,45.200761,7.649631,302,1);
 INSERT INTO airport VALUES ('TRS','Ronchi Dei Legionari','I','Trieste','Friuli-Venezia Giulia',NULL,45.8275,13.472222,11,1);
 INSERT INTO airport VALUES ('BLQ','Bologna','I','Bologna','Emilia-Romagna',NULL,44.535444,11.288667,38,1);
 INSERT INTO airport VALUES ('CTA','Catania Fontanarossa','I','Catánia','Sicilia','Sicilia',37.466781,15.0664,12,1);
 INSERT INTO airport VALUES ('LMP','Lampedusa','I',NULL,NULL,'Lampedusa',35.497914,12.618083,21,1);
 INSERT INTO airport VALUES ('CIA','Ciampino','I','Roma','Lazio',NULL,41.799361,12.594936,130,1);
 INSERT INTO airport VALUES ('LIN','Linate','I','Milano','Lombardia',NULL,45.445103,9.276739,108,1);
 INSERT INTO airport VALUES ('KIN','Norman Manley Intl','JA','Kingston','Jamaica','Jamaica',17.935667,-76.7875,3,-5);
 INSERT INTO airport VALUES ('OKJ','Okayama','J','Okayama','Okayama','Honshu',34.756944,133.855278,246,9);
 INSERT INTO airport VALUES ('OKA','Naha','J','Naha','Okinawa','Okinawa',26.195814,127.645869,4,9);
 INSERT INTO airport VALUES ('OIT','Oita','J','Oita','Oita','Kyushu',33.479444,131.737222,6,9);
 INSERT INTO airport VALUES ('GAJ','Yamagata','J','Yamagata','Yamagata','Honshu',38.411894,140.371331,108,9);
 INSERT INTO airport VALUES ('FUK','Fukuoka','J','Fukuoka','Fukuoka','Kyushu',33.585942,130.450686,10,9);
 INSERT INTO airport VALUES ('FKS','Fukushima Airport','J','Fukushima','Fukushima','Honshu',37.2274,140.431,372,9);
 INSERT INTO airport VALUES ('HIJ','Hiroshima','J','Hiroshima','Hiroshima','Honshu',34.436111,132.919444,332,9);
 INSERT INTO airport VALUES ('HND','Tokyo Intl','J','Tokyo','Tokyo','Honshu',35.552258,139.779694,11,9);
 INSERT INTO airport VALUES ('HKD','Hakodate','J','Hakodate','Hokkaido','Hokkaido',41.77,140.821944,46,9);
 INSERT INTO airport VALUES ('HSG','Saga Airport','J','Saga','Saga','Kyushu',33.1497,130.302,2,9);
 INSERT INTO airport VALUES ('ITM','Osaka Intl','J','Osaka','Osaka','Honshu',34.785528,135.438222,15,9);
 INSERT INTO airport VALUES ('AXT','Akita','J','Akita','Akita','Honshu',39.615556,140.218611,95,9);
 INSERT INTO airport VALUES ('TOY','Toyama','J','Toyama','Toyama','Honshu',36.648333,137.1875,29,9);
 INSERT INTO airport VALUES ('AOJ','Aomori','J','Aomori','Aomori','Honshu',40.734722,140.690833,202,9);
 INSERT INTO airport VALUES ('CTS','New Chitose','J','Sapporo','Hokkaido','Hokkaido',42.7752,141.692283,25,9);
 INSERT INTO airport VALUES ('TAK','Takamatsu','J','Takamatsu','Kagawa','Shikoku',34.214167,134.015556,185,9);
 INSERT INTO airport VALUES ('SDJ','Sendai','J','Sendai','Miyagi','Honshu',38.139722,140.916944,5,9);
 INSERT INTO airport VALUES ('KIX','Kansai','J','Osaka','Osaka','Honshu',34.4347222,135.244167,15,9);
 INSERT INTO airport VALUES ('KIJ','Niigata','J','Niigata','Niigata','Honshu',37.5711,139.0646,2,9);
 INSERT INTO airport VALUES ('KOJ','Kagoshima','J','Kagoshima','Kagoshima','Kyushu',31.803397,130.719408,276,9);
 INSERT INTO airport VALUES ('TTJ','Tottori','J','Tottori','Tottori','Honshu',35.530069,134.166553,20,9);
 INSERT INTO airport VALUES ('KMI','Miyazaki','J','Miyazaki','Miyazaki','Kyushu',31.877222,131.448611,6,9);
 INSERT INTO airport VALUES ('KMQ','Komatsu','J','Kanazawa','Ishikawa','Honshu',36.394611,136.406544,11,9);
 INSERT INTO airport VALUES ('KMJ','Kumamoto','J','Kumamoto','Kumamoto','Kyushu',32.837319,130.85505,196,9);
 INSERT INTO airport VALUES ('TKS','Tokushima','J','Tokushima','Tokushima','Shikoku',34.132808,134.606639,8,9);
 INSERT INTO airport VALUES ('KCZ','Kochi','J','Kochi','Kochi','Shikoku',33.546111,133.669444,13,9);
 INSERT INTO airport VALUES ('KKJ','New Kitakyushu','J','Kitakyushu','Fukuoka','Kyushu',33.845942,131.034689,6,9);
 INSERT INTO airport VALUES ('NGO','Chubu Centrair Intl','J','Nagoya','Aichi','Honshu',34.858414,136.805408,5,9);
 INSERT INTO airport VALUES ('NGS','Nagasaki','J','Nagasaki','Nagasaki','Kyushu',32.916944,129.913611,5,9);
 INSERT INTO airport VALUES ('UKB','Kobe','J','Kobe','Hyogo','Honshu',34.632778,135.223889,7,9);
 INSERT INTO airport VALUES ('NRT','Narita Intl','J','Tokyo','Tokyo','Honshu',35.764722,140.386389,43,9);
 INSERT INTO airport VALUES ('UBJ','Yamaguchi Ube','J','Yamaguchi','Yamaguchi','Honshu',33.93,131.278611,7,9);
 INSERT INTO airport VALUES ('MYJ','Matsuyama','J','Matsuyama','Ehime','Shikoku',33.827222,132.699722,8,9);
 INSERT INTO airport VALUES ('FSZ','Mt. Fuji Shizuoka Airport','J','Shizuoka','Shizuoka','Honshu',34.796111,138.189444,132,9);
 INSERT INTO airport VALUES ('JER','Jersey','GBJ','Saint Helier','Jersey','Jersey',49.207947,-2.195508,84,0);
 INSERT INTO airport VALUES ('AMM','Queen Alia Intl','JOR','Amman','Jordan',NULL,31.722556,35.993214,730,2);
 INSERT INTO airport VALUES ('PLX','Semipalatinsk','KAZ','Semei','East-Kazakhstan',NULL,50.3513,80.2344,232,6);
 INSERT INTO airport VALUES ('URA','Uralsk','KAZ','Oral','West Kazakhstan',NULL,51.150833,51.543056,38,5);
 INSERT INTO airport VALUES ('GUW','Atyrau','KAZ','Atyrau','Atyrau',NULL,47.121944,51.821389,-22,5);
 INSERT INTO airport VALUES ('SCO','Aktau','KAZ','Aktau','Mangistau',NULL,43.513557,51.052817,6,5);
 INSERT INTO airport VALUES ('DZN','Zhezkazgan Airport','KAZ','Zhezkazgan','Karaganda',NULL,47.708333,67.733333,381,6);
 INSERT INTO airport VALUES ('KSN','Kostanay West Airport','KAZ','Kustanay','Kostanai',NULL,53.206944,63.550278,181,6);
 INSERT INTO airport VALUES ('UKK','Ust Kamenogorsk Airport','KAZ','Öskemen','East-Kazakhstan',NULL,50.0366,82.4942,286,6);
 INSERT INTO airport VALUES ('CIT','Shymkent','KAZ','Shymkent','South-Kazakhstan',NULL,42.364167,69.478889,422,6);
 INSERT INTO airport VALUES ('AKX','Aktyubinsk','KAZ','Aqtobe','Aktobe',NULL,50.245833,57.206667,225,5);
 INSERT INTO airport VALUES ('ALA','Almaty','KAZ','Almaty','Almaty City',NULL,43.352072,77.040508,681,6);
 INSERT INTO airport VALUES ('TSE','Astana Intl','KAZ','Astana','Astana',NULL,51.022222,71.466944,355,6);
 INSERT INTO airport VALUES ('KGF','Sary-Arka','KAZ','Karaganda','Karaganda',NULL,49.670833,73.334444,538,6);
 INSERT INTO airport VALUES ('PWQ','Pavlodar','KAZ','Pavlodar','Pavlodar',NULL,52.195,77.073889,125,6);
 INSERT INTO airport VALUES ('KZO','Kzylorda','KAZ','Kyzylorda','Kyzylorda',NULL,44.709,65.591,131,6);
 INSERT INTO airport VALUES ('MYD','Malindi Airport','EAK','Malindi','Kenya',NULL,-3.22931,40.1017,24,3);
 INSERT INTO airport VALUES ('MBA','Mombasa Moi Intl','EAK','Mombasa','Kenya',NULL,-4.034833,39.59425,61,3);
 INSERT INTO airport VALUES ('NBO','Jomo Kenyatta International','EAK','Nairobi','Kenya',NULL,-1.319167,36.9275,1624,3);
 INSERT INTO airport VALUES ('WIL','Nairobi Wilson','EAK','Nairobi','Kenya',NULL,-1.321719,36.814833,1691,3);
 INSERT INTO airport VALUES ('KIS','Kisumu','EAK','Kisumu','Kenya',NULL,-0.086139,34.728892,1157,3);
 INSERT INTO airport VALUES ('EDL','Eldoret Intl','EAK','Eldoret','Kenya',NULL,.404458,35.238928,2116,3);
 INSERT INTO airport VALUES ('TRW','Bonriki Intl','KIR','Tarawa','Kiribati','Tarawa',1.3817,-173.1442,3,14);
 INSERT INTO airport VALUES ('KWI','Kuwait Intl','KWT','Al Kuwayt','Kuwait',NULL,29.226567,47.968928,63,3);
 INSERT INTO airport VALUES ('FRU','Manas','KGZ','Bishkek','Kyrgyzstan',NULL,43.061306,74.477556,627,5);
 INSERT INTO airport VALUES ('OSS','Osh','KGZ','Osh','Kyrgyzstan',NULL,40.608989,72.793269,892,5);
 INSERT INTO airport VALUES ('VTE','Wattay Intl','LAO','Vientiane','Laos',NULL,17.988322,102.563256,172,7);
 INSERT INTO airport VALUES ('RIX','Riga Intl','LV','Rīga','Latvia',NULL,56.923611,23.971111,10,2);
 INSERT INTO airport VALUES ('BEY','Rafic Hariri Intl','RL','Bayrūt','Lebanon',NULL,33.820931,35.488389,27,2);
 INSERT INTO airport VALUES ('MSU','Moshoeshoe I Intl','LS','Maseru','Lesotho',NULL,-29.462256,27.552503,1630,2);
 INSERT INTO airport VALUES ('ROB','Monrovia Roberts Intl','LB','Monrovia','Liberia',NULL,6.233789,-10.362311,9,0);
 INSERT INTO airport VALUES ('BEN','Benina','LAR','Benghazi','Libya',NULL,32.096786,20.269472,132,1);
 INSERT INTO airport VALUES ('MRA','Misratah Airport','LAR','Misratah','Libya',NULL,32.325,15.061,18,1);
 INSERT INTO airport VALUES ('TIP','Tripoli Intl','LAR','Tripoli','Libya',NULL,32.663544,13.159011,80,1);
 INSERT INTO airport VALUES ('KUN','Kaunas Intl','LT','Kaunas','Lithuania',NULL,54.963919,24.084778,78,2);
 INSERT INTO airport VALUES ('VNO','Vilnius Intl','LT','Vilnius','Lithuania',NULL,54.634133,25.285767,197,2);
 INSERT INTO airport VALUES ('LUX','Luxembourg','L','Luxembourg','Luxembourg',NULL,49.626575,6.211517,376,1);
 INSERT INTO airport VALUES ('MFM','Macao Intl','MACX','Macao','Macao',NULL,22.149556,113.591558,6,8);
 INSERT INTO airport VALUES ('SKP','Skopje','MK','Skopje','Macedonia',NULL,41.961622,21.621381,238,1);
 INSERT INTO airport VALUES ('DIE','Arrachart','RM','Antsiranana','Madagascar','Madagaskar',-12.3494,49.291747,114,3);
 INSERT INTO airport VALUES ('TLE','Toliara','RM','Toliara','Madagascar','Madagaskar',-23.383369,43.728453,9,3);
 INSERT INTO airport VALUES ('TNR','Ivato','RM','Antananarivo','Madagascar','Madagaskar',-18.79695,47.478806,1280,3);
 INSERT INTO airport VALUES ('TMM','Toamasina','RM','Tamatave','Madagascar','Madagaskar',-18.109517,49.392536,7,3);
 INSERT INTO airport VALUES ('BLZ','Chileka Intl','MW','Blantyre','Malawi',NULL,-15.679053,34.974014,779,2);
 INSERT INTO airport VALUES ('LLW','Kamuzu Intl','MW','Lilongwe','Malawi',NULL,-13.789378,33.781,1230,2);
 INSERT INTO airport VALUES ('PEN','Penang Intl','MAL','Georgetown','Pulau Pinang',NULL,5.297139,100.276864,3,8);
 INSERT INTO airport VALUES ('TGG','Sultan Mahmud','MAL','Kuala Terengganu','Terengganu',NULL,5.382639,103.10336,6,8);
 INSERT INTO airport VALUES ('SDK','Sandakan','MAL','Sandakan','Sabah','Borneo',5.900897,118.059486,14,8);
 INSERT INTO airport VALUES ('BKI','Kota Kinabalu Intl','MAL','Kota Kinabalu','Sabah','Borneo',5.937208,116.051181,3,8);
 INSERT INTO airport VALUES ('JHB','Sultan Ismail','MAL','Johor Bahru','Johor',NULL,1.641308,103.669619,41,8);
 INSERT INTO airport VALUES ('KCH','Kuching Intl','MAL','Kuching Utara','Sarawak','Borneo',1.484697,110.346933,27,8);
 INSERT INTO airport VALUES ('IPH','Sultan Azlan Shah','MAL','Ipoh','Perak',NULL,4.567972,101.092194,40,8);
 INSERT INTO airport VALUES ('KBR','Sultan Ismail Petra','MAL','Kota Bahru','Kelantan',NULL,6.16685,102.293014,5,8);
 INSERT INTO airport VALUES ('SZB','Sultan Abdul Aziz Shah Intl','MAL','Kuala Lumpur','Kuala Lumpur',NULL,3.130583,101.549333,27,8);
 INSERT INTO airport VALUES ('KUA','Kuantan','MAL','Kuantan','Pahang',NULL,3.775389,103.209056,18,8);
 INSERT INTO airport VALUES ('KUL','Kuala Lumpur Intl','MAL','Kuala Lumpur','Kuala Lumpur',NULL,2.745578,101.709917,21,8);
 INSERT INTO airport VALUES ('LBU','Labuan','MAL','Labuan','Labuan','Labuan',5.300683,115.250181,31,8);
 INSERT INTO airport VALUES ('MLE','Male Intl','MV','Male','Maldives','Male',4.191833,73.529128,2,5);
 INSERT INTO airport VALUES ('BKO','Senou','RMM','Bamako','Bamako',NULL,12.533544,-7.949944,380,0);
 INSERT INTO airport VALUES ('MLA','Luqa','M','Valletta','Malta','Malta',35.857497,14.4775,91,1);
 INSERT INTO airport VALUES ('MAJ','Marshall Islands Intl','MH','Majuro','Marshall Islands','Majuro',7.064758,171.272022,2,12);
 INSERT INTO airport VALUES ('FDF','Le Lamentin','MART','Fort-de-France','Martinique','Martinique',14.591033,-61.003175,5,-4);
 INSERT INTO airport VALUES ('NKC','Nouakchott','RIM','Nouakchott','Nouakchott',NULL,18.097856,-15.947956,2,0);
 INSERT INTO airport VALUES ('NDB','Nouadhibou','RIM','Nouadhibou','Dakhlet Nouadhibou',NULL,20.933067,-17.029956,5,0);
 INSERT INTO airport VALUES ('MRU','Sir Seewoosagur Ramgoolam Intl','MS','Port Louis','Mauritius','Mauritius',-20.430235,57.6836,57,5);
 INSERT INTO airport VALUES ('DZA','Dzaoudzi Pamandzi','MAYO','Mamoutzou','Mayotte','Mayotte',-12.804722,45.281113,7,3);
 INSERT INTO airport VALUES ('MAM','General Servando Canales Intl','MEX','Matamoros','Tamaulipas',NULL,25.769894,-97.525311,8,-6);
 INSERT INTO airport VALUES ('CPE','Ingeniero Alberto Acuna Ongay Intl','MEX','Campeche','Campeche',NULL,19.816794,-90.500314,10,-6);
 INSERT INTO airport VALUES ('CLQ','Colima','MEX','Colima','Colima',NULL,19.277011,-103.577397,752,-6);
 INSERT INTO airport VALUES ('UPN','Licenciado Y Gen Ignacio Lopez Rayon','MEX','Uruapan','Michoacán',NULL,19.396692,-102.039056,1603,-6);
 INSERT INTO airport VALUES ('TGZ','Angel Albino Corzo','MEX','Tuxtla Gutiérrez','Chiapas',NULL,16.561822,-93.026081,455,-6);
 INSERT INTO airport VALUES ('TIJ','General Abelardo L Rodriguez Intl','MEX','Tijuana','Baja California',NULL,32.541064,-116.970158,149,-8);
 INSERT INTO airport VALUES ('VER','General Heriberto Jara Intl','MEX','Veracruz','Veracruz',NULL,19.145931,-96.187267,27,-6);
 INSERT INTO airport VALUES ('NLD','Quetzalcoatl Intl','MEX','Nuevo Laredo','Tamaulipas',NULL,27.443918,-99.57046,148,-6);
 INSERT INTO airport VALUES ('MID','Licenciado Manuel Crescencio Rejon Int','MEX','Mérida','Yucatán',NULL,20.936981,-89.657672,12,-6);
 INSERT INTO airport VALUES ('MTY','General Mariano Escobedo Intl','MEX','Monterrey','Nuevo Léon',NULL,25.778489,-100.106878,390,-6);
 INSERT INTO airport VALUES ('MTT','Minatitlan','MEX','Minatitlán','Veracruz',NULL,18.103419,-94.580681,11,-6);
 INSERT INTO airport VALUES ('VSA','C P A Carlos Rovirosa Intl','MEX','Villahermosa','Tabasco',NULL,17.997,-92.817361,14,-6);
 INSERT INTO airport VALUES ('MXL','General Rodolfo Sanchez Taboada Intl','MEX','Mexicali','Baja California',NULL,32.630634,-115.241637,23,-8);
 INSERT INTO airport VALUES ('PBC','Hermanos Serdan Intl','MEX','Puebla','Puebla',NULL,19.158144,-98.371447,2244,-6);
 INSERT INTO airport VALUES ('ZCL','General Leobardo C Ruiz Intl','MEX','Zacatecas','Zacatecas',NULL,22.897112,-102.68689,2177,-6);
 INSERT INTO airport VALUES ('JAL','Lencero Airport','MEX','Xalapa-Enríquez','Veracruz',NULL,19.475083,-96.797506,953,-6);
 INSERT INTO airport VALUES ('QRO','Queretaro Intercontinental','MEX','Querétaro','Querétaro',NULL,20.617289,-100.185658,1920,-6);
 INSERT INTO airport VALUES ('TLC','Licenciado Adolfo Lopez Mateos Intl','MEX','Toluca','México, Estado de',NULL,19.337072,-99.566008,2581,-6);
 INSERT INTO airport VALUES ('TPQ','Tepic','MEX','Tepic','Nayarit',NULL,21.419453,-104.842581,921,-6);
 INSERT INTO airport VALUES ('CVM','General Pedro Jose Mendez Intl','MEX','Ciudad Victoria','Tamaulipas',NULL,23.703336,-98.956486,232,-6);
 INSERT INTO airport VALUES ('SLP','Ponciano Arriaga Intl','MEX','San Luis Potosí','San Luis Potosí',NULL,22.254303,-100.930806,1840,-6);
 INSERT INTO airport VALUES ('MLM','General Francisco J Mujica Intl','MEX','Morelia','Michoacán',NULL,19.849944,-101.0255,1839,-6);
 INSERT INTO airport VALUES ('DGO','Durango Intl','MEX','Durango','Durango',NULL,24.124194,-104.528014,1861,-6);
 INSERT INTO airport VALUES ('GDL','Don Miguel Hidalgo Y Costilla Intl','MEX','Guadalajara','Jalisco',NULL,20.5218,-103.311167,1529,-6);
 INSERT INTO airport VALUES ('OAX','Xoxocotlan Intl','MEX','Oaxaca','Oaxaca',NULL,16.999906,-96.726639,1521,-6);
 INSERT INTO airport VALUES ('HMO','General Ignacio P Garcia Intl','MEX','Hermosillo','Sonora',NULL,29.095858,-111.047858,191,-7);
 INSERT INTO airport VALUES ('REX','General Lucio Blanco Intl','MEX','Reynosa','Tamaulipas',NULL,26.008908,-98.228513,42,-6);
 INSERT INTO airport VALUES ('MEX','Licenciado Benito Juarez Intl','MEX','Ciudad de México','Distrito Federal',NULL,19.436303,-99.072097,2230,-6);
 INSERT INTO airport VALUES ('MZT','General Rafael Buelna Intl','MEX','Mazatlán','Sinaloa',NULL,23.161356,-106.266072,12,-7);
 INSERT INTO airport VALUES ('CUU','General R Fierro Villalobos Intl','MEX','Chihuahua','Chihuahua',NULL,28.702875,-105.964567,1360,-6);
 INSERT INTO airport VALUES ('CUN','Cancun Intl','MEX','Cancún','Quintana Roo',NULL,21.036528,-86.877083,6,-5);
 INSERT INTO airport VALUES ('CTM','Chetumal Intl','MEX','Chetumal','Quintana Roo',NULL,18.504667,-88.326847,12,-5);
 INSERT INTO airport VALUES ('CUL','Culiacan Intl','MEX','Culiacán','Sinaloa',NULL,24.764547,-107.474717,33,-7);
 INSERT INTO airport VALUES ('TAP','Tapachula Intl','MEX','Tapachula','Chiapas',NULL,14.794339,-92.370025,30,-6);
 INSERT INTO airport VALUES ('TAM','General Francisco Javier Mina Intl','MEX','Tampico','Tamaulipas',NULL,22.29645,-97.865931,24,-6);
 INSERT INTO airport VALUES ('LAP','General Manuel Marquez De Leon Intl','MEX','La Paz','Baja California Sur',NULL,24.072694,-110.362475,21,-7);
 INSERT INTO airport VALUES ('CEN','Ciudad Obregon Intl','MEX','Ciudad Obregón','Sonora',NULL,27.392639,-109.833111,63,-7);
 INSERT INTO airport VALUES ('LMM','Valle Del Fuerte Intl','MEX','Los Mochis','Sinaloa',NULL,25.685194,-109.080806,5,-7);
 INSERT INTO airport VALUES ('SLW','Plan De Guadalupe Intl','MEX','Saltillo','Coahuila',NULL,25.549497,-100.928669,1457,-6);
 INSERT INTO airport VALUES ('AGU','Jesus Teran Intl','MEX','Aguascalientes','Aguascalientes',NULL,21.705558,-102.317858,1863,-6);
 INSERT INTO airport VALUES ('TRC','Torreon Intl','MEX','Torreón','Coahuila',NULL,25.568278,-103.410583,1124,-6);
 INSERT INTO airport VALUES ('ACA','General Juan N Alvarez Intl','MEX','Acapulco','Guerrero',NULL,16.757061,-99.753953,5,-6);
 INSERT INTO airport VALUES ('PNI','Pohnpei Intl','FSM','Kolonia','Micronesia','Pohnpei',6.9851,158.208989,3,11);
 INSERT INTO airport VALUES ('KIV','Chisinau Intl','MD','Chişinău','Moldova',NULL,46.927744,28.930978,122,2);
 INSERT INTO airport VALUES ('ULN','Chinggis Khaan Intl','MNG','Ulaanbaatar','Mongolia',NULL,47.843056,106.766639,1330,8);
 INSERT INTO airport VALUES ('TGD','Podgorica','MNE','Podgorica','Montenegro',NULL,42.359392,19.251894,43,1);
 INSERT INTO airport VALUES ('MNI','John A. Osborne','MNTS','Brades','Montserrat','Montserrat',16.7914,-62.1933,168,-4);
 INSERT INTO airport VALUES ('OUD','Angads','MA','Oujda','Oriental',NULL,34.78715,-1.923986,468,0);
 INSERT INTO airport VALUES ('AGA','Inezgane','MA','Agadir','Souss Massa Daraa',NULL,30.381353,-9.546311,27,0);
 INSERT INTO airport VALUES ('TNG','Ibn Batouta','MA','Tanger','Tanger Tetouan',NULL,35.726917,-5.916889,19,0);
 INSERT INTO airport VALUES ('RAK','Menara','MA','Marrakech','Marrakech Tensift Al Haouz',NULL,31.606886,-8.0363,471,0);
 INSERT INTO airport VALUES ('CMN','Mohammed V Intl','MA','Casablanca','Grand Casablanca',NULL,33.367467,-7.589967,200,0);
 INSERT INTO airport VALUES ('AHU','Cherif El Idrissi','MA','Al Hoceima','Taza Al Hoceima Taounate',NULL,35.177103,-3.839525,29,0);
 INSERT INTO airport VALUES ('RBA','Sale','MA','Rabat','Rabat Sale Zemmour Zaer',NULL,34.051467,-6.751519,84,0);
 INSERT INTO airport VALUES ('FEZ','Saiss','MA','Fès','Fes Boulemane',NULL,33.927261,-4.977958,579,0);
 INSERT INTO airport VALUES ('VPY','Chimoio Airport','MOC','Chimoio','Manica',NULL,-19.151267,33.428958,697,2);
 INSERT INTO airport VALUES ('APL','Nampula','MOC','Nampula','Nampula',NULL,-15.105611,39.2818,440,2);
 INSERT INTO airport VALUES ('TET','Tete Chingodzi','MOC','Tete','Tete',NULL,-16.104817,33.640181,160,2);
 INSERT INTO airport VALUES ('BEW','Beira','MOC','Beira','Sofala',NULL,-19.796419,34.907556,10,2);
 INSERT INTO airport VALUES ('UEL','Quelimane','MOC','Quelimane','Zambézia',NULL,-17.8555,36.869106,11,2);
 INSERT INTO airport VALUES ('INH','Inhambane','MOC','Inhambane','Inhambane',NULL,-23.876431,35.408544,9,2);
 INSERT INTO airport VALUES ('POL','Pemba','MOC','Pemba','Cabo Delgado',NULL,-12.986753,40.522492,101,2);
 INSERT INTO airport VALUES ('MPM','Maputo','MOC','Maputo','Cidade de Maputo',NULL,-25.920836,32.572606,44,2);
 INSERT INTO airport VALUES ('VXC','Lichinga','MOC','Lichinga','Niassa',NULL,-13.273986,35.266262,1373,2);
 INSERT INTO airport VALUES ('WDH','Windhoek Hosea Kutako International Airport','NAM','Windhoek','Namibia',NULL,-22.486667,17.4625,1720,1);
 INSERT INTO airport VALUES ('KTM','Tribhuvan Intl','NEP','Kathmandu','Nepal',NULL,27.696583,85.3591,1338,5.75);
 INSERT INTO airport VALUES ('RTM','Rotterdam','NL','Rotterdam','Zuid-Holland',NULL,51.956944,4.437222,-5,1);
 INSERT INTO airport VALUES ('EIN','Eindhoven','NL','Eindhoven','Noord-Brabant',NULL,51.450139,5.374528,23,1);
 INSERT INTO airport VALUES ('MST','Maastricht','NL','Maastricht','Limburg',NULL,50.911658,5.770144,114,1);
 INSERT INTO airport VALUES ('AMS','Schiphol','NL','Amsterdam','Noord-Holland',NULL,52.308613,4.763889,-3,1);
 INSERT INTO airport VALUES ('INU','Nauru Intl','NAU','Yaren','Nauru','Nauru',-0.5475,166.9192,7,12);
 INSERT INTO airport VALUES ('NOU','La Tontouta','NCA','Noumea','New Caledonia','Grande Terre',-22.014553,166.212972,16,11);
 INSERT INTO airport VALUES ('HLZ','Hamilton','NZ','Hamilton','New Zealand','Te Ika-a-Maui (North Island)',-37.866661,175.332056,52,12);
 INSERT INTO airport VALUES ('WLG','Wellington Intl','NZ','Wellington','New Zealand','Te Ika-a-Maui (North Island)',-41.327221,174.805278,13,12);
 INSERT INTO airport VALUES ('CHC','Christchurch Intl','NZ','Christchurch','New Zealand','Te Waka-a-Maui (South Island)',-43.489358,172.532225,38,12);
 INSERT INTO airport VALUES ('AKL','Auckland Intl','NZ','Auckland','New Zealand','Te Ika-a-Maui (North Island)',-37.008056,174.791667,7,12);
 INSERT INTO airport VALUES ('DUD','Dunedin','NZ','Dunedin','New Zealand','Te Waka-a-Maui (South Island)',-45.928055,170.198333,1,12);
 INSERT INTO airport VALUES ('MGA','Managua Intl','NIC','Managua','Nicaragua',NULL,12.141494,-86.168178,59,-6);
 INSERT INTO airport VALUES ('NIM','Diori Hamani','RN','Niamey','Niamey',NULL,13.481547,2.183614,223,1);
 INSERT INTO airport VALUES ('MIU','Maiduguri','WAN','Maiduguri','Borno',NULL,11.855347,13.08095,335,1);
 INSERT INTO airport VALUES ('PHC','Port Harcourt Intl','WAN','Port Harcourt','Rivers',NULL,5.015494,6.949594,27,1);
 INSERT INTO airport VALUES ('JOS','Yakubu Gowon','WAN','Jos','Plateau',NULL,9.639828,8.86905,1290,1);
 INSERT INTO airport VALUES ('SKO','Sadiq Abubakar Iii Intl','WAN','Sokoto','Sokoto',NULL,12.916322,5.207189,308,1);
 INSERT INTO airport VALUES ('LOS','Murtala Muhammed','WAN','Lagos','Lagos',NULL,6.577369,3.321156,41,1);
 INSERT INTO airport VALUES ('BNI','Benin','WAN','Benin','Edo',NULL,6.316981,5.599503,79,1);
 INSERT INTO airport VALUES ('KAD','Kaduna','WAN','Kaduna','Kaduna',NULL,10.696025,7.320114,632,1);
 INSERT INTO airport VALUES ('KAN','Mallam Aminu Intl','WAN','Kano','Kano',NULL,12.047589,8.524622,476,1);
 INSERT INTO airport VALUES ('CBQ','Calabar','WAN','Calabar','Cross River',NULL,4.976019,8.347197,64,1);
 INSERT INTO airport VALUES ('ABV','Nnamdi Azikiwe Intl','WAN','Abuja','Abuja',NULL,9.006792,7.263172,342,1);
 INSERT INTO airport VALUES ('ENU','Enugu','WAN','Enugu','Enugu',NULL,6.474272,7.561961,142,1);
 INSERT INTO airport VALUES ('YOL','Yola','WAN','Yola','Adamawa',NULL,9.257553,12.430422,183,1);
 INSERT INTO airport VALUES ('ILR','Ilorin','WAN','Ilorin','Kwara',NULL,8.440211,4.493919,343,1);
 INSERT INTO airport VALUES ('IUE','Niue Intl','NIUE','Alofi','Niue','Niue',-19.0533,-169.9256,64,-11);
 INSERT INTO airport VALUES ('NLK','Norfolk Island Intl','NORF','Kingston','Norfolk Island','Norfolk Island',-29.041625,167.938742,113,11.5);
 INSERT INTO airport VALUES ('SPN','Francisco C Ada Saipan Intl','NMIS','Saipan','Northern Mariana Islands','Saipan',15.119003,145.729356,66,10);
 INSERT INTO airport VALUES ('FNJ','Pyongyang Sunan Int','NOK','Pyongyang','North Korea',NULL,39.2239,126.67,36,9);
 INSERT INTO airport VALUES ('SKE','Geiteryggen','N','Skien','Telemark',NULL,59.185,9.566944,141,1);
 INSERT INTO airport VALUES ('VDS','Vadsoe','N','Vadsø','Finnmark',NULL,70.065,29.844,39,1);
 INSERT INTO airport VALUES ('NVK','Framnes','N','Narvik','Nordland',NULL,68.435833,17.388056,30,1);
 INSERT INTO airport VALUES ('OSL','Gardermoen','N','Oslo','Oslo',NULL,60.193917,11.100361,208,1);
 INSERT INTO airport VALUES ('RYG','Moss','N','Moss','Østfold',NULL,59.378933,10.785389,53,1);
 INSERT INTO airport VALUES ('LYR','Longyear','SVAX','Longyearbyen','Svalbard','Svalbard',78.246111,15.465556,27,1);
 INSERT INTO airport VALUES ('MOL','Aro','N','Molde','Møre og Romsdal',NULL,62.744722,7.2625,3,1);
 INSERT INTO airport VALUES ('KRS','Kjevik','N','Kristiansand','Vest-Agder',NULL,58.204214,8.085369,17,1);
 INSERT INTO airport VALUES ('SVG','Sola','N','Stavanger','Rogaland',NULL,58.876778,5.637856,9,1);
 INSERT INTO airport VALUES ('TRD','Vaernes','N','Trondheim','Sør-Trøndelag',NULL,63.457556,10.92425,17,1);
 INSERT INTO airport VALUES ('BGO','Flesland','N','Bergen','Hordaland',NULL,60.293386,5.218142,52,1);
 INSERT INTO airport VALUES ('HFT','Hammerfest Airport','N','Hammerfest','Finnmark',NULL,70.679722,23.668889,244,1);
 INSERT INTO airport VALUES ('MCT','Seeb Intl','OM','Muscat','Oman',NULL,23.593278,58.284444,15,4);
 INSERT INTO airport VALUES ('ISB','Chaklala','PK','Islamabad','FCT Islamabad',NULL,33.616653,73.099233,509,5);
 INSERT INTO airport VALUES ('KHI','Jinnah Intl','PK','Karachi','Sindh',NULL,24.906547,67.160797,30,5);
 INSERT INTO airport VALUES ('LHE','Allama Iqbal Intl','PK','Lahore','Punjab',NULL,31.521564,74.403594,217,5);
 INSERT INTO airport VALUES ('LYP','Faisalabad Intl','PK','Faisalabad','Punjab',NULL,31.365014,72.994842,180,5);
 INSERT INTO airport VALUES ('SKZ','Sukkur','PK','Sukkur','Sindh',NULL,27.721989,68.791683,60,5);
 INSERT INTO airport VALUES ('SKT','Sialkot Airport','PK','Sialkot','Punjab',NULL,32.5356,74.3639,247,5);
 INSERT INTO airport VALUES ('RYK','Sheikh Zayed','PK','Rahimyar Khan','Punjab',NULL,28.3839,70.279572,83,5);
 INSERT INTO airport VALUES ('UET','Quetta','PK','Quetta','Balochistan',NULL,30.251369,66.937764,1606,5);
 INSERT INTO airport VALUES ('PEW','Peshawar Intl','PK','Peshawar','Khyber Pakhtunkhwa',NULL,33.993911,71.514581,353,5);
 INSERT INTO airport VALUES ('MUX','Multan Intl','PK','Multan','Punjab',NULL,30.203222,71.419111,123,5);
 INSERT INTO airport VALUES ('ROR','Babelthuap','PAL','Melekeok','Palau','Babelthuap',7.367303,134.544278,54,9);
 INSERT INTO airport VALUES ('BOC','Bocas del Toro Intl','PA','Bocas del Toro','Bocas del Toro',NULL,9.340853,-82.250842,3,-5);
 INSERT INTO airport VALUES ('PTY','Tocumen Intl','PA','Panamá City','Panamá',NULL,9.071364,-79.383453,41,-5);
 INSERT INTO airport VALUES ('POM','Port Moresby Jacksons Intl','PNG','Port Moresby','Papua New Guinea','New Guinea',-9.443383,147.22005,45,10);
 INSERT INTO airport VALUES ('AGT','Ciudad del Este','PY','Ciudad del Este','Paraguay',NULL,-25.4555,-54.843592,258,-4);
 INSERT INTO airport VALUES ('ASU','Silvio Pettirossi Intl','PY','Asunción','Paraguay',NULL,-25.23985,-57.519133,89,-4);
 INSERT INTO airport VALUES ('CIX','Capt Jose A Quinones Gonzales Intl','PE','Chiclayo','Lambayeque',NULL,-6.787475,-79.828097,30,-5);
 INSERT INTO airport VALUES ('TRU','Capitan Carlos Martinez De Pinillos','PE','Trujillo','La Libertad',NULL,-8.081411,-79.108761,32,-5);
 INSERT INTO airport VALUES ('HUU','Alferez Fap David Figueroa Fernandini Airport','PE','Huánuco','Huánuco',NULL,-9.878811,-76.204797,1851,-5);
 INSERT INTO airport VALUES ('AYP','Coronel Fap Alfredo Mendivil Duarte','PE','Ayacucho','Ayacucho',NULL,-13.154819,-74.204417,2719,-5);
 INSERT INTO airport VALUES ('TBP','Pedro Canga','PE','Tumbes','Tumbes',NULL,-3.552528,-80.381356,35,-5);
 INSERT INTO airport VALUES ('CJA','Mayor General FAP Armando Revoredo Iglesias Airport','PE','Cajamarca','Cajamarca',NULL,-7.139183,-78.4894,2677,-5);
 INSERT INTO airport VALUES ('PIU','Capitan Fap Guillermo Concha Iberico','PE','Piura','Piura',NULL,-5.20575,-80.616444,37,-5);
 INSERT INTO airport VALUES ('PCL','Cap Fap David Abenzur Rengifo Intl','PE','Pucallpa','Ucayali',NULL,-8.377939,-74.574297,156,-5);
 INSERT INTO airport VALUES ('PEM','Padre Aldamiz','PE','Puerto Maldonado','Madre de Dios',NULL,-12.613611,-69.228611,201,-5);
 INSERT INTO airport VALUES ('IQT','Coronel Francisco Secada Vignetta Intl','PE','Iquitos','Loreto',NULL,-3.784739,-73.308806,93,-5);
 INSERT INTO airport VALUES ('AQP','Rodriguez Ballon','PE','Arequipa','Arequipa',NULL,-16.341072,-71.583083,2563,-5);
 INSERT INTO airport VALUES ('JUL','Juliaca','PE','Juliaca','Puno',NULL,-15.467103,-70.158169,3827,-5);
 INSERT INTO airport VALUES ('TPP','Cadete Guillermo Del Castillo Paredes','PE','Tarapoto','San Martín',NULL,-6.508742,-76.373247,265,-5);
 INSERT INTO airport VALUES ('CUZ','Teniente Alejandro Velasco Astete Intl','PE','Cusco','Cusco',NULL,-13.535722,-71.938781,3311,-5);
 INSERT INTO airport VALUES ('TCQ','Coronel Carlos Ciriani Santa Rosa Intl','PE','Tacna','Tacna',NULL,-18.053333,-70.275833,469,-5);
 INSERT INTO airport VALUES ('LIM','Jorge Chavez Intl','PE','Lima','Lima City',NULL,-12.021889,-77.114319,34,-5);
 INSERT INTO airport VALUES ('CEB','Mactan Cebu Intl','RP','Cebu','Central Visayas','Cebu',10.307542,123.979439,9,8);
 INSERT INTO airport VALUES ('LGP','Legazpi','RP','Legazpi','Bicol','Luzon',13.157064,123.746247,20,8);
 INSERT INTO airport VALUES ('TAC','Daniel Z Romualdez','RP','Tacloban','Eastern Visayas','Leyte',11.227628,125.027758,3,8);
 INSERT INTO airport VALUES ('MNL','Ninoy Aquino Intl','RP','Manila','Metro Manila','Luzon',14.508647,121.019581,23,8);
 INSERT INTO airport VALUES ('BXU','Butuan','RP','Butuan','Caraga','Mindanao',8.951322,125.477972,43,8);
 INSERT INTO airport VALUES ('ZAM','Zamboanga Intl','RP','Zamboanga','Zamboanga Peninsula','Mindanao',6.922419,122.059633,10,8);
 INSERT INTO airport VALUES ('ILO','Iloilo','RP','Iloilo','Western Visayas','Panay',10.713044,122.545297,8,8);
 INSERT INTO airport VALUES ('PPS','Puerto Princesa','RP','Calapan','Mimaropa','Palawan',9.742119,118.758731,22,8);
 INSERT INTO airport VALUES ('PAG','Pagadian','RP','Pagadian','Zamboanga Peninsula','Mindanao',7.827197,123.458294,2,8);
 INSERT INTO airport VALUES ('GES','General Santos International Airport','RP','General Santos','Soccsksargen','Mindanao',6.106439,125.2353,9,8);
 INSERT INTO airport VALUES ('DVO','Francisco Bangoy International','RP','Davao','Davao','Mindanao',7.125522,125.645778,18,8);
 INSERT INTO airport VALUES ('BCD','Bacolod','RP','Bacolod','Western Visayas','Negros',10.642511,122.929617,8,8);
 INSERT INTO airport VALUES ('CBO','Cotabato','RP','Cotabato','Muslim Mindanao','Mindanao',7.165242,124.209619,58,8);
 INSERT INTO airport VALUES ('KRK','Balice','PL','Kraków','Małopolskie',NULL,50.077731,19.784836,241,1);
 INSERT INTO airport VALUES ('KTW','Pyrzowice','PL','Katowice','Śląskie',NULL,50.474253,19.080019,303,1);
 INSERT INTO airport VALUES ('BZG','Bydgoszcz Ignacy Jan Paderewski Airport','PL','Bydgoszcz','Kujawsko-Pomorskie',NULL,53.0968,17.9777,72,1);
 INSERT INTO airport VALUES ('SZZ','Goleniow','PL','Szczecin','Zachodniopomorskie',NULL,53.584731,14.902206,47,1);
 INSERT INTO airport VALUES ('GDN','Lech Walesa','PL','Gdańsk','Pomorskie',NULL,54.377569,18.466222,149,1);
 INSERT INTO airport VALUES ('RZE','Jasionka','PL','Rzeszów','Podkarpackie',NULL,50.109958,22.019,206,1);
 INSERT INTO airport VALUES ('POZ','Lawica','PL','Poznań','Wielkopolskie',NULL,52.421031,16.826325,94,1);
 INSERT INTO airport VALUES ('WRO','Strachowice','PL','Wrocław','Dolnośląskie',NULL,51.102683,16.885836,123,1);
 INSERT INTO airport VALUES ('LCJ','Lodz Wladyslaw Reymont Airport','PL','Łódź','Łódzkie',NULL,51.721881,19.398133,184,1);
 INSERT INTO airport VALUES ('WAW','Okecie','PL','Warszawa','Mazowieckie',NULL,52.16575,20.967122,110,1);
 INSERT INTO airport VALUES ('FAO','Faro','P','Faro','Algarve',NULL,37.014425,-7.965911,7,0);
 INSERT INTO airport VALUES ('FLW','Flores','P',NULL,NULL,'Flores (Azores)',39.455272,-31.131361,34,-1);
 INSERT INTO airport VALUES ('LIS','Portela','P','Lisboa','Lisboa',NULL,38.781311,-9.135919,114,0);
 INSERT INTO airport VALUES ('PXO','Porto Santo','P',NULL,NULL,'Porto Santo',33.073386,-16.349975,104,0);
 INSERT INTO airport VALUES ('GRW','Graciosa','P',NULL,NULL,'Graciosa',39.092169,-28.029847,26,-1);
 INSERT INTO airport VALUES ('SJZ','Sao Jorge','P',NULL,NULL,'Sao Jorge',38.6655,-28.175817,95,-1);
 INSERT INTO airport VALUES ('CVU','Corvo Airport','P',NULL,NULL,'Corvo',39.6715,-31.1136,19,-1);
 INSERT INTO airport VALUES ('SMA','Santa Maria','P',NULL,NULL,'Santa Maria',36.97139,-25.170639,94,-1);
 INSERT INTO airport VALUES ('FNC','Madeira','P','Funchal','Madeira','Madeira',32.697889,-16.774453,59,0);
 INSERT INTO airport VALUES ('PIX','Pico','P',NULL,NULL,'Pico',38.554333,-28.441333,33,-1);
 INSERT INTO airport VALUES ('TER','Lajes','P',NULL,NULL,'Terceira',38.761842,-27.090797,55,-1);
 INSERT INTO airport VALUES ('OPO','Porto','P','Oporto','Porto',NULL,41.248055,-8.681389,70,0);
 INSERT INTO airport VALUES ('PDL','Ponta Delgada','P','Ponta Delgada','Azores','Sao Miguel',37.741184,-25.69787,79,-1);
 INSERT INTO airport VALUES ('SJU','Luis Munoz Marin Intl','PR','San Juan','Puerto Rico','Puerto Rico',18.439417,-66.001833,3,-4);
 INSERT INTO airport VALUES ('DOH','Doha Intl','Q','Doha','Qatar',NULL,25.261125,51.565056,11,4);
 INSERT INTO airport VALUES ('RUN','St Denis Gillot','REUN','Saint-Denis','Reunion','Reunion',-20.8871,55.510308,20,5);
 INSERT INTO airport VALUES ('IAS','Iasi','RO','Iaşi','Iaşi',NULL,47.178492,27.620631,121,2);
 INSERT INTO airport VALUES ('SBZ','Sibiu','RO','Sibiu','Sibiu',NULL,45.785597,24.091342,456,2);
 INSERT INTO airport VALUES ('BAY','Tautii Magheraus','RO','Baia Mare','Maramureş',NULL,47.658389,23.470022,184,2);
 INSERT INTO airport VALUES ('SCV','Stefan Cel Mare','RO','Suceava','Suceava',NULL,47.6875,26.354056,419,2);
 INSERT INTO airport VALUES ('CLJ','Cluj Napoca','RO','Cluj-Napoca','Cluj',NULL,46.785167,23.686167,316,2);
 INSERT INTO airport VALUES ('TSR','Traian Vuia','RO','Timişoara','Timiş',NULL,45.809861,21.337861,106,2);
 INSERT INTO airport VALUES ('BCM','Bacau','RO','Bacău','Bacău',NULL,46.521946,26.910278,185,2);
 INSERT INTO airport VALUES ('OMR','Oradea','RO','Oradea','Bihor',NULL,47.025278,21.9025,142,2);
 INSERT INTO airport VALUES ('OTP','Henri Coanda','RO','Bucureşti','Bucureşti',NULL,44.572161,26.102178,96,2);
 INSERT INTO airport VALUES ('SUJ','Satu Mare','RO','Satu Mare','Satu-Mare',NULL,47.703275,22.8857,123,2);
 INSERT INTO airport VALUES ('ARW','Arad','RO','Arad','Arad',NULL,46.17655,21.262022,107,2);
 INSERT INTO airport VALUES ('KGD','Khrabrovo','R','Kaliningrad','Kaliningradskaya',NULL,54.89005,20.592633,13,2);
 INSERT INTO airport VALUES ('MMK','Murmansk','R','Murmansk','Murmanskaya',NULL,68.781672,32.750822,81,3);
 INSERT INTO airport VALUES ('PES','Petrozavodsk Airport','R','Petrozavodsk','Karelia',NULL,61.8852,34.1547,46,3);
 INSERT INTO airport VALUES ('ARH','Talagi','R','Arkhangelsk','Arkhangel´skaya',NULL,64.360281,40.430167,6,4);
 INSERT INTO airport VALUES ('SCW','Syktyvkar','R','Syktyvkar','Komi',NULL,61.64705,50.84505,104,3);
 INSERT INTO airport VALUES ('VKT','Vorkuta Airport','R','Vorkuta','Komi',NULL,67.4886,63.9931,184,3);
 INSERT INTO airport VALUES ('KVX','Pobedilovo Airport','R','Kirov','Kirovskaya',NULL,58.5033,49.3483,146,4);
 INSERT INTO airport VALUES ('LED','Pulkovo','R','Sankt Peterburg','Sankt-Peterburg',NULL,59.800292,30.262503,24,3);
 INSERT INTO airport VALUES ('EGO','Belgorod International Airport','R','Belgorod','Belgorodskaya',NULL,50.6438,36.5901,224,3);
 INSERT INTO airport VALUES ('DME','Domododevo','R','Moskva','Moscow',NULL,55.408611,37.906111,179,3);
 INSERT INTO airport VALUES ('SVO','Sheremetyevo','R','Moskva','Moscow',NULL,55.972642,37.414589,190,3);
 INSERT INTO airport VALUES ('VKO','Vnukovo','R','Moskva','Moscow',NULL,55.591531,37.261486,209,3);
 INSERT INTO airport VALUES ('GOJ','Strigono','R','Nizhnii Novgorod','Nizhnii Novgorodskaya',NULL,56.23,43.785,78,3);
 INSERT INTO airport VALUES ('CEE','Cherepovets Airport','R','Cherepovets','Vologodskaya',NULL,59.2736,38.0158,115,3);
 INSERT INTO airport VALUES ('KZN','Kazan','R','Kazan','Tatarstan',NULL,55.606186,49.278728,125,3);
 INSERT INTO airport VALUES ('CSY','Cheboksary Airport','R','Cheboksary','Chuvashia',NULL,56.0903,47.3473,170,3);
 INSERT INTO airport VALUES ('TBW','Tambow','R','Tambov','Tambovskaya',NULL,52.81,41.48,38,4);
 INSERT INTO airport VALUES ('VOZ','Chertovitskoye','R','Voronezh','Voronezhskaya',NULL,51.814211,39.229589,157,3);
 INSERT INTO airport VALUES ('VOG','Gumrak','R','Volgograd','Volgogradskaya',NULL,48.782528,44.345544,147,3);
 INSERT INTO airport VALUES ('ROV','Rostov Na Donu','R','Rostov-na-Donu','Rostovskaya',NULL,47.258208,39.818089,85,3);
 INSERT INTO airport VALUES ('STW','Shpakovskoye','R','Stavropol','Stavropol´skiy',NULL,45.109165,42.112778,453,4);
 INSERT INTO airport VALUES ('AER','Sochi','R','Sochi','Krasnodarskiy',NULL,43.449928,39.956589,27,3);
 INSERT INTO airport VALUES ('KRR','Pashkovskiy','R','Krasnodar','Krasnodarskiy',NULL,45.034689,39.170539,36,3);
 INSERT INTO airport VALUES ('ESL','Elista Airport','R','Elista','Kalmykiya',NULL,46.3739,44.3309,153,3);
 INSERT INTO airport VALUES ('NAL','Nalchik Airport','R','Nal''čik','Kabardino-Balkarskaya',NULL,43.5129,43.6366,445,3);
 INSERT INTO airport VALUES ('GRV','Grozny Airport','R','Grozny','Chechenskaya',NULL,43.2981,45.7841,167,3);
 INSERT INTO airport VALUES ('MCX','Uytash','R','Makhachkala','Dagestan',NULL,42.816822,47.652294,4,3);
 INSERT INTO airport VALUES ('KUF','Kurumoch','R','Samara','Samarskaya',NULL,53.5,50.15,145,4);
 INSERT INTO airport VALUES ('ULY','Ulyanovsk East Airport','R','Ulyanovsk','Ul´yanovskaya',NULL,54.401,48.8027,77,4);
 INSERT INTO airport VALUES ('ASF','Astrakhan','R','Astrakhan','Astrakhanskaya',NULL,46.283333,48.006278,-20,4);
 INSERT INTO airport VALUES ('IJK','Izhevsk Airport','R','Izhevsk','Udmurtskaya',NULL,56.8281,53.4575,162,4);
 INSERT INTO airport VALUES ('PEE','Bolshoye Savino','R','Perm','Permskij',NULL,57.914517,56.021214,123,5);
 INSERT INTO airport VALUES ('UFA','Ufa','R','Ufa','Bashkortostan',NULL,54.557511,55.874417,137,6);
 INSERT INTO airport VALUES ('REN','Orenburg','R','Orenburg','Orenburgskaya',NULL,51.795786,55.456744,118,5);
 INSERT INTO airport VALUES ('MQF','Magnitogorsk','R','Magnitogorsk','Chelyabinskaya',NULL,53.393131,58.755661,436,6);
 INSERT INTO airport VALUES ('OSW','Orsk Airport','R','Orsk','Orenburgskaya',NULL,51.0725,58.5956,277,5);
 INSERT INTO airport VALUES ('SVX','Koltsovo','R','Yekaterinburg','Sverdlovskaya',NULL,56.743108,60.802728,233,5);
 INSERT INTO airport VALUES ('CEK','Balandino','R','Chelyabinsk','Chelyabinskaya',NULL,55.305836,61.503333,234,5);
 INSERT INTO airport VALUES ('TJM','Roschino','R','Tyumen','Tyumenskaya',NULL,57.189567,65.3243,115,5);
 INSERT INTO airport VALUES ('SLY','Salekhard Airport','R','Salekhard','Yamalo Nenets ao',NULL,66.590753,66.611042,66,6);
 INSERT INTO airport VALUES ('NUX','Novyi Urengoy','R','Novyj Urengoj','Yamalo Nenets ao',NULL,66.041811,76.313938,6,6);
 INSERT INTO airport VALUES ('HMA','Khanty Mansiysk Airport','R','Khanty Mansijsk','Khanty Mansi ao',NULL,61.028479,69.086067,23,5);
 INSERT INTO airport VALUES ('SGC','Surgut','R','Surgut','Khanty Mansi ao',NULL,61.343694,73.401842,61,6);
 INSERT INTO airport VALUES ('NOJ','Noyabrsk','R','Nojabr''sk','Yamalo Nenets ao',NULL,63.110079,75.162243,6,6);
 INSERT INTO airport VALUES ('NJC','Nizhnevartovsk','R','Nizhnevartovsk','Khanty Mansi ao',NULL,60.949272,76.483617,54,5);
 INSERT INTO airport VALUES ('OMS','Omsk','R','Omsk','Omskaya',NULL,54.967042,73.310514,95,6);
 INSERT INTO airport VALUES ('OVB','Tolmachevo','R','Novosibirsk','Novosibirskaya',NULL,55.012622,82.650656,111,7);
 INSERT INTO airport VALUES ('BAX','Barnaul','R','Barnaul','Altayskiy',NULL,53.363775,83.538533,255,7);
 INSERT INTO airport VALUES ('TOF','Tomsk Bogashevo Airport','R','Tomsk','Tomskaya',NULL,56.380278,85.208333,182,7);
 INSERT INTO airport VALUES ('KEJ','Kemerovo','R','Kemerovo','Kemerovskaya',NULL,55.270094,86.107208,263,7);
 INSERT INTO airport VALUES ('NOZ','Spichenkovo Airport','R','Novokuznetsk','Kemerovskaya',NULL,53.8114,86.8772,312,7);
 INSERT INTO airport VALUES ('NSK','Alykel','R','Noril''sk','Krasnoyarsk',NULL,69.311053,87.332183,181,7);
 INSERT INTO airport VALUES ('ABA','Abakan','R','Abakan','Khakasiya',NULL,53.74,91.385,253,7);
 INSERT INTO airport VALUES ('KJA','Emelyanovo','R','Krasnoyarsk','Krasnoyarsk',NULL,56.18,92.475,287,7);
 INSERT INTO airport VALUES ('BTK','Bratsk','R','Bratsk','Irkutskaya',NULL,56.370556,101.698331,491,8);
 INSERT INTO airport VALUES ('IKT','Irkutsk','R','Irkutsk','Irkutskaya',NULL,52.268028,104.388975,511,8);
 INSERT INTO airport VALUES ('UUD','Mukhino','R','Ulan-Ude','Buryatiya',NULL,51.807764,107.437644,515,8);
 INSERT INTO airport VALUES ('HTA','Kadala','R','Chita','Zabaykalskiy',NULL,52.026317,113.305556,693,9);
 INSERT INTO airport VALUES ('BQS','Ignatyevo','R','Blagoveščensk','Amurskaya',NULL,50.425394,127.412478,195,9);
 INSERT INTO airport VALUES ('YKS','Yakutsk','R','Yakutsk','Sakha',NULL,62.09325,129.770672,99,9);
 INSERT INTO airport VALUES ('VVO','Knevichi','R','Vladivostok','Primorskiy',NULL,43.398953,132.148017,14,10);
 INSERT INTO airport VALUES ('KHV','Khabarovsk Novy','R','Khabarovsk','Khabarovskiy',NULL,48.528044,135.188361,74,10);
 INSERT INTO airport VALUES ('UUS','Khomutovo','R','Južno-Sachalinsk','Sakhalin','Sachalin',46.888672,142.717531,18,11);
 INSERT INTO airport VALUES ('GDX','Sokol','R','Magadan','Magadanskaya',NULL,59.910989,150.720439,175,11);
 INSERT INTO airport VALUES ('PKC','Yelizovo','R','Petropavlovsk-Kamčatskij','Kamchatka',NULL,53.167889,158.453669,40,12);
 INSERT INTO airport VALUES ('KGL','Kigali Intl','RWA','Kigali','Rwanda',NULL,-1.968628,30.13945,1481,2);
 INSERT INTO airport VALUES ('SKB','Robert L Bradshaw','KN','Basseterre','Saint Kitts and Nevis','Saint Kitts',17.311194,-62.718667,52,-4);
 INSERT INTO airport VALUES ('UVF','Hewanorra Intl','WL','Castries','Saint Lucia','Saint Lucia',13.733194,-60.952597,4,-4);
 INSERT INTO airport VALUES ('SLU','George F L Charles','WL','Castries','Saint Lucia','Saint Lucia',14.020228,-60.992936,7,-4);
 INSERT INTO airport VALUES ('SFP','Saint-Pierre','SPMI','Saint-Pierre','Saint Pierre and Miquelon','Saint Pierre',46.7631,-56.1742,8,-2);
 INSERT INTO airport VALUES ('SVD','E T Joshua','WV','Kingstown','Saint Vincent and the Grenadines','Saint Vincent',13.144306,-61.210861,20,-4);
 INSERT INTO airport VALUES ('APW','Faleolo Intl','WS','Apia','Samoa','Upolu',-13.829969,-172.008336,18,13);
 INSERT INTO airport VALUES ('TMS','Sao Tome Intl','STP','São Tomé','Sao Tome and Principe','Sao Tome',.378175,6.712153,10,0);
 INSERT INTO airport VALUES ('TIF','Taif','SA','At Taif','Makkah Al-Mokarramah',NULL,21.483418,40.544334,1478,3);
 INSERT INTO airport VALUES ('DMM','King Fahd Intl','SA','Dammam','Ash Sharqiyah',NULL,26.471161,49.79789,22,3);
 INSERT INTO airport VALUES ('HAS','Hail','SA','Hail','Ha''il',NULL,27.437917,41.686292,1016,3);
 INSERT INTO airport VALUES ('JED','King Abdulaziz Intl','SA','Jeddah','Makkah Al-Mokarramah',NULL,21.679564,39.156536,15,3);
 INSERT INTO airport VALUES ('RUH','King Khaled Intl','SA','Riyadh','Al-Riyadh',NULL,24.95764,46.698776,625,3);
 INSERT INTO airport VALUES ('MED','Prince Mohammad Bin Abdulaziz','SA','Al Madinah','Al-Madinah Al-Monawarah',NULL,24.553422,39.705061,656,3);
 INSERT INTO airport VALUES ('ZIG','Ziguinchor','SN','Ziguinchor','Ziguinchor',NULL,12.555617,-16.281783,23,0);
 INSERT INTO airport VALUES ('DKR','Leopold Sedar Senghor Intl','SN','Dakar','Dakar',NULL,14.739708,-17.490225,26,0);
 INSERT INTO airport VALUES ('PRN','Pristina','KOS','Prishtine','Kosovo',NULL,42.572778,21.035833,545,1);
 INSERT INTO airport VALUES ('BEG','Beograd','SRB','Beograd','Serbia',NULL,44.818444,20.309139,102,1);
 INSERT INTO airport VALUES ('INI','Nis','SRB','Niš','Serbia',NULL,43.337289,21.853722,198,1);
 INSERT INTO airport VALUES ('SEZ','Seychelles Intl','SY','Victoria','Seychelles','Mahe',-4.674342,55.521839,3,4);
 INSERT INTO airport VALUES ('FNA','Freetown Lungi','WAL','Freetown','Sierra Leone',NULL,8.616444,-13.195489,26,0);
 INSERT INTO airport VALUES ('SIN','Changi Intl','SGP','Singapore','Singapore','Ujong',1.350189,103.994433,7,8);
 INSERT INTO airport VALUES ('SXM','Princess Juliana Intl','NLSM','Philipsburg','Sint Maarten','St. Martin',18.040953,-63.1089,4,-4);
 INSERT INTO airport VALUES ('BTS','M R Stefanik','SK','Bratislava','Bratislavský',NULL,48.170167,17.212667,133,1);
 INSERT INTO airport VALUES ('KSC','Kosice','SK','Košice','Košický',NULL,48.663055,21.241112,230,1);
 INSERT INTO airport VALUES ('LJU','Ljubljana','SLO','Ljubljana','Slovenia',NULL,46.223686,14.457611,388,1);
 INSERT INTO airport VALUES ('HIR','Honiara International','SLB','Honiara','Solomon Islands','Guadalcanal',-9.428,160.054789,9,11);
 INSERT INTO airport VALUES ('MGQ','Aden Adde International Airport','SP','Mogadishu','Somalia',NULL,2.01444,45.3047,9,3);
 INSERT INTO airport VALUES ('HLA','Lanseria','RSA','Johannesburg','Gauteng',NULL,-25.938514,27.926133,1377,2);
 INSERT INTO airport VALUES ('PZB','Pietermaritzburg','RSA','Msunduzi','KwaZulu-Natal',NULL,-29.648975,30.398667,739,2);
 INSERT INTO airport VALUES ('DUR','Durban Intl','RSA','eThekwini','KwaZulu-Natal',NULL,-29.970089,30.950519,10,2);
 INSERT INTO airport VALUES ('ELS','East London','RSA','Buffalo City','Eastern Cape',NULL,-33.035569,27.825939,133,2);
 INSERT INTO airport VALUES ('BFN','Bloemfontein Intl','RSA','Mangaung','Free State',NULL,-29.092722,26.302444,1359,2);
 INSERT INTO airport VALUES ('KIM','Kimberley','RSA','Kimberley','Northern Cape',NULL,-28.802834,24.765167,1204,2);
 INSERT INTO airport VALUES ('PLZ','Port Elizabeth Intl','RSA','Nelson Mandela Bay','Eastern Cape',NULL,-33.984919,25.617275,69,2);
 INSERT INTO airport VALUES ('PTG','Pietersburg','RSA','Polokwane','Limpopo',NULL,-23.926089,29.484422,1327,2);
 INSERT INTO airport VALUES ('CPT','Cape Town Intl','RSA','Cape Town','Western Cape',NULL,-33.964806,18.601667,46,2);
 INSERT INTO airport VALUES ('JNB','Johannesburg Intl','RSA','Johannesburg','Gauteng',NULL,-26.139166,28.246,1695,2);
 INSERT INTO airport VALUES ('RSU','Yeosu','ROK','Yeosu','South Korea',NULL,34.842328,127.61685,16,9);
 INSERT INTO airport VALUES ('ICN','Incheon Intl','ROK','Seoul','South Korea',NULL,37.469075,126.450517,7,9);
 INSERT INTO airport VALUES ('PUS','Gimhae Intl','ROK','Busan','South Korea',NULL,35.179528,128.938222,2,9);
 INSERT INTO airport VALUES ('GMP','Gimpo','ROK','Seoul','South Korea',NULL,37.558311,126.790586,18,9);
 INSERT INTO airport VALUES ('USN','Ulsan','ROK','Ulsan','South Korea',NULL,35.593494,129.351722,14,9);
 INSERT INTO airport VALUES ('KWJ','Gwangju','ROK','Gwangju','South Korea',NULL,35.126389,126.808889,12,9);
 INSERT INTO airport VALUES ('TAE','Daegu Ab','ROK','Daegu','South Korea',NULL,35.894108,128.658856,35,9);
 INSERT INTO airport VALUES ('CJU','Jeju Intl','ROK','Jeju','South Korea','Jeju',33.511306,126.493028,36,9);
 INSERT INTO airport VALUES ('JUB','Juba','SSD','Juba','South Sudan',NULL,4.872006,31.601117,461,2);
 INSERT INTO airport VALUES ('VDE','Hierro','E',NULL,NULL,'Hierro',27.814847,-17.887056,31,0);
 INSERT INTO airport VALUES ('SDR','Santander','E','Santander','Cantabria',NULL,43.427064,-3.820006,5,1);
 INSERT INTO airport VALUES ('SPC','La Palma','E',NULL,NULL,'La Palma',28.626478,-17.755611,33,0);
 INSERT INTO airport VALUES ('LPA','Gran Canaria','E','Las Palmas de Gran Canaria','Canarias','Gran Canaria',27.931886,-15.386586,24,0);
 INSERT INTO airport VALUES ('SLM','Salamanca','E','Salamanca','Castilla y León',NULL,40.952117,-5.501986,791,1);
 INSERT INTO airport VALUES ('TFN','Tenerife Norte','E','Santa Cruz de Tenerife','Canarias','Teneriffa',28.482653,-16.341536,632,0);
 INSERT INTO airport VALUES ('AGP','Malaga','E','Málaga','Andalucía',NULL,36.6749,-4.499106,16,1);
 INSERT INTO airport VALUES ('BIO','Bilbao','E','Bilbao','Euskadi',NULL,43.301097,-2.910608,42,1);
 INSERT INTO airport VALUES ('TFS','Tenerife Sur','E','Santa Cruz de Tenerife','Canarias','Teneriffa',28.044475,-16.572489,64,0);
 INSERT INTO airport VALUES ('BJZ','Talavera La Real','E','Badajoz','Extremadura',NULL,38.89125,-6.821333,186,1);
 INSERT INTO airport VALUES ('ALC','Alicante','E','Alicante','Valenciana',NULL,38.282169,-0.558156,43,1);
 INSERT INTO airport VALUES ('BCN','Barcelona','E','Barcelona','Catalunya',NULL,41.297078,2.078464,4,1);
 INSERT INTO airport VALUES ('ACE','Lanzarote','E','Las Palmas de Gran Canaria','Canarias','Gran Canaria',28.945464,-13.605225,14,0);
 INSERT INTO airport VALUES ('VGO','Vigo','E','Vigo','Galicia',NULL,42.2318,-8.626775,261,1);
 INSERT INTO airport VALUES ('MLN','Melilla','MEL','Melilla','Melilla',NULL,35.279817,-2.956256,48,0);
 INSERT INTO airport VALUES ('MJV','Murcia San Javier','E','Murcia','Murcia',NULL,37.774972,-0.812389,3,1);
 INSERT INTO airport VALUES ('GMZ','La Gomera Airport','E',NULL,NULL,'Gomera',28.0296,-17.2146,219,0);
 INSERT INTO airport VALUES ('FUE','Fuerteventura','E',NULL,NULL,'Fuerteventura',28.452717,-13.863761,25,0);
 INSERT INTO airport VALUES ('XRY','Jerez','E','Jerez de la Frontera','Andalucía',NULL,36.744622,-6.060111,28,1);
 INSERT INTO airport VALUES ('PMI','Son Sant Joan','E','Palma de Mallorca','Illes Balears','Mallorca',39.55361,2.727778,7,1);
 INSERT INTO airport VALUES ('PNA','Pamplona','E','Pamplona','Navarra',NULL,42.770039,-1.646331,459,1);
 INSERT INTO airport VALUES ('GRX','Granada','E','Granada','Andalucía',NULL,37.188731,-3.777356,567,1);
 INSERT INTO airport VALUES ('IBZ','Ibiza','E',NULL,NULL,'Ibiza',38.872858,1.373117,6,1);
 INSERT INTO airport VALUES ('ZAZ','Zaragoza Ab','E','Zaragoza','Aragón',NULL,41.666242,-1.041553,263,1);
 INSERT INTO airport VALUES ('REU','Reus','E','Reus','Catalunya',NULL,41.147392,1.167172,71,1);
 INSERT INTO airport VALUES ('EAS','San Sebastian','E','Donostia','Euskadi',NULL,43.356519,-1.790611,5,1);
 INSERT INTO airport VALUES ('MAD','Barajas','E','Madrid','Madrid',NULL,40.493556,-3.566764,610,1);
 INSERT INTO airport VALUES ('MAH','Menorca','E',NULL,NULL,'Menorca',39.862597,4.218647,91,1);
 INSERT INTO airport VALUES ('VLC','Valencia','E','Valencia','Valenciana',NULL,39.489314,-0.481625,69,1);
 INSERT INTO airport VALUES ('VLL','Valladolid','E','Valladolid','Castilla y León',NULL,41.706111,-4.851944,846,1);
 INSERT INTO airport VALUES ('SVQ','Sevilla','E','Sevilla','Andalucía',NULL,37.418,-5.893106,34,1);
 INSERT INTO airport VALUES ('LCG','A Coruna','E','A Coruña','Galicia',NULL,43.302061,-8.377256,99,1);
 INSERT INTO airport VALUES ('LEI','Almeria','E','Almería','Andalucía',NULL,36.843936,-2.370097,21,1);
 INSERT INTO airport VALUES ('SCQ','Santiago','E','Santiago de Compostela','Galicia',NULL,42.896333,-8.415144,370,1);
 INSERT INTO airport VALUES ('CMB','Bandaranaike Intl Colombo','CL','Colombo','Sri Lanka','Sri Lanka',7.180756,79.884117,9,5.5);
 INSERT INTO airport VALUES ('KRT','Khartoum','SUD','Khartoum','Sudan',NULL,15.589497,32.553161,386,2);
 INSERT INTO airport VALUES ('PBM','Johan A Pengel Intl','SME','Paramaribo','Suriname',NULL,5.452831,-55.187783,18,-3);
 INSERT INTO airport VALUES ('MTS','Matsapha','SD','Mbabane','Swaziland',NULL,-26.529022,31.307519,633,2);
 INSERT INTO airport VALUES ('VXO','Kronoberg','S','Växjö','Kronoberg',NULL,56.929144,14.727994,186,1);
 INSERT INTO airport VALUES ('VBY','Visby','S','Visby','Gotland',NULL,57.662797,18.346211,50,1);
 INSERT INTO airport VALUES ('NRK','Kungsangen','S','Norrköping','Östergötland',NULL,58.586253,16.250622,10,1);
 INSERT INTO airport VALUES ('LLA','Kallax','S','Lulea','Norrbotten',NULL,65.543758,22.121989,20,1);
 INSERT INTO airport VALUES ('LPI','Saab','S','Linköping','Östergötland',NULL,58.40615,15.680508,52,1);
 INSERT INTO airport VALUES ('AGH','Angelholm-Helsingborg Airport','S','Helsingborg','Skåne',NULL,56.2961,12.8471,21,1);
 INSERT INTO airport VALUES ('KID','Kristianstad','S','Kristianstad','Skåne',NULL,55.921686,14.085536,23,1);
 INSERT INTO airport VALUES ('BMA','Bromma','S','Stockholm','Stockholm',NULL,59.354372,17.94165,14,1);
 INSERT INTO airport VALUES ('KLR','Kalmar','S','Kalmar','Kalmar',NULL,56.685531,16.287578,5,1);
 INSERT INTO airport VALUES ('UME','Umea','S','Umeå','Västerbotten',NULL,63.791828,20.282758,7,1);
 INSERT INTO airport VALUES ('NYO','Skavsta','S','Stockholm','Stockholm',NULL,58.788636,16.912189,43,1);
 INSERT INTO airport VALUES ('VST','Västerås','S','Västerås','Västmanland',NULL,59.589444,16.633611,6,1);
 INSERT INTO airport VALUES ('HAD','Halmstad','S','Halmstad','Halland',NULL,56.691128,12.820211,31,1);
 INSERT INTO airport VALUES ('JKG','Jönköping','S','Jönköping','Jönköping',NULL,57.757594,14.068731,226,1);
 INSERT INTO airport VALUES ('OSD','Östersund Airport','S','Ostersund','Jämtland',NULL,63.1944,14.5003,376,1);
 INSERT INTO airport VALUES ('ORB','Örebro','S','Örebro','Örebro',NULL,59.223733,15.037956,57,1);
 INSERT INTO airport VALUES ('GOT','Landvetter','S','Göteborg','Västra Götaland',NULL,57.662836,12.279819,154,1);
 INSERT INTO airport VALUES ('GSE','Save','S','Göteborg','Västra Götaland',NULL,57.774722,11.870372,18,1);
 INSERT INTO airport VALUES ('ARN','Arlanda','S','Stockholm','Stockholm',NULL,59.651944,17.918611,42,1);
 INSERT INTO airport VALUES ('MMX','Sturup','S','Malmö','Skåne',NULL,55.530193,13.371639,72,1);
 INSERT INTO airport VALUES ('KSD','Karlstad Airport','S','Karlstad','Värmland',NULL,59.4447,13.3374,107,1);
 INSERT INTO airport VALUES ('BRN','Bern Belp','CH','Bern','Bern',NULL,46.9141,7.497153,510,1);
 INSERT INTO airport VALUES ('LUG','Lugano','CH','Lugano','Ticino',NULL,46.004275,8.910578,279,1);
 INSERT INTO airport VALUES ('BSL','EuroAirport Basel-Mulhouse-Freiburg','CH','Basel','Basel-Stadt',NULL,47.59,7.529167,270,1);
 INSERT INTO airport VALUES ('ZRH','Zurich Kloten','CH','Zürich','Zürich',NULL,47.464722,8.549167,432,1);
 INSERT INTO airport VALUES ('GVA','Geneva Cointrin','CH','Genève','Genève',NULL,46.238064,6.10895,430,1);
 INSERT INTO airport VALUES ('ACH','St Gallen Altenrhein','CH','Sankt Gallen','Sankt Gallen',NULL,47.485033,9.560775,398,1);
 INSERT INTO airport VALUES ('DAM','Damaskus Intl','SYR','Dimashq','Dimashq',NULL,33.4115,36.5156,616,2);
 INSERT INTO airport VALUES ('ALP','Aleppo Intl','SYR','Halab','Halab',NULL,36.1806,37.2242,383,2);
 INSERT INTO airport VALUES ('KHH','Kaohsiung Intl','RC','Kaohsiung','Taiwan','Taiwan',22.577094,120.350006,9,8);
 INSERT INTO airport VALUES ('TSA','Sungshan','RC','Taipei','Taiwan','Taiwan',25.069722,121.5525,5,8);
 INSERT INTO airport VALUES ('TPE','Taoyuan Intl','RC','Taipei','Taiwan','Taiwan',25.077731,121.232822,32,8);
 INSERT INTO airport VALUES ('DYU','Dushanbe','TAD','Dushanbe','Dushanbe',NULL,38.543333,68.825,785,5);
 INSERT INTO airport VALUES ('TJU','Kulob Airport','TAD','Kulyab','Khatlon',NULL,37.981667,69.799444,699,5);
 INSERT INTO airport VALUES ('LBD','Khudzhand Airport','TAD','Khujand','Sughd',NULL,40.2154,69.6947,442,5);
 INSERT INTO airport VALUES ('ZNZ','Zanzibar','EAT','Zanzibar','Mjini Magharibi Unguja','Sansibar',-6.222025,39.224886,16,3);
 INSERT INTO airport VALUES ('JRO','Kilimanjaro Intl','EAT','Moshi','Kilimanjaro',NULL,-3.429406,37.074461,894,3);
 INSERT INTO airport VALUES ('MYW','Mtwara','EAT','Mtwara','Mtwara',NULL,-10.339058,40.181781,113,3);
 INSERT INTO airport VALUES ('DAR','Mwalimu Julius K Nyerere Intl','EAT','Dar es Salaam','Dar es Salaam',NULL,-6.878111,39.202625,55,3);
 INSERT INTO airport VALUES ('MWZ','Mwanza','EAT','Mwanza','Mwanza',NULL,-2.444486,32.932667,1147,3);
 INSERT INTO airport VALUES ('ARK','Arusha','EAT','Arusha','Arusha',NULL,-3.367794,36.633333,1387,3);
 INSERT INTO airport VALUES ('DMK','Don Muang Intl','THA','Bangkok','Thailand',NULL,13.912583,100.60675,3,7);
 INSERT INTO airport VALUES ('NST','Nakhon Si Thammarat','THA','Nakhon Si Thammarat','Thailand',NULL,8.539617,99.944725,4,7);
 INSERT INTO airport VALUES ('USM','Samui','THA',NULL,NULL,'Ko Samui',9.547794,100.062272,20,7);
 INSERT INTO airport VALUES ('KKC','Khon Kaen','THA','Khon Kaen','Thailand',NULL,16.466628,102.783661,204,7);
 INSERT INTO airport VALUES ('BKK','Suvarnabhumi Intl','THA','Bangkok','Thailand',NULL,13.681108,100.747283,2,7);
 INSERT INTO airport VALUES ('CNX','Chiang Mai Intl','THA','Chiang Mai','Thailand',NULL,18.766847,98.962644,316,7);
 INSERT INTO airport VALUES ('HDY','Hat Yai Intl','THA','Songkhla','Thailand',NULL,6.933206,100.392975,27,7);
 INSERT INTO airport VALUES ('HKT','Phuket Intl','THA','Phuket','Thailand','Phuket',8.1132,98.316872,25,7);
 INSERT INTO airport VALUES ('LFW','Gnassingbe Eyadema Intl','RT','Lomé','Togo',NULL,6.165611,1.254511,22,1);
 INSERT INTO airport VALUES ('TBU','Fua Amotu Intl','TO','Nukualofa','Tonga','Tongatapu',-21.241214,-175.149644,38,13);
 INSERT INTO airport VALUES ('POS','Piarco','TT','Port-of-Spain','Trinidad and Tobago','Trinidad',10.595369,-61.337242,18,-4);
 INSERT INTO airport VALUES ('SFA','Thyna','TN','Sfax','Tunisia',NULL,34.717953,10.690972,26,1);
 INSERT INTO airport VALUES ('TUN','Carthage','TN','Tunis','Tunisia',NULL,36.851033,10.227217,7,1);
 INSERT INTO airport VALUES ('AYT','Antalya','TR','Antalya','Antalya',NULL,36.898731,30.800461,54,3);
 INSERT INTO airport VALUES ('EZS','Elazig','TR','Elazig','Elazığ',NULL,38.606925,39.291417,892,3);
 INSERT INTO airport VALUES ('KSY','Kars Airport','TR','Kars','Kars',NULL,40.562222,43.115002,1795,3);
 INSERT INTO airport VALUES ('SZF','Samsun-Carsamba Airport','TR','Samsun','Samsun',NULL,41.2545,36.5671,5,3);
 INSERT INTO airport VALUES ('KYA','Konya','TR','Konya','Konya',NULL,37.979,32.561861,1031,3);
 INSERT INTO airport VALUES ('ADF','Adiyaman Airport','TR','Adiyaman','Adıyaman',NULL,37.7314,38.4689,676,3);
 INSERT INTO airport VALUES ('BAL','Batman','TR','Batman','Batman',NULL,37.928969,41.116583,555,3);
 INSERT INTO airport VALUES ('ADA','Adana','TR','Adana','Adana',NULL,36.982166,35.280388,20,3);
 INSERT INTO airport VALUES ('ADB','Adnan Menderes','TR','Izmir','İzmir',NULL,38.292392,27.156953,126,3);
 INSERT INTO airport VALUES ('VAN','Van','TR','Van','Van',NULL,38.468219,43.3323,1671,3);
 INSERT INTO airport VALUES ('VAS','Sivas','TR','Sivas','Sivas',NULL,39.813828,36.903497,1596,3);
 INSERT INTO airport VALUES ('NAV','Kapadokya','TR','Nevsehir','Nevşehir',NULL,38.771867,34.53455,945,3);
 INSERT INTO airport VALUES ('ESB','Esenboga','TR','Ankara','Ankara',NULL,40.128082,32.995083,953,3);
 INSERT INTO airport VALUES ('ERZ','Erzurum','TR','Erzurum','Erzurum',NULL,39.956501,41.170166,1757,3);
 INSERT INTO airport VALUES ('ERC','Erzincan','TR','Erzincan','Erzincan',NULL,39.710203,39.527003,1153,3);
 INSERT INTO airport VALUES ('KCM','Kahramanmaras Airport','TR','Kahramanmaraş','Kahramanmaraş',NULL,37.539,36.9534,525,3);
 INSERT INTO airport VALUES ('MLX','Erhac','TR','Malatya','Malatya',NULL,38.435347,38.091006,862,3);
 INSERT INTO airport VALUES ('DIY','Diyarbakir','TR','Diyarbakir','Diyarbakır',NULL,37.893897,40.201019,686,3);
 INSERT INTO airport VALUES ('ASR','Erkilet','TR','Kayseri','Kayseri',NULL,38.770386,35.495428,1056,3);
 INSERT INTO airport VALUES ('TZX','Trabzon','TR','Trabzon','Trabzon',NULL,40.995108,39.789728,32,3);
 INSERT INTO airport VALUES ('IST','Ataturk','TR','Istanbul','İstanbul',NULL,40.976922,28.814606,50,3);
 INSERT INTO airport VALUES ('SAW','Sabiha Gokcen','TR','Istanbul','İstanbul',NULL,40.898553,29.309219,95,3);
 INSERT INTO airport VALUES ('GZT','Oguzeli','TR','Gaziantep','Gaziantep',NULL,36.947183,37.478683,706,3);
 INSERT INTO airport VALUES ('HTY','Hatay Airport','TR','Hatay','Hatay',NULL,36.362778,36.282222,8,3);
 INSERT INTO airport VALUES ('AJI','Agri Airport','TR','Agri','Ağrı',NULL,39.6546,43.0271,1665,3);
 INSERT INTO airport VALUES ('AOE','Anadolu Airport','TR','Eskisehir','Eskişehir',NULL,39.809858,30.519378,789,3);
 INSERT INTO airport VALUES ('MQM','Mardin Airport','TR','Mardin','Mardin',NULL,37.2233,40.6317,527,3);
 INSERT INTO airport VALUES ('DNZ','Cardak','TR','Denizli','Denizli',NULL,37.785567,29.701297,852,3);
 INSERT INTO airport VALUES ('MSR','Mus Airport','TR','Mus','Muş',NULL,38.747769,41.661236,1267,2);
 INSERT INTO airport VALUES ('ASB','Ashgabat','TM','Ashgabat','Ashgabat',NULL,37.986814,58.360967,211,5);
 INSERT INTO airport VALUES ('PLS','Providenciales','TUCA','Grand Turk','Turks and Caicos Islands','Grand Turk',21.773625,-72.265886,5,-5);
 INSERT INTO airport VALUES ('FUN','Funafuti International','TUV','Funafuti','Tuvalu','Fongafale',-8.525,179.196389,3,12);
 INSERT INTO airport VALUES ('EBB','Entebbe Intl','EAU','Kampala','Central',NULL,.042386,32.443503,1153,3);
 INSERT INTO airport VALUES ('DOK','Donetsk Intl','UA','Donets´k','Donets´ka',NULL,48.073611,37.739722,241,2);
 INSERT INTO airport VALUES ('KBP','Boryspil Intl','UA','Kyïv','Kyïv',NULL,50.345,30.894722,130,2);
 INSERT INTO airport VALUES ('HRK','Osnova International Airport','UA','Kharkiv','Kharkivs´ka',NULL,49.924786,36.289986,155,2);
 INSERT INTO airport VALUES ('IEV','Zhuliany Intl','UA','Kyïv','Kyïv',NULL,50.401694,30.449697,179,2);
 INSERT INTO airport VALUES ('SIP','Simferopol Intl','UA','Simferopol´','Krym',NULL,45.052222,33.975139,195,2);
 INSERT INTO airport VALUES ('UDJ','Uzhhorod International Airport','UA','Uzhhorod','Zakarpats´ka',NULL,48.634278,22.263356,117,2);
 INSERT INTO airport VALUES ('DNK','Dnipropetrovsk Intl','UA','Dnipropetrovs´k','Dnipropetrovs´ka',NULL,48.357222,35.100556,147,2);
 INSERT INTO airport VALUES ('IFO','Ivano Frankivsk International Airport','UA','Ivano-Frankivs´k','Ivano-Frankivs´ka',NULL,48.884167,24.686111,280,2);
 INSERT INTO airport VALUES ('ODS','Odesa Intl','UA','Odesa','Odes´ka',NULL,46.426767,30.676464,52,2);
 INSERT INTO airport VALUES ('LWO','Lviv Intl','UA','L´viv','L´vivs´ka',NULL,49.8125,23.956111,327,2);
 INSERT INTO airport VALUES ('AUH','Abu Dhabi Intl','UAE','Abu Dhabi','United Arab Emirates',NULL,24.432972,54.651138,27,4);
 INSERT INTO airport VALUES ('AAN','Al Ain International Airport','UAE','Al Ain','United Arab Emirates',NULL,24.261667,55.609167,265,4);
 INSERT INTO airport VALUES ('DXB','Dubai Intl','UAE','Dubai','United Arab Emirates',NULL,25.252778,55.364444,19,4);
 INSERT INTO airport VALUES ('SHJ','Sharjah Intl','UAE','Al Sharjah','United Arab Emirates',NULL,25.328575,55.51715,34,4);
 INSERT INTO airport VALUES ('STN','Stansted','GB','London','London','Great Britain',51.885,.235,106,0);
 INSERT INTO airport VALUES ('LBA','Leeds Bradford','GB','Leeds','Yorkshire and the Humber','Great Britain',53.865897,-1.660569,208,0);
 INSERT INTO airport VALUES ('LCY','City','GB','London','London','Great Britain',51.505278,.055278,6,0);
 INSERT INTO airport VALUES ('LGW','Gatwick','GB','London','London','Great Britain',51.148056,-0.190278,62,0);
 INSERT INTO airport VALUES ('LHR','Heathrow','GB','London','London','Great Britain',51.4775,-0.461389,25,0);
 INSERT INTO airport VALUES ('LPL','Liverpool','GB','Liverpool','North West','Great Britain',53.333611,-2.849722,24,0);
 INSERT INTO airport VALUES ('BHX','Birmingham','GB','Birmingham','West Midlands','Great Britain',52.453856,-1.748028,100,0);
 INSERT INTO airport VALUES ('TRE','Tiree','GB',NULL,NULL,'Tiree',56.499167,-6.869167,12,0);
 INSERT INTO airport VALUES ('BLK','Blackpool','GB','Blackpool','North West','Great Britain',53.771667,-3.028611,10,0);
 INSERT INTO airport VALUES ('BEB','Benbecula','GB',NULL,NULL,'Benbecula',57.481111,-7.362778,6,0);
 INSERT INTO airport VALUES ('ABZ','Dyce','GB','Aberdeen','Scotland','Great Britain',57.201944,-2.197778,66,0);
 INSERT INTO airport VALUES ('BFS','Aldergrove','GB','Belfast','Northern Ireland','Ireland',54.6575,-6.215833,82,0);
 INSERT INTO airport VALUES ('BHD','City','GB','Belfast','Northern Ireland','Ireland',54.618056,-5.8725,5,0);
 INSERT INTO airport VALUES ('EXT','Exeter','GB','Exeter','South West','Great Britain',50.734444,-3.413889,31,0);
 INSERT INTO airport VALUES ('NCL','Newcastle','GB','Newcastle upon Tyne','North East','Great Britain',55.0375,-1.691667,81,0);
 INSERT INTO airport VALUES ('EMA','Nottingham East Midlands','GB','Nottingham','East Midlands','Great Britain',52.831111,-1.328056,93,0);
 INSERT INTO airport VALUES ('NWI','Norwich','GB','Norwich','East of England','Great Britain',52.675833,1.282778,36,0);
 INSERT INTO airport VALUES ('BOH','Bournemouth','GB','Bournemouth','South West','Great Britain',50.78,-1.8425,12,0);
 INSERT INTO airport VALUES ('DND','Dundee','GB','Dundee','Scotland','Great Britain',56.452499,-3.025833,5,0);
 INSERT INTO airport VALUES ('DSA','Robin Hood Doncaster Sheffield Airport','GB','Sheffield','Yorkshire and the Humber','Great Britain',53.474722,-1.004444,17,0);
 INSERT INTO airport VALUES ('MME','Durham Tees Valley Airport','GB','Middlesbrough','North East','Great Britain',54.509189,-1.429406,37,0);
 INSERT INTO airport VALUES ('MAN','Manchester','GB','Manchester','North West','Great Britain',53.353744,-2.27495,78,0);
 INSERT INTO airport VALUES ('EDI','Edinburgh','GB','Edinburgh','Scotland','Great Britain',55.95,-3.3725,41,0);
 INSERT INTO airport VALUES ('SOU','Southampton','GB','Southampton','South East','Great Britain',50.950261,-1.356803,13,0);
 INSERT INTO airport VALUES ('LTN','Luton','GB','Luton','East of England','Great Britain',51.874722,-0.368333,160,0);
 INSERT INTO airport VALUES ('BRR','Barra Airport','GB',NULL,NULL,'Barra',57.0228,-7.44306,2,0);
 INSERT INTO airport VALUES ('BRS','Bristol','GB','Bristol','South West','Great Britain',51.382669,-2.719089,190,0);
 INSERT INTO airport VALUES ('HUY','Humberside','GB','Kingston upon Hull','Yorkshire and the Humber','Great Britain',53.574444,-0.350833,37,0);
 INSERT INTO airport VALUES ('ILY','Islay','GB',NULL,NULL,'Islay',55.681944,-6.256667,17,0);
 INSERT INTO airport VALUES ('GLO','Gloucestershire','GB','Gloucester','South West','Great Britain',51.894167,-2.167222,31,0);
 INSERT INTO airport VALUES ('GLA','Glasgow','GB','Glasgow','Scotland','Great Britain',55.871944,-4.433056,8,0);
 INSERT INTO airport VALUES ('SEN','Southend','GB','Southend-on-Sea','East of England','Great Britain',51.571389,.695556,15,0);
 INSERT INTO airport VALUES ('CWL','Cardiff','GB','Cardiff','Wales','Great Britain',51.396667,-3.343333,67,0);
 INSERT INTO airport VALUES ('KOI','Kirkwall','GB','Kirkwall','Scotland','Orkney Mainland',58.957778,-2.905,15,0);
 INSERT INTO airport VALUES ('LRD','Laredo Intl','USA','Laredo','Texas',NULL,27.54375,-99.461556,155,-6);
 INSERT INTO airport VALUES ('CMH','Port Columbus Intl','USA','Columbus','Ohio',NULL,39.997972,-82.891889,248,-5);
 INSERT INTO airport VALUES ('DSM','Des Moines Intl','USA','Des Moines','Iowa',NULL,41.533972,-93.663083,292,-6);
 INSERT INTO airport VALUES ('DTW','Detroit Metro Wayne Co','USA','Detroit','Michigan',NULL,42.212444,-83.353389,197,-5);
 INSERT INTO airport VALUES ('MSY','Louis Armstrong New Orleans Intl','USA','New Orleans','Louisiana',NULL,29.993389,-90.258028,1,-6);
 INSERT INTO airport VALUES ('MSP','Minneapolis St Paul Intl','USA','Minneapolis','Minnesota',NULL,44.881956,-93.221767,256,-6);
 INSERT INTO airport VALUES ('MSN','Dane Co Rgnl Truax Fld','USA','Madison','Wisconsin',NULL,43.139858,-89.337514,270,-6);
 INSERT INTO airport VALUES ('FAR','Hector International Airport','USA','Fargo','North Dakota',NULL,46.92065,-96.8157639,275,-6);
 INSERT INTO airport VALUES ('FAT','Fresno Yosemite Intl','USA','Fresno','California',NULL,36.776194,-119.71814,102,-8);
 INSERT INTO airport VALUES ('ELP','El Paso Intl','USA','El Paso','Texas',NULL,31.80725,-106.377583,1207,-7);
 INSERT INTO airport VALUES ('EVV','Evansville Regional','USA','Evansville','Indiana',NULL,38.036997,-87.532364,127,-6);
 INSERT INTO airport VALUES ('EWR','Newark Liberty Intl','USA','Newark','New Jersey',NULL,40.6925,-74.168667,5,-5);
 INSERT INTO airport VALUES ('EUG','Mahlon Sweet Fld','USA','Eugene','Oregon',NULL,44.124583,-123.211972,114,-8);
 INSERT INTO airport VALUES ('ERI','Erie Intl Tom Ridge Fld','USA','Erie','Pennsylvania',NULL,42.082022,-80.176217,223,-5);
 INSERT INTO airport VALUES ('MKE','General Mitchell Intl','USA','Milwaukee','Wisconsin',NULL,42.947222,-87.896583,220,-6);
 INSERT INTO airport VALUES ('MKL','Mc Kellar Sipes Rgnl','USA','Jackson','Mississippi',NULL,35.599889,-88.915611,132,-6);
 INSERT INTO airport VALUES ('DFW','Dallas Fort Worth Intl','USA','Dallas','Texas',NULL,32.896828,-97.037997,185,-6);
 INSERT INTO airport VALUES ('MIA','Miami Intl','USA','Miami','Florida',NULL,25.79325,-80.290556,2,-5);
 INSERT INTO airport VALUES ('MDT','Harrisburg Intl','USA','Harrisburg','Pennsylvania',NULL,40.193494,-76.763403,95,-5);
 INSERT INTO airport VALUES ('MEM','Memphis Intl','USA','Memphis','Tennessee',NULL,35.042417,-89.976667,104,-6);
 INSERT INTO airport VALUES ('MDW','Chicago Midway Intl','USA','Chicago','Illinois',NULL,41.785972,-87.752417,189,-6);
 INSERT INTO airport VALUES ('MCI','Kansas City Intl','USA','Kansas City','Missouri',NULL,39.297606,-94.713905,313,-6);
 INSERT INTO airport VALUES ('MCO','Orlando Intl','USA','Orlando','Florida',NULL,28.429394,-81.308994,29,-5);
 INSERT INTO airport VALUES ('MOB','Mobile Rgnl','USA','Mobile','Alabama',NULL,30.691231,-88.242814,67,-6);
 INSERT INTO airport VALUES ('MOD','Modesto City Co Harry Sham','USA','Modesto','California',NULL,37.625817,-120.954422,30,-8);
 INSERT INTO airport VALUES ('SDF','Louisville International Airport','USA','Louisville','Kentucky',NULL,38.1740858,-85.7364989,153,-5);
 INSERT INTO airport VALUES ('CLE','Cleveland Hopkins Intl','USA','Cleveland','Ohio',NULL,41.411689,-81.849794,241,-5);
 INSERT INTO airport VALUES ('SEA','Seattle Tacoma Intl','USA','Seattle','Washington',NULL,47.449,-122.309306,132,-8);
 INSERT INTO airport VALUES ('SFO','San Francisco Intl','USA','San Francisco','California',NULL,37.618972,-122.374889,4,-8);
 INSERT INTO airport VALUES ('CHS','Charleston Afb Intl','USA','Charleston','West Virginia',NULL,32.898647,-80.040528,14,-5);
 INSERT INTO airport VALUES ('SGF','Springfield Branson Natl','USA','Springfield','Missouri',NULL,37.245667,-93.388639,387,-6);
 INSERT INTO airport VALUES ('SPS','Sheppard Afb Wichita Falls Muni','USA','Wichita Falls','Texas',NULL,33.988797,-98.491894,311,-6);
 INSERT INTO airport VALUES ('LNK','Lincoln','USA','Lincoln','Nebraska',NULL,40.850971,-96.75925,372,-6);
 INSERT INTO airport VALUES ('COS','City Of Colorado Springs Muni','USA','Colorado Springs','Colorado',NULL,38.805805,-104.700778,1886,-7);
 INSERT INTO airport VALUES ('CLT','Charlotte Douglas Intl','USA','Charlotte','North Carolina',NULL,35.214,-80.943139,228,-5);
 INSERT INTO airport VALUES ('ALB','Albany Intl','USA','Albany','New York',NULL,42.748267,-73.801692,87,-5);
 INSERT INTO airport VALUES ('BNA','Nashville Intl','USA','Nashville-Davidson','Tennessee',NULL,36.124472,-86.678194,183,-6);
 INSERT INTO airport VALUES ('TPA','Tampa Intl','USA','Tampa','Florida',NULL,27.975472,-82.53325,8,-5);
 INSERT INTO airport VALUES ('BOI','Boise Air Terminal','USA','Boise City','Idaho',NULL,43.564361,-116.222861,875,-7);
 INSERT INTO airport VALUES ('BOS','General Edward Lawrence Logan Intl','USA','Boston','Massachusetts',NULL,42.364347,-71.005181,6,-5);
 INSERT INTO airport VALUES ('MVY','Martha''s Vineyard','USA',NULL,NULL,'Marthas Vineyard',41.391667,-70.615278,20,-5);
 INSERT INTO airport VALUES ('ACK','Nantucket Mem','USA',NULL,NULL,'Nantucket',41.253053,-70.060181,15,-5);
 INSERT INTO airport VALUES ('AMA','Rick Husband Amarillo Intl','USA','Amarillo','Texas',NULL,35.219369,-101.705931,1100,-6);
 INSERT INTO airport VALUES ('TOL','Toledo','USA','Toledo','Ohio',NULL,41.586806,-83.807833,209,-5);
 INSERT INTO airport VALUES ('SYR','Syracuse Hancock Intl','USA','Syracuse','New York',NULL,43.111187,-76.106311,128,-5);
 INSERT INTO airport VALUES ('CVG','Cincinnati Northern Kentucky Intl','USA','Cincinnati','Ohio',NULL,39.048836,-84.667822,273,-5);
 INSERT INTO airport VALUES ('STL','Lambert St Louis Intl','USA','St. Louis','Missouri',NULL,38.748697,-90.370028,188,-6);
 INSERT INTO airport VALUES ('CYS','Cheyenne Rgnl Jerry Olson Fld','USA','Cheyenne','Wyoming',NULL,41.155722,-104.811839,1877,-7);
 INSERT INTO airport VALUES ('DAL','Dallas Love Fld','USA','Dallas','Texas',NULL,32.847111,-96.851778,148,-6);
 INSERT INTO airport VALUES ('DAY','James M Cox Dayton Intl','USA','Dayton','Ohio',NULL,39.902375,-84.219375,308,-5);
 INSERT INTO airport VALUES ('LAS','Mc Carran Intl','USA','Las Vegas','Nevada',NULL,36.080056,-115.15225,653,-8);
 INSERT INTO airport VALUES ('LAN','Capital City','USA','Lansing','Michigan',NULL,42.7787,-84.587357,263,-5);
 INSERT INTO airport VALUES ('CRP','Corpus Christi Intl','USA','Corpus Christi','Texas',NULL,27.770361,-97.501222,13,-6);
 INSERT INTO airport VALUES ('SLC','Salt Lake City Intl','USA','Salt Lake City','Utah',NULL,40.788389,-111.977772,1289,-7);
 INSERT INTO airport VALUES ('CRW','Yeager','USA','Charleston','West Virginia',NULL,38.373147,-81.593189,299,-5);
 INSERT INTO airport VALUES ('CSG','Columbus Metropolitan Airport','USA','Columbus','Georgia',NULL,32.5163333,-84.9388611,121,-5);
 INSERT INTO airport VALUES ('SMF','Sacramento Intl','USA','Sacramento','California',NULL,38.695417,-121.590778,8,-8);
 INSERT INTO airport VALUES ('LUK','Cincinnati Muni Lunken Fld','USA','Cincinnati','Ohio',NULL,39.103333,-84.418611,147,-5);
 INSERT INTO airport VALUES ('SNA','John Wayne Arpt Orange Co','USA','Santa Ana','California',NULL,33.675667,-117.868222,17,-8);
 INSERT INTO airport VALUES ('LAX','Los Angeles Intl','USA','Los Angeles','California',NULL,33.942536,-118.408075,38,-8);
 INSERT INTO airport VALUES ('LBB','Lubbock Preston Smith Intl','USA','Lubbock','Texas',NULL,33.663639,-101.822778,1001,-6);
 INSERT INTO airport VALUES ('DEN','Denver Intl','USA','Denver','Colorado',NULL,39.861656,-104.673178,1656,-7);
 INSERT INTO airport VALUES ('DCA','Ronald Reagan Washington Natl','USA','Washington','District of Columbia',NULL,38.852083,-77.037722,5,-5);
 INSERT INTO airport VALUES ('LGB','Long Beach','USA','Long Beach','California',NULL,33.817722,-118.151611,18,-8);
 INSERT INTO airport VALUES ('LGA','La Guardia','USA','New York','New York','Long Island',40.777245,-73.872608,7,-5);
 INSERT INTO airport VALUES ('CHA','Lovell Fld','USA','Chattanooga','Tennessee',NULL,35.035278,-85.203808,208,-5);
 INSERT INTO airport VALUES ('SHV','Shreveport Rgnl','USA','Shreveport','Louisiana',NULL,32.446629,-93.8256,79,-6);
 INSERT INTO airport VALUES ('LIT','Adams Fld','USA','Little Rock','Arkansas',NULL,34.729444,-92.224306,80,-6);
 INSERT INTO airport VALUES ('SJC','Norman Y Mineta San Jose Intl','USA','San Jose','California',NULL,37.3626,-121.929022,19,-8);
 INSERT INTO airport VALUES ('BHM','Birmingham Intl','USA','Birmingham','Alabama',NULL,33.562942,-86.75355,196,-6);
 INSERT INTO airport VALUES ('BIS','Bismarck Municipal Airport','USA','Bismarck','North Dakota',NULL,46.775842,-100.757931,506,-6);
 INSERT INTO airport VALUES ('BIL','Billings Logan International Airport','USA','Billings','Montana',NULL,45.80921,-108.537654,1113,-7);
 INSERT INTO airport VALUES ('TUL','Tulsa Intl','USA','Tulsa','Oklahoma',NULL,36.198389,-95.888111,206,-6);
 INSERT INTO airport VALUES ('TUS','Tucson Intl','USA','Tucson','Arizona',NULL,32.116083,-110.941028,806,-7);
 INSERT INTO airport VALUES ('RNO','Reno Tahoe Intl','USA','Reno','Nevada',NULL,39.499108,-119.768108,1346,-8);
 INSERT INTO airport VALUES ('BUF','Buffalo Niagara Intl','USA','Buffalo','New York',NULL,42.940525,-78.732167,221,-5);
 INSERT INTO airport VALUES ('ATL','Hartsfield Jackson Atlanta Intl','USA','Atlanta','Georgia',NULL,33.636719,-84.428067,313,-5);
 INSERT INTO airport VALUES ('BTR','Baton Rouge Metro Ryan Fld','USA','Baton Rouge','Louisiana',NULL,30.533167,-91.149639,21,-6);
 INSERT INTO airport VALUES ('AUS','Austin Bergstrom Intl','USA','Austin','Texas',NULL,30.194528,-97.669889,165,-6);
 INSERT INTO airport VALUES ('TYS','Mc Ghee Tyson','USA','Knoxville','Tennessee',NULL,35.810972,-83.994028,299,-5);
 INSERT INTO airport VALUES ('BWI','Baltimore Washington Intl','USA','Baltimore','Maryland',NULL,39.175361,-76.668333,45,-5);
 INSERT INTO airport VALUES ('CAK','Akron Canton Regional Airport','USA','Akron','Ohio',NULL,40.9160833,-81.4421944,374,-5);
 INSERT INTO airport VALUES ('ABE','Lehigh Valley Intl','USA','Allentown','Pennsylvania',NULL,40.652083,-75.440806,120,-5);
 INSERT INTO airport VALUES ('ABI','Abilene Rgnl','USA','Abilene','Texas',NULL,32.411319,-99.681897,546,-6);
 INSERT INTO airport VALUES ('TLH','Tallahassee Rgnl','USA','Tallahassee','Florida',NULL,30.396528,-84.350333,25,-5);
 INSERT INTO airport VALUES ('ACT','Waco Rgnl','USA','Waco','Texas',NULL,31.611289,-97.230519,157,-6);
 INSERT INTO airport VALUES ('ABQ','Albuquerque International Sunport','USA','Albuquerque','New Mexico',NULL,35.0402222,-106.6091944,1633,-7);
 INSERT INTO airport VALUES ('SAN','San Diego Intl','USA','San Diego','California',NULL,32.733556,-117.189667,5,-8);
 INSERT INTO airport VALUES ('SAT','San Antonio Intl','USA','San Antonio','Texas',NULL,29.533694,-98.469778,247,-6);
 INSERT INTO airport VALUES ('SAV','Savannah Hilton Head Intl','USA','Savannah','Georgia',NULL,32.127583,-81.202139,16,-5);
 INSERT INTO airport VALUES ('PWM','Portland Intl Jetport','USA','Portland','Maine',NULL,43.646161,-70.309281,23,-5);
 INSERT INTO airport VALUES ('PVD','Theodore Francis Green State','USA','Providence','Rhode Island',NULL,41.732581,-71.420383,17,-5);
 INSERT INTO airport VALUES ('IND','Indianapolis Intl','USA','Indianapolis','Indiana',NULL,39.717331,-86.294383,243,-5);
 INSERT INTO airport VALUES ('IAD','Washington Dulles Intl','USA','Washington','District of Columbia',NULL,38.944533,-77.455811,95,-5);
 INSERT INTO airport VALUES ('IAH','George Bush Intcntl Houston','USA','Houston','Texas',NULL,29.984433,-95.341442,30,-6);
 INSERT INTO airport VALUES ('ICT','Wichita Mid Continent','USA','Wichita','Kansas',NULL,37.649944,-97.433056,406,-6);
 INSERT INTO airport VALUES ('HOU','William P Hobby','USA','Houston','Texas',NULL,29.645419,-95.278889,14,-6);
 INSERT INTO airport VALUES ('ROC','Greater Rochester Intl','USA','Rochester','New York',NULL,43.118866,-77.672389,170,-5);
 INSERT INTO airport VALUES ('FLL','Fort Lauderdale Hollywood Intl','USA','Fort Lauderdale','Florida',NULL,26.072583,-80.15275,3,-5);
 INSERT INTO airport VALUES ('OMA','Eppley Afld','USA','Omaha','Nebraska',NULL,41.303167,-95.894069,300,-6);
 INSERT INTO airport VALUES ('PDX','Portland Intl','USA','Portland','Oregon',NULL,45.588722,-122.5975,9,-8);
 INSERT INTO airport VALUES ('ORF','Norfolk Intl','USA','Norfolk','Virginia',NULL,36.894611,-76.201222,8,-5);
 INSERT INTO airport VALUES ('ORD','Chicago Ohare Intl','USA','Chicago','Illinois',NULL,41.978603,-87.904842,204,-6);
 INSERT INTO airport VALUES ('FNT','Bishop International','USA','Flint','Michigan',NULL,42.965424,-83.743629,238,-5);
 INSERT INTO airport VALUES ('PHX','Phoenix Sky Harbor Intl','USA','Phoenix','Arizona',NULL,33.434278,-112.011583,346,-7);
 INSERT INTO airport VALUES ('PIT','Pittsburgh Intl','USA','Pittsburgh','Pennsylvania',NULL,40.491467,-80.232872,367,-5);
 INSERT INTO airport VALUES ('PIR','Pierre Regional Airport','USA','Pierre','South Dakota',NULL,44.3827,-100.286,531,-6);
 INSERT INTO airport VALUES ('PHL','Philadelphia Intl','USA','Philadelphia','Pennsylvania',NULL,39.871944,-75.241139,11,-5);
 INSERT INTO airport VALUES ('HLN','Helena Rgnl','USA','Helena','Montana',NULL,46.606806,-111.98275,1182,-7);
 INSERT INTO airport VALUES ('GEG','Spokane Intl','USA','Spokane','Washington',NULL,47.619861,-117.533833,724,-8);
 INSERT INTO airport VALUES ('OKC','Will Rogers World','USA','Oklahoma City','Oklahoma',NULL,35.393089,-97.600733,395,-6);
 INSERT INTO airport VALUES ('RIC','Richmond Intl','USA','Richmond','Virginia',NULL,37.505167,-77.319667,51,-5);
 INSERT INTO airport VALUES ('JFK','John F Kennedy Intl','USA','New York','New York','Long Island',40.639751,-73.778925,4,-5);
 INSERT INTO airport VALUES ('JAX','Jacksonville Intl','USA','Jacksonville','Florida',NULL,30.494056,-81.687861,9,-5);
 INSERT INTO airport VALUES ('JAN','Jackson Evers Intl','USA','Jackson','Mississippi',NULL,32.311167,-90.075889,105,-6);
 INSERT INTO airport VALUES ('SAF','Santa Fe Muni','USA','Santa Fe','New Mexico',NULL,35.617108,-106.089422,1935,-7);
 INSERT INTO airport VALUES ('OAJ','Albert J Ellis','USA','Jacksonville','Florida',NULL,34.829164,-77.612139,29,-5);
 INSERT INTO airport VALUES ('OAK','Metropolitan Oakland Intl','USA','Oakland','California',NULL,37.721278,-122.220722,3,-8);
 INSERT INTO airport VALUES ('JNU','Juneau Intl','USA','Juneau','Alaska',NULL,58.354972,-134.576278,6,-9);
 INSERT INTO airport VALUES ('ANC','Ted Stevens Anchorage Intl','USA','Anchorage','Alaska',NULL,61.174361,-149.996361,46,-9);
 INSERT INTO airport VALUES ('HNL','Honolulu Intl','USA','Honolulu','Hawaii','Oahu',21.318681,-157.922428,4,-10);
 INSERT INTO airport VALUES ('ITO','Hilo Intl','USA','Hilo','Hawaii','Hawaii',19.721375,-155.048469,12,-10);
 INSERT INTO airport VALUES ('LNY','Lanai','USA',NULL,NULL,'Lanai',20.785611,-156.951419,399,-10);
 INSERT INTO airport VALUES ('MKK','Molokai','USA',NULL,NULL,'Molokai',21.152886,-157.096256,138,-10);
 INSERT INTO airport VALUES ('OGG','Kahului','USA',NULL,NULL,'Maui',20.89865,-156.430458,16,-10);
 INSERT INTO airport VALUES ('MVD','Carrasco Intl','ROU','Montevideo','Uruguay',NULL,-34.838417,-56.030806,32,-3);
 INSERT INTO airport VALUES ('BHK','Bukhara','UZB','Buxoro','Buxoro',NULL,39.775,64.483333,229,5);
 INSERT INTO airport VALUES ('UGC','Urgench Airport','UZB','Urganch','Xorazm',NULL,41.5843,60.6417,98,5);
 INSERT INTO airport VALUES ('TMJ','Termez Airport','UZB','Termiz','Surkhandarya',NULL,37.286667,67.31,313,5);
 INSERT INTO airport VALUES ('TAS','Yuzhny','UZB','Toshkent','Toshkent City',NULL,41.257861,69.281186,432,5);
 INSERT INTO airport VALUES ('NCU','Nukus Airport','UZB','Nukus','Qoraqalpogʻiston',NULL,42.4884,59.6233,75,5);
 INSERT INTO airport VALUES ('FEG','Fergana Airport','UZB','Farg''ona','Fargʻona',NULL,40.3588,71.745,604,5);
 INSERT INTO airport VALUES ('SKD','Samarkand','UZB','Samarqand','Samarqand',NULL,39.700547,66.983829,678,5);
 INSERT INTO airport VALUES ('VLI','Port Vila Bauerfield','VU','Port Vila','Vanuatu','Efate',-17.699325,168.319794,21,11);
 INSERT INTO airport VALUES ('PZO','General Manuel Carlos Piar','YV','Ciudad Guayana','Bolívar',NULL,8.288528,-62.760361,144,-4);
 INSERT INTO airport VALUES ('BLA','General Jose Antonio Anzoategui Intl','YV','Barcelona','Anzoátegui',NULL,10.107139,-64.689161,8,-4);
 INSERT INTO airport VALUES ('PYH','Casique Aramare','YV','Puerto Ayacucho','Amazonas',NULL,5.619992,-67.606103,75,-4);
 INSERT INTO airport VALUES ('BNS','Barinas','YV','Barinas','Barinas',NULL,8.619575,-70.220825,203,-4);
 INSERT INTO airport VALUES ('BRM','Barquisimeto Intl','YV','Barquisimeto','Lara',NULL,10.042747,-69.358619,623,-4);
 INSERT INTO airport VALUES ('MAR','La Chinita Intl','YV','Maracaibo','Zulia',NULL,10.558208,-71.727856,72,-4);
 INSERT INTO airport VALUES ('VLN','Arturo Michelena Intl','YV','Valencia','Carabobo',NULL,10.149733,-67.9284,432,-4);
 INSERT INTO airport VALUES ('MUN','Maturin','YV','Maturín','Monagas',NULL,9.749067,-63.1534,68,-4);
 INSERT INTO airport VALUES ('CCS','Simon Bolivar Intl','YV','Caracas','Distrito Federal',NULL,10.603117,-66.990583,72,-4);
 INSERT INTO airport VALUES ('VKG','Rach Gia','VN','Rach Gia','Mekong River Delta',NULL,9.949676,105.133659,2,7);
 INSERT INTO airport VALUES ('VII','Vinh Airport','VN','Vinh','North and South Central Coast',NULL,18.737569,105.670764,7,7);
 INSERT INTO airport VALUES ('SGN','Tansonnhat Intl','VN','Ho Chi Minh','Southeast',NULL,10.818797,106.651856,10,7);
 INSERT INTO airport VALUES ('HAN','Noibai Intl','VN','Hanoi','Red River Delta',NULL,21.221192,105.807178,12,7);
 INSERT INTO airport VALUES ('HPH','Cat Bi International Airport','VN','Haiphong','Red River Delta',NULL,20.819386,106.724989,2,7);
 INSERT INTO airport VALUES ('VCA','Tra Noc Airport','VN','Can Tho','Mekong River Delta',NULL,10.085119,105.711922,3,7);
 INSERT INTO airport VALUES ('NHA','Nha Trang','VN','Nha Trang','North and South Central Coast',NULL,12.227467,109.192322,6,7);
 INSERT INTO airport VALUES ('STT','Cyril E King','VIRG','Charlotte Amalie','Virgin Islands','Saint Thomas',18.337306,-64.973361,7,-4);
 INSERT INTO airport VALUES ('WLS','Wallis','WAFU','Mata-Utu','Wallis and Futuna','Uvea',-13.238281,-176.199228,24,12);
 INSERT INTO airport VALUES ('EUN','Hassan I Airport','WSA','El Aaiun','Western Sahara',NULL,27.1517,-13.2192,63,0);
 INSERT INTO airport VALUES ('SAH','Sanaa Intl','YE','Sana''a','Yemen',NULL,15.476258,44.219739,2200,3);
 INSERT INTO airport VALUES ('HOD','Hodeidah Intl','YE','al Hudaydah','Yemen',NULL,14.753,42.976336,13,3);
 INSERT INTO airport VALUES ('TAI','Taiz Intl','YE','Ta''izz','Yemen',NULL,13.685964,44.139056,1475,3);
 INSERT INTO airport VALUES ('ADE','Aden Intl','YE','Aden','Yemen',NULL,12.829542,45.028792,2,3);
 INSERT INTO airport VALUES ('LVI','Livingstone','Z','Livingstone','Southern',NULL,-17.821756,25.822692,1007,2);
 INSERT INTO airport VALUES ('NLA','Ndola','Z','Ndola','Copperbelt',NULL,-12.998139,28.664944,1270,2);
 INSERT INTO airport VALUES ('LUN','Lusaka Intl','Z','Lusaka','Lusaka',NULL,-15.330817,28.452628,1152,2);
 INSERT INTO airport VALUES ('BUQ','J M Nkomo Intl','ZW','Bulawayo','Zimbabwe',NULL,-20.017431,28.617869,1329,2);
 INSERT INTO airport VALUES ('HRE','Harare Intl','ZW','Harare','Zimbabwe',NULL,-17.931806,31.092847,1490,2);