text: CREATE TABLE airport (
  name VARCHAR(256),
  location VARCHAR(256),
  designator VARCHAR(10) PRIMARY KEY
  );
  
  INSERT INTO airport VALUES('108 Mile Ranch', '108 Mile Ranch, Canada', 'ZMH');
  INSERT INTO airport VALUES('Aachen/Merzbruck', 'Aachen, Germany', 'AAH');
  INSERT INTO airport VALUES('Railway', 'Aachen, Germany', 'ZIU');
  INSERT INTO airport VALUES('Aalborg', 'Aalborg, Denmark', 'AAL');
  INSERT INTO airport VALUES('Vigra', 'Aalesund, Norway', 'AES');
  INSERT INTO airport VALUES('Tirstrup', 'Aarhus, Denmark', 'AAR');
  INSERT INTO airport VALUES('Aarhus Limo', 'Aarhus Limo, Denmark', 'ZBU');
  INSERT INTO airport VALUES('Aasiaat', 'Aasiaat, Greenland', 'JEG');
  INSERT INTO airport VALUES('Abadan', 'Abadan, Iran', 'ABD');
  INSERT INTO airport VALUES('Abaiang', 'Abaiang, Kiribati', 'ABF');
  INSERT INTO airport VALUES('Abakan', 'Abakan, Russian Federation', 'ABA');
  INSERT INTO airport VALUES('Abau', 'Abau, Papua New Guinea', 'ABW');
  INSERT INTO airport VALUES('Abbotsford', 'Abbotsford, Canada', 'YXX');
  INSERT INTO airport VALUES('Mumbai', 'Abbottabad, Pakistan', 'AAW');
  INSERT INTO airport VALUES('Abbse', 'Abbse, Yemen', 'EAB');
  INSERT INTO airport VALUES('Abecher', 'Abecher, Chad', 'AEH');
  INSERT INTO airport VALUES('Abemama Atoll', 'Abemama Atoll, Kiribati', 'AEA');
  INSERT INTO airport VALUES('Abengourou', 'Abengourou, Ivory Coast', 'OGO');
  INSERT INTO airport VALUES('Dyce', 'Aberdeen, United Kingdom', 'ABZ');
  INSERT INTO airport VALUES('Phillips AAF', 'Aberdeen, United States', 'APG');
  INSERT INTO airport VALUES('Municipal', 'Aberdeen, United States', 'ABR');
  INSERT INTO airport VALUES('Abha', 'Abha, Saudi Arabia', 'AHB');
  INSERT INTO airport VALUES('Felix Houphouet Boigny', 'Abidjan, Ivory Coast', 'ABJ');
  INSERT INTO airport VALUES('Dyess AFB', 'Abilene, United States', 'DYS');
  INSERT INTO airport VALUES('Municipal', 'Abilene, United States', 'ABI');
  INSERT INTO airport VALUES('RAF Station', 'Abingdon, United Kingdom', 'ABB');
  INSERT INTO airport VALUES('Abingdon', 'Abingdon, Australia', 'ABG');
  INSERT INTO airport VALUES('Virginia Highlands', 'Abingdon, United States', 'VJI');
  INSERT INTO airport VALUES('Aboisso', 'Aboisso, Ivory Coast', 'ABO');
  INSERT INTO airport VALUES('Abou Deia', 'Abou Deia, Chad', 'AOD');
  INSERT INTO airport VALUES('Abreojos', 'Abreojos, Mexico', 'AJS');
  INSERT INTO airport VALUES('Abu Dhabi Intl', 'Abu Dhabi, United Arab Emirates', 'AUH');
  INSERT INTO airport VALUES('Al Dhafra Military Apt', 'Abu Dhabi, United Arab Emirates', 'DHF');
  INSERT INTO airport VALUES('Bateen', 'Abu Dhabi, United Arab Emirates', 'AZI');
  INSERT INTO airport VALUES('Abu Musa', 'Abu Musa, Iran', 'AEU');
  INSERT INTO airport VALUES('Abu Rudeis', 'Abu Rudeis, Egypt', 'AUE');
  INSERT INTO airport VALUES('Abu Simbel', 'Abu Simbel, Egypt', 'ABS');
  INSERT INTO airport VALUES('International', 'Abuja, Nigeria', 'ABV');
  INSERT INTO airport VALUES('Acandi', 'Acandi, Colombia', 'ACD');
  INSERT INTO airport VALUES('Acaricuara', 'Acaricuara, Colombia', 'ARF');
  INSERT INTO airport VALUES('Acariqua', 'Acariqua, Venezuela', 'AGV');
  INSERT INTO airport VALUES('Kotoka', 'Accra, Ghana', 'ACC');
  INSERT INTO airport VALUES('Achinsk', 'Achinsk, Russian Federation', 'ACS');
  INSERT INTO airport VALUES('Acandi', 'Acandi, Colombia', 'ACD');
  INSERT INTO airport VALUES('Achutupo', 'Achutupo, Panama', 'ACU');
  INSERT INTO airport VALUES('Ada', 'Ada, United States', 'ADT');
  INSERT INTO airport VALUES('Adak Island NS', 'Adak Island, United States', 'ADK');
  INSERT INTO airport VALUES('Adana', 'Adana, Turkey', 'ADA');
  INSERT INTO airport VALUES('Adana-Incirlik Airbase', 'Adana, Turkey', 'UAB');
  INSERT INTO airport VALUES('Ad-Dabbah', 'Ad-Dabbah, Sudan', 'AAD');
  INSERT INTO airport VALUES('Bole', 'Addis Ababa, Ethiopia', 'ADD');
  INSERT INTO airport VALUES('Adelaide', 'Adelaide, Australia', 'XHX');
  INSERT INTO airport VALUES('International', 'Aden, Yemen', 'ADE');
  INSERT INTO airport VALUES('Adiyaman', 'Adiyaman, Turkey', 'ADF');
  INSERT INTO airport VALUES('Adler/Sochi', 'Adler/Sochi, Russian Federation', 'AER');
  INSERT INTO airport VALUES('Lenawee County', 'Adrian, United States', 'ADG');
  INSERT INTO airport VALUES('Aek Godang', 'Aek Godang, Indonesia', 'AEG');
  INSERT INTO airport VALUES('Afore', 'Afore, Papua New Guinea', 'AFR');
  INSERT INTO airport VALUES('Municipal', 'Afton, United States', 'AFO');
  INSERT INTO airport VALUES('Afutara Aerodrome', 'Afutara, Solomon Islands', 'AFT');
  INSERT INTO airport VALUES('Afyon', 'Afyon, Turkey', 'AFY');
  INSERT INTO airport VALUES('Agades', 'Agades, Niger', 'AJY');
  INSERT INTO airport VALUES('Agadir Almassira', 'Agadir, Morocco', 'AGA');
  INSERT INTO airport VALUES('Singerbhil', 'Agartala, India', 'IXA');
  INSERT INTO airport VALUES('Agatti Island', 'Agatti Island, India', 'AGX');
  INSERT INTO airport VALUES('Agaun', 'Agaun, Papua New Guinea', 'AUP');
  INSERT INTO airport VALUES('La Garenne', 'Agen, France', 'AGF');
  INSERT INTO airport VALUES('Aggeneys', 'Aggeneys, South Africa', 'AGZ');
  INSERT INTO airport VALUES('Aghajari', 'Aghajari, Iran', 'AKW');
  INSERT INTO airport VALUES('Agnew', 'Agnew, Australia', 'AGW');
  INSERT INTO airport VALUES('Kheria', 'Agra, India', 'AGR');
  INSERT INTO airport VALUES('Agri', 'Agri, Turkey', 'AJI');
  INSERT INTO airport VALUES('Agrinion', 'Agrinion, Greece', 'AGQ');
  INSERT INTO airport VALUES('Aguaclara', 'Aguaclara, Colombia', 'ACL');
  INSERT INTO airport VALUES('Borinquen', 'Aguadilla, Puerto Rico', 'BQN');
  INSERT INTO airport VALUES('Aguascalients', 'Aguascalientes, Mexico', 'AGU');
  INSERT INTO airport VALUES('Aguni', 'Aguni, Japan', 'AGJ');
  INSERT INTO airport VALUES('Ahe Airport', 'Ahe, French Polynesia', 'AHE');
  INSERT INTO airport VALUES('Ahmed Al Jaber', 'Ahmed Al Jaber, Kuwait', 'XIJ');
  INSERT INTO airport VALUES('Ahmedabad', 'Ahmedabad, India', 'AMD');
  INSERT INTO airport VALUES('Ahuas', 'Ahuas, Honduras', 'AHS');
  INSERT INTO airport VALUES('Ahwaz', 'Ahwaz, Iran', 'AWZ');
  INSERT INTO airport VALUES('Ai-Ais', 'Ai-Ais, Namibia', 'AIW');
  INSERT INTO airport VALUES('Aiambak', 'Aiambak, Papua New Guinea', 'AIH');
  INSERT INTO airport VALUES('Municipal', 'Aiken, United States', 'AIK');
  INSERT INTO airport VALUES('Ailigandi', 'Ailigandi, Panama', 'AIL');
  INSERT INTO airport VALUES('Ailinglapalap Island', 'Ailinglapalap Island, Marshall Islands', 'AIP');
  INSERT INTO airport VALUES('Ailuk Island', 'Ailuk Island, Marshall Islands', 'AIM');
  INSERT INTO airport VALUES('Ainsworth', 'Ainsworth, United States', 'ANW');
  INSERT INTO airport VALUES('Aiome', 'Aiome, Papua New Guinea', 'AIE');
  INSERT INTO airport VALUES('Aioun El Atrouss', 'Aioun El Atrouss, Mauritania', 'AEO');
  INSERT INTO airport VALUES('Whitsunday Airstrip', 'Airlie Beach, Australia', 'WSY');
  INSERT INTO airport VALUES('Airok', 'Airok, Marshall Islands', 'AIC');
  INSERT INTO airport VALUES('Aishalton', 'Aishalton, Guyana', 'AHL');
  INSERT INTO airport VALUES('Airstrip', 'Aitape, Papua New Guinea', 'ATP');
  INSERT INTO airport VALUES('Tadji', 'Aitape, Papua New Guinea', 'TAJ');
  INSERT INTO airport VALUES('Aitutaki', 'Aitutaki, Cook Islands', 'AIT');
  INSERT INTO airport VALUES('Railway Station', 'Aix La Chapelle, Germany', 'XHJ');
  INSERT INTO airport VALUES('Aiyura', 'Aiyura, Papua New Guinea', 'AYU');
  INSERT INTO airport VALUES('Aizawl', 'Aizawl, India', 'AJL');
  INSERT INTO airport VALUES('Campo Dell Oro', 'Ajaccio, France', 'AJA');
  INSERT INTO airport VALUES('Akhiok SPB', 'Akhiok, United States', 'AKK');
  INSERT INTO airport VALUES('Spb', 'Akiachak, United States', 'KKI');
  INSERT INTO airport VALUES('Akiak', 'Akiak, United States', 'AKI');
  INSERT INTO airport VALUES('Akita', 'Akita, Japan', 'AXT');
  
  
  
  
  
  --stopped at line 227	
  
  