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.

N1795Fowler Larry K · Harrison, ARBuilt 1967 · S/N 025 N17950Aero Club Albatross · Blairstown, NJBuilt 1972 · S/N 550 N17952Conner Walter L · Los Lunas, NMBuilt 1973 · S/N 552 N17953Csa Foundation Inc · Fort Collins, COBuilt 1973 · S/N 553 N17956Long Island Soaring Association · Yaphank, NYBuilt 1973 · S/N 286 N17960Dmc Aircraft LLC · Naples, FLBuilt 1972 · S/N 260 N17967Post Mills Soaring Club · Lyme, NHBuilt 1973 · S/N 277 N17968Northampton Aeronautics Inc · Northampton, MABuilt 1973 · S/N 270 N17969Fremont Glider Club · Rothbury, MIBuilt 1973 · S/N 269 N17970Up Up & Away LLC · Stowe, VTBuilt 1973 · S/N 80 N17971West Michigan Aviation Academy · Grand Rapids, MIBuilt 1973 · S/N 271 N17973Sale Reported · Marion, TXSale reportedBuilt 1972 · S/N 73 N17974Bates William S · Burlington, WVBuilt 1972 · S/N 74 N17975Worthington Gary J · Conneaut Lake, PAS/N 75 N1799GShields Chase B · Portland, ORBuilt 2014 · S/N 5561 N179BNNoe William Dean · Gallup, NMBuilt 2015 · S/N 6754 N179EHoke Michael J · Highlands Ranch, COBuilt 1965 · S/N 1471 N179KSHollister Soaring Center LLC · Hollister, CAS/N 21236 N17ASMarcus Barry A · Saint Louis, MOBuilt 1973 · S/N 419 N17BIndrebo James E · Healdsburg, CABuilt 1966 · S/N 21 N17BFDienst Lon C · Poplar Grove, ILBuilt 1985 · S/N BF-02 N17GHButler Ian A · Ballston Lake, NYBuilt 1976 · S/N 73G3 N17HUFronius Douglas · Poway, CAS/N 02 N17HWHanke Tim P · Ballston Spa, NYBuilt 2002 · S/N 350 CS N17RWMuncey H Michael · Trabuco Canyon, CABuilt 1979 · S/N 20271 N17SBSeattle Ballooning LLC · Burien, WABuilt 2021 · S/N 5737 N17SZAgcsc Foundation Inc · Jacumba, CABuilt 1997 · S/N B-2156 N17TDHull William L · Silver Springs, NVS/N 556 N17VDDaumas Alain · Hopewell, NJBuilt 2023 · S/N 312 N17ZZWinch Me Aviation LLC · Wurtsboro, NYBuilt 1986 · S/N 20807 N1800SEdwards Joseph C · Austin, ARBuilt 1982 · S/N 171 N1809Barrett Bruce S · Sebastian, FLBuilt 1999 · S/N 048 N180DBBarry John L · Aurora, COBuilt 1985 · S/N 4516 N180GSAmerican Balloon Promotions Inc DBA · Fenton, MIBuilt 1990 · S/N 5618 N180GWDiamant 165 LLC · Stanwood, WABuilt 1971 · S/N 079 N180KBBarrett Dennis F · Temecula, CAS/N 1182 N180LBDugger Christopher R · Grand Bay, ALBuilt 2008 · S/N 5412 N180TZRegistration Pending · Pagosa Springs, CORegistration pendingBuilt 2021 · S/N 180/151 N1810Kacin Randolph T · Brighton, MIBuilt 1968 · S/N 021 N1811TWahl John F · Edgewood, NMBuilt 1969 · S/N 107 N1811WMorgan Robert · Tehachapi, CABuilt 2000 · S/N 262 N1812BTake U Higher LLC · Powell, OHBuilt 2016 · S/N 5611 N18153Wengair LLC · Powell, WYBuilt 1938 · S/N 205 N181SHMastis Linas V · West Bloomfield, MIBuilt 2010 · S/N LP2010-01 N181WDDoiron W David · Tempe, AZS/N 460 N1822TBoggs Gary D · Buckeye, AZS/N 4 N1825Powell Chuck E · Benton, KSBuilt 1967 · S/N 6619 N183GGarnett Theodore S Jr · Paoli, PABuilt 1968 · S/N G-2 N183UVan Weersch Johannes M · San Jose, CABuilt 1997 · S/N 30 N184LBHoffmann Justin P · Sandoval, ILBuilt 2005 · S/N 5284