Skip to content

Schleicher ASW-24

Registered aircraft · 32

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

N105WRMiddleline Aviation Inc · Ballston Spa, NYS/N 24217 N111RLYoungblood Robert W · Vero Beach, FLS/N 24111 N114JSJenkyn Lawrence R · Hanover, NHBuilt 1993 · S/N 24190 N122ABDrews Frank A · Salt Lake City, UTBuilt 1993 · S/N 24195 N124CGWhite Donald Adam · Pennsburg, PABuilt 1993 · S/N 24219 N124MMSorenson Kenneth G · Waller, TXBuilt 1989 · S/N 24030 N215DDEiche Peter C · Amherst, NHBuilt 1993 · S/N 24196 N224CGTrk Sailplane Partners LLC · Schaumburg, ILBuilt 1989 · S/N 24031 N224JRMayes Brett R · Williams, CABuilt 1992 · S/N 24177 N224WKMcginnis Richard A · Black Mountain, NCBuilt 1988 · S/N 24027 N240TGTreasure Coast Soaring Club Inc · Vero Beach, FLS/N 24073 N241JMHaines Eric C · Fayetteville, NYS/N 24160 N243JUrbahn John A · Saratoga Springs, NYS/N 24182 N2499Ayotte Stewart R · Glendale, CABuilt 1988 · S/N 24009 N24MRAlonso Oscar S · Tehachapi, CAS/N 24082 N24PJDunning Francis M · Madison, WIBuilt 1992 · S/N 24189 N271FMmmdam LLC · Midlothian, TXBuilt 1993 · S/N 24216 N35KSKuehn Matthias W · Monrovia, CABuilt 1989 · S/N 24032 N3LXMyers Peter S · Franklin, TNBuilt 1988 · S/N 24002 N416EGShort James B · Crown Point, INBuilt 1992 · S/N 24187 N41ZZWalker Robert D · Louisville, KYBuilt 1994 · S/N 24224 N424SNephelai Aviation Lc · Cape Coral, FLS/N 24109 N5LXMayes Brett R · Williams, CABuilt 1993 · S/N 24199 N5YACamp James C · Oak Ridge, NCBuilt 1991 · S/N 24135 N707JBBearden Joseph N III · Boonton, NJBuilt 1992 · S/N 24152 N74UCElsen Hubert · Naples, FLS/N 24080 N7622N7622 LLC · Santa Fe, NMBuilt 1994 · S/N 24225 N84RFBeckley John P · Carlise, MABuilt 1991 · S/N 24113 N92SJJednacz Scott T · Bixby, OKBuilt 1992 · S/N 24188 N93MHMayes Brett R · Williams, CAS/N 24029 N940CBSoaring Science Inc · Wilmington, DEBuilt 1989 · S/N 24069 N94CGHackett Richard · Queensbury, NYS/N 24229

Back to Schleicher ASW-24