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.

N206TVHpfm Inc · Vermillion, SDBuilt 1974 · S/N MB-660 N2157WTreatman Chad J · Las Vegas, NVBuilt 1974 · S/N MB-680 N2164WRegistration Pending · Carson City, NVRegistration pending, pending cancellationBuilt 1974 · S/N MB-682 N2167WRasmussen Anthony Paul · Gilbertsville, KYBuilt 1974 · S/N MB-685 N2168WMaine Instrument Flight Inc · Augusta, MEBuilt 1974 · S/N MB-659 N2171WBrown Gerado S · Miramar, FLBuilt 1974 · S/N MB-688 N2185WHoward Pamela A · Goldthwaite, TXBuilt 1974 · S/N MB-696 N2191WNorton Daniel J · Osage City, KSBuilt 1974 · S/N MB-727 N2197WSmothers Edward Jr · Owasso, OKBuilt 1974 · S/N MB-697 N2218LEldib Ramsey C · Malibu, CAS/N MB-817 N2232LDodson Jack Yii · Douglasville, GABuilt 1976 · S/N MB-819 N2239LGoss Andrew M · Clio, MIBuilt 1976 · S/N MB-821 N2245LShirley Joseph P · Branson West, MOS/N MB-823 N22711Big Bend Community College · Moses Lake, WABuilt 1977 · S/N MB-865 N23859Fu Jinlin · Olympia, WABuilt 1976 · S/N MB-811 N23963Flanegan Charles E Jr · Jonesboro, GABuilt 1977 · S/N MB-827 N23982Maine Instrument Flight · Augusta, MES/N MB-831 N24006Keiper Mark D · Spring, TXBuilt 1977 · S/N MB-835 N24020Maine Instrument Flight · Augusta, MEBuilt 1977 · S/N MB-838 N24025Birx Ethan S · Piedmont, SCBuilt 1977 · S/N MB-839 N24029Bindas Ronald · Georgetown, TXBuilt 1977 · S/N MB-840 N24590Nice Flying LLC · Williamsburg, VABuilt 1972 · S/N MB-546 N24595Baisch Troy W · Oceanside, CABuilt 1972 · S/N MB-542 N24597Smoketown Flight Center LLC · Smoketown, PABuilt 1972 · S/N MB-549 N245MJMaensivu Maverick Juha · Apopka, FLS/N MB 814 N24600League Zachary E · Carter, OKBuilt 1972 · S/N MB-543 N24602Mcclain Alex · Camdenton, MOBuilt 1972 · S/N MB-551 N24605Deakins Glenn F · Ringgold, GAS/N MB-553 N24618Borges Joe A · Highland, CABuilt 1972 · S/N MB-557 N24645Kangas Matthew W · Covington, WABuilt 1973 · S/N MB-564 N24646Kosko Stanley G · Seattle, WABuilt 1973 · S/N MB-561 N24653Phillips Alan K · Junction City, ORBuilt 1973 · S/N MB-570 N24660Arey Dale W · Laramie, WYBuilt 1973 · S/N MB-565 N24679No Limits Aviation Inc · Hayden, IDBuilt 1973 · S/N MB-576 N282LBuccaneer LLC · Naperville, ILBuilt 1974 · S/N MB-700 N4344MBales Jeffrey M · Greendale, WIBuilt 1974 · S/N MB-672 N4358WSun Flyers LLC · Orlando, FLBuilt 1974 · S/N MB-702 N4359WJohnson Lonnie B · Provo, UTBuilt 1974 · S/N MB-684 N4506MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-881 N5012MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-882 N5032MLet There Be Flight LLC · Portage, MIBuilt 1978 · S/N MB-896 N5040MHulme Aviation LLC · Gilbert, AZBuilt 1978 · S/N MB-895 N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891 N50TMRegistration Pending · Williamson, WVRegistration pendingBuilt 1972 · S/N MB-552 N5101RVan Steenis William W · Boulder City, NVS/N MB-788 N5105RSale Reported · Colville, WASale reportedBuilt 1974 · S/N MB-639 N5106RBenson Robert W · Wichita Falls, TXS/N MB-640 N5111RAlpine Aviation LLC · Oasis, IDBuilt 1974 · S/N MB-645 N5113RHamaker Nevada C · Bothell, WABuilt 1974 · S/N MB-647 N5114RHayden Steven E · Westminster, COBuilt 1974 · S/N MB-648

Back to Beech B19