Skip to content

Registered aircraft · 338

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

N1038BCooper Gerald W · Kennewick, WABuilt 1946 · S/N 108-1020 N108GBusk Richard L · Anchorage, AKS/N 108-1751 N125HKCarter Steven R · Bend, ORBuilt 1947 · S/N 108-2056 N136SPSivils Richard Christopher · Healy, AKBuilt 1946 · S/N 108-931 N1947SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1947 · S/N 108-1719 N2070CKnutson Wayne R · Thompson, NDS/N 108-1004 N211CWells Sherry A Trustee · Ferndale, MIS/N 108-1965 N2642Edwards Whit · Brookland, ARBuilt 1947 · S/N 108-1515 N2643Norman Robert A · Zanesville, OHS/N 108-1516 N35VMGatward Alan J · Fox Island, WABuilt 1947 · S/N 108-2138 N40123Gerardi Joseph A · Savannah, GABuilt 1946 · S/N 108-53 N40143Smith David R · Tracy, MNS/N 108-73 N40182Trudnak Michael W · Mansfield Center, CTBuilt 1946 · S/N 108-112 N413CWalters Thomas D · Winnsboro, TXBuilt 1947 · S/N 108-3413 N4425PJames Charles · Healdsburg, CAS/N 108-755 N71XPetram William A Trustee · Willow, AKBuilt 1946 · S/N 108-1285 N734SCCarden Keith B · Irvington, ALBuilt 1947 · S/N 108-2101 N79JFoote Charles A · Apache Junction, AZS/N 108-1675 N8100KSnodgrass Richard T · Simpsonville, KYBuilt 1947 · S/N 108-3100 N8135KHead In The Clouds LLC · Ogden, UTBuilt 1946 · S/N 108-1135 N8140KSimply Living LLC · Fort Myers, FLS/N 108-1140 N8159KQ G Aviation Of America Inc · Fort Collins, COBuilt 1946 · S/N 108-1159 N8164KSkora Leslie · King Salmon, AKBuilt 1946 · S/N 108-1164 N8169KElkins Aerial LLC · Palmer, AKBuilt 1947 · S/N 108-1169 N8174KBy The Seat Corp · Wilmington, DEBuilt 1946 · S/N 108-1174 N8179KTerrell Mark E · Greentown, INBuilt 1946 · S/N 108-1179 N8189KForrest Jeffrey H · Bloomfield Hills, MIBuilt 1946 · S/N 108-1189 N8192KHerman Aaron T · Bryan, OHBuilt 1946 · S/N 108-1192 N8196KSmedsmo Darrin A · Roseau, MNS/N 1196 N8198KKroenke Seth M · Palmer, AKBuilt 1946 · S/N 108-1198 N8202KMaley Michael P · La Mesa, CABuilt 1946 · S/N 108-1202 N8205KAlsworth Glen R Jr · Port Alsworth, AKBuilt 1946 · S/N 108-1205 N8206KJohnson Brett C · Spotsylvania, VABuilt 1946 · S/N 108-1206 N8212KMckinney Charles A · Indiana, PAS/N 108-1212 N8213KWow Construction Inc · Kingsland, TXS/N 108-1213 N8216KWarbirds Of The World Air Museum · Los Lunas, NMS/N 108-1216 N8230KNylund Michael K III · Wasilla, AKBuilt 1946 · S/N 108-1230 N8233KDuncan Nelson L · Gladstone, MOBuilt 1946 · S/N 108-1233 N8238KMccann Michael H · Springfield, ORBuilt 1946 · S/N 108-1238 N8243KSchmidt Bradley E · Erlanger, KYBuilt 1946 · S/N 108-1243 N8245KStandefer Wayne B · Italy, TXBuilt 1946 · S/N 108-1245 N8258KCard Robert H II · Kenedy, TXBuilt 1946 · S/N 108-1258 N8266KJilek Dominic A · River Falls, WIBuilt 1946 · S/N 108-1266 N8273KCocuzza James · Hilton, NYBuilt 1946 · S/N 108-1273 N8274KRoberts Scott · Deland, FLBuilt 1946 · S/N 108-1274 N8275KHeller Richard D · Marengo, IABuilt 1946 · S/N 108-1275 N8286KLambert James A · Enumclaw, WAS/N 1081286 N8288KGreen Judy Ann · Arcadia, CABuilt 1946 · S/N 108-1288 N8293KAndreasen Eric E · Lompoc, CAS/N 1081293 N8299KCrutchfield Jeremy · Owasso, OKS/N 108-1299

Back to Stinson 108-1