Skip to content

Registered aircraft · 7,858

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.

N401VTFortney Wayne D · Kingsport, TNBuilt 2019 · S/N 1509 N40206Reeder Eric L · Hastings, MIBuilt 1983 · S/N 129 N40209Hodge Steven J · Tucson, AZBuilt 1983 · S/N 130 N4020JLite Haus Ballooning LLC · Ridge Spring, SCBuilt 2020 · S/N 5714 N4020LHutchinson Terry S · Albuquerque, NMBuilt 2021 · S/N 5744 N4020SRally Aviation LLC · Swisher, IABuilt 2022 · S/N 5779 N4020TMatejowsky Trevor L · Dallas, TXBuilt 2007 · S/N 6476 N4020UCook Kelli R · Aurora, COBuilt 2023 · S/N 5786 N4020YFoha LLC · Mcminnville, ORBuilt 2023 · S/N 5793 N4021LGunter Ryan S · Albuquerque, NMBuilt 1983 · S/N 134 N4021MMoore Gary · Lake Havasu City, AZBuilt 2006 · S/N 6454 N4021YAerostat Adventures LLC · Ormond Beach, FLBuilt 2006 · S/N 6464 N40229Dimmitt William C · Los Lunas, NMBuilt 1985 · S/N 162 N4022BMabee Bryant J Jr · Vestal, NYS/N 6185 N4022GAirtime Equipment LLC · Mesa, AZBuilt 1983 · S/N 132 N4022KBmg Aviation Inc · Bloomington, INBuilt 1983 · S/N 127 N4022QCampbell Brittany Rose · Los Lunas, NMS/N 148 N4022XSiarza Lta LLC · Albuquerque, NMBuilt 1996 · S/N 6073 N4023KUtah Outventures LLC · Salt Lake City, UTS/N 6497 N4024Stoltz Charles T · Trenton, MIBuilt 1972 · S/N 206 N4024GGriffin Daniel J · Ft Collins, COBuilt 1981 · S/N S55A-838 N40253Registration Pending · Pagosa Springs, CORegistration pendingBuilt 1998 · S/N S60A-3253 N4025SAaaa Education Foundation · Albuquerque, NMS/N RX8-3285 N4026LJohnson Meridian S N · Santa Fe, NMBuilt 1981 · S/N S55A-841 N4026MMelton David L · New Harmony, UTBuilt 2006 · S/N 6456 N40278Clayton Harry L · Wichita, KSBuilt 1947 · S/N 52A N4027LHebert Chad A · Zachary, LABuilt 2007 · S/N 6466 N4027QRegistered aircraftBuilt 2007 · S/N 6481 N4029ALeonard Steven E · Wichita, KSBuilt 1961 · S/N 944 N402EBSkyview Balloons LLC · Wooldridge, MOBuilt 2022 · S/N 1968 N402EWAmerican Balloon Rides LLC · Land O Lakes, FLBuilt 2008 · S/N 160/58 N402KBlace Mark P · Spring Gap, MDBuilt 1981 · S/N 4009 N402KDDraughn Kenneth W · Burlington, NCBuilt 2002 · S/N 5198 N4030AParson Ty L · Elverson, PABuilt 1995 · S/N 233 N4031ARhubarb And Custard LLC · Deer Trail, COBuilt 1997 · S/N RX8-3288 N4031GBristol David W · Sautee, GABuilt 1983 · S/N 137 N4031SVertical Concepts Inc · Wilmington, DES/N 159 N4031VEngdahl James H · Spring Creek, NVBuilt 1983 · S/N 121 N40320Campbell Brittany R · Los Lunas, NMS/N 151 N4032AMarvin Carlton · Tomahawk, WIBuilt 1958 · S/N 58 N4033JMonahan Todd J · Queensbury, NYS/N 144 N4033MSchilling Mark K · Jeffersonville, VTBuilt 2007 · S/N 6492 N4034AAbecca Corporation · Jackson, MIBuilt 1984 · S/N 140 N40351Riley Adam C · Huntsville, ALBuilt 1984 · S/N 138 N4035EMurray Richard H · Celina, OHS/N 11BC-123 N4035PBristol David W · Sautee Nacoochee, GABuilt 1985 · S/N 154 N4035THawkins Charles W · Fairacres, NMBuilt 1984 · S/N 139 N4035YKerr Robert Charles · Mason, MIBuilt 1984 · S/N 145 N40371Bowman James A · Oklahoma City, OKBuilt 1978 · S/N 6738 N4037AAirborne Adventures LLC · Albuquerque, NMBuilt 2007 · S/N 6491