Skip to content

Registered aircraft · 7,853

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.

N218ETObryan Glen D · Shelby, NCBuilt 1994 · S/N RX8-3188 N218SBSpirit Ballooning LLC · Canaan, CTBuilt 2016 · S/N 5632 N218WWBrown Thomas J · Plainwell, MIS/N 6726 N21906Coffing Mark A · Knoxville, TNS/N F7-2040 N21907Markowitz David · Maryland, NYBuilt 2004 · S/N F8B2043 N2191GGreen Robert H · Escondido, CABuilt 2004 · S/N F6B-2001 N21926Pedersen Tyler · Johnston, IABuilt 2003 · S/N F7-2035 N2192SBig Sky Hot Air Ballooning Inc · Oxford, MIBuilt 2004 · S/N F8B-2060 N2192UWeaver David B · Boulder, COS/N F8B-2049 N21935Leisek John C · Tooele, UTBuilt 2005 · S/N F8B-2078 N2193ABarnhill Jayson D · Longview, TXBuilt 2004 · S/N F8B-2059 N2193DUp Away Inc · Churchville, PABuilt 2004 · S/N F8B2057 N2193ZTsb Solutions LLC · Lebanon, INBuilt 2005 · S/N GLX-1088B N21941Suskin Dan · Atlanta, GABuilt 2004 · S/N F7B2011 N2194NNilz Raymond P · Tucson, AZBuilt 2003 · S/N F7-2033 N2194XPyramid Pool LLC · Glendale, AZS/N F9-2003 N2194ZWolters James A · Holts Summit, MOBuilt 2005 · S/N F8B-2066 N21953Snead David W · Mechanicsville, VABuilt 2003 · S/N F7-2024 N21961Tim Mcconnell Photography · Indianola, IABuilt 2004 · S/N F7-2039 N21969Patterson Todd M · Clive, IABuilt 2004 · S/N F7-2045 N2197JHooper Kirk M · Albuquerque, NMS/N F9-2002 N2197RManning Dawn L · Spring Creek, NVBuilt 2003 · S/N F8B-2051 N2198WWolniak Bruce · Auburn, NYBuilt 2003 · S/N F8B2050 N21AFAdrian Soaring Club · Ypsilanti, MIBuilt 1983 · S/N 21179 N21BPGriffes Russell N · Orem, UTBuilt 1991 · S/N RX8-3136 N21HHDerrer Anthony R · Livermore, CABuilt 1978 · S/N 53 N21KSAir Ventures Balloon Rides Inc · Chester Springs, PABuilt 1974 · S/N S55A-213 N21KVGrissom Timothy G · West Liberty, OHBuilt 2007 · S/N 5354 N21PHBoehmer David E · Mc Donald, PABuilt 1977 · S/N 33 N21PTGary Oswald Lee · Post Falls, IDBuilt 1971 · S/N 190 N21QUUtah Soaring Association · Mapleton, UTS/N 21272 N21SEThaeler Charles S III · Reno, NVBuilt 1997 · S/N 31 N21SXCantwell Paul M · Momence, ILBuilt 1993 · S/N 11 N21TUAero Club Albatross · Blairstown, NJBuilt 1974 · S/N 133 N21TWOuroboros Soaring LLC · Salt Lake City, UTS/N 19158 N2200Wendland Frank A · SiegenS/N 104 N2200LAerial Balloon Advertising LLC · Lake Orion, MIBuilt 2004 · S/N F8B-2058 N2200MBuckles Kyle · Williamson, NYBuilt 2003 · S/N F7-2032 N22015Stieber Chris D · Aurora, COBuilt 1999 · S/N 2015 N2202Independence Aviation LLC · Independence, ORBuilt 1946 · S/N 8 N2202CCarr Larry Dean · Columbiana, ALBuilt 2003 · S/N F7-2031 N2203QGower Marshall L · Town Creek, ALBuilt 2005 · S/N F8B-2074 N22041Cameron The Pilot LLC · Casper, WYBuilt 2004 · S/N F8B-2062 N2204JJacobs Steven · Lakeland, MNS/N 6629 N22054Wilczynski John J · Lake Village, INBuilt 2004 · S/N F7-2038 N2205BMeyer Mark A · Vass, NCBuilt 2004 · S/N F8B-2056 N2205QStevens Brody C · Hammond, LABuilt 2005 · S/N F7-2056 N2205ZPrestige Pilot Services LLC · El Paso, TXBuilt 2005 · S/N F8B-2068 N2206FHebda Michael J · Tigard, ORBuilt 2004 · S/N F8B-2067 N2206PRegistration Pending · Williamsburg, OHRegistration pendingBuilt 2005 · S/N F7-2047