Skip to content

Registered aircraft · 433

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

N1000MValdez Raymond G · Las Vegas, NMS/N 108-3741 N1083JBeerman William C · Raleigh, NCBuilt 1948 · S/N 108-4776 N108ABOlree Richard N Jr · Hillman, MIBuilt 1948 · S/N 108-4171 N108BTFlying J Aviation LLC · Lynden, WABuilt 1948 · S/N 108-4045 N108CMCardinal Aviation LLC · Gaines, MIBuilt 1948 · S/N 108-4723 N108KDPayne Steven H · Nine Mile Falls, WABuilt 1949 · S/N 1084963 N108LBHauser Scott R · Towanda, PAS/N 108-4811 N108RDClassic Air LLC · Lititz, PABuilt 1948 · S/N 108-4523 N108RMFernandez Taylor R · Wasilla, AKBuilt 1948 · S/N 108-5257 N108SVEnsign Development Co LLC · Leavenworth, KSBuilt 1948 · S/N 1084165 N108SWExpress Air LLC · Wilmington, DEBuilt 1949 · S/N 1084715 N108WGFichtner Eric · Concord, NCBuilt 1948 · S/N 1084124 N108WHMarshall Robert L · Pine River, MNBuilt 1986 · S/N 108-4985 N108WSSpence William D · Waller, TXBuilt 1948 · S/N 108-4502 N10ZPFormosa Lloyd A · Delta Junction, AKBuilt 1948 · S/N 108-4505 N121NAyo Johnny D · Mount Zion, GABuilt 1948 · S/N 108-4449 N123TYNorrish Tyler E · Grapeview, WABuilt 1948 · S/N 108-5212 N132QAndrews Dan C · Weatherly, PABuilt 1947 · S/N 1084052 N17WSWise River Aviation LLC · Three Forks, MTS/N 108-4499 N180LYFischer Bruce M · Sun Prairie, WIBuilt 1949 · S/N 108-4486 N214DBTudosie Catalin Trustee · Lake Arrowhead, CABuilt 1948 · S/N 1084517 N2243MHesse Stephen R · Anaheim, CAS/N 108-4127 N235DEAcro Aviation LLC · Littleton, COBuilt 1948 · S/N 108-4566 N25LWEverest John D · Bailey, COBuilt 1948 · S/N 108-4973 N38103Omlid Robert L · Watford City, NDS/N 1083800 N4006CLovitt Cole A · Douglas, WYBuilt 1948 · S/N 108-5006 N4008COlree Richard N Jr · Hillman, MIBuilt 1948 · S/N 108-5008 N4011CI-Five Inc · Carpenter, WYBuilt 1948 · S/N 108-5011 N4014CEverett James S · Wyoming, MNBuilt 1948 · S/N 108-5014 N4015CFranklin Jon P · Lopez Island, WAS/N 108-5015 N4016CThomas Craig M · Carrollton, OHBuilt 1948 · S/N 108-5016 N4022CGriffith William A · Gainesville, GABuilt 1948 · S/N 108-5022 N4023CYoung Christina Marie · Anchorage, AKBuilt 1948 · S/N 108-5023 N4029CRosson Herbert M Jr · Friendswood, TXBuilt 1948 · S/N 108-5029 N4035CMcmanigle James W · Proctor, VTBuilt 1948 · S/N 108-5035 N4037CHigdem Dane M · Kimberly, IDS/N 108-5037 N4041CRydberg Lawrence · Albuquerque, NMBuilt 1949 · S/N 108-5041 N4045CYoung David E · Wasilla, AKBuilt 1949 · S/N 1085045 N4046CWilliams Robert M · Red Hook, NYBuilt 1949 · S/N 108-5046 N4053CPossenti Wynola J · Fairbanks, AKBuilt 1949 · S/N 108-5053 N4054CWeber Charles A · Marion, IABuilt 1949 · S/N 108-5054 N4064CKiteley Steven M · Longmont, COBuilt 1950 · S/N 108-5064 N4066CSnavely Deborah B · Lake Placid, FLBuilt 1949 · S/N 108-5066 N4068CAsh Christian R · Ellison Bay, WIBuilt 1949 · S/N 108-5068 N4070CMccormick Janet · Mckenna, WABuilt 1949 · S/N 108-5070 N4072COrians Brian E · Medina, OHBuilt 1949 · S/N 108-5072 N4077CSparks James R · Lewisburg, WVS/N 108-5077 N4078CRegistered aircraftBuilt 1949 · S/N 108-5078 N4094CHay Curtis J · Alamo, GABuilt 1949 · S/N 108-5094 N4097CSale Reported · Lancaster, TXSale reported, pending cancellationBuilt 1953 · S/N 108-5097

Back to Stinson 108-3