Skip to content

Registered aircraft · 7,853

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.

N2723ZOwen Bryce C · Solvang, CABuilt 1964 · S/N 179 N2724HN2724h Aviation Services LLC · Colorado Springs, COBuilt 1978 · S/N 504 N2724ZHollatz Walter M · Concord, GABuilt 1964 · S/N 249 N2727BZelek Daniel · Wurtsboro, NYBuilt 2000 · S/N 27137 N2727ZMorgan III Robert E · Destin, FLBuilt 1964 · S/N 181 N272BLFrechtling Andrew C · Waxahachie, TXBuilt 2001 · S/N 119 N272JSRuf Chris J · Sandy Springs, GABuilt 1997 · S/N 27058 N272PCHilty Grant C · Prescott Valley, AZBuilt 1996 · S/N 27031 N2731Kriz Andrew S · Blacksburg, VABuilt 1978 · S/N 148 N2731ZWave Soaring Adventures Inc · Lake Tapps, WABuilt 1964 · S/N 251 N2736ZPearce Andrew M · San Francisco, CABuilt 1964 · S/N 254 N273PQBalloon Quest Inc · Fenton, MIBuilt 1987 · S/N 1010 N273SPRiley Thomas V · San Diego, CABuilt 1997 · S/N 27037 N273WHogben Andrew T · Belmont, CABuilt 2002 · S/N 27192 N2740ZBriner Mark E · Utica, KYS/N 257 N2741ZHamilton Soaring Club Inc · Hamilton, TXBuilt 1966 · S/N 248 N2743HSugarbush Soaring Association Inc · Warren, VTBuilt 1978 · S/N 503 N2743ZDaye Jeffrey E · Salisbury, NCBuilt 1965 · S/N 246 N2745HBarrett Jane T · Tehachapi, CABuilt 1978 · S/N 525 N2746RLewis Curtis L Jr · Loves Park, ILBuilt 1963 · S/N 216 N2747ZMidwestern Soaring Association · Peculiar, MOBuilt 1964 · S/N 195 N2748RGoebel James W · Loveland, OHBuilt 1963 · S/N 168 N2748ZBarry Stephen A · Bonsall, CABuilt 1964 · S/N 260 N2749RRenshaw Kevin J · Fort Worth, TXBuilt 1963 · S/N 217 N2749Z2019 Glider LLC · Pipersville, PABuilt 1964 · S/N 197 N274BAGreater Houston Soaring Association · Needville, TXBuilt 1994 · S/N 948113 N274CEHawkins Mark F · Edgewood, NMBuilt 1998 · S/N 27085 N274LZLiberty Balloon Holdings LLC · Groveland, NYBuilt 2021 · S/N 1848 N274RDPillard Russell L Jr · Santa Rosa, CABuilt 1996 · S/N 27019 N274RTSchaefer Rich · Marble Falls, TXBuilt 1997 · S/N 27059 N274SHTaylor Michael J · Fort Worth, TXBuilt 2006 · S/N 021 N2750HChilhowee Soaring Association Inc · Benton, TNBuilt 1976 · S/N 450 N2752RAnding Jay B · Bryan, TXBuilt 1963 · S/N 221 N2753ZDavenport Peter B · Harrington, WABuilt 1964 · S/N 208 N2754R219 Investments LLC · Miami, FLBuilt 1965 · S/N 219 N275AZRainbow Ryders Inc · Albuquerque, NMBuilt 2021 · S/N 6926 N275BNTahoe Balloon Tours · Gardnerville, NVBuilt 2024 · S/N 2317 N275FBWilkinson Steve A · Lake Havasu City, AZBuilt 2021 · S/N 1875 N275FWFair Winds Incoporated · Longmont, COBuilt 2022 · S/N 250/111 N275NMAeronautical Solutions LLC · Taos, NMBuilt 2016 · S/N 6783 N275RRRegistered aircraftBuilt 2012 · S/N 6652 N275SLPacific Rim Adventures Inc · Los Olivos, CABuilt 2022 · S/N 1991 N275UMTobin Enterprises LLC · Denver, COBuilt 2023 · S/N 250/122 N275WBPerfect Flight LLC · Albuquerque, NMBuilt 2017 · S/N 250/91 N275YVNapa Valley Aloft Inc · Yountville, CABuilt 2019 · S/N 1582 N2760RStewarts Aircraft Service · Waynesville, OHBuilt 1963 · S/N 229 N2761RCarlton Koby A · Warsaw, KYBuilt 1963 · S/N 174 N2762RWilliams Jimmy Z · Sherman, TXBuilt 1963 · S/N 175 N2763ZHard Steven J · Mustang, OKS/N 271 N2764ZTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1964 · S/N 210