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.

N2766HBennett Bruce M · Louisburg, KSBuilt 1946 · S/N 3391 N2771HLambertson Paul C · Surprise, AZBuilt 1946 · S/N 3396 N2791HMoore James L · Humboldt, TNBuilt 1946 · S/N 3416 N2800HGriggs Geri L · Kingsville, OHFirst renewal noticeBuilt 1946 · S/N 3425 N2808HBellomy Andrew · Hasty, COS/N 3433 N2816HR & R Outfitters LLC · Kalispell, MTS/N 3441 N2825HMayo Charles S · Woodlawn, TXBuilt 1946 · S/N 3450 N2829HMartin D East · Nicholasville, KYBuilt 1946 · S/N 3454 N2830HPowell Sherman B III · Pulaski, TNBuilt 1946 · S/N 3455 N2831HDon Jones Inc · Orange Beach, ALBuilt 1946 · S/N 3456 N2834HClausing Howard F · Menomonie, WIFirst renewal noticeBuilt 1946 · S/N 3459 N2837HNorberg John E · Eureka, CABuilt 1946 · S/N 3462 N2845HGoff Frederick Myron · Vernon, CTBuilt 1946 · S/N 3470 N2860HKerr Phillip D · Beebe, ARBuilt 1946 · S/N 3485 N2864HKarafit James T · Celina, OHBuilt 1946 · S/N 3489 N2865HBayne William R · Kaufman, TXFirst renewal noticeBuilt 1946 · S/N 3490 N2869HBeeman Robert P · Central City, PABuilt 1946 · S/N 3494 N2876HBurr Walter E II · Tecumseh, MIBuilt 1946 · S/N 3501 N2877HHeusdens Mark A · Kansasville, WIBuilt 1946 · S/N 3502 N2881HMickevicius Theodore A · Gregory, MIBuilt 1946 · S/N 3506 N2884HRogers Samuel I · Le Roy, KSBuilt 1946 · S/N 3509 N28939Gregory Vernon L · Swansea, SCBuilt 1941 · S/N 34 N28960Gregory Vernon L · Swansea, SCS/N 56 N28962Summit Aviation Holdings Of Nwa Inc · Rogers, ARBuilt 1941 · S/N 58 N2906HZysko Jan A · Ocala, FLBuilt 1946 · S/N 3531 N2912HAnderas Per R · Green Bay, WIBuilt 1946 · S/N 3537 N2914HChipcraft LLC · Orlando, FLBuilt 1946 · S/N 3539 N2915HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3540 N2925HYamron Mark L · Borrego Springs, CABuilt 1946 · S/N 3550 N2926HKrueger Arden B · Wausau, WIBuilt 1946 · S/N 3551 N2937HPoliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 3562 N2944HPort Townsend Aero Museum · Port Townsend, WAS/N 3569 N2951HOnderdonkrichard P · Upland, CABuilt 1946 · S/N 3576 N2962HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3587 N2963HSuryan Sheri A · Port Townsend, WABuilt 1946 · S/N 3588 N2970HBraun John L · Indianapolis, INBuilt 1946 · S/N 3595 N2974HTroubleshooter Network Inc · Denver, COBuilt 1946 · S/N 3599 N2980HPoliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 3605 N2982HBarnstormers Club LLC · Cape Coral, FLBuilt 1946 · S/N 3607 N2996HWestlund Steven G · Belleville, ILBuilt 1946 · S/N 3621 N3006HDream Flight Aviation LLC · Frederick, MDBuilt 1946 · S/N 3631 N3025HBrandt Merle G · Potomac, ILBuilt 1946 · S/N 3650 N3026HOstergaard David E · Keithville, LABuilt 1946 · S/N 3651 N3038HMclain Edward L · Albuquerque, NMS/N 3663 N3039HCarter Billie D · Steelville, MOBuilt 1946 · S/N 3664 N3042HSullivan Patrick Joseph · East Hampton, NYBuilt 1946 · S/N 3667 N3052HYoung Thomas A · Mount Olive, NCBuilt 1946 · S/N 3677 N3055HRopkey Armor And Aviation Museum Inc · Indianapolis, INBuilt 1946 · S/N 3680 N3058HCrowder Thomas L · Oak Park, CABuilt 1946 · S/N 3683 N3087HMorris Steven R · East Waterboro, MEBuilt 1946 · S/N 3712

Back to Ercoupe 415-C