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.

N805TCMuir Allan K · Houston, TXS/N 2456USA N80683Groves David T · Ortonville, MIBuilt 2003 · S/N 6326 N8068AWinker Gregory J · Denver, COBuilt 1979 · S/N S-50A-235 N8069FWasting Time LLC · Canton, OHS/N 6269 N806SFun Country Soaring Inc · Valley City, OHFirst renewal noticeBuilt 1993 · S/N 928006 N8070LKerns Michael E · Albuquerque, NMBuilt 2002 · S/N 6298 N80727Empty Pockets Balloon Team LLC · Reno, NVBuilt 2001 · S/N 10104 N80750Smith John A · La Mirada, CAS/N 034 N80752Vines David A · Loveland, COBuilt 2007 · S/N 122805 N807JRWhitling Ian C · Albuquerque, NMBuilt 2017 · S/N 223 N807PWWadleigh Eric Pell · Page, AZBuilt 2007 · S/N 5381 N8081JPritchett Mark L · Tonopah, AZBuilt 2001 · S/N 6276 N8082Worthen David · Las Vegas, NVBuilt 1971 · S/N 152 N8083LLoofbourrow Eric A · Livermore, CAS/N 28-8090080 N8085Oklahoma Soaring Association · Mustang, OKBuilt 1971 · S/N 161 N8085GShelton Jonathan R · West Des Moines, IABuilt 2000 · S/N 6248 N8086Hunter Greg L · Enosburgh, VTBuilt 1971 · S/N 165 N8089YAttitude Toys LLC · Wilmington, DEBuilt 2000 · S/N 6273 N808CUPortland Rose Balloons LLC · Wilsonville, ORS/N 6087 N808HPBotzko Charles L · Elmore, OHBuilt 1973 · S/N 001 N808SPJones Jenell · Grass Valley, CAS/N 5918 N8090QMalesko Tenneale L · Leslie, MIBuilt 2000 · S/N 6247 N8092UDavis John Kearney · Longview, WABuilt 2003 · S/N 6361 N8093YClark Garrison L · Pulaski, WIS/N 6251 N80943Hammett Bailey M · Hallsville, TXS/N 178 N8095MPlow Boy Aviation LLC · Forrest City, ARS/N 28-7911332 N8096Raetech Motorsports Inc · Ann Arbor, MIBuilt 1971 · S/N 166 N809NANasa Neil A Armstrong Flight Research Center · Edwards, CAS/N 80-1097 N809SPiedmont Soaring Society · Winston Salem, NCBuilt 1992 · S/N 928009 N80CSBerger Greg Dee · Prescott, AZBuilt 1977 · S/N 5 N80HRHarper Christopher W · Bruceton Mills, WVBuilt 2025 · S/N 2435 N80MGSharp John E · Salome, AZBuilt 1996 · S/N 1705021 N80SFDi Stefano Fabrizio D · Goose Creek, SCBuilt 1978 · S/N 19194 N80SKSmithson William J · Houston, TXFirst renewal noticeBuilt 1979 · S/N 3376 N8101NBristol David W · Sautee, GABuilt 1989 · S/N 0001 N810DBPaisley John P Jr · Burlington, NCBuilt 1988 · S/N 5464 N810LBA R B C Inc DBA · Galena, ILBuilt 2001 · S/N 5188 N810RRRainbow Ryders Inc · Albuquerque, NMBuilt 2024 · S/N F46/01 N810VEIngs Deborah Lynn · Centennial, COS/N 248 N810XXRainbow Ryders Inc · Albuquerque, NMBuilt 2020 · S/N 5732 N8117WYracheta Alfred T · Fresno, CAFirst renewal noticeS/N 28-8011025 N811FRIngram Scott Christian · Spring, TXBuilt 1973 · S/N 302 N811LBBuzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 2001 · S/N 5088 N811LXFly Lta LLC · Swisher, IABuilt 2009 · S/N 5437 N811PTStuart Erica N · Rincon, GABuilt 1989 · S/N 88-01 N812LBAppenzeller Allan Dean · Indianola, IABuilt 2012 · S/N 5524 N813CUColley Douglas W · Spokane, WAS/N 1 N813SFOld Fredrick Leigh · Dublin, OHBuilt 1996 · S/N 27009 N813SJBloom Kirk A · Indianola, IABuilt 2017 · S/N 5638 N8145Ceriotti Leonard L · Waukesha, WIBuilt 1969 · S/N 70