Skip to content

Registered aircraft · 7,849

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.

N10358Maglaughlin Ronald D · Udall, KSBuilt 1960 · S/N 84 N1035DKugler John · Mccook, NEBuilt 2005 · S/N 001 N10362Pursuit-Air-Crafters LLC · Crawford, COS/N 87 N10366Szostak Edward M · San Diego, CABuilt 1960 · S/N 48 N10371Morgan Philip S · Dardanelle, ARBuilt 1960 · S/N 49 N10372Registered aircraftBuilt 1960 · S/N 116 N10374Wings Over Miami Museum Inc · Miami, FLBuilt 1961 · S/N 87 N10378Lyon Richard K · Sun City, AZBuilt 1960 · S/N 69 N10379Havener Michael D · Murrieta, CABuilt 1961 · S/N 113 N10384Odonnell Daniel V · Dover, DEBuilt 1961 · S/N 100 N10385Miller Bruce A · Plano, TXBuilt 1961 · S/N 119 N10387Leary James · Ramona, CABuilt 1961 · S/N 123 N10388Mohawk Soaring Club Inc · Hoosick Falls, NYBuilt 1960 · S/N 50 N10389Kohler Richard L · Moriarty, NMBuilt 1961 · S/N 55 N10392Canvasback Soaring · Port Murray, NJS/N 125 N103BPWiederkehr Anthony C · Stanwood, WABuilt 1992 · S/N 34172 N103FBNorthern California Soaring Association · Byron, CABuilt 1984 · S/N 33930 N103GBKoenig David W · Menasha, WIBuilt 2014 · S/N 003 N103GHTexas Youth Flight Experience Foundation · Boerne, TXBuilt 1989 · S/N 34110 N103GPEndeavor Aviation Inc · Belgrade, MTBuilt 1994 · S/N SPIII-3001 N103GTAero Club Albatross · Blairstown, NJBuilt 1978 · S/N 3075 N103GWWalker Glen L · Coolidge, AZBuilt 1980 · S/N 0103 N103JDenman David H · Gainesville, FLBuilt 2001 · S/N 115 N103JMAlbuquerque Soaring Club Inc · Albuquerque, NMBuilt 1993 · S/N 35041 N103LBBalloon Promotions Ltd · Louisville, KYBuilt 2000 · S/N 5157 N103LMJohnson Matthew W · Langley, WABuilt 1989 · S/N 34107 N103LSLowcountry Soaring Association · Ridgeland, SCBuilt 1983 · S/N 3801-K-68 N103MGWhite Sands Soaring Association Inc · Alamogordo, NMBuilt 1985 · S/N 33983-K-216 N103NSNutmeg Soaring Assoc · Freehold, NYBuilt 1978 · S/N 3096 N103PRSeva Corp · Malibu, CABuilt 1984 · S/N 3852-K-98 N103PWN103pw LLC · Cumming, GAS/N 17.08.023 N103RFTucson Soaring Club Inc · Sahuarita, AZBuilt 1985 · S/N 33921K156 N103SHSouthern California Soaring Academy Inc · Valencia, CABuilt 1986 · S/N 34051-K-281 N103THuntsville Soaring Club · Brownsboro, ALBuilt 1978 · S/N 3144 N103TGRunaway 5 LLC · Wurtsboro, NYBuilt 1983 · S/N 3829 N103XPittsburgh Soaring Assn · Pittsburgh, PABuilt 1978 · S/N 3045 N103XSPrairie Thermals LLC · Brookings, SDBuilt 1982 · S/N 3745 N103XXRegistration Pending · Franconia, NHRegistration pendingBuilt 1977 · S/N 3016 N1040BBrimley Jennifer R · Heber City, UTBuilt 2024 · S/N 2338 N1041Del Rio Aviation Inc · Paso Robles, CAS/N 337M0317 N1042Estell William S · Wilmington, OHBuilt 1999 · S/N 042 N1042QElevatednm LLC · Los Ranchos, NMBuilt 2005 · S/N 6399 N10436Go Ballooning LLC · Anchorage, AKBuilt 2005 · S/N 6395 N1046GMonahan Todd J · Queensbury, NYBuilt 2004 · S/N 6376 N1047BAlaska Aviation Museum · Anchorage, AKS/N 7728 N1047ZDyer Evan H · Ann Arbor, MIBuilt 1964 · S/N 7147 N1049FBissonette Harle E · Brookings, ORBuilt 1979 · S/N 182 N1049YAirtime Equipment LLC · Mesa, AZBuilt 2005 · S/N 6429 N104BDLappin Thomas · Austin, TXBuilt 1997 · S/N 17.08.024 N104DJHays Brad A · Noblesville, INBuilt 2004 · S/N 93