Aircraft Owner Contacts

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
aircraft_owner_contacts.csvSample data for commercial aviation
ColumnData TypeData descriptionPackage requiredKeyData SetJoin On
Contact IDint(11)Unique ch-aviation created contact IDAircraft Owner ContactsPrimary
Entity Namevarchar(255)Entity nameAircraft Owner Contacts
Entity ch-a Codevarchar(4)Entity ch-aviation code (assigned by ch-aviation)Aircraft Owner ContactsForeignEntitiesEntity ch-a Code
Legal Namevarchar(255)Entity legal nameAircraft Owner Contacts
Entity Typeint(11)Entity typeAircraft Owner Contacts
Entity Type Codechar(1)Entity type code (E: Engine Manufacturer, I: IT Provider, L: Lessor, X: Cargo Customer/Forwarder)Aircraft Owner Contacts
Locationvarchar(255)Location airport name (closest airport if not based at airport itself)Aircraft Owner Contacts
Location IDint(11)Location ID (assigned by ch-aviation)Aircraft Owner ContactsForeignAirportsAirport ID
Countryvarchar(255)Country nameAircraft Owner Contacts
Country ISOchar(2)ISO 3166-1 Alpha-2 country codeAircraft Owner ContactsForeignCountriesCountry ISO
EU Countrychar(1)European Union country: Yes / No / (NULL)Aircraft Owner Contacts
Titlechar(2)Mr / MsAircraft Owner Contacts
Firstnamevarchar(48)First nameAircraft Owner Contacts
Lastnamevarchar(48)Last nameAircraft Owner Contacts
Job Groupvarchar(48)Job Group description (for filtering purposes)Aircraft Owner Contacts
Job Titlevarchar(127)Job titleAircraft Owner Contacts
Emailvarchar(255)E-Mail address (masked in sample data)Aircraft Owner Contacts
Social Mediavarchar(255)Social media URLAircraft Owner Contacts