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.

N9431HSamson Philip C · Nashville, TNBuilt 1962 · S/N 6013 N9439GKoenig Colleen M · Edgewood, NMBuilt 1991 · S/N X-148 N943SBBenson Gene N · Reno, NVBuilt 1970 · S/N 44 N94452Henderson Colin D · Norman, OKBuilt 1942 · S/N B-2-20 N945ZChristman Timothy A · Dayton, OHBuilt 1964 · S/N 64 N946CFAdvantage Aerosports Inc · Phoenix, AZFirst renewal noticeBuilt 2017 · S/N 6812 N946JTMayo Michael J · Palo Alto, CABuilt 2001 · S/N 119 N947DBAikins Luke Tipton · Shelton, WABuilt 2020 · S/N 001 N948BGordon Zach Edward · Spring, TXBuilt 1981 · S/N 56 N94CGHackett Richard · Queensbury, NYS/N 24229 N94HMHopke Kurt E · Escondido, CABuilt 1981 · S/N 20469 N94KGSchibler Gregory W · Encinitas, CABuilt 1983 · S/N 101AP094 N9501Overton Wilbur C · Roanoke Rapids, NCBuilt 1968 · S/N 80 N9501CLittle Keri L · Stillwater, OKBuilt 2016 · S/N X1284 N9505QEichhorn David J · Corrales, NMS/N 5382 N9507Wyatt James Bryan · Conyers, GAFirst renewal noticeBuilt 1971 · S/N 215 N9509BConrad Kenneth J · Albuquerque, NMBuilt 1989 · S/N 5601 N950BRAdvertising Balloon Co Inc · Las Vegas, NVBuilt 2017 · S/N 6830 N950LVAerostatica Inc DBA · Ann Arbor, MIBuilt 2021 · S/N 6950 N9510Ketteman Michael L · Lees Summit, MOBuilt 1969 · S/N 45 N9511LBoland Brian J · Post Mills, VTBuilt 1983 · S/N RX6-146 N9513TBlair Delbert R · Bridgeton, NJBuilt 1990 · S/N 5597 N9515FSteele Edward M · Dunsmuir, CABuilt 1989 · S/N 5586 N9516TLyman Jon A · Pittstown, NJBuilt 2026 · S/N 7038 N951BWWander Robert P · Faribault, MNBuilt 2001 · S/N 05.001.04 N9520TNakamura Judith K · Placitas, NMBuilt 1989 · S/N 5604 N9526DWalker Dorothy E · Addison, TXS/N 5558 N952CLBerry Keith Ollie · Poplar Bluff, MOBuilt 1995 · S/N 231 N952LMMastis Linas V · Green Cove Springs, FLBuilt 2007 · S/N FMB-200273 N9532Wasatch Back Ballooning LLC · Heber City, UTBuilt 2019 · S/N 1588 N9532GBeard Blair S · West Lawn, PABuilt 1990 · S/N 5613 N9532KBalloons Of Hunterdon LLC · Ringoes, NJBuilt 2020 · S/N 1734 N95341Molnar Jacob W · Vacaville, CAS/N 5624 N95353Finch Charles R · Trinity, NCBuilt 1989 · S/N 5570 N9539GMiller Edward J · Ottumwa, IABuilt 1990 · S/N 5585 N9539KBradley Kenneth P · Evans, COBuilt 1990 · S/N 5578 N9541RStandefer Wayne B · Italy, TXS/N 5559 N9547GMorning Star Visions Inc · Smoketown, PABuilt 1990 · S/N 5577 N954DKDillard Terry R · Debary, FLBuilt 2015 · S/N 5581 N954JDMccaul Benjamin · San Luis Obispo, CAS/N F5-010 N955BABruning Jack R · New Hampton, NHS/N 49 N955TECoop Balloons LLC · Swisher, IABuilt 2016 · S/N 5631 N955TSTexas Soaring Association Inc · Midlothian, TXBuilt 2006 · S/N 21815 N957VMMaguire Douglas G · Allenspark, COBuilt 1999 · S/N 605 N958KBBarrett Dennis F · Temecula, CABuilt 2012 · S/N 958 N958ZLeonard Steven E · Wichita, KSBuilt 1963 · S/N 6153 N959RJ550rj LLC · Middletown, DES/N 550-0201 N95CSLert Peter S · Graton, CAS/N 1047 N95FWCanyonlands Ballooning · Moab, UTBuilt 2015 · S/N 1122 N95JSSlifer John R Jr · Sylvania, OHBuilt 1981 · S/N 20478