Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
airports.sql - airport list (total 8800 airport)
This file has been truncated, but you can view the full file.
DROP TABLE IF EXISTS `airports`;
CREATE TABLE IF NOT EXISTS `airports` (
`code` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`name` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`cityCode` varchar(50) COLLATE utf8_turkish_ci DEFAULT NULL,
`cityName` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`countryName` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`countryCode` varchar(200) COLLATE utf8_turkish_ci DEFAULT NULL,
`timezone` varchar(8) COLLATE utf8_turkish_ci DEFAULT NULL,
`lat` varchar(32) COLLATE utf8_turkish_ci DEFAULT NULL,
`lon` varchar(32) COLLATE utf8_turkish_ci DEFAULT NULL,
`numAirports` int(11) DEFAULT NULL,
`city` enum('true','false') COLLATE utf8_turkish_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_turkish_ci;
/*!40000 ALTER TABLE `airports` DISABLE KEYS */;
INSERT INTO `airports` (`code`, `name`, `cityCode`, `cityName`, `countryName`, `countryCode`, `timezone`, `lat`, `lon`, `numAirports`, `city`) VALUES
('ANW', 'Ainsworth Minicipal Arpt', 'ANW', 'Ainsworth', 'UNITED STATES', 'US', '-100', '42.58', '-99.9933', 1, 'true'),
('ANU', 'V C Bird Intl Arpt', 'ANU', 'Antigua', 'ANTIGUA AND BARBUDA', 'AG', '-4', '17.136749', '-61.792667', 1, 'true'),
('ANR', 'Antwerp Brussels North', 'ANR', 'Antwerp', 'BELGIUM', 'BE', '1', '51.189444', '4.460278', 1, 'true'),
('ANP', 'Lee Annapolis Arpt', 'ANP', 'Annapolis', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ANI', 'Aniak Arpt', 'ANI', 'Aniak', 'UNITED STATES', 'US', '-9', '61.5816', '-159.543', 1, 'true'),
('ESB', 'Esenboga Arpt', 'ANK', 'Ankara', 'TURKEY', 'TR', '2', '40.128082', '32.995083', 1, ''),
('ANG', 'Brie Champniers', 'ANG', 'Angouleme', 'FRANCE', 'FR', '1', '45.729247', '0.221456', 1, 'true'),
('ANF', 'Cerro Moreno Arpt', 'ANF', 'Antofagasta', 'CHILE', 'CL', '-4', '-23.444478', '-70.4451', 1, 'true'),
('ANE', 'Marce Arpt', 'ANE', 'Angers', 'FRANCE', 'FR', '1', '47.5603', '-0.312222', 1, 'true'),
('AND', 'Anderson Arpt', 'AND', 'Anderson', 'UNITED STATES', 'US', '-5', '34.494583', '-82.709389', 1, 'true'),
('ANC', 'Anchorage Intl Arpt', 'ANC', 'Anchorage', 'UNITED STATES', 'US', '-9', '61.174361', '-149.996361', 1, 'true'),
('ANB', 'Anniston Municipal Arpt', 'ANB', 'Anniston', 'UNITED STATES', 'US', '-6', '33.588167', '-85.858111', 1, 'true'),
('ANA', 'Anaheim Arpt', 'ANA', 'Anaheim', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AMW', 'Ames Minicipal Arpt', 'AMW', 'Ames', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AMV', 'Amderma Airport', 'AMV', 'Amderma Airport', 'RUSSIA', 'RU', '4', '69.7633', '61.5564', 1, 'true'),
('AMS', 'Schiphol Arpt', 'AMS', 'Amsterdam', 'NETHERLANDS', 'NL', '1', '52.308613', '4.763889', 2, 'true'),
('ZYA', 'Amsterdam Central Rail Station', 'AMS', 'Amsterdam', 'NETHERLANDS', 'NL', '1', '52.7873', '4.90074', 2, ''),
('AMQ', 'Pattimura Arpt', 'AMQ', 'Ambon', 'INDONESIA', 'ID', '9', '-3.710264', '128.089136', 1, 'true'),
('AMM', 'Queen Alia Intl Arpt', 'AMM', 'Amman', 'JORDAN', 'JO', '2', '31.722556', '35.993214', 2, 'true'),
('ADJ', 'Civil Marka Arpt', 'AMM', 'Amman', 'JORDAN', 'JO', '2', '31.972703', '35.991569', 2, ''),
('AMI', 'Selaparang Airport', 'AMI', 'Mataram', 'INDONESIA', 'ID', '8', '-8.560708', '116.094656', 1, 'true'),
('AMD', 'Sardar Vallabh Bhai Patel Intl Arpt', 'AMD', 'Ahmedabad', 'INDIA', 'IN', '5', '23.077242', '72.63465', 1, 'true'),
('AMA', 'Amarillo Intl Arpt', 'AMA', 'Amarillo', 'UNITED STATES', 'US', '-6', '35.219369', '-101.705931', 2, 'true'),
('TDW', 'Tradewind Airport', 'AMA', 'Amarillo', 'UNITED STATES', 'US', '-100', '0', '0', 2, ''),
('ALY', 'El Nouzha Arpt', 'ALY', 'Alexandria', 'EGYPT', 'EG', '2', '31.183903', '29.948889', 1, 'true'),
('ALX', 'Thomas C Russell Field', 'ALX', 'Alexander City', 'UNITED STATES', 'US', '-5', '38.806346', '-77.0621', 1, 'true'),
('ALW', 'Walla Walla City County', 'ALW', 'Walla Walla', 'UNITED STATES', 'US', '-8', '46.0949', '-118.288', 1, 'true'),
('ALS', 'Alamosa Municipal', 'ALS', 'Alamosa', 'UNITED STATES', 'US', '-7', '37.435', '-105.866667', 1, 'true'),
('ALR', 'Alexandra Arpt', 'ALR', 'Alexandra', 'NEW ZEALAND', 'NZ', '12', '-45.211666', '169.373333', 1, 'true'),
('ALP', 'Nejrab Arpt', 'ALP', 'Aleppo', 'SYRIA', 'SY', '2', '36.180675', '37.224358', 1, 'true'),
('ALO', 'Livingston Betsworth Fld', 'ALO', 'Waterloo', 'UNITED STATES', 'US', '-6', '42.5571', '-92.4003', 1, 'true'),
('ALM', 'Alamogordo Municipal', 'ALM', 'Alamogordo', 'UNITED STATES', 'US', '-7', '32.8399', '-105.991', 1, 'true'),
('ALL', 'Albenga Arpt', 'ALL', 'Albenga', 'ITALY', 'IT', '1', '44.050608', '8.127428', 1, 'true'),
('ALJ', 'Kortdoorn Arpt', 'ALJ', 'Alexander Bay', 'SOUTH AFRICA', 'ZA', '2', '-28.575001', '16.533333', 1, 'true'),
('ALH', 'Albany Airport', 'ALH', 'Albany', 'AUSTRALIA', 'AU', '8', '-34.9433', '117.809', 1, 'true'),
('ALG', 'Houari Boumedienne Arpt', 'ALG', 'Algiers', 'ALGERIA', 'DZ', '1', '36.691014', '3.215408', 1, 'true'),
('ALF', 'Elvebakken Arpt', 'ALF', 'Alta', 'NORWAY', 'NO', '1', '69.976111', '23.371667', 1, 'true'),
('ALE', 'Alpine Aprt', 'ALE', 'Alpine', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ALC', 'Alicante Arpt', 'ALC', 'Alicante', 'SPAIN', 'ES', '1', '38.282169', '-0.558156', 1, 'true'),
('ALB', 'Albany Cty Arpt', 'ALB', 'Albany', 'UNITED STATES', 'US', '-5', '42.748267', '-73.801692', 1, 'true'),
('ALA', 'Almaty Arpt', 'ALA', 'Almaty', 'KAZAKHSTAN', 'KZ', '6', '43.352072', '77.040508', 1, 'true'),
('AKX', 'Aqtobe Arpt', 'AKX', 'Aqtobe', 'KAZAKHSTAN', 'KZ', '5', '50.245833', '57.206667', 1, 'true'),
('AKV', 'Akulivik Arpt', 'AKV', 'Akulivik', 'CANADA', 'CA', '-5', '60.8186', '-78.1486', 1, 'true'),
('AKU', 'Aksu Arpt', 'AKU', 'Aksu', 'CHINA', 'CN', '8', '41.2625', '80.2917', 1, 'true'),
('AKN', 'King Salmon Arpt', 'AKN', 'King Salmon', 'UNITED STATES', 'US', '-9', '58.676778', '-156.649278', 1, 'true'),
('AKL', 'Auckland Arpt', 'AKL', 'Auckland', 'NEW ZEALAND', 'NZ', '12', '-37.008056', '174.791667', 1, 'true'),
('AKJ', 'Asahikawa Arpt', 'AKJ', 'Asahikawa', 'JAPAN', 'JP', '9', '43.670833', '142.4475', 1, 'true'),
('AJU', 'Santa Maria Arpt', 'AJU', 'Aracaju', 'BRAZIL', 'BR', '-3', '-10.984', '-37.070333', 1, 'true'),
('AJR', 'Arvidsjaur Arpt', 'AJR', 'Arvidsjaur', 'SWEDEN', 'SE', '1', '65.590278', '19.281944', 1, 'true'),
('AJI', 'Agri Airport', 'AJI', 'Agri', 'TURKEY', 'TR', '2', '39.6546', '43.0271', 1, 'true'),
('AJF', 'JOUF', 'AJF', 'Al Jouf', 'SAUDI ARABIA', 'SA', '1', '0', '0', 1, 'true'),
('AJA', 'Campo Dell Oro Arpt', 'AJA', 'Ajaccio', 'FRANCE', 'FR', '1', '41.923637', '8.802917', 1, 'true'),
('AIZ', 'Lee C Fine Memorial', 'AIZ', 'Lake Of The Ozarks', 'UNITED STATES', 'US', '-5', '38.096035', '-92.549488', 1, 'true'),
('ACY', 'Pomona Field', 'AIY', 'Atlantic City', 'UNITED STATES', 'US', '-5', '39.457583', '-74.577167', 2, ''),
('AIY', 'Bader Field', 'AIY', 'Atlantic City', 'UNITED STATES', 'US', '-100', '0', '0', 2, 'true'),
('AIT', 'Aitutaki Arpt', 'AIT', 'Aitutaki', 'COOK ISLANDS', 'CK', '-10', '-18.830922', '-159.764233', 1, 'true'),
('AIN', 'Wainwright Municipal Arpt', 'AIN', 'Wainwright', 'UNITED STATES', 'US', '-9', '70.638056', '-159.994722', 1, 'true'),
('AIK', 'Aiken Municipal Arpt', 'AIK', 'Aiken', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AID', 'Anderson Municipal Arpt', 'AID', 'Anderson', 'UNITED STATES', 'US', '-100', '40.1087', '-85.613', 1, 'true'),
('AIA', 'Alliance Municipal', 'AIA', 'Alliance', 'UNITED STATES', 'US', '-7', '42.053333', '-102.803889', 1, 'true'),
('AHU', 'Charif Al Idrissi Arpt', 'AHU', 'Al Hoceima', 'MOROCCO', 'MA', '0', '35.177103', '-3.839525', 1, 'true'),
('AHO', 'Fertilia Arpt', 'AHO', 'Alghero', 'ITALY', 'IT', '1', '40.632133', '8.290772', 1, 'true'),
('AHN', 'Athens Municipal', 'AHN', 'Athens', 'UNITED STATES', 'US', '-5', '33.9486', '-83.3263', 1, 'true'),
('AHI', 'Amahai Airport', 'AHI', 'Amahai', 'INDONESIA', 'ID', '-100', '0', '0', 1, 'true'),
('AHB', 'Abha Airport', 'AHB', 'Abha', 'SAUDI ARABIA', 'SA', '3', '18.240367', '42.656625', 1, 'true'),
('AGU', 'Aguascalientes Municipal Arpt', 'AGU', 'Aguascalientes', 'MEXICO', 'MX', '-6', '21.705558', '-102.317858', 1, 'true'),
('AGT', 'Alejo Garcia Arpt', 'AGT', 'Ciudad Del Este', 'PARAGUAY', 'PY', '-4', '-25.4555', '-54.843592', 1, 'true'),
('AGS', 'Bush Field', 'AGS', 'Augusta', 'UNITED STATES', 'US', '-5', '33.369944', '-81.9645', 2, 'true'),
('DNL', 'Daniel Airport', 'AGS', 'Augusta', 'UNITED STATES', 'US', '-4', '33.466503', '-82.039381', 2, ''),
('AGR', 'Kheria Arpt', 'AGR', 'Agra', 'INDIA', 'IN', '5', '27.155831', '77.960892', 1, 'true'),
('AGQ', 'Agrinion Arpt', 'AGQ', 'Agrinion', 'GREECE', 'GR', '2', '38.602022', '21.351208', 1, 'true'),
('AGP', 'Malaga Arpt', 'AGP', 'Malaga', 'SPAIN', 'ES', '1', '36.6749', '-4.499106', 1, 'true'),
('AGO', 'Magnolia Municipal', 'AGO', 'Magnolia', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AGN', 'Angoon Arpt', 'AGN', 'Angoon', 'UNITED STATES', 'US', '-9', '57.503611', '-134.585', 1, 'true'),
('AGH', 'Angelholm Helsingborg Arpt', 'AGH', 'Angelholm', 'SWEDEN', 'SE', '1', '56.2961', '12.8471', 1, 'true'),
('AGF', 'La Garenne Arpt', 'AGF', 'Agen', 'FRANCE', 'FR', '1', '44.174721', '0.590556', 1, 'true'),
('AGE', 'Flugplatz Arpt', 'AGE', 'Wangerooge', 'GERMANY', 'DE', '1', '53.7828', '7.91389', 1, 'true'),
('AGB', 'Muehlhausen Arpt', 'AGB', 'Augsburg', 'GERMANY', 'DE', '1', '48.425158', '10.931764', 1, 'true'),
('AGA', 'Agadir Almassira Arpt', 'AGA', 'Agadir', 'MOROCCO', 'MA', '0', '30.381353', '-9.546311', 1, 'true'),
('AFY', 'Afyon Arpt', 'AFY', 'Afyon Arpt', 'TURKEY', 'TR', '2', '38.726425', '30.601114', 1, 'true'),
('AFL', 'Alta Floresta Arpt', 'AFL', 'Alta Floresta', 'BRAZIL', 'BR', '-4', '-9.866092', '-56.106206', 1, 'true'),
('AFK', 'Kondavattavan Tank Arpt', 'AFK', 'Ampara', 'SRI LANKA', 'LK', '-100', '0', '0', 1, 'true'),
('AFA', 'San Rafael Arpt', 'AFA', 'San Rafael', 'ARGENTINA', 'AR', '-3', '-34.588314', '-68.403854', 1, 'true'),
('AEY', 'Akureyri', 'AEY', 'Akureyri', 'ICELAND', 'IS', '0', '65.659994', '-18.072703', 1, 'true'),
('ESF', 'Esler Field', 'AEX', 'Alexandria', 'UNITED STATES', 'US', '-6', '31.394903', '-92.295772', 2, ''),
('AEX', 'Alexandria Intl Arpt', 'AEX', 'Alexandria', 'UNITED STATES', 'US', '-6', '31.3274', '-92.549833', 2, 'true'),
('AES', 'Vigra Airport', 'AES', 'Aalesund', 'NORWAY', 'NO', '1', '62.560372', '6.110164', 1, 'true'),
('AER', 'Alder Sochi Arpt', 'AER', 'Adler Sochi', 'RUSSIA', 'RU', '4', '43.449928', '39.956589', 1, 'true'),
('AEL', 'Albert Lea Arpt', 'AEL', 'Albert Lea', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AEI', 'Algeciras Arpt', 'AEI', 'Algeciras', 'SPAIN', 'ES', '-100', '0', '0', 1, 'true'),
('ADZ', 'San Andres Island Arpt', 'ADZ', 'San Andres', 'COLOMBIA', 'CO', '-5', '12.583594', '-81.711192', 1, 'true'),
('ADX', 'Leuchars Arpt', 'ADX', 'St Andrews', 'UNITED KINGDOM', 'GB', '0', '56.372889', '-2.868444', 1, 'true'),
('ADW', 'Andrews Air Force Base', 'ADW', 'Camp Springs', 'UNITED STATES', 'US', '-5', '38.810806', '-76.867028', 1, 'true'),
('ADU', 'Ardabil Arpt', 'ADU', 'Ardabil', 'IRAN', 'IR', '3', '38.325678', '48.424356', 1, 'true'),
('ADT', 'Ada Municipal Arpt', 'ADT', 'Ada OK', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ADQ', 'Kodiak Arpt', 'ADQ', 'Kodiak', 'UNITED STATES', 'US', '-9', '57.749967', '-152.493856', 2, 'true'),
('KDK', 'Kodiak Municipal', 'ADQ', 'Kodiak', 'UNITED STATES', 'US', '-100', '0', '0', 2, ''),
('ADM', 'Ardmore Municipal Arpt', 'ADM', 'Ardmore', 'UNITED STATES', 'US', '-6', '34.300833', '-97.008889', 1, 'true'),
('ADL', 'Adelaide Arpt', 'ADL', 'Adelaide', 'AUSTRALIA', 'AU', '9', '-34.945', '138.530556', 1, 'true'),
('ADK', 'Adak Island Ns', 'ADK', 'Adak Island', 'UNITED STATES', 'US', '-10', '51.878', '-176.646', 1, 'true'),
('ADH', 'Aldan Airport', 'ADH', 'Aldan Airport', 'RUSSIA', 'RU', '-2', '0', '0', 1, 'true'),
('ADG', 'Lenawee County Arpt', 'ADG', 'Adrian', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ADF', 'Adiyaman Airport', 'ADF', 'Adiyaman', 'TURKEY', 'TR', '2', '37.7314', '38.4689', 1, 'true'),
('ADE', 'Yemen Intl Arpt', 'ADE', 'Aden', 'YEMEN', 'YE', '3', '12.829542', '45.028792', 1, 'true'),
('ADD', 'Bole Airport', 'ADD', 'Addis Ababa', 'ETHIOPIA', 'ET', '3', '8.977889', '38.799319', 1, 'true'),
('ADA', 'Adana Arpt', 'ADA', 'Adana', 'TURKEY', 'TR', '2', '36.982166', '35.280388', 1, 'true'),
('ACX', 'Xingyi Arpt', 'ACX', 'Xingyi', 'CHINA', 'CN', '8', '25.0882', '104.9587', 1, 'true'),
('ACV', 'Arcata Eureka Arpt', 'ACV', 'Eureka', 'UNITED STATES', 'US', '-8', '40.978111', '-124.108611', 1, 'true'),
('ACT', 'Madison Cooper Arpt', 'ACT', 'Waco', 'UNITED STATES', 'US', '-6', '31.611289', '-97.230519', 1, 'true'),
('ACS', 'Achinsk Airport', 'ACS', 'Achinsk Airport', 'RUSSIA', 'RU', '-2', '0', '0', 1, 'true'),
('ACO', 'Ascona Arpt', 'ACO', 'Ascona', 'SWITZERLAND', 'CH', '-100', '0', '0', 1, 'true'),
('ACK', 'Nantucket Memorial', 'ACK', 'Nantucket', 'UNITED STATES', 'US', '-5', '41.253053', '-70.060181', 1, 'true'),
('ACI', 'The Blaye Arpt', 'ACI', 'Alderney', 'UNITED KINGDOM', 'GB', '0', '49.706111', '-2.214722', 1, 'true'),
('ACH', 'Altenrhein Arpt', 'ACH', 'Altenrhein', 'SWITZERLAND', 'CH', '1', '47.485033', '9.560775', 1, 'true'),
('ACE', 'Lanzarote Airport', 'ACE', 'Lanzarote', 'SPAIN', 'ES', '0', '28.945464', '-13.605225', 1, 'true'),
('ACC', 'Kotoka Airport', 'ACC', 'Accra', 'GHANA', 'GH', '0', '5.605186', '-0.166786', 1, 'true'),
('ACA', 'Alvarez Intl Arpt', 'ACA', 'Acapulco', 'MEXICO', 'MX', '-6', '16.757061', '-99.753953', 1, 'true'),
('ABZ', 'Dyce Airport', 'ABZ', 'Aberdeen', 'UNITED KINGDOM', 'GB', '0', '57.201944', '-2.197778', 2, 'true'),
('ZXA', 'Aberdeen ScotRail Station', 'ABZ', 'Aberdeen', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 2, ''),
('ABY', 'Dougherty Cty Arpt', 'ABY', 'Albany', 'UNITED STATES', 'US', '-5', '31.5355', '-84.1945', 1, 'true'),
('ABX', 'Albury Airport', 'ABX', 'Albury', 'AUSTRALIA', 'AU', '10', '-36.067778', '146.958056', 1, 'true'),
('ABV', 'Abuja Intl', 'ABV', 'Abuja', 'NIGERIA', 'NG', '1', '9.006792', '7.263172', 1, 'true'),
('ABT', 'Al Aqiq', 'ABT', 'Al Baha', 'SAUDI ARABIA', 'SA', '3', '20.296139', '41.634277', 1, 'true'),
('ABS', 'Abu Simbel Arpt', 'ABS', 'Abu Simbel', 'EGYPT', 'EG', '2', '22.375953', '31.611722', 1, 'true'),
('ABR', 'Aberdeen Arpt', 'ABR', 'Aberdeen', 'UNITED STATES', 'US', '-6', '45.4491', '-98.4218', 1, 'true'),
('ABQ', 'Albuquerque Intl Arpt', 'ABQ', 'Albuquerque', 'UNITED STATES', 'US', '-7', '35.040222', '-106.609194', 1, 'true'),
('ABM', 'Bamaga Arpt', 'ABM', 'Bamaga', 'AUSTRALIA', 'AU', '10', '-10.950833', '142.459444', 1, 'true'),
('ABL', 'Ambler Arpt', 'ABL', 'Ambler', 'UNITED STATES', 'US', '-9', '67.106389', '-157.8575', 1, 'true'),
('ABI', 'Abilene Municipal Arpt', 'ABI', 'Abilene', 'UNITED STATES', 'US', '-6', '32.411319', '-99.681897', 1, 'true'),
('ABE', 'Lehigh Valley Intl Arpt', 'ABE', 'Allentown', 'UNITED STATES', 'US', '-5', '40.652083', '-75.440806', 1, 'true'),
('ABD', 'Abadan Arpt', 'ABD', 'Abadan', 'IRAN', 'IR', '4', '30.371111', '48.228333', 1, 'true'),
('ABC', 'Los Llanos Arpt', 'ABC', 'Albacete', 'SPAIN', 'ES', '-100', '38.948', '-1.863', 1, 'true'),
('ABA', 'Abakan Arpt', 'ABA', 'Abakan', 'RUSSIA', 'RU', '8', '53.74', '91.385', 1, 'true'),
('AAY', 'Al Ghaydah Arpt', 'AAY', 'Al Ghaydah', 'YEMEN', 'YE', '3', '16.191667', '52.175', 1, 'true'),
('AAT', 'Altay Arpt', 'AAT', 'Altay', 'CHINA', 'CN', '8', '47.866667', '88.116667', 1, 'true'),
('AAR', 'Tirstrup Arpt', 'AAR', 'Aarhus', 'DENMARK', 'DK', '1', '56.300017', '10.619008', 2, 'true'),
('ZID', 'Aarhus Bus Service', 'AAR', 'Aarhus', 'DENMARK', 'DK', '-100', '0', '0', 2, ''),
('AAQ', 'Anapa Arpt', 'AAQ', 'Anapa', 'RUSSIA', 'RU', '4', '45.002097', '37.347272', 1, 'true'),
('AAN', 'Al Ain Arpt', 'AAN', 'Al Ain', 'UNITED ARAB EMIRATES', 'AE', '4', '24.261667', '55.609167', 1, 'true'),
('AAM', 'Mala Mala Arpt', 'AAM', 'Mala Mala', 'SOUTH AFRICA', 'ZA', '2', '-24.818111', '31.544584', 1, 'true'),
('AAL', 'Aalborg Arpt', 'AAL', 'Aalborg', 'DENMARK', 'DK', '1', '57.092789', '9.849164', 1, 'true'),
('AAH', 'Aachen Merzbruck Arpt', 'AAH', 'Aachen', 'GERMANY', 'DE', '1', '50.823194', '6.186389', 1, 'true'),
('AAG', 'Arapoti Arpt', 'AAG', 'Arapoti', 'BRAZIL', 'BR', '-100', '-24.1036', '-49.79', 1, 'true'),
('AAF', 'Apalachicola Municipal Arpt', 'AAF', 'Apalachicola', 'UNITED STATES', 'US', '-6', '29.727607', '-85.027442', 1, 'true'),
('AAE', 'Les Salines Arpt', 'AAE', 'Annaba', 'ALGERIA', 'DZ', '1', '36.822225', '7.809167', 1, 'true'),
('ANX', 'Andenes Arpt', 'ANX', 'Andenes', 'NORWAY', 'NO', '1', '69.2925', '16.144167', 1, 'true'),
('AOC', 'Altenburg Nobitz Arpt', 'AOC', 'Altenburg', 'GERMANY', 'DE', '1', '50.981817', '12.506361', 1, 'true'),
('AOE', 'Anadolu University Airport', 'AOE', 'Eskisehir', 'TURKEY', 'TR', '2', '39.809858', '30.519378', 1, 'true'),
('AOH', 'Allen County Arpt', 'AOH', 'Lima', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AOI', 'Falconara Arpt', 'AOI', 'Ancona', 'ITALY', 'IT', '1', '43.616389', '13.362222', 1, 'true'),
('AOJ', 'Aomori Arpt', 'AOJ', 'Aomori', 'JAPAN', 'JP', '9', '40.734722', '140.690833', 1, 'true'),
('AOK', 'Karpathos Arpt', 'AOK', 'Karpathos', 'GREECE', 'GR', '2', '35.421408', '27.146008', 1, 'true'),
('AOL', 'Paso De Los Libres Arpt', 'AOL', 'Paso De Los Libres', 'ARGENTINA', 'AR', '-3', '-29.689425', '-57.152078', 1, 'true'),
('AOO', 'Blair Cty Arpt', 'AOO', 'Altoona', 'UNITED STATES', 'US', '-5', '40.296372', '-78.320022', 1, 'true'),
('AOR', 'Sultan Abdul Hamlin Arpt', 'AOR', 'Alor Setar', 'MALAYSIA', 'MY', '8', '6.189667', '100.398183', 1, 'true'),
('AOT', 'Corrado Gex Arpt', 'AOT', 'Aosta', 'ITALY', 'IT', '1', '45.738456', '7.368719', 1, 'true'),
('APC', 'Napa Cty Arpt', 'APC', 'Napa', 'UNITED STATES', 'US', '-7', '38.213194', '-122.280694', 1, 'true'),
('APF', 'Naples Municipal', 'APF', 'Naples', 'UNITED STATES', 'US', '-5', '26.152619', '-81.775294', 1, 'true'),
('APL', 'Nampula Arpt', 'APL', 'Nampula', 'MOZAMBIQUE', 'MZ', '2', '-15.105611', '39.2818', 1, 'true'),
('APN', 'Phelps Collins Arpt', 'APN', 'Alpena', 'UNITED STATES', 'US', '-5', '45.0781', '-83.5603', 1, 'true'),
('APO', 'Apartado Arpt', 'APO', 'Apartado', 'COLOMBIA', 'CO', '-5', '7.033', '-77.2', 1, 'true'),
('APS', 'Anapolis Arpt', 'APS', 'Anapolis', 'BRAZIL', 'BR', '-100', '-16.3619', '-48.9275', 1, 'true'),
('APW', 'Apia Airport', 'APW', 'Apia', 'SAMOA', 'WS', '-11', '-13.829969', '-172.008336', 2, 'true'),
('FGI', 'Fagali Arpt', 'APW', 'Apia', 'SAMOA', 'WS', '-11', '-13.848611', '-171.740833', 2, ''),
('AQA', 'Araraquara Arpt', 'AQA', 'Araraquara', 'BRAZIL', 'BR', '-3', '-21.812', '-48.133028', 1, 'true'),
('AQG', 'Anqing Arpt', 'AQG', 'Anqing', 'CHINA', 'CN', '8', '30.5822', '117.0502', 1, 'true'),
('AQI', 'Qaisumah Arpt', 'AQI', 'Qaisumah', 'SAUDI ARABIA', 'SA', '3', '28.335192', '46.125069', 1, 'true'),
('AQJ', 'Aqaba Airport', 'AQJ', 'Aqaba', 'JORDAN', 'JO', '2', '29.611619', '35.018067', 1, 'true'),
('AQP', 'Rodriguez Ballon Arpt', 'AQP', 'Arequipa', 'PERU', 'PE', '-5', '-16.341072', '-71.583083', 1, 'true'),
('ARB', 'Ann Arbor Municipal', 'ARB', 'Ann Arbor', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ARH', 'Arkhangelsk Arpt', 'ARH', 'Arkhangelsk', 'RUSSIA', 'RU', '4', '64.360281', '40.430167', 1, 'true'),
('ARI', 'Chacalluta Arpt', 'ARI', 'Arica', 'CHILE', 'CL', '-4', '-18.348531', '-70.338742', 1, 'true'),
('ARK', 'Arusha Arpt', 'ARK', 'Arusha', 'TANZANIA', 'TZ', '3', '-3.367794', '36.633333', 1, 'true'),
('ARM', 'Armidale Arpt', 'ARM', 'Armidale', 'AUSTRALIA', 'AU', '10', '-30.528056', '151.617222', 1, 'true'),
('ART', 'Watertown Arpt', 'ART', 'Watertown', 'UNITED STATES', 'US', '-5', '43.991922', '-76.021739', 1, 'true'),
('ARU', 'Aracatuba Arpt', 'ARU', 'Aracatuba', 'BRAZIL', 'BR', '-3', '-21.141342', '-50.424722', 1, 'true'),
('ARV', 'Noble F Lee Memorial Field', 'ARV', 'Minocqua', 'UNITED STATES', 'US', '-6', '45.927778', '-89.730833', 1, 'true'),
('ARW', 'Arad Arpt', 'ARW', 'Arad', 'ROMANIA', 'RO', '2', '46.17655', '21.262022', 1, 'true'),
('ARY', 'Ararat Arpt', 'ARY', 'Ararat', 'AUSTRALIA', 'AU', '-100', '-37.3119', '142.9906', 1, 'true'),
('ASB', 'Ashgabat Arpt', 'ASB', 'Ashgabat', 'TURKMENISTAN', 'TM', '5', '37.986814', '58.360967', 1, 'true'),
('ASD', 'Andros Town Arpt', 'ASD', 'Andros Town', 'BAHAMAS', 'BS', '-5', '24.698283', '-77.795611', 1, 'true'),
('ASE', 'Pitkin Cty Arptt Sardy Fld', 'ASE', 'Aspen', 'UNITED STATES', 'US', '-7', '39.2232', '-106.869', 1, 'true'),
('ASF', 'Astrakhan Arpt', 'ASF', 'Astrakhan', 'RUSSIA', 'RU', '6', '46.283333', '48.006278', 1, 'true'),
('ASH', 'Boire Field Arpt', 'ASH', 'Nashua', 'UNITED STATES', 'US', '-4', '42.78175', '-71.514778', 1, 'true'),
('ASJ', 'Amami O Shima Arpt', 'ASJ', 'Amami O Shima', 'JAPAN', 'JP', '9', '28.430633', '129.712542', 1, 'true'),
('ASK', 'Yamoussoukro Arpt', 'ASK', 'Yamoussouro', 'COTE D\'IVOIRE', 'CI', '0', '6.903167', '-5.365581', 1, 'true'),
('ASL', 'Harrison County Arpt', 'ASL', 'Marshall', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ASM', 'Asmara Intl Arpt', 'ASM', 'Asmara', 'ERITREA', 'ER', '3', '15.291853', '38.910667', 1, 'true'),
('ASN', 'Talladega Arpt', 'ASN', 'Talladega', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ASP', 'Alice Springs Arpt', 'ASP', 'Alice Springs', 'AUSTRALIA', 'AU', '9', '-23.806667', '133.902222', 1, 'true'),
('ASR', 'Kayseri Arpt', 'ASR', 'Kayseri', 'TURKEY', 'TR', '2', '38.770386', '35.495428', 1, 'true'),
('AST', 'Astoria Arpt', 'AST', 'Astoria', 'UNITED STATES', 'US', '-8', '46.157972', '-123.878694', 1, 'true'),
('ASU', 'Salvio Pettirosse Arpt', 'ASU', 'Asuncion', 'PARAGUAY', 'PY', '-4', '-25.23985', '-57.519133', 1, 'true'),
('ASW', 'Daraw Arpt', 'ASW', 'Aswan', 'EGYPT', 'EG', '2', '23.964356', '32.819975', 1, 'true'),
('ATC', 'Arthurs Town Arpt', 'ATC', 'Arthurs Town', 'BAHAMAS', 'BS', '-5', '24.629417', '-75.673775', 1, 'true'),
('ATH', 'Eleftherios Venizelos Intl Arpt', 'ATH', 'Athens', 'GREECE', 'GR', '2', '37.936358', '23.944467', 2, 'true'),
('HEW', 'Athens Hellinikon Arpt', 'ATH', 'Athens', 'GREECE', 'GR', '2', '37.8933', '23.7261', 2, ''),
('ATI', 'Artigas Arpt', 'ATI', 'Artigas', 'URUGUAY', 'UY', '-100', '0', '0', 1, 'true'),
('PDK', 'Dekalb Peachtree', 'ATL', 'Atlanta', 'UNITED STATES', 'US', '-4', '33.875611', '-84.301972', 3, ''),
('FTY', 'Fulton Cty Arpt', 'ATL', 'Atlanta', 'UNITED STATES', 'US', '-5', '33.7791', '-84.5214', 3, ''),
('ATL', 'Hartsfield Jackson Intl Arpt', 'ATL', 'Atlanta', 'UNITED STATES', 'US', '-5', '33.636719', '-84.428067', 3, 'true'),
('ATM', 'Altamira Arpt', 'ATM', 'Altamira', 'BRAZIL', 'BR', '-3', '-3.253906', '-52.253978', 1, 'true'),
('ATO', 'Ohio University Arpt', 'ATO', 'Athens', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('ATQ', 'Raja Sansi Arpt', 'ATQ', 'Amritsar', 'INDIA', 'IN', '5', '31.709594', '74.797264', 1, 'true'),
('ATR', 'Mouakchott Arpt', 'ATR', 'Atar', 'MAURITANIA', 'MR', '0', '20.506828', '-13.043194', 1, 'true'),
('ATW', 'Outagamie Cty Arpt', 'ATW', 'Appleton', 'UNITED STATES', 'US', '-6', '44.257526', '-88.507576', 1, 'true'),
('ATY', 'Watertown Municipal', 'ATY', 'Watertown', 'UNITED STATES', 'US', '-6', '44.914', '-97.1547', 1, 'true'),
('AUA', 'Reina Beatrix Arpt', 'AUA', 'Aruba', 'ARUBA', 'AW', '-4', '12.501389', '-70.015221', 1, 'true'),
('AUG', 'Maine State Arpt', 'AUG', 'Augusta', 'UNITED STATES', 'US', '-5', '44.320647', '-69.797317', 1, 'true'),
('ZVJ', 'Abu Dhabi-bus Station', 'AUH', 'Abu Dhabi', 'UNITED ARAB EMIRATES', 'AE', '-100', '0', '0', 2, ''),
('AUH', 'Dhabi Intl Arpt', 'AUH', 'Abu Dhabi', 'UNITED ARAB EMIRATES', 'AE', '4', '24.432972', '54.651138', 2, 'true'),
('AUO', 'Auburn Opelika', 'AUO', 'Auburn', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AUQ', 'Atuona Arpt', 'AUQ', 'Atuona', 'FRENCH POLYNESIA', 'PF', '-9', '-9.768794', '-139.011256', 1, 'true'),
('AUR', 'Tronquieres Arpt', 'AUR', 'Aurillac', 'FRANCE', 'FR', '1', '44.891388', '2.421944', 1, 'true'),
('AUS', 'Bergstrom Intl Arpt', 'AUS', 'Austin', 'UNITED STATES', 'US', '-6', '30.194528', '-97.669889', 1, 'true'),
('AUU', 'Aurukin Arpt', 'AUU', 'Aurukun Mission', 'AUSTRALIA', 'AU', '10', '-13.3539', '141.721', 1, 'true'),
('AUW', 'Wausau Municipal Arpt', 'AUW', 'Wausau', 'UNITED STATES', 'US', '-6', '44.926285', '-89.627002', 2, 'true'),
('CWA', 'Central Wisconsin Arpt', 'AUW', 'Wausau', 'UNITED STATES', 'US', '-6', '44.772726', '-89.646635', 2, ''),
('AUX', 'Araguaina Arpt', 'AUX', 'Araguaina', 'BRAZIL', 'BR', '-3', '-7.228333', '-48.240833', 1, 'true'),
('AUZ', 'Aurora Municipal Arpt', 'AUZ', 'Aurora', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AVI', 'Maximo Gomez Arpt', 'AVI', 'Ciego De Avila', 'CUBA', 'CU', '-5', '22.027053', '-78.789617', 1, 'true'),
('AVL', 'Asheville Municipal Arpt', 'AVL', 'Asheville', 'UNITED STATES', 'US', '-5', '35.436194', '-82.541806', 1, 'true'),
('XZN', 'Avignon Railway Station', 'AVN', 'Avignon', 'FRANCE', 'FR', '-100', '46.4', '5.8333', 2, ''),
('AVN', 'Avignon Caumont Arpt', 'AVN', 'Avignon', 'FRANCE', 'FR', '1', '43.9073', '4.901831', 2, 'true'),
('AVP', 'Wilkes Barre Scranton Intl Arpt', 'AVP', 'Scranton', 'UNITED STATES', 'US', '-5', '41.338478', '-75.723403', 1, 'true'),
('SXC', 'Catalina Arpt', 'AVX', 'Catalina Island', 'UNITED STATES', 'US', '-100', '0', '0', 1, ''),
('AXA', 'Wallblake Municipal', 'AXA', 'Anguilla', 'ANGUILLA', 'AI', '-4', '18.204834', '-63.055084', 1, 'true'),
('AXD', 'Dhmokritos Arpt', 'AXD', 'Alexandroupolis', 'GREECE', 'GR', '2', '40.855869', '25.956264', 1, 'true'),
('AXM', 'El Eden Arpt', 'AXM', 'Armenia', 'COLOMBIA', 'CO', '-5', '4.452775', '-75.766447', 1, 'true'),
('AXT', 'Akita Airport', 'AXT', 'Akita', 'JAPAN', 'JP', '9', '39.615556', '140.218611', 1, 'true'),
('AXV', 'Neil Armstrong Arpt', 'AXV', 'Wapakoneta', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('AYP', 'Yanamilla Arpt', 'AYP', 'Ayacucho', 'PERU', 'PE', '-5', '-13.154819', '-74.204417', 1, 'true'),
('AYQ', 'Connellan Arpt', 'AYQ', 'Ayers Rock', 'AUSTRALIA', 'AU', '9', '-25.186111', '130.975556', 1, 'true'),
('AYR', 'Ayr Arpt', 'AYR', 'Ayr Au', 'AUSTRALIA', 'AU', '-100', '-19.5958', '147.3258', 1, 'true'),
('AYS', 'Ware County Arpt', 'AYS', 'Waycross', 'UNITED STATES', 'US', '-100', '31.2491', '-82.3955', 1, 'true'),
('AYT', 'Antalya Airport', 'AYT', 'Antalya', 'TURKEY', 'TR', '2', '36.898731', '30.800461', 1, 'true'),
('AZD', 'Yazd Arpt', 'AZD', 'Yazd', 'IRAN', 'IR', '4', '31.904908', '54.276503', 1, 'true'),
('AZG', 'Apatzingan Arpt', 'AZG', 'Apatzingan', 'MEXICO', 'MX', '-100', '0', '0', 1, 'true'),
('AZN', 'Andizhan', 'AZN', 'Andizhan', 'UZBEKISTAN', 'UZ', '5', '40.7277', '72.294', 1, 'true'),
('AZO', 'Kalamazoo Cty Arpt', 'AZO', 'Kalamazoo', 'UNITED STATES', 'US', '-5', '42.234875', '-85.552058', 1, 'true'),
('AZS', 'Samana International Arpt', 'AZS', 'Samana', 'DOMINICAN REPUBLIC', 'DO', '-4', '19.267', '-69.742', 1, 'true'),
('BAG', 'Loakan Arpt', 'BAG', 'Baguio', 'PHILIPPINES', 'PH', '8', '16.375103', '120.619636', 1, 'true'),
('BAH', 'Bahrain Intl Arpt', 'BAH', 'Muharraq', 'BAHRAIN', 'BH', '3', '26.270834', '50.63361', 1, 'true'),
('GYD', 'Heydar Aliyev Intl Arpt', 'BAK', 'Baku', 'AZERBAIJAN', 'AZ', '4', '40.4675', '50.046667', 3, ''),
('ZXT', 'Zabrat Arpt', 'BAK', 'Baku', 'AZERBAIJAN', 'AZ', '-100', '0', '0', 3, ''),
('BAK', 'Baku Airport', 'BAK', 'Baku', 'AZERBAIJAN', 'AZ', '4', '40.4675', '50.046667', 3, 'true'),
('BAL', 'Batman Arpt', 'BAL', 'Batman', 'TURKEY', 'TR', '2', '37.928969', '41.116583', 1, 'true'),
('BAO', 'Udorn Arpt', 'BAO', 'Ban Mak Khaen', 'THAILAND', 'TH', '-100', '0', '0', 1, 'true'),
('BAQ', 'E Cortissoz Arpt', 'BAQ', 'Barranquilla', 'COLOMBIA', 'CO', '-5', '10.889589', '-74.780819', 1, 'true'),
('BAS', 'Balalae Arpt', 'BAS', 'Balalae', 'SOLOMON ISLANDS', 'SB', '11', '-6.967', '155.883', 1, 'true'),
('BAT', 'Barretos Arpt', 'BAT', 'Barretos', 'BRAZIL', 'BR', '-100', '-20.585', '-48.5953', 1, 'true'),
('BAU', 'Bauru Arpt', 'BAU', 'Bauru', 'BRAZIL', 'BR', '-3', '-22.345042', '-49.0538', 1, 'true'),
('BAV', 'Baotou Arpt', 'BAV', 'Baotou', 'CHINA', 'CN', '8', '40.56', '109.997', 1, 'true'),
('BAX', 'Barnaul Arpt', 'BAX', 'Barnaul', 'RUSSIA', 'RU', '7', '53.363775', '83.538533', 1, 'true'),
('BAY', 'Baia Mare Arpt', 'BAY', 'Baia Mare', 'ROMANIA', 'RO', '2', '47.658389', '23.470022', 1, 'true'),
('BBA', 'Teniente Vidal Airport', 'BBA', 'Balmaceda', 'CHILE', 'CL', '-3', '-45.916058', '-71.689475', 1, 'true'),
('BBH', 'Barth Arpt', 'BBH', 'Barth', 'GERMANY', 'DE', '1', '54.33754', '12.699705', 1, 'true'),
('BBI', 'Biju Patnaik Arpt', 'BBI', 'Bhubaneswar', 'INDIA', 'IN', '6', '20.244364', '85.817781', 1, 'true'),
('BBJ', 'Bitburg Air Base', 'BBJ', 'Bitburg', 'GERMANY', 'DE', '1', '51.193531', '14.519747', 1, 'true'),
('BBK', 'Kasane Arpt', 'BBK', 'Kasane', 'BOTSWANA', 'BW', '2', '-17.832875', '25.1624', 1, 'true'),
('BBN', 'Bario Arpt', 'BBN', 'Bario', 'MALAYSIA', 'MY', '8', '3.73389', '115.479', 1, 'true'),
('BBR', 'Baillif Arpt', 'BBR', 'Basse Terre', 'GUADELOUPE', 'GP', '-4', '16.0133', '-61.7422', 1, 'true'),
('BBW', 'Broken Bow Municipal', 'BBW', 'Broken Bow', 'UNITED STATES', 'US', '-100', '41.4367', '-99.6417', 1, 'true'),
('BCB', 'Virginia Tech Arpt', 'BCB', 'Blacksburg', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BCD', 'Bacolod Arpt', 'BCD', 'Bacolod', 'PHILIPPINES', 'PH', '8', '10.642511', '122.929617', 1, 'true'),
('BCE', 'Bryce Arpt', 'BCE', 'Bryce', 'UNITED STATES', 'US', '-7', '37.706444', '-112.145806', 1, 'true'),
('BCH', 'English Madeira Arpt', 'BCH', 'Baucau', 'TIMOR-LESTE', 'TL', '-100', '-8.4854', '126.3993', 1, 'true'),
('BCI', 'Barcaldine Arpt', 'BCI', 'Barcaldine', 'AUSTRALIA', 'AU', '10', '-23.5653', '145.307', 1, 'true'),
('BCM', 'Bacau Arpt', 'BCM', 'Bacau', 'ROMANIA', 'RO', '2', '46.521946', '26.910278', 1, 'true'),
('BCN', 'Barcelona Arpt', 'BCN', 'Barcelona', 'SPAIN', 'ES', '1', '41.297078', '2.078464', 1, 'true'),
('BDA', 'Bermuda International', 'BDA', 'Bermuda', 'BERMUDA', 'BM', '-4', '32.364042', '-64.678703', 1, 'true'),
('BDB', 'Bundaberg Arpt', 'BDB', 'Bundaberg', 'AUSTRALIA', 'AU', '10', '-24.903889', '152.318611', 1, 'true'),
('BDD', 'Badu Island Arpt', 'BDD', 'Badu Island', 'AUSTRALIA', 'AU', '9', '-10.15', '141.175', 1, 'true'),
('BDJ', 'Sjamsudin Noor Arpt', 'BDJ', 'Banjarmasin', 'INDONESIA', 'ID', '8', '-3.442356', '114.762553', 1, 'true'),
('BDM', 'Bandirma Arpt', 'BDM', 'Bandirma Arpt', 'TURKEY', 'TR', '2', '40.317972', '27.977694', 1, 'true'),
('BDO', 'Husein Sastranegara Arpt', 'BDO', 'Bandung', 'INDONESIA', 'ID', '7', '-6.900625', '107.576294', 1, 'true'),
('BDQ', 'Vadodara Arpt', 'BDQ', 'Vadodara', 'INDIA', 'IN', '5', '22.336164', '73.226289', 1, 'true'),
('BDR', 'Sikorsky Memorial Arpt', 'BDR', 'Bridgeport', 'UNITED STATES', 'US', '-5', '41.163472', '-73.126167', 1, 'true'),
('BDS', 'Papola Casale Arpt', 'BDS', 'Brindisi', 'ITALY', 'IT', '1', '40.657633', '17.947033', 1, 'true'),
('BDU', 'Bardufoss Arpt', 'BDU', 'Bardufoss', 'NORWAY', 'NO', '1', '69.055758', '18.540356', 1, 'true'),
('BEB', 'Benbecula Arpt', 'BEB', 'Benbecula', 'UNITED KINGDOM', 'GB', '0', '57.481111', '-7.362778', 1, 'true'),
('BED', 'Bedford Arpt', 'BED', 'Bedford', 'UNITED STATES', 'US', '-5', '42.469953', '-71.289031', 1, 'true'),
('BJY', 'Batajnica Arpt', 'BEG', 'Belgrade', 'SERBIA', 'RS', '-100', '44.9236', '20.279', 2, ''),
('BEG', 'Belgrade Beograd Arpt', 'BEG', 'Belgrade', 'SERBIA', 'RS', '1', '44.818444', '20.309139', 2, 'true'),
('BEH', 'Ross Field', 'BEH', 'Benton Harbor', 'UNITED STATES', 'US', '-5', '42.128583', '-86.4285', 1, 'true'),
('BEL', 'Val De Cans Arpt', 'BEL', 'Belem', 'BRAZIL', 'BR', '-3', '-1.37925', '-48.476292', 1, 'true'),
('BEN', 'Benina Intl Arpt', 'BEN', 'Benghazi', 'LIBYAN ARAB JAMAHIRIYA', 'LY', '1', '32.096786', '20.269472', 1, 'true'),
('BEQ', 'Honington Arpt', 'BEQ', 'Bury St Edmunds', 'UNITED KINGDOM', 'GB', '0', '52.342611', '0.772939', 1, 'true'),
('BML', 'Berlin Arpt', 'BER', 'Berlin', 'GERMANY', 'DE', '-4', '44.574722', '-71.17639', 3, ''),
('SXF', 'Schoenefeld Arpt', 'BER', 'Berlin', 'GERMANY', 'DE', '1', '52.380001', '13.5225', 3, ''),
('TXL', 'Tegel Airport', 'BER', 'Berlin', 'GERMANY', 'DE', '1', '52.559686', '13.287711', 3, ''),
('BES', 'Guipavas Arpt', 'BES', 'Brest', 'FRANCE', 'FR', '1', '48.447911', '-4.418539', 1, 'true'),
('BET', 'Bethel Airport', 'BET', 'Bethel', 'UNITED STATES', 'US', '-9', '60.779778', '-161.838', 1, 'true'),
('BEU', 'Bedourie Arpt', 'BEU', 'Bedourie', 'AUSTRALIA', 'AU', '10', '-24.3461', '139.46', 1, 'true'),
('BEW', 'Beira Arpt', 'BEW', 'Beira', 'MOZAMBIQUE', 'MZ', '2', '-19.796419', '34.907556', 1, 'true'),
('BEY', 'Beirut Intl Arpt', 'BEY', 'Beirut', 'LEBANON', 'LB', '2', '33.820931', '35.488389', 1, 'true'),
('BEZ', 'Beru Arpt', 'BEZ', 'Beru', 'KIRIBATI', 'KI', '10', '-1.254722', '176.007222', 1, 'true'),
('BFD', 'Bradford Regional Arpt', 'BFD', 'Bradford', 'UNITED STATES', 'US', '-5', '41.8031', '-78.6401', 1, 'true'),
('BFE', 'Bielefeld Arpt', 'BFE', 'Bielefeld', 'GERMANY', 'DE', '-100', '0', '0', 1, 'true'),
('BFF', 'Scottsbluff Municipal', 'BFF', 'Scottsbluff', 'UNITED STATES', 'US', '-7', '41.874', '-103.596', 1, 'true'),
('BFG', 'Bullfrog Basin Arpt', 'BFG', 'Bullfrog Basin', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BFJ', 'Ba Arpt', 'BFJ', 'Ba City', 'FIJI', 'FJ', '-100', '0', '0', 1, 'true'),
('BFL', 'Meadows Field', 'BFL', 'Bakersfield', 'UNITED STATES', 'US', '-8', '35.433598', '-119.05677', 1, 'true'),
('BFN', 'Bloemfontein International', 'BFN', 'Bloemfontein', 'SOUTH AFRICA', 'ZA', '2', '-29.092722', '26.302444', 1, 'true'),
('BFP', 'Beaver Falls Arpt', 'BFP', 'Beaver Falls', 'UNITED STATES', 'US', '-100', '40.7725', '-80.3915', 1, 'true'),
('BFR', 'Virgil I Grissom Municipal', 'BFR', 'Bedford', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BFS', 'Belfast Intl Arpt', 'BFS', 'Belfast', 'UNITED KINGDOM', 'GB', '0', '54.6575', '-6.215833', 2, 'true'),
('BHD', 'Belfast City Arpt', 'BFS', 'Belfast', 'UNITED KINGDOM', 'GB', '0', '54.618056', '-5.8725', 2, ''),
('BFT', 'Beaufort County Arpt', 'BFT', 'Beaufort', 'UNITED STATES', 'US', '-5', '32.41083', '-80.635', 1, 'true'),
('BFV', 'Buri Ram Arpt', 'BFV', 'Buri Ram', 'THAILAND', 'TH', '7', '15.229539', '103.253231', 1, 'true'),
('BGA', 'Palo Negro Arpt', 'BGA', 'Bucaramanga', 'COLOMBIA', 'CO', '-5', '7.1265', '-73.184778', 1, 'true'),
('BGC', 'Braganca Arpt', 'BGC', 'Braganca', 'PORTUGAL', 'PT', '0', '41.8578', '-6.707125', 1, 'true'),
('BGF', 'Bangui Airport', 'BGF', 'Bangui', 'CENTRAL AFRICAN REPUBLIC', 'CF', '1', '4.398475', '18.518786', 1, 'true'),
('BGI', 'Grantley Adams Intl Arpt', 'BGI', 'Bridgetown', 'BARBADOS', 'BB', '-4', '13.074603', '-59.492456', 1, 'true'),
('BGM', 'Edwin A Link Field', 'BGM', 'Binghamton', 'UNITED STATES', 'US', '-5', '42.208689', '-75.979839', 1, 'true'),
('XKN', 'Finse Rail Station', 'BGO', 'Bergen', 'NORWAY', 'NO', '-100', '0', '0', 3, ''),
('BGO', 'Flesland Airport', 'BGO', 'Bergen', 'NORWAY', 'NO', '1', '60.293386', '5.218142', 3, 'true'),
('XVK', 'Voss Rail Station', 'BGO', 'Bergen', 'NORWAY', 'NO', '-100', '0', '0', 3, ''),
('BGR', 'Bangor Intl Arpt', 'BGR', 'Bangor', 'UNITED STATES', 'US', '-5', '44.807444', '-68.828139', 1, 'true'),
('BGV', 'Bento Goncalves Arpt', 'BGV', 'Bento Goncalves', 'BRAZIL', 'BR', '-100', '0', '0', 1, 'true'),
('BGW', 'Baghdad International Arpt', 'BGW', 'Baghdad', 'IRAQ', 'IQ', '3', '33.262539', '44.234578', 1, 'true'),
('BGY', 'Orio Al Serio Arpt', 'BGY', 'Bergamo', 'ITALY', 'IT', '1', '45.673889', '9.704166', 1, 'true'),
('BHB', 'Hancock County', 'BHB', 'Bar Harbor', 'UNITED STATES', 'US', '-5', '44.449769', '-68.361565', 1, 'true'),
('BHE', 'Woodbourne Arpt', 'BHE', 'Blenheim', 'NEW ZEALAND', 'NZ', '12', '-41.518333', '173.870278', 1, 'true'),
('BHI', 'Commandante Airport', 'BHI', 'Bahia Blanca', 'ARGENTINA', 'AR', '-3', '-38.724967', '-62.169317', 1, 'true'),
('BHJ', 'Rudra Mata Arpt', 'BHJ', 'Bhuj', 'INDIA', 'IN', '5', '23.287828', '69.670147', 1, 'true'),
('BHK', 'Bukhara Arpt', 'BHK', 'Bukhara', 'UZBEKISTAN', 'UZ', '5', '39.775', '64.483333', 1, 'true'),
('BHL', 'Bahia De Los Angeles Arpt', 'BHL', 'Bahia De Los Angeles', 'MEXICO', 'MX', '-100', '0', '0', 1, 'true'),
('BHM', 'Birmingham International Arpt', 'BHM', 'Birmingham', 'UNITED STATES', 'US', '-6', '33.562942', '-86.75355', 1, 'true'),
('BHO', 'Raja Bhoj Arpt', 'BHO', 'Bhopal', 'INDIA', 'IN', '5', '23.287467', '77.337375', 1, 'true'),
('BHQ', 'Broken Hill Arpt', 'BHQ', 'Broken Hill', 'AUSTRALIA', 'AU', '9', '-32.0014', '141.472', 1, 'true'),
('BHS', 'Raglan Airport', 'BHS', 'Bathurst', 'AUSTRALIA', 'AU', '10', '-33.4094', '149.652', 1, 'true'),
('BHU', 'Bhavnagar Arpt', 'BHU', 'Bhavnagar', 'INDIA', 'IN', '5', '21.752206', '72.185181', 1, 'true'),
('BHV', 'Bahawalpur Arpt', 'BHV', 'Bahawalpur', 'PAKISTAN', 'PK', '5', '29.4', '71.683334', 1, 'true'),
('XVB', 'Stafford Rail Station', 'BHX', 'Birmingham', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 4, ''),
('XNV', 'Nuneaton Rail Station', 'BHX', 'Birmingham', 'UNITED KINGDOM', 'GB', '-100', '31.2083', '35.0123', 4, ''),
('QQN', 'Birmingham - New Street Rail Service', 'BHX', 'Birmingham', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 4, ''),
('BHX', 'Birmingham Intl Arpt', 'BHX', 'Birmingham', 'UNITED KINGDOM', 'GB', '0', '52.453856', '-1.748028', 4, 'true'),
('BHY', 'Beihai Airport', 'BHY', 'Beihai', 'CHINA', 'CN', '8', '21.5394', '109.294', 1, 'true'),
('PLU', 'Pampulha Arpt', 'BHZ', 'Belo Horizonte', 'BRAZIL', 'BR', '-3', '-19.851181', '-43.950628', 2, ''),
('CNF', 'Tancredo Neves Intl Arpt', 'BHZ', 'Belo Horizonte', 'BRAZIL', 'BR', '-3', '-19.63375', '-43.968856', 2, ''),
('BIA', 'Poretta Airport', 'BIA', 'Bastia', 'FRANCE', 'FR', '1', '42.552664', '9.483731', 1, 'true'),
('BID', 'Block Island Municipal', 'BID', 'Block Island', 'UNITED STATES', 'US', '-5', '41.168056', '-71.577778', 1, 'true'),
('BIH', 'Bishop Airport', 'BIH', 'Bishop', 'UNITED STATES', 'US', '-100', '37.3731', '-118.3636', 1, 'true'),
('BII', 'Enyu Airfield', 'BII', 'Bikini Atoll', 'MARSHALL ISLANDS', 'MH', '12', '11.5225', '165.565', 1, 'true'),
('BIK', 'Mokmer Arpt', 'BIK', 'Biak', 'INDONESIA', 'ID', '9', '-1.190017', '136.107997', 1, 'true'),
('BIL', 'Logan Field', 'BIL', 'Billings', 'UNITED STATES', 'US', '-7', '45.80921', '-108.537654', 1, 'true'),
('BIM', 'Bimini Airport', 'BIM', 'Bimini', 'BAHAMAS', 'BS', '-5', '25.699881', '-79.264656', 2, 'true'),
('NSB', 'North Seaplane Base', 'BIM', 'Bimini', 'BAHAMAS', 'BS', '-5', '25.767', '-79.25', 2, ''),
('BIO', 'Bilbao Arpt', 'BIO', 'Bilbao', 'SPAIN', 'ES', '1', '43.301097', '-2.910608', 1, 'true'),
('BIQ', 'Bayonne Anglet Arpt', 'BIQ', 'Biarritz', 'FRANCE', 'FR', '1', '43.468419', '-1.523325', 1, 'true'),
('BIS', 'Bismarck Municipal Arpt', 'BIS', 'Bismarck', 'UNITED STATES', 'US', '-6', '46.775842', '-100.757931', 1, 'true'),
('BIY', 'Bisho Arpt', 'BIY', 'Bisho', 'SOUTH AFRICA', 'ZA', '-100', '-32.895', '27.285', 1, 'true'),
('BJA', 'Bejaia Arpt', 'BJA', 'Bejaia', 'ALGERIA', 'DZ', '1', '36.711997', '5.069922', 1, 'true'),
('BJC', 'Jeffco Arpt', 'BJC', 'Broomfield', 'UNITED STATES', 'US', '-7', '39.908889', '-105.117222', 1, 'true'),
('BJF', 'Batsfjord Arpt', 'BJF', 'Batsfjord', 'NORWAY', 'NO', '1', '70.600278', '29.6925', 1, 'true'),
('BJI', 'Bemidji Municipal Arpt', 'BJI', 'Bemidji', 'UNITED STATES', 'US', '-6', '47.510722', '-94.934722', 1, 'true'),
('BJL', 'Yundum Intl Arpt', 'BJL', 'Banjul', 'GAMBIA', 'GM', '0', '13.337961', '-16.652206', 1, 'true'),
('BJM', 'Bujumbura Intl Arpt', 'BJM', 'Bujumbura', 'BURUNDI', 'BI', '2', '-3.324019', '29.318519', 1, 'true'),
('BJR', 'Bahar Dar Arpt', 'BJR', 'Bahar Dar', 'ETHIOPIA', 'ET', '3', '11.608075', '37.321644', 1, 'true'),
('NAY', 'Nanyuan Arpt', 'BJS', 'Beijing', 'CHINA', 'CN', '8', '39.7825', '116.387778', 2, ''),
('PEK', 'Beijing Capital Arpt', 'BJS', 'Beijing', 'CHINA', 'CN', '8', '40.080111', '116.584556', 2, ''),
('BJX', 'Del Bajio Arpt', 'BJX', 'Leon', 'MEXICO', 'MX', '-6', '20.993464', '-101.480847', 1, 'true'),
('BJZ', 'Talaveral La Real Arpt', 'BJZ', 'Badajoz', 'SPAIN', 'ES', '1', '38.89125', '-6.821333', 1, 'true'),
('BKB', 'Bikaner Arpt', 'BKB', 'Bikaner', 'INDIA', 'IN', '-100', '0', '0', 1, 'true'),
('BKG', 'Branson Regional Arpt', 'BKG', 'Branson', 'UNITED STATES', 'US', '-6', '36.531994', '-93.200556', 1, 'true'),
('BKI', 'Kota Kinabalu Arpt', 'BKI', 'Kota Kinabalu', 'MALAYSIA', 'MY', '8', '5.937208', '116.051181', 1, 'true'),
('DMK', 'Don Mueang International Arpt', 'BKK', 'Bangkok', 'THAILAND', 'TH', '7', '13.912583', '100.60675', 2, ''),
('BKK', 'Suvarnabhumi Intl Arpt', 'BKK', 'Bangkok', 'THAILAND', 'TH', '7', '13.681108', '100.747283', 2, 'true'),
('BKM', 'Bakalalan Arpt', 'BKM', 'Bakalalan', 'MALAYSIA', 'MY', '8', '3.974', '115.618', 1, 'true'),
('BKO', 'Senou Airport', 'BKO', 'Bamako', 'MALI', 'ML', '0', '12.533544', '-7.949944', 1, 'true'),
('BKQ', 'Blackall Arpt', 'BKQ', 'Blackall', 'AUSTRALIA', 'AU', '10', '-24.427778', '145.428611', 1, 'true'),
('BKS', 'Padangkemiling Arpt', 'BKS', 'Bengkulu', 'INDONESIA', 'ID', '7', '-3.8637', '102.339036', 1, 'true'),
('BKW', 'Raleigh Cty Memorial', 'BKW', 'Beckley', 'UNITED STATES', 'US', '-5', '37.7873', '-81.1242', 1, 'true'),
('BKX', 'Brookings Municipal', 'BKX', 'Brookings', 'UNITED STATES', 'US', '-6', '44.3048', '-96.8169', 1, 'true'),
('BLA', 'Gen J A Anzoategui Arpt', 'BLA', 'Barcelona', 'VENEZUELA', 'VE', '-4', '10.107139', '-64.689161', 1, 'true'),
('XXO', 'Leksand Rail Station', 'BLE', 'Borlange', 'SWEDEN', 'SE', '-100', '28.615', '-80.695', 4, ''),
('XXU', 'Hedemora Rail Station', 'BLE', 'Borlange', 'SWEDEN', 'SE', '-100', '0', '0', 4, ''),
('XYB', 'Borlange Railway Service', 'BLE', 'Borlange', 'SWEDEN', 'SE', '-100', '0', '0', 4, ''),
('BLE', 'Dala Airport', 'BLE', 'Borlange', 'SWEDEN', 'SE', '1', '60.422017', '15.515211', 4, 'true'),
('BLF', 'Mercer County', 'BLF', 'Bluefield', 'UNITED STATES', 'US', '-5', '37.2958', '-81.2077', 1, 'true'),
('BLG', 'Belaga Arpt', 'BLG', 'Belaga', 'MALAYSIA', 'MY', '8', '2.65', '113.767', 1, 'true'),
('BLH', 'Blythe Airport', 'BLH', 'Blythe', 'UNITED STATES', 'US', '-8', '33.619167', '-114.716889', 1, 'true'),
('BLI', 'Bellingham Intl Arpt', 'BLI', 'Bellingham', 'UNITED STATES', 'US', '-8', '48.792694', '-122.537528', 1, 'true'),
('BLJ', 'Batna Arpt', 'BLJ', 'Batna', 'ALGERIA', 'DZ', '1', '35.752106', '6.308589', 1, 'true'),
('XQL', 'Lancaster Rail Station', 'BLK', 'Blackpool', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 2, ''),
('BLK', 'Blackpool Airport', 'BLK', 'Blackpool', 'UNITED KINGDOM', 'GB', '0', '53.771667', '-3.028611', 2, 'true'),
('BLL', 'Billund Airport', 'BLL', 'Billund', 'DENMARK', 'DK', '1', '55.740322', '9.151778', 1, 'true'),
('BLQ', 'Guglielmo Marconi', 'BLQ', 'Bologna', 'ITALY', 'IT', '1', '44.535444', '11.288667', 1, 'true'),
('BLR', 'Bengaluru Intl Arpt', 'BLR', 'Bangalore', 'INDIA', 'IN', '5', '12.949986', '77.668206', 1, 'true'),
('BLT', 'Blackwater Arpt', 'BLT', 'Blackwater', 'AUSTRALIA', 'AU', '10', '-23.6031', '148.807', 1, 'true'),
('BLV', 'Scott AFB Mid America', 'BLV', 'Belleville', 'UNITED STATES', 'US', '-6', '38.545178', '-89.835183', 1, 'true'),
('BLX', 'Belluno Arpt', 'BLX', 'Belluno', 'ITALY', 'IT', '-100', '0', '0', 1, 'true'),
('BLZ', 'Chileka Airport', 'BLZ', 'Blantyre', 'MALAWI', 'MW', '2', '-15.679053', '34.974014', 1, 'true'),
('BME', 'Broome Airport', 'BME', 'Broome', 'AUSTRALIA', 'AU', '8', '-17.8', '122.2', 1, 'true'),
('BMG', 'Monroe Cty Arpt Indiana', 'BMG', 'Bloomington', 'UNITED STATES', 'US', '-4', '39.146021', '-86.616681', 1, 'true'),
('BMI', 'Normal Airport', 'BMI', 'Bloomington', 'UNITED STATES', 'US', '-6', '40.477111', '-88.915917', 1, 'true'),
('BMP', 'Brampton Island Arpt', 'BMP', 'Brampton Island', 'AUSTRALIA', 'AU', '-100', '0', '0', 1, 'true'),
('BMV', 'Phung Duc Arpt', 'BMV', 'Banmethuot', 'VIET NAM', 'VN', '7', '12.668311', '108.120272', 1, 'true'),
('BNA', 'Nashville International Arpt', 'BNA', 'Nashville', 'UNITED STATES', 'US', '-6', '36.124472', '-86.678194', 1, 'true'),
('BND', 'Bandar Abbas Arpt', 'BND', 'Bandar Abbas', 'IRAN', 'IR', '4', '27.218317', '56.37785', 1, 'true'),
('BNE', 'Brisbane Arpt', 'BNE', 'Brisbane', 'AUSTRALIA', 'AU', '10', '-27.384167', '153.1175', 1, 'true'),
('BNJ', 'Bonn Railroad Station', 'BNJ', 'Bonn', 'GERMANY', 'DE', '-100', '50.7319', '7.0967', 1, 'true'),
('BNK', 'Ballina Arpt', 'BNK', 'Ballina', 'AUSTRALIA', 'AU', '10', '-28.833889', '153.5625', 1, 'true'),
('BNN', 'Bronnoy Arpt', 'BNN', 'Bronnoysund', 'NORWAY', 'NO', '1', '65.461111', '12.2175', 1, 'true'),
('BNO', 'Burns Municipal Arpt', 'BNO', 'Burns', 'UNITED STATES', 'US', '-100', '43.5919', '-118.9554', 1, 'true'),
('BNU', 'Blumenau Arpt', 'BNU', 'Blumenau', 'BRAZIL', 'BR', '-3', '-26.834239', '-49.091696', 1, 'true'),
('BNX', 'Banja Luka Arpt', 'BNX', 'Banja Luka', 'BOSNIA AND HERZEGOVINA', 'BA', '1', '44.941444', '17.297501', 1, 'true'),
('BOB', 'Motu Mute Arpt', 'BOB', 'Bora Bora', 'FRENCH POLYNESIA', 'PF', '-10', '-16.444378', '-151.751286', 1, 'true'),
('BOC', 'Bocas Del Toro Arpt', 'BOC', 'Bocas Del Toro', 'PANAMA', 'PA', '-5', '9.340853', '-82.250842', 1, 'true'),
('ZFQ', 'Gare de Bordeaux', 'BOD', 'Bordeaux', 'FRANCE', 'FR', '-100', '48.6833', '1.1', 2, ''),
('BOD', 'Bordeaux Arpt', 'BOD', 'Bordeaux', 'FRANCE', 'FR', '1', '44.828335', '-0.715556', 2, 'true'),
('BOG', 'Eldorado Airport', 'BOG', 'Bogota', 'COLOMBIA', 'CO', '-5', '4.701594', '-74.146947', 1, 'true'),
('BOH', 'Bournemouth Intl Arpt', 'BOH', 'Bournemouth', 'UNITED KINGDOM', 'GB', '0', '50.78', '-1.8425', 1, 'true'),
('BOI', 'Boise Municipal Arpt Gowen Field', 'BOI', 'Boise', 'UNITED STATES', 'US', '-7', '43.564361', '-116.222861', 1, 'true'),
('BOJ', 'Bourgas Arpt', 'BOJ', 'Bourgas', 'BULGARIA', 'BG', '2', '42.569583', '27.515236', 1, 'true'),
('BOK', 'Brookings State Arpt', 'BOK', 'Brookings', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BOM', 'Chhatrapati Shivaji', 'BOM', 'Mumbai', 'INDIA', 'IN', '5', '19.088686', '72.867919', 1, 'true'),
('BON', 'Flamingo Field', 'BON', 'Bonaire', 'NETHERLANDS ANTILLES', 'AN', '-4', '12.131044', '-68.268511', 1, 'true'),
('BOO', 'Bodo Arpt', 'BOO', 'Bodo', 'NORWAY', 'NO', '1', '67.269167', '14.365278', 2, 'true'),
('ZXM', 'Rognan Rail Station', 'BOO', 'Bodo', 'NORWAY', 'NO', '-100', '0', '0', 2, ''),
('BOS', 'Logan Intl Arpt', 'BOS', 'Boston', 'UNITED STATES', 'US', '-5', '42.364347', '-71.005181', 1, 'true'),
('BOU', 'Bourges Arpt', 'BOU', 'Bourges', 'FRANCE', 'FR', '1', '47.058056', '2.370278', 1, 'true'),
('BOW', 'Bartow Arpt', 'BOW', 'Bartow', 'UNITED STATES', 'US', '-6', '27.9434', '-81.7834', 1, 'true'),
('BOX', 'Borroloola Arpt', 'BOX', 'Borroloola', 'AUSTRALIA', 'AU', '3', '51.478506', '7.2222', 1, 'true'),
('BOY', 'Borgo Arpt', 'BOY', 'Bobo Dioulasso', 'BURKINA FASO', 'BF', '0', '11.160056', '-4.330969', 1, 'true'),
('BPN', 'Sepingan Arpt', 'BPN', 'Balikpapan', 'INDONESIA', 'ID', '8', '-1.268272', '116.894478', 1, 'true'),
('BPS', 'Porto Seguro Arpt', 'BPS', 'Porto Seguro', 'BRAZIL', 'BR', '-3', '-16.438611', '-39.080833', 1, 'true'),
('BPT', 'Jefferson Cty Arpt', 'BPT', 'Beaumont', 'UNITED STATES', 'US', '-6', '29.950833', '-94.020694', 1, 'true'),
('BQB', 'Busselton Arpt', 'BQB', 'Busselton', 'AUSTRALIA', 'AU', '-100', '-33.6867', '115.4', 1, 'true'),
('BQK', 'Gylnco Jet Port', 'BQK', 'Brunswick', 'UNITED STATES', 'US', '-5', '31.2588', '-81.4665', 1, 'true'),
('BQL', 'Boulia Arpt', 'BQL', 'Boulia', 'AUSTRALIA', 'AU', '10', '-22.9133', '139.9', 1, 'true'),
('BQN', 'Borinquen Municipal Arpt', 'BQN', 'Aguadilla', 'UNITED STATES', 'US', '-4', '18.494861', '-67.129444', 1, 'true'),
('BQS', 'Blagoveshchensk Arpt', 'BQS', 'Blagoveshchensk', 'RUSSIA', 'RU', '10', '50.425394', '127.412478', 1, 'true'),
('BQT', 'Brest Arpt', 'BQT', 'Brest', 'BELARUS', 'BY', '2', '52.06', '23.53', 1, 'true'),
('BRA', 'Barreiras Arpt', 'BRA', 'Barreiras', 'BRAZIL', 'BR', '-3', '-12.083333', '-45', 1, 'true'),
('BRC', 'San Carlos De Bariloche Intl Arpt', 'BRC', 'San Carlos Bariloche', 'ARGENTINA', 'AR', '-3', '-41.151172', '-71.157542', 1, 'true'),
('BRD', 'Crowwing Cty Arpt', 'BRD', 'Brainerd', 'UNITED STATES', 'US', '-6', '46.398308', '-94.138078', 1, 'true'),
('BRE', 'Bremen Airport', 'BRE', 'Bremen', 'GERMANY', 'DE', '1', '53.0475', '8.786667', 1, 'true'),
('BRF', 'Bradford Rail Station', 'BRF', 'Bradford', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 1, 'true'),
('BRI', 'Bari Airport', 'BRI', 'Bari', 'ITALY', 'IT', '1', '41.138856', '16.760594', 1, 'true'),
('BRK', 'Bourke Airport', 'BRK', 'Bourke', 'AUSTRALIA', 'AU', '10', '-30.0392', '145.952', 1, 'true'),
('BRL', 'Burlington Municipal Arpt', 'BRL', 'Burlington', 'UNITED STATES', 'US', '-6', '40.7832', '-91.1255', 1, 'true'),
('BRM', 'Airport Barquisimeto', 'BRM', 'Barquisimeto', 'VENEZUELA', 'VE', '-4', '10.042747', '-69.358619', 1, 'true'),
('BRN', 'Belp Airport', 'BRN', 'Berne', 'SWITZERLAND', 'CH', '1', '46.9141', '7.497153', 2, 'true'),
('ZDJ', 'Berne Railroad Station', 'BRN', 'Berne', 'SWITZERLAND', 'CH', '-100', '0', '0', 2, ''),
('BRO', 'South Padre Island Intl Arpt', 'BRO', 'Brownsville', 'UNITED STATES', 'US', '-6', '25.906833', '-97.425861', 1, 'true'),
('BRQ', 'Turnay Arpt', 'BRQ', 'Brno', 'CZECH REPUBLIC', 'CZ', '1', '49.151269', '16.694433', 1, 'true'),
('BRR', 'North Bay Arpt', 'BRR', 'Barra', 'UNITED KINGDOM', 'GB', '0', '57.0228', '-7.44306', 1, 'true'),
('BRS', 'Bristol Intl Arpt', 'BRS', 'Bristol', 'UNITED KINGDOM', 'GB', '0', '51.382669', '-2.719089', 1, 'true'),
('BRT', 'Bathurst Island Arpt', 'BRT', 'Bathurst Isl', 'AUSTRALIA', 'AU', '9', '-11.769167', '130.619722', 1, 'true'),
('CRL', 'Brussels South Charleroi Arpt', 'BRU', 'Brussels', 'BELGIUM', 'BE', '1', '50.459197', '4.453817', 4, ''),
('ZYR', 'Midi Railway Station', 'BRU', 'Brussels', 'BELGIUM', 'BE', '1', '50.8', '4.4', 4, ''),
('ZYZ', 'Antwerp Berchem Rail Station', 'BRU', 'Brussels', 'BELGIUM', 'BE', '-100', '51.2167', '4.4167', 4, ''),
('BRU', 'Brussels National Arpt', 'BRU', 'Brussels', 'BELGIUM', 'BE', '1', '50.901389', '4.484444', 4, 'true'),
('BRV', 'Bremerhaven Arpt', 'BRV', 'Bremerhaven', 'GERMANY', 'DE', '1', '53.507081', '8.572878', 1, 'true'),
('BRW', 'Barrow WBAS', 'BRW', 'Barrow', 'UNITED STATES', 'US', '-9', '71.285446', '-156.766003', 1, 'true'),
('BRX', 'Barahona Arpt', 'BRX', 'Barahona', 'DOMINICAN REPUBLIC', 'DO', '-4', '18.251464', '-71.1204', 1, 'true'),
('BSB', 'Brasilia Intl Arpt', 'BSB', 'Brasilia', 'BRAZIL', 'BR', '-3', '-15.8711', '-47.918625', 1, 'true'),
('BSD', 'Baoshan Arpt', 'BSD', 'Baoshan', 'CHINA', 'CN', '8', '25.053333', '99.168333', 1, 'true'),
('BSH', 'Brighton Airport', 'BSH', 'Brighton', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 1, 'true'),
('BSI', 'Blairsville Arpt', 'BSI', 'Blairsville', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BSJ', 'Bairnsdale Airport', 'BSJ', 'Bairnsdale', 'AUSTRALIA', 'AU', '-100', '-37.8883', '147.5683', 1, 'true'),
('BSK', 'Biskra Arpt', 'BSK', 'Biskra', 'ALGERIA', 'DZ', '1', '34.793289', '5.738231', 1, 'true'),
('BSL', 'Basel EuroAirport Swiss', 'BSL', 'Basel', 'SWITZERLAND', 'CH', '1', '47.59', '7.529167', 1, 'true'),
('BSQ', 'Bisbee Municipal Arpt', 'BSQ', 'Bisbee', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BSR', 'Basra Intl Arpt', 'BSR', 'Basra', 'IRAQ', 'IQ', '3', '30.549069', '47.662142', 1, 'true'),
('BTH', 'Hang Nadim Arpt', 'BTH', 'Batam', 'INDONESIA', 'ID', '7', '1.121028', '104.118753', 1, 'true'),
('BTJ', 'Blang Bintang Arpt', 'BTJ', 'Banda Aceh', 'INDONESIA', 'ID', '7', '5.523522', '95.420372', 1, 'true'),
('BTK', 'Bratsk Arpt', 'BTK', 'Bratsk', 'RUSSIA', 'RU', '9', '56.370556', '101.698331', 1, 'true'),
('BTL', 'WK Kellogg Regional', 'BTL', 'Battle Creek', 'UNITED STATES', 'US', '-100', '42.3075', '-85.2517', 1, 'true'),
('BTM', 'Bert Mooney Arpt', 'BTM', 'Butte', 'UNITED STATES', 'US', '-7', '45.954806', '-112.497472', 1, 'true'),
('EBR', 'Baton Rouge Downtown Arpt', 'BTR', 'Baton Rouge', 'UNITED STATES', 'US', '-100', '0', '0', 2, ''),
('BTR', 'Ryan Airport', 'BTR', 'Baton Rouge', 'UNITED STATES', 'US', '-6', '30.533167', '-91.149639', 2, 'true'),
('ZRG', 'Bratislava Bus Station', 'BTS', 'Bratislava', 'SLOVAKIA', 'SK', '-100', '0', '0', 2, ''),
('BTS', 'Ivanka Arpt', 'BTS', 'Bratislava', 'SLOVAKIA', 'SK', '1', '48.170167', '17.212667', 2, 'true'),
('BTT', 'Bettles Arpt', 'BTT', 'Bettles', 'UNITED STATES', 'US', '-9', '66.913944', '-151.529056', 1, 'true'),
('BTU', 'Bintulu Arpt', 'BTU', 'Bintulu', 'MALAYSIA', 'MY', '8', '3.12385', '113.020472', 1, 'true'),
('BTV', 'Burlington Intl Arpt', 'BTV', 'Burlington', 'UNITED STATES', 'US', '-5', '44.471861', '-73.153278', 1, 'true'),
('YEI', 'Yenisehir Arpt', 'BTZ', 'Bursa', 'TURKEY', 'TR', '2', '40.255208', '29.562569', 2, ''),
('BTZ', 'Bursa Arpt', 'BTZ', 'Bursa', 'TURKEY', 'TR', '2', '40.2489', '29.5494', 2, 'true'),
('BUC', 'Burketown Arpt', 'BUC', 'Burketown', 'AUSTRALIA', 'AU', '10', '-17.7486', '139.534', 1, 'true'),
('BUD', 'Ferihegy Arpt', 'BUD', 'Budapest', 'HUNGARY', 'HU', '1', '47.436933', '19.255592', 1, 'true'),
('EZE', 'Ministro Pistarini', 'BUE', 'Buenos Aires', 'ARGENTINA', 'AR', '-3', '-34.822222', '-58.535833', 2, ''),
('AEP', 'Jorge Newbery', 'BUE', 'Buenos Aires', 'ARGENTINA', 'AR', '-3', '-34.559175', '-58.415606', 2, ''),
('BUF', 'Greater Buffalo Intl Arpt', 'BUF', 'Buffalo', 'UNITED STATES', 'US', '-5', '42.940525', '-78.732167', 1, 'true'),
('OTP', 'Otopeni International', 'BUH', 'Bucharest', 'ROMANIA', 'RO', '2', '44.572161', '26.102178', 2, ''),
('BBU', 'Baneasa Airport', 'BUH', 'Bucharest', 'ROMANIA', 'RO', '2', '44.503194', '26.102111', 2, ''),
('BUN', 'Buenaventura Arpt', 'BUN', 'Buenaventura', 'COLOMBIA', 'CO', '-5', '3.819628', '-76.989767', 1, 'true'),
('BUQ', 'Bulawayo Arpt', 'BUQ', 'Bulawayo', 'ZIMBABWE', 'ZW', '2', '-20.017431', '28.617869', 1, 'true'),
('BUR', 'Burbank Glendale Pasadena Arpt', 'BUR', 'Burbank', 'UNITED STATES', 'US', '-8', '34.200667', '-118.358667', 1, 'true'),
('BUS', 'Batumi Arpt', 'BUS', 'Batumi', 'GEORGIA', 'GE', '2', '41.610278', '41.599694', 1, 'true'),
('BUY', 'Bunbury Arpt', 'BUY', 'Bunbury', 'AUSTRALIA', 'AU', '-4', '36.048543', '-79.474889', 1, 'true'),
('BUZ', 'Bushehr Arpt', 'BUZ', 'Bushehr', 'IRAN', 'IR', '4', '28.944811', '50.834637', 1, 'true'),
('BVB', 'Boa Vista Arpt', 'BVB', 'Boa Vista', 'BRAZIL', 'BR', '-4', '2.846311', '-60.690069', 1, 'true'),
('BVC', 'Rabil Arpt', 'BVC', 'Boa Vista', 'CAPE VERDE', 'CV', '-1', '16.136531', '-22.888897', 1, 'true'),
('BVE', 'Laroche Airport', 'BVE', 'Brive La Gaill', 'FRANCE', 'FR', '1', '45.150833', '1.469167', 1, 'true'),
('BVH', 'Vilhena Arpt', 'BVH', 'Vilhena', 'BRAZIL', 'BR', '-4', '-12.694375', '-60.098269', 1, 'true'),
('BVI', 'Birdsville Arpt', 'BVI', 'Birdsville', 'AUSTRALIA', 'AU', '10', '-25.8975', '139.348', 1, 'true'),
('BVO', 'Bartlesville Municipal Arpt', 'BVO', 'Bartlesville', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BVR', 'Esperadinha', 'BVR', 'Brava', 'CAPE VERDE', 'CV', '-100', '0', '0', 1, 'true'),
('BVX', 'Batesville Municipal', 'BVX', 'Batesville', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BVY', 'Beverly Municipal Arpt', 'BVY', 'Beverly', 'UNITED STATES', 'US', '-100', '42.5842', '-70.9165', 1, 'true'),
('BWC', 'Brawley Arpt', 'BWC', 'Brawley', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BWD', 'Brownwood Municipal Arpt', 'BWD', 'Brownwood', 'UNITED STATES', 'US', '-6', '31.793611', '-98.9565', 1, 'true'),
('BWE', 'Braunschweig Arpt', 'BWE', 'Braunschweig', 'GERMANY', 'DE', '1', '52.319167', '10.556111', 1, 'true'),
('BWF', 'Walney Island', 'BWF', 'Barrow In Furness', 'UNITED KINGDOM', 'GB', '0', '54.131167', '-3.263667', 1, 'true'),
('BWG', 'Warren Cty Arpt', 'BWG', 'Bowling Green', 'UNITED STATES', 'US', '-5', '36.964528', '-86.419667', 1, 'true'),
('BWI', 'Baltimore Washington Intl Arpt', 'BWI', 'Baltimore', 'UNITED STATES', 'US', '-5', '39.175361', '-76.668333', 2, 'true'),
('APG', 'Phillips Army Air Field', 'BWI', 'Baltimore', 'UNITED STATES', 'US', '-5', '39.466219', '-76.168808', 2, ''),
('BWK', 'Bol Airport', 'BWK', 'Bol Airport', 'CROATIA', 'HR', '1', '43.285719', '16.679719', 1, 'true'),
('BWN', 'Brunei Intl Arpt', 'BWN', 'Bandar Seri Begawan', 'BRUNEI DARUSSALAM', 'BN', '8', '4.9442', '114.928353', 1, 'true'),
('BWO', 'Balakovo Airport', 'BWO', 'Balakovo Airport', 'RUSSIA', 'RU', '4', '51.8583', '47.7456', 1, 'true'),
('BWQ', 'Brewarrina Arpt', 'BWQ', 'Brewarrina', 'AUSTRALIA', 'AU', '-100', '-29.9756', '146.8156', 1, 'true'),
('BWT', 'Burnie Wynyard Arpt', 'BWT', 'Burnie', 'AUSTRALIA', 'AU', '10', '-40.9989', '145.731', 1, 'true'),
('BWU', 'Bankstown Aerodrome', 'BWU', 'Bankstown', 'AUSTRALIA', 'AU', '10', '-33.924444', '150.988333', 1, 'true'),
('BJV', 'Milas Arpt', 'BXN', 'Bodrum', 'TURKEY', 'TR', '2', '37.82', '28.204', 1, ''),
('BXS', 'Borrego Valley Arpt', 'BXS', 'Borrego Springs', 'UNITED STATES', 'US', '-7', '33.259028', '-116.320972', 1, 'true'),
('BXU', 'Butuan Arpt', 'BXU', 'Butuan', 'PHILIPPINES', 'PH', '8', '8.951322', '125.477972', 1, 'true'),
('BYF', 'Albert Arpt', 'BYF', 'Meaulte', 'FRANCE', 'FR', '-100', '49.97', '2.6928', 1, 'true'),
('BYI', 'Burley Arpt', 'BYI', 'Burley', 'UNITED STATES', 'US', '-100', '42.5433', '-113.7717', 1, 'true'),
('BYR', 'Laeso Airport', 'BYR', 'Laeso Island', 'DENMARK', 'DK', '-100', '57.2772', '11.0001', 1, 'true'),
('BYU', 'Bindlacher Berg Arpt', 'BYU', 'Bayreuth', 'GERMANY', 'DE', '1', '49.984428', '11.638569', 1, 'true'),
('BYW', 'Blakely Is Municipal', 'BYW', 'Blakely Island', 'UNITED STATES', 'US', '-8', '48.56025', '-122.80243', 1, 'true'),
('BZC', 'Buzios Arpt', 'BZC', 'Buzios', 'BRAZIL', 'BR', '-100', '-22.7656', '-41.965', 1, 'true'),
('TZA', 'Belize City Municipal', 'BZE', 'Belize City', 'BELIZE', 'BZ', '-6', '17.5344', '-88.298', 2, ''),
('BZE', 'Belize Intl Arpt', 'BZE', 'Belize City', 'BELIZE', 'BZ', '-6', '17.539144', '-88.308203', 2, 'true'),
('BZG', 'Bydgoszcz Arpt', 'BZG', 'Bydgoszcz', 'POLAND', 'PL', '1', '53.0968', '17.9777', 1, 'true'),
('BZH', 'Bumi Hills Arpt', 'BZH', 'Bumi Hills', 'ZIMBABWE', 'ZW', '-100', '0', '0', 1, 'true'),
('BZI', 'Balikesir', 'BZI', 'Balikesir', 'TURKEY', 'TR', '2', '39.619258', '27.925958', 2, 'true'),
('MQJ', 'Merkez Arpt', 'BZI', 'Balikesir', 'TURKEY', 'TR', '2', '0', '0', 2, ''),
('BZN', 'Gallatin Field', 'BZN', 'Bozeman', 'UNITED STATES', 'US', '-7', '45.777643', '-111.160151', 1, 'true'),
('BZO', 'Bolzano Arpt', 'BZO', 'Bolzano', 'ITALY', 'IT', '1', '46.460194', '11.326383', 1, 'true'),
('BZR', 'Beziers Vias Arpt', 'BZR', 'Beziers', 'FRANCE', 'FR', '1', '43.323522', '3.353903', 1, 'true'),
('BZT', 'Brazoria County Arpt', 'BZT', 'Brazoria', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('BZV', 'Maya Maya Arpt', 'BZV', 'Brazzaville', 'CONGO', 'CG', '1', '-4.2517', '15.253031', 1, 'true'),
('CAC', 'Cascavel Arpt', 'CAC', 'Cascavel', 'BRAZIL', 'BR', '-3', '-25.000339', '-53.500764', 1, 'true'),
('CAD', 'Wexford County Arpt', 'CAD', 'Cadillac', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('OGB', 'Orangeburg Municpal', 'CAE', 'Columbia', 'UNITED STATES', 'US', '-100', '0', '0', 2, ''),
('CAE', 'Columbia Metro Arpt', 'CAE', 'Columbia', 'UNITED STATES', 'US', '-5', '33.938833', '-81.119528', 2, 'true'),
('CAG', 'Elmas Airport', 'CAG', 'Cagliari', 'ITALY', 'IT', '1', '39.251469', '9.054283', 1, 'true'),
('CAI', 'Cairo Intl Arpt', 'CAI', 'Cairo', 'EGYPT', 'EG', '2', '30.121944', '31.405556', 1, 'true'),
('CAK', 'Akron Canton Regional Arpt', 'CAK', 'Akron', 'UNITED STATES', 'US', '-5', '40.916083', '-81.442194', 1, 'true'),
('CAL', 'Machrihanish Arpt', 'CAL', 'Campbelltown', 'UNITED KINGDOM', 'GB', '0', '55.4372', '-5.68639', 1, 'true'),
('CAM', 'Choreti Arpt', 'CAM', 'Camiri', 'BOLIVIA', 'BO', '-100', '0', '0', 1, 'true'),
('CAN', 'Baiyun Airport', 'CAN', 'Guangzhou', 'CHINA', 'CN', '8', '23.392436', '113.298786', 1, 'true'),
('CAP', 'Cap Haitien Numicipal', 'CAP', 'Cap Haitien', 'HAITI', 'HT', '-5', '19.732989', '-72.194739', 1, 'true'),
('CAR', 'Caribou Municipal Arpt', 'CAR', 'Caribou', 'UNITED STATES', 'US', '-4', '46.8715', '-68.017917', 1, 'true'),
('CMN', 'Mohamed V Arpt', 'CAS', 'Casablanca', 'MOROCCO', 'MA', '0', '33.367467', '-7.589967', 2, ''),
('CAS', 'Anfa Airport', 'CAS', 'Casablanca', 'MOROCCO', 'MA', '-100', '33.5533', '-7.6614', 2, 'true'),
('CAU', 'Caruaru Arpt', 'CAU', 'Caruaru', 'BRAZIL', 'BR', '-3', '-8.28239', '-36.0135', 1, 'true'),
('CAW', 'Bartolomeu Lisandro Arpt', 'CAW', 'Campos', 'BRAZIL', 'BR', '-3', '-21.698333', '-41.301669', 1, 'true'),
('XPF', 'Penrith Rail Station', 'CAX', 'Carlisle', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 2, ''),
('CAX', 'Carlisle Arpt', 'CAX', 'Carlisle', 'UNITED KINGDOM', 'GB', '0', '54.9375', '-2.809167', 2, 'true'),
('CAY', 'Rochambeau Airport', 'CAY', 'Cayenne', 'FRENCH GUIANA', 'GF', '-3', '4.819808', '-52.360447', 1, 'true'),
('CAZ', 'Cobar Arpt', 'CAZ', 'Cobar', 'AUSTRALIA', 'AU', '10', '-31.5383', '145.794', 1, 'true'),
('CBB', 'J Wilsterman Arpt', 'CBB', 'Cochabamba', 'BOLIVIA', 'BO', '-4', '-17.421058', '-66.177114', 1, 'true'),
('CBE', 'Cumberland Municipal Arpt', 'CBE', 'Cumberland', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CBF', 'Council Bluffs Municipal Arpt', 'CBF', 'Council Bluffs', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CBG', 'Cambridge Arpt', 'CBG', 'Cambridge', 'UNITED KINGDOM', 'GB', '0', '52.205', '0.175', 1, 'true'),
('CBK', 'Colby Municipal Arpt', 'CBK', 'Colby', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CBL', 'Ciudad Bolivar Arpt', 'CBL', 'Ciudad Bolivar', 'VENEZUELA', 'VE', '-4', '8.121898', '-63.537353', 1, 'true'),
('CBN', 'Penggung Arpt', 'CBN', 'Cirebon', 'INDONESIA', 'ID', '7', '-6.756144', '108.539672', 1, 'true'),
('CBO', 'Awang Arpt', 'CBO', 'Cotabato', 'PHILIPPINES', 'PH', '8', '7.165242', '124.209619', 1, 'true'),
('CBP', 'Coimbra Arpt', 'CBP', 'Coimbra', 'PORTUGAL', 'PT', '-100', '0', '0', 1, 'true'),
('CBR', 'Canberra Arpt', 'CBR', 'Canberra', 'AUSTRALIA', 'AU', '10', '-35.306944', '149.195', 1, 'true'),
('CBS', 'Oro Negro Arpt', 'CBS', 'Cabimas', 'VENEZUELA', 'VE', '-100', '0', '0', 1, 'true'),
('CCC', 'Cayo Coco Arpt', 'CCC', 'Cayo Coco', 'CUBA', 'CU', '-5', '22.5132', '-78.511', 1, 'true'),
('CCE', 'Grand Case Arpt', 'CCE', 'Saint Martin', 'GUADELOUPE', 'GP', '-100', '18.1006', '-63.0489', 1, 'true'),
('CCF', 'Salvaza', 'CCF', 'Carcassonne', 'FRANCE', 'FR', '1', '43.215978', '2.306317', 1, 'true'),
('CCJ', 'Kozhikode Arpt', 'CCJ', 'Kozhikode', 'INDIA', 'IN', '5', '11.136839', '75.9553', 1, 'true'),
('CCK', 'Cocos Islands Arpt', 'CCK', 'Cocos Islands', 'COCOS (KEELING) ISLANDS', 'CC', '6', '-12.1883', '96.8339', 1, 'true'),
('CCM', 'Criciuma Arpt', 'CCM', 'Criciuma', 'BRAZIL', 'BR', '-3', '-28.725817', '-49.424739', 1, 'true'),
('CCP', 'Carriel Sur Arpt', 'CCP', 'Concepcion', 'CHILE', 'CL', '-4', '-36.77265', '-73.063106', 1, 'true'),
('CCR', 'Buchanan Field', 'CCR', 'Concord', 'UNITED STATES', 'US', '-8', '37.989667', '-122.056889', 1, 'true'),
('CCS', 'Simon Bolivar Arpt', 'CCS', 'Caracas', 'VENEZUELA', 'VE', '-4', '10.603117', '-66.990583', 1, 'true'),
('CCU', 'Netaji Subhas Chandra Bose Intl', 'CCU', 'Kolkata', 'INDIA', 'IN', '5', '22.654739', '88.446722', 1, 'true'),
('CCV', 'Craig Cove Arpt', 'CCV', 'Craig Cove', 'VANUATU', 'VU', '11', '-16.265', '167.924', 1, 'true'),
('CDA', 'Cooinda Airport', 'CDA', 'Cooinda', 'AUSTRALIA', 'AU', '9', '-12.9033', '132.532', 1, 'true'),
('CDC', 'Cedar City Municipal', 'CDC', 'Cedar City', 'UNITED STATES', 'US', '-7', '37.700967', '-113.098847', 1, 'true'),
('CDD', 'Cauquira Arpt', 'CDD', 'Cauquira', 'HONDURAS', 'HN', '-100', '0', '0', 1, 'true'),
('CDH', 'Harrell Fieldsandro Arpt', 'CDH', 'Camden', 'UNITED STATES', 'US', '-100', '33.6233', '-92.7633', 1, 'true'),
('CDI', 'Cachoeiro De Itapemirim Arpt', 'CDI', 'Cachoeiro De Itapemirim', 'BRAZIL', 'BR', '-5', '39.975028', '-81.577583', 1, 'true'),
('CDR', 'Chadron Arpt', 'CDR', 'Chadron', 'UNITED STATES', 'US', '-7', '42.8375', '-103.095556', 1, 'true'),
('CDV', 'Mudhole Smith Arpt', 'CDV', 'Cordova', 'UNITED STATES', 'US', '-9', '60.491778', '-145.477556', 1, 'true'),
('CDW', 'Caldwell Wright Arpt', 'CDW', 'Caldwell', 'UNITED STATES', 'US', '-4', '40.875222', '-74.281361', 1, 'true'),
('CEB', 'Cebu Intl', 'CEB', 'Cebu', 'PHILIPPINES', 'PH', '8', '10.307542', '123.979439', 1, 'true'),
('CEC', 'Crescent City Municipal Arpt', 'CEC', 'Crescent City', 'UNITED STATES', 'US', '-8', '41.7802', '-124.237', 1, 'true'),
('CED', 'Ceduna Arpt', 'CED', 'Ceduna', 'AUSTRALIA', 'AU', '9', '-32.1306', '133.71', 1, 'true'),
('CEE', 'Cherepovets Airport', 'CEE', 'Cherepovets Airport', 'RUSSIA', 'RU', '4', '59.2736', '38.0158', 1, 'true'),
('XRC', 'Runcorn Rail Station', 'CEG', 'Chester', 'UNITED KINGDOM', 'GB', '-100', '0', '0', 2, ''),
('CEG', 'Chester Arpt', 'CEG', 'Chester', 'UNITED KINGDOM', 'GB', '0', '53.178056', '-2.977778', 2, 'true'),
('CEH', 'Chelinda Arpt', 'CEH', 'Chelinda', 'MALAWI', 'MW', '-100', '0', '0', 1, 'true'),
('CEI', 'Chaing Rai Arpt', 'CEI', 'Chiang Rai', 'THAILAND', 'TH', '7', '19.952342', '99.882928', 1, 'true'),
('CEK', 'Chelyabinsk Arpt', 'CEK', 'Chelyabinsk', 'RUSSIA', 'RU', '6', '55.305836', '61.503333', 1, 'true'),
('CEN', 'Ciudad Obregon Arpt', 'CEN', 'Ciudad Obregon', 'MEXICO', 'MX', '-7', '27.392639', '-109.833111', 1, 'true'),
('CEQ', 'Mandelieu Arpt', 'CEQ', 'Cannes', 'FRANCE', 'FR', '1', '43.54205', '6.953478', 1, 'true'),
('CER', 'Maupertius Arpt', 'CER', 'Cherbourg', 'FRANCE', 'FR', '1', '49.650106', '-1.470281', 1, 'true'),
('CES', 'Cessnock Arpt', 'CES', 'Cessnock', 'AUSTRALIA', 'AU', '10', '-32.7875', '151.342', 1, 'true'),
('CET', 'Le Pontreau Arpt', 'CET', 'Cholet', 'FRANCE', 'FR', '1', '47.082136', '-0.877064', 1, 'true'),
('CEU', 'Clemson Oconee Cty Arpt', 'CEU', 'Clemson', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CEY', 'Calloway Cty Arpt', 'CEY', 'Murray', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CEZ', 'Montezuma County', 'CEZ', 'Cortez', 'UNITED STATES', 'US', '-7', '37.303', '-108.628056', 1, 'true'),
('CFB', 'Cabo Frio Arpt', 'CFB', 'Cabo Frio', 'BRAZIL', 'BR', '-3', '-22.921667', '-42.074167', 1, 'true'),
('CFE', 'Aulnat Arpt', 'CFE', 'Clermont Ferrand', 'FRANCE', 'FR', '1', '45.786661', '3.169169', 1, 'true'),
('CFG', 'Cienfuegos Arpt', 'CFG', 'Cienfuegos', 'CUBA', 'CU', '-5', '22.15', '-80.414167', 1, 'true'),
('CFK', 'Chlef Arpt', 'CFK', 'Chlef', 'ALGERIA', 'DZ', '-100', '36.21', '1.33', 1, 'true'),
('CFN', 'Donegal Arpt', 'CFN', 'Donegal', 'IRELAND', 'IE', '0', '55.044192', '-8.341', 1, 'true'),
('CFQ', 'Creston Arpt', 'CFQ', 'Creston', 'CANADA', 'CA', '-100', '0', '0', 1, 'true'),
('CFR', 'Carpiquet Arpt', 'CFR', 'Caen', 'FRANCE', 'FR', '1', '49.173333', '-0.45', 1, 'true'),
('CFS', 'Coffs Harbour Arpt', 'CFS', 'Coffs Harbour', 'AUSTRALIA', 'AU', '10', '-30.320556', '153.116389', 1, 'true'),
('CFU', 'I Kapodistrias Arpt', 'CFU', 'Kerkyra', 'GREECE', 'GR', '2', '39.601944', '19.911667', 1, 'true'),
('CGA', 'Craig Seaplane Base', 'CGA', 'Craig', 'UNITED STATES', 'US', '-9', '55.478889', '-133.147778', 1, 'true'),
('CGB', 'Marechal Rondon Arpt', 'CGB', 'Cuiaba', 'BRAZIL', 'BR', '-4', '-15.652931', '-56.116719', 1, 'true'),
('CGD', 'Changde Arpt', 'CGD', 'Changde', 'CHINA', 'CN', '8', '28.9189', '111.64', 1, 'true'),
('CGI', 'Cape Girardeau Municipal Arpt', 'CGI', 'Cape Girardeau', 'UNITED STATES', 'US', '-6', '37.2253', '-89.5708', 1, 'true'),
('QKL', 'Cologne Railroad Station', 'CGN', 'Cologne', 'GERMANY', 'DE', '1', '50.9', '7.183', 2, ''),
('CGN', 'Koeln Bonn Arpt', 'CGN', 'Cologne', 'GERMANY', 'DE', '1', '50.865917', '7.142744', 2, 'true'),
('CGO', 'Zhengzhou Arpt', 'CGO', 'Zhengzhou', 'CHINA', 'CN', '8', '34.519672', '113.840889', 1, 'true'),
('CGP', 'Patenga Arpt', 'CGP', 'Chittagong', 'BANGLADESH', 'BD', '6', '22.249611', '91.813286', 1, 'true'),
('CGQ', 'Changchun Arpt', 'CGQ', 'Changchun', 'CHINA', 'CN', '8', '43.5412', '125.1201', 1, 'true'),
('CGR', 'Internacional', 'CGR', 'Campogrande', 'BRAZIL', 'BR', '-4', '-20.468667', '-54.6725', 1, 'true'),
('CGY', 'Lumbia Arpt', 'CGY', 'Cagayan', 'PHILIPPINES', 'PH', '8', '8.415619', '124.611219', 1, 'true'),
('CHA', 'Chattanooga Lovell Fld', 'CHA', 'Chattanooga', 'UNITED STATES', 'US', '-5', '35.035278', '-85.203808', 1, 'true'),
('CHC', 'Christchurch Arpt', 'CHC', 'Christchurch', 'NEW ZEALAND', 'NZ', '12', '-43.489358', '172.532225', 1, 'true'),
('CHD', 'Williams AFB Airport', 'CHD', 'Chandler', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('PWK', 'Pal Waukee Arpt', 'CHI', 'Chicago', 'UNITED STATES', 'US', '-6', '42.11429', '-87.901538', 5, ''),
('RFD', 'Chicago Rockford Arpt', 'CHI', 'Chicago', 'UNITED STATES', 'US', '-6', '42.195361', '-89.097222', 5, ''),
('DPA', 'Dupage County Arpt', 'CHI', 'Chicago', 'UNITED STATES', 'US', '-6', '41.907778', '-88.248611', 5, ''),
('ORD', 'O\'Hare Intl Arpt', 'CHI', 'Chicago', 'UNITED STATES', 'US', '-6', '41.978603', '-87.904842', 5, ''),
('MDW', 'Midway', 'CHI', 'Chicago', 'UNITED STATES', 'US', '-6', '41.785972', '-87.752417', 5, ''),
('CHO', 'Charlottesville Albemarle Arpt', 'CHO', 'Charlottesville', 'UNITED STATES', 'US', '-5', '38.138639', '-78.452861', 1, 'true'),
('CHQ', 'Souda Arpt', 'CHQ', 'Chania', 'GREECE', 'GR', '2', '35.531747', '24.149678', 1, 'true'),
('CHR', 'Chateauroux Arpt', 'CHR', 'Chateauroux', 'FRANCE', 'FR', '1', '46.862194', '1.730667', 1, 'true'),
('CHS', 'Charleston Intl Arpt', 'CHS', 'Charleston', 'UNITED STATES', 'US', '-5', '32.898647', '-80.040528', 1, 'true'),
('CHW', 'Jiuquan Arpt', 'CHW', 'Jiuquan', 'CHINA', 'CN', '-100', '0', '0', 1, 'true'),
('CHX', 'Changuinola Arpt', 'CHX', 'Changuinola', 'PANAMA', 'PA', '-5', '9.458636', '-82.516806', 1, 'true'),
('CIC', 'Chico Municipal Arpt', 'CIC', 'Chico', 'UNITED STATES', 'US', '-8', '39.795383', '-121.858422', 1, 'true'),
('CID', 'Cedar Rapids Municipal Arpt', 'CID', 'Cedar Rapids', 'UNITED STATES', 'US', '-6', '41.884694', '-91.710806', 1, 'true'),
('CIG', 'Craig Moffat', 'CIG', 'Craig', 'UNITED STATES', 'US', '-100', '40.495', '-107.5214', 1, 'true'),
('CIL', 'Melsing Creek Arpt', 'CIL', 'Council', 'UNITED STATES', 'US', '-9', '64.897778', '-163.703333', 1, 'true'),
('CIO', 'Mcal Lopez Arpt', 'CIO', 'Concepcion', 'PARAGUAY', 'PY', '2', '45.4715', '21.1136', 1, 'true'),
('CIT', 'Shimkent Arpt', 'CIT', 'Shimkent', 'KAZAKHSTAN', 'KZ', '6', '42.364167', '69.478889', 1, 'true'),
('CIW', 'Canouan Island Minicipal', 'CIW', 'Canovan Island', 'DOMINICA', 'DM', '-4', '12.699042', '-61.342431', 1, 'true'),
('CIX', 'Cornel Ruiz Arpt', 'CIX', 'Chiclayo', 'PERU', 'PE', '-5', '-6.787475', '-79.828097', 1, 'true'),
('CIY', 'Comiso Arpt', 'CIY', 'Comiso', 'ITALY', 'IT', '-100', '0', '0', 1, 'true'),
('CJB', 'Peelamedu Airport', 'CJB', 'Coimbatore', 'INDIA', 'IN', '5', '11.030031', '77.043383', 1, 'true'),
('CJC', 'El Loa Arpt', 'CJC', 'Calama', 'CHILE', 'CL', '-4', '-22.498175', '-68.903575', 1, 'true'),
('CJI', 'Ciudad Real City Arpt', 'CJI', 'Ciudad Real City', 'SPAIN', 'ES', '-100', '0', '0', 1, 'true'),
('CJJ', 'Cheongju Arpt', 'CJJ', 'Cheongju', 'KOREA, REPUBLIC OF', 'KR', '9', '36.7166', '127.499119', 1, 'true'),
('CJM', 'Chumphon Arpt', 'CJM', 'Chumphon', 'THAILAND', 'TH', '7', '10.7112', '99.361706', 1, 'true'),
('CJN', 'El Cajon Arpt', 'CJN', 'El Cajon', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CJS', 'Intl Abraham Gonzalez', 'CJS', 'Ciudad Juarez', 'MEXICO', 'MX', '-6', '31.636133', '-106.428667', 1, 'true'),
('CJU', 'Jeju Intl Arpt', 'CJU', 'Jeju City', 'KOREA, REPUBLIC OF', 'KR', '9', '33.511306', '126.493028', 1, 'true'),
('CKB', 'Clarksburg Benedum Arpt', 'CKB', 'Clarksburg', 'UNITED STATES', 'US', '-5', '39.2966', '-80.2281', 1, 'true'),
('CKG', 'Chongqing Arpt', 'CKG', 'Chongqing', 'CHINA', 'CN', '8', '29.719217', '106.641678', 1, 'true'),
('CKH', 'Chokurdakh Airport', 'CKH', 'Chokurdakh Airport', 'RUSSIA', 'RU', '12', '70.6231', '147.902', 1, 'true'),
('CKM', 'Fletcher Field', 'CKM', 'Clarksdale', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CKS', 'Carajas Arpt', 'CKS', 'Carajas', 'BRAZIL', 'BR', '-3', '-6.11781', '-50.0035', 1, 'true'),
('CKV', 'Outlaw Field', 'CKV', 'Clarksville', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CKY', 'Conakry Airport', 'CKY', 'Conakry', 'GUINEA', 'GN', '0', '9.576889', '-13.611961', 1, 'true'),
('CKZ', 'Canakkale Arpt', 'CKZ', 'Canakkale', 'TURKEY', 'TR', '2', '40.137722', '26.426777', 1, 'true'),
('CLC', 'Metroport', 'CLC', 'Clear Lake City', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CLD', 'Carlsbad Arpt', 'CLD', 'Carlsbad', 'UNITED STATES', 'US', '-8', '33.0742', '-117.1648', 1, 'true'),
('CGF', 'Cuyahoga County Airport', 'CLE', 'Cleveland', 'UNITED STATES', 'US', '-5', '41.565124', '-81.486356', 3, ''),
('CLE', 'Hopkins Intl Arpt', 'CLE', 'Cleveland', 'UNITED STATES', 'US', '-5', '41.411689', '-81.849794', 3, 'true'),
('BKL', 'Burke Lakefront Arpt', 'CLE', 'Cleveland', 'UNITED STATES', 'US', '-100', '41.525', '-81.6833', 3, ''),
('CLJ', 'Napoca Arpt', 'CLJ', 'Cluj', 'ROMANIA', 'RO', '2', '46.785167', '23.686167', 1, 'true'),
('CLL', 'Easterwood Field', 'CLL', 'College Station', 'UNITED STATES', 'US', '-6', '30.588583', '-96.363833', 1, 'true'),
('CLM', 'William Fairchild Intl Arpt', 'CLM', 'Port Angeles', 'UNITED STATES', 'US', '-8', '48.1202', '-123.5', 1, 'true'),
('CLO', 'Alfonso Bonella Aragon Arpt', 'CLO', 'Cali', 'COLOMBIA', 'CO', '-5', '3.543222', '-76.381583', 1, 'true'),
('CLQ', 'Colima Arpt', 'CLQ', 'Colima', 'MEXICO', 'MX', '-6', '19.277011', '-103.577397', 1, 'true'),
('CLT', 'Charlotte Douglas Intl Arpt', 'CLT', 'Charlotte', 'UNITED STATES', 'US', '-5', '35.214', '-80.943139', 1, 'true'),
('CLU', 'Columbus Municipal Arpt', 'CLU', 'Columbus', 'UNITED STATES', 'US', '-100', '39.2617', '-85.8967', 1, 'true'),
('CLW', 'Clearwater Executive Airpark', 'CLW', 'Clearwater', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CLY', 'Ste Catherine Arpt', 'CLY', 'Calvi', 'FRANCE', 'FR', '1', '42.530753', '8.793189', 1, 'true'),
('CMA', 'Cunnamulla Arpt', 'CMA', 'Cunnamulla', 'AUSTRALIA', 'AU', '10', '-28.03', '145.622', 1, 'true'),
('CMB', 'Bandaranaike Intl Arpt', 'CMB', 'Colombo', 'SRI LANKA', 'LK', '6', '7.180756', '79.884117', 1, 'true'),
('CME', 'Ciudad Del Carmen Arpt', 'CME', 'Ciudad Del Carmen', 'MEXICO', 'MX', '-6', '18.653739', '-91.799017', 1, 'true'),
('CMF', 'Chambery Aix Les Bains Arpt', 'CMF', 'Chambery', 'FRANCE', 'FR', '1', '45.63805', '5.880225', 1, 'true'),
('CMG', 'Internacional Corumba', 'CMG', 'Corumba', 'BRAZIL', 'BR', '-4', '-19.011931', '-57.673053', 1, 'true'),
('OSU', 'Ohio State Univ Arpt', 'CMH', 'Columbus', 'UNITED STATES', 'US', '-5', '40.0798', '-83.073', 3, ''),
('LCK', 'Rickenbacker Intl Arpt', 'CMH', 'Columbus', 'UNITED STATES', 'US', '-5', '39.813786', '-82.927822', 3, ''),
('CMH', 'Port Columbus Intl Arpt', 'CMH', 'Columbus', 'UNITED STATES', 'US', '-5', '39.997972', '-82.891889', 3, 'true'),
('CMI', 'Univ Of Illinois Willard Arpt', 'CMI', 'Champaign', 'UNITED STATES', 'US', '-6', '40.03925', '-88.278056', 1, 'true'),
('CMQ', 'Clermont Arpt', 'CMQ', 'Clermont', 'AUSTRALIA', 'AU', '-100', '-22.7694', '147.6194', 1, 'true'),
('CMR', 'Colmar Houssen Arpt', 'CMR', 'Colmar', 'FRANCE', 'FR', '1', '48.109853', '7.359011', 1, 'true'),
('CMV', 'Coromandel Arpt', 'CMV', 'Coromandel', 'NEW ZEALAND', 'NZ', '-100', '0', '0', 1, 'true'),
('CMW', 'Ign Agramonte Intl Arpt', 'CMW', 'Camaguey', 'CUBA', 'CU', '-5', '21.420428', '-77.847433', 1, 'true'),
('CMX', 'Houghton Cty Memorial Arpt', 'CMX', 'Houghton', 'UNITED STATES', 'US', '-5', '47.1684', '-88.4891', 1, 'true'),
('CMY', 'Camp Mccoy Aaf', 'CMY', 'Sparta', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CNB', 'Coonamble Arpt', 'CNB', 'Coonamble', 'AUSTRALIA', 'AU', '10', '-30.9833', '148.376', 1, 'true'),
('CNC', 'Coconut Island Arpt', 'CNC', 'Coconut Island', 'AUSTRALIA', 'AU', '10', '-10.05', '143.07', 1, 'true'),
('CND', 'Kogalniceanu Arpt', 'CND', 'Constanta', 'ROMANIA', 'RO', '2', '44.362222', '28.488333', 1, 'true'),
('CNG', 'Parvaud Arpt', 'CNG', 'Cognac', 'FRANCE', 'FR', '1', '45.658333', '-0.3175', 1, 'true'),
('CNJ', 'Cloncurry Arpt', 'CNJ', 'Cloncurry', 'AUSTRALIA', 'AU', '10', '-20.6686', '140.504', 1, 'true'),
('CNM', 'Carlsbad Airport', 'CNM', 'Carlsbad', 'UNITED STATES', 'US', '-7', '32.337472', '-104.263278', 1, 'true'),
('CNQ', 'Camba Punta Arpt', 'CNQ', 'Corrientes', 'ARGENTINA', 'AR', '-3', '-27.445503', '-58.761864', 1, 'true'),
('CNS', 'Cairns Airport', 'CNS', 'Cairns', 'AUSTRALIA', 'AU', '10', '-16.885833', '145.755278', 1, 'true'),
('CNX', 'Chiang Mai Intl Arpt', 'CNX', 'Chiang Mai', 'THAILAND', 'TH', '7', '18.766847', '98.962644', 1, 'true'),
('CNY', 'Moab Municipal', 'CNY', 'Moab', 'UNITED STATES', 'US', '-7', '38.755', '-109.754722', 1, 'true'),
('COC', 'Concordia Arpt', 'COC', 'Concordia', 'ARGENTINA', 'AR', '-3', '-31.296944', '-57.996631', 1, 'true'),
('COD', 'Yellowstone Regional Arpt', 'COD', 'Cody', 'UNITED STATES', 'US', '-7', '44.520194', '-109.023806', 1, 'true'),
('COE', 'Coeur d Alene Municipal Arpt', 'COE', 'Coeur D Alene', 'UNITED STATES', 'US', '-100', '47.7743', '-116.8196', 1, 'true'),
('COF', 'Patrick AFB', 'COI', 'Cocoa Metro Area', 'UNITED STATES', 'US', '-5', '28.234922', '-80.610125', 2, ''),
('COI', 'Merrit Island Arpt', 'COI', 'Cocoa Metro Area', 'UNITED STATES', 'US', '-100', '0', '0', 2, 'true'),
('COJ', 'Coonabarabran Arpt', 'COJ', 'Coonabarabrn', 'AUSTRALIA', 'AU', '-100', '-31.335', '149.27', 1, 'true'),
('COK', 'Kochi Intl Arpt', 'COK', 'Kochi', 'INDIA', 'IN', '5', '10.155556', '76.391389', 1, 'true'),
('CON', 'Concord Arpt', 'CON', 'Concord', 'UNITED STATES', 'US', '-5', '43.20267', '-71.50233', 1, 'true'),
('COO', 'Cotonou Airport', 'COO', 'Cotonou', 'BENIN', 'BJ', '1', '6.357228', '2.384353', 1, 'true'),
('COR', 'Pajas Blanco Arpt', 'COR', 'Cordoba', 'ARGENTINA', 'AR', '-3', '-31.323619', '-64.207953', 1, 'true'),
('COS', 'Colorado Springs Municipal Arpt', 'COS', 'Colorado Springs', 'UNITED STATES', 'US', '-7', '38.805805', '-104.700778', 1, 'true'),
('COU', 'Columbia Regional', 'COU', 'Columbia', 'UNITED STATES', 'US', '-6', '38.818094', '-92.219631', 1, 'true'),
('CPC', 'Chapelco Arpt', 'CPC', 'Chapelco', 'ARGENTINA', 'AR', '-3', '-40.075383', '-71.137294', 1, 'true'),
('CPD', 'Coober Pedy Arpt', 'CPD', 'Coober Pedy', 'AUSTRALIA', 'AU', '9', '-29.04', '134.721', 1, 'true'),
('CPE', 'Campeche Intl Arpt', 'CPE', 'Campeche', 'MEXICO', 'MX', '-6', '19.816794', '-90.500314', 1, 'true'),
('ZGH', 'Copenhagen Rail Station', 'CPH', 'Copenhagen', 'DENMARK', 'DK', '-100', '0', '0', 2, ''),
('CPH', 'Copenhagen Arpt', 'CPH', 'Copenhagen', 'DENMARK', 'DK', '1', '55.617917', '12.655972', 2, 'true'),
('CPO', 'Chamonate Arpt', 'CPO', 'Copiapo', 'CHILE', 'CL', '-4', '-27', '-70', 1, 'true'),
('CPQ', 'International Campinas', 'CPQ', 'Campinas', 'BRAZIL', 'BR', '-4', '-22.8592', '-47.1082', 1, 'true'),
('CPR', 'Natrona Cty Intl Arpt', 'CPR', 'Casper', 'UNITED STATES', 'US', '-7', '42.908', '-106.464417', 1, 'true'),
('CPT', 'Cape Town International', 'CPT', 'Cape Town', 'SOUTH AFRICA', 'ZA', '2', '-33.964806', '18.601667', 1, 'true'),
('CPV', 'Joao Suassuana Arpt', 'CPV', 'Campina Grande', 'BRAZIL', 'BR', '-3', '-7.269917', '-35.896364', 1, 'true'),
('CPX', 'Culebra Arpt', 'CPX', 'Culebra', 'UNITED STATES', 'US', '-4', '18.3127', '-65.3034', 1, 'true'),
('CQD', 'Shahre Kord Arpt', 'CQD', 'Shahre Kord', 'IRAN', 'IR', '3', '32.2972', '50.8422', 1, 'true'),
('CQM', 'Ciudad Real Central Arpt', 'CQM', 'Ciudad Real', 'SPAIN', 'ES', '1', '38.856389', '-3.97', 1, 'true'),
('CRA', 'Craiova Arpt', 'CRA', 'Craiova', 'ROMANIA', 'RO', '2', '44.318139', '23.888611', 1, 'true'),
('CRD', 'Comodoro Rivadavia Arpt', 'CRD', 'Comodoro Rivadavia', 'ARGENTINA', 'AR', '-3', '-45.785347', '-67.465508', 1, 'true'),
('CRK', 'Clark Field Arpt', 'CRK', 'Luzon Island', 'PHILIPPINES', 'PH', '8', '15.185833', '120.560278', 1, 'true'),
('CRP', 'Corpus Christi Intl Arpt', 'CRP', 'Corpus Christi', 'UNITED STATES', 'US', '-6', '27.770361', '-97.501222', 1, 'true'),
('CRV', 'Crotone Arpt', 'CRV', 'Crotone', 'ITALY', 'IT', '1', '38.997225', '17.080169', 1, 'true'),
('CRW', 'Yeager Arpt', 'CRW', 'Charleston', 'UNITED STATES', 'US', '-5', '38.373147', '-81.593189', 1, 'true'),
('CRX', 'Roscoe Turner Arpt', 'CRX', 'Corinth', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CRZ', 'Turkmenabad Arpt', 'CRZ', 'Turkmenabad', 'TURKMENISTAN', 'TM', '5', '39.083333', '63.602222', 1, 'true'),
('CSF', 'Creil Arpt', 'CSF', 'Creil', 'FRANCE', 'FR', '1', '49.253547', '2.519139', 1, 'true'),
('CSG', 'Columbus Metro Ft Benning Arpt', 'CSG', 'Columbus', 'UNITED STATES', 'US', '-5', '32.516333', '-84.938861', 1, 'true'),
('CSI', 'Casino Arpt', 'CSI', 'Casino', 'AUSTRALIA', 'AU', '-100', '-28.8833', '153.0583', 1, 'true'),
('SBP', 'San Luis Obispo County Arpt', 'CSL', 'San Luis Obispo', 'UNITED STATES', 'US', '-8', '35.2368', '-120.642', 2, ''),
('CSL', 'O Sullivan Army Air Field', 'CSL', 'San Luis Obispo', 'UNITED STATES', 'US', '-100', '0', '0', 2, 'true'),
('CLK', 'Clinton Municipal Arpt', 'CSM', 'Clinton', 'UNITED STATES', 'US', '-100', '0', '0', 2, ''),
('CSM', 'Sherman Arpt', 'CSM', 'Clinton', 'UNITED STATES', 'US', '-100', '35.34', '-99.2', 2, 'true'),
('CSN', 'Carson Arpt', 'CSN', 'Carson City', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CSU', 'Santa Cruz Do Sul Arpt', 'CSU', 'Santa Cruz Do Sul', 'BRAZIL', 'BR', '-100', '0', '0', 1, 'true'),
('CSX', 'Changsha Arpt', 'CSX', 'Changsha', 'CHINA', 'CN', '8', '28.189158', '113.219633', 1, 'true'),
('CSY', 'Cheboksary Arpt', 'CSY', 'Cheboksary', 'RUSSIA', 'RU', '4', '56.0903', '47.3473', 1, 'true'),
('CTA', 'Fontanarossa Arpt', 'CTA', 'Catania', 'ITALY', 'IT', '1', '37.466781', '15.0664', 1, 'true'),
('CTC', 'Choya Arpt', 'CTC', 'Catamarca', 'ARGENTINA', 'AR', '-3', '-28.593214', '-65.750925', 1, 'true'),
('CTD', 'Chitre Airfield', 'CTD', 'Chitre', 'PANAMA', 'PA', '-5', '7.98784', '-80.4097', 1, 'true'),
('CTG', 'Rafael Nunez Arpt', 'CTG', 'Cartagena', 'COLOMBIA', 'CO', '-5', '10.442381', '-75.512961', 1, 'true'),
('CTL', 'Charleville Arpt', 'CTL', 'Charleville', 'AUSTRALIA', 'AU', '10', '-26.413334', '146.2625', 1, 'true'),
('CTM', 'Chetumal International', 'CTM', 'Chetumal', 'MEXICO', 'MX', '-6', '18.504667', '-88.326847', 1, 'true'),
('CTN', 'Cooktown Arpt', 'CTN', 'Cooktown', 'AUSTRALIA', 'AU', '10', '-15.4447', '145.184', 1, 'true'),
('CTU', 'Chengdu Arpt', 'CTU', 'Chengdu', 'CHINA', 'CN', '8', '30.578528', '103.947086', 1, 'true'),
('CTW', 'Cottonwood Airport', 'CTW', 'Cottonwood', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CUA', 'Ciudad Constitucion Arpt', 'CUA', 'Ciudad Constitucion', 'MEXICO', 'MX', '-7', '25.0538', '-111.615', 1, 'true'),
('CUC', 'Camilo Dazo Arpt', 'CUC', 'Cucuta', 'COLOMBIA', 'CO', '-5', '7.927567', '-72.511547', 1, 'true'),
('CUE', 'Cuenca Arpt', 'CUE', 'Cuenca', 'ECUADOR', 'EC', '-5', '-2.889467', '-78.984397', 1, 'true'),
('CUF', 'Levaldigi Arpt', 'CUF', 'Cuneo', 'ITALY', 'IT', '1', '44.547019', '7.623217', 1, 'true'),
('CUG', 'Cudal Arpt', 'CUG', 'Cudal', 'AUSTRALIA', 'AU', '-100', '-33.2783', '148.7633', 1, 'true'),
('CUL', 'Fedl De Bachigualato Arpt', 'CUL', 'Culiacan', 'MEXICO', 'MX', '-7', '24.764547', '-107.474717', 1, 'true'),
('CUM', 'Antonio Jose De Sucre', 'CUM', 'Cumana', 'VENEZUELA', 'VE', '-4', '10.450333', '-64.130472', 1, 'true'),
('CUN', 'Cancun Aeropuerto Internacional', 'CUN', 'Cancun', 'MEXICO', 'MX', '-6', '21.036528', '-86.877083', 1, 'true'),
('CUQ', 'Coen Arpt', 'CUQ', 'Coen', 'AUSTRALIA', 'AU', '10', '-13.7608', '143.114', 1, 'true'),
('CUR', 'Areopuerto Hato Arpt', 'CUR', 'Curacao', 'NETHERLANDS ANTILLES', 'AN', '-4', '12.188853', '-68.959803', 1, 'true'),
('CUS', 'Columbus Municipal', 'CUS', 'Columbus', 'UNITED STATES', 'US', '-100', '0', '0', 1, 'true'),
('CUU', 'Chihuahua Airport', 'CUU', 'Chihuahua', 'MEXICO', 'MX', '-6', '28.702875', '-105.964567', 1, 'true'),
('CUZ', 'Tte Velazco Astete Arpt', 'CUZ', 'Cuzco', 'PERU', 'PE', '-5', '-13.535722', '-71.938781', 1, 'true'),
('CVF', 'Courchevel Arpt', 'CVF', 'Courchevel', 'FRANCE', 'FR', '1', '45.3967', '6.63472', 1, 'true'),
('LUK', 'Cincinnati Municipal Arpt', 'CVG', 'Cincinnati', 'UNITED STATES', 'US', '-5', '39.103333', '-84.418611', 2, ''),
('CVG', 'Cincinnati No Kentucky Intl Arpt', 'CVG', 'Cincinnati', 'UNITED STATES', 'US', '-5', '39.048836', '-84.667822', 2, 'true'),
('CVJ', 'Cuernavaca Arpt', 'CVJ', 'Cuernavaca', 'MEXICO', 'MX', '-6', '18.834764', '-99.2613', 1, 'true'),
('CVM', 'Ciudad Victoria Arpt', 'CVM', 'Ciudad Victoria', 'MEXICO', 'MX', '-6', '23.703336', '-98.956486', 1, 'true'),
('CVN', 'Clovis Airport', 'CVN', 'Clovis', 'UNITED STATES', 'US', '-6', '34.425139', '-103.079278', 1, 'true'),
('QWY', 'Albany Bus Service', 'CVO', 'Corvallis', 'UNITED STATES', 'US', '-100', '0', '0', 2, ''),
('CVO', 'Corvallis Municipal Arpt', 'CVO', 'Corvallis', 'UNITED STATES', 'US', '-100', '0', '0', 2, 'true'),
('CVQ', 'Carnarvon Arpt', 'CVQ', 'Carnarvon', 'AUSTRALIA', 'AU', '8', '-24.8806', '113.672', 1, 'true'),
('CVT', 'Baginton Arpt', 'CVT', 'Coventry', 'UNITED KINGDOM', 'GB', '0', '52.369722', '-1.479722', 1, 'true'),
('CVU', 'Corvo Arpt', 'CVU', 'Corvo Island', 'PORTUGAL', 'PT', '-1', '39.6715'