Skip to content

Schempp-Hirth VENTUS-B

Registered aircraft · 28

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

N109Mikelsen Carlos A · Sun Prairie, WIBuilt 1981 · S/N 66 N10ZFRegistration Pending · Loveland, OHRegistration pendingBuilt 1981 · S/N 42 N12VFPfiffner Richard H · Hornbrook, CABuilt 1982 · S/N 113 N139PSwanson Thomas G · Seaford, VABuilt 1981 · S/N 55 N1428BSmith Richard G · Kokomo, INBuilt 1981 · S/N 37 N15YGFried Stephen S · Kingston, MAS/N 119 N193SAWiley George D · Loganville, GABuilt 1983 · S/N 142 N22RHArcher James P · Bend, ORBuilt 1982 · S/N 80 N246DCleveland David · North Salt Lake, UTBuilt 1982 · S/N 77 N27DGZimmerman Walker D · Nashville, TNS/N 98 N314CAIverson Eric W · Park City, UTBuilt 1981 · S/N 67 N38ULagrone Travis L · Houston, TXBuilt 1982 · S/N 102 N43DLCornelis Reindert Van De Klippe · West Chicago, ILS/N 103 N44HZMcdowell Samuel A · Carlsbad, NMS/N 112 N511RDMeacham Bruce · Kansas City, KSS/N 110 N59GWWalker Scott G · Tehachapi, CABuilt 1983 · S/N 129 N59PZZanis Paul M · Wolfeboro, NHBuilt 1981 · S/N 39 N65LEZawodny Jeremy D · Groveland, CABuilt 1982 · S/N 108 N700TMWestphal Eric R · Conroe, TXBuilt 1982 · S/N 100 N77AERoberts David M · Albuquerque, NMS/N 59 N77JHFiliaci Mattia E · New York, NYBuilt 1983 · S/N 169 N804TThompson Arthur C · San Jose, CABuilt 1981 · S/N 60 N89RRMastaler Ronald A · Tucson, AZBuilt 1981 · S/N 48 N90VVRussell Tipton J · Muncie, INS/N 81 N911FCavanagh Michael B · Dubois, WYBuilt 1982 · S/N 64 N93NDavidson Brent V · Sausalito, CABuilt 1982 · S/N 85 N948BGordon Zach Edward · Spring, TXBuilt 1981 · S/N 56 N984TWatrous Dave Warren · Lake Oswego, ORBuilt 1981 · S/N 61

Back to Schempp-Hirth VENTUS-B