Skip to content

Universal Stinson 108-1

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

N6668ELeclere Doug D · Coggon, IABuilt 1947 · S/N 108-1-1063 N8122KScott Randel E · Locust Grove, GABuilt 1947 · S/N 108-3122 N8143KLanggle Robert S Jr · Titusville, FLBuilt 1946 · S/N 108-1143 N8188KContra Costa County · Concord, CABuilt 1946 · S/N 108-1188 N8329KFerrell Herman H · Oak Grove, LABuilt 1946 · S/N 108-1329 N8409KZimmerman Harvey H · Shelby, OHBuilt 1946 · S/N 108-1409 N8484KFeydo Richard D · Andover, OHS/N 108-1484 N8504KDonat Joseph M · Laporte, MNS/N 108-1504 N855FWullner Leeroy J · Cedar Rapids, IABuilt 1947 · S/N 108-1519 N8570KMelton Joshua S · Hayden, IDBuilt 1947 · S/N 108-1570 N85XSmith Shawn B · Salem, ORS/N 108-1340 N8607KCarr Jerome S · Mcgregor, MNBuilt 1947 · S/N 108-1607 N8634KWullner Leeroy J · Cedar Rapids, IABuilt 1947 · S/N 108-1634 N8666KBuce Thomas M · Kimberly, ORS/N 108-1666 N8668KCongdon Walter W · Oneco, CTBuilt 1947 · S/N 108-1668 N8772KHoeksel Michael J · Poplar Grove, ILS/N 108-1772 N8795KWishart Nigel R · Hillsboro, OHS/N 108-1795 N8818KChristians Rolland · Chiefland, FLBuilt 1947 · S/N 108-1818 N8868KSchmidt John E · Saint Paul, MNBuilt 1947 · S/N 108-1868 N8876KSimply Living LLC · Fort Myers, FLS/N 1081876 N9008KKellys Flying Service LLC · Warrensburg, MOBuilt 1947 · S/N 108-2008 N9117KAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1947 · S/N 1082117 N9206KKroenke Seth M · Palmer, AKBuilt 1947 · S/N 108-2206 N97048Petrof Karl · Ligonier, PABuilt 1946 · S/N 108-1048 N97092Papke James L · Sligo, PABuilt 1946 · S/N 1081092 N97746Gay Curtiss R · Tunkhannock, PAS/N 108-746 N97796Holz James T · Grand Junction, IAS/N 108-796 N97972Mcketa Steve C · Bella Vista, ARS/N 108972

Back to Universal Stinson 108-1