Skip to content

Universal Stinson 108

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

N40107Knutson Wayne R · Thompson, NDBuilt 1946 · S/N 108-37 N40128Weigel Samuel D · Bremerton, WABuilt 1946 · S/N 108-58 N40157Jones Daniel S · Panama City Beach, FLBuilt 1946 · S/N 108-87 N412First State Ag Air Inc · Viola, DEBuilt 1946 · S/N 108-160 N8628KWessner Ross W · Myerstown, PAS/N 108-1628 N9063KSparks James D · Glennallen, AKBuilt 1947 · S/N 108-2063 N9381KKansas Air LLC · Linn, KSBuilt 1947 · S/N 108-2381 N97206Cox Alex E · Watson, ARBuilt 1946 · S/N 108-206 N97230Johnson Albert L · Baldwinsville, NYBuilt 1946 · S/N 108-230 N97254Wightman John F · Sierra Madre, CABuilt 1946 · S/N 108-254 N97323Halverson Ronie G · Bennett, COBuilt 1946 · S/N 108-323 N97340Jones Wade T · Wichita, KSBuilt 1946 · S/N 108-340 N97344Hodges Paul · Simi Valley, CABuilt 1946 · S/N 108-344 N97350Becker Steven P · Lincoln, NES/N 108-350 N97379Whitfield Richard A Jr · Hurdle Mills, NCBuilt 1946 · S/N 108-379 N97421Mahan Phillip A · Douglas, AKBuilt 1946 · S/N 108-421 N97629Mcmullen Douglas · Wasilla, AKBuilt 1946 · S/N 108-629 N97707Lumpkin Ed · Rosie, ARS/N 108-707 N995PWWood Stephen R · San Diego, CAS/N 108-457

Back to Universal Stinson 108