Skip to content

Registered aircraft · 213

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

N839CRegistration Pending · Corsicana, TXRegistration pending, canceledBuilt 1947 · S/N 1083839 N8468KEdwards Scott H Trustee · Columbus, MTBuilt 1946 · S/N 108-1468 N8472KAirport Farms Aviation LLC · Tarkio, MOBuilt 1946 · S/N 108-1472 N8502Sherwood Ryan D · Granger, INBuilt 1947 · S/N 108-1502 N8547KTrudell Zackary J · Inchelium, WAS/N 108-1547 N8623KMclaughlin J P · Salem, ORBuilt 1947 · S/N 108-1623 N8758KRose William C · Rye, NHBuilt 1947 · S/N 108-1758 N87601Simonds Wayne · Pueblo, COS/N 108-2 N87607Johnson Zachary M · Eagle River, AKBuilt 1945 · S/N 108-8 N87608Galloway Adam L · New Richmond, WIBuilt 1945 · S/N 108-9 N8879KKantor Philip S · Canonsburg, PABuilt 1947 · S/N 108-1879 N8942KCooper Melvin Russell Jr · Prineville, ORS/N 108-1942 N8978KSchler Joseph B · Reno, NVS/N 108-1978 N9041KKeim Michael A · Wasilla, AKBuilt 1947 · S/N 108-2041 N9043KMcelligott Lee M · North Powder, ORS/N 108-2043 N9051KSchriber Burton R · Taunton, MABuilt 1947 · S/N 108-2051 N9070KMattson Scott D · Zimmerman, MNBuilt 1947 · S/N 108-2070 N908CTrax Eric E · Vero Beach, FLBuilt 1947 · S/N 108-3908 N9090KD'Alo Allan R · Norwalk, CABuilt 1950 · S/N 108-2090 N9109KCampbell Christopher · Talkeetna, AKBuilt 1947 · S/N 108-2109 N9125KJessop Herman · Cedar City, UTBuilt 1947 · S/N 108-2125 N9133KOwens Benny F · Mounds, ILBuilt 1947 · S/N 108-2133 N9198KKing Barbara J · Strykersville, NYBuilt 1947 · S/N 108-2198 N9253KJohnson Gregory J · Port Orange, FLBuilt 1947 · S/N 108-2253 N9391KKing Jeffrey L · Lincoln, NEBuilt 1947 · S/N 108-2391 N9406KSilliman Peter D · Georgetown, INBuilt 1947 · S/N 108-2406 N9432KHumes James M · Adkins, TXBuilt 1947 · S/N 108-2432 N9473KSchatz Nikolos · Seward, AKBuilt 1947 · S/N 108-2473 N9478KKainu William M · Santa Rosa, CABuilt 1947 · S/N 108-2478 N9538KGrove Glenn K · Maple Valley, WABuilt 1947 · S/N 108-2538 N9550KEicher Bruce R Trustee · Wilsonville, ORBuilt 1947 · S/N 108-2550 N9595KVeesart Ryland P · Los Osos, CABuilt 1947 · S/N 108-2595 N9612KHiner Hugh Dennis · Angola, INBuilt 1947 · S/N 108-2612 N9618KGatto Robert · Basking Ridge, NJBuilt 1947 · S/N 1082618 N97009Schillace Michael A · Gulf Shores, ALBuilt 1946 · S/N 108-1009 N97028Royalty Chris M · Danville, KYBuilt 1946 · S/N 108-1028 N97068Britton Martin · Redlands, CABuilt 1946 · S/N 108-1068 N97140Bruckelmeyer Charles J · Zanesville, OHBuilt 1946 · S/N 108-140 N97162James David R · Wayne, MIFirst renewal noticeS/N 108-162 N97164Colorado Classic Aircraft LLC · Longmont, COS/N 108-164 N97175Kranz Stanley A · Java Village, NYBuilt 1946 · S/N 108-175 N97179Gerker Robert J · League City, TXBuilt 1946 · S/N 108-179 N97185James David R · Wayne, MIBuilt 1946 · S/N 108-185 N97194King Daddy Aviation LLC · Madison, MSS/N 108-194 N97198Jordan Martinez Tyler J · Chandler, AZS/N 108-198 N97203Tovsen Jim P · Anchorage, AKBuilt 1946 · S/N 108-203 N97207Ashley James M · Greenwood, SCBuilt 1946 · S/N 108-207 N97215Taylor Terry D · Fleming Island, FLBuilt 1946 · S/N 108-215 N97223Ayresouth Aviation Inc · Lithia Springs, GABuilt 1946 · S/N 108-223 N97232Elks Virginia L · Chocowinity, NCBuilt 1946 · S/N 108-232

Back to Stinson 108