Skip to content

Schempp-Hirth DISCUS-2B

Registered aircraft · 27

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 ('3801904', '3801908')
  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 ('3801904', '3801908')
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.

N103JDenman David H · Gainesville, FLBuilt 2001 · S/N 115 N140BHRegistered aircraftBuilt 2000 · S/N 85 N144JSullivan Brent · Houston, TXBuilt 2000 · S/N 73 N15VHLehmann Lawrence W E · Pittsburgh, PABuilt 2002 · S/N 129 N163AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 188 N164AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 189 N165AFUsaf Academy · Usaf Academy, COBuilt 2003 · S/N 187 N200DXOpitz Michael R · Freehold, NYBuilt 1999 · S/N 50 N204JGGreer John M Jr · Mercer Island, WABuilt 2000 · S/N 76 N212VBFurdal Lukasz · Hillsborough, NJBuilt 2000 · S/N 75 N257SBDuncan Marvin H Jr · Marblehead, MABuilt 2002 · S/N 145 N272BLFrechtling Andrew C · Waxahachie, TXBuilt 2001 · S/N 119 N28WGGeiger William D · Pittsburgh, PABuilt 2006 · S/N 220 N29PSWalling Reigh A · Clifton Park, NYS/N 137 N328TWAlspaugh George J · Pfafftown, NCBuilt 2007 · S/N 228 N41REEckel Robert W · Centerville, UTBuilt 1998 · S/N 10 N51CRJaeger Dieter · Decatur, GABuilt 2003 · S/N 165 N523RRGlenn Tom · Fallbrook, CABuilt 2009 · S/N 232 N63HRWisniewski Steven Jay Jr · Marietta, GABuilt 2017 · S/N 257 N64PGGaisford Phillip A · Billerica, MABuilt 2002 · S/N 134 N67CRStanley Ronald L · Ellsworth, ILBuilt 2002 · S/N 144 N755HEmmert Paul H · Marana, AZBuilt 2002 · S/N 148 N761YGregg Steven D · Queen Creek, AZBuilt 2000 · S/N 63 N828JNHutnick Michael C Jr · Bloomsburg, PABuilt 2001 · S/N 120 N917WVByars Guy F · Goshen, OHBuilt 2000 · S/N 81 N928JFForbes Murray I · Marietta, GABuilt 2002 · S/N 156 N97KGNasadowski Martin · Portland, ORBuilt 1998 · S/N 13

Back to Schempp-Hirth DISCUS-2B