Skip to content

Registered aircraft · 624

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 ('0420322')
  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 ('0420322')
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.

N93515Braden James L · Hillsboro, KSS/N 838 N93530Freeman Robert Dennis · Batavia, OHBuilt 1946 · S/N 853 N93539Spitfire Aviation Inc · Wilmington, DEBuilt 1946 · S/N 862 N93544Carlson James D · Hugo, MNS/N 867 N93545Acock Danny J · Oklahoma City, OKBuilt 1946 · S/N 868 N93553Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 876 N93569Traweek Parrish C · San Manuel, AZBuilt 1946 · S/N 892 N93584Godbold Joshua M · Perdido Beach, ALS/N 907 N93587Paxton Ronald R · Colorado Springs, COBuilt 1946 · S/N 910 N93598Boehler Brian S · Pacific City, ORBuilt 1946 · S/N 921 N93606Vernon Gregory L · Swansea, SCBuilt 1946 · S/N 929 N93610Treat Michael D · Fayetteville, ARBuilt 1946 · S/N 933 N93611Vukonich Thomas P · Oxford, MIBuilt 1946 · S/N 934 N93612Cook Sherman D · Mount Vernon, KYS/N 935 N93614Peterson Dennis E · Cambridge, MNBuilt 1946 · S/N 3465 N93616Casper Sean C · Oshkosh, WIBuilt 1946 · S/N 939 N93636Schneider Scott M · Tribune, KSBuilt 1946 · S/N 959 N93654Sale Reported · Sherrill, ARSale reported, pending cancellationBuilt 1946 · S/N 977 N93655Brosman Earl H · Indianapolis, INBuilt 1946 · S/N 978 N93659Morrissett Jay D · Bumpass, VABuilt 1946 · S/N 982 N93683Martin Daniel E · Longview, TXBuilt 1946 · S/N 1006 N93685Stuart Pat · Willow Springs, MOBuilt 1946 · S/N 1008 N93687Registered aircraftBuilt 1946 · S/N 1010 N93691Registration Pending · De Pere, WIRegistration pendingBuilt 1946 · S/N 1014 N93694Nix Jimmie E · Madison, ALS/N 1017 N93697Seiler Kathryn R · Quitman, ARBuilt 1946 · S/N 1020 N93712Hetrick David R · Alexandria, PABuilt 1946 · S/N 1035 N93717Wolter Michael S · Dallas, TXBuilt 1946 · S/N 1040 N93724Russell Walter B · Boone, COBuilt 1946 · S/N 1047 N93727Hjelle Mark L · Barrett, MNBuilt 1946 · S/N 1050 N93744Hanneman Rhea Ann · Abilene, TXBuilt 1946 · S/N 1067 N93746Raty Ronald J · Bremerton, WABuilt 1946 · S/N 1069 N93749Denchel Thomas W · Prosser, WABuilt 1946 · S/N 1072 N93751Gable Clark F · Oxford, ALBuilt 1946 · S/N 1074 N93760Dillman David O · Harrogate, TNS/N 1083 N93775Stack Richard P · Lacey, WABuilt 1946 · S/N 1098 N93788Gregory Vernon L · Swansea, SCS/N 1111 N93798Schrimpf Robert J · Batesville, INBuilt 1946 · S/N 1121 N93803Cuthbert Alan R · Edwardsburg, MIBuilt 1946 · S/N 1126 N93805Bass Daniel · Winona, MNBuilt 1946 · S/N 1128 N93807Knorr D Steven · Shiocton, WIBuilt 1946 · S/N 1130 N93808Dante K Escobar · Davenport, FLBuilt 1946 · S/N 1131 N93820Tenforty Inc · Vermillion, SDBuilt 1946 · S/N 1143 N93833Bergstrom Gunnar · Kenai, AKBuilt 1946 · S/N 1156 N93834Logerfo Richard · Amsterdam, NYBuilt 1946 · S/N 1157 N93838Burke Dan · Kirkland, WABuilt 1946 · S/N 1161 N93850Rollison Michael W · Fairfield, PABuilt 1946 · S/N 1173 N93851Bayne William R · Kaufman, TXBuilt 1946 · S/N 1174 N93852Swartwout William A · Selbyville, DEBuilt 1946 · S/N 1175 N93862Graumfear LLC · Cincinnati, OHBuilt 1946 · S/N 1185

Back to Ercoupe 415-C