Skip to content

Registered aircraft · 7,860

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.

N678GBJ2j LLC · Cheyenne, WYBuilt 2016 · S/N 678 N678TMLavoie Michael T · West Ossipee, NHFirst renewal noticeBuilt 2000 · S/N 001 N678TSTucson Soaring Club Inc · Sahuarita, AZBuilt 2003 · S/N 78.03.10 N67972Commemorative Air Force · Dallas, TXBuilt 1942 · S/N 38 N679SSImages Aloft Inc · Sellersburg, INBuilt 2006 · S/N 6462 N679TWHsu Chih Yuan · Glendora, CABuilt 2012 · S/N 6669 N67AEWeiss Donald E II · Murray, UTBuilt 1997 · S/N 60 N67BNPluck Joseph · Marlton, NJS/N MAB2013135 N67CRStanley Ronald L · Ellsworth, ILBuilt 2002 · S/N 144 N67JPLloyd Clee E · Canby, ORBuilt 1974 · S/N 58 N67LBMahony John · Ballston Spa, NYBuilt 1982 · S/N 23 N67LSKarlovich James W · Kingston, GABuilt 1985 · S/N 6003 N67PJTuscon Soaring Club Inc · Sahuarita, AZBuilt 2000 · S/N 21707 N67TTL/D Max Sales LLC · Missoula, MTBuilt 1998 · S/N 74 N67WSHopke Kurt Ervin · Escondido, CAS/N 8 N6800Naoshy David · Laurel, MDBuilt 1977 · S/N 20546 N6800TJohnson Durwood D · Beaumont, TXS/N 6348 N680UJohnson Gustav M · Newton, NJBuilt 1965 · S/N 302 N6813JHyannis Air Service Inc DBA · Hyannis, MAS/N 402C0641 N681SJCoffing Stephen · Albuquerque, NMBuilt 2013 · S/N 6710 N681UBishop Thomas W · Decatur, TXBuilt 1965 · S/N 217 N682CBGross Andrew L · Pemberville, OHBuilt 2014 · S/N 6682 N68389Callicrate Richard · Piedmont, CABuilt 1972 · S/N SEM-74 N683UPtacek Stephen R · Estes Park, COBuilt 1965 · S/N 304 N6848CRegistration Pending · Sheridan, WYRegistration pendingBuilt 1984 · S/N E-2147 N6851WBalloon Depot · Snohomish, WABuilt 2020 · S/N 6903 N685UMaglaughlin Ronald D · Udall, KSFirst renewal noticeBuilt 1965 · S/N 220 N68674Harbick John R · Fresno, CABuilt 1976 · S/N 01 N686BSBlaser Swisslube · Goshen, NYBuilt 2013 · S/N 5547 N686CEWebb Randol B Jr · Sherman, CTBuilt 1978 · S/N 20644 N68724Western Antique Aeroplane & Automobile Museum · Hood River, ORS/N 160 N687UDaves Aircraft Inc · Edgewater, FLBuilt 1965 · S/N 306 N6881Rehmel Timothy R · Enid, OKBuilt 1968 · S/N 849 N6882MScuttle421 LLC · Sugar Land, TXS/N 421C1074 N688JAWestern Antique Aeroplane & Automobile Museum · Hood River, ORS/N 025414 N688RBCruise Control Aviation LLC · Albuquerque, NMBuilt 2022 · S/N 6939 N688UKendall Flying Services LLC · Miami, FLS/N 307 N68944Cowie Leland K II · Lorton, VAS/N PRG-01-38 N689UHayter Henry W Jr · Burlington, KYBuilt 1965 · S/N 308 N68HPCorsair Enterprises Inc · Wilmington, DES/N 97302 N68LBAviation Museum Of Kentucky Inc · Lexington, KYS/N 1 N68LSDs Soaring LLC · Brooklyn, NYBuilt 1986 · S/N 6077 N68NCRampart Aviation LLC · Colorado Springs, COS/N 124 N68STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1973 · S/N 25508 N6901DFlick Damon Michael · Dansville, NYBuilt 2008 · S/N 5413 N690AMHrechniw Taras K · Ellenville, NYBuilt 1988 · S/N RX7-3169 N690WOliver William M · Bloomington, INBuilt 2015 · S/N 5590 N690XRGrote Matthew R · Rio Rancho, NMBuilt 2025 · S/N EX6901 N691MTSale Reported · Lenexa, KSSale reportedBuilt 2007 · S/N 366 N691XRMarchand Michael Austin · Pagosa Springs, COBuilt 2025 · S/N EX6902