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.

N3619HVanberg David O · Mineral Wells, TXBuilt 1946 · S/N 4244 N3626HPost Greg G · Mapleton, KSFirst renewal noticeBuilt 1946 · S/N 4251 N3627HPina Gabriel · Pasadena, CAS/N 4252 N3633HMaximus Aviation LLC · Cheyenne, WYS/N 4258 N3642HMccoy Bill · Deland, FLBuilt 1946 · S/N 4267 N3644HJohnston David W Sr · Vero Beach, FLBuilt 1946 · S/N 4271 N3649HVlahos James M · Brigham City, UTBuilt 1946 · S/N 4274 N3668HSheridan Walter S · Indianapolis, INS/N 4293 N3675HCarlson Kim R · Swartz Creek, MIBuilt 1946 · S/N 4300 N3677HWalkup Richard A · Pioneer, OHBuilt 1946 · S/N 4302 N3678HWilliams Terry R · Vinita, OKBuilt 1946 · S/N 4303 N3679HJohnson Richard E · Mulberry, FLBuilt 1946 · S/N 4304 N3688HTench William Carroll · Belton, SCBuilt 1946 · S/N 4313 N3689HO Handley Hugh Jr · Rogersville, TNBuilt 1946 · S/N 4314 N3694HAshburn Lauren W · Alta Vista, KSBuilt 1946 · S/N 4319 N3695HGem Utilities Inc · Greenfield, INBuilt 1946 · S/N 4320 N3704HBrown Terese A · Port Saint Lucie, FLS/N 4329 N37119Hahola James J · Easton, PAS/N 86 N37122Morgan Kenneth H · Carthage, NCBuilt 1941 · S/N 89 N37135Porter Bryan L · Kent, WABuilt 1941 · S/N 102 N37139Bowers Robert D · Ottawa, KSBuilt 1956 · S/N 106 N37140Perry John · Tomah, WIBuilt 1941 · S/N 107 N37143Hardin John M · Terrell, TXBuilt 1941 · S/N 110 N3726HWinter Jack W · Custer, SDS/N 4351 N3769HBowers Dennis · Palacios, TXBuilt 1947 · S/N 4394 N3771HGoldstein Steven I · Hawthorne, NJFirst renewal noticeBuilt 1947 · S/N 4396 N3773HDuvall Gene Adrian · Amarillo, TXBuilt 1947 · S/N 4398 N3779HDurfee Robert W.C. · Taylor, MIS/N 4404 N3794HWorley William M · Camden, NCBuilt 1947 · S/N 4419 N3798HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4423 N37JMLowe Ron C · Abernathy, TXBuilt 1946 · S/N 353 N3831HBlickhan C John · Quincy, ILBuilt 1947 · S/N 4532 N3870HGuenther Mary J · Port Charlotte, FLBuilt 1947 · S/N 4571 N412DPHultzapple Ted D · Farmington, NYBuilt 1946 · S/N 2057 N415BZDaley Lige W · Carlinville, ILBuilt 1946 · S/N 693 N415CPStrannard David L · Sacramento, CABuilt 1946 · S/N 1704 N415GPWebb David W · Jupiter, FLS/N 667 N415LLBawtinheimer Kris · Grand Rapids, MIBuilt 1946 · S/N 1221 N415TBLeuthold Mike · Concord, CABuilt 1946 · S/N 1612 N43832Knutson Wayne R · Thompson, NDS/N 178 N43LEFlying Colors Air Parts Inc · Leesburg, FLBuilt 1946 · S/N 352 N464MEMaas Russell J · Gleason, WIBuilt 1946 · S/N 2977 N500BKFriest Eric J · Menomonie, WIBuilt 1946 · S/N 442 N51DVBennett Gabriel J C · Hillsboro, ORBuilt 1946 · S/N 2024 N525SLFlying Smiles LLC · Land O Lakes, FLBuilt 1946 · S/N 1374 N529LMcclain Donald H · Pasadena, TXBuilt 1946 · S/N 498 N56JBWalker Mark C · New Castle, VABuilt 1946 · S/N 1062 N5830MTotten Matthew W · Wamego, KSS/N 2161 N611GCIppolito Joseph · Fremont, CAS/N 611 N66YYFreeman Stephen K · Kingsbury, TXS/N 1643

Back to Ercoupe 415-C