Data Airlines

Airline

Last imported 03:02AM UTC on Tuesday, March 26, 2013. See log

Airlines (e.g. Virgin America).

As there is no single widely-used airline code system we maintain a list of airlines that includes ICAO, IATA, and BTS codes. BTS 'unique carrier' codes come from the U.S. BTS lookup table. ICAO and IATA codes come from a proprietary data set, supplemented by Brighter Planet research.

Citing this data

To cite this data, reference Brighter Planet, "Airlines," <http://data.brighterplanet.com/airlines>, retrieved 2013-05-26 04:57:28 UTC.

Download

Total: 2,527 records.

Random data sample

Sample: 5 records.

name secondary name bts code iata code icao code
1time Airline 1T RNX
40-Mile Air Q5
748 Air Services SVT
A Soriano Aviation SOY
A/S Conair CIQ

Import steps

Click a step for more detail.

  1. Import the BTS unique carrier code lookup table

    1. Fetch data from www.transtats.bts.gov.
    2. Apply errata.
    3. Store
      • name
      • secondary_name
      • bts_code
      .

  2. Import ICAO and IATA codes from a proprietary dataset

    1. Fetch data from .
    2. Apply errata.
    3. Store
      • name
      • iata_code
      • icao_code
      .

  3. Import airlines not included in other sources

    1. Fetch data from .
    2. Store
      • name
      • icao_code
      • iata_code
      .

Table structure

CREATE TABLE airlines
  (
     name           CHARACTER VARYING(255) NOT NULL PRIMARY KEY,
     secondary_name CHARACTER VARYING(255),
     bts_code       CHARACTER VARYING(255),
     iata_code      CHARACTER VARYING(255),
     icao_code      CHARACTER VARYING(255)
  );