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.

N3095HSpruell Kenneth A · Mc Leansboro, ILBuilt 1946 · S/N 3720 N3100HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3725 N3112HTietze Thomas N · Olathe, KSBuilt 1946 · S/N 3737 N31140Brown Doyle E · Jonesboro, ARBuilt 1946 · S/N 3143 N3132HHottenstein John C · Rifle, COBuilt 1946 · S/N 3757 N3137HBeaty Larry · Newport Beach, CABuilt 1946 · S/N 3762 N3140HLayne John A · Danville, INBuilt 1946 · S/N 3765 N3147HRegistration Pending · Grand Forks, NDRegistration pendingBuilt 1946 · S/N 3772 N3156HFoster Scott R · Federal Way, WABuilt 1946 · S/N 3781 N3165HWilson Hunter W · Williston, NDBuilt 1946 · S/N 3790 N3170HSchimmel O L · Port Hueneme, CABuilt 1946 · S/N 3795 N3175HGoitia Juan C · Toa Alta, PRBuilt 1946 · S/N 3800 N3193HWarren Howard E · Cookeville, TNBuilt 1946 · S/N 3818 N3224HLeonardo Alan W · Higbee, MOS/N 3849 N3239HEschholz Hans-Joachim · Marietta, GABuilt 1946 · S/N 3864 N3243HSpecht Leo M · Towner, COS/N 3868 N3245HBrewer Curtis E · Garland, TXS/N 3870 N3259HFowler Joshua N · Dayton, NVBuilt 1946 · S/N 3884 N3282HScott Kaden S · Juneau, AKBuilt 1946 · S/N 3907 N3287HHouston Aeronautical Heritage Society Inc · Houston, TXBuilt 1946 · S/N 3912 N3324HNicholls Kenneth E · Glide, ORBuilt 1947 · S/N 3949 N3349HGoranson Jan David · Cherry Valley, ILBuilt 1946 · S/N 3974 N3359HOdonnell Michael A · Delanco, NJBuilt 1946 · S/N 3984 N3363HBailey Riley W Jr · Ada, OKS/N 3988 N3376HTaylor Laura M · Tucson, AZBuilt 1946 · S/N 4001 N3383HMessina David A · Currituck, NCBuilt 1946 · S/N 4008 N3390HMyers Robert W · Fort Wayne, INBuilt 1946 · S/N 4015 N3396HSpecht Leo M · Towner, COBuilt 1946 · S/N 4021 N3398HSanderson Donald J · Mckinney, TXBuilt 1946 · S/N 4023 N3405HHolman Steve R · Vero Beach, FLBuilt 1946 · S/N 4030 N3411HSexton Thomas G · Pelzer, SCBuilt 1946 · S/N 4036 N3426HRomanjenko Fred · Gillette, WYS/N 4051 N3428HSnider Thomas G · Arizona City, AZBuilt 1946 · S/N 4053 N3437HAbrams Linda T · San Pedro, CABuilt 1946 · S/N 4062 N3471HPritchett Otis R · Avery, TXBuilt 1946 · S/N 4096 N3488HHeath Jackie · Radcliff, KYS/N 4113 N3524HRabaut Chuck P · Oceanside, CABuilt 1946 · S/N 4149 N3530HUltraflight LLC · Angola, INBuilt 1946 · S/N 4155 N3538HJugeau Jean-Louis · Thomasville, PABuilt 1946 · S/N 4163 N3539HDresback Glen Lloyd · Cleveland, OKBuilt 1946 · S/N 4164 N3548HGresley Ross A · Catawba, NCBuilt 1946 · S/N 4173 N3550HShinn Larry J · Victor, CABuilt 1946 · S/N 4175 N3560HBlakley Jordan A · Lake Point, UTBuilt 1946 · S/N 4185 N3569HHess James L · Honey Brook, PAS/N 4194 N3571HLang James L · Buckley, WAS/N 4196 N3579HBucciarelli Dominick · Pueblo, COBuilt 1946 · S/N 4204 N3587HIlatina LLC · Carson City, NVS/N 4212 N3589HJones David F · Memphis, TNBuilt 1946 · S/N 4214 N3602HSale Reported · Jadwin, MOSale reported, pending cancellationS/N 4227 N3615HKent Larry A · Gaylord, MIS/N 4240

Back to Ercoupe 415-C