Skip to content

Schleicher ASW-20C

Registered aircraft · 20

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

N127PXGrimes Nathan C · Boulder, WYBuilt 1985 · S/N 20797 N16ALMiller Blaine N · Brooks, GABuilt 1985 · S/N 20799 N17ZZWinch Me Aviation LLC · Wurtsboro, NYBuilt 1986 · S/N 20807 N20CXGaines Paul A · Kingman, AZBuilt 1983 · S/N 20702 N20HWRiegal Bryan S · Horseheads, NYS/N 20629 N20QSLoewenstein Paul N · Palo Alto, CABuilt 1983 · S/N 20705 N20UHHenry Raymond L Jr · Belton, TXBuilt 1985 · S/N 20809 N226AMueller Douglas G · Boulder City, NVBuilt 1983 · S/N 20704 N311DPMcarthur Heinz M · Cary, NCS/N 20831 N37DLSimmonds David G · San Pedro, CABuilt 1985 · S/N 20802 N420DDukerich Thomas P · Phoenix, AZBuilt 1985 · S/N 20792 N46GHBunnell Shawn H · Gilmanton, NHS/N 20800 N59HKSahlberg Peter C · Santa Maria, CABuilt 1983 · S/N 20631 N620CLevy Niv B · Torrance, CAS/N 20837 N6514MColton Daniel R · San Carlos, CABuilt 1985 · S/N 20801 N747EAMacmonagle Daniel J · Lyme, NHBuilt 1985 · S/N 20790 N87BMendenhall John M · Williamson, GABuilt 1985 · S/N 20793 N88EEKingswood Andrew C · Auburn, NHBuilt 1983 · S/N 20701 N88VSGrubb Mark D · Tehachapi, CABuilt 1987 · S/N 20863 N929MArnold Jason A · Benton, TNBuilt 1983 · S/N 20707

Back to Schleicher ASW-20C