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.

N7794SAnding Jay B · Bryan, TXBuilt 1969 · S/N 70 N7795SSwartz Raymond L Jr · Pasadena, CABuilt 1969 · S/N 460 N7798SRussell Larry B · Union City, TNFirst renewal noticeBuilt 1969 · S/N 458 N7799SCumberland Soaring Group Inc · Wiley Ford, WVBuilt 1972 · S/N 446 N779SGGneiting Scott J · Saint George, UTBuilt 2020 · S/N 1771 N77AERoberts David M · Albuquerque, NMS/N 59 N77ASHigh Flights Soaring Club · Peyton, COFirst renewal noticeBuilt 1978 · S/N 027006 N77BFEckels Richard E · Venice, FLBuilt 1977 · S/N 48 N77BSDickman Marc · Jacksonville, FLBuilt 1969 · S/N 4 N77CNSandhill Soaring Club Inc · Brighton, MIBuilt 1971 · S/N 105 N77HZWisniewski Wit Tadeusz · Tucson, AZBuilt 1976 · S/N 20121C N77JHFiliaci Mattia E · New York, NYBuilt 1983 · S/N 169 N77JRRobertson Kirk Patrick · Bay City, TXBuilt 1973 · S/N 470 N77LKOlsen Randle B · Riverton, UTBuilt 1979 · S/N 3355 N77LTDay Carl D · Sedan, KSBuilt 2020 · S/N 1648 N77NVLert Peter S · Graton, CABuilt 1969 · S/N 031 N77SWWestbrook Michael S · Mansfield, TXBuilt 2006 · S/N 169 N77UDSchafer Gordon · Alden, MIBuilt 2021 · S/N 6928 N77ULRed Line Flyers LLC · Zionsville, INS/N 1288 N77UMNapa Valley Aloft Inc · Napa, CAS/N 77/259 N77UNAcme Rocket Sleds LLC · Draper, UTBuilt 2002 · S/N 27186 N77UUHingst Douglas J · Rcho Sta Marg, CABuilt 1999 · S/N 54 N77VLGehrlein Products · Waterford, PABuilt 1976 · S/N 449 N77WJDerrickson Jack N · Waynesville, OHS/N 77 N77WPParzyk Roy E · Lake Stevens, WABuilt 1975 · S/N 20056 N77XRVoegeli Jan M · Golden, COS/N 20267 N77XTCarpenter Bruce E · Monroe, NYBuilt 1976 · S/N 20100C N77YZBadenhop April · Fort Pierce, FLBuilt 2000 · S/N 2020 N77ZDRadigan Laura Lynn · Merritt Island, FLBuilt 1997 · S/N B-2172 N7801TNapa Valley Aerostat Club · Napa, CABuilt 1990 · S/N 2348 N780HSCrabtree Chad · Delton, MIBuilt 2023 · S/N 6957 N780RLLykins Robert J · Washingtn Twp, MIBuilt 2008 · S/N 001 N7812CKoenig David W · Menasha, WIBuilt 1997 · S/N 001 N781FNRussel Luke S · Chagrin Falls, OHBuilt 2013 · S/N 962 N781LBSt Louis Ballooning Adventures LLC · Foley, MOBuilt 2009 · S/N 5431 N7820AWhite Wings LLC · Sheridan, WYBuilt 1978 · S/N 20093 N7820DSafronoff Drew · Seattle, WAS/N 20602 N782TCDigiovanni Ronald · Milford, NJBuilt 1993 · S/N 2409 N783ATUtah Outventures LLC · South Salt Lake, UTBuilt 2012 · S/N 946 N784MEMorin Chad R · Algonquin, ILS/N 150/02 N7855RZimmer Rachel A · Rio Rancho, NMBuilt 2016 · S/N 212 N785GClosson Luke E Jr · Valdosta, GABuilt 1985 · S/N 33985-K-218 N785SRitchie Race Scott · Odessa, TXS/N EA-334 N786GCypress Soaring Inc · Hemet, CABuilt 1985 · S/N 33986-K-219 N786LBSkycab Balloon Promotions Inc · Louisville, KYBuilt 2016 · S/N 5610 N786TCKious Thomas · Albuquerque, NMS/N 2517 N7872CSteenblik Jan W · Bloomington, INBuilt 1959 · S/N 1043 N7877YLapointe Wil J · Owasso, OKBuilt 2021 · S/N 1830 N7879Thurber Charles H Jr · Mcalester, OKBuilt 1966 · S/N 24 N787CWWelsh Christopher R · Cresson, TXS/N 4090