Skip to content

Registered aircraft · 41

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

N101FDLakala Aviation Inc · Vicksburg, MIS/N MB-417 N117DMApplied Professional Solutions Llp · Jacksonville, FLBuilt 1968 · S/N MB-381 N16727Armstrong Bernard A · Cerrillos, NMBuilt 1969 · S/N MB-444 N16BDLambert Thomas E · Roland, IABuilt 1969 · S/N MB-456 N17BWLoeffler Helmut Guenter · Prattsburgh, NYBuilt 1968 · S/N MB-344 N18BWFarris Fred · Gladstone, MOBuilt 1969 · S/N MB-431 N2127UFox Robert H · Wyandotte, MIBuilt 1969 · S/N MB-447 N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343 N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346 N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347 N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378 N6066NPacific Union College · Angwin, CABuilt 1968 · S/N MB-398 N6067NGustavson Allan R Jr · Tonopah, AZBuilt 1968 · S/N MB-391 N6068NVan Steenburgh Owen Christopher · Manitowoc, WIBuilt 1968 · S/N MB-392 N606ERHansen Justin L · St George, UTS/N MB-397 N6098NRegistered aircraftBuilt 1968 · S/N MB-395 N6123NPfisters Flying Wahine · Waialua, HIBuilt 1969 · S/N MB-409 N6124NPacific Coast Air Museum · Santa Rosa, CABuilt 1968 · S/N MB-410 N6143NTorikawa Domingojason K · Ewa Beach, HIBuilt 1969 · S/N MB-414 N6144NRegistration Pending · Benton, ARRegistration pendingS/N MB-415 N6510TLenkersdorfer John D · Burley, IDS/N MB-350 N6511TAgricola Joseph D · Brooksville, FLBuilt 1968 · S/N MB-354 N6513TReilly Michael G · Somerset, NJBuilt 1968 · S/N MB-355 N6519TVeverka Merle G · Frederick, COBuilt 1968 · S/N MB-356 N6527TBaugher Mark A · Harrison, MIS/N MB-359 N6535TDobson Richard W · Phenix City, ALBuilt 1968 · S/N MB-360 N6544TCourtney John T · Woodbridge, CTBuilt 1968 · S/N MB-365 N6584TCaufman Richard D · Corry, PAS/N MB-369 N6961QReed Billy B · Cabool, MOBuilt 1968 · S/N MB-316 N6970QWalker Joshua D · Denison, TXBuilt 1968 · S/N MB-317 N6971QRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1968 · S/N MB-318 N6977QAnderson Gary D · Mechanicsville, MDBuilt 1968 · S/N MB-325 N6979QShlomo Yaron · Honolulu, HIBuilt 1969 · S/N MB-403 N6980QHulme Aviation LLC · Gilbert, AZBuilt 1968 · S/N MB-404 N6987QSmith Casey W · Houlka, MSBuilt 1968 · S/N MB-336 N7641RDossey Kevin L · Oroville, CABuilt 1969 · S/N MB-432 N7648RJohnson Jerome L · Victorville, CABuilt 1969 · S/N MB-457 N7682RTrull Stephen G · Golden Valley, MNBuilt 1969 · S/N MB-452 N781JBKilgus Christopher R · Felton, CABuilt 1968 · S/N MB-405 N9107TVaughan Lee E Jr · Philip, SDBuilt 1968 · S/N MB-377 N9114TFlying Frog Aviation LLC · Palm City, FLBuilt 1969 · S/N MB-401

Back to Beech 19A