Skip to content

Schleicher ASW-19B

Registered aircraft · 17

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

N106TCollins Michael R · Parker, AZBuilt 1979 · S/N 19288 N10WHOdonnell Michael F · Newtown, PABuilt 1980 · S/N 19322 N119LTCilley Sherburn C · South Royalton, VTBuilt 1980 · S/N 19312 N19JNBrannan Patrick S · Saint Louis, MOBuilt 1979 · S/N 19294 N19KLRuskauff David J · Geneseo, NYS/N 19058 N19LKCanty Jeremiah D · Burke, VABuilt 1981 · S/N 19353 N19MLEyler Stuart L · Oceanside, CABuilt 1982 · S/N 19373 N28TRHouseknecht Thomas J · State College, PAS/N 19419 N319HHCampbell Gary A · Boulder, COS/N 19408 N31GFTarnoczy Robert I · Corning, NYBuilt 1983 · S/N 19386 N34HRRossi Michael A · Pittsboro, NCBuilt 1981 · S/N 19349 N37RBBransford Edward J · Smithfield, VABuilt 1979 · S/N 19295 N53JCBlack Forest Soaring Association · Monument, COBuilt 1985 · S/N 19415 N651ASStyker Andrew J · Xenia, OHBuilt 1979 · S/N 19289 N888MKLynch William Reymond · Dearborn, MIBuilt 1983 · S/N 19397 N982WTMorse Kathleen A · Groveland, CABuilt 1982 · S/N 19363 N99NDHermann Mark A · Glastonbury, CTS/N 19357

Back to Schleicher ASW-19B