OpenAirDocs.org
Hayward, WI

Registered aircraft · 25

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_state = 'WI' AND g.registrant_city = 'HAYWARD'
  ORDER BY g.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.

N131TLAirbus Helicopters EC 130 T2 · S/N 8254Built 2016 · Link Snacks IncN1917UCessna A185E · S/N 185-1588Built 1969 · Pinewood Homes LLCN2252TCessna A185E · S/N 185-1410Registration pending, pending cancellationBuilt 1968N24170Funk B75L · S/N 196Built 1940 · Hanna Bay Holdings LLCN2612QCessna 182K · S/N 18257812Labarre Ben AN27900Piper J3C-65 · S/N 4434Built 1940 · Korn Clifton AN2875HEngineering & Research 415-C · S/N 3500Built 1946 · Boley Richard JN2904QCessna A185F · S/N 18503541Built 1978 · Boley Richard JN351JLBombardier BD-100-1A10 · S/N 20775Built 2018 · Link Snacks IncN361JLBombardier BD-100-1A10 · S/N 20944Built 2023 · Link Snacks IncN490DCCessna 140 · S/N 9123Wulff John DN498HSJames R Schilling RANS S-7 · S/N 0310540Schilling James RN50067Cessna 172N · S/N 17272811Prop Wash Aviation LLCN5582LAlon A2 · S/N A-130Hyr IncN58832Cessna 182P · S/N 18262328Built 1973 · Wiley Eleven Eleven LtdN594DJEavision EA-J70 · S/N JMZKJ070UAV612555316Jonjak Cranberry Farm IncN6044SBeech 58P · S/N TJ-42Built 1976 · Pinewood Properties LLCN67AWWereley Andrew L RV-8 · S/N 80234Registration pendingBuilt 2009N713TACirrus Design SR20 · S/N 2636Built 2020 · Sutton Logistics LLCN7241MCessna 175 · S/N 55541Built 1958 · Labarre Ben AN7660GCessna 172L · S/N 17259360Built 1970 · Korn Clifton AN7915HPiper PA-12 · S/N 12-819Built 1946 · Hanna Bay Holdings LLCN8047QCessna 421B · S/N 421B0047Built 1970 · Air Boys IncN8091CPiper PA-22-135 · S/N 22-2237Built 1954 · Olson Christian AN8291NPiper PA-28-140 · S/N 28-25509Built 1969 · Peters Rodney A Jr
Back to Hayward, WI