Skip to content

Registered aircraft · 159

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

N798BVaughn Ken W · Fort Bragg, CAS/N D-1810 N8403ACrittenden William R · Dunwoody, GABuilt 1948 · S/N D-1815 N8410ABonanza Parts · Davis, CAS/N D-1847 N8412AZeien Robert A · Charlton, MAS/N D-1849 N8425AKeshishian Gregory · New York, NYBuilt 1948 · S/N D1862 N8430AMontgomery Patrick E · Auburn, NYBuilt 1948 · S/N D-1844 N8431ABas Part Sales LLC · Greeley, COBuilt 1948 · S/N D-1845 N8434AShepard Roger C · Aberdeen, WABuilt 1948 · S/N D-1850 N8440AWeller Donald R · Kathleen, GABuilt 1948 · S/N D-1846 N8452AHoward Jordan Stevens · Tioga, NDS/N D-1870 N8456ACrawford Larry G · California, MOS/N D-1874 N8461ALove Larry E · Greenbrier, ARBuilt 1949 · S/N D-2012 N8465AKeys James B · Oakwood, GABuilt 1948 · S/N D-1883 N8467ARegistration Pending · Tucson, AZRegistration pendingBuilt 1948 · S/N D-1885 N8478ABrice Staeheli · Saint Paul, MNS/N D-1898 N8482AEngelhart Mitchell S · Roswell, GABuilt 1948 · S/N D-1902 N8483AHeller Louis T · Reno, NVBuilt 1948 · S/N D-1903 N8490AUrquhart Dan DBA · Fallon, NVBuilt 1948 · S/N D-1910 N8497AHaynie Walter R · Brooklyn, IABuilt 1948 · S/N D-1919 N8501ARosanova Richard Shane · Flagstaff, AZBuilt 1948 · S/N D-1923 N8507ATidwell Jim O · Canton, GABuilt 1949 · S/N D1929 N8511ASipple Ronald W Jr · Gardner, KSBuilt 1949 · S/N D-1933 N8518ALapinel Marc P · Long Beach, NYS/N D-2018 N8519AMyers Travis · Bridgeport, WVBuilt 1949 · S/N D-2019 N8525AAuten Charles W III · Parker, COBuilt 1949 · S/N D-2023 N8531AChappie Michael R · Sidney, OHS/N D-1953 N8538AWeeks Stanley III · Taneyville, MOS/N D-1960 N8558AAerobanc Of America Inc · Camarillo, CABuilt 1949 · S/N D-1980 N8565AHendricks Allan T · Pearland, TXBuilt 1949 · S/N D-1987 N8571AWilliams Alan P · Bossier City, LABuilt 1949 · S/N D-1993 N8577ANissen Chris · Sandy, ORBuilt 1948 · S/N D-1999 N8578ABonanza Parts Inc · Davis, CABuilt 1949 · S/N D-2000 N8585AFervida Jeffrey B · Milford, INBuilt 1949 · S/N D-2007 N8588AAbbott R Barry · Tempe, AZBuilt 1949 · S/N D-2010 N8595ANorthshore Flyers · Houston, TXBuilt 1949 · S/N D-2033 N8602AHardcopf Robert W · Apple Valley, MNBuilt 1949 · S/N D-1989 N8605ADifferent Auto LLC · Twin Falls, IDBuilt 1948 · S/N D-1928 N8639ARegistration Pending · Sparta, MORegistration pending, pending cancellationBuilt 1949 · S/N D-2049 N8642AKrulic Charlie Bartol III · Greenville, SCBuilt 1949 · S/N D-2052 N8652AGnb Aviation LLC · Lake City, TNBuilt 1949 · S/N D-2062 N8654APicturesque Aviation LLC · Fort Worth, TXBuilt 1949 · S/N D-2064 N8657APierson Jeffrey L · Montague, MIBuilt 1949 · S/N D-2067 N8659ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1949 · S/N D-2069 N8662AAircraft Partner Holdings Inc Trustee · BerlinS/N D-2127 N8667AForthun Daniel Jay · Argyle, TXS/N D2129 N8669ARounds Chris · Waller, TXBuilt 1949 · S/N D-2079 N8681ACopeland Forrest H · Brentwood, CABuilt 1949 · S/N D-2091 N8692ACrouse Wayne A · Bernice, OKBuilt 1949 · S/N D-2200 N8700AJurskis Joseph S · Darien, GABuilt 1949 · S/N D-2110 N8708AMcilvenna John · Chandler, AZS/N D-2118

Back to Beech A35