Skip to content

Registered aircraft · 425

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

N101JMSale Reported · Clay Center, KSSale reportedBuilt 1967 · S/N D-8459 N109QShariff Diane · Cameron Park, CABuilt 1966 · S/N D-8126 N110CCIntermountain Aero Inc · Salt Lake City, UTBuilt 1966 · S/N D-8339 N111ECGs Wings Inc · Pawnee, ILBuilt 1967 · S/N D-8385 N111MSMid America Sprayers Inc · Johnson, KSBuilt 1966 · S/N D-8249 N112XAir Corriente LLC · Columbia, TNBuilt 1966 · S/N D-8121 N1130MTelbo LLC · Vonore, TNBuilt 1965 · S/N D-8023 N113JLHare Richard C · Northville, MIBuilt 1966 · S/N D-8167 N113XClement James G · Cresson, TXBuilt 1966 · S/N D-8112 N118VSmith Gregg W · Lake Jackson, TXBuilt 1966 · S/N D-8096 N119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNBuilt 1966 · S/N D-8231 N11HTJet X Leasing Inc · Johnson, KSBuilt 1967 · S/N D-8534 N11RTBraly And Braly Pc · Ada, OKBuilt 1967 · S/N D-8420 N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276 N123CTPastor Jordan D · Riverside, CABuilt 1967 · S/N D-8590 N126HBockman Ltd · Milford, IABuilt 1967 · S/N D-8544 N129XSwarts Robert · Cincinnati, OHBuilt 1967 · S/N D-8586 N135JAD & K Aviation Inc · Milford, IABuilt 1967 · S/N D-8478 N135WWKarwowski Richard · Battle Ground, WAS/N D-8129 N136GBHarris Vincent A · Columbus, MSBuilt 1967 · S/N D-8557 N1417BDavis Brad Michael · Whitesboro, TXBuilt 1967 · S/N D-8550 N141WSCopper Spike Aero LLC · Douglas, WYBuilt 1965 · S/N D-7995 N144RExtrivo Inc · Lewes, DEBuilt 1967 · S/N D-8496 N147UMartin Delano R · Spring, TXS/N D-8533 N148PRJaspar Dorsey E · Bakersfield, CABuilt 1967 · S/N D-8580 N148UUpmeyer Matthew D · Richland, WABuilt 1967 · S/N D-8437 N149GMetro Flyers Ltd · N Richland Hills, TXBuilt 1966 · S/N D-8100 N1500FGerhold Jeremy · Rosharon, TXS/N D-8552 N1520VBerka George · Wilmington, DES/N D-8159 N152JPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1966 · S/N D8322 N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472 N170MWilliams John R Jr · Marfa, TXBuilt 1966 · S/N D-8317 N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259 N179KDTblc LLC · Princeton, NJBuilt 1967 · S/N D-8519 N17CBCygnet Aerospace Corp · Los Osos, CABuilt 1966 · S/N D-8232 N1897EThompson Loren Charles · Arlington, VABuilt 1966 · S/N D-8313 N18TUCheck Seven LLC · Champaign, ILBuilt 1967 · S/N D-8450 N18WPPacker William M · Orchard Lake, MIBuilt 1966 · S/N D-8125 N191YPlatte Valley Air LLC · Columbus, NEBuilt 1966 · S/N D-8172 N194NASharrit Edgar W · Sebring, FLS/N D-8409 N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173 N1QGLos Arboles Management Company LLC · Moriarty, NMBuilt 1966 · S/N D-8328 N2001BBangert Computer Systems Inc · Shawnee, KSBuilt 1966 · S/N D-8216 N2002WWilliams Howard Dale II · Oklahoma City, OKBuilt 1965 · S/N D-7988 N2008WSiamese Cat LLC · Issaquah, WABuilt 1965 · S/N D-7977 N2016DRbc Aero · Mooresville, NCBuilt 1966 · S/N D-8209 N201JHSpero Alan J · Ramona, CABuilt 1966 · S/N D-8113 N2020WMidland Mist Inc · Midland, GABuilt 1966 · S/N D-8077 N2024WMunn Jeffrey R · Auburn, NYBuilt 1966 · S/N D-8078 N2037WGregs Crop Care Co · Wilbur, WABuilt 1965 · S/N D-7980

Back to Beech V35