Skip to content

Registered aircraft · 7,853

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.

N2269SMartens Eric A · Indianola, IABuilt 2007 · S/N 361 N226AMueller Douglas G · Boulder City, NVBuilt 1983 · S/N 20704 N226CCCollins Dennis L · Richland, WABuilt 1996 · S/N 20 N226HRHolsinger David E · Raphine, VABuilt 2017 · S/N 001 N226ZDCt Ballooning LLC · Kensington, CTBuilt 2017 · S/N 5624 N22751Advantage Aerosports · Phoenix, AZBuilt 2008 · S/N 6522 N2277BBuckner Jason A · Albuquerque, NMBuilt 2014 · S/N ZR-7002 N227BBDerosa John H · West Dundee, ILBuilt 2002 · S/N 27181 N227CBEscape Adventures Inc · Temecula, CABuilt 1980 · S/N 611 N227CDMagpie Aviation Inc · Hayward, CABuilt 1978 · S/N 20592 N227DWDutka Leslie A · Pittsburgh, PABuilt 2002 · S/N 27200 N227MGRegistered aircraftRegistration pendingBuilt 1998 · S/N 27099 N227NGBaker Gary L · Monument, COS/N 27199 N227PNSexton James R · Kinards, SCBuilt 1959 · S/N 673 N227SDMinar Steven H · Bend, ORBuilt 2001 · S/N 27173 N227TCEagy Gregory L · Boise, IDBuilt 1992 · S/N 2067USA N227ZBluhm Eric H · Minneapolis, MNBuilt 1988 · S/N 120450 N22817Hinckley David D · Belton, TXBuilt 1979 · S/N AK2 N2285SPlonk Daniel W · Chiefland, FLS/N R18201324 N2287ZGunter Ryan S · Albuquerque, NMBuilt 1979 · S/N 001 N228BGUtah Soaring Association Inc · Mapleton, UTBuilt 1985 · S/N 33995-K-228 N228JAir Carriage LLC · San Marcos, TXS/N 1573 N228JGDe Rham Jacques H · Bellevue, WABuilt 2002 · S/N 28061 N228TYThank You Balloon Project Co · Stamford, CTBuilt 2021 · S/N WD200408K N2295MGoebel William R · Rhome, TXBuilt 1947 · S/N 40A N229CWHill Steven S · Tijeras, NMBuilt 2008 · S/N 29036 N229TCGet High Inc · Longview, TXBuilt 1991 · S/N 2095USA N229TDEklund Don C II · Yorba Linda, CABuilt 2012 · S/N 29072 N22DZBoone Jerry W · Hutchinson, KSBuilt 1978 · S/N 4 N22PMIreland Robert C · Mount Shasta, CAS/N 9 N22RFGray David M · Albuquerque, NMBuilt 1969 · S/N 891 N22RHArcher James P · Bend, ORBuilt 1982 · S/N 80 N22SQMertins Enrique · Parrish, FLS/N 27148 N22UUChow Timothy · Norwich, VTBuilt 1977 · S/N 20511 N22ZAPmp55 LLC · Slingerlands, NYS/N 51207 N22ZBCollegiate Soaring Association Inc · Greeley, COBuilt 1976 · S/N 1309 N2303ADuke Kay · Darrouzett, TXBuilt 1978 · S/N 122 N2304ADavis Daniel W Jr · Peoria, AZBuilt 2008 · S/N 6546 N2304JNapa Valley Balloons Inc · Napa, CABuilt 2012 · S/N 6633 N2306Sanders Dennis R · Ione, CABuilt 1971 · S/N 34 N230DBTauber David B · New Castle, NHBuilt 1979 · S/N 20263 N230GWahl John F · Edgewood, NMBuilt 1970 · S/N 132 N230KBig Sky Ventus LLC · Anaconda, MTBuilt 2001 · S/N 64 N230LBDorshorst Terry · West Salem, WIBuilt 2008 · S/N 5393 N230XFWalker Neiman J · Denton, TXBuilt 1972 · S/N 209 N23130Mayes Brett R · Williams, CABuilt 1991 · S/N 23130 N23136Mayes Brett R · Williams, CABuilt 1994 · S/N 23136 N231LSSale Reported · Jefferson, GASale reported, pending cancellationBuilt 1993 · S/N 938020 N231SLBaker Kenneth J · Norridgewock, MEBuilt 1964 · S/N 68 N2321DBalloonstormers Inc · Ashland, MOBuilt 2016 · S/N 1223