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.

N2764ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1964 · S/N 210 N2765ZMaurer Christian N · Loveland, OHBuilt 1964 · S/N 281 N2766ZSky Sailing Inc · Warner Springs, CABuilt 1964 · S/N 9 N2767RAero Club Albatross · Blairstown, NJBuilt 1964 · S/N 234 N2768RHockenberry Tyler F · Royse City, TXBuilt 1963 · S/N 233 N2768ZRea Marita J · Suffolk, VABuilt 1964 · S/N 282 N276BAFowler Larry K · Harrison, ARBuilt 1994 · S/N 948115 N276BBBroker William · Wylie, TXBuilt 2025 · S/N BB-009 N2772ZWright Alan L · Independence, ORBuilt 1965 · S/N 215 N2774HKnauth Geoffrey Stanton · Williamsport, PABuilt 1977 · S/N 74 N2774ZMinden Soaring Club Inc · Minden, NVS/N 14 N2775ZFranconia Soaring Association · Franconia, NHBuilt 1965 · S/N 297 N2776HMontgomery Raymond Lee · Blackfoot, IDBuilt 1978 · S/N 86 N2776ZRegistration Pending · HamburgRegistration pendingBuilt 1965 · S/N 298 N2777ZLewis Curtis L Jr · Loves Park, ILS/N 300 N2779HLudolph William K · Brooklyn, NYBuilt 1976 · S/N 59 N2779ZLake Elsinore Soaring Club · Wildomar, CABuilt 1965 · S/N 15 N277ADDerado John · Lebanon, INBuilt 2001 · S/N 6280 N277ASJantar Group Limited LLC · Mount Airy, MDBuilt 1977 · S/N B-793 N277BAWheeler Shaun W · Covington, TNBuilt 1994 · S/N 940302 N277BMTimeless Tail LLC · Glendale, AZBuilt 2005 · S/N 200589 N277LBCheron Inc DBA · Bryan, TXBuilt 2008 · S/N 5408 N277RRRainbow Ryders Inc · Albuquerque, NMBuilt 2021 · S/N 6935 N277SFPadelt Albert F · Barto, PABuilt 2017 · S/N 753-AP N2780HMorrison Brian D · Albuquerque, NMBuilt 1977 · S/N 80 N2780ZLittfin Scott A · Maryville, TNBuilt 1965 · S/N 299 N2781HBjork Richard · Brackettville, TXBuilt 1977 · S/N 671 N2781ZCollier James D · Summit Point, WVBuilt 1965 · S/N 289 N27826Bowen Stephen T · Englewood, TNBuilt 1970 · S/N 84 N2782WGlen William S · Roswell, NMBuilt 1985 · S/N S60A-353 N2784ZAerodrome Services LLC · Maple Park, ILS/N 218 N2785ZAdkins Dwain L · Sycamore, ILBuilt 1965 · S/N 296 N2787DHancock Derek K · Lake Oswego, ORBuilt 1985 · S/N S60A-361 N27882Knutson-Smisek Edward A · Elysian, MNBuilt 1985 · S/N S55A-1081 N2788ZFuller Paul H · Powell, OHBuilt 1965 · S/N 292 N2789NWagner Bill R · Brandon, SDBuilt 1985 · S/N S60A-372 N278BANevada Soaring Association Inc · Reno, NVS/N 940207 N278RRRainbow Ryders Inc · Albuquerque, NMBuilt 2023 · S/N 2127 N2791CBroker William · Wylie, TXBuilt 1992 · S/N S60A-3176 N27927Raper Robert B · North Bend, ORS/N RX7-396 N2792SSnipes William Morgan · Edmond, OKBuilt 2024 · S/N 2392 N2792XNajewski Edwin R · Tinley Park, ILBuilt 1985 · S/N RX7-394 N2792ZMassey Air Museum Inc · Massey, MDBuilt 1965 · S/N 294 N2793HJourneys Aviation Inc · Boulder, COBuilt 1978 · S/N 533 N2793ZPark Forest South Aviation Group · Mount Prospect, ILS/N 286 N2794LDrake Mary Jo · Alamogordo, NMS/N RX7-404 N2794XHunziker Edward A · Newton, NJS/N RX7-407 N2797ZWilkinson Ephriam B · Eads, TNBuilt 1966 · S/N 293 N2798ZLake Elsinore Soaring Club · Wildomar, CABuilt 1965 · S/N 285 N279BANevada Soaring Association Inc · Reno, NVBuilt 1994 · S/N 940216