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.

N97NDRuby Crest LLC · Girdwood, AKBuilt 1998 · S/N 24252 N97RDHall John E · Corpus Christi, TXBuilt 1972 · S/N 288G N97SLNatkiel Paul · Hanover, NHBuilt 1982 · S/N 4335 N97UBGodfrey Jacob Phillip · Manchester, NHBuilt 1997 · S/N F8B-534 N980Willems Steven D · Costa Mesa, CABuilt 1976 · S/N X-128 N9801NErickson Karl L · Hope, MEBuilt 1986 · S/N 0165 N9802CCowen David · Corrales, NMBuilt 1985 · S/N 166 N9803LDekoevend Enterprises Inc · Fort Garland, COBuilt 1974 · S/N RX6-107 N9803SPluta Mark C · Saratoga Springs, NYBuilt 2014 · S/N 442 N9808SMartin Pamela M · Newnan, GAS/N 179 N98098Hodge Steven J · Tucson, AZS/N 189 N9809SAlong For The Ride LLC · Gilbert, PABuilt 2014 · S/N 1108 N980CBDickey Bill A · Corrales, NMBuilt 2006 · S/N 101 N980VARainbow Ryders Inc · Albuquerque, NMBuilt 2022 · S/N 6968 N9810SAkin Jason B · Rio Rancho, NMBuilt 2012 · S/N 002 N9811MGunter Ryan S · Albuquerque, NMS/N 167 N9811NRe/Max Marketing Fund LLC · Denver, COS/N 190 N9812YBucket List Adventures LLC · Albuquerque, NMS/N 192 N9814AGreaterboston Soaring Club Inc · Sterling, MABuilt 1978 · S/N 19199 N9817SDiekhoff Michael · Bloomington, INS/N 187 N98188Usda Forest Service Fepp · Columbia, SCS/N R1720077 N98189Kashmere Apartments LLC · Missouri City, TXS/N R172-0244 N9818JPayne Ralph J · Hastings, MIS/N 176 N9819QJones Dan E · Hilton Head Island, SCS/N 184 N981LBCwc Balloons LLC · Watkins, COBuilt 2016 · S/N 5620 N981WAnding Jay B · Bryan, TXS/N M-4222 N981ZSFlatt Herby A · Henryetta, OKBuilt 1999 · S/N 6197 N982Dupre Sam · Peyton, COBuilt 1972 · S/N 1 N9821Johnson Mark C · Spokane, WABuilt 1969 · S/N 19 N982BBBroker William · Wylie, TXBuilt 2025 · S/N B5-65-003 N982KAAlley Lynn D · Bountiful, UTBuilt 1998 · S/N 163 N982WTMorse Kathleen A · Groveland, CABuilt 1982 · S/N 19363 N982ZSClapp Royce T · Mccook, NEBuilt 1998 · S/N 6198 N9838Johnston Robert · Plantation, FLFirst renewal noticeBuilt 1970 · S/N 36 N9839EWalenda Richard · Elgin, ILBuilt 1965 · S/N 270 N983RRSkyline Balloons Inc · Murrieta, CABuilt 2013 · S/N 6705 N983ZSChristophersen Andrew P · Albuquerque, NMBuilt 1999 · S/N 6199 N9843EHard Steven J · Mustang, OKBuilt 1965 · S/N 314 N9848EZellers Clyde E · Springfield, ILBuilt 1965 · S/N 229 N984DWWinddancer Balloon Promotions LLC · Waukesha, WIBuilt 2008 · S/N 5383 N984MWRainbow Ryders Inc · Albuquerque, NMBuilt 2023 · S/N 2187 N984RRRainbow Ryders Inc · Albuquerque, NMBuilt 2023 · S/N 6973 N984TWatrous Dave Warren · Lake Oswego, ORBuilt 1981 · S/N 61 N984ZSChad Dennis · Grand Blanc, MIS/N 6203 N9853EHilton Loye Lee · Bullhead City, AZBuilt 1965 · S/N 231 N9854EGarrett John J III · Spokane, WABuilt 1965 · S/N 321 N9856EStewarts Aircraft Service Inc · Waynesville, OHBuilt 1965 · S/N 322 N9857EK&L Soaring LLC · Cayuta, NYBuilt 1965 · S/N 24 N985WBHenderson Colin D · Norman, OKBuilt 1950 · S/N MHL012 N9861ERiley Thomas V · San Diego, CABuilt 1965 · S/N 323