Skip to content

Engineering & Research ERCOUPE 415-C

Registered aircraft · 272

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 ('0420312')
  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 ('0420312')
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.

N103JFJudkovitz Shmuel · Brooklyn, NYBuilt 1946 · S/N 745 N104BKnl Associates LLC · Mansfield, OHBuilt 1946 · S/N 2533 N116JKJetran LLC · Horseshoe Bay, TXBuilt 1946 · S/N 4276 N13CLCrawford Dennis E · Williams, ORBuilt 1946 · S/N 1985 N2001HBlake Bobby J · Eugene, ORS/N 2624 N2006HLegrand Stephen L · Oro Valley, AZBuilt 1946 · S/N 2629 N2026HFlying R Aviation LLC · Smackover, ARBuilt 1946 · S/N 2649 N2028HAustin Christopher L · Waxahachie, TXBuilt 1946 · S/N 2651 N2035HPoliak Mark A Trustee · Carmel, INBuilt 1946 · S/N 2658 N2048HLund Patrick · Gilmer, TXBuilt 1946 · S/N 2671 N2049HArquer Nicholas R · Rancho Cucamonga, CAS/N 2672 N2056HKieffer William A · Chillicothe, MOBuilt 1946 · S/N 2662 N2091HCripe Daniel J · Kuna, IDBuilt 1946 · S/N 2714 N2093HAdams Ronald B · Statesboro, GABuilt 1946 · S/N 2716 N2094HBoulet Robert B · Atlanta, GABuilt 1946 · S/N 2717 N2099HVess Gerald · Livingston, TXS/N 2722 N2113HFitzgerald Anthony M · Crete, NEBuilt 1946 · S/N 2736 N2121HPoulos Nicholas · Andersonville, GABuilt 1946 · S/N 2744 N2133HJonsson Erik Trustee · Twin Falls, IDBuilt 1946 · S/N 2756 N2138HBowels Larry L · Mcgregor, TXBuilt 1946 · S/N 2761 N2139HRay Paul D · Rochester, MNBuilt 1946 · S/N 2762 N2141HMcallister William R · League City, TXBuilt 1946 · S/N 2764 N2147HPenley Brian L · Westfield, INBuilt 1946 · S/N 2770 N2148HRobb Cattle Co LLC · Doniphan, NEBuilt 1946 · S/N 2771 N2181HHirsch Randall L · Mc Donald, TNBuilt 1946 · S/N 2804 N2185HKeys Sharlynn L · Sunset, TXBuilt 1946 · S/N 2808 N2201HSalvaggio Anthony Jr · Union City, MIBuilt 1946 · S/N 2824 N2207HRodamaker Craig M · Brainerd, MNS/N 2830 N2214HDailey Joe R · Oneonta, ALS/N 2837 N2217HGassert Kevin J · Cincinnati, OHBuilt 1946 · S/N 2840 N2222HPelican Aviation LLC · Hattiesburg, MSBuilt 1946 · S/N 2845 N2244HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 2867 N2264HWhite Vernon R · Owasso, OKBuilt 1946 · S/N 2889 N2268HCarden Keith A · Barneveld, WIBuilt 1946 · S/N 2893 N2271HQuirk Kirby Patrick · Flint, TXBuilt 1946 · S/N 2896 N2274HBarts Flying Service Inc · Storm Lake, IABuilt 1946 · S/N 2899 N2287HM3 Aviation LLC · Wausau, WIS/N 2912 N2361HStotts Thomas E · Spokane, WAS/N 2986 N2384HBressman John W · Belton, MOBuilt 1946 · S/N 3009 N2400HDavis Mark W · Syracuse, KSBuilt 1946 · S/N 3025 N2404HMcmillan Jimmie R · Breckenridge, TXBuilt 1946 · S/N 3029 N2409HLocke Greg DBA · Jacksonville, TXS/N 3034 N2417HSandwith Richard B · Puyallup, WAS/N 3042 N2438HMiley Ollie Z · Sacramento, KYBuilt 1946 · S/N 3063 N2448HNovotny Joseph J · Newark, DEBuilt 1946 · S/N 3073 N2458HDeyoe Allen S · Orion, ILBuilt 1946 · S/N 3083 N2471HLord Jason T · Show Low, AZBuilt 1946 · S/N 3096 N2473HSimmons David E · Cambridge, MDBuilt 1946 · S/N 3098 N2486HMartin Rodney R · Knoxville, IABuilt 1946 · S/N 3111 N2501HPoliak Mark A · Carmel, INS/N 3126

Back to Engineering & Research ERCOUPE 415-C