Skip to content

Registered aircraft · 225

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

N9579RSotax Inc · Tacoma, WABuilt 1959 · S/N D-6176 N9580RHershberger Daniel S · Bedford, INBuilt 1959 · S/N D-6178 N9583RVtaildoc LLC · Venice, FLBuilt 1959 · S/N D-6180 N9586RCarter James L · Mesa, AZBuilt 1959 · S/N D-6182 N9587RJetset LLC · Edmonds, WABuilt 1959 · S/N D-6186 N9592RHall James H · Discovery Bay, CABuilt 1959 · S/N D-6177 N9593RWard David C · Painted Post, NYBuilt 1959 · S/N D-6202 N9596RFournier Louis Wilfred Jr · Lynn Haven, FLBuilt 1959 · S/N D-6190 N9597RWise Eric · Enon, OHBuilt 1959 · S/N D-6191 N9598RMcdonald James S · Yorba Linda, CABuilt 1959 · S/N D-6274 N9599RFry Larry D DBA · Ocala, FLBuilt 1959 · S/N D-6206 N960DMMcwilliams Michael D · Conroe, TXS/N D-6543 N9622RGordon Casey · Los Angeles, CABuilt 1960 · S/N D-6461 N96MCW Patrick Enterprises Inc · Wilmington, DEBuilt 1960 · S/N D-6555 N9704RPrewitt Scott S · King City, CABuilt 1959 · S/N D-6262 N9706RParrish Michael W · Granbury, TXBuilt 1959 · S/N D-6249 N9708RGaberdiel Jeffrey M · Lake Butler, FLBuilt 1960 · S/N D-6269 N9709RVance Marc G · Canal Winchester, OHBuilt 1959 · S/N D-6263 N9712RFenoglid John A II · Florence, TXBuilt 1959 · S/N D-6259 N9714RMichael Dunlevie Pc · Eagle, COBuilt 1959 · S/N D-6266 N9716RTracy Scott J · Santa Barbara, CABuilt 1960 · S/N D-6288 N9717RSale Reported · Lenoir City, TNSale reportedBuilt 1960 · S/N D-6395 N9719RHughes Alan J · Edison, OHBuilt 1960 · S/N D-6296 N9721RDeland Air And Sea Brokerage Inc · Deland, FLS/N D-6192 N9724RFinley Trevor S · Caddo Mills, TXBuilt 1959 · S/N D-6196 N9732RPfau Michael G · Princeton, MNBuilt 1959 · S/N D-6211 N9734RAces Hangar LLC · Bentonville, ARBuilt 1959 · S/N D-6213 N9736RGet Happy Adventures LLC · Leawood, KSBuilt 1959 · S/N D-6203 N9738RNathan Price · Crawfordsville, INBuilt 1959 · S/N D-6217 N9739RKinkade John T · Gallatin, TNBuilt 1959 · S/N D-6218 N9740RTonge Gregory Charles · Wenatchee, WABuilt 1959 · S/N D-6219 N9741RDoble Michael P · Waukesha, WIBuilt 1959 · S/N D-6220 N9745RBykerk John C · Springfield, ORS/N D-6226 N9747RAmundson James Robert · South Lake Tahoe, CAS/N D-6228 N9748RVinson Lonnie Eugene Jr · Oceanside, CABuilt 1959 · S/N D-6229 N9750RMiletta Anthony · Beloit, OHS/N D-6232 N9752RChristensen Craig H · Webster, MNBuilt 1959 · S/N D-6240 N9753RMasterson James Patrick · Aptos, CAS/N D-6241 N9754RStrojny Andrew P Jr · Strongsville, OHBuilt 1959 · S/N D-6248 N9755RSalisbury Ronald · Newport Beach, CABuilt 1959 · S/N D-6250 N9756REstes Aviation LLC · Vicksburg, MSBuilt 1959 · S/N D-6251 N9757RVan Noy Stephen E · Alliance, NEBuilt 1960 · S/N D-6286 N9758RTurner Richard Walser Trustee · Rocky Gap, VABuilt 1960 · S/N D-6304 N9759RSanders Kenneth E · Millsap, TXBuilt 1959 · S/N D-6238 N9763RSpencer Eric M · Glenrock, WYBuilt 1960 · S/N D-6305 N9764RSchaffert Warren E · Trenton, NES/N D-6247 N9765RHathorn Luther G · Corsicana, TXBuilt 1959 · S/N D-6243 N9767RRowell Jerome F · Winchester, VABuilt 1959 · S/N D-6254 N9768RGeorge Raymond R · Shadow Hills, CABuilt 1959 · S/N D-6244 N9770RSmith Francis K · Saint Inigoes, MDBuilt 1960 · S/N D-6285

Back to Beech M35