Airlines

airlines.sql

CREATE TABLE airlines(
   ICAO              VARCHAR(3) NOT NULL PRIMARY KEY
  ,IATA              VARCHAR(2) NOT NULL
  ,Airline           VARCHAR(52) NOT NULL
  ,Callsign          VARCHAR(29)
  ,Country_of_Origin VARCHAR(26)
);
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JOR','0B','Blue Air','Blue Transport','Romania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AMB','1I','Deutsche Rettungsflugwacht','Civil Air Ambulance','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EJA','1I','Netjets','Execjet','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DBB','2A','Deutsche Bahn',NULL,'Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TGV','2C','SNCF',NULL,'France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DYA','2D','Dynamic Airways/Dynamic International Airways','Dynamic Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AGU','2G','Angara Airlines','Sarma','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SRU','2I','Star Peru','Star Up','Peru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VBW','2J','Air Burkina','Burkina','Burkina Faso');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GLG','2K','Aerogal Aerolineas Galapagos','Aerogal','Ecuador');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BOL','2L','Transportes Aereos Bolivianos','Bol','Bolivia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OAW','2L','Helvetic Airways','Helvetic','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NTJ','2N','Nextjet','Nextjet','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GAP','2P','PAL Express','Airphil','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SNC','2Q','Air Cargo Carriers','Night Cargo','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CMV','3C','Calima Aviacion','Calima','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GSB','3G','Gading Sari Aviation Services','Gading Sari','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIE','3H','Air Inuit','Air Inuit','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JBW','3J','Jubba Airways','Airjub','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JSA','3K','Jetstar Asia Airways','Jetstar Asia','Singapore');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ISK','3L','Intersky','Intersky','Austria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SIL','3M','Silver Airways','Silver Wings','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('URG','3N','Air Urga','Urga','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MAC','3O','Air Arabia Maroc','Nawras','Morocco');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TNM','3P','Tiara Air','Tiara','Aruba');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RGR','3R','Avior Regional','Avior RegionalGromov Airline','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BOX','3S','AeroLogic','German Cargo','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GUY','3S','Air Guyane Express/Air Antilles Express','Green Bird','French Guiana');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TRQ','3T','Tarco Airlines','Airtarco','Sudan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSC','3U','Sichuan Airlines','Si Chuan','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAY','3V','TNT Airways','Quality','Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MWI','3W','Malawian Airlines',NULL,'Malawi');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XBO','3Y','Baseops International',NULL,'USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TVP','3Z','Travel Service Polska','Jettravel','Poland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AKL','4A','Air Kiribati',NULL,'Kiribati');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TUP','4B','Aviastar-TU','Tupolevair','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BTQ','4B','Boutique Air','Boutique','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ARE','4C','LAN Colombia','Aires','Colombia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ASD','4D','Air Sinai','Air Sinai','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SBO','4E','Stabo Air','Stabair','Zambia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GZP','4G','Gazpromavia','Gazprom','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UBD','4H','United Airways','United Bangladesh','Bangladesh');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IZM','4I','Izair','Izmir','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FDK','4J','FlyDamas','Damavia','Syria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KBA','4K','Kenn Borek Air','Borek Air','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DSM','4M','LAN Argentina','Lan Ar','Argentina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANT','4N','Air North Charter','Air North','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIJ','4O','Interjet/ABC Aerolineas','ABC Aerolineas','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SFW','4Q','Safi Airways','Safi Airways','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OLC','4S','Solar Cargo','Solarcargo','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BHP','4T','Belair Airlines','Belair','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GWI','4U','Germanwings','Germanwings','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AJK','4W','Allied Air Cargo','Bambi','Nigeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WAV','4W','Warbelow�s Air Ventures','Warbelow','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MEC','4X','Air Mercury/Mercury Air Cargo','Mercair','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TUD','4Y','Flight Alaska/Yute Air','Tundra','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LNK','4Z','SA Airlink/Airlink','Link','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIP','5A','Alpine Air Express','Alpine Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BSX','5B','Bassaka Air','Bassaka','Cambodia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ICL','5C','CAL Cargo Air Lines/Cavei Avir Levitanim','Cal','Israel');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NRR','5C','Nature Air','Nature Air','Costa Rica');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SLI','5D','Aeromexico Connect','Costera','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FFV','5H','Fly540/Five Forty Aviation','Swift Tango','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CEB','5J','Cebu Pacific Air','Cebu Air','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HFY','5K','Hifly','Sky Flyer','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MNT','5M','FlyMontserrat/Montserrat Airways','Montserrat','Montserrat');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AUL','5N','Nordavia','Archangelsk Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FPO','5O','Europe Airpost','French Post','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BVR','5P','ACM Air Charter','Bavarian','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RUC','5R','Rutas Aereas CA/RUTACA Airlines','Rutaca','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GAK','5S','Global Aviation and Services Group','Aviagroup','Libya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PSV','5S','Servicios Aereos Profesionales','Proservicios','Dominican Rep.');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MPE','5T','Canadian North','Empress','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TGU','5U','Transportes Aereos Guatemaltecos','Chapin','Guatemala');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VTS','5V','Everts Air/Tatonduk Outfitters','Everts','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UPS','5X','UPS Airlines/United Parcel Service','UPS','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GTI','5Y','Atlas Air','Giant','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KEM','5Z','CemAir','CemAir','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BLX','6B','TUIfly Nordic','Bluescan','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PAS','6D','Pelita Air Service','Pelita','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IGO','6E','IndiGo Airlines','Ifly','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FAO','6F','Falcon Air Express','Panther','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FRJ','6F','Afrijet Airlines','Afrijet','Nigeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RLX','6G','Go2Sky','Relax','Slovakia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ISR','6H','Israir','Israir','Israel');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IBZ','6I','International Business Air','Interbiz','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MMD','6I','Alsie Express/MMD','Mermaid','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VVA','6I','Aviast','Ialsi','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SNJ','6J','Skynet Asia Airways','Newsky','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AKK','6L','Aklak Air','Aklak','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DRU','6R','Alrosa Mirny Air Enterprise','Mirny','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TNO','6R','Aerounion/Aerotransporte de Carga Union','Aero Union','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LMT','6T','Almaty Aviation','Almaty','Kazakhstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SOV','6W','Saravia Saratov Airlines','Saratov Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LTC','6Y','SmartLynx Airlines','Latcharter','Latvia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('COY','7C','Coyne Airways','Coyne Air','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JJA','7C','Jeju Air','Jeju Air','Korea � Rep. of');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWU','7E','Sylt Air','Sylt-Air','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FAB','7F','First Air','First Air','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SFJ','7G','StarFlyer','Starflyer','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAI','7H','Corendon Airlines','Corendon','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ERH','7H','ERA Aviation','Erah','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSV','7I','Coastal Travel Limited','Coastal Travel','Tanzania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('INC','7I','Insel Air','Inselair','Curacao');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TJK','7J','Tajik Air','Tajik Air','Tajikistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KGL','7K','Metrojet/Kolavia/Kogalymavia Airlines','Kogalym','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CRN','7L','Aero Caribbean','Aerocaribbean','Cuba');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAG','7M','Air Atlantique','Atlantic','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TLR','7Q','Air Libya','Air Libya','Libya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RYA','7S','Arctic Transportation Services/Ryan Air Services','Ryan Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AGV','7T','Air Glaciers','Air Glaciers','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RTM','7T','Aero Express Del Ecuador','Aero Transam','Ecuador');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TOB','7T','Tobruk Air Transport and Cargo','Tobruk Air','Libya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WRC','7W','Wind Rose Aviation','Windrose','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AGO','7Y','Angola Air Charter','Angola Charter','Angola');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NYL','7Y','Mid Airlines','Nile','Sudan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ATN','8C','Air Transport International ATI','Air Transport','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EXV','8D','Expo Aviation','Expo Avia','Sri Lanka');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BRG','8E','Bering Air','Bering Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('STP','8F','STP Airways','Saotome Airways','Sao Tome and Principe');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BGH','8H','BH Air','Balkan Holidays','Bulgaria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LKE','8L','Lucky Air','Lucky Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RHC','8L','Redhill Aviation','Redair','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MMA','8M','Myanmar Airways International','Myanmar','Myanmar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NKF','8N','Barents AirLink/Nordkalottflyg','Nordflight','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PCO','8P','Pacific Coastal Airlines','Pasco','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BAJ','8Q','Baker Aviation','Baker Aviation','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OHY','8Q','Onur Air','Onur Air','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OLS','8R','Sol Lineas Aereas','Flight Sol','Argentina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAW','8U','Afriqiyah Airways','Afriqiyah','Libya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ACP','8V','Astral Aviation','Astral Cargo','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PWF','8W','Private Wings Flugcharter','Private Wings','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CYZ','8Y','China Postal Airlines','China Post','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GGE','8Y','EGA Ecuato Guineana de Aviacion','Ecuato Guineana','Equatorial Guinea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EZX','9A','Eaglexpress','Eaglexpress Air','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WDA','9C','Wimbi Dira Airways','Wimbi Dira','Congo � Democratic Rep.');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('THE','9D','Toumai Air Tchad','Toumai Air','Chad');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FLG','9E','Endeavor Air','Flagship','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PGP','9G','Perm Airlines','Perm Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CGN','9H','Changan Airlines','Changan','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DAN','9J','Dana Air','Danaco','Nigeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KAP','9K','Cape Air','Cair','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GLR','9M','Central Mountain Air','Glacier','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NSE','9N','SATENA','Satena','Colombia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VAP','9R','Phuket Air','Phuket Air','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CQH','9S','Spring Airlines','Air Spring','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SOO','9S','Southern Air','Southern Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABS','9T','Transwest Air','Athabaska','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RUN','9T','ACT Airlines','Cargo Turk','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MLD','9U','Air Moldova','Air Moldova','Moldova');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AMV','9V','AMC Airlines',NULL,'Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ROI','9V','Avior Airlines','Avior','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAI','9W','Jet Airways','Jet Airways','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AXY','9X','New Axis Airways','Axis','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CIU','A2','Cielos Airlines','Cielos','Peru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AEE','A3','Aegean Airlines','Aegean','Greece');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HOP','A5','Hop!','Air Op','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BGL','A8','Benin Golf Air','Benin Golf','Benin');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TGZ','A9','Georgian Airways/Air Zena','Tamazi','Georgia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAL','AA','American Airlines','American','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BER','AB','Air Berlin','Air Berlin','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ACA','AC','Air Canada','Air Canada','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AZU','AD','Azul Linhas Aereas Brasileiras','Azul','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MDA','AE','Mandarin Airlines','Mandarin','Taiwan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AFR','AF','Air France','Airfrans','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABR','AG','Air Contractors','Contract','Ireland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DAH','AH','Air Algerie','Air Algerie','Algeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIA','AI','Airmark Indonesia','Airmark','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIC','AI','Air India','Air India','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NIG','AJ','Aero Contractors','Aeroline','Nigeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AXM','AK','AirAsia','Red Cap','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TXC','AL','Transaviaexport Cargo Airline','Transexport','Belarus');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AMX','AM','Aeromexico','Aeromexico','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ARG','AR','Aerolineas Argentinas','Argentina','Argentina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ASA','AS','Alaska Airlines','Alaska','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RAM','AT','Royal Air Maroc','Royalair Maroc','Morocco');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AUT','AU','Austral Lineas Aereas','Austral','Argentina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AVA','AV','Avianca','Avianca','Colombia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWN','AW','Air Niamey','Air Niamey','Niger');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SCH','AW','CHC Airways','Schreiner','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LOF','AX','Trans States Airlines','Waterski','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FIN','AY','Finnair','Finnair','Finland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AZA','AZ','Alitalia','Alitalia','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BRU','B2','Belavia','Belarus Avia','Belarus');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BCF','B4','BACH Flugbetriebs','Bach','Austria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BKA','B4','Bankair','Bankair','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EXZ','B5','East African Safari Air Express','Twiga','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JBU','B6','JetBlue Airways {Jet Blue}','Jetblue','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UIA','B7','UNI Airways Corporation','Glory','Taiwan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ERT','B8','Eritrean Airlines','Eritrean','Eritrea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IRB','B9','Iran Air Tours',NULL,'Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BAT','BA','British Airways','Limited','BA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BAW','BA','British Airways Plc','Speedbird','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SHT','BA','British Airways Shuttle','Shuttle','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SBS','BB','Seaborne Airlines','Seaborne','Virgin Islands � USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SKY','BC','Skymark Airlines','Skymark','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BEE','BE','flybe','Jersey','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FCM','BE','flybe Nordic/Finnish Commuter Airlines','Finncomm','Finland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BBD','BF','Bluebird Cargo','Blue Cargo','Iceland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RSR','BF','Aero-Service','Congoserv','Congo');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BBC','BG','Biman Bangladesh','Bangladesh','Bangladesh');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BHA','BH','Hawkair','Hawk','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RBA','BI','Royal Brunei Airlines','Brunei','Brunei Darussalam');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BRJ','BJ','Borajet','Bora Jet','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LBT','BJ','Nouvelair','Nouvelair','Tunisia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OKA','BK','Okay Airways','Okayjet','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PIC','BL','Jetstar Pacific Airlines','Pacific','Vietnam');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BMR','BM','bmi Regional','Kittiwake','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BBW','BO','BB Airways',NULL,'Nepal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BOT','BP','Air Botswana','Botswana','Botswana');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BBV','BQ','Bravo Airlines','Bravo Europa','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EVA','BR','EVA Airways Corporation','Eva','Taiwan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BIH','BS','British International Helicopters','Brintel','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BTI','BT','Air Baltic','Air Baltic','Latvia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BPA','BV','Blue Panorama Airlines/Blu-Express','Blue Panorama','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BWA','BW','Caribbean Airlines/Air Jamaica','Caribbean Airlines','Trinidad and Tobago');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABL','BX','Air Busan','Air Busan','Korea � Rep. of');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TOM','BY','Thomson Airways','Tomson','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BBG','BZ','Bluebird Airways','Candia Bird','Greece');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BDA','BZ','Blue Dart Aviation','Blue Dart','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KEE','BZ','Keystone Air Service','Keystone','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CEL','C2','CEIBA Intercontinental','Ceiba Line','Equatorial Guinea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IMX','C4','Zimex Aviation','Zimex','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UCA','C5','Commutair','Commutair','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CJA','C6','CanJet','Canjet','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CIN','C7','Cinnamon Air','Cinnamon','Sri Lanka');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAO','CA','Air China Cargo','Airchina Freight','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CCA','CA','Air China','Air China','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CCD','CA','Dalian Airlines','Xiangjian','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABD','CC','Air Atlanta Icelandic','Atlanta','Iceland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LLR','CD','Air India Regional','Allied','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TOK','CG','Airlines PNG/Airlines of Papua New Guinea','Balus','Papua New Guinea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BMJ','CH','Bemidji Airlines','Bemidji','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAL','CI','China Airlines','Dynasty','Taiwan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CFE','CJ','BA CityFlyer Express','Flyer','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CKK','CK','China Cargo Airlines','Cargo King','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CLH','CL','Lufthansa Cityline','Hansa Line','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CLW','CL','LOT Charters','Central Wings','Poland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CMP','CM','Copa Airlines','Copa','Panama');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GDC','CN','Grand China Air','Grand China','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CPZ','CP','Compass Airlines','Compass Rose','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EXL','CQ','Sunshine Express Airlines',NULL,'Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CYL','CT','Alitalia CityLiner','Cityliner','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CUB','CU','Cubana de Aviacion','Cubana','Cuba');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CLX','CV','Cargolux','Cargolux','Luxembourg');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CVA','CV','Air Chathams','Chatham','New Zealand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MRS','CW','Air Marshall Islands','Marshall Islands','Marshall Islands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CPA','CX','Cathay Pacific Airways','Cathay','Hong Kong');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CYP','CY','Cyprus Airways','Cyprus','Cyprus');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSN','CZ','China Southern Airlines','China Southern','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DHK','D0','DHL Air UK/DHL Air Ltd','Eurotrans','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SSF','D2','Severstal Aircompany','Severstal','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DAO','D3','Daallo Airlines','Dalo Airlines','Djibouti');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LID','D4','Alidaunia','Alida','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DAE','D5','DHL Aero Expreso','Yellow','Panama');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ILN','D6','Inter Air','Inline','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XAX','D7','AirAsia X','Xanadu','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DNV','D9','Donavia','Donavia','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GAO','DC','Golden Air','Golden','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NOK','DD','Nok Air','Nok Air','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CFG','DE','Condor Airlines','Condor','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DER','DF','Beijing Capital Airlines','Deer Jet','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SRQ','DG','South East Asian Airlines','Seair','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VOZ','DJ','Virgin Australia Airlines','Virgin','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PBN','DJ','Virgin Samoa','Bluebird','Samoa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VKG','DK','Thomas Cook Airlines Scandinavia','Viking','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DAL','DL','Delta Air Lines','Delta','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SGG','DN','Senegal Airlines','Senegal Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CXT','DQ','Coastal Air Transport','Coastal','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EZS','DS','easyJet Switzerland','Top Swiss','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DTA','DT','TAAG Angola Airlines','DTA','Angola');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NLH','DU','Norwegian Long Haul','Norstar','Norway');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VSV','DV','Scat Air/PLL Scat Aircompany','Vlasta','Kazakhstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UCR','DW','Aero Charter Ukraine','Charter Ukraine','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DTR','DX','DAT Danish Air Transport','Danish','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NAX','DY','Norwegian Air Shuttle','Nor Shuttle','Norway');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RBG','E5','Air Arabia Egypt','Arabia Egypt','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ESF','E7','Estafeta Carga Aerea','Estafeta','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GTA','E8','City Airways','City Airways','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EVE','E9','Evelop Airlines','Evelop','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PLM','EB','Pullmantur Air','Pullmantur','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BOS','EC','OpenSkies','Mistral','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TWN','EC','Avialeasing Aviation Company','Twin Arrow','Uzbekistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABQ','ED','Airblue','Airblue','Pakistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ESY','EF','EasyFly','Easy Fly','Colombia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ENJ','EG','Enerjet','Enerjet Air','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AKX','EH','ANA Wings','Alfa Wing','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EIN','EI','Aer Lingus','Shamrock','Ireland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NEA','EJ','New England Airlines','New England','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UAE','EK','Emirates','Emirates','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AEB','EM','Aero Benin','Aeroben','Benin');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CFS','EM','Empire Airlines','Empire Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DLA','EN','Air Dolomiti','Dolomiti','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LHN','EO','Express One International','Longhorn','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IRC','EP','Iran Asseman Airlines',NULL,'Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAE','EQ','TAME','Tame','Ecuador');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DHX','ES','SNAS/DHL/DHL International Aviation ME','Dilmun','Bahrain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ETH','ET','Ethiopian Airlines','Ethiopian','Ethiopia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UEA','EU','Chengdu Airlines','Hibiscus City','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ASQ','EV','ExpressJet Airlines','Acey','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EWG','EW','Eurowings','Eurowings','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BJK','EX','Atlantic Airlines','Blackjack','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EFL','EY','Eagle Air','Flying Eagle','Tanzania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ETD','EY','Etihad Airways','Etihad','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EIA','EZ','Evergreen International Airlines','Evergreen','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SUS','EZ','Sun Air of Scandinavia','Sun Scan','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FSW','F3','Faso Airways','Faso','Burkina Faso');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FXL','F3','Fly Excellent','Fly Excellent','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SGB','F3','Sky King','Songbird','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DWT','F7','Darwin Airline/Etihad Regional','Darwin','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VRE','F7','Volare Airlines','Ukraine Volare','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FFT','F9','Frontier Airlines','Frontier Flight','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SFR','FA','Safair/FlySafair',NULL,'South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LZB','FB','Bulgaria Air','Flying Bulgaria','Bulgaria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FCX','FC','Falcon Express Cargo Airlines','Falcon Cargo','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIQ','FD','Thai AirAsia','Thai Asia','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AFG','FG','Ariana Afghan Airlines','Ariana','Afghanistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ICE','FI','Icelandair','Ice Air','Iceland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FJI','FJ','Fiji Airways','Fiji','Fiji');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FJA','FJ','Pacific Sun/Fiji Airlines  Pac Sun',NULL,NULL);
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WTA','FK','Africa West Airlines','West Togo','Togo');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSH','FM','Shanghai Airlines','Shanghai Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FTZ','FN','Fastjet','Greybird','United Kingdom/Tanzania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RGL','FN','Royal Air Maroc Express/Regional Airlines','Maroc Regional','Morocco');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ATM','FO','Airlines of Tasmania','Air Tas','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FXX','FO','Felix Airways',NULL,'Yemen');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FPG','FP','TAG Aviation','Tag Aviation','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FRE','FP','Freedom Air/Aviation Services','Freedom','Guam');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TCW','FQ','Thomas Cook Airlines Belgium','Thomas Cook','Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RYR','FR','Ryanair','Ryanair','Ireland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SYA','FS','Syphax Airlines','Syphaxair','Tunisia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SDM','FV','Rossiya Russian Airlines','Russia','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FRI','FW','Ibex Airlines','Ibex','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FDX','FX','FedEx Express/Federal Express','Fedex','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FFM','FY','Firefly','Firefly','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NWR','FY','Northwest Regional Airlines',NULL,'Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FDB','FZ','Flydubai','Sky Dubai','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VXG','G2','Avirex Gabon','Avirex Gabon','Gabon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GLO','G3','GOL Transportes Aereos','Gol Transporte','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAY','G4','Allegiant Air','Allegiant','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GZD','G4','Grizodubova Air Company','Grizodubova Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HXA','G5','China Express Airlines','China Express','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GJS','G7','GoJet Airlines','Lindbergh','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ENK','G8','Enkor','Enkor','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GOW','G8','GoAir','Go Air','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABY','G9','Air Arabia','Arabia','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GIA','GA','Garuda Indonesia','Indonesia','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABX','GB','ABX Air','Abex','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GCB','GC','Lina Congo','Linacongo','Congo');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GNR','GC','Gambia International Airlines','Gambia International','Gambia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TNA','GE','TransAsia Airways','Trans Asia','Taiwan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GFA','GF','Gulf Air','Gulf Air','Bahrain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GLP','GH','Globus','Globus','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CDC','GJ','Zhejiang Loong Airlines','Gualong','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JJP','GK','JetStar Japan','Orange Liner','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GRL','GL','Air Greenland','Greenlandair','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KZU','GO','ULS Airlines Cargo Transport','Universal Cargo','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GDR','GP','Gadair European Airlines','Gadair Lines','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GES','GP','Gestair','Gestair','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SEH','GQ','Sky Express','Air Crete','Greece');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AUR','GR','Aurigny Air Services','Ayline','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GCR','GS','Tianjin Airlines','China Dragon','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JXX','GX','Primera Air','Jetbird','Iceland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GBK','GY','Gabon Airlines','Gabon Airlines','Gabon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TMG','GY','Tri-MG Intra Asia Airlines','Trilines','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SKU','H2','Sky Airline','Aerosky','Chile');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HRM','H3','Hermes Airlines','Hermes','Greece');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HLI','H4','Heli Securite Helicopter Airlines','Heli Saint Tropez','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RSY','H5','I-Fly','Russian Sky','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BUC','H6','Bulgarian Air Charter','Bulgarian Charter','Bulgaria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HAG','H6','Hageland Aviation Services','Hageland','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EGU','H7','Eagle Air','African Eagle','Uganda');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HTH','H9','Helitt Lineas Aereas','Alboran','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HAL','HA','Hawaiian Airlines','Hawaiian','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAQ','HB','Asia Atlantic Airlines','Asia Atlantic','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ADO','HD','Hokkaido International Airlines/Air Do','Air Do','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LGW','HE','LGW Luftfahrtgesellschaft Walter','Walter','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NLY','HG','Niki','Flyniki','Austria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TMN','HJ','Tasman Cargo Airlines','Tasman','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FSC','HK','Four Star Air Cargo','Four Star','Virgin Islands � USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HAY','HK','Hamburg Airways','Hamburg Airways','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SEY','HM','Air Seychelles','Seychelles','Seychelles');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HVY','HN','HeavyLift Cargo Airlines','Heavy Cargo','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PTH','HN','Proteus Helicopteres','Proteus','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DKH','HO','Juneyao Airlines','Air Juneyao','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HHN','HR','Hahn Air','Rooster','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HSV','HS','Svenska Direktflyg','Highswede','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IMP','HT','Hellenic Imperial Airways','Imperial','Greece');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CHH','HU','Hainan Airlines','Hainan','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TRA','HV','transavia.com/Transavia Airlines','Transavia','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NWL','HW','North-Wright Airways','Northwright','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CRK','HX','Hong Kong Airlines','Bauhinia','Hong Kong');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UZB','HY','Uzbekistan Airways','Uzbek','Uzbekistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SHU','HZ','Aurora','Satair','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IBS','I2','Iberia Express','Iberexpres','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FWA','I4','Interstate Airlines','Freewayair','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IAD','I5','AirAsia India','Ariya','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CMM','I5','Air Mali','Camali','Mali');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SEQ','I6','Sky Eyes','Sky Eyes','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IAW','IA','Iraqi Airways','Iraqi','Iraq');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IBE','IB','Iberia','Iberia','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BTK','ID','Batik Air','Batik','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SOL','IE','Solomon Airlines','Solomon','Solomon Islands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ISS','IG','Meridiana Fly','Merair','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MZA','IH','Irtysh Air','Azamat','Kazakhstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSQ','II','IBC Airways','Chasqui','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MNJ','IM','Menajet','Menajet','Lebanon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IRA','IR','Iran Air','Iran Air','Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ISA','IS','Island Airlines','Island','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WON','IW','Wings Abadi Air','Wings Abadi','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AXB','IX','Air India Express','Express India','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IYE','IY','Yemenia','Yemeni','Yemen');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AIZ','IZ','Arkia','Arkia','Israel');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AHC','J2','AZAL Avia Cargo','Azalaviacargo','Azerbaijan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AHY','J2','AZAL Azerbaijan Airlines/AHY','Azal','Azerbaijan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PLR','J3','Northwestern Air','Polaris','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BFL','J4','Buffalo Airways','Buffalo Airways','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EPA','J5','Shenzhen Donghai Airlines','Donghai Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ARW','J6','Jamaica Air Shuttle','Jamaica Shuttle','Jamaica');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DNM','J7','Denim Air','Denim','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BVT','J8','Berjaya Air','Berjaya','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JZR','J9','Jazeera Airways','Jazeera','Kuwait');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BON','JA','B & H Airlines','BH Airlines','Bosnia-Herzegovina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JGN','JA','Jagson Airlines',NULL,'India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JBA','JB','Helijet International','Helijet','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JEX','JC','JAL Express','Janex','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAC','JC','Japan Air Commuter','Commuter','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MNO','JE','Mango','Tulca','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAB','JF','LAB Flying Service','Lab','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FDA','JH','Fuji Dream Airlines','Fuji Dream','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AGX','JJ','Aviogenex','Genex','Serbia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAM','JJ','TAM Linhas Aereas','Tam','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAL','JL','Japan Airlines','Japan Air','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JKT','JM','Jetstar Hong Kong','Kai Tak','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NLV','JN','Livingston Compagnia Aerea','Seagull','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ADR','JP','Adria Airways','Adria','Slovenia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JST','JQ','Jetstar Airways','Jetstar','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAV','JQ','AlbaStar','Alba Star','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JOY','JR','Joy Air','Joy Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KOR','JS','Air Koryo','Air Koryo','Korea � Dem. People�s Rep.');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LNI','JT','Lion Airlines/Lion Mentari Air','Lion Inter','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAT','JU','Jat Airways','Jat','Serbia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BLS','JV','Bearskin Airlines','Bearskin','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VNL','JW','Vanilla Air','Vanilla','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IWY','JZ','Air Turks and Caicos','Islandways','Turks and Caicos Islands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ELO','K2','EuroLOT','Eurolot','Poland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CKS','K4','Kalitta Air','Connie','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABE','K5','Aban Air','Aban','Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SQH','K5','Wings of Alaska/SeaPort Airlines','Sasquach','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KHV','K6','Cambodia Angkor Air','Cambodia Air','Cambodia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ZAK','K8','Zambia Skyways','Zambia Skies','Zambia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ESD','K9','Esen Air','Esen Air','Kyrgyzstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KFS','K9','Kalitta Charters','Kalitta','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KRI','K9','Krylo Aviakompania','Krilo','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HDA','KA','Dragonair/Hong Kong Dragon Airlines','Dragon','Hong Kong');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DRK','KB','Druk Air','Royal Bhutan','Bhutan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KZR','KC','Air Astana','Astana Line','Kazakhstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KAL','KE','Korean Air','Korean Air','Korea � Rep. of');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BLF','KF','Blue1','Bluefin','Finland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GTV','KG','Aerogaviota','Gaviota','Cuba');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAH','KH','Aloha Air Cargo','Aloha','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KKK','KK','AtlasJet','Atlasjet','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KLM','KL','KLM Royal Dutch Airlines','KLM','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AMC','KM','Air Malta','Air Malta','Malta');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CUA','KN','China United Airlines','Lianhang','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AER','KO','Alaska Central Express','Ace Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QNK','KO','Kabo Air','Kabo','Nigeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KQA','KQ','Kenya Airways','Kenya','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KMZ','KR','Comores Aviation',NULL,'Comoros');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PEN','KS','Penair/Peninsula Airways','Peninsula','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KAC','KU','Kuwait Airways','Kuwaiti','Kuwait');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KFA','KW','Kelowna Flightcraft Air Charter','Flightcraft','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAY','KX','Cayman Airways','Cayman','Cayman Islands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NCA','KZ','Nippon Cargo Airlines','Nippon Cargo','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LYC','L2','Lynden Air Cargo','Lynden','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JOS','L3','DHL de Guatemala',NULL,'Guatemala');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LTR','L5','Lufttransport','Lufttransport','Norway');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MAI','L6','Mauritanian Airlines International',NULL,'Mauritania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VNZ','L6','TAM Air/Tbilaviamsheni','Tbilavia','Georgia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LHS','L7','Lugansk Airlines','Enterprise Luhansk','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAN','LA','LAN Airlines','Lan Chile','Chile');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LBR','LB','Air Costa',NULL,'India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LOG','LC','Loganair','Logan','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AHK','LD','Air Hong Kong','Air Hong Kong','Hong Kong');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TUY','LD','Linea Turistica Aerotuy','Aereotuy','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LGL','LG','Luxair','Luxair','Luxembourg');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DLH','LH','Lufthansa','Lufthansa','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GEC','LH','Lufthansa Cargo','Lufthansa Cargo','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LIA','LI','LIAT','Liat','Antigua and Barbuda');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JNA','LJ','Jin Air','Jin Air','Korea � Rep. of');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SLA','LJ','Sierra National Airlines','Selair','Sierra Leone');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BSK','LL','Miami Air International','Biscayne','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAA','LN','Lybian Arab Airlines','Libair','Libya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LOT','LO','LOT Polish Airlines','Pollot','Poland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LPE','LP','LAN Peru','Patagonia','Peru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAQ','LQ','Lebanese Air Transport','Lat','Lebanon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LRC','LR','Lacsa','Lacsa','Costa Rica');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EXS','LS','Jet2.com','Channex','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LTU','LT','Air Lituanica','Lituanica','Lithuania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LXP','LU','Lan Express','Lan Ex','Chile');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NMI','LW','Pacific Wings/GeorgiaSkies/New Mexico Airlines','Tsunami','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWR','LX','Swiss International Air Lines','Swiss','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWU','LX','Swiss European Air Lines','Euroswiss','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ELY','LY','El Al','El Al','Israel');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MNG','M0','Aero Mongolia','Aero Mongolia','Mongolia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MZS','M2','Mahfooz Aviation','Mahfooz','Gambia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NFA','M3','Air Norway/North Flying','North Flying','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TUS','M3','ABSA Aerolinhas Brasileiras','Turismo','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AJT','M6','Amerijet International','Amerijet','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MAA','M7','MasAir','Mas Carga','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MSL','M7','Marsland Aviation','Marsland Air','Sudan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MSI','M9','Motor Sich Aviakompania','Motor Sich','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MNB','MB','MNG Airlines','Black Sea','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MSC','MC','Air Cairo',NULL,'Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RCH','MC','Air Mobility Command','Reach','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MDG','MD','Air Madagascar','Air Madagascar','Madagascar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MEA','ME','MEA Middle East Airlines Airliban','Cedar Jet','Lebanon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CXA','MF','Xiamen Airlines','Xiamen Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MIX','MG','Midex Airlines','Midexcargo','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MAS','MH','Malaysia Airlines','Malaysian','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MWG','MH','MASwings','Maswings','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SLK','MI','SilkAir','Silkair','Singapore');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MLR','MJ','Mihin Lanka','Mihin Lanka','Sri Lanka');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MAU','MK','Air Mauritius','Air Mauritius','Mauritius');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BIE','ML','Air Mediterranee','Mediterrannee','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ETC','ML','ATTICO African Transport Trading and Investment Co.','Tranattico','Sudan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('APJ','MM','Peach Aviation','Air Peach','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAW','MN','kulula.com/Comair Commercial Airlines','Commercial','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AUH','MO','Abu Dhabi Amiri Flight','Sultan','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAV','MO','Calm Air','Calm Air','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MPH','MP','Martinair','Martinair','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ENY','MQ','Envoy Air/American Eagle','Envoy','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MML','MR','Hunnu Air','Trans Mongolia','Mongolia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MSE','MS','EgyptAir Express','Egyptair Express','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MSR','MS','EgyptAir','Egyptair','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TCX','MT','Thomas Cook Airlines','Kestrel','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CES','MU','China Eastern Airlines','China Eastern','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BUG','MW','Mokulele Airlines','Speedbuggy','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MYD','MW','Maya Island Air','Myland','Belize');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MWA','MY','Midwest Airlines',NULL,'Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NWS','N4','Nordwind Airlines','Nordland','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TNB','N4','Trans Air Benin','Trans Benin','Benin');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MDM','N5','Medavia','Medavia','Malta');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SGY','N5','Skagway Air Service','Skagway Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MUA','N8','National Airlines','Murray Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NVR','N9','Novair/Nova Airlines','Navigator','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NAC','NC','Northern Air Cargo','Yukon','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NJS','NC','Cobham Aviation Services Australia','National Jet','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NMA','NE','Nesma Airlines','Nesma','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AVN','NF','Air Vanuatu','Air Van','Vanuatu');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANA','NH','ANA All-Nippon Airways','All Nippon','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PGA','NI','Portugalia','Portugalia','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NGB','NJ','Nordic Global Airlines','Nordic Global','Finland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NKS','NK','Spirit Airlines','Spirit Wings','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SAI','NL','Shaheen Air International','Shaheen Air','Pakistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NZM','NM','Mount Cook Airline','Mount Cook','New Zealand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MOV','NN','VIM Airlines','Mov Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NOS','NO','Neos','Moonflower','Italy');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NIA','NP','Nile Air','Nile Bird','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SKP','NP','Skytrans Airlines','Skytrans','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AJX','NQ','Air Japan','Air Japan','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HBH','NS','Hebei Airlines','Hebei Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IBB','NT','Binter Canarias','Binter','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JTA','NU','Japan Transocean Air','Jai Ocean','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AMU','NX','Air Macau','Air Macao','Macau');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FNA','NY','Air Iceland/Flugfelag Islands','Faxi','Iceland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANZ','NZ','Air New Zealand','New Zealand','New Zealand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWK','NZ','Airwork','Airwork','New Zealand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RLK','NZ','Air Nelson','Link','New Zealand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JEA','O2','OLT Jetair','Jeta','Poland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABV','O4','Antrak Air','Antrak','Ghana');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ONE','O6','Avianca Brazil','Oceanair','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NOV','O9','Nova Airline','Novanile','Sudan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OAL','OA','Olympic Air','Olympic','Greece');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BOV','OB','Boliviana de Aviacion',NULL,'Bolivia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OAV','OC','Omni Aviacao e Tecnologia/PGA Express','Omni','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MXD','OD','Malindo Air','Malindo Express','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ENT','OF','Enter Air','Enterair','Poland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TML','OF','Transports et Travaux Aeriens de Madagascar','Tam Airline','Madagascar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FJM','OJ','Fly Jamaica Airways','Greenheart','Jamaica');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSA','OK','Czech Airlines','CSA Lines','Czech Rep.');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MGL','OM','MIAT Mongolian Airlines','Mongol Air','Mongolia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RON','ON','Our Airline',NULL,'Nauru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SKW','OO','Skywest Airlines','Skywest','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CQN','OQ','Chongqing Airlines','Chong Qing','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CRF','OR','Krym','Crimea Air','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TFL','OR','Arkefly','Arkefly','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AUA','OS','Austrian Airlines','Austrian','Austria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CTN','OU','Croatia Airlines','Croatia','Croatia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ELL','OV','Estonian Air','Estonian','Estonia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OVA','OV','Melilla Airlines','Aeronova','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OEA','OX','Orient Thai Airlines','Orient Thai','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANS','OY','Andes Lineas Aereas','Aeroandes','Argentina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OAE','OY','Omni Air Express/Omni Air International','Omni Express','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAR','OZ','Asiana Airlines','Asiana','Korea � Rep. of');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PFZ','P0','Proflight Commuter Services','Proflight Zambia','Zambia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XAK','P2','Airkenya Express','Sunexpress','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PTB','P3','Passaredo Transportes Aereos','Passaredo','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NSO','P4','Aerolineas Sosa','Sosa','Honduras');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RPB','P5','Copa Airlines Colombia','Aerorepublica','Colombia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MUI','P6','Trans Air','Maui','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ESL','P7','Russian Sky Airlines','Raduga','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PTN','P8','Pantanal Linhas Aereas Sul-Matogrossenses','Pantanal','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PVN','P9','Peruvian Airlines','Peruvian','Peru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FCL','PA','Florida Coastal Airlines','Florida Coastal','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SPR','PB','Provincial Airlines','Speedair','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PGT','PC','Pegasus Airlines','Sun Turk','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('POE','PD','Porter Airlines','Porter','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PEV','PE','People�s Viennaline/Altenrhein Luftfahrt','Peoples','Austria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PNW','PF','Palestinian Airlines','Palestinian','Palestinian Territory');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BKP','PG','Bangkok Airways','Bangkok Air','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PAO','PH','Polynesian Airlines','Polynesian','Samoa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SPM','PJ','Air Saint-Pierre','Saint-Pierre','St. Pierre and Miquelon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PIA','PK','Pakistan International Airlines','Pakistan','Pakistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TOS','PM','Tropic Air','Tropiser','Belize');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CHB','PN','China West Air','West China','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PAC','PO','Polar Air Cargo','Polar','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PJS','PP','Jet Aviation Business Jets','Jet Aviation','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('APG','PQ','Philippines AirAsia','Cool Red','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TFK','PQ','Transafrik International',NULL,'Sao Tome and Principe');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PAL','PR','Philippine Airlines','Philippine','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AUI','PS','Ukraine International Airlines','Ukraine International','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWN','PT','West Air Sweden','Air Sweden','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PNR','PV','PAN Air Lineas Aereas','Skyjet','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PRF','PW','Precision Air Services','Precision Air','Tanzania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANG','PX','Air Niugini','Niugini','Papua New Guinea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SLM','PY','Surinam Airways','Surinam','Suriname');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAP','PZ','TAM Airlines/Transportes Aereos del Mercosur','Paraguaya','Paraguay');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DQA','Q2','Maldivian/Island Aviation Services','Island Aviation','Maldives');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MLA','Q5','40-Mile Air','Mile Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CDP','Q6','Aero Condor','Condor Peru','Peru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PEC','Q8','Pacific East Asia Cargo Airlines','Cool Red','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TSG','Q8','Trans Air Congo','Trans Congo','Congo');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CIM','QA','Cimber','Cimber','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GFG','QB','SkyGeorgia','National','Georgia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QCL','QD','Air Class Lineas Aereas','Acla','Uruguay');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EAQ','QF','Eastern Australia Airlines','Eastern','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QFA','QF','Qantas Airways','Qantas','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QLK','QF','QantasLink','Q Link','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QNZ','QF','JetConnect','Qantas JetConnect','New Zealand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SSQ','QF','Sunstate Airlines','Sunstate','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LYN','QH','Kyrgyzstan','Altyn Avia','Kyrgyzstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JZA','QK','Jazz Aviation/Air Canada Express','Jazz','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LER','QL','LASER Linea Aerea de Servicio Ejecutivo Regional','Laser','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RNL','QL','Aero Lanka/Serendib Express','Aero Lanka','Sri Lanka');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AML','QM','Air Malawi','Malawi','Malawi');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ARR','QN','Air Armenia','Air Armenia','Armenia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UTY','QQ','Alliance Airlines','Unity','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QTR','QR','Qatar Airways','Qatari','Qatar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TVS','QS','Travel Service/Smart Wings','Skytravel','Czech Rep.');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TPA','QT','TAMPA Transportes Aereos Mercantiles Panamericanos','Tampa','Colombia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UGX','QU','East African Airlines','Crane','Uganda');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UTN','QU','UTair-Ukraine','UT Ukraine','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAO','QV','Lao Airlines','Lao','Laos');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TCI','QW','Turks Air Cargo','Kerrmont','Turks and Caicos Islands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('QXE','QX','Horizon Air','Horizon Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BCS','QY','European Air Transport','Eurotrans','Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWQ','QZ','Indonesia AirAsia','Wagon Air','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RPK','R0','Royal Airlines','Royal Pakistan','Pakistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ORB','R2','Orenair/Orenburg Airlines','Orenburg','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SYL','R3','Yakutia Airlines','Air Yakutia','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAV','R5','Jordan Aviation','Jordan Aviation','Jordan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OCA','R7','Aserca Airlines','Arosca','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CAM','R9','Camai Air/Village Aviation','Air Camai','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TSD','R9','TAF Linhas Aereas','Tafi','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RNA','RA','Nepal Airlines','Nepal','Nepal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SYR','RB','Syrian Arab Airlines','Syrianair','Syrian Arab Rep.');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FLI','RC','Atlantic Airways','Faroeline','Faroe Islands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('REA','RE','Stobart Air','Aer Arann','Ireland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FWL','RF','Florida West International Airways','Flo West','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RPH','RH','RPX Airlines/Republic Express Airlines','Public Express','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RJA','RJ','Royal Jordanian','Jordanian','Jordan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RCT','RK','R Airlines','Green Sky','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RIO','RL','Rio Linhas Aereas','Rio Linhas','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RKT','RN','Rayani Air','Blue Green','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ROT','RO','Tarom Romanian Air Transport','Tarom','Romania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CHQ','RP','Chautauqua Airlines','Chautauqua','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KMF','RQ','Kam Air','Kamgar','Afghanistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RFR','RR','Royal Air Force','Rafair','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ORF','RS','Oman Royal Flight','Oman','Oman');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SKV','RS','Sky Regional Airlines/Air Canada Express','Maple','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ABW','RU','AirBridge Cargo Airlines','Airbridge Cargo','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CPN','RV','Caspian Airlines Service Company','Caspian','Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ROU','RV','Air Canada Rouge','Rouge','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RPA','RW','Republic Airlines','Brickyard','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LRS','RZ','SANSA Servicios Aereos Nacionales SA',NULL,'Costa Rica');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BBR','S3','Santa Barbara Airlines','Santa Barbara','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RZO','S4','Sata International','Air Azores','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TCF','S5','Shuttle America','Mercury','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SRR','S6','Star Air','White Star','Denmark');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SBI','S7','S7 Airlines/Siberia Airlines','Siberian Airlines','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWW','S8','Shovkoviy Shlyah Airlines','Way Aero','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IKM','S9','Starbow Airlines','Easy Shuttle','Ghana');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SAA','SA','South African Airways','Springbok','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ACI','SB','Aircalin/Air Caledonie International','Aircalin','New Caledonia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CDG','SC','Shandong Airlines','Shandong','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SUD','SD','Sudan Airways','Sudanair','Sudan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XLF','SE','XL Airways France','Starway','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DTH','SF','Tassili Airlines','Tassili Air','Algeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SEJ','SG','SpiceJet','SpiceJet','India');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWS','SI','Arab Wings','Arab Wings','Jordan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BCI','SI','Blue Islands','Blue Island','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SPA','SI','Sierra Pacific Airlines','Sierra Pacific','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CGL','SJ','Seagle Air','Seagle','Slovakia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SAS','SK','SAS Scandinavian Airlines System','Scandinavian','Denmark/Norway/Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TLM','SL','Thai Lion Air','Mentari','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MNP','SM','Spirit of Manila Airlines','Manila Sky','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BEL','SN','Brussels Airlines','Bee Line','Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HKA','SO','Superior Aviation','Spend Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SLC','SO','SALSA d�Haiti','Salsa','Haiti');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SAT','SP','SATA Air Acores','Sata','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SIA','SQ','Singapore Airlines','Singapore','Singapore');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SQC','SQ','Singapore Airlines Cargo','Singcargo','Singapore');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CRL','SS','Corsairfly','Corsair','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GMI','ST','Germania','Germania','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AFL','SU','Aeroflot Russian Airlines','Aeroflot','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SVA','SV','Saudi Arabian Airlines','Saudia','Saudi Arabia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NMB','SW','Air Namibia','Namibia','Namibia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SCX','SY','Sun Country Airlines','Sun Country','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TPU','T0','Taca Peru','Trans Peru','Peru');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TMA','T2','Trans Mediterranean Airways','Tango Lima','Lebanon');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EZE','T3','Eastern Airways','East Flight','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TIB','T4','TRIP Linhas Aereas','Trip','Brazil');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TUA','T5','Turkmenistan Airlines','Turkmenistan','Turkmenistan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TVR','T6','Tavrey Airlines/Tavria Aviakompania','Travey','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TJT','T7','Twin Jet','Twinjet','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAI','TA','Taca International Airlines','Taca','El Salvador');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAF','TB','Jetairfly','Beauty','Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ATC','TC','Air Tanzania','Tanzania','Tanzania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LUR','TD','Atlantis European Airways',NULL,'Armenia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SCW','TF','Malmo Aviation','Scanwing','Sweden');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('THA','TG','Thai Airways International','Thai','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TSE','TH','Transmile Air Services','Transmile','Malaysia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TOL','TI','TolAir Services','Tol Air','Puerto Rico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AJA','TK','AnadoluJet','Anadolujet','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('THY','TK','Turkish Airlines','Turk Air','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANO','TL','Airnorth Regional','Top End','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAM','TM','LAM','Mozambique','Mozambique');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('THT','TN','Air Tahiti Nui','Tahiti Lines','French Polynesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TVF','TO','Transavia France','France Soleil','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAP','TP','TAP Portugal','Air Portugal','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TDM','TQ','Tandem Aereo','Tandem','Moldova');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TGW','TR','Tiger Airways','Go Cat','Singapore');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TSC','TS','Air Transat','Air Transat','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAR','TU','Tunisair','Tunair','Tunisia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TBA','TV','Tibet Airlines','Tibet','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FWI','TX','Air Caraibes','French West','Guadeloupe/Martinique');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TPC','TY','Air Caledonie','Air Cal','New Caledonia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SCO','TZ','Scoot','Scooter','Singapore');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TWG','TZ','Air-taxi europe','Twin-Goose','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EZY','U2','easyJet','Easy','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SVR','U6','Ural Airlines','Sverdlovsk Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UAL','UA','United Airlines','United','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UBA','UB','Myanma Airways','Unionair','Myanmar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LCO','UC','LAN Cargo','Lan Cargo','Chile');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HER','UD','Hex�Air','Hex Airline','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NAS','UE','Nasair','Nasairways','Eritrea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UKM','UF','UM Air/Ukrainian Mediterranean Airlines','Ukraine Mediterrannee','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SEN','UG','Sevenair','Sevenair','Tunisia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GMT','UJ','Magnicharters','Grupo Monterrey','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LMU','UJ','AlMasria Universal Airlines','Almasria','Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ALK','UL','SriLankan Airlines','Sri Lankan','Sri Lanka');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TSO','UN','Transaero Airlines','Trans Soviet','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HKE','UO','Hong Kong Express','Hongkong Shuttle','Hong Kong');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BHS','UP','Bahamasair','Bahamas','Bahamas');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KMV','UR','UTair Express','Kominter','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWE','US','US Airways','Cactus','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JIA','US','PSA Airlines','Blue Streak','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PDT','US','Piedmont Airlines','Piedmont','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UTA','UT','UTair Aviation','Utair','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('REU','UU','Air Austral','Reunion','Reunion Island');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UTP','UW','Uni-Top Airlines','Uni-Top','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AEA','UX','Air Europa','Europa','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BRQ','UZ','Buraq Air Transport','Buraq Air','Libya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VCV','V0','Conviasa','Conviasa','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RBY','V2','Vision Airlines','Ruby','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KRP','V3','Carpatair','Carpatair','Romania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VEC','V4','Vensecar Internacional','Vensecar','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VOG','V6','Voyager Airlines','Voyager Air','Bangladesh');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VOE','V7','Volotea','Volotea','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TPS','V8','TAPSA Transportes Aereos Petroleros SA','Tapsa','Argentina');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VAS','V8','ATRAN Aviatrans Cargo Airlines','Atran','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VAU','VA','Virgin Australia International Airlines','Vee Oz','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VIV','VB','Viva Aerobus','Aeroenlaces','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VAL','VC','Voyageur Airways','Voyageur','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KPA','VD','Henan Airlines','Kun Peng','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VJC','VD','VietJet Air','Vietjetair','Vietnam');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VLM','VG','VLM','Rubens','Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ALV','VH','Aeropostal Alas de Venezuela','Alven','Venezuela');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VDA','VI','Volga-Dnepr Airlines','Volda Dnepr','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VES','VI','Vieques Air Link','Vieques','Puerto Rico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VIM','VL','Air VIA Bulgarian Airways','Via Airways','Bulgaria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('HVN','VN','Vietnam Airlines','Vietnam Airlines','Vietnam');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TYR','VO','Tyrolean Airways/Austrian Arrows','Tyrolean','Austria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TCV','VR','TACV Cabo Verde Airlines','Cabo Verde','Cape Verde');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VIR','VS','Virgin Atlantic Airways','Virgin','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VTA','VT','Air Tahiti','Air Tahiti','French Polynesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAO','VW','Transportes Aeromar','Trans Aeromar','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VRD','VX','Virgin America','Redwood','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VLG','VY','Vueling Airlines','Vueling','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WDL','W1','WDL Aviation','WDL','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ARA','W3','Arik Air','Arik Air','Nigeria');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DNU','W3','Danu Oro Transportas','Danu','Lithuania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWT','W3','Swiftair','Swift','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BES','W4','Aero Services Executive','Bird Express','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IRM','W5','Mahan Air','Mahan Air','Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WZZ','W6','Wizz Air','Wizz Air','Hungary');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CJT','W8','CargoJet Airways','Cargojet','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JAB','W9','Air Bagan','Air Bagan','Myanmar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KLC','WA','KLM Cityhopper','City','Netherlands');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RWD','WB','Rwandair Express','Rwandair','Rwanda');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ISV','WC','Islena Airlines',NULL,'Honduras');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CWC','WE','Centurion Air Cargo','Challenge Cargo','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WIF','WF','Wideroe Flyveselskap','Wideroe','Norway');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWG','WG','Sunwing Airlines','Sunwing','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TDX','WI','TradeWinds Airlines','Tradewinds Express','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LAL','WJ','Air Labrador','Lab Air','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EDW','WK','Edelweiss Air','Edelweiss','Switzerland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WIA','WM','Winair/Windward Islands Airways','Windward','Sint Maarten');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWA','WN','Southwest Airlines','Southwest','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MKU','WP','Island Air','Moku','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WEN','WR','WestJet Encore','Encore','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WJA','WS','WestJet','Westjet','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WSG','WT','Wasaya Airways','Wasaya','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('WOW','WW','WOW air','Wow Air','Iceland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BCY','WX','CityJet','City Ireland','Ireland');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OMA','WY','Oman Air','Oman Air','Oman');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MDJ','WZ','Jetran Air','Jetran Air','Romania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VAZ','WZ','Red Wings Airlines','Remont Air','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TUI','X3','TUIfly','TUI Jet','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OTJ','X5','Fly Romania','Fly Romania','Romania');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DAP','X8','Aerovias DAP','Dap','Chile');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KHO','X9','Khors Aircompany','Aircompany Khors','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XAA','XA','ARINC/Aeronautical Radio Inc.',NULL,'USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IAT','XB','IATA/International Air Transport Association',NULL,'Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KDC','XC','KD Air','Kay Dee','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VLK','XF','Vladivostok Air','Vladair','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KHH','XH','Alexandria Airlines',NULL,'Egypt');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XXH','XH','Special Ground Handling Service',NULL,'USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XXI','XI','AEROTEL/Aeronautical Telecommunications',NULL,'Jamaica');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TAX','XJ','Thai AirAsia X','Express Wing','Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CCM','XK','Air Corsica/Compagnie Corse Mediterranee','Corsica','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LNE','XL','LAN Ecuador','Lan Ecuador','Ecuador');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JLJ','XM','J-Air','J-Air','Japan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('JTE','XM','JetEx/Australian Air Express','JetEx','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('XAR','XN','Xpress Air','Travel Express','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SXS','XQ','SunExpress','Sun Express','Turkey');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OZW','XR','SkyWest Airlines','Ozwest','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SIT','XS','SITA',NULL,'Belgium');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('INX','XT','Indonesia AirAsia X','IndonesianRedcap','Indonesia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AXK','XU','African Express Airways','Express Jet','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('KNE','XY','Nas Air/Al-Khayala Airline','Nas Express','Saudi Arabia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EXY','XZ','South African Express Airways','Expresswayx','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('VOI','Y4','Volaris','Volaris','Mexico');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWA','Y5','Asia Wings','Asia Wings','Kazakhstan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GMR','Y5','Golden Myanmar Airlines','Golden Myanmar','Myanmar');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('TYA','Y7','Taimyr Air Company','Taimyr','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('YZR','Y8','Yangtze River Express Airlines','Yangtze River','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('IRK','Y9','Kish Air','Kishair','Iran');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LLM','YC','Yamal Airlines','Yamal','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CFC','YF','Canadian Armed Forces','Canforce','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('OTL','YG','South Airlines','Southline','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RSI','YI','Air Sunshine','Air Sunshine','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NTN','YJ','National Airways','Natchair','South Africa');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('BSA','YL','Air Bissau International','Bissau International','Guinea-Bissau');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ULG','YL','U Airlines',NULL,'Thailand');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MGX','YM','Montenegro Airlines','Montair','Montenegro');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CRQ','YN','Air Creebec','Cree','Canada');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MCM','YO','Heli Air Monaco','Heli Air','Monaco');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('POT','YQ','Polet Cargo Airlines','Polet','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EGJ','YR','Scenic Airlines','Scenic','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MMZ','YU','euroAtlantic airways','Euroatlantic','Portugal');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ASH','YV','Mesa Airlines','Air Shuttle','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ANE','YW','Air Nostrum','Nostrum Air','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('EZD','Z2','AirAsia Zest','Zest Airways','Philippines');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SMJ','Z3','AV Cargo',NULL,'Zimbabwe');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('UDN','Z6','Dnieproavia','Dniepro','Ukraine');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AZN','Z8','Linea Aerea Amaszonas','Amaszonas','Bolivia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MTZ','Z8','Mali Airways','Mali Airways','Mali');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('DCP','Z9','Delta Connection Kenya','Nilecat','Kenya');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('SWM','ZA','Sky Wings Asia Airlines','Sky Wings','Cambodia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('MON','ZB','Monarch Airlines','Monarch','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('FDN','ZD','Dolphin Air','Flying Dolphin','United Arab Emirates');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AZE','ZE','Arcus-Air Logistics','Arcus Air','Germany');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ESR','ZE','Eastar Jet','Eastar','Korea � Rep. of');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CSZ','ZH','Shenzhen Airlines','Shenzhen Air','China');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AAF','ZI','Aigle Azur','Aigle Azur','France');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('ARC','ZJ','Air Routing International',NULL,'USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GLA','ZK','Great Lakes Aviation','Lakes Air','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('RXA','ZL','Regional Express','Rex','Australia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('CNB','ZM','CityLine Hungary','Cityhun','Hungary');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('NAY','ZN','NAYSA Navegacion y Servicios Aereos Canarios','Naysa','Spain');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AZQ','ZP','Silk Way Airlines','Silk Line','Azerbaijan');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('LOC','ZQ','Locair','Locair','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AZS','ZR','Aviacon Zitotrans','Zitotrans','Russia');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('PUN','ZR','Punto Azul','Punto Azul','Equatorial Guinea');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWC','ZT','Titan Airways','Zap','United Kingdom');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('AWI','ZW','Air Wisconsin','Air Wisconsin','USA');
INSERT INTO airlines(ICAO,IATA,Airline,Callsign,Country_of_Origin) VALUES ('GGN','ZX','Air Georgian/Air Alliance','Georgian','Canada');