Skip to content

Registered aircraft · 326

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

N1003KScott Michelle · Vallejo, CABuilt 1946 · S/N 3730 N1050KLynden Aeronautical Services LLC · Lynden, WABuilt 1946 · S/N 3777 N1078KClairday Preston H · Melbourne, ARS/N 3805 N1109BWeymouth James H · Jackson, MIBuilt 1947 · S/N 5736 N110QSilvaire Air LLC · Gun Barrel City, TXBuilt 1948 · S/N 5983 N1114BGiddens Ronald E · Boynton Beach, FLS/N 5741 N1118BFraser Christopher D · Gig Harbor, WABuilt 1947 · S/N 5745 N1145KSheehan Sean M · Hampstead, NCBuilt 1946 · S/N 3872 N1160BMees Martin B · Eagle River, AKBuilt 1947 · S/N 5787 N1162KKruckeberg Leroy A · Sanford, NCBuilt 1946 · S/N 3889 N1183KRobinson Stephanie L · Ventura, CABuilt 1946 · S/N 3910 N1199BBowen Allan R · Brockport, NYS/N 5826 N1201KVillaurrutia Carlos · Mcallen, TXBuilt 1946 · S/N 3928 N1216BBrown Carl E Jr · Milan, ILS/N 5843 N1235KWheeler Brian K · Landenberg, PABuilt 1946 · S/N 3962 N1268KDanielson Bradley K · Sunburg, MNBuilt 1946 · S/N 3995 N1273KWhitlock Paul H · Kent, WAS/N 4000 N1298BJury Steven T · Fresno, CABuilt 1947 · S/N 5925 N1302BSns Flyers LLC · Salinas, CABuilt 1948 · S/N 5929 N130RHHendry Rickey William · Apple Springs, TXS/N 5935 N1314BHildebrant Steven C · Newborn, GABuilt 1948 · S/N 5941 N1337BLerille Mark J · Lafayette, LAS/N 5964 N1346BFugate David W · Hamilton, OHBuilt 1948 · S/N 5973 N1347BCorley Charles P · Wesley Chapel, FLBuilt 1948 · S/N 5974 N1350BHeiderscheidt Sam T · Hector, MNBuilt 1948 · S/N 5977 N1353BShaw James J · Loranger, LABuilt 1948 · S/N 5980 N1354BStieber Joe · Brownwood, TXBuilt 1948 · S/N 5981 N1357BHall Frederick R · Marana, AZS/N 5984 N1358BBoyko Seth · Ruso, NDS/N 5985 N1360BMcmillian Custom Service Inc · Waynesboro, GABuilt 1948 · S/N 5987 N1381BJames Dennis · Pleasant Grove, CAS/N 6008 N1390BSowers Harry D · S Bloomingvil, OHBuilt 1948 · S/N 6017 N1398KSale Reported · Inola, OKSale reportedBuilt 1946 · S/N 4125 N1400BIler Elden · Van Nuys, CAS/N 6027 N1401BSummers Greg D · Sheridan, ORBuilt 1948 · S/N 6028 N1402BSlys Aircraft Service · Platte, SDBuilt 1948 · S/N 6029 N1406BBadenhorse Frans · Hawthorne, FLBuilt 1948 · S/N 6033 N1407BAufdencamp Timothy E · Bloomdale, OHBuilt 1948 · S/N 6034 N1416BGould Aaron J · Aptos, CABuilt 1948 · S/N 6042 N1418BGrewell Ronald V · West Carrollton, OHBuilt 1948 · S/N 6045 N1419BHattan John A · Goddard, KSBuilt 1948 · S/N 6046 N1420BWeber Joel A · Goddard, KSBuilt 1948 · S/N 6047 N1442BWilliams Michael · Hartsville, INBuilt 1948 · S/N 6069 N1444BPoklar Norman · Mount Orab, OHS/N 6071 N1454BWithrow Thomas E · Lewisburg, WVS/N 6081 N1463BRegistered aircraftRegistration pendingBuilt 1945 · S/N 6090 N1467BNielsen Jeffrey S · Ashland, ORS/N 6094 N1492BRegistration Pending · Castle Pines, CORegistration pendingS/N 6119 N1520BRegistration Pending · Fort Worth, TXRegistration pending, canceledBuilt 1948 · S/N 6147 N1521BAnderson Andrew A · Bates City, MOS/N 6148

Back to Luscombe 8E