Skip to content

Schleicher ASW-27

Registered aircraft · 72

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

N108WRHallett Mark R · Hobe Sound, FLBuilt 2002 · S/N 27189 N127FPFoertsch Eric R · Acton, MAS/N 27065 N127KSDeutsch Mitchell M · Marietta, GABuilt 1998 · S/N 27097 N127LJRedweik Eric P · Tucson, AZBuilt 1998 · S/N 27094 N127MGMichalowski Roman · Eastchester, NYS/N 27034 N127MMRoach Brian L · San Jose, CABuilt 2004 · S/N 27228 N127PADowell Christopher W · Palmdale, CABuilt 2000 · S/N 27146 N127PRCedar Richard D · Cincinnati, OHS/N 27004 N127SM27 Bravo LLC · Saint Paul, MNBuilt 2001 · S/N 27156 N137EDUrbanczyk Kirk M · Draper, UTBuilt 1999 · S/N 27102 N19HKCarter Gary E · Dahlonega, GAS/N 27106 N227BBDerosa John H · West Dundee, ILBuilt 2002 · S/N 27181 N227DWDutka Leslie A · Pittsburgh, PABuilt 2002 · S/N 27200 N227MGRegistered aircraftRegistration pendingBuilt 1998 · S/N 27099 N227SDMinar Steven H · Bend, ORBuilt 2001 · S/N 27173 N22SQMertins Enrique · Parrish, FLS/N 27148 N2611WEiler Martin J · California City, CABuilt 1997 · S/N 27039 N270ASWeck Geoffrey E · Woodstock, ILS/N 27147 N271JHSchmidt Mark A · San Marino, CABuilt 2003 · S/N 27217 N271JSArmstrong Daniel J · Tehachapi, CABuilt 1996 · S/N 27035 N2727BZelek Daniel · Wurtsboro, NYBuilt 2000 · S/N 27137 N272JSRuf Chris J · Sandy Springs, GABuilt 1997 · S/N 27058 N272PCHilty Grant C · Prescott Valley, AZBuilt 1996 · S/N 27031 N273SPRiley Thomas V · San Diego, CABuilt 1997 · S/N 27037 N274CEHawkins Mark F · Edgewood, NMBuilt 1998 · S/N 27085 N274JMLarimore Stuart B Trustee · Boise, IDS/N 27029 N274RDPillard Russell L Jr · Santa Rosa, CABuilt 1996 · S/N 27019 N274RTSchaefer Rich · Marble Falls, TXBuilt 1997 · S/N 27059 N274SPRoettele Mark S · Yorba Linda, CAS/N 27167 N27BUJones Philip Trustee · Carson City, NVBuilt 2002 · S/N 27201 N27BZN27bz LLC · Decatur, GABuilt 2003 · S/N 27213 N27CEMccarthy Evan · Irvine, CABuilt 1997 · S/N 27002 N27FSCarden Eric · Huntsville, ALS/N 27067 N27GLMcmaster Justin Thomas · Winterhaven, FLBuilt 1998 · S/N 27096 N27HFSawyer Tyson David · Mason, NHS/N 27119 N27HHWaitekaitis Steven M · Norwell, MABuilt 1997 · S/N 27066 N27KHEvenski Linda G · Honeoye, NYBuilt 1998 · S/N 27068 N27KTGardner Timothy J · Gardnerville, NVBuilt 1999 · S/N 27116 N27UHBohl Howard M Jr · Long Beach, CABuilt 1997 · S/N 27057 N27XAHansman Robert J · Cambridge, MABuilt 1998 · S/N 27093 N27ZLRegistration Pending · Alpine, NJRegistration pendingBuilt 2001 · S/N 27161 N321ERRegistration Pending · Richfield Springs, NYRegistration pendingS/N 27091 N337DDOlson Daniel E · Jamestown, NYBuilt 1998 · S/N 27074 N360GHRegistration Pending · Truckee, CARegistration pendingS/N 27128 N45EMGlaab Louis J · Hampton, VABuilt 1996 · S/N 27007 N474SHarness Kermit M R · Memphis, TNS/N 27164 N503CWGillis Matthew J · Los Molinos, CAS/N 27165 N527TFIturregui Miguel M · Los Alamos, NMS/N 27140 N52XXStroud Terry S · Grand Prairie, TXS/N 27176 N5XXAnisman David · Los Altos, CABuilt 1999 · S/N 27109

Back to Schleicher ASW-27