Skip to content

Registered aircraft · 7,860

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.

N61CTArcher Lisa A · Maumelle, ARS/N 2393 N61JJSchindowsky Normen · Sarasota, FLBuilt 1974 · S/N 549 N61XCStewart James R · Westford, MABuilt 1996 · S/N 31 N61XTMckenzie Dawn · Birmingham, MIBuilt 2023 · S/N 6993 N6206TBlaser Swisslube · Goshen, NYBuilt 1998 · S/N 96 N620CLevy Niv B · Torrance, CAS/N 20837 N620PHFelty Paul A · Danville, INBuilt 2018 · S/N 1448 N620PSA R B C Inc DBA · Galena, ILBuilt 2026 · S/N 5839 N620XSBarnosky Joseph J · Cedaredge, COBuilt 2012 · S/N 6563 N621ASLongley Charles A · Nome, AKBuilt 1980 · S/N 20363 N621CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2000 · S/N 21708 N621HHHarris Hill Soaring Corp · Horseheads, NYBuilt 2008 · S/N 21846 N621MGMid-Georgia Soaring Association · Monroe, GABuilt 1985 · S/N 21254 N621USGreen John J · Albuquerque, NMBuilt 2003 · S/N S57H-3003 N6222LKing John D · Midland, VABuilt 1999 · S/N 64425 N622KWWalter Jack D · Waukesha, WIBuilt 2025 · S/N 5824 N622WAviation Museum Of Kentucky Inc · Lexington, KYBuilt 1964 · S/N 106 N623Noodergraaf Alexander A · Concord, NHBuilt 1970 · S/N 15073 N62301Leonard Steven E · Wichita, KSBuilt 1970 · S/N 281 N6230VBlaser Swisslube Inc · Goshen, NYBuilt 1996 · S/N 0005 N62358Red Leasing LLC · Juneau, AKBuilt 1953 · S/N 627 N6238Chmiel John P · Wausau, WIS/N 1931 N62390Bedell Christopher L · Santa Fe, NMBuilt 1974 · S/N 20011 N623KDRegistration Pending · Edgewood, NMRegistration pendingBuilt 2026 · S/N 5836 N623KLWahl John · Edgewood, NMBuilt 1995 · S/N S49A-3196 N623NXWahl John F · Edgewood, NMBuilt 1970 · S/N 106 N623RKKeyser Ralph · Albuquerque, NMFirst renewal noticeBuilt 2017 · S/N 6814 N623RNStanton James E · Fulton, MSBuilt 2023 · S/N 2132 N623XTurner Lee H · Felton, DEBuilt 1965 · S/N 8402 N623XXWahl John F · Edgewood, NMBuilt 1965 · S/N 226 N62434Romano James J · San Antonio, TXBuilt 1976 · S/N 11 N624BGMadson James W · Las Vegas, NVBuilt 1979 · S/N 3354 N624GWJawz Management LLC · Chandler, AZBuilt 1984 · S/N 25-0823 N624RMDavis Gary L · Lascassas, TNS/N 10-129S82 N624XGifford Scott A · Mcminnville, ORBuilt 1965 · S/N 12 N62516N304mg LLC · Homestead, FLBuilt 1973 · S/N 063 N62589Byard Jeffery G · Carson City, NVBuilt 1959 · S/N 11-B1 N625CWTrottier Walter R · Bronx, NYBuilt 1981 · S/N 19 N625DHHoover David A · Little Rock, ARBuilt 2007 · S/N 5359 N625FFMonahan Todd J · Queensbury, NYBuilt 2014 · S/N LP2013-02 N625LLMonahan Todd J · Queensbury, NYBuilt 2012 · S/N 1026 N625SKMonahan Todd · Queensbury, NYBuilt 2023 · S/N 6983 N625SLMonahan Todd J · Queensbury, NYBuilt 2020 · S/N LP2020-04 N625TGMonahan Todd J · Queensbury, NYBuilt 2021 · S/N LP2021-04 N625UNMonahan Todd · Queensbury, NYBuilt 2019 · S/N LP2019-02 N626EVBalloon The Nations LLC · Carmel, INBuilt 2025 · S/N 2448 N626JFFarzad Dariush · Willseyville, NYBuilt 2022 · S/N 6948 N627FNRiley Matthew · Kansas City, MOBuilt 2018 · S/N 5669 N627KTCusick James F · Marysville, OHBuilt 2004 · S/N 5262 N627NGSummers Christopher S · Lebanon, OHBuilt 2003 · S/N 27212