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.

N71129Pustay John D · Inglis, FLBuilt 1946 · S/N 2556 N71135Jebb Steven J · Clovis, CABuilt 1946 · S/N 2562 N71139Whetzel Herbert H · Clarkesville, GABuilt 1946 · S/N 2566 N71142Truesdale Thair W · Collinsville, OKBuilt 1946 · S/N 2569 N71147Atkins Ricky K · Placerville, CABuilt 1946 · S/N 2574 N71148Registered aircraftBuilt 1946 · S/N 2575 N71152Allen Justin W · Lizton, INBuilt 1946 · S/N 2579 N71155Step Too LLC · Wilmington, DEBuilt 1946 · S/N 2582 N71156Rasch Kevin W · Denton, TXBuilt 1946 · S/N 2583 N71157Bauer Lawrence L · Grand Rapids, MIS/N 2584 N71161Miller Todd · Martinton, ILS/N 2588 N71166Hatcher Michael C · Timberville, VABuilt 1946 · S/N 2593 N71170Vandoynhoven John T · Glencoe, MNBuilt 1946 · S/N 2597 N71172Bialozynski Gary · Menomonee Falls, WIBuilt 1946 · S/N 2599 N71173Amigos 8a LLC · Breckenridge, TXBuilt 1946 · S/N 2600 N71177Traweek Brian C · Battle Mountain, NVBuilt 1946 · S/N 2604 N71189Carlson Tom H · Miles City, MTBuilt 1946 · S/N 2616 N71201Hatter Ronnie A · Newcastle, OKBuilt 1946 · S/N 2628 N71212Smith Brian D · Sinclairville, NYBuilt 1946 · S/N 2639 N71218Adkins Dwain L · Sycamore, ILBuilt 1946 · S/N 2645 N71219Dakota Territory Air Museum · Minot, NDBuilt 1946 · S/N 2646 N71230Hopper Jerry L · Winfield, KSBuilt 1946 · S/N 2657 N71231Yeash Kevin M · Pemberton, NJBuilt 1946 · S/N 2678 N71232Flying L Aircraft Inc · Fort Denaud, FLS/N 2659 N71236Clark Michael L · Milford, CABuilt 1946 · S/N 2663 N71239Sowder David M · Boonville, INBuilt 1946 · S/N 2666 N71240Schlosser Charles M · Webster, MNBuilt 1946 · S/N 2667 N71245Kussatz Michael · Olathe, KSBuilt 1946 · S/N 2672 N71252Willis Theresa J · Greenfield, INBuilt 1946 · S/N 2679 N71261Magnuson Lloyd W · Opelousas, LABuilt 1946 · S/N 2688 N71264Wilson Richard · Morriston, FLBuilt 1946 · S/N 2691 N71275Lee Robert E · Medford, WIBuilt 1946 · S/N 2702 N71277Allen Robert K · Dallas, TXBuilt 1946 · S/N 2704 N71281Keller William R · East Amherst, NYBuilt 1946 · S/N 2708 N71283Week James A · Sun Prairie, WIBuilt 1946 · S/N 2710 N71288Wilcox Ross L · Santa Rosa, CAS/N 2715 N71291Williams Garner W · Naperville, ILBuilt 1946 · S/N 2718 N71295Logback Michael R · Mcpherson, KSBuilt 1946 · S/N 2722 N71297Eigsti Rodney E Trustee · Friend, NEBuilt 1946 · S/N 2724 N71299Hurlbert Vernon L · Anchorage, AKBuilt 1946 · S/N 2726 N71301Chambers Todd R · Brundidge, ALS/N 2728 N71303Roetman Donald E · Flippin, ARS/N 2730 N71306Braswell Charles A Jr · Taylorsville, NCS/N 2733 N71307Wings Den LLC · Wilmington, DEBuilt 1946 · S/N 2734 N71308Woodson Robert L III · Fort Mill, SCBuilt 1946 · S/N 2735 N71312Frasca Air Museum · Urbana, ILBuilt 1946 · S/N 2739 N71315Shewalter Nicholas · Frankfort, MIBuilt 1946 · S/N 2742 N71318Allen Benjamin S · Flowery Branch, GABuilt 1946 · S/N 2745 N71328Egbert Charles A · Mogadore, OHBuilt 1946 · S/N 2755 N71329Eigsti Rodney E Trustee · Friend, NES/N 2756

Back to Luscombe 8A