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.

N2432WStolutions LLC · Lexington Park, MDS/N 44 N2433WTakallu M A · Norfolk, VABuilt 1966 · S/N 74 N243GBWagoner Benjamin A · Bristol, CTBuilt 2023 · S/N CCR77-01 N243HPKuykendall Bob · Murphys, CABuilt 2016 · S/N 03 N243TCCory Shane D · Phoenix, AZBuilt 1992 · S/N 2101USA N243TWRocky Mountain Balloon Adventures LLC · Pagosa Springs, COBuilt 2023 · S/N 2151 N24409Keller Clifford G · Santa Cruz, NMBuilt 1973 · S/N SEM91 N2440WBeltzville Soaring Club · Lehighton, PABuilt 1967 · S/N 8 N2441WNiagara Soaring Club Inc · Williamsville, NYBuilt 1967 · S/N 9 N2443WWichita Soaring Association Inc · Wichita, KSBuilt 1967 · S/N 10 N2444WBickers Donald S · Knoxville, TNBuilt 1966 · S/N 363 N2445WEagle Sport Aviation Club Inc · De Leon Springs, FLBuilt 1967 · S/N 15 N2446WCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1967 · S/N 11 N244CXIto Rysuke · Everett, WAS/N 83 N244LBLavigna William F · Gates Mills, OHBuilt 2014 · S/N 5564 N244NSNelson Tim · Sloughhouse, CABuilt 2012 · S/N 955 N244TCFear Robert C · Rio Rancho, NMBuilt 1992 · S/N 2105USA N2453WDeener Larry C · Lexington, KYBuilt 1967 · S/N 368 N2455WBurbank Franklin R · Ocala, FLBuilt 1967 · S/N 19 N2456WMcmaster John · Wichita, KSBuilt 1967 · S/N 20 N2457WHood River Soaring · Hood River, ORS/N 21 N245BAUtah Outventures LLC · South Salt Lake, UTBuilt 2011 · S/N 818 N245DKAeronautical Adventures Inc · Eagle, IDBuilt 2011 · S/N 817 N245FForney James C · Spokane, WABuilt 1967 · S/N 49 N245JDStallman Jon M · Chico, CABuilt 1983 · S/N 4329 N245NSSpear Jeffrey · Sonoma, CABuilt 2011 · S/N 863 N2460WReynolds Richard L · Gainesville, FLBuilt 1967 · S/N 371 N2463WValley Soaring Club Inc · Middletown, NYBuilt 1967 · S/N 26 N2466WShortridge Randall R · Mesa, AZBuilt 1967 · S/N 48 N2469WMayes Brett R · Williams, CABuilt 1967 · S/N 53 N246DCleveland David · North Salt Lake, UTBuilt 1982 · S/N 77 N246HFFranke Sean R · Eagle, IDBuilt 1978 · S/N 3305 N246LBDuff Jenny I · Albuquerque, NMBuilt 1999 · S/N 5113 N246NSNapa Valley Aloft Inc · Yountville, CABuilt 2012 · S/N 968 N246TCGood John R · Prairieville, LAS/N 2094USA N2471WJourneys Aviation Inc · Boulder, COBuilt 1964 · S/N 7 N2471ZRegistration Pending · Prosser, WARegistration pendingBuilt 1979 · S/N 471 N2474WCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1967 · S/N 30 N2476WSky Sailing Inc · Warner Springs, CABuilt 1967 · S/N 32 N2479WFault Line Flyers · Leander, TXBuilt 1967 · S/N 33 N247NSNapa Valley Aloft Inc · Yountville, CABuilt 2012 · S/N 911 N2481Barnett Jerry L · Madison, ALBuilt 1969 · S/N 062 N2481WSky Sailing Inc · Warner Springs, CABuilt 1967 · S/N 35 N2482WBig Sky Jet Inc · Bozeman, MTBuilt 1967 · S/N 36 N2484WKendall Flying Services LLC · Miami, FLS/N 378 N2486WSoaring Club Of Houston · Waller, TXBuilt 1967 · S/N 38 N2488WLake Elsinore Soaring Club · Wildomar, CABuilt 1967 · S/N 40 N248CACoyne Charles A · San Dimas, CABuilt 1998 · S/N 248CS N248LJColubmus Aeronauts LLC · Dublin, OHBuilt 2024 · S/N 7002 N248SDyer Evan H · Ann Arbor, MIS/N 13003