Aircraft Hexcode Fixes
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 |
|---|---|
| hexcode_fixes.csv | Sample data for commercial aviation and business jets |
| Column | Data Type | Data description | Package Required | Key | Data Set | Join On |
|---|---|---|---|---|---|---|
| hexcode | char(6) | Incorrect ICAO 24-bit address/Mode-S hexcode | Hexcode fixes | |||
| hexcode_fixed | char(6) | Corrected ICAO 24-bit address/Mode-S hexcode | Hexcode fixes | |||
| start_date | date | Date the record's validity begins | Hexcode fixes | |||
| end_date | date | Date the record's validity ends | Hexcode fixes | |||
| callsign | varchar(255) | Flight callsign | Hexcode fixes | |||
| callsign_icao | varchar(3) | Callsign operator ICAO three-character code | Hexcode fixes | |||
| hexcode_id | varchar(32) | Unique identifier for each hexcode, generated as an MD5 hash of the hexcode, hexcode_fixed, start_date, end_date. Stable as long as the combination of underlying data does not change (it changes if data is adjusted or improved by ch-aviation). | Hexcode fixes | Primary |