Airports May 2024

Login or register to download files

Raw file: All Airports Data May2024.csv (4.58 MB)

Includes 19889 locations in the following areas:

• United States: AK, AL, AR, AZ, CA, CO, CT, DE, FL, GA, HI, IA, ID, IL, IN, KS, KY, LA, MA, MD, ME, MI, MN, MO, MS, MT, NC, ND, NE, NH, NJ, NM, NV, NY, OH, OK, OR, PA, RI, SC, SD, TN, TX, UT, VA, VT, WA, WI, WV, WY
• Canada: AB, BC, MB, NB, NS, NT, ON, PE, QC, YT
• some may be in: DC, MEX, SK (near a border)

143 location(s) outside USA/Canada

I am forwarding 2 CSV files: All Airports Data May2024.csv and All Runway Data May2024.csv.
You can post these files if you think any of your members might be interested in them.
All information was extracted from the Airport Data and Information site file Published 5010, all-airport-data.xlsx.
NOTE: This information is NOT for navigational use.

Both files have a listing within Column C [LocID] which designation is unique to each airport; therefore, it is best to use this designation for any airport search in Column C. Each has ()'s before and after the designation such as (LocID CEF). This ID is for Westover AFB in Chicopee, MA. Be sure to use the ()'s so names within Column C that contain cef will not be brought up as part of the search.

In All Airporrts Data May2024.csv: Column A = Longitude; Column B = Latitude; Column C = LocID, Airport name, SiteID, and Airport Type; Column D = Address, City State Zip, Phone, Elevation,Sectional Chart name, frequencies for Unicom and CTAF, Magnetic variation of facility, and I append the Longitude and Latitude at the end so it is viewable as information on my Garmin GPS.

In All Runways Data May2024.csv: Columna A = Longitude; Column B= Latitude; Column C = LocID and Airport name; Column D = Runway ID, Runway Length, Runway width, Runway Surface, and again I append the Longitude and Latitude.

The Letters listed within the SiteID are: A = Airport; B = Balloonport; C = Seapane Base; G = Gliderport; H = Heliport; and U = Ultralight.

Example for search of (cef) in All Airports Data May2024.csv brings up:
Column A = Longitude
Column B = Latitude
Column C = LocID (CEF) Westover ARB/Metro [SiteID (09304.02*A)] Type= Airport
Column D = 439th OSS/OSA 750 HANGER AVE CHICOPEE, MA 01022 413-557-2187 Elev= 241.1 [ Sect= NEW YORK] [Unicom= 122.950]
[CTAF= 134.850] [Mag Var= 14W] Longitude then Latitude

Example for search of (cef) in All Runway Data May2024.csv brings up 2 entries (2 runways)
Column A = Longitude
Column B = Latitude
Column C = [LocID: (CEF)] [Airport Name: WESTOVER ARB/METRO]
Column D = [Rnwy ID= 05/23] [Length= 11597] [Width= 300] [Surface= ASPH-G] Longitude/Latitude
the second runway entry is
Column A = Longitude
Column B = Latitude
Column C = [LocID: (CEF)] [Airport Name: WESTOVER ARB/METRO]
Column D = [Rnwy ID= 15/33] [Length= 7085] [Width= 150] [Surface= ASPH-G] Longitude/Latitude