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.

N105VCBrewer Curtis E · Garland, TXBuilt 1946 · S/N 2534 N190XAirline Pilots Historical Society · Saint Charles, ILBuilt 1946 · S/N 2445 N2013TSamford Tristan W · Carthage, TXBuilt 1946 · S/N 2689 N2070HFike Glen P · Beavercreek, OHBuilt 1946 · S/N 2693 N2077HWinter Jack W · Custer, SDBuilt 1946 · S/N 2700 N2078SVolkman Royce D · Fairview, MTS/N 1428 N2118FMclaughlin Michael W · Egg Hbr Twp, NJBuilt 1946 · S/N 2102 N2120HGregory Vernon L · Swansea, SCS/N 2787 N2134HSullivan James E · Bismarck, NDBuilt 1946 · S/N 2757 N2250HZahner Paul G · Fairfield, CABuilt 1946 · S/N 2873 N2273HWright Colleen E · Punta Gorda, FLBuilt 1946 · S/N 2898 N2387HOgden Thomas C · New Cumberland, WVBuilt 1946 · S/N 3012 N2396HChowdhury Ajoy · Newark, CABuilt 1946 · S/N 3021 N2408HPope Bradley L · Woodstock, GABuilt 1946 · S/N 3033 N2472HDunlap Lloyd A · Brighton, MIBuilt 1946 · S/N 3097 N2650HBreza Thomas S · Laud By Sea, FLS/N 3275 N2715HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3340 N2785HBal-Air LLC · Boca Raton, FLBuilt 1946 · S/N 3410 N2820HWelkner Brent G · Guyton, GABuilt 1946 · S/N 3445 N2844HSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3469 N2940HWilhelm Dallas E Jr · Hastings, NEBuilt 1946 · S/N 3565 N2972HWirt James L · Goldsby, OKBuilt 1946 · S/N 3597 N3099HJones Fredrick R · Lawrence, KSBuilt 1946 · S/N 3724 N3139HRegistered aircraftBuilt 1946 · S/N 3764 N3149HGregory Vernon L · Swansea, SCS/N 3774 N3281HJardine Brian E · Greenleaf, IDS/N 3906 N3392HWilliams Robert B · Azle, TXBuilt 1955 · S/N 4017 N3418HRegistration Pending · Brady, TXRegistration pendingBuilt 1946 · S/N 4043 N3435HCasa Del Pajaro LLC · Plaistow, NHBuilt 1946 · S/N 4060 N3475HBrownback Terry R · Emporia, KSS/N 4100 N3564HPittinger Sandra Lee · Beggs, OKS/N 4189 N3595HRowe William S · Argyle, TXBuilt 1946 · S/N 4220 N3637HDe Young Robert · Napa, CABuilt 1946 · S/N 4262 N3734HRobinson Stephen G · Livermore, CABuilt 1946 · S/N 4359 N3793HHensley Michael F · Coos Bay, ORBuilt 1947 · S/N 4418 N3821HWilson Christopher W · Honey Grove, TXBuilt 1947 · S/N 4522 N3834HStuder Rodney J · Shelby, MIS/N 4535 N3838HHales Thomas P III · Venice, FLBuilt 1947 · S/N 4539 N3852HPaxton Ronald R · Colorado Springs, COBuilt 1947 · S/N 4553 N3869HPopio John A · Marysville, OHBuilt 1947 · S/N 4570 N3878HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4579 N3919HReed Tyrone P · Essexville, MIBuilt 1947 · S/N 4620 N3927HPoliak Mark A Trustee · Carmel, INBuilt 1947 · S/N 4628 N3985HReese Jon O · Wichita Falls, TXBuilt 1947 · S/N 4686 N3992HHaynes Roger M · Fremont, OHBuilt 1947 · S/N 4693 N4151Stapleton Halley S · Brownsville, TXS/N 3003 N415DRHughes Keith A · Ormond Beach, FLBuilt 1946 · S/N 784 N415JC1st Resources Unltd Inc · Houston, TXS/N 3728 N415PTFlying Angel LLC · Bismarck, NDBuilt 1946 · S/N 1707 N41889Bair Zach · Memphis, TNS/N 119

Back to Ercoupe 415-D