Frequencies – Flown (ADS-B based)

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)
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