Operator Historical ICAO Codes
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 Name | Sample Description |
|---|---|
| operator_historical_icao_codes.csv | Sample data for operator historical icao codes |
| Column | Data Type | Data description | Package required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| id | int(4) | Auto increment historical icao code | Historical ICAO codes | Primary | ||
| operator_icao | varchar(3) | Operator ICAO three-character code | Historical ICAO codes | |||
| exact_icao_start_date | date | The date the ICAO code became effective for this operator in yyyy-mm-dd format | Historical ICAO codes | |||
| exact_icao_end_date | date | The date the ICAO code ceased to be active for this operator in yyyy-mm-dd format (empty if current) | Historical ICAO codes | |||
| operator_ch_code | varchar(5) | Operator ch-aviation code (assigned by ch-aviation). Operator ch-aviation codes can be 2, 3, or 5 characters (empty if the operator is not part of the ch-aviation database) | Historical ICAO codes | Foreign | Operators | Operator ch-a Code |
| operator_name | varchar(255) | Operator name | Historical ICAO codes | |||
| note | varchar(255) | Additional context | Historical ICAO codes | |||
| country_iso | char(2) | ISO 3166-1 Alpha-2 country code | Historical ICAO codes | Foreign | Countries | Country ISO |