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.

N94145Smith Dwight S · Ann Arbor, MIBuilt 1946 · S/N 1468 N94175Preslicka Eric · York, NEBuilt 1946 · S/N 1498 N94188Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1511 N94189Champion James D · Urbandale, IABuilt 1946 · S/N 1512 N94191Olson Daren C · Tichnor, ARBuilt 1946 · S/N 1514 N94307Bellings Eric E · Neshkoro, WIBuilt 1946 · S/N 1530 N94308Hoyer Brian Lee · Wickenburg, AZBuilt 1946 · S/N 1531 N94316Nowicki John W · West Chicago, ILBuilt 1946 · S/N 1539 N94320Gap Aircrafts LLC · Dover, DEBuilt 1946 · S/N 1543 N94333Hodgson John S · Genoa, NVBuilt 1946 · S/N 1556 N94348Devlin Robert E · Hillsborough, NJBuilt 1946 · S/N 1571 N94351Daffer Jon Terrill · Edgewood, NMBuilt 1946 · S/N 1574 N94355Cato James W · Las Cruces, NMBuilt 1947 · S/N 1578 N94365Logemann Dennis F · Sandia, TXBuilt 1946 · S/N 1588 N94366Hepner Glenn L · New Port Richey, FLBuilt 1946 · S/N 1589 N94367Flying L Aircraft Inc · Fort Denaud, FLBuilt 1946 · S/N 1590 N94372Johnson Randal D · Clearwater, FLBuilt 1946 · S/N 1595 N94376Kimberly Charles M · Wellington, FLBuilt 1946 · S/N 1599 N94390Hershorin Paul A · Okeechobee, FLFirst renewal noticeBuilt 1946 · S/N 1613 N94398Bores Scott J · Huron, OHS/N 1621 N94423Marshall Jerry D · Hachita, NMBuilt 1946 · S/N 2978 N94695Wehmer Alan R · Ewa Beach, HIBuilt 1947 · S/N 4806 N99013Poehler Carol S · Prairie Village, KSBuilt 1946 · S/N 1636 N99030Brown John R · Nashville, TNS/N 1653 N99036Wilwerding Terry · Omaha, NEFirst renewal noticeBuilt 1946 · S/N 1659 N99037Still Robert L · Thomasville, NCS/N 1660 N99039Alesso Casey H · Rosamond, CABuilt 1946 · S/N 1662 N99043Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1666 N99047Marriott Robert E · Newark, OHBuilt 1946 · S/N 1670 N99049Brown Jeffrey S · Jerome, IDBuilt 1946 · S/N 1672 N99050Berry Norman R · Knoxville, TNBuilt 1946 · S/N 1673 N99052Wallace Paul E · Cedar Falls, IABuilt 1946 · S/N 1675 N99075Estuarial Medical Consultants · South Boston, VABuilt 1946 · S/N 1698 N99083Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1706 N99088Stanton Paul L · Bloomington, MNBuilt 1946 · S/N 1711 N99092Mapes Joseph S · Stevens Point, WIBuilt 1946 · S/N 1715 N99103Pearson Landon S · Madison, SDBuilt 1946 · S/N 1726 N99109Holmes Ronald · Modesto, CABuilt 1946 · S/N 1732 N99115Gregory Vernon L · Swansea, SCBuilt 1946 · S/N 1738 N99116Hallman Eugene A · Kasota, MNBuilt 1946 · S/N 1739 N99124Stephany Peter T · Umatilla, FLS/N 1747 N99134Balla Steve · Fallbrook, CAS/N 1757 N99159Chesak Jonathan J · Merlin, ORFirst renewal noticeBuilt 1946 · S/N 1782 N99164Paul James W · Los Angeles, CAFirst renewal noticeBuilt 1946 · S/N 1787 N99174Vohlken Edward · Smithboro, ILBuilt 1946 · S/N 1797 N99177York George T · Harvard, ILBuilt 1946 · S/N 1800 N99180Rilling Norman I Jr · Bakersfield, CABuilt 1946 · S/N 1803 N99181Wilhelm Kenneth H · Helena, MTBuilt 1946 · S/N 1804 N99186Emerson Daniel B · Port Royal, PABuilt 1946 · S/N 1809 N99187Bobbitt James Warren · Imboden, ARS/N 1810

Back to Ercoupe 415-C