Skip to content

Registered aircraft · 285

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

N108MNPeterson Lucas J H · Danube, MNS/N 108-3259 N108WYRegistered aircraftBuilt 1947 · S/N 108-2444 N10CLDuffy James R · Boise, IDBuilt 1947 · S/N 108-2587 N147CWolverine Aviation LLC · Frankenmuth, MIS/N 108-3147 N159CFay William E · Washougal, WABuilt 1947 · S/N 108-3159 N161CMarler Ryan · Rexburg, IDS/N 1083161 N162CBradley Christopher · Juneau, AKS/N 108-3162 N165CWeakley Companies LLC · Poland, NYBuilt 1947 · S/N 108-3165 N168CSutton George Michael · Carmel Valley, CABuilt 1947 · S/N 108-3168 N171CCarpenter John H Jr · Malabar, FLBuilt 1947 · S/N 108-3171 N174CDurham Rex L · Blakely, GABuilt 1947 · S/N 108-3174 N175CRauber Paul C · Carmel By The Sea, CABuilt 1947 · S/N 108-3175 N176CPurvis David S · Fresno, CABuilt 1947 · S/N 108-3176 N177CSmith Happy E · Rogersville, TNBuilt 1947 · S/N 108-3177 N184CPatterson Charles R · Jeffersonville, INBuilt 1947 · S/N 108-3184 N187CHogan Mary · Forest Park, ILBuilt 1947 · S/N 108-3187 N18FWilcox Gilbert B · Somers, CTBuilt 1947 · S/N 108-3092 N195CWixom Jason D · Blackfoot, IDS/N 108-3195 N197CWilson Eric D · Fairbanks, AKS/N 108-3197 N198CStanton Jason H · Boise, IDBuilt 1947 · S/N 108-3198 N201CVlk Mark J · Moses Lake, WAS/N 108-3201 N202CLuft Aviation Inc · Wilmington, DEBuilt 1947 · S/N 108-3202 N209CRezin David L · Warrens, WIBuilt 1947 · S/N 108-3209 N211ZBell Scott · Mc Alpin, FLBuilt 1947 · S/N 108-2838 N216CIreland James L · Fort Worth, TXBuilt 1947 · S/N 108-3216 N220CSparks James D · Glennallen, AKBuilt 1947 · S/N 108-3220 N221CKappel Alea · Wasilla, AKBuilt 1947 · S/N 108-3221 N224CMerritt Daniel D · Graham, WABuilt 1947 · S/N 108-3224 N227CKisela Andrew J DBA · Tecumseh, MIBuilt 1947 · S/N 108-3227 N240CAvenger Educators LLC · Wilmington, DEBuilt 1947 · S/N 108-3240 N242CFoss Jared K · Greenbush, MNBuilt 1947 · S/N 108-3242 N243CK R T Aviation LLC · Tulsa, OKBuilt 1947 · S/N 108-3243 N246CChristopher R Keene · Weedsport, NYBuilt 1947 · S/N 108-3246 N247CRegistered aircraftBuilt 1947 · S/N 108-3247 N248CKomko Richard D · Spanaway, WAS/N 108-3248 N261CMarshall Bob L · Pine River, MNBuilt 1947 · S/N 108-3261 N2721LGodke John Michael · Titusville, FLBuilt 1947 · S/N 108-2721 N275CLowe Butch · Naples, FLBuilt 1947 · S/N 108-3275 N283CFarwell Jesse R · Albion, NYBuilt 1947 · S/N 108-3283 N291CNylund Michael K · Wasilla, AKBuilt 1947 · S/N 108-3291 N292CStephens Thomas A · Baton Rouge, LABuilt 1947 · S/N 108-3292 N293CTroedson Wesley M · Richfield, MNBuilt 1947 · S/N 108-3293 N299CCarr Steven F · Wasilla, AKBuilt 1947 · S/N 108-3299 N3076KBergeron Harvey E · North Conway, NHBuilt 1947 · S/N 108-3076 N311CFryer Properties LLC · Fort Worth, TXBuilt 1947 · S/N 108-3311 N316CTuttle Jacob · Graham, WAS/N 108-3316 N326CTipton Hugh Anthony · Mina, NVBuilt 1947 · S/N 108-3326 N32CVAero 32 LLC · Port Orange, FLBuilt 1947 · S/N 108-3032 N330CLemire Lee M · Oregon City, ORBuilt 1947 · S/N 108-3330 N332CMarks William D · Highland, MIBuilt 1948 · S/N 108-3332

Back to Stinson 108-2