--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- -- Airline ICAO codes, in SQL -- -- Vincent Fiano (ynniv@ynniv.com) -- --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- -- The souce of this information is Wikipedia: http://en.wikipedia.org/wiki/ICAO_airline_designator -- This database is NOT a derivative of the official ICAO database. -- It is also NOT authorative. This means if there are mistakes, it is totally NOT my problem. -- If you need accurate data, you should purchase the official list from the ICAO: http://www.icao.int --=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-- -- -- Uncomment if you do not already have a database -- create table airline_icao (code char(4) not null primary key, name varchar(255), callsign varchar(32), website varchar(255)); -- -- Historic data: (optional) -- insert into airline_icao (code, name, callsign, website) values ("AET", "Aero-Palma - Spain (Not Current)", "Aero Palma", ""); -- insert into airline_icao (code, name, callsign, website) values ("AFW", "Great Barrier Airlines - New Zealand (Not Current)", "", ""); -- insert into airline_icao (code, name, callsign, website) values ("AKF", "Anikay Air Company Limited - Krygzstan", "Anikay", ""); -- insert into airline_icao (code, name, callsign, website) values ("ARS", "Aeromet Servicios Ltda - Chile", "Metservice", ""); -- insert into airline_icao (code, name, callsign, website) values ("ASP", "Airsprint Inc - Canada", "Airsprint", ""); -- insert into airline_icao (code, name, callsign, website) values ("AVS", "Artac - Spain (Not Current)", "Artac", ""); -- insert into airline_icao (code, name, callsign, website) values ("ROA", "Reno Air - United States of America defunct", "Reno Air", ""); -- -- Controlled duplicates: (you'll have to reconcile these) insert into airline_icao (code, name, callsign, website) values ("ANX", "Secretaria de Marina - Mexico", "Secretaria Demarina", ""); -- insert into airline_icao (code, name, callsign, website) values ("ANX", "AN Express Hava Yollari (ANEX) - Turkey", "", ""); insert into airline_icao (code, name, callsign, website) values ("ARP", "Société D'Exploitation Aeropostale - France", "Aeroposte", ""); -- insert into airline_icao (code, name, callsign, website) values ("ARP", "RPA-Aviataxi Ltd. - Russian Federation", "", ""); insert into airline_icao (code, name, callsign, website) values ("ASQ", "Atlantic Southeast Airlines - United States of America", "Acey", "http://www.flyasa.com"); -- insert into airline_icao (code, name, callsign, website) values ("ASQ", "Asia Service Airlines - Kazakhstan", "Asia Service", ""); insert into airline_icao (code, name, callsign, website) values ("AUZ", "Australian Airlines Ltd. - Australia", "Australian", ""); -- insert into airline_icao (code, name, callsign, website) values ("AUZ", "Aus-Air (Australian Air Charterers Pty Ltd.) - Australia", "Australian", ""); insert into airline_icao (code, name, callsign, website) values ("RPA", "Republic Airlines - United States of America", "Brickyard", "http://www.republicairlines.com/"); -- insert into airline_icao (code, name, callsign, website) values ("RPA", "Provence Aero Service - France", "Airpass", ""); -- -- Current data insert into airline_icao (code, name, callsign, website) values ("AAA", "Ansett Airlines of Australia (Australia) defunct", "Ansett", ""); insert into airline_icao (code, name, callsign, website) values ("AAB", "Abelag Aviation - Belgium", "ABG", "www.westlink.be"); insert into airline_icao (code, name, callsign, website) values ("AAC", "Army Air Corps - United Kingdom", "Armyair", "www.army.mod.uk/armyaircorps"); insert into airline_icao (code, name, callsign, website) values ("AAD", "Aero Aviation Centre Ltd. - Canada", "Sunrise", ""); insert into airline_icao (code, name, callsign, website) values ("AAE", "Express Air - United States of America", "Arizona", ""); insert into airline_icao (code, name, callsign, website) values ("AAF", "Aigle Azur - France", "Aigle Azur", "www.aigleazur.net"); insert into airline_icao (code, name, callsign, website) values ("AAG", "Air Atlantique - United Kingdom", "Atlantic", "www.airatlantique.co.uk"); insert into airline_icao (code, name, callsign, website) values ("AAH", "Aloha Airlines, Inc. - United States of America", "Aloha", "www.alohaairlines.com"); insert into airline_icao (code, name, callsign, website) values ("AAI", "Air Aurora - United States of America", "Borealis", ""); insert into airline_icao (code, name, callsign, website) values ("AAJ", "Air Alma - Canada", "Air Alma", ""); insert into airline_icao (code, name, callsign, website) values ("AAK", "Alaska Island Air - United States of America", "Alaska Island", ""); insert into airline_icao (code, name, callsign, website) values ("AAL", "American Airlines - United States of America", "American", "www.aa.com"); insert into airline_icao (code, name, callsign, website) values ("AAM", "Aviation Management Corporation - United States of America", "Am Corp", ""); insert into airline_icao (code, name, callsign, website) values ("AAN", "Atlantic Aviation Services - Liberia", "", ""); insert into airline_icao (code, name, callsign, website) values ("AAO", "Atlantis Airlines (USA) - United States of America", "Atlantis Air", ""); insert into airline_icao (code, name, callsign, website) values ("AAP", "Aerovista Airlines - Kyrgyzstan", "Aerovista Group", ""); insert into airline_icao (code, name, callsign, website) values ("AAQ", "Copterline Oy - Finland", "Coptreline", ""); insert into airline_icao (code, name, callsign, website) values ("AAR", "Asiana Airlines - Korea, Republic of", "Asiana", "www.flyAsiana.com"); insert into airline_icao (code, name, callsign, website) values ("AAS", "Asiana Airlines (Pvt) Ltd. - Pakistan", "Al-ass", ""); insert into airline_icao (code, name, callsign, website) values ("AAT", "Austrian Airtransport (Osterreichische Flugbetriebsgesellschaft MbH.) - Austria", "Austrian Charter", ""); insert into airline_icao (code, name, callsign, website) values ("AAU", "Australia Asia Airlines Limited - Australia", "Austasia", ""); insert into airline_icao (code, name, callsign, website) values ("AAV", "Astro Air International - United States of America", "Astro-Phil", ""); insert into airline_icao (code, name, callsign, website) values ("AAW", "Afriqiyah Airways - Libyan Arab Jamahiriya", "Afriqiyah", ""); insert into airline_icao (code, name, callsign, website) values ("AAX", "Afric'air Express - Ivory Coast", "Afrex", ""); insert into airline_icao (code, name, callsign, website) values ("AAY", "Allegiant Air, Inc. - United States of America", "Allegiant", ""); insert into airline_icao (code, name, callsign, website) values ("AAZ", "Angus Aviation Ltd. - Canada", "Angus", ""); insert into airline_icao (code, name, callsign, website) values ("ABA", "Artem-Avia - Ukraine", "Artem-Avia", ""); insert into airline_icao (code, name, callsign, website) values ("ABB", "African Business and Transportations - Congo, The Democratic Republic of", "African Business", ""); insert into airline_icao (code, name, callsign, website) values ("ABC", "OAG Worldwide - United Kingdom", "", ""); insert into airline_icao (code, name, callsign, website) values ("ABD", "Air Atlanta Icelandic - Iceland", "Atlanta", ""); insert into airline_icao (code, name, callsign, website) values ("ABE", "Arberia Airlines - Albania", "Arberia Airlines", ""); insert into airline_icao (code, name, callsign, website) values ("ABF", "Aerial Oy - Finland", "Skywings", ""); insert into airline_icao (code, name, callsign, website) values ("ABG", "Abakan-Avia - Russian Federation", "Abakan-Avia", ""); insert into airline_icao (code, name, callsign, website) values ("ABH", "Aerolineas de Baleares Aebal - Spain", "Air Balear", ""); insert into airline_icao (code, name, callsign, website) values ("ABI", "Antigua And Barbuda Airways International Ltd., - Antigua and Barbuda", "Anair", ""); insert into airline_icao (code, name, callsign, website) values ("ABJ", "Ala Abaete Linhas Aereas S/A - Brazil", "", ""); insert into airline_icao (code, name, callsign, website) values ("ABK", "Alberta Citylink - Canada", "Alberta Citylink", ""); insert into airline_icao (code, name, callsign, website) values ("ABL", "Air BC - Canada", "Aircoach", ""); insert into airline_icao (code, name, callsign, website) values ("ABM", "Aero Albatros - Spain", "Albatros Espana", ""); insert into airline_icao (code, name, callsign, website) values ("ABN", "Air Fret Senegal - Senegal", "", ""); insert into airline_icao (code, name, callsign, website) values ("ABO", "Aeroexpreso Bogota SA - APSA - Colombia", "Aeroexpreso", ""); insert into airline_icao (code, name, callsign, website) values ("ABP", "Aba Air - Czech Republic", "Bair", ""); insert into airline_icao (code, name, callsign, website) values ("ABQ", "Airblue Limited - Pakistan", "Pakblue", ""); insert into airline_icao (code, name, callsign, website) values ("ABR", "Air Contractors (Ireland) Limited - Ireland", "Contract", ""); insert into airline_icao (code, name, callsign, website) values ("ABS", "Transwest Air Limited - Canada", "Athabaska", ""); insert into airline_icao (code, name, callsign, website) values ("ABT", "Air Brousse, Inc - Canada", "Air Brousse", ""); insert into airline_icao (code, name, callsign, website) values ("ABU", "Aerovias Bueno Ltda. - Colombia", "Aerobueno", ""); insert into airline_icao (code, name, callsign, website) values ("ABV", "Antrak Air Ghana - Ghana", "Antrak", ""); insert into airline_icao (code, name, callsign, website) values ("ABW", "Arberia Airways - Albania", "", ""); insert into airline_icao (code, name, callsign, website) values ("ABX", "Airborne Express, Inc. - United States of America", "Abex", ""); insert into airline_icao (code, name, callsign, website) values ("ABY", "Air Arabia - United Arab Emirates", "Arabia", ""); insert into airline_icao (code, name, callsign, website) values ("ABZ", "ATA - Atlantico Transporte Aereo Ltda - Brazil", "ATA-Brazil", ""); insert into airline_icao (code, name, callsign, website) values ("ACA", "Air Canada - Canada", "Air Canada", "http://www.aircanada.com"); insert into airline_icao (code, name, callsign, website) values ("ACB", "African Cargo Services Limited - Kenya", "Africargo", ""); insert into airline_icao (code, name, callsign, website) values ("ACC", "Avcard Services Ltd. - United Kingdom", "", ""); insert into airline_icao (code, name, callsign, website) values ("ACD", "Academy Airlines - United States of America", "Academy", ""); insert into airline_icao (code, name, callsign, website) values ("ACE", "Race Cargo Airlines - Ghana", "Fastcargo", ""); insert into airline_icao (code, name, callsign, website) values ("ACF", "Centro de Formacion Aeronautica de Canarias - Spain", "Forcan", ""); insert into airline_icao (code, name, callsign, website) values ("ACG", "Air Partner Plc - United Kingdom", "Air Partner", ""); insert into airline_icao (code, name, callsign, website) values ("ACH", "Air Cargo Plus - Liberia", "Air Plus", ""); insert into airline_icao (code, name, callsign, website) values ("ACI", "Air Caledonie International - New Caledonia", "Aircalin", ""); insert into airline_icao (code, name, callsign, website) values ("ACJ", "Avicon Limited - Kenya", "Avicharter", ""); insert into airline_icao (code, name, callsign, website) values ("ACK", "Nantucket Airlines - United States of America", "Ack Air", ""); insert into airline_icao (code, name, callsign, website) values ("ACL", "Itali Airlines - Italy", "Itali", ""); insert into airline_icao (code, name, callsign, website) values ("ACM", "Air Caledonia - Canada", "West Cal", ""); insert into airline_icao (code, name, callsign, website) values ("ACN", "Aerolineas Centroamericanas, S.A. (Central American Airlines) - Nicaragua", "Aerocentro", ""); insert into airline_icao (code, name, callsign, website) values ("ACO", "Aero Comondu - Mexico", "Aero Comondu", ""); insert into airline_icao (code, name, callsign, website) values ("ACP", "Astral Aviation Limited - Kenya", "Astral Cargo", ""); insert into airline_icao (code, name, callsign, website) values ("ACQ", "Nuevo Continente - Peru", "Aero Continente", ""); insert into airline_icao (code, name, callsign, website) values ("ACR", "Aerocenter, Escuela de Formacion de Pioltos Privados de Avion - Spain", "Aerocenter", ""); insert into airline_icao (code, name, callsign, website) values ("ACS", "Air Cess (Liberia) - Liberia", "", ""); insert into airline_icao (code, name, callsign, website) values ("ACT", "Flight Line - United States of America", "American Check", ""); insert into airline_icao (code, name, callsign, website) values ("ACU", "Air Cargo Transportation System Limited - Kenya", "Afrispirit", ""); insert into airline_icao (code, name, callsign, website) values ("ACV", "Air Charter Service - United Kingdom", "", ""); insert into airline_icao (code, name, callsign, website) values ("ACW", "RAF Air Cadet Schools - United Kingdom", "Air Cadet", ""); insert into airline_icao (code, name, callsign, website) values ("ACX", "Air Charters, Inc. - Canada", "Parair", ""); insert into airline_icao (code, name, callsign, website) values ("ACY", "Archana Airways Ltd. - India", "Archana", ""); insert into airline_icao (code, name, callsign, website) values ("ADA", "Airservices Australia, Flight Inspection Unit - Australia", "Auscal", ""); insert into airline_icao (code, name, callsign, website) values ("ADB", "Antonov Design Bureau / Antonov Airlines - Ukraine", "Antonov Bureau", ""); insert into airline_icao (code, name, callsign, website) values ("ADC", "Air Atlantic Dominicana - Dominican Republic", "Atlan-Dominican", ""); insert into airline_icao (code, name, callsign, website) values ("ADD", "Advanced Air Co. Ltd. - Japan", "", ""); insert into airline_icao (code, name, callsign, website) values ("ADE", "Ada Air - Albania", "Ada Air", ""); insert into airline_icao (code, name, callsign, website) values ("ADF", "Ade, Aviacion Deportiva, S.L. - Spain", "Ade Aviacion", ""); insert into airline_icao (code, name, callsign, website) values ("ADG", "Aerea Flying Training Organization, S.A. - Spain", "Aerea Training", ""); insert into airline_icao (code, name, callsign, website) values ("ADH", "Air One - Italy", "Heron", ""); insert into airline_icao (code, name, callsign, website) values ("ADI", "Audeli Air Express - Spain", "Audeli", ""); insert into airline_icao (code, name, callsign, website) values ("ADJ", "Abicar - Cote D'Ivoire", "Abicar", ""); insert into airline_icao (code, name, callsign, website) values ("ADK", "Aviation Development Company Plc - Nigeria", "Adco", ""); insert into airline_icao (code, name, callsign, website) values ("ADL", "Aero Dynamics - United Kingdom", "Cotswold", ""); insert into airline_icao (code, name, callsign, website) values ("ADM", "Dominair - Dominican Republic", "Dominair", ""); insert into airline_icao (code, name, callsign, website) values ("ADN", "Aerodienst GmbH - Germany", "Aerodienst", ""); insert into airline_icao (code, name, callsign, website) values ("ADO", "Hokkaido International Airlines - Japan", "Air Do", "http://www.airdo21.com/"); insert into airline_icao (code, name, callsign, website) values ("ADP", "Aerodiplomatic - Mexico", "Aerodiplomatic", ""); insert into airline_icao (code, name, callsign, website) values ("ADQ", "Avion Taxi (2695731 Canada Inc.) - Canada", "Air Data", ""); insert into airline_icao (code, name, callsign, website) values ("ADR", "Adria Airways - Slovenia", "Adria", "http://www.adria-airways.com"); insert into airline_icao (code, name, callsign, website) values ("ADS", "Aviones de Sonora, S.A. - Mexico", "Sonorav", ""); insert into airline_icao (code, name, callsign, website) values ("ADT", "Air Dorval Ltee. - Canada", "Air Dorval", ""); insert into airline_icao (code, name, callsign, website) values ("ADU", "Airdeal Oy - Finland", "Airdeal", ""); insert into airline_icao (code, name, callsign, website) values ("ADV", "Advance Air Charters - Canada", "Advance", ""); insert into airline_icao (code, name, callsign, website) values ("ADW", "Air Andaman - Thailand", "Air Andaman", ""); insert into airline_icao (code, name, callsign, website) values ("ADX", "Anderson Aviation, Inc. - United States of America", "Andax", ""); insert into airline_icao (code, name, callsign, website) values ("ADY", "Aerodyne - United States of America", "Aerodyne", ""); insert into airline_icao (code, name, callsign, website) values ("AEA", "Air Europa Líneas Aéreas, S.A. - Spain", "Europa", "http://www.aireuropa.com"); insert into airline_icao (code, name, callsign, website) values ("AEB", "Aero Benin S.A. - Benin", "Aeroben", ""); insert into airline_icao (code, name, callsign, website) values ("AEC", "Aerocesar, Aerovias Del Cesar - Colombia", "Aerocesar", ""); insert into airline_icao (code, name, callsign, website) values ("AED", "Aerotrans Airlines, Closed Joint-Stock Company - Russian Federation", "", ""); insert into airline_icao (code, name, callsign, website) values ("AEE", "Aegean Airlines - Greece", "Aegean", ""); insert into airline_icao (code, name, callsign, website) values ("AEF", "Aero LLoyd - Germany", "Aero Lloyd", ""); insert into airline_icao (code, name, callsign, website) values ("AEG", "Aerofumigaciones Sam - Chile", "Fumigaciones Sam", ""); insert into airline_icao (code, name, callsign, website) values ("AEH", "Aviaexpress - Hungary", "Avex", ""); insert into airline_icao (code, name, callsign, website) values ("AEI", "Aeroexpreso Interamericano - Colombia", "Interam", ""); insert into airline_icao (code, name, callsign, website) values ("AEJ", "Air Express Limited - Tanzania, United Republic of", "Khaki Express", ""); insert into airline_icao (code, name, callsign, website) values ("AEK", "Aero Costa Rica - Costa Rica", "Acorisa", ""); insert into airline_icao (code, name, callsign, website) values ("AEL", "Air Europe S.p.A. - Italy", "Air Europe", ""); insert into airline_icao (code, name, callsign, website) values ("AEM", "Aero Madrid - Spain", "Aeromadrid", ""); insert into airline_icao (code, name, callsign, website) values ("AEN", "Air Entreprise - France", "Air Enterprise", ""); insert into airline_icao (code, name, callsign, website) values ("AEO", "Aeroservicios Ejecutivos Del Occidente, S.A. de C.V. - Mexico", "Aero Occidente", ""); insert into airline_icao (code, name, callsign, website) values ("AEP", "Aerotec - Spain", "Aerotec", ""); insert into airline_icao (code, name, callsign, website) values ("AEQ", "Air Expess in Sweden - Sweden", "Luna", ""); insert into airline_icao (code, name, callsign, website) values ("AER", "Alaska Central Express, Inc. - United States of America", "Ace Air", ""); insert into airline_icao (code, name, callsign, website) values ("AES", "Aerolineas Centrales de Colombia - Colombia", "Aces", ""); insert into airline_icao (code, name, callsign, website) values ("AET", "Aeronautical Radio of Thailand - Thailand", "Aerothai", ""); insert into airline_icao (code, name, callsign, website) values ("AEU", "Astraeus - United Kingdom", "Flystar", "http://www.flyastreus.com"); insert into airline_icao (code, name, callsign, website) values ("AEV", "Aeroventas, S.A. - Mexico", "Aeroventas", ""); insert into airline_icao (code, name, callsign, website) values ("AEW", "Aerosvit Airlines - Ukraine", "Aerosvit", ""); insert into airline_icao (code, name, callsign, website) values ("AEX", "Airway Express, Inc. - United States of America", "Avco", ""); insert into airline_icao (code, name, callsign, website) values ("AEY", "Air Italy - Italy", "Air Italy", ""); insert into airline_icao (code, name, callsign, website) values ("AEZ", "Aerial Transit Company - United States of America", "Aerial Tranz", ""); insert into airline_icao (code, name, callsign, website) values ("AFA", "Alfa Air - Czech Republic", "Blue Alfa", ""); insert into airline_icao (code, name, callsign, website) values ("AFB", "American Falcon, S.A. - Argentina", "American Falcon", ""); insert into airline_icao (code, name, callsign, website) values ("AFC", "African West Air (AWA) - Senegal", "African West", ""); insert into airline_icao (code, name, callsign, website) values ("AFD", "Panorama Flight Service - United States of America", "Airfed", ""); insert into airline_icao (code, name, callsign, website) values ("AFE", "Airfast Service Indonesia PT - Indonesia", "Airfast", ""); insert into airline_icao (code, name, callsign, website) values ("AFF", "Afric'Air Charter, S.A. - Benin", "Benin-Charters", ""); insert into airline_icao (code, name, callsign, website) values ("AFG", "Ariana Afghan Airlines - Afghanistan", "Ariana", ""); insert into airline_icao (code, name, callsign, website) values ("AFH", "Air Fecteau Ltee. - Canada", "Fecto", ""); insert into airline_icao (code, name, callsign, website) values ("AFI", "Africaone - The Gambia", "Africaworld", ""); insert into airline_icao (code, name, callsign, website) values ("AFJ", "Alliance - Uganda", "Jambo", ""); insert into airline_icao (code, name, callsign, website) values ("AFK", "Africa Air Links - Sierra Leone", "Africa Links", ""); insert into airline_icao (code, name, callsign, website) values ("AFL", "Aeroflot Russian Airlines - Russian Federation", "Aeroflot", ""); insert into airline_icao (code, name, callsign, website) values ("AFM", "Affretair (Private) Limited - Zimbabwe", "Afro", ""); insert into airline_icao (code, name, callsign, website) values ("AFN", "African International Airlines - Lesotho", "Simba", ""); insert into airline_icao (code, name, callsign, website) values ("AFO", "Aero Empresa Mexicana, S.A. - Mexico", "Aero Empresa", ""); insert into airline_icao (code, name, callsign, website) values ("AFP", "Portuguese Air Force - Portugal", "Portuguese Air Force", ""); insert into airline_icao (code, name, callsign, website) values ("AFQ", "Alba Servizi Aerotrasporti S.p.A. - Italy", "Alba", ""); insert into airline_icao (code, name, callsign, website) values ("AFR", "Air France - France", "Airfrans", "http://www.airfrance.com"); insert into airline_icao (code, name, callsign, website) values ("AFS", "Air Data Ltd. - United Kingdom", "", ""); insert into airline_icao (code, name, callsign, website) values ("AFU", "Afrinat (Gambia) International Airlines, Inc. - Ghana", "Afrinat", ""); insert into airline_icao (code, name, callsign, website) values ("AFV", "Air Afrique Vacancies - Cote D'Ivoire", "Arfique Vacance", ""); insert into airline_icao (code, name, callsign, website) values ("AFW", "Afrique Regional Airways - Cote D'Ivoire", "Afrair", ""); insert into airline_icao (code, name, callsign, website) values ("AFX", "Airfreight Express - United Kingdom 'defunct'", "", ""); insert into airline_icao (code, name, callsign, website) values ("AFY", "Africa Chartered Services - Nigeria", "Africa Chartered", ""); insert into airline_icao (code, name, callsign, website) values ("AFZ", "Africa Freight Services (Z) Limited - Zambia", "Afreight", ""); insert into airline_icao (code, name, callsign, website) values ("AGA", "Aeronaves Del Centro - Venezuela", "", ""); insert into airline_icao (code, name, callsign, website) values ("AGB", "Air Service Gabon - Gabon", "", ""); insert into airline_icao (code, name, callsign, website) values ("AGC", "Arab Agricultural Aviation Company - Egypt", "Agrico", ""); insert into airline_icao (code, name, callsign, website) values ("AGD", "Agderfly A/S - Norway", "Agderfly", ""); insert into airline_icao (code, name, callsign, website) values ("AGE", "Servicios Aereos de Los Angeles, S.A. de C.V. - Mexico", "Aeroangel", ""); insert into airline_icao (code, name, callsign, website) values ("AGF", "Atlantic Gulf Airlines, Inc. - United States of America", "Atlantic Gulf", ""); insert into airline_icao (code, name, callsign, website) values ("AGG", "Algoma Airways, Inc. - Canada", "Algoma", ""); insert into airline_icao (code, name, callsign, website) values ("AGH", "Altagna - France", "Altagna", ""); insert into airline_icao (code, name, callsign, website) values ("AGI", "Agrar-Aviacion, S.A. - Spain", "Agrar Aviacion", ""); insert into airline_icao (code, name, callsign, website) values ("AGK", "TAG Aviation Ukraine Ltd. - Ukraine", "TAG Ukraine", ""); insert into airline_icao (code, name, callsign, website) values ("AGL", "Air Angouleme - France", "Air Angouleme", ""); insert into airline_icao (code, name, callsign, website) values ("AGM", "Air Guam - United States", "Air Guam", ""); insert into airline_icao (code, name, callsign, website) values ("AGN", "Air Gabon - Gabon", "Golf November", ""); insert into airline_icao (code, name, callsign, website) values ("AGO", "AAC - Angola Air Charter Ltd. - Angola", "Angola Charter", ""); insert into airline_icao (code, name, callsign, website) values ("AGP", "AERFI Group plc - Ireland", "Aer Tara", ""); insert into airline_icao (code, name, callsign, website) values ("AGQ", "Aerogala Ltda - Chile", "Galaservice", ""); insert into airline_icao (code, name, callsign, website) values ("AGR", "Dept. Of Agriculture - United States of America", "Agriculture", ""); insert into airline_icao (code, name, callsign, website) values ("AGS", "Air Gambia - Gambia", "Atas", ""); insert into airline_icao (code, name, callsign, website) values ("AGT", "Amadeus Global Travel Distribution, S.A. - Spain", "", ""); insert into airline_icao (code, name, callsign, website) values ("AGU", "Angara Airlines, JSC - Russian Federation", "Sarma", ""); insert into airline_icao (code, name, callsign, website) values ("AGV", "Air Glaciers - Switzerland", "Air Glaciers", ""); insert into airline_icao (code, name, callsign, website) values ("AGW", "Aero Gambia - Gambia", "Aero Gambia", ""); insert into airline_icao (code, name, callsign, website) values ("AGX", "Aviogenex - Serbia and Montenegro", "Genex", "http://www.aviogenex.co.yu/"); insert into airline_icao (code, name, callsign, website) values ("AGY", "Aero Flight Service, Inc. - United States of America", "Flight Group", ""); insert into airline_icao (code, name, callsign, website) values ("AGZ", "Agrolet-Mci Ltd. - Slovak Republic", "Agrolet", ""); insert into airline_icao (code, name, callsign, website) values ("AHA", "Air Alpha Greenland A/S - Denmark", "Air Alpha", ""); insert into airline_icao (code, name, callsign, website) values ("AHB", "Aerolineas de Honduras, S.A. (AEHSA) - Honduras", "", ""); insert into airline_icao (code, name, callsign, website) values ("AHC", "Cargo Airline of the State Concern Azerbaijan Hava - Azerbaijan", "Azalviacargo", ""); insert into airline_icao (code, name, callsign, website) values ("AHD", "Czech Air Handling - Czech Republic", "Airhandling", ""); insert into airline_icao (code, name, callsign, website) values ("AHE", "Airport Helicopter Basel, Muller & Co. - Switzerland", "Airport Helicopter", ""); insert into airline_icao (code, name, callsign, website) values ("AHF", "Aspen Helicopters, Inc. - United States of America", "Aspen", ""); insert into airline_icao (code, name, callsign, website) values ("AHG", "Aerochago Airlines SA - Dominican Republic", "Aerochago", ""); insert into airline_icao (code, name, callsign, website) values ("AHH", "Airplanes Holdings Ltd. - Ireland", "Airhold", ""); insert into airline_icao (code, name, callsign, website) values ("AHI", "Servicios Aereos de Chihuahua Aerochisa, S.A. de C.V. - Mexico", "Aerochisa", ""); insert into airline_icao (code, name, callsign, website) values ("AHK", "AHK Air Hong Kong Ltd. - Hong Kong SAR of China", "Air Hong Kong", "http://www.airhongkong.com.hk/"); insert into airline_icao (code, name, callsign, website) values ("AHM", "Garrison Aviation Ltd. - Canada", "Air Huron", ""); insert into airline_icao (code, name, callsign, website) values ("AHN", "Air Hungaria Ltd. - Hungary", "Air Hungaria", ""); insert into airline_icao (code, name, callsign, website) values ("AHO", "Air Holbaek I/S - Denmark", "Airdane", ""); insert into airline_icao (code, name, callsign, website) values ("AHP", "Aerochiapas, S.A. de C.V. - Mexico", "Aerochiapas", ""); insert into airline_icao (code, name, callsign, website) values ("AHR", "Air Adriatic Ltd. - Croatia", "Adriatic", "http://www.airadriatic.com/"); insert into airline_icao (code, name, callsign, website) values ("AHS", "Air Viggi San Raffaele S.r.l. - Italy", "Airsar", ""); insert into airline_icao (code, name, callsign, website) values ("AHT", "HTA Helicopteros, Lda - Portugal", "Heliapra", ""); insert into airline_icao (code, name, callsign, website) values ("AHU", "ABC Air Hungary Ltd. - Hungary", "ABC Hungary", ""); insert into airline_icao (code, name, callsign, website) values ("AHW", "Aeromist - Kharkiv Ltd. - Ukraine", "Aeromist", ""); insert into airline_icao (code, name, callsign, website) values ("AHY", "Azerbaijan Hava Yollary - Azerbaijan", "Azal", "http://www.nac-azal.com"); insert into airline_icao (code, name, callsign, website) values ("AIA", "Avies - Estonia", "Avies", "http://www.avies.ee/"); insert into airline_icao (code, name, callsign, website) values ("AIB", "Airbus Industrie - France", "Airbus Industrie", "http://www.airbus.com/en/"); insert into airline_icao (code, name, callsign, website) values ("AIC", "Air India Limited - India", "Airindia", "http://www.airindia.com"); insert into airline_icao (code, name, callsign, website) values ("AID", "Altit - Kazakhstan", "Altit", ""); insert into airline_icao (code, name, callsign, website) values ("AIE", "Air Inuit Ltd/Ltee. - Canada", "Air Inuit", "http://www.airinuit.com"); insert into airline_icao (code, name, callsign, website) values ("AIF", "CIA - Compania Aerea de Valencia - Spain", "Flymed", ""); insert into airline_icao (code, name, callsign, website) values ("AIG", "Air Inter Gabon - Gabon", "", ""); insert into airline_icao (code, name, callsign, website) values ("AIH", "Alpine Air Chile, S.A. - Chile", "Apline Chile", ""); insert into airline_icao (code, name, callsign, website) values ("AII", "Air Integra - Canada", "Integra", ""); insert into airline_icao (code, name, callsign, website) values ("AIK", "African Airlines International Limited - Kenya", "African Airlines", ""); insert into airline_icao (code, name, callsign, website) values ("AIL", "Air Illinois, Inc. - United States of America", "Air Illinois", ""); insert into airline_icao (code, name, callsign, website) values ("AIM", "Aviones Y Helicopteros Illes Balears, S.A. - Spain", "Avicoba", ""); insert into airline_icao (code, name, callsign, website) values ("AIN", "African International Airways - Swaziland", "Fly Cargo", "http://www.aiaflycargo.com"); insert into airline_icao (code, name, callsign, website) values ("AIO", "Chief of Staff, United States Air Force - United States of America", "Air Chief", ""); insert into airline_icao (code, name, callsign, website) values ("AIP", "Alpine Aviation, Inc. - United States of America", "Alpine Air", ""); insert into airline_icao (code, name, callsign, website) values ("AIQ", "Air Asia Aviation Co. Ltd. - Thailand", "Thai Asia", ""); insert into airline_icao (code, name, callsign, website) values ("AIR", "Airlift International, Inc. - United States of America", "Airlift", ""); insert into airline_icao (code, name, callsign, website) values ("AIS", "Air Sureste - Spain", "Air Sureste", ""); insert into airline_icao (code, name, callsign, website) values ("AIT", "Airest - Estonia", "", ""); insert into airline_icao (code, name, callsign, website) values ("AIU", "Alicante Internacional Airlines, S.L. - Spain", "Alia", ""); insert into airline_icao (code, name, callsign, website) values ("AIV", "Airvias S/A Linhas Aereas - Brazil", "Airvias", ""); insert into airline_icao (code, name, callsign, website) values ("AIW", "Atlantic Island Airways - Canada", "Tartan", ""); insert into airline_icao (code, name, callsign, website) values ("AIX", "Aircruising Australia - Australia", "Cruiser", ""); insert into airline_icao (code, name, callsign, website) values ("AIY", "Aircrew Check and Training Australia - Australia", "Aircrew", ""); insert into airline_icao (code, name, callsign, website) values ("AIZ", "Arkia Israel Airlines - Israel", "Arkia", "http://www.arkia.co.il/"); insert into airline_icao (code, name, callsign, website) values ("AJA", "A J Services Limited - United Kingdom", "Ayjay Services", ""); insert into airline_icao (code, name, callsign, website) values ("AJB", "Aero JBR, S.A. de C.V. - Mexico", "Aero JBR", ""); insert into airline_icao (code, name, callsign, website) values ("AJC", "Bar Harbor Airlines - United States of America", "Bar Harbor", ""); insert into airline_icao (code, name, callsign, website) values ("AJE", "Aero Jet Express, S.A. de C.V. - Mexico", "Jet Express", ""); insert into airline_icao (code, name, callsign, website) values ("AJF", "Avia Consult Flugbetriebs - Austria", "Aviaconsult", ""); insert into airline_icao (code, name, callsign, website) values ("AJI", "Ameristar Jet Charter, Inc. - United States of America", "Ameristar", ""); insert into airline_icao (code, name, callsign, website) values ("AJJ", "A2 Jet Leasing LLC - United States of America", "Atlantic Jet", ""); insert into airline_icao (code, name, callsign, website) values ("AJK", "Allied Air Limited - Nigeria", "Bambi", ""); insert into airline_icao (code, name, callsign, website) values ("AJM", "Air Jamaica - Jamaica", "Jamaica", "http://www.airjamaica.com/"); insert into airline_icao (code, name, callsign, website) values ("AJO", "Aeroejecutivo S.A. de C.V. - Mexico", "Aeroexo", ""); insert into airline_icao (code, name, callsign, website) values ("AJP", "Aero Jets Corporativos, S.A. de C.V. - Mexico", "Aerojets", ""); insert into airline_icao (code, name, callsign, website) values ("AJS", "Aeroejecutivos Colombia - Aeroejecutivos Aeroservicios Ejecutivos - Colombia", "Aeroejecutivos", ""); insert into airline_icao (code, name, callsign, website) values ("AJT", "Amerijet International, Inc. - United States of America", "Amerijet", "http://www.amerijet.com/"); insert into airline_icao (code, name, callsign, website) values ("AJU", "Air Jetsul - Portugal", "Airjetsul", ""); insert into airline_icao (code, name, callsign, website) values ("AJW", "Alpha Jet International - United States of America", "Alphajet", ""); insert into airline_icao (code, name, callsign, website) values ("AJX", "Air Japan Company Ltd - Japan", "Air Japan", "http://www.air-japan.co.jp/"); insert into airline_icao (code, name, callsign, website) values ("AKA", "Air Korea Co. Ltd. - Korea, Republic of", "", ""); insert into airline_icao (code, name, callsign, website) values ("AKB", "Aktjubavia - Kazakhstan", "Karab", ""); insert into airline_icao (code, name, callsign, website) values ("AKC", "Arca Aerovias Colombianas Ltda. - Colombia", "Arca", ""); insert into airline_icao (code, name, callsign, website) values ("AKD", "Alfa KR - Kyrgyzstan", "Alfa Asia", ""); insert into airline_icao (code, name, callsign, website) values ("AKE", "Air Maken - Equatorial Guinea", "Air Maken", ""); insert into airline_icao (code, name, callsign, website) values ("AKF", "Aero Monbasa - Kenya", "African Falcon", ""); insert into airline_icao (code, name, callsign, website) values ("AKG", "84 Squadron RAF Akrotiri - United Kingdom", "Grifter", ""); insert into airline_icao (code, name, callsign, website) values ("AKH", "Akhal - Turkmenistan", "Akhal", ""); insert into airline_icao (code, name, callsign, website) values ("AKI", "Ibk-Petra - Sudan", "", ""); insert into airline_icao (code, name, callsign, website) values ("AKK", "Aklak Air, Inc. - Canada", "Aklak", ""); insert into airline_icao (code, name, callsign, website) values ("AKM", "Acme (airline) - Spain", "Amce Aereo", ""); insert into airline_icao (code, name, callsign, website) values ("AKN", "Alkan Air Ltd. - Canada", "Alkan Air", ""); insert into airline_icao (code, name, callsign, website) values ("AKP", "Aircompany Antex-Polus, CJSC - Russian Federation", "Antex-Polus", ""); insert into airline_icao (code, name, callsign, website) values ("AKR", "Arctic Air A.S. - Norway", "Arctic Norway", ""); insert into airline_icao (code, name, callsign, website) values ("AKS", "Akhmos-1 - Belarus", "Akhmos", ""); insert into airline_icao (code, name, callsign, website) values ("AKT", "Karat Joint Stock Company - Russian Federation", "Aviakarat", ""); insert into airline_icao (code, name, callsign, website) values ("AKU", "Acsunkar - Kazakhstan", "Acsunkar", ""); insert into airline_icao (code, name, callsign, website) values ("AKW", "Angkor Airways - Cambodia", "Angkorways", ""); insert into airline_icao (code, name, callsign, website) values ("AKX", "Air Nippon Network Co. Ltd. - Japan", "Alfa Wing", ""); insert into airline_icao (code, name, callsign, website) values ("AKY", "Yak-Service - Russian Federation", "Yak-Service", ""); insert into airline_icao (code, name, callsign, website) values ("AKZ", "AK Navigator LLC - Kazakhstan", "Absolute", ""); insert into airline_icao (code, name, callsign, website) values ("ALB", "Aero Albatros - Mexico", "Albatros", ""); insert into airline_icao (code, name, callsign, website) values ("ALC", "Southern Jersey Airways, Inc. - United States of America", "Acom", ""); insert into airline_icao (code, name, callsign, website) values ("ALD", "Aeronaves La Dorada, S.A. - Spain", "Dorada", ""); insert into airline_icao (code, name, callsign, website) values ("ALE", "Aeroalas Colombia - Aerolineas Especiales de Colombia - Colombia", "Aeroalas", ""); insert into airline_icao (code, name, callsign, website) values ("ALF", "Allied Command Europe (Mobile Force) - Belgium", "Aceforce", ""); insert into airline_icao (code, name, callsign, website) values ("ALG", "Air Logistics - United States of America", "Airlog", ""); insert into airline_icao (code, name, callsign, website) values ("ALH", "Atlantic Airways Ltd. - United Kingdom", "Lofcargo", ""); insert into airline_icao (code, name, callsign, website) values ("ALI", "Air Liberia - Liberia", "November Lima", ""); insert into airline_icao (code, name, callsign, website) values ("ALJ", "Heli Ambulance Team - Austria", "Alpin Heli", ""); insert into airline_icao (code, name, callsign, website) values ("ALK", "SriLankan Airlines Limited - Sri Lanka", "Srilankan", ""); insert into airline_icao (code, name, callsign, website) values ("ALL", "Aerovallarta, S.A. de C.V. - Mexico", "Vallarta", ""); insert into airline_icao (code, name, callsign, website) values ("ALM", "ALM 1997 Airline Inc., d/b/a Air ALM - Netherlands Antilles", "Antillean", ""); insert into airline_icao (code, name, callsign, website) values ("ALN", "Air Lincoln, Inc. - United States of America", "Chicago Lincoln", ""); insert into airline_icao (code, name, callsign, website) values ("ALO", "Allegheny Commuter Airlines, Inc. d/b/a USAirways Express - United States of America", "Allegheny", ""); insert into airline_icao (code, name, callsign, website) values ("ALP", "Alpliner AG - Switzerland", "Alpliner", ""); insert into airline_icao (code, name, callsign, website) values ("ALQ", "Altair Aviation (1986) Ltd. - Canada", "Altair", ""); insert into airline_icao (code, name, callsign, website) values ("ALR", "Lineas Aereas Alaire S.L. - Spain", "Aeroalaire", ""); insert into airline_icao (code, name, callsign, website) values ("ALS", "Atlantis Airlines - Senegal", "Atlantis-Lines", ""); insert into airline_icao (code, name, callsign, website) values ("ALT", "SBS Aircraft - Kazakhstan", "Green-Craft", ""); insert into airline_icao (code, name, callsign, website) values ("ALU", "Air Luxor STP - Sao Tome and Principe", "Luxorjet", ""); insert into airline_icao (code, name, callsign, website) values ("ALV", "Alas de Venezuela - Venezuela", "Alven", ""); insert into airline_icao (code, name, callsign, website) values ("ALW", "Alas Nacionales, S.A. - Dominican Republic", "Alnacional", ""); insert into airline_icao (code, name, callsign, website) values ("ALX", "Hewa Bora Airways - Congo, The Democratic Republic of", "Allcongo", ""); insert into airline_icao (code, name, callsign, website) values ("ALY", "Alyeska Air Service - United States of America", "Alyeska", ""); insert into airline_icao (code, name, callsign, website) values ("ALZ", "Alta Flights (Charters) Ltd. - Canada", "", ""); insert into airline_icao (code, name, callsign, website) values ("AMA", "ATMA - Kazakhstan", "Adik", ""); insert into airline_icao (code, name, callsign, website) values ("AMB", "Deutsche Rettungsflugwacht - Germany", "Civil Air Ambulance", ""); insert into airline_icao (code, name, callsign, website) values ("AMC", "Air Malta - Malta", "Air Malta", ""); insert into airline_icao (code, name, callsign, website) values ("AMD", "Aerolineas Medellin - Colombia", "Aerolineas Medellin", ""); insert into airline_icao (code, name, callsign, website) values ("AME", "Aeronave Militar Espanola. Ministerio de Defensa (Spanish Air Force) - Spain", "Airmil", ""); insert into airline_icao (code, name, callsign, website) values ("AMF", "Ameriflight, Inc. - United States of America", "Amflight", ""); insert into airline_icao (code, name, callsign, website) values ("AMG", "Air Minas Linhas Aereas Ltda - Brazil", "Air Minas", ""); insert into airline_icao (code, name, callsign, website) values ("AMH", "Alan Mann Helicopters Ltd. - United Kingdom", "Mann", ""); insert into airline_icao (code, name, callsign, website) values ("AMI", "Air Maldives Limited - Maldives", "Air Maldives", ""); insert into airline_icao (code, name, callsign, website) values ("AMJ", "Aviation Amos M. Et J. Inc. d/b/a Aviation Amos - Canada", "Aviation Amos", ""); insert into airline_icao (code, name, callsign, website) values ("AMK", "Amerer Air - Austria", "Amer Air", ""); insert into airline_icao (code, name, callsign, website) values ("AML", "Air Malawi Limited - Malawi", "Malawi", ""); insert into airline_icao (code, name, callsign, website) values ("AMM", "Aeroputul International Marculesti - Moldova", "Aerom", ""); insert into airline_icao (code, name, callsign, website) values ("AMN", "Air Montenegro - Yugoslavia", "Montenegro", ""); insert into airline_icao (code, name, callsign, website) values ("AMO", "Air Montreal (Air Holdings Inc.) - Canada", "Air Montreal", ""); insert into airline_icao (code, name, callsign, website) values ("AMP", "Aero Transporte S.A. (ATSA) - Peru", "Atsa", ""); insert into airline_icao (code, name, callsign, website) values ("AMQ", "Aeromedicare Ltd. - United Kingdom", "Lifeline", ""); insert into airline_icao (code, name, callsign, website) values ("AMR", "Air Specialties Corporation d/b/a Air American / Total Air - United States of America", "Air Am", ""); insert into airline_icao (code, name, callsign, website) values ("AMS", "Air Muskoka - Canada", "Air Muskoka", ""); insert into airline_icao (code, name, callsign, website) values ("AMT", "ATA Airlines - United States of America", "Amtran", ""); insert into airline_icao (code, name, callsign, website) values ("AMU", "Air Macao Company Limited - Macau SAR of China", "Air Macao", ""); insert into airline_icao (code, name, callsign, website) values ("AMV", "Aircraft Maintenance Company - Egypt", "", ""); insert into airline_icao (code, name, callsign, website) values ("AMW", "Air Midwest - United States of America", "Air Midwest", ""); insert into airline_icao (code, name, callsign, website) values ("AMX", "Aeroméxico - Mexico", "Aeromexico", "http://www.aeromexico.com"); insert into airline_icao (code, name, callsign, website) values ("AMY", "Air Ambar, S.A. - Dominican Republic", "Air Ambar", ""); insert into airline_icao (code, name, callsign, website) values ("AMZ", "Amiya Airline Limited - Nigeria", "Amiyi Air", "http://www.amiya.com"); insert into airline_icao (code, name, callsign, website) values ("ANA", "All Nippon Airways Co. Ltd. - Japan", "All Nippon", "http://www.fly-ana.com"); insert into airline_icao (code, name, callsign, website) values ("ANB", "Air Navigation And Trading Co. Ltd. - United Kingdom", "Air Nav", ""); insert into airline_icao (code, name, callsign, website) values ("ANC", "Anglo Cargo - United Kingdom 'defunct'", "Anglo", ""); insert into airline_icao (code, name, callsign, website) values ("AND", "National Jet Service, Inc. - United States of America", "Air Indiana", ""); insert into airline_icao (code, name, callsign, website) values ("ANE", "Americana de Aviacion, S.A. - Peru", "Americana", ""); insert into airline_icao (code, name, callsign, website) values ("ANF", "Alpine Aviation Ltd. - United Kingdom", "Cresta", ""); insert into airline_icao (code, name, callsign, website) values ("ANG", "Air Niugini - Papua New Guinea", "Niugini", "http://www.airniugini.com.pg/"); insert into airline_icao (code, name, callsign, website) values ("ANH", "Alajnihah for Air Transport - Libyan Arab Jamahiriya", "Alajnihah", ""); insert into airline_icao (code, name, callsign, website) values ("ANI", "Air Atlantic (Nig) Limited - Nigeria", "Nigalantic", ""); insert into airline_icao (code, name, callsign, website) values ("ANK", "Air Nippon - Japan", "Ank Air", "http://www.air-nippon.co.jp/"); insert into airline_icao (code, name, callsign, website) values ("ANL", "Nacoia Lda - Angola", "Air Nacoia", ""); insert into airline_icao (code, name, callsign, website) values ("ANM", "Antares Airtransport, Maintenance & Service GmbH - Germany", "Antares", ""); insert into airline_icao (code, name, callsign, website) values ("ANO", "Airnorth Regional - Australia", "Topend", ""); insert into airline_icao (code, name, callsign, website) values ("ANP", "Antonair International (Pty) Ltd. - Lesotho", "Antonair", ""); insert into airline_icao (code, name, callsign, website) values ("ANQ", "Aerolinea de Antioquia, S.A. (ADA) - Colombia", "Antioquia", ""); insert into airline_icao (code, name, callsign, website) values ("ANR", "Aeronorte, S.A. - Colombia", "Aeronorte", ""); insert into airline_icao (code, name, callsign, website) values ("ANS", "Air Nostrum - Spain", "Nostru Air", ""); insert into airline_icao (code, name, callsign, website) values ("ANT", "Air North Charter - Canada", "Air North", ""); insert into airline_icao (code, name, callsign, website) values ("ANV", "Pacific Wings - United States of America", "Tsunami", ""); insert into airline_icao (code, name, callsign, website) values ("ANW", "Aviacion Del Noroeste, S.A. de C.V. - Mexico", "Avinor", ""); insert into airline_icao (code, name, callsign, website) values ("ANY", "OAG Computer -", "", ""); insert into airline_icao (code, name, callsign, website) values ("ANZ", "Air New Zealand - New Zealand", "New Zealand", "http://www.airnewzealand.com"); insert into airline_icao (code, name, callsign, website) values ("AOA", "Alcon Servicios Aereos, S.A. de C.V. - Mexico", "Alcon", ""); insert into airline_icao (code, name, callsign, website) values ("AOC", "Joint-Stock Holding Co. Aviation Commercial - AVCOM - Russian Federation", "Aero Avcom", ""); insert into airline_icao (code, name, callsign, website) values ("AOD", "Aero Vodochody - Czech Republic", "Aero Czech", ""); insert into airline_icao (code, name, callsign, website) values ("AOE", "Air One Executive - Italy", "", ""); insert into airline_icao (code, name, callsign, website) values ("AOF", "Atair Pty Ltd. - South Africa", "Atair", ""); insert into airline_icao (code, name, callsign, website) values ("AOG", "Aero VIP, S.A. - Argentina", "Avip", ""); insert into airline_icao (code, name, callsign, website) values ("AOH", "North Coast Aviation - United States of America", "Air Ohio", ""); insert into airline_icao (code, name, callsign, website) values ("AOI", "Astoria, Inc. - Canada", "Astoria", ""); insert into airline_icao (code, name, callsign, website) values ("AOK", "Aeroatlantico Colombia - Aerovias Del Atlantico Ltda. - Colombia", "", ""); insert into airline_icao (code, name, callsign, website) values ("AOL", "Angkor Airlines - Cambodia", "Angkor Air", ""); insert into airline_icao (code, name, callsign, website) values ("AON", "Aero Entreprise - France", "Aero Enterprose", ""); insert into airline_icao (code, name, callsign, website) values ("AOO", "As, Opened Joint Stock Company - Ukraine", "Company As", ""); insert into airline_icao (code, name, callsign, website) values ("AOP", "Aeropiloto - Sociedade Exploradora de Servicos Aereos, Lda. - Portugal", "Aeropiloto", ""); insert into airline_icao (code, name, callsign, website) values ("AOR", "Afro International Ent. Limited - Nigeria", "Inter-Afro", ""); insert into airline_icao (code, name, callsign, website) values ("AOS", "Servicios Aerecs Del Sol, S.A. de C.V. - Mexico", "Aerosol", ""); insert into airline_icao (code, name, callsign, website) values ("AOT", "Asia Overnight Express Corporation - Philippines", "Asia Overnight", ""); insert into airline_icao (code, name, callsign, website) values ("AOU", "Air Tractor - Croatia", "Air Tractor", ""); insert into airline_icao (code, name, callsign, website) values ("AOV", "Aero Vision - France", "Aerovision", ""); insert into airline_icao (code, name, callsign, website) values ("AOW", "Air Andaman Corporation Limited - Thailand", "Air Andaman", ""); insert into airline_icao (code, name, callsign, website) values ("AOX", "Aerotaxi Del Valle - Colombia", "Aerovalle", ""); insert into airline_icao (code, name, callsign, website) values ("APA", "Air Park Aviation Ltd. - Canada", "Can-Am", ""); insert into airline_icao (code, name, callsign, website) values ("APB", "Aviopiva - Bosnia Hercegovina", "Aviopiva", ""); insert into airline_icao (code, name, callsign, website) values ("APC", "Airpac Airlines, Inc. - United States of America", "Airpac", ""); insert into airline_icao (code, name, callsign, website) values ("APD", "Sabre Pacific - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("APE", "Parcel Express - United States of America", "Air Parcel", ""); insert into airline_icao (code, name, callsign, website) values ("APF", "Amapola Flyg AB - Sweden", "Amapola", ""); insert into airline_icao (code, name, callsign, website) values ("APG", "Air People International Co. Ltd. - Thailand", "Air People", ""); insert into airline_icao (code, name, callsign, website) values ("APH", "Alpha Aviation, Inc. - United States of America", "Airflight", ""); insert into airline_icao (code, name, callsign, website) values ("API", "ASA Pesada, Lda. - Angola", "Asa Pesada", ""); insert into airline_icao (code, name, callsign, website) values ("APJ", "Air Print, S.A. - Luxembourg", "Air Print", ""); insert into airline_icao (code, name, callsign, website) values ("APK", "Asia Pacific Air Cargo Pte Ltd. - Singapore", "Apac", ""); insert into airline_icao (code, name, callsign, website) values ("APL", "Appalachian Flying Service, Inc. - United States of America", "Appalachian", ""); insert into airline_icao (code, name, callsign, website) values ("APM", "Airpac, Inc. - United States of America", "Alaska Pacific", ""); insert into airline_icao (code, name, callsign, website) values ("APN", "Air Polonia Ltd. - Poland", "Air Polonia", ""); insert into airline_icao (code, name, callsign, website) values ("APO", "Aeropro - Canada", "Aeropro", ""); insert into airline_icao (code, name, callsign, website) values ("APP", "Aerolineas Pacifico Atlantico, S.A. (Apair) - Panama", "Aeroperlas", ""); insert into airline_icao (code, name, callsign, website) values ("APR", "Air Polonia Cargo Ltd. - Poland", "AP Cargo", ""); insert into airline_icao (code, name, callsign, website) values ("APS", "Aerotransporte Peruanos Internacionales, S.A. - Peru", "Apisa", ""); insert into airline_icao (code, name, callsign, website) values ("APT", "LAP Colombia - Lineas Aereas Petroleras, S.A. - Colombia", "LAP", ""); insert into airline_icao (code, name, callsign, website) values ("APU", "Aeropuma, S.A. - El Salvador", "Aeropuma", ""); insert into airline_icao (code, name, callsign, website) values ("APV", "Air Plan International - Congo, The Democratic Republic of", "Air Plan", ""); insert into airline_icao (code, name, callsign, website) values ("APW", "Arrow Air, Inc. - United States of America", "Big A", ""); insert into airline_icao (code, name, callsign, website) values ("APX", "Apex Air Cargo - United States of America", "Parcel Express", ""); insert into airline_icao (code, name, callsign, website) values ("APY", "APA Internacional - Dominican Republic", "Apa Internacional", ""); insert into airline_icao (code, name, callsign, website) values ("APZ", "Hydro-Quebec - Canada", "Ampere", ""); insert into airline_icao (code, name, callsign, website) values ("AQA", "Aeroatlas, S.A. - Colombia", "Atco", ""); insert into airline_icao (code, name, callsign, website) values ("AQB", "Aqualata Air S.L. (Aqua Air) - Spain", "Aquair", ""); insert into airline_icao (code, name, callsign, website) values ("AQC", "Alquiladora de Casas, S.A. de C.V. - Mexico", "Alquiladora", ""); insert into airline_icao (code, name, callsign, website) values ("AQL", "Aquila Air Ltd. - Canada", "Aquila", ""); insert into airline_icao (code, name, callsign, website) values ("AQN", "Air Queensland - Australia", "Bushair", ""); insert into airline_icao (code, name, callsign, website) values ("AQO", "Aluminum Company Of America, Alcoa Aircraft Operations - United States of America", "Alcoa Shuttle", ""); insert into airline_icao (code, name, callsign, website) values ("AQT", "Aviones de Renta de Quintana Roo, S.A. de C.V. - Mexico", "Avioquintana", ""); insert into airline_icao (code, name, callsign, website) values ("AQU", "Airquarius Aviation - South Africa", "Quarius", ""); insert into airline_icao (code, name, callsign, website) values ("AQZ", "Aerodyne Charter Company - United States of America", "Quanza", ""); insert into airline_icao (code, name, callsign, website) values ("ARA", "Aerobeira, Sociedade de Transportes Aereos Lda - Portugal", "Aerobeira", ""); insert into airline_icao (code, name, callsign, website) values ("ARB", "Avia Air N.V. - Aruba", "Aviair", ""); insert into airline_icao (code, name, callsign, website) values ("ARC", "Air Routing International Corp. - United States of America", "", ""); insert into airline_icao (code, name, callsign, website) values ("ARD", "ATA Aerocondor Transportes Aéreos Lda. - Portugal", "Aerocondor", ""); insert into airline_icao (code, name, callsign, website) values ("ARE", "Aires, Aerovias de Integracion Regional, S.A. - Colombia", "Aires", ""); insert into airline_icao (code, name, callsign, website) values ("ARF", "Aero Flight GmbH & Co - Germany", "Aero Fox", ""); insert into airline_icao (code, name, callsign, website) values ("ARG", "Aerolineas Argentinas - Argentina", "Argentina", ""); insert into airline_icao (code, name, callsign, website) values ("ARH", "Arrowhead Airways - United States of America", "Arrowhead", ""); insert into airline_icao (code, name, callsign, website) values ("ARI", "Aero Vics, S.A. de C.V. - Mexico", "Aerovics", ""); insert into airline_icao (code, name, callsign, website) values ("ARJ", "Aerojet de Costa Rica, S.A. - Costa Rica", "", ""); insert into airline_icao (code, name, callsign, website) values ("ARK", "Aero Link Air Services S.L. - Spain", "Link Service", ""); insert into airline_icao (code, name, callsign, website) values ("ARL", "Airlec - Air Aquitaine Transport - France", "Airlec", ""); insert into airline_icao (code, name, callsign, website) values ("ARM", "Aeromarket Express - Spain", "Amex", ""); insert into airline_icao (code, name, callsign, website) values ("ARN", "Arnoro - Bosnia and Herzegovina", "Arnoro", ""); insert into airline_icao (code, name, callsign, website) values ("ARO", "Arrow Aviation Ltd. - Canada", "Arrow", ""); insert into airline_icao (code, name, callsign, website) values ("ARQ", "Armstrong Air, Inc. - Canada", "Armstrong", ""); insert into airline_icao (code, name, callsign, website) values ("ARR", "Air Armenia - Armenia", "Air Armenia", ""); insert into airline_icao (code, name, callsign, website) values ("ARS", "Aeronaves Hafe, S.A. de C.V. - Mexico", "Hafe", ""); insert into airline_icao (code, name, callsign, website) values ("ART", "Aerotal Aerolineas Territoriales de Colombia Ltda - Colombia", "Aerotal", ""); insert into airline_icao (code, name, callsign, website) values ("ARV", "Aravco Ltd. - United Kingdom", "Aravco", ""); insert into airline_icao (code, name, callsign, website) values ("ARW", "Aria - France", "Ariabird", ""); insert into airline_icao (code, name, callsign, website) values ("ARX", "Air Xpress, Inc. - United States of America", "Airex", ""); insert into airline_icao (code, name, callsign, website) values ("ARY", "Argosy Airways - United States of America", "Gosey", ""); insert into airline_icao (code, name, callsign, website) values ("ARZ", "Air Resorts - United States of America", "Air Resorts", ""); insert into airline_icao (code, name, callsign, website) values ("ASA", "Alaska Airlines, Inc. - United States of America", "Alaska", ""); insert into airline_icao (code, name, callsign, website) values ("ASB", "Air-Spray 1967 Ltd. - Canada", "Air Spray", ""); insert into airline_icao (code, name, callsign, website) values ("ASC", "Air Star Corporation - Canada", "Air Star", ""); insert into airline_icao (code, name, callsign, website) values ("ASD", "Air Sinai - Egypt", "Air Sinai", ""); insert into airline_icao (code, name, callsign, website) values ("ASE", "Airstars, Airways Company - Russian Federation", "Morozov", ""); insert into airline_icao (code, name, callsign, website) values ("ASF", "Air Schefferville, Inc. - Canada", "Scheff", ""); insert into airline_icao (code, name, callsign, website) values ("ASG", "African Star Airways (PTY) Ltd. - South Africa", "African Star", ""); insert into airline_icao (code, name, callsign, website) values ("ASH", "Mesa Airlines - United States of America", "Air Shuttle", "http://www.mesa-air.com"); insert into airline_icao (code, name, callsign, website) values ("ASI", "Aerosun International, Inc. - United States of America", "Aerosun", ""); insert into airline_icao (code, name, callsign, website) values ("ASJ", "Air Satellite, Inc. - Canada", "Satellite", ""); insert into airline_icao (code, name, callsign, website) values ("ASK", "La Ronge Aviation Services Ltd - Canada", "Air Sask", ""); insert into airline_icao (code, name, callsign, website) values ("ASL", "Spurling Aviation - United States of America", "Air Seattle", ""); insert into airline_icao (code, name, callsign, website) values ("ASM", "Awesome Flight Services (PTY) Ltd. - South Africa", "Awesome", ""); insert into airline_icao (code, name, callsign, website) values ("ASN", "Air and Sea Transport - Russian Federation", "", ""); insert into airline_icao (code, name, callsign, website) values ("ASO", "Aero Slovakia - Slovakia", "Aero Nitra", ""); insert into airline_icao (code, name, callsign, website) values ("ASP", "Empresa de Servicios Maritima Y Aerea, S.A. - Peru", "", ""); insert into airline_icao (code, name, callsign, website) values ("ASR", "All Star Airlines, Inc. - United States of America", "All Star", ""); insert into airline_icao (code, name, callsign, website) values ("ASS", "Air Class, S.A. de C.V. - Mexico", "Air Class", ""); insert into airline_icao (code, name, callsign, website) values ("AST", "Aerlineas Del Oeste - Mexico", "Aeroeste", ""); insert into airline_icao (code, name, callsign, website) values ("ASU", "Compania Boliviana de Transporte Aereo Privado Aerosur, S.A. - Bolivia", "Asur", ""); insert into airline_icao (code, name, callsign, website) values ("ASV", "Astravia-Bissau Air Transports Ltd. - Guinea Bissau", "Astravia", ""); insert into airline_icao (code, name, callsign, website) values ("ASW", "Air Southwest Ltd. - Canada", "Airsouthwest", ""); insert into airline_icao (code, name, callsign, website) values ("ASX", "Air Special - Czech Republic", "Airspec", ""); insert into airline_icao (code, name, callsign, website) values ("ASY", "Royal Australian Air Force - Australia", "Aussie", ""); insert into airline_icao (code, name, callsign, website) values ("ASZ", "Astrakhan Airlines - Russian Federation", "Air Astrakhan", ""); insert into airline_icao (code, name, callsign, website) values ("ATA", "Air Transport Association of America (ATA) - United States of America", "", "http://www.airlines.org"); insert into airline_icao (code, name, callsign, website) values ("ATB", "Atlantair Ltd. - Canada", "Starlite", ""); insert into airline_icao (code, name, callsign, website) values ("ATC", "Air Tanzania Company Ltd. - Tanzania, United Republic of", "Tanzania", ""); insert into airline_icao (code, name, callsign, website) values ("ATD", "Aerotours Dominicana, C. Por. A. - Dominican Republic", "Aerotours", ""); insert into airline_icao (code, name, callsign, website) values ("ATE", "Atlantis Transportation Services, Ltd. - Canada", "Atlantis Canada", ""); insert into airline_icao (code, name, callsign, website) values ("ATF", "Compania Aerotecnicas Fotograficas - Spain", "Aerotecnicas", ""); insert into airline_icao (code, name, callsign, website) values ("ATG", "Aerotrans Airline - Kazakhstan", "Bachyt", ""); insert into airline_icao (code, name, callsign, website) values ("ATH", "Air Travel Corp. - United States of America", "Air Travel", ""); insert into airline_icao (code, name, callsign, website) values ("ATI", "Aero-Tropics Air Services - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("ATJ", "Air Traffic GmbH - Germany", "Snoopy", ""); insert into airline_icao (code, name, callsign, website) values ("ATK", "Aerotaca Colombia - Aerotaxi Casanare Ltda. - Colombia", "Aerotaca", ""); insert into airline_icao (code, name, callsign, website) values ("ATL", "Aerocentral, S.A. de C.V. - Mexico", "Centralmex", ""); insert into airline_icao (code, name, callsign, website) values ("ATM", "Airlines Of Tasmania Pty Ltd. - Australia", "Airtas", ""); insert into airline_icao (code, name, callsign, website) values ("ATN", "Air Transport International LLC - United States of America", "Air Transport", ""); insert into airline_icao (code, name, callsign, website) values ("ATO", "Air Tonga - Tonga", "", ""); insert into airline_icao (code, name, callsign, website) values ("ATP", "ASTRAL Colombia - Aerotransportes Especiales Ltda. - Colombia", "Astral", ""); insert into airline_icao (code, name, callsign, website) values ("ATQ", "Air Transport Schiphol - Netherlands", "Multi", ""); insert into airline_icao (code, name, callsign, website) values ("ATR", "Atlas Airlines - United States of America", "Atlas-Air", ""); insert into airline_icao (code, name, callsign, website) values ("ATS", "Air Transport Service - Congo, The Democratic Republic of", "", ""); insert into airline_icao (code, name, callsign, website) values ("ATT", "Aer Turas Service - Ireland", "Aerturas", ""); insert into airline_icao (code, name, callsign, website) values ("ATU", "Atlant Aerobatics Ltd. - Hungary", "Atlant Hungary", ""); insert into airline_icao (code, name, callsign, website) values ("ATV", "Avanti Air - Germany", "Avanti Air", ""); insert into airline_icao (code, name, callsign, website) values ("ATW", "Aero Trades (Western) Ltd. - Canada", "Aero Trades", ""); insert into airline_icao (code, name, callsign, website) values ("ATX", "Warwickshire Aerocentre Ltd. - United Kingdom", "Airtax", ""); insert into airline_icao (code, name, callsign, website) values ("ATY", "International Airports Authority Of India - India", "", ""); insert into airline_icao (code, name, callsign, website) values ("ATZ", "Alarmond Limited - United Kingdom", "Astel", ""); insert into airline_icao (code, name, callsign, website) values ("AUA", "Austrian Airlines, Osterreichische Luftverkehrs AG d/b/a/ Austrian - Austria", "Austrian", "http://www.aua.com"); insert into airline_icao (code, name, callsign, website) values ("AUB", "Augsburg Airways GmbH - Germany", "Augsburg Air", ""); insert into airline_icao (code, name, callsign, website) values ("AUC", "Aero Marine Consulting Pty Ltd. d/b/a Transaustralian Air Express Pty. Ltd. - Australia", "Auscargo", ""); insert into airline_icao (code, name, callsign, website) values ("AUD", "Audi Air, Inc. - United States of America", "Audi Air", ""); insert into airline_icao (code, name, callsign, website) values ("AUF", "Augusta Air Luftfahrtunternehmen - Germany", "Augusta", ""); insert into airline_icao (code, name, callsign, website) values ("AUH", "Abu Dhabi Amiri Flight - United Arab Emirates", "Sultan", ""); insert into airline_icao (code, name, callsign, website) values ("AUI", "Ukraine International Airlines - Ukraine", "Ukraine International", ""); insert into airline_icao (code, name, callsign, website) values ("AUJ", "BFS Business Flight Salzburg - Austria", "Austrojet", ""); insert into airline_icao (code, name, callsign, website) values ("AUL", "Aeroflot - Nord - Russian Federation", "Archangelsk Air", ""); insert into airline_icao (code, name, callsign, website) values ("AUM", "Air Atlantic Uruguay, S.A. - Uruguay", "Atlamur", ""); insert into airline_icao (code, name, callsign, website) values ("AUN", "Aviones Unidos, S.A. de C.V. - Mexico", "Aviones Unidos", ""); insert into airline_icao (code, name, callsign, website) values ("AUO", "Empresa (Aero Uruguay), S.A. - Uruguay", "Uniform Oscar", ""); insert into airline_icao (code, name, callsign, website) values ("AUP", "Avia Business Group - Russian Federation", "", ""); insert into airline_icao (code, name, callsign, website) values ("AUR", "Aurigny Air Services - United Kingdom", "Ayline", ""); insert into airline_icao (code, name, callsign, website) values ("AUS", "Aus-Air - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("AUT", "Cielos del Sur S.A. d/b/a Austral Lineas Aereas S.A. - Argentina", "Austral", ""); insert into airline_icao (code, name, callsign, website) values ("AUU", "Aurora Aviation, Inc. - United States of America", "Aurora Air", ""); insert into airline_icao (code, name, callsign, website) values ("AUV", "Atruvera - Russian Federation", "Atruvera", ""); insert into airline_icao (code, name, callsign, website) values ("AUX", "Air Uganda International Ltd. - Uganda", "", ""); insert into airline_icao (code, name, callsign, website) values ("AUY", "Aerolineas Uruguayas, S.A. - Uruguay", "Ausa", ""); insert into airline_icao (code, name, callsign, website) values ("AVA", "Avianca - Aerovias Nacionales de Colombia, S.A. - Colombia", "Avianca", ""); insert into airline_icao (code, name, callsign, website) values ("AVB", "Aviation Beaufort Ltd. - United Kingdom", "Beaupair", ""); insert into airline_icao (code, name, callsign, website) values ("AVC", "Aeronautica Venezolana, C.A. (Aierovenca) - Venezuela", "Aerovenca", ""); insert into airline_icao (code, name, callsign, website) values ("AVD", "Alamo Aviacion, S.L. - Spain", "Alamo", ""); insert into airline_icao (code, name, callsign, website) values ("AVE", "Aerovias Venezolanas, S.A. (AVENSA) - Venezuela", "AlphaVictorEcho", ""); insert into airline_icao (code, name, callsign, website) values ("AVF", "Aviair Aviation Ltd. - Canada", "Cariboo", ""); insert into airline_icao (code, name, callsign, website) values ("AVG", "Air Falcon - Djibouti", "Djibouti Falcon", ""); insert into airline_icao (code, name, callsign, website) values ("AVH", "Aviser, S.A. - Spain", "Aviser", ""); insert into airline_icao (code, name, callsign, website) values ("AVI", "Aviorrenta, S.A. - Mexico", "Aviorrenta", ""); insert into airline_icao (code, name, callsign, website) values ("AVJ", "Avia Traffic Company - Kyrgyzstan", "Atomic", ""); insert into airline_icao (code, name, callsign, website) values ("AVK", "AV8 Helicopters - South Africa", "Aviate-Copter", ""); insert into airline_icao (code, name, callsign, website) values ("AVL", "Aerovias Las Americas, S.A. - Panama", "Las Americas", ""); insert into airline_icao (code, name, callsign, website) values ("AVM", "Aviacion Ejecutiva Mexicana, S.A. - Mexico", "Avemex", ""); insert into airline_icao (code, name, callsign, website) values ("AVN", "Air Vanuatu - Vanuatu", "Air Van", ""); insert into airline_icao (code, name, callsign, website) values ("AVP", "Avcorp Registrations Ltd. - United Kingdom", "Avcorp", ""); insert into airline_icao (code, name, callsign, website) values ("AVQ", "Aviation Services, Inc. - United States of America", "Aquiline", ""); insert into airline_icao (code, name, callsign, website) values ("AVR", "Active Aero Charter, Inc. - United States of America", "Active Aero", ""); insert into airline_icao (code, name, callsign, website) values ("AVS", "Avialsa T-35 - Spain", "Avialsa", ""); insert into airline_icao (code, name, callsign, website) values ("AVT", "Asia Avia Megatama - Indonesia", "Asiavia", ""); insert into airline_icao (code, name, callsign, website) values ("AVU", "Avia Sud Aérotaxi - France", "Aviasud", ""); insert into airline_icao (code, name, callsign, website) values ("AVV", "Airvantage Incorporated - United States of America", "Airvantage", ""); insert into airline_icao (code, name, callsign, website) values ("AVW", "Aviator, S.A. - Greece", "Aviator", ""); insert into airline_icao (code, name, callsign, website) values ("AVX", "Aviapaslauga - Lithuania", "Paslauga", ""); insert into airline_icao (code, name, callsign, website) values ("AVY", "Aerovaradero, S.A. - Cuba", "Aerovaradero", ""); insert into airline_icao (code, name, callsign, website) values ("AVZ", "Aeroservice - Kazakhstan", "Sabit", ""); insert into airline_icao (code, name, callsign, website) values ("AWA", "The Atlantic Airline (Gambia) Ltd. - The Gambia", "Gambia Atlantic", ""); insert into airline_icao (code, name, callsign, website) values ("AWB", "Airways International, Inc. - United States of America", "Airnat", ""); insert into airline_icao (code, name, callsign, website) values ("AWC", "Titan Airways - United Kingdom", "Zap", "http://www.titan-airways.com"); insert into airline_icao (code, name, callsign, website) values ("AWD", "Providence Aviation Services (Pvt) Limited - Pakistan", "", ""); insert into airline_icao (code, name, callsign, website) values ("AWE", "America West Airlines - United States of America", "Cactus", " http://www.americawest.com"); insert into airline_icao (code, name, callsign, website) values ("AWF", "Arab Air Cargo - Jordan", "Sinbad", ""); insert into airline_icao (code, name, callsign, website) values ("AWG", "Aerowings, Inc. - Antigua and Barbuda", "Skyribbean", ""); insert into airline_icao (code, name, callsign, website) values ("AWH", "Air Inter Niger - Niger", "Inter Niger", ""); insert into airline_icao (code, name, callsign, website) values ("AWI", "Air Wisconsin - United States of America", "Air Wisconsin", ""); insert into airline_icao (code, name, callsign, website) values ("AWJ", "Sahel Airlines - Niger", "Sahel Airlines", ""); insert into airline_icao (code, name, callsign, website) values ("AWK", "Airwork (New Zealand) Limited - New Zealand", "Airwork", "http:\\www.airwork.co.nz"); insert into airline_icao (code, name, callsign, website) values ("AWL", "Australian Wetleasing Operations Pty Ltd. (AWOPS) - Australia", "Aussieworld", ""); insert into airline_icao (code, name, callsign, website) values ("AWM", "Contact, Compagnie Nigerienne Des Transports Aerien - Niger", "Air Contact", ""); insert into airline_icao (code, name, callsign, website) values ("AWN", "Air Niamey, S.A. - Niger", "Air Niamey", ""); insert into airline_icao (code, name, callsign, website) values ("AWO", "Awood Air Ltd. - Canada", "Awood Air", ""); insert into airline_icao (code, name, callsign, website) values ("AWP", "Air Niger International - Niger", "Niger International", ""); insert into airline_icao (code, name, callsign, website) values ("AWQ", "Air Wagon Internation - Indonesia", "Wagon Air", ""); insert into airline_icao (code, name, callsign, website) values ("AWR", "Arctic Wings And Rotors Ltd. - Canada", "Arctic Wings", ""); insert into airline_icao (code, name, callsign, website) values ("AWS", "Arab Wings Company - Jordan", "Arab Wings", ""); insert into airline_icao (code, name, callsign, website) values ("AWT", "Air West - Canada", "Air West", ""); insert into airline_icao (code, name, callsign, website) values ("AWU", "Aeroline GmbH - Germany", "Sylt-Air", ""); insert into airline_icao (code, name, callsign, website) values ("AWV", "Airwave Transport, Inc. - Canada", "Airwave", ""); insert into airline_icao (code, name, callsign, website) values ("AWW", "Air Wales Limited - United Kingdom", "Red Dragon", "http://www.airwales.com"); insert into airline_icao (code, name, callsign, website) values ("AWX", "CAA Directorate of Airspace Policy (IFP) - United Kingdom", "Allweather", "http://www.caa.co.uk"); insert into airline_icao (code, name, callsign, website) values ("AWY", "Aeroway, S.L. - Spain", "Aerowee", ""); insert into airline_icao (code, name, callsign, website) values ("AWZ", "AirWest - Sudan", "", ""); insert into airline_icao (code, name, callsign, website) values ("AXA", "Kiev Aar Airlines - Ukraine", "Aar Airlines", ""); insert into airline_icao (code, name, callsign, website) values ("AXB", "Air India Express - India", "Express India", ""); insert into airline_icao (code, name, callsign, website) values ("AXC", "Air Exclusive - Croatia", "Air Exclusive", ""); insert into airline_icao (code, name, callsign, website) values ("AXD", "Air Express - Sudan", "Air Sudex", ""); insert into airline_icao (code, name, callsign, website) values ("AXE", "Executive Air - Zimbabwe", "Axair", ""); insert into airline_icao (code, name, callsign, website) values ("AXF", "Asian Express Airlines Pty Limited - Australia", "Freightexpress", ""); insert into airline_icao (code, name, callsign, website) values ("AXG", "Avirex Guinee Equatoriale - Equatorial Guinea", "Avirex", ""); insert into airline_icao (code, name, callsign, website) values ("AXH", "Aeromexhaga - Mexico", "Aeromexhaga", ""); insert into airline_icao (code, name, callsign, website) values ("AXI", "Aeron International Airlines, Inc. - United States of America", "Air Freighter", ""); insert into airline_icao (code, name, callsign, website) values ("AXK", "African Express Airways (K) Ltd. - Kenya", "Express Jet", ""); insert into airline_icao (code, name, callsign, website) values ("AXL", "Air Exel Netherlands B.V. - Netherlands", "Exel Commuter", ""); insert into airline_icao (code, name, callsign, website) values ("AXM", "Air Asia - Malaysia", "Asian Express", ""); insert into airline_icao (code, name, callsign, website) values ("AXN", "Alexandair - Greece", "Alexandros", ""); insert into airline_icao (code, name, callsign, website) values ("AXP", "Aeromax - Spain", "Aeromax Spain", ""); insert into airline_icao (code, name, callsign, website) values ("AXQ", "Action Airlines (Action Air Charter) - United States of America", "Action Air", ""); insert into airline_icao (code, name, callsign, website) values ("AXR", "Axel Rent, S.A. - Mexico", "Rentaxel", ""); insert into airline_icao (code, name, callsign, website) values ("AXS", "Altus Airlines - United States of America", "Altus", ""); insert into airline_icao (code, name, callsign, website) values ("AXT", "Aerotaxis Axa, S.L. - Spain", "Aeroaxa", ""); insert into airline_icao (code, name, callsign, website) values ("AXV", "Aviaxess - France", "Axavia", ""); insert into airline_icao (code, name, callsign, website) values ("AXX", "Avioimpex A.D.p.o. - Macedonia", "Impex", ""); insert into airline_icao (code, name, callsign, website) values ("AXY", "Axis Airways - France", "Axis", ""); insert into airline_icao (code, name, callsign, website) values ("AYA", "Federal Aviation Administration (FAA) Academy - United States of America", "Academy Air", ""); insert into airline_icao (code, name, callsign, website) values ("AYB", "Force Terrestre Belge - Belgium", "Belgian Army", ""); insert into airline_icao (code, name, callsign, website) values ("AYK", "Aykavia Aircompany - Armenia", "", ""); insert into airline_icao (code, name, callsign, website) values ("AYM", "Airman, S.L. - Spain", "Airman", ""); insert into airline_icao (code, name, callsign, website) values ("AYN", "Atlantic Airlines, S.A. - Nicaragua", "Atlantic Nicaragua", ""); insert into airline_icao (code, name, callsign, website) values ("AYR", "Flight Training Europe - Spain", "Cygnet", ""); insert into airline_icao (code, name, callsign, website) values ("AYT", "Ayeet Aviation & Tourism - Israel", "Ayeet", ""); insert into airline_icao (code, name, callsign, website) values ("AYU", "Yuhi Air Lines Co Ltd - Japan", "", ""); insert into airline_icao (code, name, callsign, website) values ("AYZ", "Atlant-Soyuz Airlines - Russian Federation", "Atlant-Soyuz", ""); insert into airline_icao (code, name, callsign, website) values ("AZA", "Alitalia - Linee Aeree Italiane - Italy", "Alitalia", "http://www.alitalia.com"); insert into airline_icao (code, name, callsign, website) values ("AZB", "Azamat - Kazakhstan", "Tumara", ""); insert into airline_icao (code, name, callsign, website) values ("AZD", "Aral Air - Kazakhstan", "Aral Air", ""); insert into airline_icao (code, name, callsign, website) values ("AZE", "Arcus-Air Logistic - Germany", "Arcus Air", "http://www.arcus-air.com/"); insert into airline_icao (code, name, callsign, website) values ("AZF", "Air Zermatt AG - Switzerland", "Air Zermatt", ""); insert into airline_icao (code, name, callsign, website) values ("AZG", "Sakaviaservice - Georgia", "Sakservice", ""); insert into airline_icao (code, name, callsign, website) values ("AZH", "Sky Wind - Azerbaijan", "Sky Wind", ""); insert into airline_icao (code, name, callsign, website) values ("AZI", "Azzurra Air - Italy (Defunct)", "Azzurra Air", ""); insert into airline_icao (code, name, callsign, website) values ("AZK", "Azalhelikopter - Azerbaijan", "Azalkopter", ""); insert into airline_icao (code, name, callsign, website) values ("AZL", "Africa One (Zambia) Ltd - Zambia", "Sky Africa", ""); insert into airline_icao (code, name, callsign, website) values ("AZM", "Aerocozumel, S.A. - Mexico", "Aerocozumel", ""); insert into airline_icao (code, name, callsign, website) values ("AZN", "Servicios Aereos Amazonicos - Peru", "Aero Amazonico", ""); insert into airline_icao (code, name, callsign, website) values ("AZP", "Arizona Pacific Airways - United States of America", "Arizona Pacific", ""); insert into airline_icao (code, name, callsign, website) values ("AZQ", "Silk Way Airlines - Azerbaijan", "Silk Line", ""); insert into airline_icao (code, name, callsign, website) values ("AZR", "Zenith Air - South Africa", "Zenair", ""); insert into airline_icao (code, name, callsign, website) values ("AZS", "Aviacon Zitotrans Air Company JSC - Russian Federation", "Zitotrans", ""); insert into airline_icao (code, name, callsign, website) values ("AZT", "Azimut, S.A. - Spain", "Azimut", ""); insert into airline_icao (code, name, callsign, website) values ("AZV", "Asov.Avia, Aircompany - Ukraine", "Azov Avia", ""); insert into airline_icao (code, name, callsign, website) values ("AZW", "Air Zimbabwe - Zimbabwe", "Air Zimbabwe", ""); insert into airline_icao (code, name, callsign, website) values ("AZY", "Arizona Airways, Inc. - United States of America", "Arizair", ""); insert into airline_icao (code, name, callsign, website) values ("AZZ", "Azza Transport Co. Ltd. - Sudan", "Azza Transport", ""); insert into airline_icao (code, name, callsign, website) values ("BAW", "British Airways - United Kingdom", "Speedbird", "http://www.ba.com"); insert into airline_icao (code, name, callsign, website) values ("BBC", "Biman Bangladesh - Bangladesh", "Bangladesh", "http://www.bimanair.com"); insert into airline_icao (code, name, callsign, website) values ("BBD", "Bluebird Cargo - Iceland", "Blue Cargo", ""); insert into airline_icao (code, name, callsign, website) values ("BBR", "Santa Barbara Airlines - Venezuela", "Santa Barbara", "http://www.santabarbaraairlines.com"); insert into airline_icao (code, name, callsign, website) values ("BCS", "European Air Transport - Belgium", "Eurotrans", ""); insert into airline_icao (code, name, callsign, website) values ("BCY", "Cityjet - Ireland", "City-Ireland", "http://www.cityjet.com"); insert into airline_icao (code, name, callsign, website) values ("BEE", "Flybe - United Kingdom", "Jersey", "http://www.flybe.com"); insert into airline_icao (code, name, callsign, website) values ("BFL", "Buffalo Airways - Canada", "Buffalo", "http://www.buffaloairways.com"); insert into airline_icao (code, name, callsign, website) values ("BLE", "Blue Line - France", "Blue Berry", ""); insert into airline_icao (code, name, callsign, website) values ("BLF", "Blue1 - Finland", "Bluefin", "http://www.blue1.com"); insert into airline_icao (code, name, callsign, website) values ("BMA", "bmi - United Kingdom", "Midland", "http://www.flybmi.com"); insert into airline_icao (code, name, callsign, website) values ("BMI", "bmibaby - United Kingdom", "Baby", "http://www.bmibaby.com"); insert into airline_icao (code, name, callsign, website) values ("BNF", "Braniff International Airways - United States of America defunct", "Braniff", ""); insert into airline_icao (code, name, callsign, website) values ("BRA", "Braathens (Norway) defunct (merged with Norway's portion of SAS to become SAS Braathens)", "Braathens", ""); insert into airline_icao (code, name, callsign, website) values ("BRD", "Brock Air Services - Canada", "Brock Air", "http://www.brockair.com"); insert into airline_icao (code, name, callsign, website) values ("BRU", "Belavia Belarusian Airlines - Belarus", "Belarus Avia", "http://www.belavia.by"); insert into airline_icao (code, name, callsign, website) values ("BSY", "Big Sky Airlines - United States", "Big Sky", "http://www.bigskyair.com"); insert into airline_icao (code, name, callsign, website) values ("BTA", "Continental Express (ExpressJet) - United States", "Jet Link", "http://www.continental.com"); insert into airline_icao (code, name, callsign, website) values ("BWA", "BWIA West Indies Airways - Trinidad and Tobago", "West Indian", "http://www.bwee.com"); insert into airline_icao (code, name, callsign, website) values ("BWG", "Blue Wings - Germany", "Blue Wings", "http://www.bluewing.info"); insert into airline_icao (code, name, callsign, website) values ("BZH", "Brit Air - France", "Britair", "http://www.britair.com"); insert into airline_icao (code, name, callsign, website) values ("CAL", "China Airlines - Taiwan/ROC", "Dynasty", "http://www.china-airlines.com"); insert into airline_icao (code, name, callsign, website) values ("CAV", "Calm Air - Canada", "", "http://www.calmair.com"); insert into airline_icao (code, name, callsign, website) values ("CAY", "Cayman Airways - Cayman Islands", "Cayman", ""); insert into airline_icao (code, name, callsign, website) values ("CBF", "China Northern Airlines", "", ""); insert into airline_icao (code, name, callsign, website) values ("CCA", "Air China - China/PRC", "Air China", "http://www.airchina.com"); insert into airline_icao (code, name, callsign, website) values ("CCD", "Cascade Airways - United States of America defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("CDN", "Canadian Airlines - Canada defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("CEA", "RegionsAir - United States of America (formerly Corporate Airlines)", "", ""); insert into airline_icao (code, name, callsign, website) values ("CEB", "Cebu Pacific Air - Philippines", "", ""); insert into airline_icao (code, name, callsign, website) values ("CES", "China Eastern Airlines - China", "China Eastern", ""); insert into airline_icao (code, name, callsign, website) values ("CFC", "Canadian Armed Forces - Canada", "", ""); insert into airline_icao (code, name, callsign, website) values ("CFG", "Condor Flugdienst - Germany", "Condor", ""); insert into airline_icao (code, name, callsign, website) values ("CHQ", "Chautauqua Airlines - United States of America", "Chautauqua", ""); insert into airline_icao (code, name, callsign, website) values ("CIM", "Cimber Air - Denmark", "", ""); insert into airline_icao (code, name, callsign, website) values ("CIP", "City Air - Germany defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("CJA", "CanJet - Canada", "CanJet", "http://www.canjet.com"); insert into airline_icao (code, name, callsign, website) values ("CJC", "Colgan Air - United States of America", "", ""); insert into airline_icao (code, name, callsign, website) values ("CKY", "Sky Airlines - Cyprus", "", ""); insert into airline_icao (code, name, callsign, website) values ("CLH", "Lufthansa CityLine - Germany", "", ""); insert into airline_icao (code, name, callsign, website) values ("CMI", "Continental Micronesia - Guam, United States of America", "Air Mike", "http://www.continental.com"); insert into airline_icao (code, name, callsign, website) values ("CMM", "Compagnie Aerienne du Mali - Mali", "Camali", "http://www.camaero.com"); insert into airline_icao (code, name, callsign, website) values ("CNO", "SAS Braathens - Norway", "Scanor", "http://www.sasbraathens.no"); insert into airline_icao (code, name, callsign, website) values ("CNW", "China Northwest Airlines - China", "", ""); insert into airline_icao (code, name, callsign, website) values ("CMP", "Copa Airlines - Panama", "Copa", "http://www.copaair.com"); insert into airline_icao (code, name, callsign, website) values ("COA", "Continental Airlines - United States of America", "Continental", "http://www.continental.com"); insert into airline_icao (code, name, callsign, website) values ("COM", "Comair - United States of America", "Comair", "www.comair.com"); insert into airline_icao (code, name, callsign, website) values ("CPA", "Cathay Pacific Airways Limited - Hong Kong, China", "Cathay", "http://www.cathaypacific.com"); insert into airline_icao (code, name, callsign, website) values ("CPC", "CP Air - Canada defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("CRQ", "Air Creebec - Canada", "", ""); insert into airline_icao (code, name, callsign, website) values ("CRX", "CrossAir - Switzerland defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("CSA", "Czech Airlines - Czech Republic", "CSA Lines", "http://www.czechairlines.com"); insert into airline_icao (code, name, callsign, website) values ("CSN", "China Southern Airlines - People's Republic of China", "China Southern", "http://www.cs-air.com"); insert into airline_icao (code, name, callsign, website) values ("CST", "Coast Air - Norway", "", ""); insert into airline_icao (code, name, callsign, website) values ("CSZ", "Shenzhen Airlines - China", "", ""); insert into airline_icao (code, name, callsign, website) values ("CTN", "Croatia Airlines - Croatia", "Croatia", ""); insert into airline_icao (code, name, callsign, website) values ("CUB", "Cubana de Aviacion SA - Cuba", "Cubana", ""); insert into airline_icao (code, name, callsign, website) values ("CXS", "Boston-Maine Airways (Pan Am Clipper Connection - United States of America (Pan Am III))", "Clipper Connection", ""); insert into airline_icao (code, name, callsign, website) values ("DAH", "Air Algerie - Algeria", "Air Algerie", ""); insert into airline_icao (code, name, callsign, website) values ("DAL", "Delta Air Lines - United States of America", "Delta", "http://www.delta.com"); insert into airline_icao (code, name, callsign, website) values ("DHL", "Astar Air Cargo, DHL - United States of America", "Dahl", ""); insert into airline_icao (code, name, callsign, website) values ("DLH", "Lufthansa - Germany", "Lufthansa", "http://www.lufthansa.com"); insert into airline_icao (code, name, callsign, website) values ("DTA", "TAAG - Angola", "Dta", ""); insert into airline_icao (code, name, callsign, website) values ("EAL", "European Air Express - Germany", "STAR WING", ""); insert into airline_icao (code, name, callsign, website) values ("EEZ", "Eurofly - Italy", "E-FLY", ""); insert into airline_icao (code, name, callsign, website) values ("EGF", "American Eagle Airlines - United States of America", "EAGLE FLIGHT", "http://www.aa.com"); insert into airline_icao (code, name, callsign, website) values ("EHR", "Valfell-Verkflug - Iceland", "ROTOR", ""); insert into airline_icao (code, name, callsign, website) values ("EIN", "Aer Lingus - Ireland", "SHAMROCK", "http://www.aerlingus.com"); insert into airline_icao (code, name, callsign, website) values ("ELY", "El Al Israel Airlines - Israel", "ELAL", "http://www.elal.co.il"); insert into airline_icao (code, name, callsign, website) values ("ETD", "Etihad Airways - United Arab Emirates", "ETIHAD", ""); insert into airline_icao (code, name, callsign, website) values ("EUJ", "EUjet - Ireland", "UNION JET", "http://www.eujet.com"); insert into airline_icao (code, name, callsign, website) values ("EVA", "EVA Air - Taiwan/ROC", "EVA", "http://www.evaair.com"); insert into airline_icao (code, name, callsign, website) values ("EXS", "Channel Express Air Services Ltd. (operates as Jet2.com)", "CHANNEX", ""); insert into airline_icao (code, name, callsign, website) values ("EXY", "South African Express Airways - South Africa", "EXPRESSWAYS", "http://www.saexpress.co.za/default.htm"); insert into airline_icao (code, name, callsign, website) values ("EZE", "Eastern Airways - United Kingdom", "EASTFLIGHT", "http://www.easternairways.com"); insert into airline_icao (code, name, callsign, website) values ("EZS", "easyJet - Switzerland", "TOPSWISS", "http://www.easyjet.ch"); insert into airline_icao (code, name, callsign, website) values ("EZY", "easyJet - United Kingdom", "EASY", "http://www.easyjet.com"); insert into airline_icao (code, name, callsign, website) values ("FCA", "First Choice Airways - United Kingdom", "Jetset", "http://www.firstchoiceairways.co.uk"); insert into airline_icao (code, name, callsign, website) values ("FDX", "Federal Express - United States of America", "Fedex", ""); insert into airline_icao (code, name, callsign, website) values ("FEI", "Eagle Air Iceland - Iceland", "Arctic Eagle", ""); insert into airline_icao (code, name, callsign, website) values ("FFT", "Frontier Airlines - United States of America", "Frontier Flight", "http://www.flyfrontier.com/"); insert into airline_icao (code, name, callsign, website) values ("FIF", "Air Finland - Finland", "Air Finland", ""); insert into airline_icao (code, name, callsign, website) values ("FIN", "Finnair - Finland", "Finnair", "http://www.finnair.com"); insert into airline_icao (code, name, callsign, website) values ("FJI", "Air Pacific - Fiji", "Pacific", ""); insert into airline_icao (code, name, callsign, website) values ("FLG", "Pinnacle Airlines - United States of America", "Flagship", "http://www.nwairlink.com"); insert into airline_icao (code, name, callsign, website) values ("FRL", "Freedom Airlines - United States of America", "Freedom Air", ""); insert into airline_icao (code, name, callsign, website) values ("FXI", "Flugfelag Islands, Iceland Air - Iceland", "Faxi", ""); insert into airline_icao (code, name, callsign, website) values ("GAO", "Golden Air - Sweden", "Golden", ""); insert into airline_icao (code, name, callsign, website) values ("GBL", "GB Airways - United Kingdom", "Geebee Airways", ""); insert into airline_icao (code, name, callsign, website) values ("GDA", "GoldAir - United Kingdom", "Goldair", ""); insert into airline_icao (code, name, callsign, website) values ("GEC", "Lufthansa Cargo - Germany", "Lufthansa Cargo", "http://www.lhcargo.com"); insert into airline_icao (code, name, callsign, website) values ("GFA", "Gulf Air - Bahrain/Oman/United Arab Emirates", "Gulf Air", ""); insert into airline_icao (code, name, callsign, website) values ("GFT", "Gulfstream International Airlines - United States of America", "Gulf Flight", ""); insert into airline_icao (code, name, callsign, website) values ("GHA", "Ghana Airways - Ghana", "Ghana", ""); insert into airline_icao (code, name, callsign, website) values ("GHB", "Ghana International Airlines - Ghana", "Ghana Airlines", ""); insert into airline_icao (code, name, callsign, website) values ("GIA", "Garuda Indonesia - Indonesia", "Indonesia", ""); insert into airline_icao (code, name, callsign, website) values ("GMA", "Gama Aviation - United Kingdom", "Gama", ""); insert into airline_icao (code, name, callsign, website) values ("GMI", "Germania - Germany", "Germania", ""); insert into airline_icao (code, name, callsign, website) values ("GOJ", "EuroJet Aviation - United Kingdom", "Gojet", ""); insert into airline_icao (code, name, callsign, website) values ("GRE", "Air Scotland - United Kingdom", "Greece Airways", "http://www.air-scotland.com"); insert into airline_icao (code, name, callsign, website) values ("GSM", "Flyglobespan - United Kingdom", "Globespan", ""); insert into airline_icao (code, name, callsign, website) values ("GWI", "Germanwings - Germany", "German Wings", ""); insert into airline_icao (code, name, callsign, website) values ("HAL", "Hawaiian Airlines - United States", "Hawaiian", "http://www.hawaiianair.com"); insert into airline_icao (code, name, callsign, website) values ("HAN", "Hansung Airlines - Republic of Korea", "Hansung Air", "http://www.hansungairlines.com/"); insert into airline_icao (code, name, callsign, website) values ("HDA", "Dragonair, Hong Kong Dragon Airlines - Hong Kong, China/PRC", "Dragon", "http://www.dragonair.com"); insert into airline_icao (code, name, callsign, website) values ("HLX", "Hapag-Lloyd Express - Germany", "Excellence", ""); insert into airline_icao (code, name, callsign, website) values ("HVN", "Vietnam Airlines - Vietnam", "Viet Nam Airlines", "http://www.vietnamairlines.com"); insert into airline_icao (code, name, callsign, website) values ("IAA", "Indonesian Airlines - Indonesia", "Indo Lines", "http://www.indonesian-airlines.co.id"); insert into airline_icao (code, name, callsign, website) values ("IAC", "Indian Airlines - India", "Indair", "http://indian-airlines.nic.in/"); insert into airline_icao (code, name, callsign, website) values ("IAW", "Iraqi Airways - Iraq", "Iraqi", ""); insert into airline_icao (code, name, callsign, website) values ("IBE", "Iberia Airlines of Spain - Spain", "Iberia", "http://www.iberia.com"); insert into airline_icao (code, name, callsign, website) values ("ICB", "Icebird Airline - Iceland", "Icebird", "http//www.islandsflug.is/"); insert into airline_icao (code, name, callsign, website) values ("ICE", "Icelandair - Iceland", "Iceair", "http://www.icelandair.net"); insert into airline_icao (code, name, callsign, website) values ("ICG", "Iclandic Coast Guard - Iceland", "Iceland Coast", "http://www.lhg.is/"); insert into airline_icao (code, name, callsign, website) values ("ICL", "CAL - Cargo Air Lines - Israel", "Cal", "http://www.cal.co.il/"); insert into airline_icao (code, name, callsign, website) values ("IDE", "Independence Air - United States of America Defunct", "Independence Air", "http://www.flyi.com"); insert into airline_icao (code, name, callsign, website) values ("IDP", "Independent Air Freighters - Australia", "Independent", ""); insert into airline_icao (code, name, callsign, website) values ("IHS", "Thryluthjonustan - Iceland", "", ""); insert into airline_icao (code, name, callsign, website) values ("IPA", "IPEC Aviation - Australia", "Ipec", ""); insert into airline_icao (code, name, callsign, website) values ("IRA", "Iran Air - Iran", "Iranair", "http://www.iranair.com/"); insert into airline_icao (code, name, callsign, website) values ("IRM", "Mahan Airlines - Iran", "Mahan Air", "http://www.mahan.aero/"); insert into airline_icao (code, name, callsign, website) values ("ISR", "Israir Airlines - Israel", "Israir", "http://www.israirairlines.com/"); insert into airline_icao (code, name, callsign, website) values ("IYE", "Yemenia-Yemen Airways - Yemen", "Yemeni", "http://www.yemenia.com/"); insert into airline_icao (code, name, callsign, website) values ("JAA", "Japan Asia Airways - Japan", "Asia", ""); insert into airline_icao (code, name, callsign, website) values ("JAL", "Japan Airlines International - Japan", "Japanair", "http://www.japanair.com"); insert into airline_icao (code, name, callsign, website) values ("JAT", "Jat Airways - Serbia and Montenegro", "Jat", ""); insert into airline_icao (code, name, callsign, website) values ("JAZ", "JALways - Japan", "Jalways", ""); insert into airline_icao (code, name, callsign, website) values ("JBU", "JetBlue Airways - United States of America", "JetBlue", "http://www.jetblue.com"); insert into airline_icao (code, name, callsign, website) values ("JGO", "JetsGo - Canada (defunct)", "Jetsgo", ""); insert into airline_icao (code, name, callsign, website) values ("JIA", "PSA Airlines (part of US Airways) - United States of America", "Blue Streak", "http://www.psaairlines.com"); insert into airline_icao (code, name, callsign, website) values ("JKK", "Spanair - Spain", "Spanair", "http://www.spanair.com"); insert into airline_icao (code, name, callsign, website) values ("JLJ", "Japan Airlines Domestic - Japan", "J-BIRD", "http://www.japanair.com"); insert into airline_icao (code, name, callsign, website) values ("JOR", "Blue Air - Romania", "Blue Transport", ""); insert into airline_icao (code, name, callsign, website) values ("JVK", "Jorvik - Iceland", "Islandia", ""); insert into airline_icao (code, name, callsign, website) values ("JXX", "Jetx Airlines - Iceland", "Jetbird", ""); insert into airline_icao (code, name, callsign, website) values ("JZA", "Air Canada Jazz - Canada", "Jazz", ""); insert into airline_icao (code, name, callsign, website) values ("KAC", "Kuwait Airways - Kuwait", "Kuwaiti", "http://www.kuwait-airways.com"); insert into airline_icao (code, name, callsign, website) values ("KAL", "Korean Air - Republic of Korea", "Koreanair", "http://www.koreanair.com"); insert into airline_icao (code, name, callsign, website) values ("KAP", "Cape Air - United States", "Cair", ""); insert into airline_icao (code, name, callsign, website) values ("KFB", "Blue1 - Finland", "Botnia", ""); insert into airline_icao (code, name, callsign, website) values ("KFR", "Kingfisher Airlines - India", "Kingfisher", "http://www.flykingfisher.com"); insert into airline_icao (code, name, callsign, website) values ("KIS", "Contactair - Germany", "Contactair", "http://www.contactair.de"); insert into airline_icao (code, name, callsign, website) values ("KLM", "KLM Royal Dutch Airlines - The Netherlands", "KLM", "http://www.klm.com"); insert into airline_icao (code, name, callsign, website) values ("KMG", "Kosmas Air - Serbia and Montenegro", "Kosmas Cargo", "http://www.kosmasair.co.yu"); insert into airline_icao (code, name, callsign, website) values ("KMR", "Kam Air - Afghanistan", "Kamgar", ""); insert into airline_icao (code, name, callsign, website) values ("KOR", "Air Koryo - North Korea", "Air Koryo", "http://www.korea-dpr.com/airkoryo.htm"); insert into airline_icao (code, name, callsign, website) values ("KQA", "Kenya Airways - Kenya", "Kenya", "http://www.kenya-airways.com"); insert into airline_icao (code, name, callsign, website) values ("KZW", "Khalifa Airways - Algeria defunct", "Khalifa Air", ""); insert into airline_icao (code, name, callsign, website) values ("LAA", "Libyan Arab Airlines - Libya", "Libair", ""); insert into airline_icao (code, name, callsign, website) values ("LAN", "LAN Airlines Argentina - Chile - Ecuador - Peru", "Lan", "http://www.lan.com"); insert into airline_icao (code, name, callsign, website) values ("LGL", "Luxair - Luxembourg", "Luxair", ""); insert into airline_icao (code, name, callsign, website) values ("LHT", "Lufthansa Technik - Germany", "Lufthansa Technik", ""); insert into airline_icao (code, name, callsign, website) values ("LIO", "Leiguflug Isleifs Ottesen - Iceland", "", ""); insert into airline_icao (code, name, callsign, website) values ("LIZ", "MyTravel Lite - United Kingdom", "", ""); insert into airline_icao (code, name, callsign, website) values ("LLB", "Lloyd Aereo Boliviano - Bolivia", "Lloyd Aero", ""); insert into airline_icao (code, name, callsign, website) values ("LOF", "Trans States Airlines - United States of America", "Waterski", ""); insert into airline_icao (code, name, callsign, website) values ("LOT", "LOT Polish Airlines - Poland", "Pollot", "http://www.lot.com"); insert into airline_icao (code, name, callsign, website) values ("LPE", "LAN Peru - Peru", "Lanperu", ""); insert into airline_icao (code, name, callsign, website) values ("LTE", "LTE International Airways - Spain", "Funjet", ""); insert into airline_icao (code, name, callsign, website) values ("LTU", "LTU International - Germany", "Ltu", ""); insert into airline_icao (code, name, callsign, website) values ("LVB", "IRS Airlines - Nigeria", "Silverbird", ""); insert into airline_icao (code, name, callsign, website) values ("LYC", "Lynden Air Cargo - United States of America", "Lynden", ""); insert into airline_icao (code, name, callsign, website) values ("LYD", "Lydd Air - United Kingdom", "Lyddair", ""); insert into airline_icao (code, name, callsign, website) values ("LYM", "Key Lime Air - United States", "Key Lime", ""); insert into airline_icao (code, name, callsign, website) values ("LYN", "Altyn Air - Krygyzstan", "Altyn Avia", ""); insert into airline_icao (code, name, callsign, website) values ("LYT", "Apatas - Lithuania", "Apatas", ""); insert into airline_icao (code, name, callsign, website) values ("LYX", "Lynx Aviation - Pakistan", "Lynx Air", ""); insert into airline_icao (code, name, callsign, website) values ("LZA", "Lanza Air - Spain", "Aerolanza", ""); insert into airline_icao (code, name, callsign, website) values ("LZB", "Bulgaria Air - Bulgaria", "Flying Bulgaria", ""); insert into airline_icao (code, name, callsign, website) values ("LZP", "Air Ban - Bulgaria", "Doc Air", ""); insert into airline_icao (code, name, callsign, website) values ("LZR", "Air Lazur - Bulgaria", "Lazur Bee-Gee", ""); insert into airline_icao (code, name, callsign, website) values ("LZT", "Lanzerote Aerocargo - Spain", "Baraka", ""); insert into airline_icao (code, name, callsign, website) values ("MAH", "Malév Hungarian Airlines - Hungary", "Malev", "http://www.malev.hu"); insert into airline_icao (code, name, callsign, website) values ("MAK", "Macedonian Airlines - Macedonia", "Makavio", ""); insert into airline_icao (code, name, callsign, website) values ("MAS", "Malaysia Airlines - Malaysia", "Malaysian", ""); insert into airline_icao (code, name, callsign, website) values ("MDI", "MD Airlines - Iceland", "Delta Ice", ""); insert into airline_icao (code, name, callsign, website) values ("MDL", "Mandala Airlines - Indonesia", "Mandala", ""); insert into airline_icao (code, name, callsign, website) values ("MES", "Mesaba Airlines - United States of America", "Mesaba", "http://www.mesaba.com"); insert into airline_icao (code, name, callsign, website) values ("MGM", "MGM Grand Air - United States of America defunct", "Grand Air", ""); insert into airline_icao (code, name, callsign, website) values ("MGX", "Montenegro Airlines - SCG", "Montair", ""); insert into airline_icao (code, name, callsign, website) values ("MKU", "Island Air - United States of America", "Moku", ""); insert into airline_icao (code, name, callsign, website) values ("MLA", "40-Mile Air - United States of America", "Mile-Air", ""); insert into airline_icao (code, name, callsign, website) values ("MON", "Monarch Airlines - United Kingdom", "Monarch", ""); insert into airline_icao (code, name, callsign, website) values ("MPE", "Air Norterra - Canada", "Empress", ""); insert into airline_icao (code, name, callsign, website) values ("MSR", "Egyptair - Egypt", "Egyptair", ""); insert into airline_icao (code, name, callsign, website) values ("MXA", "Mexicana - Mexico", "Mexicana", ""); insert into airline_icao (code, name, callsign, website) values ("MYT", "MyTravel Airways - United Kingdom", "Kestrel", ""); insert into airline_icao (code, name, callsign, website) values ("NAA", "National Oceanic and Atmospheric Administration - United States of America", "Noaa", ""); insert into airline_icao (code, name, callsign, website) values ("NAB", "Mina Airline Company - Egypt", "", ""); insert into airline_icao (code, name, callsign, website) values ("NAC", "Northern Air Cargo Inc - United States of America", "Yukon", ""); insert into airline_icao (code, name, callsign, website) values ("NAD", "Seulawah Nad Air - Indonesia", "Seulawah", ""); insert into airline_icao (code, name, callsign, website) values ("NAE", "Nations Air Express Inc - United States of America", "Nations Express", ""); insert into airline_icao (code, name, callsign, website) values ("NAF", "Royal Netherlands Air Force - Netherlands", "Netherlands Air Force", ""); insert into airline_icao (code, name, callsign, website) values ("NAH", "Nahanni Air Services Ltd - Canada", "Nahanni", ""); insert into airline_icao (code, name, callsign, website) values ("NAI", "North Adria Aviation - Croatia", "North-Adria", ""); insert into airline_icao (code, name, callsign, website) values ("NAJ", "North American Jet Charter Group LLC - United States of America", "Jet Group", ""); insert into airline_icao (code, name, callsign, website) values ("NAL", "Northway Aviation Ltd - Canada", "Northway", ""); insert into airline_icao (code, name, callsign, website) values ("NAM", "Nortland Air Manitoba - Canada", "Manitoba", ""); insert into airline_icao (code, name, callsign, website) values ("NAN", "National Airlines Inc - United States of America", "Nation Air", ""); insert into airline_icao (code, name, callsign, website) values ("NAO", "North American Airlines Inc - United States of America", "North American", ""); insert into airline_icao (code, name, callsign, website) values ("NAP", "Napier Air Service Inc - United States of America", "Napier", ""); insert into airline_icao (code, name, callsign, website) values ("NAR", "Air Continental Inc - United States of America", "Night Air", ""); insert into airline_icao (code, name, callsign, website) values ("NAT", "North Atlantic Air Inc - United States of America", "Mass Air", ""); insert into airline_icao (code, name, callsign, website) values ("NAU", "Antanik-Air - Ukraine", "Antanik", ""); insert into airline_icao (code, name, callsign, website) values ("NAV", "Nav Flight Planning - Czech Republic", "Nav Dispatch", ""); insert into airline_icao (code, name, callsign, website) values ("NAW", "Newair - Denmark", "Newdan", ""); insert into airline_icao (code, name, callsign, website) values ("NAX", "Norwegian Air Shuttle - Norway", "Nor Shuttle", ""); insert into airline_icao (code, name, callsign, website) values ("NAY", "Navegacion Servicios Aereos Canarios SA - Spain", "Naysa", ""); insert into airline_icao (code, name, callsign, website) values ("NAZ", "Servicios Aereos del Nazas SA de CV - Mexico", "Nazas", ""); insert into airline_icao (code, name, callsign, website) values ("NBA", "North East Bolivian Airways - Bolivia", "Neba", ""); insert into airline_icao (code, name, callsign, website) values ("NBE", "Novosibirsk Aviaenterprise - Russian Federation", "Nakair", ""); insert into airline_icao (code, name, callsign, website) values ("NBK", "Albarka Air PLC - Nigeria", "Al-Air", ""); insert into airline_icao (code, name, callsign, website) values ("NBL", "Nobil Air - Republic Moldova", "Nobil Air", ""); insert into airline_icao (code, name, callsign, website) values ("NBN", "North British Airlines Ltd - United Kingdom", "Teesair", ""); insert into airline_icao (code, name, callsign, website) values ("NBS", "Nimbus Aviation - United Kingdom", "Nimbus", ""); insert into airline_icao (code, name, callsign, website) values ("NCA", "Nippon Cargo Airlines - Japan", "Nippon Cargo", ""); insert into airline_icao (code, name, callsign, website) values ("NCB", "North Caribou Flying Service Ltd - Canada", "North Caribout", ""); insert into airline_icao (code, name, callsign, website) values ("NCC", "North Coast Air Services Ltd - Canada", "North Coast", ""); insert into airline_icao (code, name, callsign, website) values ("NCE", "Northcoast Executive Airlines - United States of America", "Top Hat", ""); insert into airline_icao (code, name, callsign, website) values ("NCF", "Norfolk County Flight College Ltd - United Kingdom", "County", ""); insert into airline_icao (code, name, callsign, website) values ("NCG", "Nederlandse Kustwacht - Netherlands", "Netherlands Coastguard", ""); insert into airline_icao (code, name, callsign, website) values ("NCH", "Chanchangi Airlines (Nigeria) Limited - Nigeria", "Chanchangi", ""); insert into airline_icao (code, name, callsign, website) values ("NCL", "ACA-Ancargo Air Sociedade de Transporte de Carga Lda - Angola", "Ancargo Air", ""); insert into airline_icao (code, name, callsign, website) values ("NCM", "NAS Air SA - Angola", "Air Bane", ""); insert into airline_icao (code, name, callsign, website) values ("NCO", "Natalco Air Lines - Sao Tome Principe", "Natalco", ""); insert into airline_icao (code, name, callsign, website) values ("NCP", "Capital Airlines Limited - Nigeria", "Capital Shuttle", ""); insert into airline_icao (code, name, callsign, website) values ("NCS", "Simpson Air Ltd - Canada", "Commuter-Canada", ""); insert into airline_icao (code, name, callsign, website) values ("NCT", "Nacional Transportes Aereos Ltda - NATA - Brazil", "Nata Transportes", ""); insert into airline_icao (code, name, callsign, website) values ("NEA", "New England Airlines - United States of America", "New England", "http://www.block-island.com/nea/"); insert into airline_icao (code, name, callsign, website) values ("NGA", "Nigeria Airways - Nigeria defunct", "Nigeria", ""); insert into airline_icao (code, name, callsign, website) values ("NKS", "Spirit Airlines - United States of America", "Spirit Wings", "htpp://www.spiritair.com"); insert into airline_icao (code, name, callsign, website) values ("NWA", "Northwest Airlines - United States of America", "Northwest", "http://www.nwa.com"); insert into airline_icao (code, name, callsign, website) values ("NXA", "Nationair Canada - Canada defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("OAA", "Oxley Aviation - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("OAC", "Oriental Airlines - Nigeria", "Oriental Air", ""); insert into airline_icao (code, name, callsign, website) values ("OAD", "Orscom TOurist Installation Company - Egypt", "Orscom", ""); insert into airline_icao (code, name, callsign, website) values ("OAE", "Omni Air Express - United States", "Omni-Express", ""); insert into airline_icao (code, name, callsign, website) values ("OAL", "Olympic Airlines - Greece", "Olympic", ""); insert into airline_icao (code, name, callsign, website) values ("OAO", "Arkhangelsk 2 Aviation Division - Russian Federation", "Dvina", ""); insert into airline_icao (code, name, callsign, website) values ("OAP", "COAPA AIR - Mexico", "Coapa", ""); insert into airline_icao (code, name, callsign, website) values ("OAV", "Omni - Aviacao e Tecnologia - Portugal", "Omni", ""); insert into airline_icao (code, name, callsign, website) values ("OAW", "Helvetic Airways - Switzerland", "Helvetic", ""); insert into airline_icao (code, name, callsign, website) values ("OAX", "Operational Aviation Services - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("OBA", "Aerobanana - Mexico", "Aerobanana", ""); insert into airline_icao (code, name, callsign, website) values ("OBK", "Amako Airlines - Nigeria", "Amako Air", ""); insert into airline_icao (code, name, callsign, website) values ("OCA", "Aeroservicios Caraboba (ASERCA - Venezuela", "Arosca", ""); insert into airline_icao (code, name, callsign, website) values ("OCC", "Occidental Airlines - Liberia", "", ""); insert into airline_icao (code, name, callsign, website) values ("OCE", "Heliocean - France", "Heliocean", ""); insert into airline_icao (code, name, callsign, website) values ("OCF", "Ocean Airlines - France", "Explorer", ""); insert into airline_icao (code, name, callsign, website) values ("OCM", "O'Connor Airlines - Australia", "Oconner", ""); insert into airline_icao (code, name, callsign, website) values ("OCN", "O Air - France", "O-Bird", ""); insert into airline_icao (code, name, callsign, website) values ("OCO", "Ostend Air College - Belgium", "Air College", ""); insert into airline_icao (code, name, callsign, website) values ("OCR", "Oceanic Air - Maldives", "Oceanic Air", ""); insert into airline_icao (code, name, callsign, website) values ("OCT", "Occidental Airlines (Liberia) - Liberia", "Occidental", ""); insert into airline_icao (code, name, callsign, website) values ("ODI", "Jonsson, H Air Taxi - Iceland", "Odinn", ""); insert into airline_icao (code, name, callsign, website) values ("ODS", "Odessa Airlines - Ukraine", "Odessa", ""); insert into airline_icao (code, name, callsign, website) values ("ODY", "Odyssey International - Canada", "Odyssey", ""); insert into airline_icao (code, name, callsign, website) values ("OEA", "Orient Thai Airlines - Thailand", "Orient Air", ""); insert into airline_icao (code, name, callsign, website) values ("OEC", "Christophurus Flugrettungsverein - Austria", "Christophorus", ""); insert into airline_icao (code, name, callsign, website) values ("OED", "Orion Air Charter", "Orion Charter", ""); insert into airline_icao (code, name, callsign, website) values ("OFA", "Helitaxi Ofavi - Mexico", "Ofavi", ""); insert into airline_icao (code, name, callsign, website) values ("OFF", "Challenge International Airlines - United States", "Challenge Air", ""); insert into airline_icao (code, name, callsign, website) values ("OGE", "Atlas International - Turkey", "Atlasjet", ""); insert into airline_icao (code, name, callsign, website) values ("OGI", "Aerogisa - Mexico", "Aerogisa", ""); insert into airline_icao (code, name, callsign, website) values ("OGJ", "Bakoji Airlines Services - Nigeria", "Bako Air", ""); insert into airline_icao (code, name, callsign, website) values ("OGN", "Origin Pacific Airways - New Zealand", "Origin", ""); insert into airline_icao (code, name, callsign, website) values ("OHY", "Onur Air - Turkey", "Onur Air", ""); insert into airline_icao (code, name, callsign, website) values ("OIC", "Iwamoto Crane Co Ltd - Japan", "", ""); insert into airline_icao (code, name, callsign, website) values ("OJF", "Occitania Jet Fleet - France", "Occitania", ""); insert into airline_icao (code, name, callsign, website) values ("OJY", "Florida Air - United States", "Ohjay", ""); insert into airline_icao (code, name, callsign, website) values ("OKA", "Okay Airways Company - China", "Okayjet", ""); insert into airline_icao (code, name, callsign, website) values ("OKJ", "Okada Airlines - Nigeria", "Okada Air", ""); insert into airline_icao (code, name, callsign, website) values ("OKL", "Oklahoma Department of Public Safety Troop O - United States", "Oklahoma", ""); insert into airline_icao (code, name, callsign, website) values ("OKP", "Okapi Airways - Democratic Republic of Congo", "Okapi", ""); insert into airline_icao (code, name, callsign, website) values ("OKS", "Slok Air International (Gambia) - Gambia", "Slok Gambia", ""); insert into airline_icao (code, name, callsign, website) values ("OKT", "Soko Aviation - Spain", "Soko Air", ""); insert into airline_icao (code, name, callsign, website) values ("OLA", "Overland Airways - Nigeria", "Overland", ""); insert into airline_icao (code, name, callsign, website) values ("OLC", "Solar Cargo - Venezuela", "Solarcargo", ""); insert into airline_icao (code, name, callsign, website) values ("OLE", "Operadora de Lineas Ejecutivas - Mexico", "Operadora", ""); insert into airline_icao (code, name, callsign, website) values ("OLO", "Soloflight - United Kingdom", "Solo", ""); insert into airline_icao (code, name, callsign, website) values ("OLR", "Colaereos - Ecuador", "Colaereos", ""); insert into airline_icao (code, name, callsign, website) values ("OLT", "Ostfriesische Lufttransport - Germany", "Oltra", ""); insert into airline_icao (code, name, callsign, website) values ("OLV", "Aerolineas Olve - Mexico", "Olve", ""); insert into airline_icao (code, name, callsign, website) values ("OLX", "Olimex - Czech Republic", "Olimex", ""); insert into airline_icao (code, name, callsign, website) values ("OLY", "Olympic Aviation - Greece", "Olavia", ""); insert into airline_icao (code, name, callsign, website) values ("OMA", "Oman Air - Oman", "Khanijar", ""); insert into airline_icao (code, name, callsign, website) values ("OME", "Omega Air - Honduras", "", ""); insert into airline_icao (code, name, callsign, website) values ("OMF", "Omniflys - Mexico", "Omniflys", ""); insert into airline_icao (code, name, callsign, website) values ("OMG", "Aeromega - United Kingdom", "Omega", ""); insert into airline_icao (code, name, callsign, website) values ("OML", "Organizacoes Mambra - Angola", "Mambra", ""); insert into airline_icao (code, name, callsign, website) values ("OMR", "Minair - Central African Republic", "Ormine", ""); insert into airline_icao (code, name, callsign, website) values ("OMS", "Omskavia Airline - Russian Federation", "Omsk", ""); insert into airline_icao (code, name, callsign, website) values ("ONE", "Ocenair - Linhas Aereas - Brazil", "Oceanair", ""); insert into airline_icao (code, name, callsign, website) values ("ONG", "Sonnig SA - Switzerland", "Sonnig", ""); insert into airline_icao (code, name, callsign, website) values ("ONM", "Presidencia de La Republica de Guinea Ecuatorial - Equatorial Guinea", "", ""); insert into airline_icao (code, name, callsign, website) values ("ONT", "Air Ontario - Canada", "Ontario", ""); insert into airline_icao (code, name, callsign, website) values ("OOM", "Zoom Airlines - Canada", "Zoom", ""); insert into airline_icao (code, name, callsign, website) values ("OOT", "Out Of The Blue Air Safaris - South Africa", "Ootbas", ""); insert into airline_icao (code, name, callsign, website) values ("OPA", "Opal Air - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("OPC", "Krystel Air Charter - United Kingdom", "Optic", ""); insert into airline_icao (code, name, callsign, website) values ("OPS", "Jet-Ops - United Arab Emirates", "Ops-Jet", ""); insert into airline_icao (code, name, callsign, website) values ("OPT", "Flight Options - United States", "Options", ""); insert into airline_icao (code, name, callsign, website) values ("OPV", "Operadora de Veulos Ejectutivos - Mexico", "Operadora De Vuelos", ""); insert into airline_icao (code, name, callsign, website) values ("ORA", "Montauk Caribbean Airways trading as Long Island Airlines - United States", "Long Island", ""); insert into airline_icao (code, name, callsign, website) values ("ORB", "State Orenburg Avia Enterprise - Russian Federation", "Orenburg", ""); insert into airline_icao (code, name, callsign, website) values ("ORC", "Air Cordial - United Kingdom", "Cordial", ""); insert into airline_icao (code, name, callsign, website) values ("ORE", "Orange Aviation - Israel", "Orange Aviation", ""); insert into airline_icao (code, name, callsign, website) values ("ORF", "Oman Royal Flight - Oman", "Oman", ""); insert into airline_icao (code, name, callsign, website) values ("ORG", "Oriental Airlines (Gambia) - Gambia", "Oriegam", ""); insert into airline_icao (code, name, callsign, website) values ("ORI", "Orion Air - Seychelles", "Orion Air", ""); insert into airline_icao (code, name, callsign, website) values ("ORK", "Orange Air Sierra Leone - Sierra Leone", "Orca Taxi", ""); insert into airline_icao (code, name, callsign, website) values ("ORL", "On Air Limited - Canada", "On Air", ""); insert into airline_icao (code, name, callsign, website) values ("ORM", "Orel State Air Enterprise - Russian Federation", "Orprise", ""); insert into airline_icao (code, name, callsign, website) values ("ORN", "Orient Airways - Pakistan", "Orient Liner", ""); insert into airline_icao (code, name, callsign, website) values ("ORO", "C N Air - Spain", "Capri", ""); insert into airline_icao (code, name, callsign, website) values ("ORP", "Aerocorp - Mexico", "Corpsa", ""); insert into airline_icao (code, name, callsign, website) values ("ORR", "Operadora Turistica Aurora - Mexico", "Turistica Aurora", ""); insert into airline_icao (code, name, callsign, website) values ("ORS", "Action Air - Italy", "Aviation Service", ""); insert into airline_icao (code, name, callsign, website) values ("ORT", "Air Orient - France", "Air Orient", ""); insert into airline_icao (code, name, callsign, website) values ("ORX", "Orbit Ekspres Hava Yollari - Turkey", "Orex", ""); insert into airline_icao (code, name, callsign, website) values ("ORZ", "Zorex - Spain", "Zorex", ""); insert into airline_icao (code, name, callsign, website) values ("OSA", "Aero Astra - Mexico", "Rostra", ""); insert into airline_icao (code, name, callsign, website) values ("OSH", "Osh Avia - Kyrgyzstan", "Osh Avia", ""); insert into airline_icao (code, name, callsign, website) values ("OSL", "Sosoliso Limited - Nigeria", "Sosoliso", ""); insert into airline_icao (code, name, callsign, website) values ("OSN", "Aerosan - Mexico", "Aerosan", ""); insert into airline_icao (code, name, callsign, website) values ("OSO", "Aviapartner Limited Company - Russian Federation", "", ""); insert into airline_icao (code, name, callsign, website) values ("OSS", "Servicios Aereos Noticiosos - Mexico", "Noticiosos", ""); insert into airline_icao (code, name, callsign, website) values ("OST", "Airline Alania - Russian Federation", "Alania", ""); insert into airline_icao (code, name, callsign, website) values ("OSW", "JetAfrica Swaziland - Swaziland", "Bevo", ""); insert into airline_icao (code, name, callsign, website) values ("OSY", "Open Skies Consultative Commission - United States", "Open Skies", ""); insert into airline_icao (code, name, callsign, website) values ("OTA", "Organizacion De Transportes Aereos - Mexico", "Organizacion", ""); insert into airline_icao (code, name, callsign, website) values ("OTL", "South Airlines - Ukraine", "Southline", ""); insert into airline_icao (code, name, callsign, website) values ("OTM", "Onetime Airlines Zambia - Zambia", "Zedtime", ""); insert into airline_icao (code, name, callsign, website) values ("OTN", "LASTP - Sao Tome and Principe", "Lastp", ""); insert into airline_icao (code, name, callsign, website) values ("OTP", "Operadora de Transportes Aereos - Mexico", "Operadora Aereo", ""); insert into airline_icao (code, name, callsign, website) values ("OTR", "Orient Airlines - Sudan", "Orientroc", ""); insert into airline_icao (code, name, callsign, website) values ("OUA", "Transport Aerien Ouest Africain - Senegal", "Ouest Africain", ""); insert into airline_icao (code, name, callsign, website) values ("OUL", "Air Atonabee - Canada", "City Express", ""); insert into airline_icao (code, name, callsign, website) values ("OVA", "Aero Nova - Spain", "Aeronova", ""); insert into airline_icao (code, name, callsign, website) values ("OVC", "Aerovic - Ecuador", "", ""); insert into airline_icao (code, name, callsign, website) values ("OVE", "Aeromover - Mexico", "Aeromover", ""); insert into airline_icao (code, name, callsign, website) values ("OVI", "Aerovias Ejecutivas - Mexico", "Vias Ejecutivas", ""); insert into airline_icao (code, name, callsign, website) values ("OWL", "Miami Valley Aviation - United States", "Night Owl", ""); insert into airline_icao (code, name, callsign, website) values ("OWN", "Owens Group - New Zealand", "Owensair", ""); insert into airline_icao (code, name, callsign, website) values ("OXE", "Gregg Air - United Kingdom", "Oxoe", ""); insert into airline_icao (code, name, callsign, website) values ("OXO", "Million Air - United States", "Mill Air", ""); insert into airline_icao (code, name, callsign, website) values ("OYE", "Koda International - Nigeria", "Koda Air", ""); insert into airline_icao (code, name, callsign, website) values ("OZG", "Zori Air Cargo - Bulgaria", "Zori Cargo", ""); insert into airline_icao (code, name, callsign, website) values ("OZJ", "Ozjet Airlines - Australia", "Ausjet", ""); insert into airline_icao (code, name, callsign, website) values ("OZR", "Ozark Air Lines - United States", "Ozark", ""); insert into airline_icao (code, name, callsign, website) values ("OZU", "Hozu-Avia - Kazakhstan", "Hozavia", ""); insert into airline_icao (code, name, callsign, website) values ("OZW", "Skywest Airlines - Australia", "Ozwest", "Skywest"); insert into airline_icao (code, name, callsign, website) values ("PAA", "Pan American Airways - United States", "CLIPPER", "http://www.flypanam.com/"); insert into airline_icao (code, name, callsign, website) values ("PAC", "Polar Air Cargo - United States", "POLAR", "http://www.polaraircargo.com/"); insert into airline_icao (code, name, callsign, website) values ("PAL", "Philippine Airlines - Philippines", "PHILIPPINE", "http://www.philippineairlines.com/"); insert into airline_icao (code, name, callsign, website) values ("PAO", "Polynesian Airlines - Samoa", "POLYNESIAN", "http://www.polynesianairlines.com/"); insert into airline_icao (code, name, callsign, website) values ("PBA", "PB Air - Thailand", "PEEBEE AIR", "http://www.pbair.com/"); insert into airline_icao (code, name, callsign, website) values ("PDT", "Piedmont Airlines - United States", "PIEDMONT", "http://www.piedmont-airlines.com/"); insert into airline_icao (code, name, callsign, website) values ("PGT", "Pegasus Airlines - Turkey", "SUNTURK", "http://www.flypgs.com/"); insert into airline_icao (code, name, callsign, website) values ("PIA", "Pakistan International Airlines - Pakistan", "PAKISTAN", "http://www.piac.com.pk"); insert into airline_icao (code, name, callsign, website) values ("PXA", "Pan Am - United States defunct", "", ""); insert into airline_icao (code, name, callsign, website) values ("QAC", "Qatar Air Cargo - Qatar", "QATAR CARGO", ""); insert into airline_icao (code, name, callsign, website) values ("QAF", "Qatar Amiri Flight - Qatar", "AMIRI", ""); insert into airline_icao (code, name, callsign, website) values ("QAH", "Quick Airways Holland - Netherland", "QUICK", "http://www.quickairways.nl/"); insert into airline_icao (code, name, callsign, website) values ("QAJ", "Quick Air Jet Charter - Germany", "DAGOBERT", ""); insert into airline_icao (code, name, callsign, website) values ("QAS", "Quisqueya Airlines - Haiti", "QUISQUEYA", ""); insert into airline_icao (code, name, callsign, website) values ("QAT", "Aero Taxi - Canada", "AIR QUASAR", ""); insert into airline_icao (code, name, callsign, website) values ("QCA", "Aerospace Consortium Limited - Kenya", "AERO KENYA", "http://www.aerokenya.net/"); insert into airline_icao (code, name, callsign, website) values ("QCC", "Qwest Commuter Corporation - United States", "QWEST AIR", ""); insert into airline_icao (code, name, callsign, website) values ("QCL", "Air Class Lineas Aereas - Uruguay", "ACLA", ""); insert into airline_icao (code, name, callsign, website) values ("QEA", "Aviation Consultancy Office - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("QFA", "Qantas Airways - Australia", "QANTAS", "http://www.qantas.com.au"); insert into airline_icao (code, name, callsign, website) values ("QGA", "Windrose Air - Germany", "QUADRIGA", "http://www.windroseair.de/"); insert into airline_icao (code, name, callsign, website) values ("QID", "USAF 100th Air Refuelling Wing - United States", "QUID", ""); insert into airline_icao (code, name, callsign, website) values ("QJA", "Quickjet Aviation - Namibia", "QUICKJET", ""); insert into airline_icao (code, name, callsign, website) values ("QKC", "Aero Taxi Aviation - United States", "QUAKER CITY", ""); insert into airline_icao (code, name, callsign, website) values ("QLA", "Aviation Quebec Labrador - Canada", "QUEBEC LABRADOR", ""); insert into airline_icao (code, name, callsign, website) values ("QNA", "Queen Air - Dominican Republic", "QUEEN AIR", ""); insert into airline_icao (code, name, callsign, website) values ("QNK", "Kabo Air - Nigeria", "KABO", ""); insert into airline_icao (code, name, callsign, website) values ("QNT", "Qanot Sharq - Uzbekistan", "QANAT SHARQ", ""); insert into airline_icao (code, name, callsign, website) values ("QNZ", "JetConnect - New Zealand", "QANTAS JETCONNECT", "http://www.qantas.com.au"); insert into airline_icao (code, name, callsign, website) values ("QRS", "Yaroslav Aircompany - Ukraine", "YAROSLAV", ""); insert into airline_icao (code, name, callsign, website) values ("QRT", "4D Air - Thailand", "QUARTET", ""); insert into airline_icao (code, name, callsign, website) values ("QSC", "African Safari Airways - Kenya", "ZEBRA", "http://www.africansafariclub.com/html/flights.php"); insert into airline_icao (code, name, callsign, website) values ("QTR", "Qatar Airways - Qatar", "QATARI", "http://www.qatarairways.com/"); insert into airline_icao (code, name, callsign, website) values ("QTX", "Quantex Environmental - Canada", "AIR QUANTEX", ""); insert into airline_icao (code, name, callsign, website) values ("QUE", "Quebec Government Air Service - Canada", "QUEBEC", ""); insert into airline_icao (code, name, callsign, website) values ("QUI", "Aero Quimmco - Mexico", "QUIMMCO", ""); insert into airline_icao (code, name, callsign, website) values ("QWE", "Qwestair - Australia", "", ""); insert into airline_icao (code, name, callsign, website) values ("QWL", "Qwila Air - South Africa", "Q-CHARTER", "http://www.qwila-air.co.za/"); insert into airline_icao (code, name, callsign, website) values ("QXE", "Horizon Air - USA", "HORIZON AIR", "http://www.horizonair.com/"); insert into airline_icao (code, name, callsign, website) values ("RAM", "Royal Air Maroc - Morocco)", "Royalair Maroc", ""); insert into airline_icao (code, name, callsign, website) values ("REA", "Aer Arann - Ireland", "Aer Arann", "http://www.aerarann.com"); insert into airline_icao (code, name, callsign, website) values ("RJA", "Royal Jordanian Airlines - Jordan", "Jordanian", "http://www.rja.com.jo"); insert into airline_icao (code, name, callsign, website) values ("RNX", "1Time Airline - South Africa", "Nextime", ""); insert into airline_icao (code, name, callsign, website) values ("ROA", "SNAS Aviation - Croatia", "", ""); insert into airline_icao (code, name, callsign, website) values ("ROT",