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.

N23NHPinney Charles W · Tucson, AZBuilt 1982 · S/N 4205 N23SGSoaring Society Of Boulder Inc · Boulder, COBuilt 1991 · S/N 052-CS N23WSDovey Air Inc · Birmingham, MIS/N BB-1143 N2401WOdonnell Daniel V · Dover, DEBuilt 1966 · S/N 347 N2402WHood River Soaring · Hood River, ORBuilt 1966 · S/N 39 N2403WCarvino Anthony M · Hackettstown, NJBuilt 1966 · S/N 348 N2404WFarrar Kelley J · Ames, IABuilt 1966 · S/N 349 N2405EDougherty Donald A · Colorado Springs, COBuilt 2007 · S/N 367 N2405WBorchers Jonathan M · Independence, ORBuilt 1966 · S/N 73 N24062Sproul Keith A · North Brunswick, NJBuilt 1967 · S/N S40-111 N2406WWilkinson E B · Eads, TNBuilt 1966 · S/N 350 N2407WPiendel Richard · Annville, PAS/N 130 N2407XBlaser Swisslube · Goshen, NYBuilt 2002 · S/N 131 N2408WPadelt Joan M · Barto, PABuilt 2001 · S/N 121760 N240LBBeachy David · Ostrander, OHBuilt 2013 · S/N 5533 N240PBDavid Lee Bradley Productions Inc · Temecula, CABuilt 1993 · S/N 053 N240TGTreasure Coast Soaring Club Inc · Vero Beach, FLS/N 24073 N240WBLight Flight Balloons Inc · Bel Air, MDBuilt 1985 · S/N 673 N2411PBurchfield Jon D · Gallatin, TNS/N 18-8009010 N2411WKramer Dean E · Bernville, PABuilt 1966 · S/N 249 N2412SSullivan Bernard · Nashville, TNBuilt 2024 · S/N 2292 N2413WFlying L Aircraft Inc · Fort Denaud, FLBuilt 1966 · S/N 251 N2414JGunnarsson Jon · Concrete, WAS/N 025313 N2414LChilhowee Soaring Association Inc · Benton, TNBuilt 1979 · S/N B929 N2416DDelmarva Balloon Rides LLC · Chester, MDBuilt 2023 · S/N 2014 N2416GBlaser Swisslube Inc · Goshen, NYBuilt 2003 · S/N 403 N24185Kramer Dean E · Bernville, PABuilt 1942 · S/N B-1-4 N2418ZAndreoli Bernard Paul · Old Forge, PABuilt 1977 · S/N 418 N241UKHingst Douglas J · Rcho Sta Marg, CABuilt 1982 · S/N 4199 N2420WDavis Anthony S · Hemet, CAS/N 366 N24216Renaissance Balloons LLC · Hartland, MIS/N 6823 N2421AGreen Mark T · Orlando, FLBuilt 2007 · S/N 365 N2421HGarner Kenneth W · Decatur, ALBuilt 2008 · S/N 376 N24220Quinn Megan M · Fort Edward, NYBuilt 2007 · S/N 369 N24225Monahan Todd J · Queensbury, NYS/N 368 N2422WNolan John R · Colorado Springs, COS/N 357 N2423NBig Sky Balloon Co · Redmond, ORBuilt 2014 · S/N 431 N2423PBristol David W · Sautee, GABuilt 2006 · S/N 350 N2424WMaurer Norbert O · Loveland, OHS/N 359 N2425WField Drew H · Dallas, TXBuilt 1966 · S/N 356 N2426WCoughlin Colten G · Wichita, KSBuilt 1966 · S/N 358 N24282Komadina Mark W · Corrales, NMBuilt 2017 · S/N 1382 N2428LSalters Daniel L · High Ridge, MOBuilt 2014 · S/N 001 N2428WCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1966 · S/N 360 N2428ZBechtold Larry E · Apple Valley, CABuilt 1978 · S/N 8101 N2429Bittner Charles K · Maize, KSBuilt 1971 · S/N 118 N242APPernell Robert A · Henderson, NCBuilt 2007 · S/N 0604 N242MSScott Michael R · Rio Rancho, NMBuilt 1997 · S/N F7B-379 N242NUGrote Matthew R · Rio Rancho, NMBuilt 1996 · S/N HAB 7 N242RLFellenz James D · Slippery Rock, PABuilt 1986 · S/N 4561