Skip to content

Registered aircraft · 145

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

N5137MFuture Pilots Of America Flight Academy LLC · Baxley, GABuilt 1978 · S/N MB-890 N5204MZenteno Nelson Jr · Winter Haven, FLBuilt 1978 · S/N MB-878 N52AAWebster Patrick Edward · Elk Grove, CABuilt 1975 · S/N MB-760 N546DKMcghee Billy H · Deland, FLS/N MB-616 N6010CBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-905 N6504RJohn M Peters · Damascus, MDBuilt 1974 · S/N MB-716 N6507RJoachim Peter · Grafton, WIBuilt 1974 · S/N MB-724 N6514RNess John A · Friday Harbor, WABuilt 1974 · S/N MB-711 N6538RFunnell John R · Cedar Park, TXBuilt 1974 · S/N MB-712 N6539RSpencer Alexander Joshua · North Las Vegas, NVS/N MB-713 N6553RRenkenberger Paul H · Yucaipa, CABuilt 1975 · S/N MB-744 N6560RBurgett William J · Juneau, AKBuilt 1974 · S/N MB-722 N6578RGrinnell Herbert W · Oroville, CABuilt 1974 · S/N MB-729 N6589RBradley Mark S · Holly, MIBuilt 1975 · S/N MB-731 N6594RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-718 N6595RBig Bend Community College · Moses Lake, WABuilt 1974 · S/N MB-714 N6602RFagundes Farms · Hanford, CABuilt 1974 · S/N MB-734 N6616RVanover Kevin · Whitesburg, KYS/N MB-736 N6651RZucha Joseph P · Rio Vista, CABuilt 1975 · S/N MB-742 N6659RGarn Darrell L · Palmetto, GABuilt 1974 · S/N MB-743 N687SSSciscoe William D · Dish, TXS/N MB-675 N727WMMd Air Ops LLC · High Springs, FLS/N MB-799 N7680RPotter Steven R · Grapevine, TXS/N MB-502 N7691RWestfall Brent J · Three Lakes, WIBuilt 1970 · S/N MB-487 N8064RN8064r LLC · Kalispell, MTBuilt 1970 · S/N MB-492 N819BABig Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-866 N88SWBoline Lonny R · Lincoln, MEBuilt 1970 · S/N MB-500 N8NDSmith Dane S · Berlin Heights, OHBuilt 1971 · S/N MB-514 N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787 N9161SCarr Jack Willson · East Lansing, MIBuilt 1975 · S/N MB-785 N9182SBig Bend Community College · Moses Lake, WABuilt 1975 · S/N MB-786 N9187SCarr Gary · Crestwood, ILBuilt 1976 · S/N MB-790 N9260SChristiansen Dee W · Kerrville, TXBuilt 1975 · S/N MB-781 N9287SDale Michael W · Clayton, NCS/N MB-758 N9302SLayden John M Jr · Moyock, NCS/N MB-763 N9344SScram Branden L · Fairbanks, AKBuilt 1975 · S/N MB-778 N9351SHauling Ag Inc · Middlebury, INBuilt 1975 · S/N MB-769 N9700LJet Aviation LLC · Commerce Township, MIBuilt 1971 · S/N MB-506 N9709QRobles Andres M · Plantation, FLBuilt 1970 · S/N MB-494 N9714LWebaire LLC · Slidell, LABuilt 1971 · S/N MB-510 N9718LStucky Verne L · Royal Oaks, CABuilt 1971 · S/N MB-511 N9725LLeading Edge Aviation LLC · Manchester, MOS/N MB-515 N9727LWiseman Holdings Group LLC · Clermont, FLBuilt 1971 · S/N MB-521 N9737LSzish Michael · Mountain Top, PABuilt 1972 · S/N MB-524 N9748QSchwanke Timothy Michael · Enid, OKBuilt 1971 · S/N MB-522

Back to Beech B19