Skip to content

Schempp-Hirth CIRRUS

Registered aircraft · 15

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

N1194Leonard Steven E · Wichita, KSS/N 4 N11NCPierce John C · Cedar City, UTBuilt 1968 · S/N 64 N3441Field Drew H · Dallas, TXBuilt 1968 · S/N 24 N404ESHardy John A · El Paso, TXBuilt 1969 · S/N 44 N413MDNyman Robert H · Elsinore, CABuilt 1968 · S/N 28 N4173CCompton Francis B · Marfa, TXBuilt 1968 · S/N 33 N441UJBruce Robert H · Boerne, TXBuilt 1969 · S/N 55 N6660Malis Michael B · Stevenson Ranch, CABuilt 1969 · S/N 80 N6662Perkins Chris D · Veradale, WABuilt 1969 · S/N 81 N6663King Peter C · Signal Mountain, TNBuilt 1969 · S/N 83 N757NLeonard Steven E · Wichita, KSBuilt 1968 · S/N 36 N77CNSandhill Soaring Club Inc · Brighton, MIBuilt 1971 · S/N 105 N8145Ceriotti Leonard L · Waukesha, WIBuilt 1969 · S/N 70 N8169Timothy R Lutzko · Ocean View, DEBuilt 1969 · S/N 67 N888ANRockfish Cirrus LLC · Faber, VABuilt 1968 · S/N 18

Back to Schempp-Hirth CIRRUS