Skip to content

Registered aircraft · 7,860

Aircraft with this engine in the FAA registry, by N-number.

Query with SQL

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE engine_model_code IN ('00000')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE engine_model_code IN ('00000')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N57TBluestein Ryan · Garland, TXBuilt 1975 · S/N 406 N5817XSmith Gregory A · Lewistown, MTS/N 5026 N581AClosson Luke E Jr · Valdosta, GAS/N 7233 N581DBBaldassarri Giuseppe · Carrollton, GABuilt 1977 · S/N 262 N5825VFriend Jeffrey L · Omaha, NEBuilt 1964 · S/N 263 N5826VSky Sailing Inc · Warner Springs, CABuilt 1964 · S/N 3 N5828VGoofys Glider Club · Wichita, KSBuilt 1964 · S/N 202 N5828YWard Hal K Trustee · Wasilla, AKS/N G3-5939 N5829VBarkow Thomas A · Manchaca, TXBuilt 1964 · S/N 264 N582KAPfeiffer Neal J · Wichita, KSBuilt 1958 · S/N 03 N582RCNeal Michael · Port Charlotte, FLBuilt 1986 · S/N 76 N5831VWilkinson Ephriam B · Eads, TNBuilt 1964 · S/N 259 N58321Gradwell Dean H · Jacksonville, ORBuilt 1943 · S/N 151 N5833VIroquois Soaring Association · Rome, NYBuilt 1966 · S/N 266 N5834VCreech Daniel B · Chewelah, WABuilt 1964 · S/N 267 N5836VBlace Mark P · Luthersville, GAS/N 269 N5839VFueston Vernon A · Montague, CABuilt 1964 · S/N 272 N5842VSchultz Todd H · Bakersfield, CABuilt 1964 · S/N 273 N5844VNezgoda Daniel W · Hope Hull, ALFirst renewal noticeBuilt 1964 · S/N 274 N584MKJenkins Robin · Alvarado, TXBuilt 2001 · S/N 3E496 N584TBurch Preston M · Sykesville, MDBuilt 1961 · S/N 934 N584ZRStar Trail Inc · Albuquerque, NMS/N 026 N585Gehrlein Jay L · Waterford, PABuilt 1976 · S/N 477 N585LBTzr Group LLC · Knoxville, TNBuilt 2017 · S/N 5616 N5880Cato Josh · Reno, TXBuilt 2022 · S/N BB-003 N588MPedreiro Sergio · Greenwich, CTBuilt 1966 · S/N 4049 N5895Churchman Harrison · Mcdonough, GABuilt 2007 · S/N S60A-3290 N5897X3 Hanging 9 Enterprizes LLC · Lewistown, MTS/N 7GCAA161M N58DPPayne Ralph J · Hastings, MIBuilt 1973 · S/N 654 N58HRNorris James M · Santa Barbara, CABuilt 1998 · S/N 71 N58KGMcguire James Jared · Athens, PAS/N 101A0203 N58PSSterbonic Peter D · Wickenburg, AZS/N EU-180 N58RWMudd Robert J · Moriarty, NMBuilt 1999 · S/N 2014 N58UMMay First Inc · Fishers, INBuilt 2026 · S/N 130/117 N5911Montague Mark W · Reno, NVBuilt 1967 · S/N 53 N5912Jones Stephen C · Wadsworth, ILS/N 46 N59125Baldwin Roger L · Bosque Farms, NMBuilt 2002 · S/N FMB-200270 N591KYBb Aero Works Ltd · Whitehouse, OHBuilt 2025 · S/N LP2025-03 N591MHGrant Richard · Eugene, ORS/N 1793 N591SZRovey Jonathan E · Sedona, AZS/N B-2168 N59256Seymour David E · Evergreen, COBuilt 1966 · S/N 4057 N592BBBroker William · Wylie, TXBuilt 2023 · S/N 008 N59328Msu Soaring Club Inc · Mississippi State, MSBuilt 1970 · S/N 32 N593ZSSkites Walter W · Salome, AZBuilt 1995 · S/N SNR 0695 N5945Grant Richard M · Eugene, ORBuilt 1971 · S/N 1739 N594KSHenderson John M · Moses Lake, WAS/N 21218 N594LPSager Christian T · Hartford, CTBuilt 1994 · S/N 1 N594TWHsu Chih Yuan · Glendora, CABuilt 2012 · S/N 6654 N5952VDorman Richard E · Mesa, WAS/N 56 N595BGPeterson Michael K · Lexington Park, MDBuilt 1995 · S/N B-2161