Skip to content

Registered aircraft · 7,850

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.

N1106SBrandywine Soaring Association · Hockessin, DEBuilt 1971 · S/N 501 N11076Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 3005 N1107SSugarbush Soaring Association Inc · Warren, VTBuilt 1971 · S/N 507 N1107ZBurning Desire Inc · Albuquerque, NMBuilt 2005 · S/N 6434 N1108SSoaring Eagle Foundation · Peyton, COBuilt 1970 · S/N 478 N1109SSeminole Soaring Club LLC · Clermont, FLBuilt 1970 · S/N 479 N110AAMaguire Douglas Gary · Allenspark, COBuilt 2023 · S/N 400 N110BSMaughan Stephanie · Wentzville, MOBuilt 2004 · S/N 001 N110EFBrodbeck Amanda · Dacono, COBuilt 2023 · S/N 2119 N110HDLang Neil D · West Des Moines, IAS/N 5241 N110LBVesely Scott · Frisco, TXBuilt 2003 · S/N 5224 N110NSNutmeg Soaring Association Inc · Freehold, NYS/N 3106 N1110PPestun Jeffery A · Holland, MIBuilt 2006 · S/N 6427 N1110TMuxworthy Keaton A · Bedford, TXS/N 108 N1110ZCastellion Jack A · Winter Park, COBuilt 2023 · S/N 2108 N1113AThermal Inc · Rhinebeck, NYBuilt 1980 · S/N 3546 N1113GNorth American Wave Engine Corp · Baltimore, MDBuilt 1968 · S/N PJ-29 N1113SMiller Blaine N · Brooks, GABuilt 1970 · S/N 480 N1114CWilliams John Scott · Norman, OKBuilt 1977 · S/N 27 N1115SPost Mills Soaring Club · Norwich, VTS/N 505 N1117Lipe James E · Rossville, TNBuilt 1969 · S/N 14 N1117DGlider Guys · Rexburg, IDBuilt 1966 · S/N 1489 N1118SAero Club Albatross Inc · Blairstown, NJBuilt 1971 · S/N 508 N111BGGrant Richard M · Eugene, ORBuilt 1972 · S/N 17008 N111CRCramer Warren C · Horseheads, NYBuilt 1971 · S/N 183 N111KGWille Chad C · Corning, IABuilt 1982 · S/N 26 N111NDLeonard Steven E · Wichita, KSBuilt 1977 · S/N N4 N111PRPortland Rose Balloons LLC · Wilsonville, ORBuilt 2012 · S/N 866 N111RGAeronautical Solutions LLC · Taos, NMBuilt 1995 · S/N 197 N111RLYoungblood Robert W · Vero Beach, FLS/N 24111 N111RPDoxey Bryan Doughlas · Irondale, ALBuilt 1979 · S/N 3377 N111VHCascade Soaring Society Inc · East Wenatchee, WABuilt 1978 · S/N 3326 N111WHWhiskey Hotel LLC · Houma, LAS/N 167 N111ZBAeronautical Solutions LLC · Taos, NMBuilt 1994 · S/N F11-003 N1120SHoover Michael B · Ridgeland, WIBuilt 1971 · S/N 510 N11218Jackson Neil R · Albuquerque, NMBuilt 2006 · S/N 6437 N1121APadelt Albert F · Barto, PABuilt 2000 · S/N FAC002 N1121SStrutz Daniel S · Yale, SDBuilt 2005 · S/N 6403 N1124WDe Young Robert Erwin · Napa, CABuilt 1969 · S/N 7 N1127CNilz Patrick Shawn · Marana, AZBuilt 2004 · S/N 6380 N1128NGaines Randi K · Foley, MOBuilt 2006 · S/N 6438 N1129RRoessing G A · Gary, INBuilt 1976 · S/N S55A-302 N112CWilkinson Ephriam B · Eads, TNBuilt 1970 · S/N 482 N112DFScollin Daniel Kelly · Huntersville, NCBuilt 2000 · S/N 59 N112JBMarkowitz David B · Maryland, NYBuilt 1981 · S/N 51 N112JLWebster Benjamin T · Cypress, TXBuilt 1985 · S/N 20680 N112LKBergeson John S · Rhome, TXS/N 6220 N112PWVan Tassel Gary W · Seaford, VABuilt 1997 · S/N 17.09.002 N112RDObrien Robert P · Waupaca, WIBuilt 1998 · S/N 535 N112SAHeartland Aviation Inc · Alliance, NEBuilt 1977 · S/N 026954