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.

N2368KBolog Keith · Kenosha, WIS/N 5095 N2375KPowell Larry C · Fresno, CABuilt 1947 · S/N 5102 N2388KAbercrombie Andrea D · Eatonton, GABuilt 1947 · S/N 5115 N2399KMoriarty Joseph B · Madbury, NHBuilt 1947 · S/N 5126 N2401KLemons Brooks D · Visalia, CABuilt 1947 · S/N 5128 N2402YShepard John A · Thornville, OHS/N 5129 N2414KCahill Michael F · Batavia, OHBuilt 1947 · S/N 5141 N2415KCekinovich Ted M · Machesney Park, ILBuilt 1947 · S/N 5142 N2419KMccann Michael · Springfield, ORBuilt 1947 · S/N 5146 N2420KNewhouse Hayden V · Fredericksburg, TXS/N 5147 N2423KDarley Vernon O · Peachtree City, GABuilt 1947 · S/N 5150 N2433XPoklar Norman A · Mount Orab, OHS/N 5160 N2438KSchwister Steven W · Forest Lake, MNBuilt 1947 · S/N 5165 N2442KSpirit Aviation N231az LLC · Austin, TXBuilt 1947 · S/N 5169 N2449KBlack Charles Bernard · Lenoir, NCS/N 5176 N2450KBlue Cloud Aviation LLC · Turlock, CABuilt 1947 · S/N 5177 N2451KWheeler Brian K · Landenberg, PABuilt 1947 · S/N 5178 N2452KCottonwood Flying Club · Rockford, ILBuilt 1947 · S/N 5179 N2453KWalden Taylor G · Pueblo, COS/N 5180 N2455KBrice Beni H · Severna Park, MDBuilt 1947 · S/N 5182 N2456KSpalding Norman C · Sacramento, CABuilt 1947 · S/N 5183 N2457KWayne Alex A · Flowery Branch, GABuilt 1947 · S/N 5184 N2458KEigsti Rodney E Trustee · Friend, NEBuilt 1947 · S/N 5185 N2468KYarbrough Robert D · Cortez, COBuilt 1947 · S/N 5195 N2470KSucich John J · Belleville, MIBuilt 1947 · S/N 5197 N2471KMainero Tanner R · Chehalis, WABuilt 1947 · S/N 5198 N2485KKaplan Samuel · Santa Paula, CABuilt 1947 · S/N 5212 N2486KSolar Joseph R · Punta Gorda, FLBuilt 1947 · S/N 5213 N2487KKing Gary B · Suffolk, VABuilt 1947 · S/N 5214 N2488KBruton Bert L · San Angelo, TXS/N 5215 N2493KPydeski Joseph J · Dunedin, FLBuilt 1947 · S/N 5220 N2494KWilkie David J · Nashua, NHBuilt 1947 · S/N 5221 N2500KSchroder John Ted IV · Walnut Creek, CABuilt 1947 · S/N 5227 N2501KKnudson Eric C · Bozeman, MTBuilt 1947 · S/N 5228 N2503KMcfall Robert Leroy Trustee · Topeka, KSBuilt 1947 · S/N 5230 N2506KMccann Ryan J · Washington, DCBuilt 1947 · S/N 5233 N2512KShetter Justin M · Harrisburg, PABuilt 1947 · S/N 5239 N2514KSmith Jeffrey C · Asheboro, NCBuilt 1947 · S/N 5241 N2515KPatton John W · Mancos, COBuilt 1947 · S/N 5242 N2518KGolden Coast Airways Corp · Carolina, PRBuilt 1947 · S/N 5245 N2528KDrake Keith · Monroe, NCBuilt 1947 · S/N 5255 N2529KCully Dean F · Anchorage, AKBuilt 1947 · S/N 5256 N2547KSullivan Stephen G · Mize, MSBuilt 1947 · S/N 5274 N2548KBauer Keith F · Taneytown, MDS/N 5275 N2550KChildress David W · Coldwater, MSBuilt 1947 · S/N 5277 N25ERiedel Steven J · Homer, AKBuilt 1947 · S/N 5244 N2604KMcdowall Douglas D · No Little Rock, ARBuilt 1947 · S/N 5331 N2619KNortheast Cub LLC · Hudson, NYS/N 5346 N2622KMartin Stephen J · Jonestown, PABuilt 1947 · S/N 5349 N2623KGilger Steven · Dubois, IDBuilt 1947 · S/N 5350

Back to Luscombe 8E