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.

N2319WWinstead Walley K · Leavenworth, KSBuilt 1965 · S/N MB-1 N2320WThompson Robert J · Irwin, PABuilt 1966 · S/N MB-2 N2329WSwonke Adam J · Spring, TXBuilt 1966 · S/N MB-20 N2371WSpaich Brad G · Mcpherson, KSBuilt 1966 · S/N MB-9 N2372WHulme Aviation LLC · Gilbert, AZBuilt 1966 · S/N MB-10 N2383WMcclure Miles · Vancouver, WAS/N MB-18 N2389WCherney Cody L · Belleville, KSBuilt 1966 · S/N MB-24 N2390WNgk Aviation LLC · West Point, NEBuilt 1966 · S/N MB-28 N2391WShanahan Jolene D · Upper Lake, CAS/N MB-29 N2395WRegistration Pending · Leavittsburg, OHRegistration pendingS/N MB-26 N2397WMigliorini William E · Granville, ILBuilt 1966 · S/N MB-27 N300JLKehoe Keith J · Marion, TXBuilt 1966 · S/N MB-134 N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4 N3614QMay Robert L · Spring Branch, TXBuilt 1967 · S/N MB-252 N3615QPlane Safe Aircraft Maintenance Inc · Waukesha, WIS/N MB-237 N3624QEkholm Bryan K · Annandale, MNBuilt 1967 · S/N MB-242 N3635QFantini Real Estate LLC · Louisville, KYBuilt 1967 · S/N MB-246 N3638QWinder Keven S · Castle Rock, COBuilt 1967 · S/N MB-251 N3640QBenville Pete E Jr · Boonville, CABuilt 1967 · S/N MB-253 N3642QPorte Elvis · Miami, FLS/N MB-262 N39474Hartwig Aircraft Fuel Cell Repair Inc · St AndrewsBuilt 1966 · S/N MB-23 N4711JDoucet Joshua A · Cabot, ARBuilt 1966 · S/N MB-169 N4717JBrock Aviation Flight School LLC · Douglasville, GABuilt 1966 · S/N MB-175 N4724JRegistration Pending · Orlando, FLRegistration pendingS/N MB-184 N4727JSindelar Kenneth L · Fremont, WIBuilt 1966 · S/N MB-185 N4728JGlodo Gordon W · Grand Tower, ILBuilt 1966 · S/N MB-186 N4753JTiki Aerospace LLC · Saint Petersburg, FLBuilt 1967 · S/N MB-197 N4754JDevendorf Donald A Jr · Prescott, AZBuilt 1967 · S/N MB-201 N4756JEhling Joseph P · Snohomish, WABuilt 1967 · S/N MB-203 N4765JHall Jarrod L · Eufaula, OKBuilt 1967 · S/N MB-204 N4771JAsx Flight Services LLC · Ashland, WIBuilt 1967 · S/N MB-207 N4776JKimbrough Paul E · Millcreek, UTBuilt 1967 · S/N MB-221 N4777JHowell Michael A · Parsons, KSBuilt 1967 · S/N MB-224 N4780JItzchak Arzt · Sarasota, FLBuilt 1967 · S/N MB-228 N4781JWyatt Steven Joseph · Caddo Mills, TXBuilt 1967 · S/N MB-231 N4784JSale Reported · Crystal, MNSale reportedBuilt 1967 · S/N MB-220 N501AHOlah Gregory J · High Point, NCBuilt 1966 · S/N MB-80 N5660SRussek Ron · Cleburne, TXBuilt 1966 · S/N MB-101 N5667SParsons John C · Wichita, KSBuilt 1966 · S/N MB-106 N5671SMusketeer Aviation Inc · Potterville, MIBuilt 1966 · S/N MB-110 N5679SWinters Kevin L · Nine Mile Falls, WABuilt 1966 · S/N MB-122 N5685SGreen Taylor · Olympia, WABuilt 1966 · S/N MB-125 N5687SRobbins Warren N · Chandler, AZBuilt 1966 · S/N MB-127 N5688STanneberg Larry · Coulee City, WABuilt 1966 · S/N MB-128 N5758VNelson Mike R · Philip, SDS/N MB-41 N5766VBruce James W · Searcy, ARBuilt 1966 · S/N MB-50 N5794VHand Timothy P · Osage Beach, MOBuilt 1966 · S/N MB-55 N5795VTech Specialty Services LLC · Killeen, TXBuilt 1966 · S/N MB-52 N5798VHarlow Daniel E · Spotsylvania, VABuilt 1966 · S/N MB-58 N5952SMaestro Aviation LLC · Anson, TXBuilt 1966 · S/N MB-62

Back to Beech A23-19