NOTE: In order to import this dataset, use import mode CSV using LOAD DATA. Fields are terminated by ';', escaped by '\', and they are not enclosed by any character.

• Aircrafts

  Name	Name of the aircraft.
  ICAO	4-letter ICAO code, if available.
  IATA	3-letter IATA code (identifier).
  Capacity	Seating capacity (empty for cargo aircrafts).
  Country	Country or territory where aircraft maker is incorporated.

  Sample data:

  Boeing 737-800 (winglets) pax;B738;73H;162;United States
  Boeing 737-200 Combi;B732;73M;\N;United States
  Boeing 737-700 (winglets) pax;B737;73W;126;United States
  Boeing 737-200 Freighter;B732;73X;\N;United States
  Boeing 737-300 Freighter;B733;73Y;\N;United States
  Boeing 747-100 pax;B741;741;452;United States
  Boeing 747-200 pax;B742;742;452;United States
  Boeing 747-300 pax;B743;743;420;United States
  Boeing 747-400 pax;B744;744;416;United States
  Boeing 747 all pax models;\N;747;416;United States
  

• Airlines

  Name	Name of the airline.
  IATA	2-letter IATA code (identifier).
  ICAO	3-letter ICAO code, if available.
  Callsign	Airline callsign.
  Country	Country or territory where airline is incorporated.

  Sample data:

  Air Exel;XT;AXL;EXEL COMMUTER;Netherlands
  Air Fiji;PC;FAJ;FIJIAIR;Fiji
  Air Finland;OF;FIF;AIR FINLAND;Finland
  Air Florida;QH;FLZ;AIR FLORIDA;United States
  Air Foyle;GS;UPA;FOYLE;United Kingdom
  Air France;AF;AFR;AIRFRANS;France
  Air Gabon;GN;AGN;GOLF NOVEMBER;Gabon
  Air Georgia;DA;GRG;AIR GEORGIA;Georgia
  Air Georgian;ZX;GGN;GEORGIAN;Canada
  Air Glaciers;7T;AGV;AIR GLACIERS;Switzerland
  Air Greenland;GL;GRL;GREENLAND;Denmark
  

• Airports

  Name	Name of airport. May or may not contain the City name.
  City	Main city served by airport. May be spelled differently from Name.
  Country	Country or territory where airport is located.
  IATA	3-letter IATA code (identifier).
  ICAO	4-letter ICAO code.
  Latitude	Decimal degrees, usually to six significant digits. Negative is South, positive is North.
  Longitude	Decimal degrees, usually to six significant digits. Negative is West, positive is East.
  Altitude	In feet.
  Timezone	Hours offset from UTC.
  DST	Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None) or U (Unknown).

  Sample data:

  Changzhou;Changzhou;China;CZX;ZSCG;31.941667;119.711667;39;+0800;U
  Chapada Diamantina Airport;Lençóis;Brazil;LEC;SBLE;-12.4823;-41.277;1676;-0300;U
  Chapais Airport;Chibougamau;Canada;YMT;CYMT;49.7719;-74.5281;1270;-0500;A
  Chapeco;Chapeco;Brazil;XAP;SBCH;-27.134219;-52.656553;2146;-0300;U
  Chapleau;Chapleau;Canada;YLD;CYLD;47.82;-83.346667;1470;-0500;A
  Charles De Gaulle;Paris;France;CDG;LFPG;49.012779;2.55;392;+0100;E
  Charleston Afb Intl;Charleston;United States;CHS;KCHS;32.898647;-80.040528;45;-0500;A
  Charleville;Charlieville;Australia;CTL;YBCV;-26.413334;146.2625;1003;+1000;O
  Charlo;Charlo;Canada;YCL;CYCL;47.990833;-66.330278;132;-0400;A
  Charlotte Douglas Intl;Charlotte;United States;CLT;KCLT;35.214;-80.943139;748;-0500;A
  Charlottesville-Albemarle;Charlottesville VA;United States;CHO;KCHO;38.138639;-78.452861;639;-0500;A
  

• Distance

  Airport1	IATA 3-letter code for airport #1.
  Airport2	IATA 3-letter code for airport #2.
  Distance	Distance in kilometers between airport #1 and airport #2.

  Sample data:

  CDG;DFW;7962.625
  CDG;HEL;1900.066
  CDG;HKG;9624.070
  CDG;JFK;5849.491
  CDG;LHR;348.229
  CDG;MIA;7384.878
  CDG;NGO;9674.928
  CDG;NRT;9733.829
  CDG;ORD;6682.783
  CEB;HKG;1689.296
  

• Schedule

  Valid from 2-Jan-2009 to 30-Jan-2009

  From	Departure airport (3-letter IATA code).
  To	Arrival airport (3-letter IATA code).
  Valid-From	Begining of the schedule validity (2-Jan-2009 if not specified).
  Valid-Until	End of the schedule validity (30-Jan-2009 if not specified).
  Days	Days of operation (1=Monday, 2=Tuesday, 3=Wednesday, 4=Thursday, 5=Friday, 6=Saturday, 7=Sunday)
  Departure	Departure time (hh:mm).
  Arrival	Arrival time (hh:mm or hh:mm+N, +N=Arrival N days later).
  Flight	Flight information (2-letter IATA airline code + flight number).
  Aircraft	3-letter IATA aircraft code.
  Duration	Flight duration (hh:mm).

  Sample data:

  CDG;JFK;\N;\N;1234567;11:15;13:55;AA45;763;08:40
  CDG;JFK;\N;\N;13567;17:50;20:35;AA121;763;08:45
  CDG;JFK;\N;\N;13567;17:50;20:35;AA121;763;08:45
  CDG;LHR;2009-01-17;\N;123467;21:45;21:55;BA329;319;01:10
  CDG;LHR;2009-01-17;\N;123467;21:45;21:55;BA329;319;01:10
  CDG;LHR;2009-01-24;\N;1234567;10:30;11:00;BA307;319;01:30
  CDG;LHR;2009-01-24;\N;1234567;10:30;11:00;BA307;319;01:30
  CDG;LHR;2009-01-29;\N;4;19:20;19:45;BA325;320;01:25
  CDG;LHR;2009-01-29;\N;4;19:20;19:45;BA325;320;01:25
  CDG;LHR;\N;2009-01-02;5;21:45;21:55;BA329;319;01:10