Skip to content

Registered aircraft · 258

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

N316BMPrice John DBA · Bennington, KSS/N D-3268 N3456GLawson Michael · Athens, TNBuilt 1952 · S/N D-3195 N354ZFlorida Keys Aviation Service & Leasing LLC · Key Largo, FLBuilt 1952 · S/N D-3287 N357TSSmith Thomas W · Enid, OKBuilt 1951 · S/N D-2785 N35STHess Hendrix · New York, NYBuilt 1951 · S/N D-2936 N361Anderson G Drew · Kent, WABuilt 1952 · S/N D-3202 N388GBInternational Air Services Inc Trustee · Carson City, NVBuilt 1951 · S/N D-2761 N41XEMedic Choppers LLC · Springdale, ARS/N D-2871 N426RWolff Phillip R · Highlands Ranch, COBuilt 1952 · S/N D-3188 N42XRegistration Pending · Grandfield, OKRegistration pendingBuilt 1951 · S/N D-2825 N44AWMorrison Charles W · Huntington, TXBuilt 1952 · S/N D-3228 N45XEnglish Gary M · Clermont, FLBuilt 1952 · S/N D-3060 N461Lindeman Rusty · D Hanis, TXBuilt 1952 · S/N D-3378 N480RBMace William L · Queen Creek, AZS/N D-3237 N4951VBranam John R · Clinton, TNBuilt 1952 · S/N D-3197 N49WPWilkinson Graham · Camano Island, WAS/N D-2725 N4EVSchlueter Gerald C · Lincoln, CABuilt 1952 · S/N D-3302 N5050XGrevatt Douglas E · Norwalk, CTBuilt 1952 · S/N D-3150 N5298CCheshire Derek L · Mercer Island, WABuilt 1951 · S/N D-2682 N55BDMclenaghan Alvin N · Phoenix, AZBuilt 1952 · S/N D-3156 N5802CRackham Alan Scott · Foresthill, CABuilt 1951 · S/N D-2754 N5806CPasztalaniec Matt · Monterey, CABuilt 1951 · S/N D-2758 N5808CDeasy John F Jr · Doylestown, PABuilt 1951 · S/N D-2760 N5812CJanzen Larry L · Lakeland, FLBuilt 1951 · S/N D-2764 N5814CMag Aviation Fuel · Flagstaff, AZS/N D-2827 N5818CSwartz William R · Alto, MIS/N D-2770 N5821CMilazzo Air LLC · North Adams, MAS/N D-2773 N5828CTubens Robert N · Benton City, WABuilt 1951 · S/N D-2780 N5829CYore Victor N · Chase City, VABuilt 1951 · S/N D-2828 N5834CRainey Chris D · Justin, TXBuilt 1951 · S/N D-2786 N5836CCohen Barry M · Streetman, TXBuilt 1952 · S/N D-2788 N5838CRiley Daniel B · Valparaiso, INBuilt 1951 · S/N D-2790 N5839CDepew Gerald R · Oak Ridge, TNBuilt 1951 · S/N D-2829 N5846CDangberg Dennis · Wayne, NEBuilt 1951 · S/N D-2798 N5848CRochna Stephen John · Fallon, NVBuilt 1951 · S/N D-2800 N5865CMacdonald Kaitlyn A · Dillon, MTBuilt 1951 · S/N D-2817 N5879CSkeen Nikki B · Redlands, CABuilt 1951 · S/N D-2835 N5889CHoye Charlie L · Rimrock, AZBuilt 1957 · S/N D-2840 N5890CHumphrey Gary L · Lake Havasu City, AZBuilt 1951 · S/N D-2842 N5892CPeter Jesse D · Glendive, MTBuilt 1951 · S/N D-2844 N5896CVeal Thomas H · Cocoa Beach, FLS/N D-2849 N5900CKaufmann Landry V · Gamaliel, KYBuilt 1951 · S/N D-2854 N5903CCollins John P · El Cajon, CAS/N D-3273 N5907CN5907c LLC · Fairhope, ALBuilt 1952 · S/N D-3290 N5908CAircorps Aviation LLC · Bemidji, MNBuilt 1952 · S/N D-3267 N5917CVierra David R · Chaska, MNBuilt 1952 · S/N D-3277 N5921CRegistered aircraftS/N D-3281 N5924CJuneau Greg L · Shreveport, LAS/N D-3283 N5925CBrickey William C · Morrilton, ARBuilt 1952 · S/N D-3284 N5926CCase Robert M · Poulsbo, WABuilt 1952 · S/N D-3285

Back to Beech C35