Skip to content

Schweizer SGS 1-35

Registered aircraft · 28

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

N135ALBlack Industries LLC · Helena, MTS/N 40 N135BDDierker Robert R · Chestertown, MDBuilt 1975 · S/N 24 N135KLK & L Soaring LLC · Cayuta, NYBuilt 1975 · S/N 43 N135MJEmery Kyle W · Mulberry, FLBuilt 1974 · S/N 3 N135MNKuyt Michael · Rochester, NYBuilt 1975 · S/N 45 N135MSAlders Neal · Okeechobee, FLS/N 44 N135RDNewton Christian B · Redondo Beach, CABuilt 1976 · S/N 55 N135RMBromschwig Kurt Ftrustee · Montgomery, TXBuilt 1975 · S/N 48 N233XHautau Arthur David · Melbourne, FLS/N 28 N2851HSmith Leonard I III · Overland Park, KSBuilt 1976 · S/N 51 N2JYNorthern Aviation LLC · Palmer, AKBuilt 1976 · S/N 56 N33996Doyle Brian G · Windsor, MABuilt 1974 · S/N 6 N34107Strong Kurt J · Lake Geneva, WIBuilt 1975 · S/N 50 N34173Zacharski Robert · Wakefield, MAS/N 12 N34174Registered aircraftBuilt 1975 · S/N 14 N34175Hull Mahlon B · Sedro Woolley, WABuilt 1975 · S/N 15 N34180Raven Nw Llp · Acme, PAS/N 20 N34181Folwarczny Petr · Round Lake, ILBuilt 1975 · S/N 21 N34183Smith Timothy A · Poynette, WIBuilt 1975 · S/N 33 N34185Olczyk Adam · Woodhaven, NYBuilt 1975 · S/N 25 N34189Mays Paul R · Toney, ALBuilt 1975 · S/N 39 N34262Zhills Soaring LLC · Temple Terrace, FLBuilt 1975 · S/N 42 N623YBSierra Soaring Club · Ridgecrest, CAS/N 38 N64QThurmond Clark · Georgetown, TXBuilt 1975 · S/N 19 N65882Hall Christopher G · Indianapolis, INBuilt 1974 · S/N 2 N65919Ellis Lee Demott III · Lutz, FLS/N 29 N75135Pitoniak Michael · Townsend, MABuilt 1975 · S/N 35 N9JKStewart James D · Trussville, ALBuilt 1975 · S/N 18

Back to Schweizer SGS 1-35