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.

N1919DWarren Wesley L · Coeur D Alene, IDBuilt 1952 · S/N D-3191 N1920DHunt James W · Maryville, TNBuilt 1952 · S/N D-3192 N1921DBrickhouse Aviation LLC · Franklin, TNS/N D-3193 N1926DKoosmann Mark R · Corcoran, MNBuilt 1956 · S/N D-3198 N1927DHawksworth Jeff · Laveen, AZS/N D-3199 N1930DFletcher Ellexis L · Corpus Christi, TXBuilt 1952 · S/N D-3203 N1935DCoppage Walter J · Wichita Falls, TXBuilt 1952 · S/N D-3209 N1938DPlane Crazy Aviation LLC · Hickory, NCBuilt 1952 · S/N D-3214 N1942DFrancis David L · Fort Worth, TXBuilt 1952 · S/N D-3219 N1943DHartman Dylan · Avon, INBuilt 1952 · S/N D-3221 N1948DDuncan Rodney P · Las Vegas, NVBuilt 1952 · S/N D-3227 N1953DFox Christopher R · Modesto, CAS/N D-3233 N1954DMontes Muriel E · Edgewood, NMBuilt 1952 · S/N D-3234 N1957DLiggenstoffer Buddy L · Kiowa, KSBuilt 1952 · S/N D-3238 N1966DKing Kevin L · Anaheim, CABuilt 1952 · S/N D-3249 N1975DAlsworth Cinimin Sea · Anchorage, AKBuilt 1952 · S/N D-3172 N1976DRobertson William Jr · Powell, TNBuilt 1956 · S/N D-3190 N1978DRegistration Pending · Knoxville, TNRegistration pendingBuilt 1952 · S/N D-3177 N1979DRoberts Lawrence A Trustee · Fishersville, VABuilt 1952 · S/N D-3200 N1984DFoster Buell M · Yucca Valley, CABuilt 1952 · S/N D-3215 N1986DWolfe Thomas V · Mountain Lakes, NJBuilt 1952 · S/N D-3220 N1991DCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1952 · S/N D-3250 N1993DSale Reported · Summer Shade, KYSale reportedBuilt 1952 · S/N D-3256 N1995DAment Robert · Merritt Island, FLBuilt 1952 · S/N D-3265 N1998DLundberg Cole M · Junction City, WIBuilt 1952 · S/N D-3263 N1PVMuzny Gregory · Magnolia, TXS/N D-3028 N2001DOn The Roll Aviation LLC · Vail, AZBuilt 1952 · S/N D-3351 N2005DT&H LLC · Cottage Grove, ORBuilt 1952 · S/N D-3355 N2006DGraham Richard W · Rohnert Park, CABuilt 1952 · S/N D-3356 N2007DHayes Donald · Mcloud, OKS/N D-3357 N2008DDrevalas George · Bandon, ORBuilt 1952 · S/N D-3358 N2011DGardner Robert J · Reno, NVBuilt 1952 · S/N D-3361 N2015DAv8rs LLC · Portland, ORBuilt 1952 · S/N D-3366 N2017DCream Puff Classics Inc · Hubertus, WIBuilt 1952 · S/N D-3368 N2020DPearson Martha A · Walnut Grove, CABuilt 1952 · S/N D-3371 N2021DDockter Travis R · Linton, NDS/N D-3372 N2026DToro Miguel Angel · San Ysidro, CABuilt 1952 · S/N D-3377 N2032DCochran Douglas B · La Jolla, CAS/N D-3383 N2034DMcpartland Patrick R · Herriman, UTBuilt 1952 · S/N D-3385 N2035DKnoxville Airventure LLC · Knoxville, TNBuilt 1952 · S/N D-3386 N2041DLyman Eric J · Upland, CABuilt 1952 · S/N D-3393 N2055DRegistration Pending · Alvaton, KYRegistration pending, pending cancellationBuilt 1952 · S/N D-3398 N2056DBickert Marshal A · Springfield, VABuilt 1953 · S/N D-3399 N2199KRegistered aircraftBuilt 1951 · S/N D-2941 N21RCChristopherson Robert J · Provo, UTBuilt 1951 · S/N D-2789 N222ZBonanza Parts Inc · Davis, CABuilt 1951 · S/N D-2732 N243HEason Michael P · Murfreesboro, TNBuilt 1952 · S/N D-3272 N244LAcevedo Jesus · North Branford, CTS/N D-2747 N262DHansen Nicholas R · Dayton, MTS/N D-3024 N2860WTalbot Tad W · Danville, CABuilt 1951 · S/N D-2859

Back to Beech C35