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_numberRun 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.
N94157Coles Nathan A · Alta Loma, CAN94161Sale Reported · Crystal, MNSale reportedN94174Stork Matthew J · Mulberry, FLN94184Zheng Kevin · S San Fran, CAN94306Winn Gary M · Lake Charles, LAN94310Rioux Roger · Corpus Christi, TXN94313Emley Richard A · Huntington, INN94327Sprang Russell D · Mansfield, OHN94352Burkhead Claude I III · Apex, NCN94378Kittner Robert T · Ellenville, NYN94379Post Greg G · Mapleton, KSN94380O'Neel Cory P · Ames, IAN94604Johnson Earl A · Jordan, MNN94606Hurd Alexander D · Liberty Township, OHN94639Conrad Daniel R · Sweet Home, ORN946BFDelmarva Skies LLC · Milton, DEN94716Beach Andrew N · Hawthorne, NVN99008Hays Gary R · Chino Valley, AZN99009Fennig Trevor L · Bryant, INN99011Redding Doug Trustee · Sapulpa, OKN99023May John D · Ward, ARN99028Demarzo Alexander J · Flower Mound, TXN99058Williams David E · Sadieville, KYN99068Macklam George L · Scottville, MIN99069Davenport Jimmy J · Hayesville, NCN99117Sanders John L · Sikeston, MON99119Carpenter William Edward · Mason, TNN99127Mears Benjamin W · Eastville, VAN99150Eaa Chapter 1699 Inc · Selkirk, NYN99155Hiett Joseph Warren · Juliette, GAN99208Dakota Territory Air Museum Inc · Minot, NDN99217Rising Lisa Ann · Ocala, FLN99224Continental Title Trust LLC Trustee · Wichita, KSN99299Gilson David R · New Port Richey, FLN99303Howser Kevin E · Fort Ashby, WVN99304Gregory Vernon L · Swansea, SCN99306Kemper Joseph C · Coxs Mills, WVN99316Ingram Robert L · Stanley, VAN99339Coe Patrick K · Bellingham, WAN99345Porter Steven B · Corning, IAN99350Hallett Terry L · Bryan, OHN99357Carlson Bruce D · Umatilla, ORN99365Sharp Richard L · Decatur, ILN99373Gregory Vernon L · Swansea, SCN99389Jenneve Philippe A · Lancaster, MAN99404Buchta Joshua A · Harrisburg, PAN99439Wittco Aero LLC · Vancouver, WAN99462Hattel Arthur L · Huntingdon, PAN99477Masterman Julayne A · Muncie, INN99490Buchanon Lonnie J · Bell, FL
Back to Engineering & Research ERCOUPE 415-C