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.

N789RGBonanza N789rg LLC · Oro Valley, AZBuilt 1973 · S/N D-9483 N78KKJim Heck Investments LLC · Findlay, OHBuilt 1977 · S/N D-10075 N78RSSkorpiks Inc · Tyndall, SDBuilt 1980 · S/N D-10360 N78WHDel Rosi Anthony J · Key Largo, FLBuilt 1978 · S/N D-10145 N793LMJohnson Roger C · Lake Havasu City, AZBuilt 1979 · S/N D-10300 N79PRHutchinson Andrew J · Gardner, KSBuilt 1970 · S/N D-9138 N7KTOrtiz Alexander · Walnut Creek, CABuilt 1979 · S/N D-10268 N7PKBohn Robert D Jr · Midway, GABuilt 1974 · S/N D-9608 N800EEMarks Robin · San Luis Obispo, CABuilt 1979 · S/N D-10288 N803DLRapids Ruddervators LLC · Wisconsin Rapids, WIBuilt 1973 · S/N D-9448 N809TTsr Aviation Inc · Rochester, MNBuilt 1973 · S/N D-9460 N80DFBeadazzled LLC · Holland, MIBuilt 1976 · S/N D-9982 N8105RBuckley Timothy L · Zionsville, INBuilt 1969 · S/N D-9089 N8119RCarona Robert A Jr Trustee · Oceanside, CABuilt 1974 · S/N D-9655 N8135RKeyt Richard C · Granbury, TXBuilt 1974 · S/N D-9696 N8137RWestdale Aviation LLC · Shreveport, LABuilt 1974 · S/N D-9660 N813CHBlech Andreas J · Grants Pass, ORBuilt 1973 · S/N D-9536 N8158RFullerton Vtail Partners LLC · Mission Viejo, CABuilt 1974 · S/N D-9665 N8166RJmac Aviation Services LLC · Andalusia, ALBuilt 1974 · S/N D-9666 N8169RPreister Properties LLC · Norfolk, NEBuilt 1974 · S/N D-9668 N816UMcmullen Gerald W Trustee · Spokane, WABuilt 1970 · S/N D-9161 N816VBrawler Aviation LLC · Edmond, OKBuilt 1971 · S/N D-9266 N8171RYankee Air Pirate LLC · Memphis, TNBuilt 1974 · S/N D-9669 N8183RFerriolo Donald J · Greer, SCBuilt 1974 · S/N D-9671 N8187RFleck Richard N Trustee · Camarillo, CABuilt 1974 · S/N D-9673 N8191RM B Duncan Inc · Bakersfield, CABuilt 1974 · S/N D-9675 N819BRooney William T · Lakin, KSBuilt 1978 · S/N D-10186 N819T3rd Gen Aviation LLC · Lisbon, NDBuilt 1973 · S/N D-9507 N81VBNeal Foster Trucking Inc · Merrill, ORBuilt 1980 · S/N D-10315 N81VTDouble D Aircraft LLC · Sergeant Bluff, IABuilt 1974 · S/N D-9640 N822TMarburger James H · Phoenix, AZBuilt 1973 · S/N D-9513 N823TKnight Koby Ernest · Haslet, TXS/N D-9521 N823VUsher James C · Fort Worth, TXBuilt 1976 · S/N D-9872 N826RSSpence Charles A · Midland, TXBuilt 1971 · S/N D-9272 N826TBonanza H35 LLC · Greensboro, NCBuilt 1973 · S/N D-9518 N826VMills Aviation Ltd · Wapakoneta, OHBuilt 1977 · S/N D-9950 N82HCVan Buskirk Steven · Denver, COBuilt 1974 · S/N D-9584 N843TClifford Brent N · Lubbock, TXBuilt 1973 · S/N D-9482 N844CSSchmidt Clifford W · Jackson, MIBuilt 1970 · S/N D-9247 N8498AAllen Scott C · Mcminnville, ORBuilt 1970 · S/N D-9237 N84DSankofa Air LLC · Wilmington, DEBuilt 1978 · S/N D-10109 N84FBJohnson David P · Sycamore, ILBuilt 1977 · S/N D-10059 N84KN84k LLC · The Dalles, ORBuilt 1977 · S/N D-10067 N850TWisdom John D · Mineola, TXBuilt 1972 · S/N D-9367 N853Cameo Marketing Inc · Ellsworth, MES/N D-9888 N853THumphrey Daniel P · Sausalito, CABuilt 1974 · S/N D-9630 N8566RSouthwest Fresh Potato LLC · Hugoton, KSBuilt 1974 · S/N D-9684 N86TEBowers Stephen W · Richland, MIS/N D-10342 N879MCJ P IV LLC · Hickory, NCBuilt 1977 · S/N D-10008 N888DBEastern Stearman Inc Trustee · Leesburg, VAS/N D10076

Back to Beech V35B