Skip to content

Registered aircraft · 897

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 ('8190104', '8190111')
  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 ('8190104', '8190111')
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.

N23036Misulich Mark D · Lawrenceburg, INBuilt 1939 · S/N 959 N23042Moore P Ladon · Byron, GABuilt 1939 · S/N 1004 N23053Reed Thomas F · Maize, KSBuilt 1939 · S/N 976 N23057English Don C · Richland, ORBuilt 1939 · S/N 981 N23063Krolikowski Ryszard · West Milford, NJBuilt 1939 · S/N 987 N23074Davis Jeffrey W · Fairhaven, MABuilt 1939 · S/N 998 N23079Braswell Charles A Jr · Taylorsville, NCS/N 1003 N23090Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 1014 N23093Carolina Aero Tech LLC · Hilton Head Island, SCBuilt 1939 · S/N 1017 N2315KWelch Christopher M · Bozeman, MTBuilt 1947 · S/N 5042 N2324KBrewer George F II · Colorado Springs, COBuilt 1947 · S/N 5051 N2325KN2325k LLC · Newport, MEBuilt 1947 · S/N 5052 N2336Baumann Keith A · Fairfield, ILBuilt 1938 · S/N 812 N2337KDaphna Inc · Middletown, DEBuilt 1947 · S/N 5064 N2340KMistysyn Scott D · Pottsville, PABuilt 1947 · S/N 5067 N2342KCole Mark L · Farmington, NMBuilt 1947 · S/N 5069 N2354KHeinz Dennis M · Carnesville, GABuilt 1947 · S/N 5081 N25100Bragg Scott T · Salem, ORBuilt 1939 · S/N 1024 N25103Eric Forsman · Corvallis, ORBuilt 1939 · S/N 1027 N25106Petro Jerry R · Williamsburg, VAFirst renewal noticeBuilt 1939 · S/N 1030 N25108Chakerian Gregory V · Hollister, CABuilt 1939 · S/N 1032 N25127Rust Roger · Jerseyville, ILBuilt 1939 · S/N 1051 N25128Holt Kenneth G Jr · Upper Marlboro, MDBuilt 1939 · S/N 1052 N25138Emig Terry L · Casa Grande, AZBuilt 1939 · S/N 1062 N25142King Rachel G · Gainesville, FLBuilt 1939 · S/N 1066 N25144Freeman Roger M · Kingsbury, TXBuilt 1939 · S/N 1068 N25147Prairie Aero LLC · Elgin, ILBuilt 1939 · S/N 1071 N25154Registration Pending · Jamestown, INRegistration pendingBuilt 1939 · S/N 1078 N25164Wright Ronald E · Overland, MOBuilt 1939 · S/N 1088 N25165Harkness Kathy A · Denton, MDBuilt 1939 · S/N 1089 N25174Wighton Harold B · Bloomer, WIBuilt 1939 · S/N 1098 N25178Stechschulte George H · Bluffton, OHS/N 1102 N25215Harkness Kathy A · Denton, MDBuilt 1939 · S/N 1120 N25231Atkinson James A · Bouse, AZS/N 1136 N25236Drake Randy L · Greenfield, INBuilt 1940 · S/N 1141 N25263Smith James G · Cherry Valley, ILBuilt 1940 · S/N 1170 N25267Prevost Ronald J · Denham Springs, LABuilt 1940 · S/N 1174 N25274Thompson Ralph L · Petersburg, PABuilt 1940 · S/N 1181 N25288Voelbel John H · Bristol, NHBuilt 1945 · S/N 1195 N25289Dunn Miles H · Ellsworth, MEBuilt 1940 · S/N 1196 N25291Belton Aviation Maintenance Services LLC · Belton, SCBuilt 1940 · S/N 1198 N25297Lowry Wilson R · Leonardtown, MDBuilt 1940 · S/N 1204 N25333Flying Ace LLC · Lakeville, MNS/N 1209 N25345Stevens Sean P · Creswell, ORBuilt 1940 · S/N 1221 N25366Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1940 · S/N 1242 N25376Cosgrove Mark A · Grand Ledge, MIBuilt 1940 · S/N 1252 N2564KRamin Jeanette J · Houston, TXBuilt 1947 · S/N 5291 N2583KPolzin Allan E Jr · Corona, CABuilt 1947 · S/N 5693 N2585KWhitten Flying Service Equipment LLC · Snook, TXBuilt 1947 · S/N 5312 N2588KGleaton Joe W · Lizella, GAFirst renewal noticeS/N 5315

Back to Luscombe 8A