Countries

Column Data Type Data description Package required Key Data Set Join On
ID int(11) Unique ch-aviation created country ID Airports Primary    
Country ISO char(2) ISO 3166-1 Alpha-2 country code Airports Unique    
Country Name varchar(255) Country name Airports      
Continent varchar(255) Continent name Airports      
Registration varchar(255) Aircraft registration prefix(es) for the country Airports      
IASAWS char(1) Country International Aviation Safety Assessment program status (assigned by FAA): 0 – not assessed / 1 – Category 1 (meets ICAO standards) / 2 – Category 2 (does not meet ICAO standards) Airports      
GDPR Country char(3) European Union country where GDPR regulations apply: Yes / No / (NULL) Airports