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.

To access the full sample data set on Snowflake, visit the ch-aviation profile on Snowflake Marketplace here.

Sample File NameSample Description
frequencies_flown_adsb_bizjets.csvSubset for business jets
frequencies_flown_adsb_comav.csvSubset for commercial aviation
frequencies_flown_adsb.csvSample data for commercial aviation and business jets
ColumnData TypeData descriptionKeyData SetJoin On
operator_namevarchar(255)Operator name
operator_ch_codevarchar(5)Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.Primary (combined)/ForeignOperatorsOperator ch-a Code
aircraft_variantvarchar(255)Aircraft Variant designation (i.e. A321-200N)Primary (combined)/ForeignAircraft Variantsvariant_text
origin_airport_namevarchar(255)Origin airport display name (combination of City Name and Airport Name)
origin_airport_icaovarchar(6)Origin airport ICAO codePrimary (combined)/ForeignAirportsAirport ICAO
origin_airport_iatavarchar(3)Origin airport IATA codeForeignAirportsAirport IATA
origin_continentvarchar(255)Origin airport continent name
origin_airport_country_namevarchar(255)Origin airport country name
origin_airport_country_iso_codechar(2)Origin airport ISO 3166-1 Alpha-2 country codePrimary (combined)/ForeignCountriesCountry ISO
origin_subdivisionvarchar(255)Origin airport state name
origin_subdivision_cha_codechar(2)Origin airport ISO 3166-2 Alpha-2 subdivision code (used for states)
destination_airport_namevarchar(255)Destination airport display name (combination of City Name and Airport Name)
destination_airport_icaovarchar(6)Destination airport ICAO codePrimary (combined)/ForeignAirportsAirport ICAO
destination_airport_iatavarchar(3)Destination airport IATA codeForeignAirportsAirport IATA
destination_continentvarchar(255)Destination airport continent name
destination_airport_country_namevarchar(255)Destination airport country name
destination_airport_country_iso_codechar(2)Destination airport ISO 3166-1 Alpha-2 country codePrimary (combined)/ForeignCountriesCountry ISO
destination_subdivisionvarchar(255)Destination airport state name
destination_subdivision_cha_codechar(2)Destination airport ISO 3166-2 Alpha-2 subdivision code (used for states)
monthint(2)Month of the flights (1-12).Primary (combined)
yearint(4)Year of flightsPrimary (combined)
number_of_flightsint(8)Total number of flights flown on the route in the month.
total_cargo_capacity_kgint(8)Total cargo capacity (kg)
total_cargo_capacity_lbdecimal(15,2)Total cargo capacity (lb)