Skip to content

Nord STAMPE SV4C

Registered aircraft · 19

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 ('6383006', '8470107')
  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 ('6383006', '8470107')
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.

N100SVKretschman Thomas J · Verona, WIBuilt 1946 · S/N 526 N10703Ace Aviators LLC · New Baltimore, MIBuilt 1947 · S/N 174 N111SVSiebert Derrick R · Wausau, WIBuilt 1949 · S/N 1063 N11SVBarrow Timothy M · Castroville, TXS/N 183 N123BDMcoran Campbell Neill I · Boerne, TXBuilt 1946 · S/N 235 N12433Domeyer David K · Washougal, WABuilt 1946 · S/N 23 N12SVHarmacinski Larry Trustee · Punta Gorda, FLBuilt 1947 · S/N 418 N13SVCosgrove Mark A · Grand Ledge, MIBuilt 1946 · S/N 1139 N14428Gray Shane C · Interlochen, MIBuilt 1947 · S/N 594 N14SVBaron Robert David · Rochester, MIBuilt 1947 · S/N 537 N1606Weeks Kermit A · Polk City, FLBuilt 1945 · S/N 190 N3790QPeterson Don C · Carson City, NVS/N 674 N383DKSimply Living LLC · Fort Myers, FLBuilt 1952 · S/N 383 N46SVBevan John E · Spokane, WABuilt 1956 · S/N 420 N47SVHess Scott R · Spicewood, TXBuilt 1947 · S/N 423 N48000Gillies Paul A · Marion, KYS/N 393 N604SVApfelbaum Jonathan · Erie, COS/N 604 N616SVWayman Ian A · Peyton, COBuilt 1947 · S/N 616 N666DHTucker Leonard R Jr · Saint Augustine, FLBuilt 1946 · S/N 350

Back to Nord STAMPE SV4C