-- MySQL dump 10.13  Distrib 5.1.73, for redhat-linux-gnu (x86_64)
--
-- Host: localhost    Database: otf20_dev
-- ------------------------------------------------------
-- Server version	5.1.73

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `AIRLINE`
--

DROP TABLE IF EXISTS `AIRLINE`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `AIRLINE` (
  `AIRLINEnum` int(10) NOT NULL AUTO_INCREMENT,
  `AIRLINEicao` varchar(4) DEFAULT NULL,
  `AIRLINEiata` char(3) DEFAULT NULL,
  `AIRLINEname` varchar(255) DEFAULT NULL,
  `AIRLINEcallsign` varchar(32) DEFAULT NULL,
  `AIRLINEcountryen` varchar(50) DEFAULT NULL,
  `AIRLINEwww` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`AIRLINEnum`),
  UNIQUE KEY `AIRLINEiata` (`AIRLINEiata`)
) ENGINE=MyISAM AUTO_INCREMENT=1169 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `AIRLINE`
--

LOCK TABLES `AIRLINE` WRITE;
/*!40000 ALTER TABLE `AIRLINE` DISABLE KEYS */;
INSERT INTO `AIRLINE` VALUES (3,'ASQ','EV','Atlantic Southeast Airlines','Acey','UNITED STATES','http://www.flyasa.com'),(4,'AUZ','NO','Australian Airlines Ltd.','Australian','AUSTRALIA',''),(5,'RPA','RW','Republic Airlines','Brickyard','UNITED STATES','http://www.republicairlines.com/'),(11,'AAF','ZI','Aigle Azur','Aigle Azur','FRANCE','www.aigleazur.net'),(12,'AAG','7M','Air Atlantique','Atlantic','UNITED KINGDOM','www.airatlantique.co.uk'),(13,'AAH','AQ','Aloha Airlines, Inc.','Aloha','UNITED STATES','www.alohaairlines.com'),(17,'AAL','AA','American Airlines','American','UNITED STATES','www.aa.com'),(23,'AAR','OZ','Asiana Airlines','Asiana','KOREA, REPUBLIC OF','www.flyAsiana.com'),(28,'AAW','8U','Afriqiyah Airways','Afriqiyah','LIBYAN ARAB JAMAHIRIYA',''),(30,'AAY','G4','Allegiant Air, Inc.','Allegiant','UNITED STATES',''),(35,'ABD','CC','Air Atlanta Icelandic','Atlanta','ICELAND',''),(39,'ABH','DF','Aerolineas de Baleares Aebal','Air Balear','SPAIN',''),(48,'ABQ','ED','Airblue Limited','Pakblue','PAKISTAN',''),(49,'ABR','AG','Air Contractors (Ireland) Limited','Contract','IRELAND',''),(50,'ABS','9T','Transwest Air Limited','Athabaska','CANADA',''),(55,'ABX','GB','Airborne Express, Inc.','Abex','UNITED STATES',''),(56,'ABY','G9','Air Arabia','Arabia','UNITED ARAB EMIRATES',''),(58,'ACA','AC','Air Canada','Air Canada','CANADA','http://www.aircanada.com'),(66,'ACI','SB','Air Caledonie International','Aircalin','NEW CALEDONIA',''),(69,'ACL','9X','Itali Airlines','Itali','ITALY',''),(87,'ADE','ZY','Ada Air','Ada Air','ALBANIA',''),(90,'ADH','AP','Air One','Heron','ITALY',''),(93,'ADK','Z7','Aviation Development Company Plc','Adco','NIGERIA',''),(97,'ADO','HD','Hokkaido International Airlines','Air Do','JAPAN','http://www.airdo21.com/'),(100,'ADR','JP','Adria Airways','Adria','SLOVENIA','http://www.adria-airways.com'),(108,'AEA','UX','Air Europa LÃƒÂ­neas AÃƒÂ©reas, S.A.','Europa','SPAIN','http://www.aireuropa.com'),(109,'AEB','EM','Aero Benin S.A.','Aeroben','BENIN',''),(112,'AEE','A3','Aegean Airlines','Aegean','GREECE',''),(115,'AEH','RX','Aviaexpress','Avex','HUNGARY',''),(117,'AEJ','ZG','Air Express Limited','Khaki Express','TANZANIA, UNITED REPUBLIC OF',''),(119,'AEL','PE','Air Europe S.p.A.','Air Europe','ITALY',''),(125,'AER','KO','Alaska Central Express, Inc.','Ace Air','UNITED STATES',''),(128,'AEU','5W','Astraeus','Flystar','UNITED KINGDOM','http://www.flyastreus.com'),(130,'AEW','VV','Aerosvit Airlines','Aerosvit','UKRAINE',''),(135,'AFB','WK','American Falcon, S.A.','American Falcon','ARGENTINA',''),(139,'AFF','7A','Afric\'Air Charter, S.A.','Benin-Charters','BENIN',''),(140,'AFG','FG','Ariana Afghan Airlines','Ariana','AFGHANISTAN',''),(142,'AFI','RV','Africaone','Africaworld','THE GAMBIA',''),(143,'AFJ','3A','Alliance','Jambo','UGANDA',''),(145,'AFL','SU','Aeroflot Russian Airlines','Aeroflot','RUSSIAN FEDERATION',''),(151,'AFR','AF','Air France','Air France','FRANCE','http://www.airfrance.com'),(153,'AFU','Q9','Afrinat (Gambia) International Airlines, Inc.','Afrinat','GHANA',''),(160,'AGB','G8','Air Service Gabon','','GABON',''),(179,'AGV','7T','Air Glaciers','Air Glaciers','SWITZERLAND',''),(184,'AHA','GD','Air Alpha Greenland A/S','Air Alpha','DENMARK',''),(193,'AHK','LD','AHK Air Hong Kong Ltd.','Air Hong Kong','HONG KONG SAR OF CHINA','http://www.airhongkong.com.hk/'),(202,'AHW','HT','Aeromist - Kharkiv Ltd.','Aeromist','UKRAINE',''),(203,'AHY','J2','Azerbaijan Hava Yollary','Azal','AZERBAIJAN','http://www.nac-azal.com'),(204,'AIA','U3','Avies','Avies','ESTONIA','http://www.avies.ee/'),(206,'AIC','AI','Air India Limited','Airindia','INDIA','http://www.airindia.com'),(208,'AIE','3H','Air Inuit Ltd/Ltee.','Air Inuit','CANADA','http://www.airinuit.com'),(218,'AIP','5A','Alpine Aviation, Inc.','Alpine Air','UNITED STATES',''),(219,'AIQ','FD','Air Asia Aviation Co. Ltd.','Thai Asia','THAILAND',''),(228,'AIZ','IZ','Arkia Israel Airlines','Arkia','ISRAEL','http://www.arkia.co.il/'),(237,'AJM','JM','Air Jamaica','Jamaica','JAMAICA','http://www.airjamaica.com/'),(238,'AJO','SX','Aeroejecutivo S.A. de C.V.','Aeroexo','MEXICO',''),(241,'AJT','M6','Amerijet International, Inc.','Amerijet','UNITED STATES','http://www.amerijet.com/'),(244,'AJX','NQ','Air Japan Company Ltd','Air Japan','JAPAN','http://www.air-japan.co.jp/'),(254,'AKK','6L','Aklak Air, Inc.','Aklak','CANADA',''),(258,'AKR','8A','Arctic Air A.S.','Arctic Norway','NORWAY',''),(260,'AKT','V2','Karat Joint Stock Company','Aviakarat','RUSSIAN FEDERATION',''),(263,'AKX','EH','Air Nippon Network Co. Ltd.','Alfa Wing','JAPAN',''),(275,'ALK','UL','SriLankan Airlines Limited','Srilankan','SRI LANKA',''),(284,'ALT','XE','SBS Aircraft','Green-Craft','KAZAKHSTAN',''),(288,'ALX','EO','Hewa Bora Airways','Allcongo','CONGO, THE DEMOCRATIC REPUBLIC OF',''),(293,'AMC','KM','Air Malta','Air Malta','MALTA',''),(302,'AML','QM','Air Malawi Limited','Malawi','MALAWI',''),(310,'AMT','TZ','ATA Airlines','Amtran','UNITED STATES',''),(311,'AMU','NX','Air Macao Company Limited','Air Macao','MACAU SAR OF CHINA',''),(313,'AMW','ZV','Air Midwest','Air Midwest','UNITED STATES',''),(314,'AMX','AM','AeromÃƒÂ©xico','Aeromexico','MEXICO','http://www.aeromexico.com'),(317,'ANA','NH','All Nippon Airways Co. Ltd.','All Nippon','JAPAN','http://www.fly-ana.com'),(323,'ANG','PX','Air Niugini','Niugini','PAPUA NEW GUINEA','http://www.airniugini.com.pg/'),(326,'ANK','EL','Air Nippon','Ank Air','JAPAN','http://www.air-nippon.co.jp/'),(329,'ANO','TL','Airnorth Regional','Topend','AUSTRALIA',''),(334,'ANT','4N','Air North Charter','Air North','CANADA',''),(335,'ANV','LW','Pacific Wings','Tsunami','UNITED STATES',''),(338,'ANZ','NZ','Air New Zealand','New Zealand','NEW ZEALAND','http://www.airnewzealand.com'),(340,'AOC','J6','Joint-Stock Holding Co. Aviation Commercial - AVCOM','Aero Avcom','RUSSIAN FEDERATION',''),(344,'AOG','2D','Aero VIP, S.A.','Avip','ARGENTINA',''),(345,'AOH','N9','North Coast Aviation','Air Ohio','UNITED STATES',''),(354,'AOT','OE','Asia Overnight Express Corporation','Asia Overnight','PHILIPPINES',''),(365,'APG','3D','Air People International Co. Ltd.','Air People','THAILAND',''),(374,'APP','WL','Aerolineas Pacifico Atlantico, S.A. (Apair)','Aeroperlas','PANAMA',''),(380,'APW','JW','Arrow Air, Inc.','Big A','UNITED STATES',''),(394,'ARB','3R','Avia Air N.V.','Aviair','ARUBA',''),(395,'ARC','ZJ','Air Routing International Corp.','','UNITED STATES',''),(396,'ARD','2B','ATA Aerocondor Transportes AÃƒÂ©reos Lda.','Aerocondor','PORTUGAL',''),(397,'ARE','4C','Aires, Aerovias de Integracion Regional, S.A.','Aires','COLOMBIA',''),(399,'ARG','AR','Aerolineas Argentinas','Argentina','ARGENTINA',''),(417,'ASA','AS','Alaska Airlines, Inc.','Alaska','UNITED STATES',''),(420,'ASD','4D','Air Sinai','Air Sinai','EGYPT',''),(421,'ASE','PL','Airstars, Airways Company','Morozov','RUSSIAN FEDERATION',''),(424,'ASH','YV','Mesa Airlines','Air Shuttle','UNITED STATES','http://www.mesa-air.com'),(426,'ASJ','6O','Air Satellite, Inc.','Satellite','CANADA',''),(436,'ASU','5L','Compania Boliviana de Transporte Aereo Privado Aerosur, S.A.','Asur','BOLIVIA',''),(441,'ASZ','OB','Astrakhan Airlines','Air Astrakhan','RUSSIAN FEDERATION',''),(444,'ATC','TC','Air Tanzania Company Ltd.','Tanzania','TANZANIA, UNITED REPUBLIC OF',''),(450,'ATI','HC','Aero-Tropics Air Services','','AUSTRALIA',''),(454,'ATM','FO','Airlines Of Tasmania Pty Ltd.','Airtas','AUSTRALIA',''),(455,'ATN','8C','Air Transport International LLC','Air Transport','UNITED STATES',''),(468,'AUA','OS','Austrian Airlines','Austrian','AUSTRIA','http://www.aua.com'),(469,'AUB','IQ','Augsburg Airways GmbH','Augsburg Air','GERMANY',''),(474,'AUI','PS','Ukraine International Airlines','Ukraine International','UKRAINE',''),(476,'AUL','5N','Aeroflot - Nord','Archangelsk Air','RUSSIAN FEDERATION',''),(481,'AUR','GR','Aurigny Air Services','Ayline','UNITED KINGDOM',''),(483,'AUT','AU','Cielos del Sur S.A. d/b/a Austral Lineas Aereas S.A.','Austral','ARGENTINA',''),(488,'AVA','AV','Avianca - Aerovias Nacionales de Colombia, S.A.','Avianca','COLOMBIA',''),(492,'AVE','VE','Aerovias Venezolanas, S.A. (AVENSA)','AlphaVictorEcho','VENEZUELA',''),(501,'AVN','NF','Air Vanuatu','Air Van','VANUATU',''),(517,'AWE','HP','America West Airlines','Cactus','UNITED STATES',' http://www.americawest.com'),(521,'AWI','ZW','Air Wisconsin','Air Wisconsin','UNITED STATES',''),(529,'AWQ','QZ','Air Wagon Internation','Wagon Air','INDONESIA',''),(533,'AWU','7E','Aeroline GmbH','Sylt-Air','GERMANY',''),(535,'AWW','6G','Air Wales Limited','Red Dragon','UNITED KINGDOM','http://www.airwales.com'),(544,'AXF','HJ','Asian Express Airlines Pty Limited','Freightexpress','AUSTRALIA',''),(548,'AXK','XU','African Express Airways (K) Ltd.','Express Jet','KENYA',''),(550,'AXM','AK','Air Asia','Asian Express','MALAYSIA',''),(559,'AXY','6V','Axis Airways','Axis','FRANCE',''),(568,'AYZ','3G','Atlant-Soyuz Airlines','Atlant-Soyuz','RUSSIAN FEDERATION',''),(569,'AZA','AZ','Alitalia - Linee Aeree Italiane','Alitalia','ITALY','http://www.alitalia.com'),(572,'AZE','ZE','Arcus-Air Logistic','Arcus Air','GERMANY','http://www.arcus-air.com/'),(582,'AZQ','ZP','Silk Way Airlines','Silk Line','AZERBAIJAN',''),(584,'AZS','ZR','Aviacon Zitotrans Air Company JSC','Zitotrans','RUSSIAN FEDERATION',''),(587,'AZW','UM','Air Zimbabwe','Air Zimbabwe','ZIMBABWE',''),(590,'BAW','BA','British Airways','Speedbird','UNITED KINGDOM','http://www.ba.com'),(591,'BBC','BG','Biman Bangladesh','Bangladesh','BANGLADESH','http://www.bimanair.com'),(592,'BBD','BF','Bluebird Cargo','Blue Cargo','ICELAND',''),(593,'BBR','S3','Santa Barbara Airlines','Santa Barbara','VENEZUELA','http://www.santabarbaraairlines.com'),(594,'BCS','QY','European Air Transport','Eurotrans','BELGIUM',''),(595,'BCY','WX','Cityjet','City-Ireland','IRELAND','http://www.cityjet.com'),(596,'BEE','BE','Flybe','Jersey','UNITED KINGDOM','http://www.flybe.com'),(597,'BFL','J4','Buffalo Airways','Buffalo','CANADA','http://www.buffaloairways.com'),(599,'BLF','KF','Blue1','Bluefin','FINLAND','http://www.blue1.com'),(600,'BMA','BD','British Midland','Midland','UNITED KINGDOM','http://www.flybmi.com'),(601,'BMI','WW','bmibaby','Baby','UNITED KINGDOM','http://www.bmibaby.com'),(605,'BRU','B2','Belavia Belarusian Airlines','Belarus Avia','BELARUS','http://www.belavia.by'),(606,'BSY','GQ','Big Sky Airlines','Big Sky','UNITED STATES','http://www.bigskyair.com'),(607,'BTA','RU','Continental Express (ExpressJet)','Jet Link','UNITED STATES','http://www.continental.com'),(608,'BWA','BW','BWIA West Indies Airways','West Indian','TRINIDAD AND TOBAGO','http://www.bwee.com'),(609,'BWG','QW','Blue Wings','Blue Wings','GERMANY','http://www.bluewing.info'),(610,'BZH','DB','Brit Air','Britair','FRANCE','http://www.britair.com'),(611,'CAL','CI','China Airlines','Dynasty','TAIWAN/ROC','http://www.china-airlines.com'),(613,'CAY','KX','Cayman Airways','Cayman','CAYMAN ISLANDS',''),(615,'CCA','CA','Air China','Air China','CHINA/PRC','http://www.airchina.com'),(618,'CEA','3C','RegionsAir','','UNITED STATES',''),(619,'CEB','5J','Cebu Pacific Air','','PHILIPPINES',''),(620,'CES','MU','China Eastern Airlines','China Eastern','CHINA',''),(621,'CFC','YF','Canadian Armed Forces','','CANADA',''),(622,'CFG','DE','Condor Flugdienst','Condor','GERMANY',''),(623,'CHQ','RP','Chautauqua Airlines','Chautauqua','UNITED STATES',''),(624,'CIM','QI','Cimber Air','','DENMARK',''),(625,'CIP','6E','City Air','','GERMANY DEFUNCT',''),(626,'CJA','C6','CanJet','CanJet','CANADA','http://www.canjet.com'),(627,'CJC','9L','Colgan Air','','UNITED STATES',''),(629,'CLH','CL','Lufthansa CityLine','','GERMANY',''),(632,'CNO','BU','SAS Braathens','Scanor','NORWAY','http://www.sasbraathens.no'),(634,'CMP','CM','Copa Airlines','Copa','PANAMA','http://www.copaair.com'),(635,'COA','CO','Continental Airlines','Continental','UNITED STATES','http://www.continental.com'),(636,'COM','OH','Comair','Comair','UNITED STATES','www.comair.com'),(637,'CPA','CX','Cathay Pacific Airways Limited','Cathay','HONG KONG, CHINA','http://www.cathaypacific.com'),(639,'CRQ','YN','Air Creebec','','CANADA',''),(641,'CSA','OK','Czech Airlines','CSA Lines','CZECH REPUBLIC','http://www.czechairlines.com'),(642,'CSN','CZ','China Southern Airlines','China Southern','PEOPLE\'S REPUBLIC OF CHINA','http://www.cs-air.com'),(643,'CST','BX','Coast Air','','NORWAY',''),(644,'CSZ','4G','Shenzhen Airlines','','CHINA',''),(645,'CTN','OU','Croatia Airlines','Croatia','CROATIA',''),(646,'CUB','CU','Cubana','Cubana','CUBA',''),(647,'CXS','E9','Boston-Maine Airways (Pan Am Clipper Connection','Clipper Connection','UNITED STATES',''),(648,'DAH','AH','Air Algerie','Air Algerie','ALGERIA',''),(649,'DAL','DL','Delta Air Lines','Delta','UNITED STATES','http://www.delta.com'),(650,'DHL','ER','Astar Air Cargo, DHL','Dahl','UNITED STATES',''),(651,'DLH','LH','Lufthansa','Lufthansa','GERMANY','http://www.lufthansa.com'),(652,'DTA','DT','TAAG','Dta','ANGOLA',''),(654,'EEZ','GJ','Eurofly','E-FLY','ITALY',''),(655,'EGF','MQ','American Eagle Airlines','EAGLE FLIGHT','UNITED STATES','http://www.aa.com'),(657,'EIN','EI','Aer Lingus','SHAMROCK','IRELAND','http://www.aerlingus.com'),(658,'ELY','LY','El Al Israel Airlines','ELAL','ISRAEL','http://www.elal.co.il'),(659,'ETD','EY','Etihad Airways','ETIHAD','UNITED ARAB EMIRATES',''),(661,'EVA','BR','EVA Air','EVA','TAIWAN/ROC','http://www.evaair.com'),(663,'EXY','YB','South African Express Airways','EXPRESSWAYS','SOUTH AFRICA','http://www.saexpress.co.za/default.htm'),(664,'EZE','T3','Eastern Airways','EASTFLIGHT','UNITED KINGDOM','http://www.easternairways.com'),(665,'EZS','DS','easyJet','TOPSWISS','SWITZERLAND','http://www.easyjet.ch'),(666,'EZY','U2','easyJet','EASY','UNITED KINGDOM','http://www.easyjet.com'),(667,'FCA','DP','First Choice Airways','Jetset','UNITED KINGDOM','http://www.firstchoiceairways.co.uk'),(668,'FDX','FX','Federal Express','Fedex','UNITED STATES',''),(670,'FFT','F9','Frontier Airlines','Frontier Flight','UNITED STATES','http://www.flyfrontier.com/'),(671,'FIF','OF','Air Finland','Air Finland','FINLAND',''),(672,'FIN','AY','Finnair','Finnair','FINLAND','http://www.finnair.com'),(673,'FJI','FJ','Air Pacific','Pacific','FIJI',''),(674,'FLG','9E','Pinnacle Airlines','Flagship','UNITED STATES','http://www.nwairlink.com'),(677,'GAO','DC','Golden Air','Golden','SWEDEN',''),(678,'GBL','GT','GB Airways','Geebee Airways','UNITED KINGDOM',''),(681,'GFA','GF','Gulf Air','Gulf Air','BAHRAIN/OMAN/UNITED ARAB EMIRATES',''),(682,'GFT','3M','Gulfstream International Airlines','Gulf Flight','UNITED STATES',''),(684,'GHB','G0','Ghana International Airlines','Ghana Airlines','GHANA',''),(685,'GIA','GA','Garuda Indonesia','Indonesia','INDONESIA',''),(687,'GMI','ST','Germania','Germania','GERMANY',''),(690,'GSM','B4','Flyglobespan','Globespan','UNITED KINGDOM',''),(691,'GWI','4U','Germanwings','German Wings','GERMANY',''),(692,'HAL','HA','Hawaiian Airlines','Hawaiian','UNITED STATES','http://www.hawaiianair.com'),(694,'HDA','KA','Dragonair, Hong Kong Dragon Airlines','Dragon','HONG KONG, CHINA/PRC','http://www.dragonair.com'),(695,'HLX','X3','Hapag-Lloyd Express','Excellence','GERMANY',''),(696,'HVN','VN','Vietnam Airlines','Viet Nam Airlines','VIETNAM','http://www.vietnamairlines.com'),(697,'IAA','IO','Indonesian Airlines','Indo Lines','INDONESIA','http://www.indonesian-airlines.co.id'),(698,'IAC','IC','Indian Airlines','Indair','INDIA','http://indian-airlines.nic.in/'),(699,'IAW','IA','Iraqi Airways','Iraqi','IRAQ',''),(700,'IBE','IB','Iberia Airlines of Spain','Iberia','SPAIN','http://www.iberia.com'),(702,'ICE','FI','Icelandair','Iceair','ICELAND','http://www.icelandair.net'),(704,'ICL','5C','CAL - Cargo Air Lines','Cal','ISRAEL','http://www.cal.co.il/'),(705,'IDE','DH','Independence Air','Independence Air','UNITED STATES','http://www.flyi.com'),(709,'IRA','IR','Iran Air','Iranair','IRAN','http://www.iranair.com/'),(710,'IRM','W5','Mahan Airlines','Mahan Air','IRAN','http://www.mahan.aero/'),(711,'ISR','6H','Israir Airlines','Israir','ISRAEL','http://www.israirairlines.com/'),(712,'IYE','IY','Yemenia-Yemen Airways','Yemeni','YEMEN','http://www.yemenia.com/'),(713,'JAA','EG','Japan Asia Airways','Asia','JAPAN',''),(714,'JAL','JL','Japan Airlines International','Japanair','JAPAN','http://www.japanair.com'),(715,'JAT','JU','Jat Airways','Jat','SERBIA AND MONTENEGRO',''),(716,'JAZ','JO','JALways','Jalways','JAPAN',''),(717,'JBU','B6','JetBlue Airways','JetBlue','UNITED STATES','http://www.jetblue.com'),(720,'JKK','JK','Spanair','Spanair','SPAIN','http://www.spanair.com'),(721,'JLJ','JD','Japan Airlines Domestic','J-BIRD','JAPAN','http://www.japanair.com'),(722,'JOR','0B','Blue Air','Blue Transport','ROMANIA',''),(725,'JZA','QK','Air Canada Jazz','Jazz','CANADA',''),(726,'KAC','KU','Kuwait Airways','Kuwaiti','KUWAIT','http://www.kuwait-airways.com'),(727,'KAL','KE','Korean Air','Koreanair','REPUBLIC OF KOREA','http://www.koreanair.com'),(728,'KAP','9K','Cape Air','Cair','UNITED STATES',''),(730,'KFR','IT','Kingfisher Airlines','Kingfisher','INDIA','http://www.flykingfisher.com'),(732,'KLM','KL','KLM Royal Dutch','KLM','THE NETHERLANDS','http://www.klm.com'),(735,'KOR','JS','Air Koryo','Air Koryo','NORTH KOREA','http://www.korea-dpr.com/airkoryo.htm'),(736,'KQA','KQ','Kenya Airways','Kenya','KENYA','http://www.kenya-airways.com'),(738,'LAA','LN','Libyan Arab Airlines','Libair','LIBYA',''),(739,'LAN','LA','LAN Airlines Argentina - Chile - Ecuador','Lan','PERU','http://www.lan.com'),(740,'LGL','LG','Luxair','Luxair','LUXEMBOURG',''),(744,'LLB','LB','Lloyd Aereo Boliviano','Lloyd Aero','BOLIVIA',''),(745,'LOF','AX','Trans States Airlines','Waterski','UNITED STATES',''),(746,'LOT','LO','LOT Polish Airlines','Pollot','POLAND','http://www.lot.com'),(747,'LPE','LP','LAN Peru','Lanperu','PERU',''),(748,'LTE','XO','LTE International Airways','Funjet','SPAIN',''),(749,'LTU','LT','LTU International','Ltu','GERMANY',''),(751,'LYC','L2','Lynden Air Cargo','Lynden','UNITED STATES',''),(754,'LYN','QH','Altyn Air','Altyn Avia','KRYGYZSTAN',''),(758,'LZB','FB','Bulgaria Air','Flying Bulgaria','BULGARIA',''),(762,'MAH','MA','Malev Hungarian Airlines','Malev','HUNGARY','http://www.malev.hu'),(763,'MAK','IN','Macedonian Airlines','Makavio','MACEDONIA',''),(764,'MAS','MH','Malaysia Airlines','Malaysian','MALAYSIA',''),(766,'MDL','RI','Mandala Airlines','Mandala','INDONESIA',''),(767,'MES','XJ','Mesaba Airlines','Mesaba','UNITED STATES','http://www.mesaba.com'),(769,'MGX','YM','Montenegro Airlines','Montair','SCG',''),(770,'MKU','WP','Island Air','Moku','UNITED STATES',''),(771,'MLA','Q5','40-Mile Air','Mile-Air','UNITED STATES',''),(772,'MON','ZB','Monarch Airlines','Monarch','UNITED KINGDOM',''),(773,'MPE','5T','Air Norterra','Empress','CANADA',''),(774,'MSR','MS','Egyptair','Egyptair','EGYPT',''),(775,'MXA','MX','Mexicana','Mexicana','MEXICO',''),(779,'NAC','NC','Northern Air Cargo Inc','Yukon','UNITED STATES',''),(789,'NAO','NA','North American Airlines Inc','North American','UNITED STATES',''),(796,'NAX','DY','Norwegian Air Shuttle','Nor Shuttle','NORWAY',''),(801,'NBK','F4','Albarka Air PLC','Al-Air','NIGERIA',''),(805,'NCA','KZ','Nippon Cargo Airlines','Nippon Cargo','JAPAN',''),(811,'NCH','3U','Chanchangi Airlines (Nigeria) Limited','Chanchangi','NIGERIA',''),(813,'NCM','P9','NAS Air SA','Air Bane','ANGOLA',''),(818,'NEA','EJ','New England Airlines','New England','UNITED STATES','http://www.block-island.com/nea/'),(819,'NGA','WT','Nigeria Airways','Nigeria','NIGERIA DEFUNCT',''),(820,'NKS','NK','Spirit Airlines','Spirit Wings','UNITED STATES','htpp://www.spiritair.com'),(821,'NWA','NW','Northwest Airlines','Northwest','UNITED STATES','http://www.nwa.com'),(826,'OAE','OY','Omni Air Express','Omni-Express','UNITED STATES',''),(827,'OAL','OA','Olympic Airlines','Olympic','GREECE',''),(830,'OAV','OC','Omni - Aviacao e Tecnologia','Omni','PORTUGAL',''),(831,'OAW','2L','Helvetic Airways','Helvetic','SWITZERLAND',''),(835,'OCA','R7','Aeroservicios Caraboba (ASERCA','Arosca','VENEZUELA',''),(839,'OCM','UQ','O\'Connor Airlines','Oconner','AUSTRALIA',''),(845,'ODS','5K','Odessa Airlines','Odessa','UKRAINE',''),(847,'OEA','OX','Orient Thai Airlines','Orient Air','THAILAND',''),(852,'OGE','KK','Atlas International','Atlasjet','TURKEY',''),(855,'OGN','QO','Origin Pacific Airways','Origin','NEW ZEALAND',''),(856,'OHY','8Q','Onur Air','Onur Air','TURKEY',''),(864,'OKS','S0','Slok Air International (Gambia)','Slok Gambia','GAMBIA',''),(866,'OLA','OJ','Overland Airways','Overland','NIGERIA',''),(871,'OLT','OL','Ostfriesische Lufttransport','Oltra','GERMANY',''),(875,'OMA','WY','Oman Air','Khanijar','OMAN',''),(881,'OMS','N3','Omskavia Airline','Omsk','RUSSIAN FEDERATION',''),(882,'ONE','O6','Ocenair - Linhas Aereas','Oceanair','BRAZIL',''),(886,'OOM','Z4','Zoom Airlines','Zoom','CANADA',''),(894,'ORB','R2','State Orenburg Avia Enterprise','Orenburg','RUSSIAN FEDERATION',''),(897,'ORF','RS','Oman Royal Flight','Oman','OMAN',''),(908,'ORT','UT','Air Orient','Air Orient','FRANCE',''),(913,'OSL','SO','Sosoliso Limited','Sosoliso','NIGERIA',''),(921,'OTL','YG','South Airlines','Southline','UKRAINE',''),(939,'OZR','ZO','Ozark Air Lines','Ozark','UNITED STATES',''),(943,'PAC','PO','Polar Air Cargo','POLAR','UNITED STATES','http://www.polaraircargo.com/'),(944,'PAL','PR','Philippine Airlines','PHILIPPINE','PHILIPPINES','http://www.philippineairlines.com/'),(945,'PAO','PH','Polynesian Airlines','POLYNESIAN','SAMOA','http://www.polynesianairlines.com/'),(946,'PBA','9Q','PB Air','PEEBEE AIR','THAILAND','http://www.pbair.com/'),(948,'PGT','1I','Pegasus Airlines','SUNTURK','TURKEY','http://www.flypgs.com/'),(949,'PIA','PK','Pakistan International Airlines','PAKISTAN','PAKISTAN','http://www.piac.com.pk'),(959,'QCL','QD','Air Class Lineas Aereas','ACLA','URUGUAY',''),(961,'QFA','QF','Qantas Airways','QANTAS','AUSTRALIA','http://www.qantas.com.au'),(968,'QNK','N2','Kabo Air','KABO','NIGERIA',''),(973,'QSC','QS','African Safari Airways','ZEBRA','KENYA','http://www.africansafariclub.com/html/flights.php'),(974,'QTR','QR','Qatar Airways','QATARI','QATAR','http://www.qatarairways.com/'),(980,'QXE','QX','Horizon Air','HORIZON AIR','USA','http://www.horizonair.com/'),(981,'RAM','AT','Royal Air Maroc','Royalair Maroc','MOROCCO)',''),(982,'REA','RE','Aer Arann','Aer Arann','IRELAND','http://www.aerarann.com'),(983,'RJA','RJ','Royal Jordanian Airlines','Jordanian','JORDAN','http://www.rja.com.jo'),(986,'ROT','RO','Tarom','Tarom','ROMANIA','http://www.tarom.ro'),(988,'RSO','E4','Aero Asia International','Aero Asia','PAKISTAN',''),(991,'RYA','7S','Ryan Air Services','Ryan Air','UNITED STATES',''),(992,'RYN','RD','Ryan International Airlines','Ryan International','UNITED STATES',''),(993,'RYR','FR','Ryanair','Ryanair','IRELAND','http://www.ryanair.com'),(994,'SAA','SA','South African Airways','Springbok','SOUTH AFRICA','http://www.flysaa.com'),(995,'SAB','SN','Sabena','Sabena','BELGIUM DEFUNCT',''),(996,'SAI','NL','Shaheen Air International','Shaheen Air','PAKISTAN',''),(997,'SAS','SK','Scandinavian Airlines System','Scandanavian','DENMARK/NORWAY/SWEDEN','http://www.scandanavian.net'),(999,'SCX','SY','Sun Country Airlines','Sun Country','UNITED STATES',''),(1003,'SIA','SQ','Singapore Airlines','Singapore','SINGAPORE','http://www.singaporeair.com'),(1005,'SKU','H2','Sky Airline','Aerosky','CHILE',''),(1006,'SKW','OO','SkyWest Airlines','Skywest','UNITED STATES','http://www.skywest.com'),(1007,'SLK','MI','SilkAir','Silkair','SINGAPORE',''),(1008,'SNG','V7','Air Senegal International','Air Sengal','SENEGAL',''),(1010,'SSV','5G','Skyservice','SkyService','CANADA','www.skyserviceairlines.com'),(1011,'SUD','SD','Sudan Airways','Sudanair','SUDAN',''),(1012,'SVA','SV','Saudi Arabian Airlines','Saudia','SAUDI ARABIA (EX SAUDI)',''),(1013,'SWA','WN','Southwest Airlines','Southwest','UNITED STATES','http://www.southwest.com'),(1015,'SWR','LX','Swiss International Air Lines','Swiss','SWITZERLAND (AIRLINEICAO PREVIOUSLY WITH SWISSAIR','http://www.swiss.com'),(1016,'TAI','TA','Taca International Airlines','Taca','EL SALVADOR',''),(1018,'TAP','TP','TAP Portugal','Air Portugal','PORTUGAL','http://www.tap.pt'),(1019,'TAR','TU','Tunisair','Tunair','TUNISIA',''),(1020,'TAT','LR','TACA/LACSA','Taca-Costarica','COSTA RICA',''),(1021,'TCF','S5','Shuttle America','Shuttlecraft','UNITED STATES',''),(1026,'THA','TG','Thai Airways International','Thai','THAILAND','http://www.thaiairways.com'),(1027,'THY','TK','Turkish Airlines','Turkair','TURKEY',''),(1029,'TOM','BY','Thomsonfly','Tomson','UNITED KINGDOM',''),(1030,'TPA','QT','Tampa','Tampa','COLOMBIA',''),(1031,'TRS','FL','AirTran Airways','Citrus','UNITED STATES',''),(1032,'TRZ','T9','TransMeridian Airlines','Trans-Meridian','UNITED STATES',''),(1033,'TSC','TS','Air Transat','Transat','CANADA/FRANCE',''),(1035,'TUB','JF','Jetairfly','Beauty','BELGIUM','http://www.Jetairfly.com'),(1036,'TYR','VO','Austrian Arrows','Tyrolean','AUSTRIA',''),(1037,'UAE','EK','Emirates','Emirates','UNITED ARAB EMIRATES','http://www.emirates.com'),(1038,'UAL','UA','United Airlines','United','UNITED STATES','http://www.united.com'),(1039,'UCA','C5','CommutAir','Commutair','UNITED STATES','http://www.commutair.com'),(1041,'UPS','5X','United Parcel Service','UPS','UNITED STATES','http://www.ups.com'),(1042,'USA','US','US Airways','U S Air','UNITED STATES','http://www.usairways.com'),(1043,'UYC','UY','Cameroon Airlines','Cam-Air','CAMEROON',''),(1044,'UZB','HY','Uzbekistan Airways','Uzbek','UZBEKISTAN',''),(1045,'VAP','9R','Phuket Air','Phuket Air','THAILAND','http://www.phuketairlines.com'),(1046,'VDA','VI','Volga-Dnepr Airlines','Volga-Dnepr','RUSSIA','http://www.voldn.ru'),(1049,'VEX','TV','Virgin Express','Virgin Express','BELGIUM','http://www.virgin-express.com'),(1051,'VIR','VS','Virgin Atlantic Airways','Virgin','UNITED KINGDOM','http://www.virgin-atlantic.com'),(1053,'VLG','VY','Vueling Airlines','Vueling','BARCELONA, SPAIN','http://www.vueling.com'),(1055,'VOZ','DJ','Virgin Blue','','AUSTRALIA','http://www.virginblue.com.au'),(1057,'VRG','RG','Varig','Varig','BRAZIL','http://www.varig.com'),(1060,'WJA','WS','WestJet','Westjet','CANADA',''),(1061,'WOA','WO','World Airways','World','UNITED STATES','www.worldairways.com'),(1064,'XAA','XA','Aeronautical Radio Inc','','UNITED STATES',''),(1077,'XBO','3Y','Baseops Internation','','UNITED STATES',''),(1103,'XLA','JN','Excel Airways','Expo','UNITED KINGDOM',''),(1111,'XME','XM','Australia Air Express','','AUSTRALIA',''),(1147,'YZR','Y8','Yangtze River Express Airlines','Yangtze River','CHINA',''),(1149,'ZAK','K8','Zambia Skyways Limited','Zambia Skies','ZAMBIA',''),(1150,'ZAN','VK','Zantop International Airlines','Zantop','UNITED STATES','http://www.flyzantop.com'),(1158,'SWG','WG','Sunwing Airlines','Sunwing','CANADA','www.flysunwing.com'),(1159,'SYR','RB','Syrian Arab Airlines','Syrian Air','SYRIA',NULL),(1160,'','TBA','A venir','A venir',NULL,NULL),(1161,'BHS','UP','Bahamas Air','Bahamas','Bahamas','www.bahamasair.com'),(1163,'VUN','VU',NULL,'Airivorie',NULL,NULL),(1164,'TAM','JJ','TAM','TAM','Brazil',NULL),(1165,'CRL','SS','Corsair','Corsair','France','www.corsair.fr'),(1166,'CHP','6A','Aviacsa','Aviacsa','MX','www.aviacsa.com.mx'),(1167,'S2S2','S2','JetLite','JetLite','CA',NULL),(1168,'TAO','VW','Aeromar','Aeromar','MX',NULL);
/*!40000 ALTER TABLE `AIRLINE` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2015-01-19 14:54:54
