OpenAirDocs.org
Monroe, WI

Registered aircraft · 31

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 = 'MONROE'
  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.

N10743Liimatainen William J PIETENPOL SKY SCOUT · S/N 0001Built 2009 · Liimatainen William JN1138DHall Dennis PIETENPOL AIRCAMPER · S/N 001Built 2001 · Johnson Benjamin MN1295UCessna 172M · S/N 17266989Built 1976 · Wolff Timothy W TrusteeN1358EAeronca 7AC · S/N 7AC-4919Built 1946 · Liimatainen William JN19GPFairchild PT-19A · S/N T421844Wegmueller Daniel EN24RZRonald Zweifel GLASAIR/GLASTAR · S/N 5653Built 2020 · Zweifel Ronald MN2837NCessna 140 · S/N 13098Wells Mark AN295YFairchild 24W-41A · S/N W40-102Built 1940 · Wegmueller Daniel EN3109SDJI AGRAS T40 · S/N 5X5BKHT0010A1Dynamic Agronomics LLCN3993BJones Peter M BOEING/JONES 75 · S/N AR-30Built 1984 · Hughes Teresa AN442KBrewster FLEET 7 · S/N 165Built 1929 · Liimatainen William JN474CFRaytheon HAWKER 800XP · S/N 258662Built 2004 · Carrousel Aviation LLCN4931DDJI AGRAS T40 · S/N 64TBK8U001008NDynamic Agronomics LLCN4932DDJI AGRAS T40 · S/N 64TBL1X002006MDynamic Agronomics LLCN5329CCessna 140A · S/N 15449Built 1950 · Vetterli Gary RN635YTEavision EA-J150 · S/N JMZKJ150UAV602595450Timm EricN6381WDavid Waller PIETENPOL AIR CAMPER · S/N DLW-1Waller DavidN701RZZweifel Ronald M ZENITH CH 701 · S/N 7-5108Built 2015 · Zweifel Ronald MN72393Cessna 140 · S/N 9579Built 1946 · Snow Joseph AN7373WPiper PA-28-180 · S/N 28-1255Built 1963 · Colvin Michael EN737SCCessna 172N · S/N 17269631Built 1977 · Isely Alec DN79499Cessna 172K · S/N 17258133Built 1969 · Johnson Benjamin MN797HMonocoupe 125 · S/N 6K19Liimatainen William JN8089BPiper PA-28RT-201T · S/N 28-7921057Bader Bradley CN81369Fairchild 24W-46 · S/N W46269Built 1946 · Liimatainen William JN8143ACessna 170B · S/N 20995Built 1952 · Liimatainen William JN8169ACessna 170B · S/N 25021Built 1952 · Vetterli Gary RN86VFleet 7 · S/N 404Built 1931 · Liimatainen William JN901SCRaytheon HAWKER 800XP · S/N 258561Built 2001 · Sc Aviation IncN921PKRaytheon HAWKER 850XP · S/N 258818Sc Aviation IncN985JCDJI AGRAS T40 · S/N 64TBL61002009SDynamic Agronomics LLC
Back to Monroe, WI