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.

N1319KJames Dennis K · La Crosse, VABuilt 1946 · S/N 4046 N1321BReck Robert Cody · Cameron, MTBuilt 1948 · S/N 5948 N1323BMoyer Alan L · Perkasie, PABuilt 1948 · S/N 5950 N1325BRemax Flying Club · West Plains, MOBuilt 1948 · S/N 5952 N1325KGilpin Nathan L · Cornelia, GABuilt 1946 · S/N 4052 N1327Anderson Mark A · Bates City, MOS/N 801 N1329KCarson Ronald G · San Antonio, TXBuilt 1946 · S/N 4056 N1330BKazamias Evangelios · Niles, ILBuilt 1948 · S/N 5957 N1331KCarlson Carl A · Geneva, NYS/N 4058 N1333KSenkair LLC · Sylvester, GABuilt 1946 · S/N 4060 N1336BDeckett William H · East Tawas, MIBuilt 1948 · S/N 5963 N1343BSchneider David W · Richfield, MNS/N 5970 N1343KVyfvinkel Frederick J · New Smyrna Beach, FLBuilt 1946 · S/N 4070 N1345KCollins Camden B · Millersport, OHBuilt 1946 · S/N 4072 N1350KLewis John E · Claytonon, NJBuilt 1946 · S/N 4077 N1354KDenicola Michael B · Ruidoso, NMBuilt 1946 · S/N 4081 N1356KAnderson Andrew A · Bates City, MOS/N 4083 N1358KUllman Holdings LLC · Fort Myers, FLS/N 4085 N1359KRooster Aviation LLC · Payson, UTS/N 4086 N1360KFinney Kevin A · Hawthorne, FLBuilt 1946 · S/N 4087 N1364KYager Stuart O · Wellington, KSBuilt 1946 · S/N 4091 N1365KWesterberg Roger K · Cottage Grove, MNBuilt 1946 · S/N 4092 N1378KHebron Jeffrey N · Trenton, SCBuilt 1946 · S/N 4105 N1380KKoebel Allan Trustee · High Ridge, MOBuilt 1946 · S/N 4107 N1382KPierce Larry J · Moxee, WABuilt 1946 · S/N 4109 N1387KFlurry Richard · Piedmont, OKS/N 4114 N1394KRohleder Joseph · La Salle, COS/N 4121 N1396KNelson Daniel N · Newark, ILBuilt 1946 · S/N 4123 N1399KSattelmayer Ralph · Sacramento, CABuilt 1946 · S/N 4126 N13CQCajun Queen 8a LLC · Ormond Beach, FLBuilt 1946 · S/N 3867 N1400KKush John J Jr · Oil City, PABuilt 1946 · S/N 4127 N1412KHarvey Donald L · Wheeling, WVBuilt 1946 · S/N 4139 N1413KBennett Robert M · Felton, DEBuilt 1946 · S/N 4140 N1420KMolohan Ronald M · Elk Grove, CABuilt 1946 · S/N 4147 N1423KEnglund Ronald E · Springfield, ORBuilt 1946 · S/N 4150 N1424KStarke Daniel L · Odessa, TXRegistration revokedBuilt 1946 · S/N 4151 N1426KDavis John E · Fairland, INBuilt 1946 · S/N 4153 N1428KNordby Bonin S · Nampa, IDS/N 4155 N1434BGraznak Timothy C · Greeley, COS/N 6061 N1434KRobertson Claude A · Phoenix, AZS/N 4161 N1435BHarpham Verdon R · Boyden, IARegistration revokedBuilt 1948 · S/N 6062 N1435KAmmons H B · Sanford, NCRegistration revokedBuilt 1946 · S/N 4162 N1439KEigsti Rodney E · Friend, NES/N 4166 N1440KTucker James M Jr · Headland, ALBuilt 1946 · S/N 4167 N1441BRon Alexander Youth Aviation Program · Williamson, GABuilt 1948 · S/N 6068 N1442KGibbs Lena R · Eagle River, AKBuilt 1946 · S/N 4169 N1445KHutson David A · Northport, ALBuilt 1946 · S/N 4172 N1448KBentch James R · Lincoln, MOBuilt 1946 · S/N 4175 N144BRLeighton Michael L · Saco, MEBuilt 1946 · S/N 3695 N1451KAnderson Mark A · Bates City, MOS/N 4178

Back to Luscombe 8A