Aircraft Owner Contacts

Column Data Type Data description Package required Key Data Set Join On
Contact ID int(11) Unique ch-aviation created contact ID Entity Contacts Primary
Entity Name varchar(255) Entity name Entity Contacts
Entity ch-a Code varchar(4) Entity ch-aviation code (assigned by ch-aviation) Entity Contacts Foreign Entities Entity ch-a Code
Legal Name varchar(255) Entity legal name Entity Contacts
Entity Type int(11) Entity type Entity Contacts
Entity Type Code char(1) Entity type code (E: Engine Manufacturer, I: IT Provider, L: Lessor, X: Cargo Customer/Forwarder) Entity Contacts
Location varchar(255) Location airport name (closest airport if not based at airport itself) Entity Contacts
Location ID int(11) Location ID (assigned by ch-aviation) Entity Contacts Foreign Airports Airport ID
Country varchar(255) Country name Entity Contacts
Country ISO char(2) ISO 3166-1 Alpha-2 country code Entity Contacts Foreign Countries Country ISO
EU Country char(1) European Union country: Yes / No / (NULL) Entity Contacts
Title char(2) Mr / Ms Entity Contacts
Firstname varchar(48) First name Entity Contacts
Lastname varchar(48) Last name Entity Contacts
Job Group varchar(48) Job Group description (for filtering purposes) Entity Contacts
Job Title varchar(127) Job title Entity Contacts
Email varchar(255) E-Mail address (masked in sample data) Entity Contacts
Social Media varchar(255) Social media URL Entity Contacts