Skip to content

Schempp-Hirth VENTUS 2CM

Registered aircraft · 11

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

N10VNTen Victor November LLC · Kailua, HIBuilt 1999 · S/N 75 N118EESitar Zlatko · Apex, NCBuilt 1998 · S/N 55 N163DRPieters Richard · Scotts Valley, CABuilt 2002 · S/N 123 N47DGWhitesell Albert L · Albuquerque, NMBuilt 2002 · S/N 122 N713JSLove John R · Sutton, MABuilt 2006 · S/N 172 N776MRAnderson Carl B · Southlake, TXBuilt 2006 · S/N 170 N777VHKleinhempel Uwe · Minden, NVBuilt 2006 · S/N 179 N7ZQPosch Johann · Minden, NVBuilt 2003 · S/N 137 N989RBostik Industries LLC · Satellite Beach, FLBuilt 2003 · S/N 139 N9UYPrice Michael F · Minden, NVBuilt 2005 · S/N 166 N9VSVan Grunsven Richard E · Hillsboro, ORBuilt 2001 · S/N 112

Back to Schempp-Hirth VENTUS 2CM