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.

N45594Morris Aaron J · Newman Lake, WAS/N 2121 N45595Gillman Ryan J · Hamburg, NYBuilt 1946 · S/N 2122 N45598Makepeace Mike C · El Dorado, ARBuilt 1946 · S/N 2125 N45604Gavlak Edward C · Cincinnati, OHBuilt 1946 · S/N 2131 N45610Johnson Leslie R · Saint Paul, MNBuilt 1946 · S/N 2137 N45619Swager Garren J · Rancho Cucamonga, CABuilt 1946 · S/N 2146 N45628Erl Don L · Medford, WIS/N 2155 N45634Sittig Robin A · Sioux Falls, SDBuilt 1946 · S/N 2161 N45635Whitmore Alex · Terlingua, TXBuilt 1946 · S/N 2162 N45641Miller Erik J · Gilbert, AZBuilt 1946 · S/N 2168 N45642Clough Douglas P · Graham, WABuilt 1946 · S/N 2169 N45647Beatty Rose E · Hollister, CABuilt 1946 · S/N 2174 N45651Atkinson Karl A · Athol, IDBuilt 1946 · S/N 2178 N45653Lewis Bruce E · Oxford, MEBuilt 1946 · S/N 2180 N45658Scheevel Thomas E · Preston, MNFirst renewal noticeBuilt 1946 · S/N 2185 N45661Andrasik William J · Sagamore Hills, OHBuilt 1946 · S/N 2188 N45664Powell James A · Zanesville, OHBuilt 1946 · S/N 2191 N45666Sierens Stephen E · Deland, FLBuilt 1946 · S/N 2193 N45668Brooks William L · Vienna, VABuilt 1946 · S/N 2195 N45669Whetzel Herbert H · Clarkesville, GAS/N 2196 N45671Macpherson Ursula A · Lagrangeville, NYBuilt 1946 · S/N 2198 N45675Flory David M · Stillwater, MNBuilt 1946 · S/N 2202 N45680Brown Thomas L · Hartford, WIBuilt 1946 · S/N 2207 N45683Worm Gary L · Adona, ARBuilt 1946 · S/N 2210 N45688Snead John S · Crescent City, FLBuilt 1946 · S/N 2215 N45694Deal Clarence N · Jonesboro, GAS/N 2221 N45701Hurlbert Vernon L · Anchorage, AKBuilt 1946 · S/N 2228 N45707Oklahoma Warbird Aviation LLC · Oklahoma City, OKS/N 2234 N45719Mustard Aviation LLC · Lovington, NMBuilt 1946 · S/N 2246 N45721Registered aircraftAssigned, pending cancellationS/N 2248 N45722Bergen Henry E · Fond Du Lac, WIBuilt 1946 · S/N 2249 N45725Ude James K · Waterford, CABuilt 1946 · S/N 2252 N45729Dietz Dale Gerard · Chesterfield, MOBuilt 1946 · S/N 2256 N45730Greene Robert M · Limestone, TNS/N 2257 N45736Ramin Reuben F · Tomball, TXBuilt 1946 · S/N 2263 N45740Ducut Justin Joseph · Upland, CABuilt 1946 · S/N 2267 N45749Henley Charles D · New London, NCS/N 2276 N45750Carter Casey C · Sanger, TXBuilt 1946 · S/N 2277 N45754Edmiston Brandon Lee · Murray, KYBuilt 1946 · S/N 2281 N45755Davisson Paul V · Jupiter, FLBuilt 1946 · S/N 2282 N45765Jhaco LLC · Lake Charles, LAS/N 2292 N45766Gallette John B · Edgewood, NMBuilt 1946 · S/N 2293 N45768Wilkie David J · Nashua, NHBuilt 1946 · S/N 2288 N45771Lindee Douglas L · Deer Park, WIBuilt 1946 · S/N 2298 N45781Darden Jesse R · Nixa, MOBuilt 1946 · S/N 2308 N45785Hoover Eli P · Chico, CABuilt 1946 · S/N 2312 N45796Goldasich John · Lomita, CABuilt 1946 · S/N 2323 N4580Ramin Fred R · Tomball, TXBuilt 1939 · S/N 1123 N45803Lindberg David D · Everett, WABuilt 1946 · S/N 2330 N45805Prather Carl L · Gilroy, CABuilt 1946 · S/N 2332

Back to Luscombe 8A