Frequencies – Flown (ADS-B based)

To access the full sample data set on Amazon Web Services manually or programmatically, the S3 bucket URLs are provided here.

To get user name and password for manual access or access key and secret key for programmatic access, contact sales@ch-aviation.com.

ColumnData TypeData descriptionKeyData SetJoin On
operator_ch_codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.ForeignOperatorsOperator ch-a Code
operator_namevarchar(255)Operator name
aircraft_variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)ForeignAircraft Variantsvariant_text
origin_airport_icaovarchar(6)Origin airport ICAO codeForeignAirportsAirport ICAO
origin_airport_iatavarchar(6)Origin airport IATA codeForeignAirportsAirport IATA
origin_airport_namevarchar(255)Origin airport display name (combination of City Name and Airport Name)
origin_airport_country_iso_codechar(2)Origin airport ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
origin_airport_country_namevarchar(255)Origin airport country name
origin_continentvarchar(255)Origin airport continent name
destination_airport_icaovarchar(6)Destination airport ICAO codeForeignAirportsAirport ICAO
destination_airport_iatavarchar(6)Destination airport IATA codeForeignAirportsAirport IATA
destination_airport_namevarchar(255)Destination airport display name (combination of City Name and Airport Name)
destination_airport_country_iso_codechar(2)Destination airport ISO 3166-1 Alpha-2 country codeForeignCountriesCountry ISO
destination_airport_country_namevarchar(255)Destination airport country name
destination_continentvarchar(255)Destination airport continent name
monthint(2)month of flights
yearint(4)year of flights
number_of_flightsint(8)total number of flights