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.

N100RFN100rf Ghost LLC · Burleson, TXS/N MB580 N1150ZLundin Ronny · Brewton, ALS/N MB-582 N156ASWallwork Robert R III · Wauna, WABuilt 1976 · S/N MB-805 N1790UHarris M A · Hartford, KSBuilt 1970 · S/N MB-486 N18775Chesley Boyd A · Cottonwood, AZS/N MB-846 N18888Symosko Stephen · Oakdale, PABuilt 1977 · S/N MB-858 N188BSSmith Brenda S · Livingston, TXBuilt 1977 · S/N MB-873 N18932Weber Brandon P · Otsego, MIBuilt 1977 · S/N MB-863 N18947Federer Joe E · Crane Hill, ALBuilt 1977 · S/N MB-864 N18956Hanig Kraig K · Merrill, WIBuilt 1977 · S/N MB-867 N18966Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-869 N18972Kroll Kenneth M · Counce, TNBuilt 1977 · S/N MB-868 N1914LDeakins Glenn F · Ringgold, GAS/N MB-803 N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794 N1920LAverill William B · Lacombe, LABuilt 1976 · S/N MB-792 N1920WWilfert Frederick · Springfield, VABuilt 1973 · S/N MB-579 N1926WSengstock Frank W · Traverse City, MIBuilt 1973 · S/N MB-587 N1927LCarrillo Isaias D · Wasilla, AKBuilt 1976 · S/N MB-796 N1927WAltitude Aviation Services LLC · Mountain Home, IDBuilt 1973 · S/N MB-609 N1931WDelgado Alan J · Auburn, GABuilt 1973 · S/N MB-589 N1933WHanson Garrick D · Clayton, NCS/N MB-597 N1935LBlais Aviation Services LLC · Frisco, TXBuilt 1976 · S/N MB-797 N1936WDelgatto Robert G · Bellingham, WAS/N MB-599 N1937WMcculloch Jordan · Enfield, CTBuilt 1973 · S/N MB-600 N1945WHunhoff Mark B · Yankton, SDBuilt 1973 · S/N MB-603 N1950WLight Sport And Beyond LLC · Carville, LABuilt 1973 · S/N MB-612 N1951WHoover Ryan B · Le Claire, IABuilt 1973 · S/N MB-615 N1955WLakeview Farm Foundation Corp · Yukon, OKBuilt 1973 · S/N MB-619 N1956WGasaway Chad D · Middleton, IDS/N MB-620 N1961WMeier Monte M · Grove, OKS/N MB-624 N1963WHuertas Andrew C · Tujunga, CABuilt 1973 · S/N MB-627 N1966WSale Reported · Southaven, MSSale reportedS/N MB-630 N1967WNovotny Andrew T · Los Angeles, CABuilt 1974 · S/N MB-656 N1974WObannon Michael Verlin · Apple Valley, CAS/N MB-633 N1979WLeedom David · Center Point, IAS/N MB-658 N1987LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-806 N1987WWood Wilbur L · Alachua, FLBuilt 1974 · S/N MB-663 N1990WObsidian Defense LLC · Tampa, FLBuilt 1974 · S/N MB-668 N1991WGmm Records Inc · Big Pine Key, FLBuilt 1974 · S/N MB-673 N1992WMcdonald Gregory S · Mena, ARS/N MB-657 N1996WMelton Joshua D · Mitchell, INBuilt 1974 · S/N MB-677 N19NHLaquadra Gregory John · North Liberty, IABuilt 1975 · S/N MB-740 N19NTHall Karl A · Colorado Springs, COBuilt 1974 · S/N MB-710 N2012KMaine Instrument Flight · Augusta, MEBuilt 1978 · S/N MB-901 N2013AMusketeer LLC · Fayette, ALBuilt 1978 · S/N MB-902 N2047ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-899 N2048ABig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-904 N2053LMaine Instrument Flight · Augusta, MEBuilt 1976 · S/N MB-812 N2059LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-808 N2063LPeterson Eric T · Port Townsend, WABuilt 1976 · S/N MB-809

Back to Beech B19