Skip to content

Rolladen-Schneider LS-3

Registered aircraft · 22

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

N1000ALewis Steven G · Salida, COBuilt 1978 · S/N 3255 N100XLLaitinen David P · Raleigh, NCBuilt 1979 · S/N 3401 N13TBCcsc Ls3 LLC · Oakwood, OHBuilt 1977 · S/N 3292 N216TPTalarek Eva · Far Hills, NJBuilt 1977 · S/N 3073 N26XCangahuala Laureano A · Claremont, CABuilt 1977 · S/N 3002 N27DCPautz Martin R · Alpharetta, GABuilt 1978 · S/N 3306 N32JKSamson Philip C · Nashville, TNS/N 3102 N40HWBurrows Erik · Lake Forest, CABuilt 1978 · S/N 3279 N45EWDoherty Mark R · Pryor, OKBuilt 1978 · S/N 3224 N46895Westenfelder Christof · Salt Lake City, UTS/N 3199 N48CWHibbard Bruce A · Layton, UTBuilt 1977 · S/N 3196 N4EHHealy Richard A · Chatham, NJBuilt 1977 · S/N 3028 N511YRoeske Stanley B · Albuquerque, NMBuilt 1978 · S/N 3275 N51801Templin Robert S · Stanhope, NJS/N 3197 N52BWNeilson William Andrew · Louisa, VABuilt 1977 · S/N 3198 N573JLWood Thomas Edwin Jr · Steamboat Springs, COBuilt 1978 · S/N 3313 N707JEFrias Roberto J · Steamboat Springs, COBuilt 1978 · S/N 3225 N71JFeldvebel Tom P · Albuquerque, NMBuilt 1978 · S/N 3254 N78FDYorston John · Boonton, NJBuilt 1977 · S/N 3193 N85AAFallah Albert M · Spring, TXBuilt 1978 · S/N 3277 N96JHAliante LLC · Longmont, COBuilt 1977 · S/N 3050 N99NECloudstreet Ventures Inc · Temple Terrace, FLS/N 3103

Back to Rolladen-Schneider LS-3