Skip to content

Schempp-Hirth DISCUS B

Registered aircraft · 29

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

N105GDHudson Mitchell C · Erie, COS/N 10 N13SGBay Area Soaring Associates Inc · San Jose, CABuilt 1985 · S/N 69 N144TCypress Soaring Inc · Hemet, CABuilt 1989 · S/N 266 N14SZWoenker Timothy E · Columbia City, INS/N 96 N14ZZKlunk Lewis J · Cambridge, MABuilt 1987 · S/N 176 N16DEWashington Robert D · Eureka, MOBuilt 1984 · S/N 6 N16JJEggert Darrell R · San Luis Obispo, CABuilt 1986 · S/N 97 N19BEVan De Velde Thomas E · Brookline, MAS/N 27 N224BDuncan Terry Trustee · Cupertino, CABuilt 1987 · S/N 205 N244CXIto Rysuke · Everett, WAS/N 83 N26HLEngel Carl J · Campbell, CAS/N 31 N32086Hinniger Werner M · HamburgBuilt 1985 · S/N 65 N3DDTirca Laviniu H · Philadelphia, PABuilt 1986 · S/N 145 N400HBKautter William J · Columbia, MDBuilt 1995 · S/N 550 N43SGNoordergraaf Alexander A · Concord, NHBuilt 1986 · S/N 82 N44BXBoedecker Paul L · Excelsior, MNBuilt 1986 · S/N 58 N526BCPortman Lance N · Morgan Hill, CABuilt 1988 · S/N 244 N54HWUS Junior Soaring Association · Brighton, MIBuilt 1986 · S/N 113 N560RProkes William J · Tempe, AZBuilt 1987 · S/N 147 N57PPStewart Michael · Park City, UTS/N 313 N65JJJackson James A · Houston, TXBuilt 1993 · S/N 472 N717MJPhiladelphia Glider Counsil Inc · Hilltown, PAS/N 211 N77AUCoder Don Erdman · Arlington, TXS/N 77 N7958CLeonard Ronald A · Peculiar, MOS/N 251 N84DFMollified LLC · Beaver, PABuilt 1986 · S/N 128 N87BDHarrison Lee · Rensselaer, NYS/N 78 N888TKCloclasure David L · Bringhurst, INBuilt 1986 · S/N 134 N941KSCrippen Terrence M · Maple Valley, WABuilt 1985 · S/N 13 N97DGLoeffler Herbert M Jr · Saratoga Springs, NYBuilt 1986 · S/N 108

Back to Schempp-Hirth DISCUS B