Skip to content

Registered aircraft · 101

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

N48EStransky Theodore J · Newburgh, INBuilt 1946 · S/N 3328 N666EAStevens Burton G · Las Vegas, NVBuilt 1946 · S/N 1258 N7029UBohlke LLC · Kingshill, VIBuilt 1946 · S/N 3404 N72DSGregory Vernon L · Swansea, SCBuilt 1946 · S/N 1012 N8144NMckee James L · Caledonia, OHBuilt 1947 · S/N 4597 N82REEpton Richard C · Williamson, GABuilt 1946 · S/N 2179 N87118Wittco Aero LLC · Vancouver, WABuilt 1946 · S/N 291 N87124Kadel James R · Portsmouth, OHBuilt 1946 · S/N 297 N87240Hacker James D · Borden, INBuilt 1946 · S/N 413 N87274Webb Aaron J · Monroe, GABuilt 1946 · S/N 447 N87312Lademann Ryan C · Saint Clair Shores, MIBuilt 1946 · S/N 485 N87330Maison Taisiya E · Olney, MDBuilt 1946 · S/N 503 N87348Howard Dale L · Harrisburg, NCBuilt 1946 · S/N 521 N87410Harpole Bill · Dickinson, NDBuilt 1946 · S/N 583 N93452Ragan Dan M · Danbury, CTBuilt 1946 · S/N 775 N93494Johnson Harold C · Foster City, MIS/N 817 N93543Hawkins Terry D · Conyers, GABuilt 1946 · S/N 866 N93684Mckenzie Kenneth E · Ft Lauderdale, FLBuilt 1946 · S/N 1007 N93696Sale Reported · Locust Grove, GASale reported, canceledBuilt 1946 · S/N 1019 N93823Courson Keith A · Boise, IDS/N 1146 N93828Stanford Dolph B · Watauga, TXS/N 1151 N93906Shiloh Aviation LLC · Ramer, TNBuilt 1946 · S/N 1229 N93932Specht Leo M · Towner, COBuilt 1946 · S/N 1255 N93949Jardine Brian E · Greenleaf, IDBuilt 1946 · S/N 1272 N93953Veltri Laura D · Kismet, KSBuilt 1946 · S/N 1276 N94039Antonelli Michael · Mesa, AZS/N 1361 N94135Flying Wrenches · Buhl, IDBuilt 1946 · S/N 1458 N94171Tittle James L · Pembine, WIBuilt 1946 · S/N 1494 N94315Whitmire Joseph A · Soddy Daisy, TNBuilt 1946 · S/N 1538 N94633Hawkins Paul R · Peachtree City, GABuilt 1947 · S/N 4740 N980DDHeath Jackie · Radcliff, KYBuilt 1946 · S/N 4010 N99055Ag-Aero Services LLC · Spring Hill, FLBuilt 1946 · S/N 1678 N99121Sprott Robert L · Perkins, OKBuilt 1946 · S/N 1744 N99143Shannon Air Museum LLC · Fredericksburg, VABuilt 1946 · S/N 1766 N99183Mahon David L · Payson, ILS/N 1806 N99207Silvagnoli Miguel · Bay Shore, NYBuilt 1946 · S/N 1830 N99229Yanks Air Museum · Baldwin Park, CABuilt 1946 · S/N 1852 N99246Poliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 1869 N99315Shackleford Larry D · Southmont, NCS/N 1938 N99387Hobschaidt Kurt · Pittstown, NJBuilt 1946 · S/N 2010 N99399Adams Thomas D · Marathon, NYBuilt 1946 · S/N 2022 N99493Beem Ray M · Apison, TNS/N 2116 N99597Vardara Philip G · Penn Valley, CABuilt 1946 · S/N 2220 N99641Oltz Walter H · Sauk Rapids, MNBuilt 1946 · S/N 2264 N99646Shuler Donald · Punta Gorda, FLBuilt 1946 · S/N 2269 N99673Schupp Edward W · Hedgesville, WVBuilt 1946 · S/N 2296 N99711Posada Hernan · Valencia, CABuilt 1946 · S/N 2334 N99828Hale Larry E · Granbury, TXBuilt 1946 · S/N 2451 N99879N46p Inc · Fort Wayne, INBuilt 1946 · S/N 2502 N99924Harvell Randall W · Manteno, ILBuilt 1946 · S/N 2547

Back to Ercoupe 415-D