Skip to content

Universal Stinson 108-2

Registered aircraft · 38

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

N108RCGriebsch James J · Saranac Lake, NYBuilt 1947 · S/N 108-2995 N108USGunter Vernon W · Talkeetna, AKBuilt 1947 · S/N 108-2841 N134CSutton Aircraft Salvage LLC · Palmer, AKS/N 108-3134 N190CWare Mark · Granbury, TXBuilt 1947 · S/N 108-3190 N196CTopp Gary J · Lakewood, COBuilt 1947 · S/N 108-3196 N257CMetcalf Susan K · Anchorage, AKS/N 108-3257 N271CDresback Glen · Cleveland, OKBuilt 1947 · S/N 108-3271 N294CSj Ventures LLC · Kalispell, MTBuilt 1947 · S/N 108-3294 N297KDehaven James D Jr · Enfield Center, NHBuilt 1947 · S/N 1082797 N300CLambremont John L · Normangee, TXBuilt 1947 · S/N 108-3300 N315COff LLC · Lonoke, ARS/N 1083315 N328CWillett Lynn B · Wooster, OHBuilt 1947 · S/N 108-3328 N382CSmith Shawn B · Salem, ORS/N 108-3382 N399CMiller Eric M · Fairfield, IABuilt 1947 · S/N 108-3399 N415CHutson A C N · Griffin, GABuilt 1947 · S/N 108-3415 N442CBuster Colvin · Big Cabin, OKBuilt 1947 · S/N 108-3442 N8026KBarnes Matthew · Anton, TXBuilt 1947 · S/N 108-3026 N8070KParks Alan D · Newcastle, WYS/N 108-3070 N8129KRinaldi Stephen J · Plymouth, CTBuilt 1947 · S/N 108-3129 N901DMaglaughlin Ronald D · Udall, KSBuilt 1947 · S/N 1082901 N9262KAppleberry William H · Warren, MIBuilt 1947 · S/N 108-2262 N9275KStinson Adventure Inc · Appleton, WIBuilt 1941 · S/N 108-2275 N9287KBouden Reese M · Fortson, GABuilt 1947 · S/N 108-2287 N9299KSilvia Richard J · Livermore, CABuilt 1947 · S/N 1082299 N9308KSipes Brian S · North Pole, AKS/N 108-2308 N930DHrabetin James F · Berkeley, CABuilt 1947 · S/N 108-2930 N9411KWenzel Aviation LLC · Rosholt, WIBuilt 1947 · S/N 108-2411 N9427KRegistered aircraftS/N 108-2427 N9433KHigginbotham Stewart · Woodbine, GABuilt 1947 · S/N 1082433 N9443KHultberg Michael T · Palmer, AKBuilt 1947 · S/N 108-2443 N9461KBurnham James A · Macomb, ILBuilt 1947 · S/N 108-2461 N955DSmith Patrick J · Huntington Beach, CABuilt 1947 · S/N 108-2955 N9597KGraef Christopher R · Greenwich, CTBuilt 1947 · S/N 108-2597 N9711KHames Byron L · Maricopa, AZBuilt 1947 · S/N 108-2711 N975DShackelford John S Jr · Roanoke, TXBuilt 1947 · S/N 108-2975 N9848KHolmbeck Dennis J · Milladore, WIBuilt 1947 · S/N 108-2848 N9850KHarvey Douglas J · North Pole, AKBuilt 1947 · S/N 108-2850 N987DPlendl Bruce R · Everett, WABuilt 1947 · S/N 108-2987

Back to Universal Stinson 108-2