Skip to content

Schweizer SGS 1-35C

Registered aircraft · 26

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

N135CSNick Kevin E · Loma Linda, CAS/N 98 N135DBDavis Michael D · Boerne, TXBuilt 1977 · S/N 76 N135EXDelash John · Williamson, GABuilt 1977 · S/N 72 N135JRTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1977 · S/N 82 N13ZKirschman Kim C · Ankeny, IAS/N 79 N2000DMcallister Samuel M · Grand Blanc, MIBuilt 1977 · S/N 84 N2671HHatfield Michael O · Fredericksburg, VABuilt 1976 · S/N 71 N2675HBeckman James E · Great Meadows, NJBuilt 1977 · S/N 75 N2709HMajor Travis S · Phoenix, AZBuilt 1978 · S/N 89 N2774HKnauth Geoffrey Stanton · Williamsport, PABuilt 1977 · S/N 74 N2776HMontgomery Raymond Lee · Blackfoot, IDBuilt 1978 · S/N 86 N2779HLudolph William K · Brooklyn, NYBuilt 1976 · S/N 59 N2780HMorrison Brian D · Albuquerque, NMBuilt 1977 · S/N 80 N2813HDavenport Lawrence H · Brandon, FLBuilt 1979 · S/N 93 N2817HElliott Donald E III · Lexington, SCS/N 77 N2846HSparta Rotors · New York, NYBuilt 1976 · S/N 66 N2880HLeonard Glenn D · Ruidoso, NMBuilt 1976 · S/N 70 N2883HTisdale William H · Milford, NHS/N 83 N2895HSkinner John Jay · Citrus Springs, FLBuilt 1978 · S/N 95 N2922HUmphlette Charles B Jr · Suffolk, VABuilt 1978 · S/N 92 N2924HReilman Robert F Jr · Colorado Springs, COBuilt 1979 · S/N 94 N2927HCrowley James S · Riverview, FLBuilt 1980 · S/N 97 N2966HLannom Tony F · Fort Davis, TXBuilt 1979 · S/N 96 N35ACGaddy Larry J · Lakeland, FLBuilt 1976 · S/N 63 N3620EHarris Hill Soaring Corp · Elmira, NYBuilt 1981 · S/N 100 N55PSBauer Douglas M · Pahrump, NVBuilt 1976 · S/N 64

Back to Schweizer SGS 1-35C