Skip to content

Registered aircraft · 7,855

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.

N2985BGuthrie Matt W · Albuquerque, NMBuilt 1985 · S/N 5121 N2985HArizona Soaring Inc · Maricopa, AZBuilt 1979 · S/N 555 N29861K And D Company · Beulah, MIBuilt 1986 · S/N 5194 N2987HSterling Flyers LLC · Lehi, UTS/N 559 N29895Susquehanna Valley Balloon Co Inc · Lititz, PABuilt 1986 · S/N 5212 N2989WSalazar Katelyn C · Los Lunas, NMS/N 5202 N298CBDorman Richard E · Mesa, WAS/N 454 N298LSGawthrop Keirn R · Westfield, INBuilt 2016 · S/N 5600 N298TWAviation Ranch LLC · Cordele, GABuilt 2025 · S/N 2455 N2990HSky Sailing Inc · Warner Springs, CABuilt 1979 · S/N 690 N2990WIbbotson Mark D · Grand Prairie, TXBuilt 1986 · S/N 5214 N29920White James R · West Liberty, OHS/N 24503 N29921Cheers Over California Inc · Sacramento, CABuilt 1986 · S/N 5224 N29922Nilz Patrick S · Marana, AZBuilt 1986 · S/N 5225 N2992LBalloon Adventures New Bedford Inc · South Dartmouth, MABuilt 1986 · S/N 5223 N2994HAero Club Albatross · Blairstown, NJBuilt 1979 · S/N 692 N2995AAbecca Corp · Jackson, MIBuilt 1985 · S/N 5157 N2995HRihn Daniel R · Seal Beach, CABuilt 1979 · S/N 695 N2995MDennis Chad W · Grand Blanc, MIS/N 5139 N2997HMoos Milton H Trustee · Westerville, OHBuilt 1979 · S/N 697 N2998HSharp John W Trustee · Opelika, ALBuilt 1980 · S/N 698 N299ANGo Ballooning LLC · Beavercreek, OHBuilt 1979 · S/N 410 N299BALas Vegas Valley Soaring Association Inc · Jean, NVBuilt 1996 · S/N 968303 N299GFevrier Ian · San Diego, CABuilt 1978 · S/N 3328 N299VPBates William S · Burlington, WVS/N 2-29 N299ZZOlson William J · Indianola, IABuilt 2025 · S/N 5821 N29ASKatinszky Harold A · Fullerton, CAS/N W-862 N29DGBrenhaug Jeffrey O · Hutchinson, MNBuilt 1981 · S/N E-86 G-59 N29ESAugust Aero LLC · Kalispell, MTBuilt 1965 · S/N 318 N29HSCocatre-Zilgien Jan H · Urbana, ILBuilt 1996 · S/N 022 N29JHTampa Bay Soaring Soceity Inc · Zephyrhills, FLBuilt 1975 · S/N 20061 N29KSHoover Michael B · Ridgeland, WIS/N 144 N29PSWalling Reigh A · Clifton Park, NYS/N 137 N29SZReitter Noah T · Avoca, NYBuilt 2009 · S/N 29053 N29XDPalmer William F Jr · Ramona, CABuilt 2008 · S/N 29031 N29XMXray Mike Inc · Wilmington, DEBuilt 2012 · S/N 29069 N29XRSkycab Balloon Promotions LLC · Louisville, KYBuilt 2006 · S/N 5334 N2CGValentine Joseph L · Stanton, CABuilt 1972 · S/N 209 N2CUCavin John C · Indialantic, FLBuilt 2008 · S/N 42448 N2JYNorthern Aviation LLC · Palmer, AKBuilt 1976 · S/N 56 N2KJReinhart Rodger Alan · Pescadero, CABuilt 1999 · S/N 258CS N2KVSides Matt E · Lonoke, ARBuilt 1975 · S/N 20036 N2LEHaggett William Thomas · Durham, NCBuilt 1976 · S/N 1312 N2XWAlexander Kenton C · Wichita, KSBuilt 1977 · S/N 20566 N2YASmith Daryl N · Coventry, CTBuilt 1981 · S/N 4093 N2YSDonald J Beahm · Silverton, ORS/N W-704 N2ZJRobinson David G · Half Moon Bay, CAS/N 003 N30006Kurczab Krzystof J · Streamwood, ILBuilt 2001 · S/N 015 N3000SRivas Stacee L · Sanford, NCBuilt 2011 · S/N F7B-2017 N30018Vande Hoef Edward L · Broomfield, COBuilt 2000 · S/N 105/71