Skip to content

Registered aircraft · 72

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 ('1151212')
  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 ('1151212')
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.

N5953SKahn Richard K · Middletown, DEBuilt 1966 · S/N MB-63 N5954SLancaster Andy R · Midlothian, TXS/N MB-64 N5981STucker Mark R · Williamsburg, VABuilt 1966 · S/N MB-72 N5982SPercy Gary A · Wedderburn, ORBuilt 1966 · S/N MB-73 N5984SBoswell Kurt R · Renton, WABuilt 1966 · S/N MB-76 N5994SThree Musketeers LLC · Gorham, KSBuilt 1966 · S/N MB-84 N5997SHardin Sammy R · Mckinney, TXBuilt 1966 · S/N MB-77 N6901QCbus Flight LLC · Pickerington, OHBuilt 1967 · S/N MB-265 N6903QSullivan Lynford M · Hernando, MSBuilt 1967 · S/N MB-267 N6906QFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N MB-283 N6909QHuston Lee E · Graham, WABuilt 1967 · S/N MB-281 N6915QWilson Kenneth G · Peoria, AZS/N MB-278 N6916QShawn James R · Pattison, TXS/N MB-287 N73MDReed Henry J · Jacksonville, NCS/N MB-226 N7908LUSA Aircraft Leasing LLC · Dover, DEBuilt 1966 · S/N MB-119 N7911LAlthouse Randy A · Postville, IAS/N MB-123 N7912LMiller Cameron · Loomis, CAS/N MB-129 N7914LHumble Aviation LLC · Russellville, ARS/N MB-131 N7923LTolliver Richard R · Amery, WIBuilt 1966 · S/N MB-137 N7945LBertsch David L · Caldwell, IDBuilt 1966 · S/N MB-144 N7976LFarrell Michael · Rockwall, TXBuilt 1966 · S/N MB-157 N7986LRegistered aircraftBuilt 1966 · S/N MB-164

Back to Beech A23-19