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.

N1990BSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1948 · S/N 6417 N1999KSommers Bradley D · Robinson, KSBuilt 1947 · S/N 4726 N2004Brocato Barry J · Coronado, CABuilt 1956 · S/N 5937 N2011BBrandon Thomas C · Prospect, PABuilt 1948 · S/N 6438 N2011KChidester Leo S · Tremonton, UTBuilt 1947 · S/N 4738 N2020BLepkowski Daniel P · Industry, PABuilt 1948 · S/N 6447 N2021KJinkins Robert Lee · Silver Springs, MDBuilt 1947 · S/N 4748 N2025KByler Michael Jay · Mocksville, NCBuilt 1947 · S/N 4752 N2026KGibboney Scott H · Temecula, CABuilt 1947 · S/N 4753 N2028KHokuf Erik L · Bemidji, MNBuilt 1947 · S/N 4755 N2035KAnderson Raymond · Grass Valley, CAS/N 4762 N2038KWalker Ray A · Sanger, TXBuilt 1947 · S/N 4765 N2040KSchnelker William A · Fort Wayne, INBuilt 1947 · S/N 4767 N2042KDalzell Dean M · Donnelly, IDBuilt 1947 · S/N 4769 N2043KHyde Todd S · Loon Lake, WABuilt 1947 · S/N 4770 N2045KTyler Walter M · Canoga Park, CABuilt 1947 · S/N 4772 N2047KTr Pegasus · Glenwood, NJS/N 4774 N2052KCromley Mark C · Lewisburg, PABuilt 1947 · S/N 4779 N2057KMoghadam Jack · Ann Arbor, MIBuilt 1947 · S/N 4784 N2059KHunt Abby L · Leary, GABuilt 1947 · S/N 4786 N2066BAeschlimann Stephen · Show Low, AZBuilt 1948 · S/N 6493 N2070BGilbert Jill W · Kingfisher, OKBuilt 1948 · S/N 6497 N208DLRegistered aircraftBuilt 1947 · S/N 5478 N2101KGleitz Jay D · Longmont, COBuilt 1947 · S/N 4828 N2117KTemptation Motors Ltd · Hayward, CABuilt 1947 · S/N 4844 N2118BGahagan Stanley A · Jacksonville, TXBuilt 1949 · S/N 6545 N2159BRappa Giovanni · Hampton, VABuilt 1949 · S/N 6586 N2189BBolton Derwin B · Jacksonville, TXS/N 6616 N22004Emory Robert N · Fort Mohave, AZBuilt 1938 · S/N 854 N221BKThielen Andrew J · Atlantic, IABuilt 1947 · S/N 5288 N2225KJohnson Brian O · Alexandria, VABuilt 1947 · S/N 4952 N2229KProffett Paul G · Jupiter, FLBuilt 1947 · S/N 4956 N2231KBishop Elijah Ar · Ukiah, CABuilt 1947 · S/N 4958 N2243BSlys Aircraft Service · Platte, SDBuilt 1950 · S/N 6670 N2271KWarner Isaac F · Three Rivers, CABuilt 1947 · S/N 4998 N2281KWest Jack T · Lamar, COBuilt 1947 · S/N 5008 N2282KGivens Benjamin T · Ruffin, SCBuilt 1947 · S/N 5009 N2284KLind Ronald C · Rainier, WABuilt 1947 · S/N 5011 N2290KHansen Christian F · Tucson, AZBuilt 1947 · S/N 5017 N2294KRicks Rebecca G · Hot Springs, ARS/N 5021 N2295KObrien A Scott · Camarillo, CABuilt 1947 · S/N 5022 N2299KRusinowski Steve · Royal Oak, MIBuilt 1947 · S/N 5026 N2302KHartman Alfonse A · Mc Alpin, FLBuilt 1947 · S/N 5029 N2305KScimone Michael J · Wildwood, MOS/N 5032 N2306KSchlosser Joseph V · Rockford, MNBuilt 1947 · S/N 5033 N2312KDavey Kenneth E · Lake Crystal, MNBuilt 1947 · S/N 5039 N2320KBolton Derwin B · Jacksonville, TXBuilt 1947 · S/N 5047 N2336KAhlers Walter P Jr · Hackettstown, NJBuilt 1947 · S/N 5063 N2351KYoung Anthony J · Saint Cloud, MNBuilt 1947 · S/N 5078 N2366KMiller Joey M · San Antonio, TXS/N 5093

Back to Luscombe 8E