Skip to content

Schleicher ASW-20

Registered aircraft · 57

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

N11KJTango Kilo LLC · Miami, FLBuilt 1977 · S/N 20015 N120Dittmer Larry J · Basco, ILBuilt 1980 · S/N 20344 N120BLRegistration Pending · Elmira, NYRegistration pending, canceledS/N 20105 N120PVEckstein Sean R · Orange, CABuilt 1981 · S/N 20493 N120WBMcclain Kip M · Parker, COBuilt 1980 · S/N 20361 N123DPFrankenberger Arnold C III · Newport Beach, CABuilt 1980 · S/N 20343 N12HAZeug Leon · Delano, MNBuilt 1980 · S/N 20339 N12ZBIngram Dartanyan A · Tulsa, OKBuilt 1978 · S/N 20060 N1301GFaust Stanley J · Nashua, NHBuilt 1978 · S/N 20063 N17RWMuncey H Michael · Trabuco Canyon, CABuilt 1979 · S/N 20271 N199CSSchneider Michael E · Pleasanton, CAS/N 20491 N1BTCarneal Jeffrey T · Nashville, TNBuilt 1978 · S/N 20072 N204QRehmel Carey L · Kirklin, INBuilt 1979 · S/N 20262 N20ABTanner Roger J · Rosamond, CABuilt 1980 · S/N 20338 N20DQBerry Wallace D · Lafayette, ALBuilt 1977 · S/N 20018 N20NTSanders Tyler G · Tehachapi, CABuilt 1979 · S/N 20275 N20TSFlying Boyz Soaring LLC · Lakeland, FLBuilt 1981 · S/N 20483 N20UZEarles Craig P · Vail, AZBuilt 1978 · S/N 20016 N20YPTen Victor November LLC · Kailua, HIBuilt 1981 · S/N 20487 N20ZZFish George T · Tularosa, NMBuilt 1977 · S/N 20010 N230DBTauber David B · New Castle, NHBuilt 1979 · S/N 20263 N24WAPurcell David S · Chandler, AZBuilt 1982 · S/N 20488 N251BAnklam Thomas M · Dublin, CABuilt 1979 · S/N 20274 N2557Sare Samuel · Port Matilda, PABuilt 1980 · S/N 20355 N261Larder Lee R · Charlotte, MIBuilt 1977 · S/N 20112 N26307Dorwart Jeffrey B · Quaker Hill, CTBuilt 1981 · S/N 20477 N27MMGanse Thomas · Holderness, NHBuilt 1978 · S/N 20064 N288Taylor Nathan R · Nashville, TNBuilt 1981 · S/N 20463 N31TSHindman Clifford D · Harpersville, ALBuilt 1982 · S/N 20598 N3252NKoepper Mark D · Waltham, MAS/N 20587 N333ATPitts Carl A · Salt Lake City, UTBuilt 1978 · S/N 20102 N365JMUS Junior Soaring Association · Brighton, MIBuilt 1983 · S/N 20365 N3682Madsen Shannon R · Livermore, CABuilt 1980 · S/N 20341 N37VVBaker Daniel L · Monticello, NYS/N 20003 N39DGSaunders Christopher D · Lehighton, PAS/N 20356 N44ZHWhitelaw James W · Phoenix, AZS/N 20253 N46811Sky Sailing Inc · Warner Springs, CABuilt 1977 · S/N 20013 N472JHMabry Thomas · Atlanta, GABuilt 1981 · S/N 20472 N4804WPaetzold Larry E · Hereford, TXS/N 20272 N49946Lagrone Travis · Houston, TXBuilt 1979 · S/N 20121 N4XAFrias Roberto J · Steamboat Springs, COBuilt 1978 · S/N 20117 N5XBCrawford Iain A · Perkinsville, VTBuilt 1981 · S/N 20466 N62CMTradewinds Aero Inc · Traverse City, MIBuilt 1981 · S/N 20489 N62TMPullup Associates · East Wenatchee, WABuilt 1981 · S/N 20485 N70864Brown Elijah E · Chino Valley, AZS/N 20277 N727AMLikos William E · Warner Robins, GABuilt 1979 · S/N 20273 N77XRVoegeli Jan M · Golden, COS/N 20267 N7820AWhite Wings LLC · Sheridan, WYBuilt 1978 · S/N 20093 N79BSWeydmann Peter · Hamilton, NJBuilt 1982 · S/N 20592 N79JGDaniel Gordon W · Dillsburg, PABuilt 1979 · S/N 20264

Back to Schleicher ASW-20