Skip to content

Registered aircraft · 913

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

N9158QBurton John H III · Woodstock, ILBuilt 1970 · S/N D-9217 N9171QBeech Babe Ltd · Colorado Springs, COBuilt 1970 · S/N D-9246 N917SDTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1977 · S/N D-9988 N919TPWarren Jason J · Silverdale, WABuilt 1977 · S/N D-10068 N91JPJackson Gerald M · Lake City, MIBuilt 1975 · S/N D-9810 N91KMj Aviation Inc · Custer, SDBuilt 1975 · S/N D-9764 N9216QOsage Aviation LLC · Yates Center, KSBuilt 1971 · S/N D-9268 N9219QMedia Exp LLC · Portland, ORBuilt 1971 · S/N D-9265 N921MKCognito Design Inc · Punta Gorda, FLS/N D-9321 N9221QPhelan Raymond F · Portland, ORBuilt 1971 · S/N D-9264 N9233QMid America Aviation LLC · Wilmington, DEBuilt 1971 · S/N D-9274 N9242QSample Donald L · Houston, TXBuilt 1970 · S/N D-9242 N9243QFlegler Barry Bronson · Eagle, MIBuilt 1970 · S/N D-9243 N924VBauman Ronald L · Stuttgart, ARBuilt 1974 · S/N D-9702 N9253QN9253q LLC · Goldsby, OKBuilt 1971 · S/N D-9253 N925MVan Wylen Mary F · Grand Rapids, MIBuilt 1973 · S/N D-9474 N927DCCiruli David E · Lafayette, CABuilt 1976 · S/N D-9855 N927JBAirgroup Express LLC · Santa Rosa, CABuilt 1980 · S/N D-10345 N927MWStrauss Michael · Ormond Beach, FLBuilt 1973 · S/N D-9546 N9287QElarel Corporation · Lewes, DEBuilt 1971 · S/N D-9287 N9289QCoutu Bobby L · Plano, TXBuilt 1971 · S/N D-9289 N9293QChalk 2 Inc · Apple Valley, CABuilt 1971 · S/N D-9293 N9296QReichert Aviation Enterprises LLC · El Cajon, CABuilt 1971 · S/N D-9294 N9304QK Factor Aircraft Corp · Jupiter, FLBuilt 1971 · S/N D-9296 N9309QBehrent Carl D · Granbury, TXBuilt 1971 · S/N D-9295 N9343QMorris Mark · Jasper, GABuilt 1971 · S/N D-9304 N934VFinke Wailes · Charleston, MSBuilt 1975 · S/N D-9739 N9371QAshe Industries LLC · Murrieta, CABuilt 1972 · S/N D-9309 N93VTLidner Mark H · Sun City, AZBuilt 1970 · S/N D-9155 N9400QPrealow Scottie T · Lubbock, TXBuilt 1970 · S/N D-9163 N9430QHoyt Stuart T · Raleigh, NCBuilt 1972 · S/N D-9316 N9440QKatz Alan E · Hopkinton, MABuilt 1972 · S/N D-9319 N9461QRose Kim N · East Wenatchee, WABuilt 1972 · S/N D-9322 N9463QCcf Ventures Inc · Bangor, MEBuilt 1972 · S/N D-9324 N9465QMaydew Aircraft LLC · Dallas, TXBuilt 1972 · S/N D-9325 N9470QCullison James B Trustee · Canby, ORBuilt 1972 · S/N D-9327 N947TTobler Patrick M · Wake Forest, NCBuilt 1971 · S/N D-9270 N9483QSouthwest Investment Co · Little Rock, ARS/N D-9331 N9487QLebarron David · Winnsboro, TXBuilt 1972 · S/N D-9333 N950CAZero Charlie Alpha LLC · Mountain View, CABuilt 1974 · S/N D-9667 N950MCL C Cattle Inc · Garden City, KSBuilt 1978 · S/N D-10171 N951MMChambers Wilbert Wayne Jr · Burlington, NCBuilt 1974 · S/N D-9707 N956VParker Aerospace LLC · Warren, VTBuilt 1975 · S/N D-9817 N95DBBlankenbeker Edward D · Fernandina Beach, FLBuilt 1979 · S/N D-10239 N96WRegistered aircraftBuilt 1971 · S/N D-9269 N9750CJv Aviation LLC · Johnston, RIBuilt 1973 · S/N D-9469 N975QCYoung Billy G · Livingston, TXBuilt 1970 · S/N D-9114 N975RMclane Norman B · Mesa, AZBuilt 1979 · S/N D-10276 N976DSFisher Samuel J · Nahant, MABuilt 1976 · S/N D-9931 N98LKMb Duncan Inc · Bakersfield, CABuilt 1977 · S/N D-10027

Back to Beech V35B