Flight Number Decoding

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
flight_number_decoding.csvSample data for commercial aviation
ColumnData TypeData descriptionKeyData SetJoin On
ch_code_operatorvarchar(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
icaochar(3)Callsign operator ICAO three-character codePrimary (combined)
flight_numbervarchar(4)Callsign flight numberPrimary (combined)
suffixvarchar(1)Callsign suffixPrimary (combined)
flight_typevarchar(20)Indicator of special flight types (ferry, technical, training)
ch_code_regional_partnershipvarchar(5)ch-aviation code for the carrier the regional partnership flights are operated for (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters.Primary (combined)/ForeignOperatorsOperator ch-a Code
regional_partnershipvarchar(255)Regional partnership name under which the flight is operatedForeignRegional SubsidiariesRel Subsidiary
ch_code_cargo_customervarchar(5)Cargo customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.Primary (combined)/ForeignEntitiesEntity ch-a Code
cargo_customervarchar(255)Name of cargo customer for whom the flight is operated
ch_code_wet_lease_customervarchar(5)Wet lease customer ch-aviation code (assigned by ch-aviation). Can be 2, 3, 4, or 5 characters.Primary (combined)/ForeignEntitiesEntity ch-a Code
wet_lease_customervarchar(255)Wet lease customer name
notesvarchar(255)Additional free text notes related to the flight
flight_number_decoding_idvarchar(32)Generated row id: MD5 of ch_code_operator, icao, flight_number, suffix, ch_code_regional_partnership, ch_code_cargo_customer and ch_code_wet_lease_customer (empty values as empty text, separated by '|'). Stable as long as these values do not change.