inconsistancy in IATA code and FAA code.
In the website, http://openflights.org/data.html quote: " IATA/FAA 3-letter FAA code, for airports located in Country "United States of America". 3-letter IATA code, for all other airports. Blank if not assigned. " However, I found at least two airports that are in United States and using IATA code instead of FAA code. 4088, "McClellan-Palomar Airport","Carlsbad","United States","CLD","KCRQ",33.0742,-117.1648,328,-8,"A","America/Los_Angeles" "CLD" is actually IATA code. and the FAA code is "CRQ". 6505,"Phoenix-Mesa Gateway","Mesa","United States","AZA","KIWA",33.307833,-111.655,1382,-7,"N","America/Phoenix" "AZA" is IATA code, and the FAA code is "IWA".
I would suggest to separate IATA code with FAA code into two columns.