Skip to content

Registered aircraft · 7,850

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.

N1272QYocom Mark A · Albuquerque, NMBuilt 2006 · S/N 6448 N1275Martin William F · San Antonio, TXBuilt 1968 · S/N 73 N127JGAir Venture Balloon Rides Inc · Chester Springs, PABuilt 2012 · S/N 924 N127KSDeutsch Mitchell M · Marietta, GABuilt 1998 · S/N 27097 N127LJRedweik Eric P · Tucson, AZBuilt 1998 · S/N 27094 N127LZFabian Gary G · Kingsland, TXBuilt 1981 · S/N S55A-753 N127MMRoach Brian L · San Jose, CABuilt 2004 · S/N 27228 N127MSColvert Elston S · Washington, MIBuilt 2001 · S/N 127 N127PADowell Christopher W · Palmdale, CABuilt 2000 · S/N 27146 N127PXGrimes Nathan C · Boulder, WYBuilt 1985 · S/N 20797 N127RCFlint River Soaring LLC · Bainbridge, GABuilt 1974 · S/N 584 N127RJDavid James R Jr · Franconia, NHBuilt 1997 · S/N 27046 N127SCDavid Lee Bradley Productions Inc · Temecula, CABuilt 2004 · S/N 180/47 N127SM27 Bravo LLC · Saint Paul, MNBuilt 2001 · S/N 27156 N127SSLakeland Aero Club Inc · Lakeland, FLBuilt 1976 · S/N 1170 N12825Baldwin Dale A · Troy, MOBuilt 1963 · S/N DMP-1 N12827Aerial Adventures LLC · Burton, OHBuilt 1998 · S/N S53A-3047 N1285PLeatherberry Jody L · Leslie, MIBuilt 2005 · S/N 6426 N1287VNorris Eric Brent · Santa Clara, CAS/N 881 N128DJDavenport Eric · Malta, NYS/N 6007 N128KSMah Richard · Los Alamos, NMS/N 21273 N128RFSherrill David S · Westford, MAS/N 28004 N128SSCardinal Flying LLC · Anderson, INBuilt 1976 · S/N 1211 N128UHNixon Henry · Wayne, NJBuilt 2000 · S/N 28010 N128UMRegistration Pending · Longview, TXRegistration pendingBuilt 2011 · S/N 56-47 N1297Marvin Shawn · Tomahawk, WIS/N 144 N129AGieseke Joe R · Mount Juliet, TNBuilt 1975 · S/N 20079 N129KSHigh Desert Soaring Club Inc · Bend, ORS/N 21275 N129LBMckenzie Dawn R · Birmingham, MIBuilt 1999 · S/N 5102 N129PAGriffin Charles G · Redwood City, CABuilt 2012 · S/N 29075 N129PGDonnelly Mark S · Goodyear, AZBuilt 2005 · S/N 167 N129RFFletcher Robert W · Princeton, MABuilt 2012 · S/N 29082 N129SAUnlimited Vertical LLC · Milton Freewater, ORS/N 28R-7737053 N129SSReeves Air Glide LLC · Moriarty, NMS/N 1212 N129WBFour Corners Balloon Rides LLC · Rio Rancho, NMBuilt 1993 · S/N 2426 N129WXCleveland David S · North Salt Lake, UTBuilt 2007 · S/N 29025 N129WYHarrison Edward I · Pittsburgh, PABuilt 2000 · S/N 114 N12EKKnutson Wayne R · Tioga, NDS/N 75-199 N12FBBrookside Ballooning LLC · Pennington, NJBuilt 2000 · S/N 092 N12GUGieseke Joe R · Mount Juliet, TNBuilt 2004 · S/N 150 N12GVJorgensen David · Laconia, NHBuilt 1995 · S/N 17 N12HAZeug Leon · Delano, MNBuilt 1980 · S/N 20339 N12JHLeonard Steven E · Wichita, KSS/N 31 N12KUCzech US Out Balloons LLC · Salina, UTBuilt 2007 · S/N 525 N12MEBlair Ventures LLC · Newark, DEBuilt 1993 · S/N 109 N12MRJonas James P Jr · Anaconda, MTBuilt 1975 · S/N 20038 N12RUAlbuquerque Soaring Club · Albuquerque, NMBuilt 1971 · S/N 208 N12TGFavicchio Valerie A · Fort Collins, COBuilt 2012 · S/N 6651 N12UFHagemeister Gary A · Cannon Falls, MNBuilt 1972 · S/N 17 N12UMMars Leasing Company · Phoenix, AZBuilt 2021 · S/N 300/96