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.

N2549HStilson Terrence L · Azle, TXBuilt 1946 · S/N 3174 N2556HCrandell Anthony Gene · Lamoni, IABuilt 1946 · S/N 3181 N2560HSale Reported · Oklahoma City, OKSale reportedBuilt 1946 · S/N 3185 N2574HBarton Robert Lee Jr · Silverdale, WABuilt 1946 · S/N 3199 N2581HSenior Solutions LLC · Well, NVBuilt 1946 · S/N 3206 N2583HFly Again LLC · Tulsa, OKBuilt 1946 · S/N 3208 N2587HHarvell Joshua L · Salem, WIBuilt 1946 · S/N 3212 N2594HLongfellow Christopher Kirk · St Louis Park, MNBuilt 1946 · S/N 3219 N2601HWilliams Joe A · Grants Pass, ORBuilt 1946 · S/N 3226 N2607HButler Thomas M · Savannah, GAS/N 3232 N2623HWalmart Inc · Rogers, ARBuilt 1946 · S/N 3248 N2628HBecquer Jordan · Lees Summit, MOBuilt 1946 · S/N 3253 N262BWRialto Christian Flyers Club Inc · Bradenton, FLS/N 4295 N2630HWahlberg Ranoy A · Pearland, TXS/N 3255 N2636HMaine Aviators LLC · Solon, MEBuilt 1946 · S/N 3261 N2638HJones Emmett F III · Minden, LABuilt 1946 · S/N 3263 N2654HDe Vargas Norberto X · Modesto, CABuilt 1946 · S/N 3279 N266AEnterra LLC · Aroda, VAS/N 569 N2674HWilson Dennis R Trustee · Houston, MOBuilt 1946 · S/N 3299 N2699HForsyth Technical Community College · Winston Salem, NCS/N 3324 N2713HUrban Joe P · Ben Wheeler, TXBuilt 1946 · S/N 3338 N2733HMcguire Michael K · Elba, ALBuilt 1946 · S/N 3358 N2744HLemke Lee L · Cecil, WIBuilt 1946 · S/N 3369 N2790HPhelps Frank R Jr · Muskegon, MIS/N 3415 N2853HIves Jackson C · Columbia Station, OHBuilt 1946 · S/N 3478 N2870HTrahan John L II · Lebanon, ORS/N 3495 N28943Gassert Kevin J · Cincinnati, OHBuilt 1941 · S/N 38 N2921HSullivan Michael A · Reno, NVBuilt 1946 · S/N 3546 N2936HHeideman Christopher M · New London, WIBuilt 1946 · S/N 3561 N2943HBreon Shawn · Rockford, ILBuilt 1946 · S/N 3568 N2955HLindsey Nicholas · Upland, CABuilt 1946 · S/N 3580 N2973HByrnes Brandyn · Burien, WABuilt 1946 · S/N 3598 N2988HKramer Craig W · Dyersville, IABuilt 1946 · S/N 3613 N299DWWebb Douglas C · Mullica Hill, NJBuilt 1946 · S/N 1871 N3074HJohnson Victor R · Modesto, CABuilt 1946 · S/N 3699 N3084HFoster Wayne A · West Haven, CTBuilt 1946 · S/N 3709 N3090HWebb Willard N · Key Largo, FLBuilt 1946 · S/N 3715 N3121HArnold Thomas J · Hooker, OKBuilt 1946 · S/N 3746 N3143HBuckley Barney P · Colfax, WABuilt 1946 · S/N 3768 N3158HReed Brenda L · Hopland, CAS/N 3783 N3201HSale Reported · Miami, FLSale reportedBuilt 1946 · S/N 3826 N3222HRhodes Bobby T · Palmdale, CABuilt 1946 · S/N 3847 N3250HLee Justin W · Maud, TXS/N 3875 N3267HZemaitis Richard A · Birchwood, WIBuilt 1946 · S/N 3892 N3286HAllison Rodney L · Keizer, ORBuilt 1946 · S/N 3911 N3308HHaag Dale · West Saint Paul, MNBuilt 1946 · S/N 3933 N331WMHall Russell W · Teague, TXBuilt 1946 · S/N 227 N3320HHatley Ralph A · Eagle Creek, ORFirst renewal noticeBuilt 1947 · S/N 3945 N3344HHenry Stephen M · Newberry, FLBuilt 1946 · S/N 3969 N3353HMccormick William K · Fitzwilliam, NHBuilt 1946 · S/N 3978

Back to Engineering & Research ERCOUPE 415-C