Skip to content

Registered aircraft · 623

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.

N1210HThiel Scott D · Edgewood, WABuilt 1946 · S/N 3887 N13PQAllen Ron · Oceanside, CABuilt 1946 · S/N 3544 N142Rains Cecil R · Wichita, KSBuilt 1940 · S/N 12 N153JDMorgan Thomas R · San Antonio, TXBuilt 1946 · S/N 284 N15JLTravland Lewis H · Alpine, TXS/N 2410 N168PMcmanus Brian K · Smithville, TXBuilt 1946 · S/N 905 N179GAnderson John P · Knoxville, TNBuilt 1946 · S/N 1802 N17JDSpecht Leo M · Towner, COS/N 4354 N194HSFuller Randy M · Mooresville, NCS/N 1517 N2007HElder Robert C · Prosser, WABuilt 1946 · S/N 2630 N2022HGartke Michael L · Waterman, ILBuilt 1946 · S/N 2645 N2024HVarzavand Shahram · Cedar Falls, IABuilt 1946 · S/N 2647 N2034HWustrack Jeffrey F · Wichita, KSS/N 2657 N2038HOgren Michael W · Spring Hill, FLBuilt 1946 · S/N 2661 N2050HCopaair Maintenance Services Inc · Indiantown, FLBuilt 1946 · S/N 2673 N2064HMcbride Devin · Forney, TXS/N 2687 N2078H84 Aviation Llp · Lebanon, OHBuilt 1946 · S/N 2701 N2081HGutierrez Ryan Y · Pacoima, CABuilt 1946 · S/N 2704 N2083HHatcher Joe W · Ripon, WIBuilt 1946 · S/N 2706 N2095HStovall Spencer R · Iuka, MSBuilt 1946 · S/N 2718 N2102HHarvell Randall W · Manteno, ILS/N 2725 N2122HSmith Gaynor J · Clay Center, NEBuilt 1946 · S/N 2745 N2128HVecchio Alfred James · Emerado, NDBuilt 1946 · S/N 2751 N2129HMathison John M · Fernley, NVBuilt 1946 · S/N 2752 N2169HPecoraro Carmine F · Kirkland, WABuilt 1946 · S/N 2792 N2176HLandry Robert J · Winston Salem, NCBuilt 1946 · S/N 2799 N2180HGraf Edwin X · Washington Island, WIBuilt 1946 · S/N 2803 N2213HValentine Rolland N · Atlanta, MIBuilt 1946 · S/N 2836 N2237HEason James D · Leawood, KSBuilt 1946 · S/N 2860 N2239HGreen Michael B · Kent, WABuilt 1946 · S/N 2862 N2240HRoberts Shane · Las Cruces, NMBuilt 1946 · S/N 2863 N2248HPayne Emily R · Lake Mills, IABuilt 1946 · S/N 2871 N2253HBlakely Charles G · Ellijay, GABuilt 1946 · S/N 2878 N2256HKoberstein Tracy T · Pilot Rock, ORS/N 2881 N2270HGehrman Holdings LLC · De Pere, WIBuilt 1946 · S/N 2895 N2278HEcho Matrix LLC · Bentonville, ARBuilt 1946 · S/N 2903 N2279HCook Michael E · Collinsville, ILBuilt 1946 · S/N 2904 N2282HPerkins Gary N · Maineville, OHBuilt 1946 · S/N 2907 N2306HDugas Thomas · Vancouver, WABuilt 1946 · S/N 2931 N2318H355 Flyers Association · Moses Lake, WABuilt 1946 · S/N 2943 N2326HMalmaison Road LLC · Lewes, DEBuilt 1946 · S/N 2951 N23343Gassert Kevin · Cincinnati, OHS/N 2959 N2335HRosenquist Susan L · Chisago City, MNBuilt 1946 · S/N 2960 N2347HKerr Phillip D · Beebe, ARS/N 2972 N2356HRegester Robert H · Indianapolis, INBuilt 1946 · S/N 2981 N2360HWilson Gary L · Moultrie, GAS/N 2985 N2365HCassels William · Phoenix, AZBuilt 1946 · S/N 2990 N2367HGoodman Harlon · Ontario, NYBuilt 1946 · S/N 2992 N2374HCurtner Mark A · Sidney, OHS/N 2999 N2385HNeer Brent A · Nampa, IDS/N 3010

Back to Ercoupe 415-C