Skip to content

Universal Stinson 108-3

Registered aircraft · 49

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

N108NMHarbison Kenneth R · Las Cruces, NMBuilt 1948 · S/N 108-4910 N3049Perry Conrad J · Kasilof, AKBuilt 1948 · S/N 1084442 N328TTAirport Farms Aviation LLC · Tarkio, MOS/N 108-3514 N4001CJsl Air LLC · Sikeston, MOBuilt 1949 · S/N 108-5001 N4005CHerlihy LLC · Loveland, COBuilt 1947 · S/N 1084005 N4024CHoran David L · Diana, TXBuilt 1948 · S/N 108-5024 N4026CNauta Gordon W · Palmdale, CABuilt 1948 · S/N 108-5026 N4028CZaiet Hanni · Agua Dulce, CABuilt 1948 · S/N 108-5028 N4049CBays Dennis II · Wadsworth, OHBuilt 1949 · S/N 108-5049 N4069CMorgan David W · Canton, MIBuilt 1950 · S/N 108-5069 N4073CHone Ryan L · Dixie, IDBuilt 1948 · S/N 108-5073 N4076CYoung Steven H · Bountiful, UTBuilt 1948 · S/N 108-5076 N4090CPlourde James A · Palm Coast, FLBuilt 1950 · S/N 108-5090 N4098CAstro Holdings LLC · Smithfield, RIS/N 108-5098 N4102CJones John Edwin Jr · Metter, GAS/N 108-5102 N531CLeehan Drew · East Grand Forks, MNBuilt 1947 · S/N 108-3531 N562CBellew James W · Pueblo, COBuilt 1947 · S/N 108-3562 N576CFerence Jeffrey J · Chandler, AZS/N 108-3576 N603CGross J Peter · Kalispell, MTBuilt 1947 · S/N 108-3603 N6090MLanam Philip A · Potter Valley, CABuilt 1947 · S/N 108-4090 N6102MCrenshaw Dennis A · Mechanicsville, VABuilt 1947 · S/N 108-4102 N6167MDunn Robert J · Penngrove, CABuilt 1948 · S/N 108-4167 N6219MHandberg Lawrence E · Thermopolis, WYBuilt 1948 · S/N 108-4219 N6280MFish Russell D · Salt Lake City, UTBuilt 1948 · S/N 108-4280 N6381MPradelt Charles F · Queen Creek, AZBuilt 1948 · S/N 108-4381 N6383MKrejci Dwight D · Wheatland, WYBuilt 1948 · S/N 108-4383 N6450MAndersen Dana K · Scappoose, ORBuilt 1948 · S/N 108-4450 N6492MHess Wayne P · Terrebonne, ORS/N 108-4492 N6507MFelice Thomas L · Schenectady, NYBuilt 1948 · S/N 1084507 N6508MSuryan Richard L · Port Townsend, WABuilt 1948 · S/N 108-4508 N65127Bowen William · Fairbanks, AKBuilt 1948 · S/N 108-4554 N6564MToby Aviation Inc · Pigeon Forge, TNS/N 108-4564 N6655MLoos Richard Lee · Warsaw, INS/N 108-4655 N6674MWilson Randall L · Fairbanks, AKS/N 108-4674 N6689MGehrich Michael · Greenwood, INBuilt 1949 · S/N 108-4689 N6729MMid Atlantic Air Museum · Reading, PABuilt 1948 · S/N 108-4729 N6825MSoutheastern Aero LLC · Coats, NCBuilt 1948 · S/N 108-4825 N6905MMarquardt John Wayne · Angola, INS/N 108-4905 N6909MZarinnia Anthony · Chelsea, MIBuilt 1948 · S/N 108-4909 N71WKGoodwin Gerald C · Belton, SCBuilt 1947 · S/N 108-3711 N745CManiscalco Peter · Germansville, PABuilt 1947 · S/N 108-3745 N765CCarrion William J · Lawton, OKBuilt 1947 · S/N 108-3765 N775CHammons Daniel G · Vadnais Heights, MNBuilt 1947 · S/N 108-3775 N807CSieg Lee C · Truman, MNBuilt 1947 · S/N 108-3807 N822CHeathco Merle S · Scappoose, ORBuilt 1947 · S/N 108-3822 N833CTexter John F · Saint Ignace, MIBuilt 1947 · S/N 108-3833 N922CKay Bennie L · Brigham City, UTBuilt 1947 · S/N 108-3922 N929COkeefe Daniel R · Wasilla, AKBuilt 1947 · S/N 108-3929 N994CFlora Joseph A · Polk City, FLBuilt 1947 · S/N 108-3994

Back to Universal Stinson 108-3