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.

N11KJTango Kilo LLC · Miami, FLBuilt 1977 · S/N 20015 N11LELeonard Steven E · Wichita, KSS/N 013 N11MNJet Mavericks LLC · Indianapolis, INBuilt 1976 · S/N 500-0266 N11NCPierce John C · Cedar City, UTBuilt 1968 · S/N 64 N11QSNevada Soaring Association Inc · Reno, NVBuilt 1978 · S/N 19210 N11RDHolmes Alonso P · Broomfield, COBuilt 1969 · S/N 74 N11RQStory James A · Herrin, ILBuilt 1969 · S/N 20 N11SABarlow Robert K · Lakeway, TXBuilt 1974 · S/N 591 N11SWMetkowski Leonard P · York, PABuilt 1972 · S/N 243G N11TACurry Robert B · Delphos, OHBuilt 1978 · S/N 3193 N11TWDunifer Charles P · Salado, TXBuilt 1969 · S/N 051 N11TXWeis John F · Sedona, AZBuilt 1969 · S/N 050 N11UUnicorn Soaring Associates · Maple Valley, WABuilt 1976 · S/N 1369 N11UMEichhorn David J · Corrales, NMS/N 160/24 N11UUFisch Gregory Z · Charlotte, NCBuilt 1971 · S/N 42 N11VEKlein Flying Service Inc · Lawrenceville, ILBuilt 1976 · S/N 20150C N11WXPinney Charles W · Tucson, AZBuilt 2004 · S/N 159 N11XHAnderson Michael L · Lubbock, TXBuilt 1977 · S/N B-719 N11YVMahony John P · Schenectady, NYBuilt 1977 · S/N 55 N120Dittmer Larry J · Basco, ILBuilt 1980 · S/N 20344 N1200Carpenter James M · Harrisburg, NCBuilt 1966 · S/N 6521 N1200SRetroair Restoration LLC · Big Lake, AKBuilt 1970 · S/N 200 N1201Blair Charles Lee · West Hartford, CTBuilt 2003 · S/N 308CS N1202Warbirds Of The World Air Museum · Los Lunas, NMS/N 19JB N1202ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1982 · S/N 3615 N12035Portland Rose Balloons LLC · Wilsonville, ORBuilt 2026 · S/N 2582 N12052Gonitzke Matthew D · Andover, KSBuilt 1965 · S/N SH76 N1205RDuer Darrell Jr · Oklahoma City, OKS/N S60A-3039 N1206WKenyo R Eugene · Hudson, OHBuilt 2019 · S/N F7-2074 N120AKN120ak LLC · Sheridan, WYBuilt 2025 · S/N 2547 N120BLRegistration Pending · Elmira, NYRegistration pending, canceledS/N 20105 N120DPLewis John R · Leakey, TXBuilt 2016 · S/N 6767 N120DWArizona Soaring Inc · Maricopa, AZBuilt 2002 · S/N 21747 N120GDEndeavor Aviation Inc · Belgrade, MTBuilt 2014 · S/N 6723 N120KBAmazing Adventures Inc · Temecula, CABuilt 2014 · S/N 1065 N120LBPlano Balloon Festival Inc · Plano, TXBuilt 2004 · S/N 5234 N120LEHitron John · Louisville, KYBuilt 2001 · S/N 3082 N120MWHood River Soaring Inc · Hood River, ORBuilt 2000 · S/N 000513 N120NMVegas Balloon Rides (2021) LLC · Las Vegas, NVBuilt 2011 · S/N 6609 N120NNGreen Mark T · Orlando, FLBuilt 2012 · S/N 6674 N120NVSonoma Ballooning Adventures LLC · Sonoma, CABuilt 2014 · S/N 1096 N120PVEckstein Sean R · Orange, CABuilt 1981 · S/N 20493 N120RSRamsden Graham P · Omaha, NEBuilt 1981 · S/N 4092 N120RTLin Yuchen · Park City, UTS/N 6662 N120SMXclusive Balloons LLC · Taylorsville, KYBuilt 2010 · S/N 5472 N120TAHagleitner Gunther · San Jose, CAS/N 246 CS N120TCDavis Cory M · Carrollton, TXBuilt 1990 · S/N 1869USA N120TRFitzpatrick Mary Ann · Los Angeles, CAS/N 6670 N120USAnderson Abruzzo Intl Balloon Museum Foundation · Albuquerque, NMBuilt 1985 · S/N 1120 N120WBMcclain Kip M · Parker, COBuilt 1980 · S/N 20361