Skip to content

Registered aircraft · 48

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

N123YPLeochner Jason F · Decatur, TXBuilt 1947 · S/N 4503 N127GBaine Larry A · Marne, MIBuilt 1963 · S/N 4795 N2383HSale Reported · Decatur, TXSale reportedBuilt 1946 · S/N 3008 N2415HErcoupe LLC · Colonial Heights, VABuilt 1946 · S/N 3040 N2727HQuada Andrew W · Lowell, MIBuilt 1946 · S/N 3352 N3041HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3666 N3067HGregory Vernon L · Swansea, SCBuilt 1946 · S/N 3692 N3155HPayne Glenn A · Oregon, MOBuilt 1946 · S/N 3780 N3194HSickles Garry M · Minooka, ILS/N 3819 N3272HHeard Gary S · Delta, COS/N 3897 N3452HDuddy Donald Patrick · White City, ORBuilt 1947 · S/N 4077 N3454HBost Kenneth A · Rockwell, NCBuilt 1948 · S/N 4079 N3480HRusch Edward J · Oak Harbor, OHBuilt 1948 · S/N 4105 N3502HCavallaro Jack C · Jordan, NYBuilt 1947 · S/N 4127 N3520HBushnell Cody A · San Antonio, TXS/N 4145 N3563HBoelman Scott · Whittier, CABuilt 1947 · S/N 4188 N3617HRegistration Pending · Beebe, ARRegistration pendingBuilt 1946 · S/N 4242 N3807HBassett Robin · Orlando, FLBuilt 1947 · S/N 4508 N3868HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4569 N3893HCross Franklin O · Huntsville, MOS/N 4594 N3906HKrall James M · Mitchell, SDBuilt 1947 · S/N 4607 N3913HDidier Thomas · Port Washington, WIBuilt 1947 · S/N 4614 N3922HWhite Wayne · Middleburg, FLBuilt 1947 · S/N 4623 N3926DGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4627 N3943HGregory Vernon L · Swansea, SCBuilt 1947 · S/N 4644 N3948HYordan Victor E · Simpsonville, SCBuilt 1947 · S/N 4649 N3966HRokeby Richard F · Tulsa, OKBuilt 1947 · S/N 4667 N3968HCannon Christopher C · Charleston, WVBuilt 1947 · S/N 4669 N3971HPerry Gregory C · Maurice, LABuilt 1947 · S/N 4672 N3977HGaither David G Executor · Houston, TXBuilt 1947 · S/N 4678 N415CDRoehm David L · Leesburg, OHBuilt 1947 · S/N 4523 N433APetty Clifford C · Cedar Hill, TXS/N 4615 N499TTMackentepe Zandra Paige · Vinemont, ALS/N 4664 N772CMDuncan John S · Maple, NCS/N 4662 N87399Lee Justin W · Maud, TXS/N 572 N93337Oneel Cory · Ames, IABuilt 1946 · S/N 660 N94621Specht Leo M · Towner, COBuilt 1947 · S/N 4722 N94625Costilow Bobby W · Griffin, GABuilt 1947 · S/N 4726 N94636Gregory Vernon L · Swansea, SCBuilt 1947 · S/N 4743 N94654Moose James E Jr · Newton, NCBuilt 1947 · S/N 4763 N94667Alee-Jay Enterprises Inc · Topeka, KSBuilt 1947 · S/N 4778 N94676Dwyer Casey M · Stilwell, KSBuilt 1947 · S/N 4787 N94692Fuller William W · Waxahachie, TXBuilt 1947 · S/N 4803 N94715Schmaltz Dennis B · Rapid City, SDBuilt 1947 · S/N 4826 N94729Murphy Thomas · Spring Hill, TNBuilt 1947 · S/N 4840 N94732Babbitt Dennis L · Crawford, TXS/N 4843 N94743Flying Wrenches · Buhl, IDS/N 4854 N94746White Wayne · Middleburg, FLBuilt 1947 · S/N 4857

Back to Ercoupe 415-CD