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.

N2591KFlannery Robert P · Durango, COBuilt 1947 · S/N 5318 N2611KGengarelly Clare O · Benson, AZBuilt 1947 · S/N 5338 N2613KHerndon Michael T · Danville, KYBuilt 1947 · S/N 5340 N2654KHalstead George · E St Louis, ILRegistration revokedBuilt 1947 · S/N 42662K N2666KIngraham Danny E · Soldotna, AKBuilt 1947 · S/N 5393 N2685KJestes Monte G · Stillwater, OKBuilt 1947 · S/N 5412 N2703KHamilton James R · Senoia, GABuilt 1947 · S/N 5430 N2707KWoenker Timothy E · Columbia City, INBuilt 1947 · S/N 5434 N2708KSwanson Gavin S · Jamestown, NYS/N 5435 N2710KWhite Brian R · Concrete, WABuilt 1947 · S/N 5437 N2719KNorsworthy Cletus C · Media, PABuilt 1947 · S/N 5446 N2750KLeithead Bruce O · Stone Mountain, GABuilt 1947 · S/N 5477 N2757KClassic Air 46 LLC · Cleveland, GABuilt 1947 · S/N 5484 N2764KQueen Gregory A · Pickerington, OHBuilt 1947 · S/N 5491 N276YHolliday Mark E · Lake Elmo, MNS/N 2723 N2794KWallitner Raymond · Renton, WABuilt 1947 · S/N 5521 N2796KWilson Roy M III · Seguin, TXBuilt 1947 · S/N 5523 N2797KWalton T Michael · Hudson Falls, NYS/N 5524 N2833KCook Norman E · Davie, FLS/N 5560 N2836KKent Stephen G · Danvers, MAS/N 5563 N28404Bongiovanni Joseph T · Ocala, FLBuilt 1940 · S/N 1271 N28412Poppy The Plane LLC · Hernando, FLBuilt 1940 · S/N 1279 N28419Shirlted LLC · Rome City, INBuilt 1940 · S/N 1286 N28424Hooten William T Jr · Greenbrier, ARBuilt 1940 · S/N 1291 N28428Johengen James M · Eau Claire, WIBuilt 1940 · S/N 1295 N2842KMiller Steven L · Naperville, ILBuilt 1947 · S/N 5569 N28430Lamb James M · Farmersville, OHBuilt 1940 · S/N 1297 N28436Madaras William W · Eureka, CAS/N 1303 N2843KMorrison John L · Oklahoma City, OKBuilt 1947 · S/N 5570 N28442Jeffers Kyle A · New Carlisle, OHBuilt 1940 · S/N 1309 N28443Hoecher Robert T · Anchorage, AKBuilt 1940 · S/N 1310 N28444Plourde James D · Flint, MIBuilt 1940 · S/N 1311 N28450Hataway Gregory L · Kinston, ALS/N 1317 N28461Smutny John · Auburn, WABuilt 1940 · S/N 1328 N28465Davis Christopher Vance · Green Forest, ARS/N 1332 N28468Perkins Dale J · Union, ORBuilt 1940 · S/N 1335 N28473Uvanni Bruce A · Shelburne, VTBuilt 1940 · S/N 1340 N28480Wigley Jan L · Centralia, WABuilt 1948 · S/N 1347 N28485Lewis Timothy W · Thousand Palms, CAS/N 1352 N28486Reed Michael D · Parsons, KSBuilt 1940 · S/N 1353 N28488Doan Lawrence E · Seattle, WABuilt 1947 · S/N 1355 N28494Pristo Paul J · Scottsdale, AZFirst renewal noticeBuilt 1940 · S/N 1361 N28554Ruth-Ann Baughman Bell · Hummelstown, PABuilt 1940 · S/N 1383 N28564Gingras John T · Bakersfield, CABuilt 1940 · S/N 1393 N28574Mccutchan Clay T · Milton, FLBuilt 1940 · S/N 1403 N28576White Paul M · Elizaville, NYBuilt 1940 · S/N 1405 N28577Snodgrass James T · Gallipolis, OHS/N 1406 N28579Lutz Terry L · Williamston, MIBuilt 1940 · S/N 1408 N28580Goble John H · Cresson, TXBuilt 1940 · S/N 1409 N28600Kenney Madelaine J · Seattle, WABuilt 1940 · S/N 1429

Back to Luscombe 8A