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.

N4037JBookman Benjamin I · Colorado Springs, COS/N 7799 N4038RBalloons Over Iowa Ltd · Carlisle, IABuilt 1978 · S/N 6740 N4038UEdwards Jeremy · Marietta, GABuilt 1978 · S/N 7814 N4039GRutan Aaron R · Greentown, INS/N 7831 N4039QRadloff Mark W · Argyle, NYBuilt 1978 · S/N 7824 N403BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029017 N403FNTsb Solutions LLC · Lebanon, INS/N 1407 N403TCCaviglia Roy · El Paso, TXBuilt 1992 · S/N 2136USA N4040JFreedom Flight Inc · Saint Cloud, MNBuilt 1998 · S/N 6077 N4040LHill Martin Jr · Centennial, COBuilt 1979 · S/N 7835 N4041Walker Carol L · Ennis, TXBuilt 1956 · S/N 41 N4041WLee Peter M · Fair Oaks Ranch, TXS/N 5529 N40427Word D Glen · Anthony, NMBuilt 1979 · S/N 7861 N4042DMile High Aeronauts Inc · Littleton, COBuilt 1978 · S/N 7855 N4042KHalling Wayne C · Ceresco, NEBuilt 1979 · S/N 7856 N4042SKimmich Russ S · Coronado, CABuilt 1981 · S/N S55A-852 N40433Starr William K · Buckeye, AZBuilt 1997 · S/N 5042 N40435Berka Joel M · Binghamton, NYS/N 6482 N4044EDezmelyk Robert · Newton, NHBuilt 1979 · S/N 7874 N4044WThornton Ronald D · Littleton, MABuilt 1979 · S/N 7880 N4046KShady Raymond · Casper, WYS/N 513 N40486Clerx Bernard C · Newport Beach, CABuilt 2000 · S/N 28013 N40488Hot Air Balloon Port Inc · Gonzales, LABuilt 2007 · S/N 6488 N4048KGonzales Robert Jr · Coleman, TXBuilt 2006 · S/N 6442 N40494Sumrell Michael P · Lawrenceville, GABuilt 2007 · S/N 6489 N4049RClaypole David C · Chickasha, OKBuilt 1979 · S/N 510 N4049SMiller Howard G · Atmore, ALBuilt 1997 · S/N S57A-3189 N404ESHardy John A · El Paso, TXBuilt 1969 · S/N 44 N404KPBarry Aviation Florida Inc · Edgewater, FLBuilt 1998 · S/N 04-04KP N40501De Koevend Enterprises Inc · Fort Garland, COS/N 7936 N40515Ace Aviation Adventures Inc · Ann Arbor, MIBuilt 1983 · S/N RX7-312 N40517Constellion Susan C · Winter Park, COBuilt 2007 · S/N 6471 N40518Vande Hoef Raymond L · Greeley, COS/N 11143 N4051KSalient Innovations Inc · Sandia Park, NMBuilt 2007 · S/N 6483 N4051TLombardi Marcia M · Bristol, CTBuilt 1979 · S/N 7947 N4052JFlameboyant Balloons LLC · Easton, PABuilt 1980 · S/N 10117 N4052TLeonard Ian Q · Burlington, NCFirst renewal noticeBuilt 1981 · S/N 10040 N4053SBobs Balloon Charters LLC · Davenport, FLBuilt 2007 · S/N 6460 N4053YIhle Ronald W · Slater, IABuilt 1980 · S/N 10088 N4054STerranova-Anderson Deirdre P · Norman, OKBuilt 1980 · S/N 10099 N4054UBailey Todd J · Richland, MOBuilt 1981 · S/N 10101 N4055AGarcia Christopher P · Albuquerque, NMBuilt 2007 · S/N 6494 N4055MAtar Mehmet · Vernon Rockville, CTBuilt 2007 · S/N 6507 N40562Chico Timothy · Vista, CABuilt 2007 · S/N 6490 N40565Campbell Douglas J II · Pahrump, NVS/N 6485 N4057GBoyd Robert T · Quakertown, PABuilt 1981 · S/N 10115 N4058SFuller David M II · Saint Augustine, FLBuilt 1997 · S/N RXS8-3061 N40596Campbell Brittany Rose · Los Lunas, NMBuilt 2007 · S/N 6506 N40598Pyramid Pool LLC · Glendale, AZBuilt 2007 · S/N 6509 N405ABHanson Laurne E · Portage, MIBuilt 2021 · S/N 320