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.

N434RHPoladian Rakel J · Homestead, FLS/N 282CS N434TCAbove It All Balloon Co Inc · Basalt, COBuilt 1992 · S/N 2258USA N435ACLeonard Steven E · Wichita, KSBuilt 1998 · S/N 035 N435NLHappily Ever After Balloon Company LLC · Fort Collins, COBuilt 2001 · S/N 001 N4362Sigler Robert E · Round Rock, TXBuilt 1971 · S/N 216 N4372UColyer William G · Fairfield, CTBuilt 1998 · S/N CYB-002 N4373KMcleroy Johnathan David · Saint Cloud, FLBuilt 1997 · S/N 17.10.009 N437BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029015 N438BACivil Air Patrol · Maxwell Afb, ALBuilt 2002 · S/N 029016 N438TCConrad David G · Ouray, COFirst renewal noticeBuilt 1992 · S/N 2259USA N43929Henry James R · Lakeville, MNBuilt 1977 · S/N 81 N4392SAerial Advantage Inc · Columbia, MOBuilt 2006 · S/N 9840 N4392USommers Christopher A · Slatington, PABuilt 1984 · S/N S60A-297 N4394EAugust Joe A · Newport Beach, CABuilt 1984 · S/N S60A-310 N4394XGarner Kenneth W · Decatur, ALBuilt 1984 · S/N S60A-316 N4395LWhite Shannon N · Loveland, COS/N S60A-331 N4397VWinchester William E · Jonesboro, ARS/N RX7-366 N43ARBuffalo Outdoor Center Inc · Ponca, ARBuilt 2021 · S/N 5727 N43GHRichards Kerry T · Longview, WABuilt 1998 · S/N 551198103 N43JHohanshelt Laura S · Minneapolis, MNBuilt 1970 · S/N 4345 N43JHHuntsville Soaring Assn · Brownsboro, ALBuilt 1983 · S/N 3806 N43MDMiddleline Aviation Inc · Ballston Spa, NYBuilt 1989 · S/N 6-40 N43SGNoordergraaf Alexander A · Concord, NHBuilt 1986 · S/N 82 N4401YMajestic Adventures Inc · South Lyon, MIBuilt 1984 · S/N S55A-1070 N4401ZOswald Donald W · Palmdale, CABuilt 1985 · S/N RX7-378 N4404Colvin Clu D DBA · Big Cabin, OKS/N 6601 N4408RChrysalis · Carlsborg, WABuilt 1999 · S/N 1 N440BHPundole Faraidoon N · Sugar Land, TXS/N 4098 N440BKKeown Owen B · Temecula, CABuilt 2020 · S/N 1640 N440MDBarrett William M · Neosho, MOBuilt 2003 · S/N 5244 N440THCasti Peter A · Sparks, NVBuilt 1979 · S/N 4022 N44147Knutson Wayne R · Thompson, NDS/N 25-49 N4414WZivley Mark · Houston, TXBuilt 1998 · S/N 17.09.014 N4416SRuggiero Lawrence G · Greenville, SCBuilt 1998 · S/N B2177 N441MCBemidji Aviation Services Inc · Bemidji, MNS/N LF 45 N441MTAerial Advantage Inc · Columbia, MOBuilt 2016 · S/N 5603 N441UJBruce Robert H · Boerne, TXBuilt 1969 · S/N 55 N4424ESouthern Eagles Soaring Inc · Butler, GABuilt 1983 · S/N 5117 N4424NSouthern Eagles Soaring Inc · Butler, GABuilt 1983 · S/N 5116 N44259Sandhill Soaring Club Inc · Brighton, MIBuilt 1983 · S/N 3790 N4425YRudloff Uwe K · Lake Village, INBuilt 1983 · S/N 3820 N4426BN4426b LLC · Hood River, ORBuilt 1983 · S/N 3791 N442LCaldwell George A · Henderson, NVBuilt 1996 · S/N 1939 N442MCMerrell Jon P · Wolcott, NYS/N LF 54 N4432TWilliams John Scott · Norman, OKS/N 29 N44340Johnson Carl A · Auburndale, MABuilt 1989 · S/N 7041 N443BACivil Air Patrol Inc · Maxwell Afb, ALBuilt 2002 · S/N 029018 N443MCFnnuts LLC · West Hazleton, PAS/N 31-8252061 N4440CLapointe Wilfred · Heber City, UTBuilt 2020 · S/N 1766 N4444YConstantin George N · Granada Hills, CABuilt 1965 · S/N 805