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.

N2388HRoozee James B Jr · Crystal Lake, ILBuilt 1946 · S/N 3013 N2393HSnider Samuel · West Jordan, UTBuilt 1946 · S/N 3018 N2395HGrater Timothy F · Knoxville, TNBuilt 1946 · S/N 3020 N2402HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3027 N2407HKirby Brent L · Metamora, MIBuilt 1946 · S/N 3032 N2411HLekas Melissa · Toms River, NJBuilt 1946 · S/N 3036 N2419HPeterson Christopher A · Holt, FLBuilt 1946 · S/N 3044 N2425HStevens James L · Morehead, KYBuilt 1946 · S/N 3050 N2427HRishovd Thomas A II · Elk River, MNS/N 3052 N2428HHowland Gary M · Marysville, KSBuilt 1946 · S/N 3053 N2434HBigham Dylan · Windsor, CABuilt 1946 · S/N 3059 N2446HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3071 N2449HTracy Kevin A · Sequim, WABuilt 1947 · S/N 3074 N2467HOmlid Robert L · Watford City, NDBuilt 1946 · S/N 3092 N2475HSchroer Jeffery B · Warrenton, MOBuilt 1946 · S/N 3100 N2500HNabb Andrew W · Mooresville, NCBuilt 1946 · S/N 3125 N2503HCarlson Lyle V · Allen, NEBuilt 1946 · S/N 3128 N2511HGalassi Thomas D · Petersburg, ILBuilt 1946 · S/N 3136 N2516HFolk George W · Martinsburg, WVBuilt 1946 · S/N 3141 N2525HWilliams Randy Hillman · Blue Ridge, GAS/N 3150 N2536HGregory Vernon L · Swansea, SCS/N 3161 N2537HMaddock Jay B · Sugar Grove, ILS/N 3162 N2546HWing Wendall E · Marion, MIBuilt 1946 · S/N 3171 N2551HCoupe Groupe Inc · Bayport, NYBuilt 1946 · S/N 3176 N2555HJohns Leroy E · Keenesburg, COBuilt 1946 · S/N 3180 N2569HFolk George W · Martinsburg, WVBuilt 1946 · S/N 3194 N2576HMartin Aaron M · Penn Yan, NYBuilt 1948 · S/N 3201 N2593HUpham Chester R III · Mineral Wells, TXBuilt 1946 · S/N 3218 N2597HQuantie Harold · Locust Grove, OKBuilt 1946 · S/N 3222 N2606HOlberding Timothy · Bolingbrook, ILS/N 3231 N2608HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3233 N2627HGarman Karl E · Crystal Lake, ILBuilt 1946 · S/N 3252 N2633HGlenn Michael J · Payson, AZBuilt 1946 · S/N 3258 N2634HReaser Jordan Scott · Pacific Palisades, CABuilt 1946 · S/N 3259 N2663HGregory Vernon L · Swansea, SCS/N 3288 N2678HGlasser Gene P · Glen Ullin, NDBuilt 1946 · S/N 3303 N2679HAbrams David E · Boston, MABuilt 1946 · S/N 3304 N2698HGoodrich James A · Jacksonville, MOBuilt 1946 · S/N 3323 N2700HBousquet Arthur David · Highgate Center, VTBuilt 1946 · S/N 3325 N2701HLevsen Charles L · Clinton, IABuilt 1946 · S/N 3326 N2702HHessling Gary G · Trinidad, COBuilt 1946 · S/N 3327 N2704HBoelke Ross D · Armada, MIS/N 3329 N2714HRey Thomas A · Fort Worth, TXS/N 3339 N271HRegistered aircraftBuilt 1946 · S/N 2306 N2730HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3355 N2738HDieter Walter T · Salome, AZBuilt 1946 · S/N 3363 N2747HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3372 N2749HEngle Elvin Michael · Houston, TXBuilt 1946 · S/N 3374 N2757HEtchison Don L · Spring Hill, FLBuilt 1946 · S/N 3382 N2758HFitchpatrick Markel C · Blodgett, MOBuilt 1946 · S/N 3383

Back to Ercoupe 415-C