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.

N5074TPate Michael G · Pontotoc, MSS/N MA-322 N5076TDriffill Leroy R · Antonito, COS/N MA-324 N5077TBerg Sanford B · Lakeville, MNBuilt 1968 · S/N MA-325 N50GDTranguch John M · Beaver Meadows, PABuilt 1966 · S/N MA-128 N5650SOliver Jonathan · Maryville, TNBuilt 1966 · S/N MA-68 N5653SSellers Alton H · Savannah, GABuilt 1966 · S/N MA-79 N5654SWilcox Ryan · Brookland, ARBuilt 1966 · S/N MA-80 N5672SHogan Jacob A · Canon City, COBuilt 1966 · S/N MA-82 N5681SHillcrest Aviation LLC · Midland, TXBuilt 1966 · S/N MA-91 N5693SChupp David · Abbeville, SCBuilt 1966 · S/N MA-94 N5698SNewell Gary A · Colmar, PABuilt 1966 · S/N MA-102 N5754VWeiser Steven Clark · Hutto, TXBuilt 1966 · S/N MA-20 N5755VArnold Alan Dale · Glenwood Springs, COBuilt 1966 · S/N MA-16 N5768VSkyzure LLC · Chelsea, MIBuilt 1966 · S/N MA-21 N5770VAkins Terral S · Grain Valley, MOBuilt 1966 · S/N MA-25 N5771VLow & Slow Aviation LLC · Westminster, COBuilt 1966 · S/N MA-22 N5772VSouthwest Truck Parts Inc · Pratt, KSS/N MA-24 N5777VDe La Garza Jimmy · Granbury, TXBuilt 1966 · S/N MA-29 N5778VGlenn Larry D · Reynoldsburg, OHBuilt 1966 · S/N MA-37 N5782VDave Sheets And Sons Contracting Inc · Columbia City, INBuilt 1966 · S/N MA-41 N5964SMcnew John P · Brighton, COS/N MA-51 N5965SOverstreet James C · Montgomery, TXBuilt 1966 · S/N MA-52 N5973SPeck David T III · Whiting, NJBuilt 1966 · S/N MA-56 N5974SGulf Coast Aviation LLC · New Orleans, LABuilt 1966 · S/N MA-57 N5977SRothwell Rocky J · Valdosta, GABuilt 1966 · S/N MA-50 N5979SJohnson Jay W · Wichita, KSBuilt 1966 · S/N MA-60 N5993SEnd Poverty Now Inc · Maumee, OHS/N MA-63 N6094NAmerican Aviator LLC · Arlington, TXBuilt 1968 · S/N MA-336 N6134NChris Bellinger Dvm LLC · Newalla, OKS/N MA-345 N650VXOneal Timothy James · Vancouver, WABuilt 1967 · S/N MA-194 N6920QNeff Marcus J · Tigard, ORBuilt 1967 · S/N MA-273 N6923QWelch William Trustee · Washington, UTBuilt 1967 · S/N MA-279 N6924QPag Air LLC · Concord Township, OHBuilt 1967 · S/N MA-283 N6927QIowa Military Aviation Heritage Museum · Ankeny, IABuilt 1967 · S/N MA-286 N6945QEllis Jordan Barrett · Oklahoma City, OKBuilt 1968 · S/N MA-295 N6946QBlalock James M · Sheridan, ARBuilt 1968 · S/N MA-296 N6953QBrancefield John Lewis · Fort Mohave, AZBuilt 1968 · S/N MA-300 N6954QBalash Bryan J · Oldenburg, INBuilt 1968 · S/N MA-302 N6956QStaab Robert J · Wantage, NJBuilt 1968 · S/N MA-304 N6957QWashburn Ronald G · Westfield, INBuilt 1968 · S/N MA-305 N6963QHorst Monte · Cody, WYBuilt 1968 · S/N MA-308 N6964QSliger Arbie D · Benton, KSBuilt 1968 · S/N MA-309 N6975QWeber Mark J · Hoven, SDBuilt 1968 · S/N MA-338 N6976QBeech 76q LLC · Englewood, FLBuilt 1968 · S/N MA-339 N6986QBennett Donald M · Burley, WAFirst renewal noticeBuilt 1968 · S/N MA-317 N7626RBasinger Weston P · Alexandria, VABuilt 1969 · S/N MA-348 N7653RBeech Aviators Of Houston LLC · Kingsland, TXBuilt 1969 · S/N MA-353 N7679RSmith Melissa R · Atlanta, ILS/N MA-359 N7907LParker Daniel J · Ewing, NES/N MA-99 N7920LOstrom Richard A · Sterling Hts, MIBuilt 1966 · S/N MA-103

Back to Beech A23-24