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.

N45816Holley Donald W · Willis, TXBuilt 1946 · S/N 2343 N45817Nelson Braxton A · Paducah, KYS/N 2344 N4581MDaphna Inc · Middletown, DEBuilt 1945 · S/N 1936 N45823Phillips Keaton K · Rigby, IDBuilt 1946 · S/N 2350 N45839Stieber Joe · Brownwood, TXBuilt 1946 · S/N 2366 N45841Michaud Paul K · Forest Lake, MNBuilt 1946 · S/N 2368 N45842Feuge Philip R · Elgin, TXBuilt 1946 · S/N 2369 N45847Southwest Aero Tech LLC · Punta Gorda, FLBuilt 1946 · S/N 2374 N45851Guido Keith J · Saugerties, NYBuilt 1946 · S/N 2378 N45853Camacho Hector · Andover, KSBuilt 1946 · S/N 2380 N45872Smith Warren D · Oak Harbor, WABuilt 1946 · S/N 2399 N45886Craig Richard L · Sonoma, CABuilt 1946 · S/N 2413 N45890Rushing Kevin W · Marks, MSS/N 2417 N45893Rout Chester E · Mountain Home, ARBuilt 1946 · S/N 2420 N45896Stegman Robert A · Saint Peters, MOBuilt 1946 · S/N 2423 N45897Taylor Aaron L · Salado, TXBuilt 1946 · S/N 2424 N45903Phenis Christopher · Elkhart, INBuilt 1946 · S/N 2430 N45912Parker Henry Reed · Fairbanks, AKS/N 2439 N45924Grateful Endeavors LLC · Sandpoint, IDS/N 2451 N45930Dorr Martin · Strongsville, OHBuilt 1946 · S/N 2457 N45935Borszich Claude C · Phoenix, AZS/N 2462 N45939Ramin R Fred · Tomball, TXBuilt 1946 · S/N 2466 N45957Boisselle Joe C · White Swan, WAS/N 2484 N45964Terhune Thomas A · Wichita, KSBuilt 1946 · S/N 2491 N45972Schertz Edward J · Cahokia, ILBuilt 1946 · S/N 2499 N45974Ranger Aviation Inc · Burlington, COBuilt 1946 · S/N 2501 N45978Factor James Rodney · El Paso, TXS/N 2505 N45979Kreikemeier Terry L · Garfield, WAFirst renewal noticeS/N 2506 N45983Bedford Dennis L · Auke Bay, AKBuilt 1946 · S/N 2510 N45984Imbrock Timothy M · Nampa, IDBuilt 1946 · S/N 2511 N45991Dooley Steven P · Toughkenamon, PABuilt 1946 · S/N 2518 N45995Southard Hunter · Knob Noster, MOBuilt 1946 · S/N 2522 N45JSJohnson Christopher J · Tacoma, WABuilt 1945 · S/N 1948 N468ALLewis Seth · North Manchester, INS/N 3397 N51551Registration Pending · Hartford, SDRegistration pendingBuilt 1946 · S/N 2978 N515SFWebster David H T · Apache Junction, AZBuilt 1946 · S/N 3766 N51828Flannery Robert P · Durango, COBuilt 1947 · S/N 5287 N519SBSassy Brat LLC · Ormond Beach, FLS/N 2595 N528NSVanduynhoven Shawn · Trinity, ALS/N 1766 N579MGHaas Sean Francis · Yucca Valley, CAS/N 2479 N5896XQualitair LLC Trustee · MichelstadtS/N 2553 N5990PMoquin Thomas A · Hampshire, ILBuilt 1946 · S/N 2794 N62925L8 Aero LLC · Narberth, PAS/N 3393 N642TSNightingale Matthew · Rancho Cucamonga, CAS/N 4218 N681ARoberts Samuel K · Greenville, ALBuilt 1948 · S/N 5872 N698DKKellogg Darlene R · Kasilof, AKBuilt 1946 · S/N 2225 N71101Beasley Horace E · Columbia, SCBuilt 1946 · S/N 2528 N71103Muszala Robbyn · Tucson, AZBuilt 1946 · S/N 2530 N71115Weyrauch Brandin T · Williston, NDBuilt 1946 · S/N 2542 N71127Dillahunty Chris D · Fresno, CAS/N 2554

Back to Luscombe 8A