Skip to content

Registered aircraft · 121

Aircraft of this model 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 aircraft_model_code IN ('1151226')
  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 aircraft_model_code IN ('1151226')
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.

N7925LAdams August G · Southport, NCS/N MA-112 N7928LCox Robert Etan · Flippin, ARBuilt 1966 · S/N MA-115 N7930LChavez Andrew · Pagosa Springs, COBuilt 1966 · S/N MA-117 N7931LZundel Dana John · Watkins, COS/N MA-118 N7942LSpitzer Jimmy J · Waxahachie, TXBuilt 1966 · S/N MA-119 N7958LLongleaf Aviators LLC · Enterprise, ALBuilt 1966 · S/N MA-139 N7964LNordby Frederick · Felton, CABuilt 1966 · S/N MA-140 N7981LLund Larry D · Manti, UTBuilt 1966 · S/N MA-143 N7987LWhitten Michael Neil · Wimberley, TXBuilt 1966 · S/N MA-148 N7988LMorris Aaron B · Louisville, GABuilt 1966 · S/N MA-159 N7989LPringle Nathan · Discovery Bay, CABuilt 1966 · S/N MA-150 N7990LAshment Joseph E · Shepherd, MTBuilt 1966 · S/N MA-163 N7993LFranklin Tonda Leah · Chatfield, TXBuilt 1966 · S/N MA-155 N7994LConsummate Inc · Cedar City, UTBuilt 1966 · S/N MA-156 N7998LMarkham Gerald W · Kodiak, AKBuilt 1966 · S/N MA-161 N8462NBoskind Richard · Indialantic, FLBuilt 1968 · S/N MA-321 N86ZZSchermer Jacob D · Denver, COBuilt 1966 · S/N MA-85 N9116TSkinner Jay D · The Woodlands, TXBuilt 1968 · S/N MA-331 N9119TDahab Richard E · Brightwaters, NYBuilt 1968 · S/N MA-333 N914GPRoy Dino · Saginaw, TXBuilt 1966 · S/N MA-124 N98339Carlson Jeremy · Yucaipa, CABuilt 1968 · S/N MA297

Back to Beech A23-24