Skip to content

Registered aircraft · 459

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

N5831KWright Scott M · Tulare, CABuilt 1965 · S/N D-7840 N5831SDangberg Dennis C · Wayne, NES/N D-7731 N5832KSutton Sean A · Fort Lauderdale, FLBuilt 1965 · S/N D-7843 N5832SRoutt Thomas · Norfolk, VABuilt 1964 · S/N D-7729 N5833KFostvedt Kim C · Elkhorn, NEBuilt 1965 · S/N D-7844 N5833SDelp William H · Doral, FLBuilt 1964 · S/N D-7744 N5834KVandagriff Phillip H · Kingwood, TXBuilt 1965 · S/N D-7845 N5835KAdee Bret L · Toronto, SDBuilt 1965 · S/N D-7846 N5835SStiles David W · Saint Petersburg, FLBuilt 1964 · S/N D-7734 N5838KSullivan Jesse G · Yukon, OKBuilt 1965 · S/N D-7838 N5839SFox Alan D · Cherry Hill, NJBuilt 1964 · S/N D-7736 N5840KFrogmore V-Tail LLC · Beaufort, SCBuilt 1965 · S/N D-7850 N5840SBergstrom Aircraft Inc · Pasco, WABuilt 1965 · S/N D-7896 N5841KJones David E · Corsicana, TXBuilt 1965 · S/N D-7852 N5842KSander John B · Knoxville, TNBuilt 1965 · S/N D-7853 N5844SFilips Roger F · Spencer, NEBuilt 1964 · S/N D-7741 N5845SCircle City Balloon Rides LLC · Indianapolis, INBuilt 1964 · S/N D-7739 N5846KMcclendon Jon L · Kilgore, TXBuilt 1965 · S/N D-7847 N5847SRegistered aircraftBuilt 1965 · S/N D-7742 N5848KCater Benjamin · Fresno, CABuilt 1965 · S/N D-7891 N5849KRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1965 · S/N D-7881 N5853SMillen Scott R · Fallbrook, CABuilt 1964 · S/N D-7746 N5858JPezza Cecile A · Brook Haven, NYBuilt 1965 · S/N D-7860 N5863JWehkamp Dave L · Ingalls, KSBuilt 1965 · S/N D-7861 N5864JMccarthney Rickcliffe D · Woodbine, NJBuilt 1965 · S/N D-7863 N5874JMy Flight LLC · Cypress, TXBuilt 1965 · S/N D-7866 N5875JMiller Michael Andrew · Huffman, TXBuilt 1965 · S/N D-7868 N5876J76juliet Aviation LLC · Firth, NES/N D-7869 N5876SDevine Steven A · Roseville, CABuilt 1965 · S/N D-7822 N5877SNguyen Tri Ngoc · Fort Worth, TXBuilt 1965 · S/N D-7758 N5878JThomas William S · Casa Grande, AZBuilt 1965 · S/N D-7870 N5881JDj&M Aero LLC · Eau Claire, WIBuilt 1965 · S/N D-7871 N5883JFaire Kenneth D · La Canada, CABuilt 1965 · S/N D-7874 N5887SMcmartin Cutler J · Roanoke, TXBuilt 1965 · S/N D-7760 N5890JBengal Lawrence W · Upland, CABuilt 1965 · S/N D-7877 N5894SV Tail Therapy LLC · Seattle, WABuilt 1965 · S/N D-7765 N5895SBurson Lloyd R · Anthony, NMBuilt 1965 · S/N D-7773 N5896SPreston Robert J · Pittstown, NJBuilt 1965 · S/N D-7826 N5897SPrecision Aviation LLC · Califon, NJBuilt 1965 · S/N D-7828 N5899JSchuyler Paul E · Morgan Hill, CABuilt 1965 · S/N D-7880 N5899SNvl Properties LLC · Wilmington, DEBuilt 1965 · S/N D-7769 N6001F2120 Limited LLC · Flushing, MIBuilt 1965 · S/N D-7794 N6008FShared 08f Inc · Pensacola Beach, FLBuilt 1965 · S/N D-7798 N600MDDowning Scott L · Fitzgerald, GABuilt 1965 · S/N D-7803 N6016FHanson Enterprises Inc · Hamel, MNBuilt 1965 · S/N D-7823 N6019FFlying R LLC · Apison, TNBuilt 1965 · S/N D-7901 N6027FPease David · Santa Cruz, CABuilt 1965 · S/N D-7895 N6028FFlying Ospreys LLC · Camas, WABuilt 1965 · S/N D-7808 N6029FTeeple Leighton B · Plainview, TXBuilt 1965 · S/N D-7809 N6040FJct Holdings LLC · Henderson, NVS/N D-7814

Back to Beech S35