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.

N8848MFly Shetland LLC · Lubbock, TXS/N D-7360 N884TPerryton Motor Co Inc · Perryton, TXBuilt 1965 · S/N D-7807 N8851MBal-Kar Holdings Inc · Punta Gorda, FLBuilt 1964 · S/N D-7362 N8852MAndys Auto Sales LLC · Caroline, WIBuilt 1964 · S/N D-7367 N8853MBeaver Creek Aviation LLC · Clinton, OKBuilt 1964 · S/N D-7368 N8902ULusby II Dale · Garden Valley, CABuilt 1965 · S/N D-7902 N8903UMartin William C · Middleville, MIBuilt 1965 · S/N D-7903 N8906UKelley William · Springtown, TXS/N D-7906 N8907USprague Allen T · Warrenton, ORBuilt 1965 · S/N D-7907 N8908UFly Buys Too LLC · Wilmington, DEBuilt 1965 · S/N D-7908 N890WBelcher Timothy A · Liberty, KSBuilt 1964 · S/N D-7563 N8917MAero Flite Del Inc · Felton, DEBuilt 1964 · S/N D-7322 N8917UBashaw Trenton C · Newport Beach, CABuilt 1965 · S/N D-7910 N8921ULucy Donald E III · Newbury Park, CABuilt 1965 · S/N D-7911 N8922UN8922u LLC · Twin Falls, IDS/N D-7913 N8923USpeck John W Jr · Plainview, TXBuilt 1965 · S/N D-7917 N8924MTre Aviation Corp · Wilmington, DEBuilt 1964 · S/N D-7337 N8932US35 Aviation LLC · Lakeland, FLBuilt 1965 · S/N D-7921 N8939USiegfried Robert W II · Downers Grove, ILBuilt 1965 · S/N D-7924 N8942UConner Ernest A III · Dallas, TXBuilt 1965 · S/N D-7933 N8944MEngland Neil Dean Jr Trustee · Watsonville, CABuilt 1965 · S/N D-7940 N8945UPoeppelman Philip W · Versailles, OHBuilt 1965 · S/N D-7923 N8946UEilers John D · Royal City, WABuilt 1965 · S/N D-7928 N8948UClarke Cheryl A · Oakley, CABuilt 1965 · S/N D-7945 N8951MZimmerman Bruce M · Crittenden, KYBuilt 1964 · S/N D-7338 N897TMLow Approach Only LLC · Wilmington, DEBuilt 1965 · S/N D-7962 N8981MPeter N Steinmetz Trustee · Tempe, AZBuilt 1964 · S/N D-7339 N8982MSharman Paul D · Carefree, AZBuilt 1964 · S/N D-7310 N8986M170kts LLC · Novato, CABuilt 1964 · S/N D-7313 N8990MHayden Patrick Jr · Lexington, KYBuilt 1964 · S/N D-7312 N8993MNorthwood Holdings LLC · Dugspur, VABuilt 1964 · S/N D-7316 N8995MCollins Sherman C · Sedona, AZBuilt 1964 · S/N D-7317 N9002SD'Alessio Enterprises Inc · Smithville, TNBuilt 1965 · S/N D-7936 N9003SWestchester Flying Club Inc · Purchase, NYBuilt 1965 · S/N D-7937 N9004SMorris Ag Air & Sons Inc · Orovada, NVBuilt 1965 · S/N D-7934 N9011DPorter Michael · Cleveland, TNBuilt 1964 · S/N D-7641 N9018SOptimus Motors LLC · Amarillo, TXBuilt 1965 · S/N D-7948 N9019SSky Master LLC · Blue Earth, MNS/N D-7949 N9022SWalker April M · Keller, TXBuilt 1965 · S/N D-7950 N9023STwo Wings LLC · Pierre, SDBuilt 1965 · S/N D-7951 N9029SKubier Martin · Yukon, OKBuilt 1965 · S/N D-7956 N9034SMcnurlin Thomas C · Tucson, AZBuilt 1965 · S/N D-7960 N9041SMarzich Frank M · Rockford, ILBuilt 1965 · S/N D-7963 N9042STruly Ted · Sherman, TXBuilt 1965 · S/N D-7964 N9044SAshby Peter L Sr · Cadillac, MIBuilt 1965 · S/N D-7941 N90KRKoch Leasing LLC · Campbellsville, KYBuilt 1965 · S/N D-7892 N925TPreserve Land Company LLC · Franklin Lakes, NJBuilt 1964 · S/N D-7371 N941AChalk 2 Inc · Apple Valley, CABuilt 1965 · S/N D-7865 N94BWErdman Aviation LLC · Cameron Park, CABuilt 1964 · S/N D-7627 N961SFBdr Aviation LLC · Ponte Vedra Beach, FLBuilt 1964 · S/N D 7541

Back to Beech S35