Skip to content

Schleicher ASW-19

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

N10GKLong Taylor · Hamilton, TXBuilt 1976 · S/N 19021 N119JGGrecco Joseph J · Saddle Brook, NJBuilt 1977 · S/N 19137 N11QSNevada Soaring Association Inc · Reno, NVBuilt 1978 · S/N 19210 N127JCEllertson Don R · Torrance, CABuilt 1976 · S/N 19031 N196HSale Reported · AlbertaSale reportedBuilt 1977 · S/N 19139 N19DTAgnew Alfred P · West Palm Beach, FLBuilt 1978 · S/N 19193 N19FZTagliani James M · Dewey, AZBuilt 1976 · S/N 19020 N19HGSoaring Science Inc · Wilmington, DES/N 19255 N19JEKozlik Wiktor · Ramsey, NJBuilt 1978 · S/N 19214 N19MROpitz Martin H · Seymour, CTBuilt 1978 · S/N 19191 N19PLGarbacz Christina B · Chicago, ILBuilt 1977 · S/N 19138 N21TWOuroboros Soaring LLC · Salt Lake City, UTS/N 19158 N237JFTzerefos Lambros P · Mathews, VAS/N 19156 N333USHutnick Michael C Jr · Bloomsburg, PABuilt 1977 · S/N 19160 N37PLTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 19190 N439ASDezzutti John P · Lakeside, CTS/N 19231 N44AULong Nicholas R · Woodinville, WABuilt 1976 · S/N 19061 N451ASReynolds John C · Warren, PAS/N 19252 N54619Butler Kenneth L · Mc Leansville, NCBuilt 1977 · S/N 19159 N64HRChew Lindsey J · Lafayette, NJBuilt 1978 · S/N 19189 N78CMKilo 7 LLC · Colorado Springs, COBuilt 1976 · S/N 19070 N80SFDi Stefano Fabrizio D · Goose Creek, SCBuilt 1978 · S/N 19194 N842CCHolmberg William · Dallas, TXBuilt 1976 · S/N 19069 N876FTucson Soaring Club Inc · Sahuarita, AZBuilt 1976 · S/N 19068 N97GSWillamette Valley Soaring Club · Cornelius, ORBuilt 1977 · S/N 19140 N9814AGreaterboston Soaring Club Inc · Sterling, MABuilt 1978 · S/N 19199

Back to Schleicher ASW-19