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.

N4105BNelson Debra M · Eastport, MEBuilt 1991 · S/N 5687 N41069Wilson John A · Rio Rancho, NMBuilt 2020 · S/N 6917 N410BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029005 N410DFUsda Forest Service Fepp · Mcclellan, CAS/N 305158M82 N410KPBarry Airborne Solutions LLC · Titusville, FLBuilt 1997 · S/N 04-10KP N410PWChilhowee Soaring Association Inc · Benton, TNBuilt 1997 · S/N 1707006 N4110VWells Russell L · Seville, OHS/N 6184 N41117Pannuzzo Joanne · Bergenfield, NJBuilt 1997 · S/N 6113 N4111AAbove It All Balloon Co Inc · Basalt, COBuilt 1997 · S/N 6082 N4112UPortland Rose Balloons LLC · Wilsonville, ORBuilt 1997 · S/N 6094 N4112ZGupton Jerry T · Lewisburg, KYBuilt 1997 · S/N 6100 N41134Starr William · Buckeye, AZBuilt 1997 · S/N 6118 N4113GLarson David A · Fort Pierce, FLBuilt 1983 · S/N 3794 N4113QByrd Polar Research Center · Columbus, OHFirst renewal noticeBuilt 1997 · S/N 6108 N4113TTaylor-Christensen Tim · Salt Lake City, UTBuilt 1996 · S/N 6072 N41155Buzzards Glory Balloon Co LLC · Cedar Rapids, IABuilt 1997 · S/N 6110 N4115MTucson Soaring Club Inc · Sahuarita, AZBuilt 1983 · S/N 3799K N4116MKennedy Cary A · Toano, VABuilt 1983 · S/N 5608CB N4116TRader Todd · Aurora, OHS/N 18-2381 N41191Portland Rose Balloons LLC · Wilsonville, ORBuilt 1997 · S/N 6116 N4119GLapamaa LLC · Marysville, OHBuilt 1997 · S/N 6114 N411AMMastis Raminta I · West Bloomfield, MIBuilt 2000 · S/N S60S3004 N411CXBalloon The Nations LLC · Carmel, INBuilt 2023 · S/N 2136 N411JRCollegiate Soaring Association Inc · Greeley, COBuilt 1970 · S/N 35 N411KPBarry Aviation Florida Inc · Edgewater, FLBuilt 1998 · S/N 04-11KP N411LBAirventures Balloon Rides Inc · Paoli, PABuilt 2002 · S/N 5205 N411VARosenbaum Henry D · Mechanicsville, VABuilt 1997 · S/N 5045 N4123BRistenbatt Philip A · Ann Arbor, MIS/N 6067 N41269Gerwig Garrett W · Ashland, OHBuilt 1991 · S/N 5732 N4128YCliver Harold L DBA · Lewisville, TXBuilt 1997 · S/N 6112 N412BKWard Ken E · San Jose, CABuilt 1989 · S/N 6164 N412DHBatalia Michael A · Clemmons, NCBuilt 2000 · S/N 050 N412HSteven Alain P · Lansdale, PABuilt 1979 · S/N 3359 N412JRBorovykh Grigoriy · New York, NYBuilt 2020 · S/N 254 N412LKMahony John · Schenectady, NYBuilt 1994 · S/N 6216 N412SLeonard Steven E · Wichita, KSBuilt 1969 · S/N 12012 N412XLAbercrombie David R · Eatonton, GABuilt 1967 · S/N 6608 N41311Hale Bradley · Lewisville, TXBuilt 1991 · S/N 5693 N4135FRothrock Virgil N Jr · Streator, ILS/N 5710 N413BRUnique Motor Sports LLC · Albuquerque, NMBuilt 2012 · S/N 5504 N413CBMach 1 Ballooning Ltd · Colorado Springs, COBuilt 2010 · S/N LPC 200304 N413HHelmick Hugh M · Ridgecrest, CABuilt 1971 · S/N 48 N413MDNyman Robert H · Elsinore, CABuilt 1968 · S/N 28 N413PJLinda K Howe · Parma, OHBuilt 1974 · S/N 148 N4141DAbove It All Balloon Co Inc · Basalt, COBuilt 1991 · S/N 5682 N4143JBubbles On Ash LLC · Tempe, AZBuilt 1990 · S/N 5686 N4145QBlair Frank L · Fenton, MOBuilt 1991 · S/N 5743 N41463Broker Bill · Wylie, TXBuilt 1991 · S/N 5751 N414JBMadson Jerome Ronald · Goodyear, AZS/N 209 N414KREastern Iowa Gliders Inc · Muscatine, IABuilt 1993 · S/N 04-14KP