River Falls, WI

Registered aircraft · 43

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 = 'RIVER FALLS'
  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.

N12562Cessna 172M · S/N 17262075Built 1973 · Weinreich Mark WN140DACessna 525A · S/N 525A0140Built 2003 · Ramsey Hill Aviation LLCN14HFMaule MT-7-235 · S/N 18084CBuilt 2003 · Skopek Darin AN156MLCessna 525 · S/N 525-0156Built 1996 · Air Miles LLCN1999VCessna 140 · S/N 14210Built 1947 · Weinreich Mark WN2004YTaylorcraft F21 · S/N F-1008Built 1980 · Amorelli Leon DN219SMHines Ronald L RV6A · S/N 24094Built 1998 · Steger Paul GN222APiaggio P.136-L1 · S/N 194Ocean Air IncN2581APiper PA-18-135 · S/N 18-2157Built 1952 · Sattler Philip JN2683PConsolidated Aeronautics LAKE LA-4-200 · S/N 891Jilek Dominic AN29396Culver LCA · S/N 189Built 1940 · Jilek Dominic AN3067MPiper PA-12 · S/N 12-1754Built 1947 · King NolanN3113BPereyra Arnet AVENTURA II · S/N AP2A0100Built 2005 · Schmidt Matthew FN36654Aeronca 65-CA · S/N C17311Built 1941 · Pace Danny WN386CBDJI AGRAS T40 · S/N 64TBLBH0020022Boles LeeN40907Piper J3C-65 · S/N 7585Built 1941 · Skopek Darin AN4216BBeech F35 · S/N D-4175Built 1955 · Rasmussen Nathan AN4NBCessna 182M · S/N 18259860Built 1969 · Greenslip Aviation LLCN532BBeech A35 · S/N D-1547Built 1948 · Weinreich Mark WN546AJEavision EA-J150 · S/N JMZKJ150UAV602595158Crm Services LLCN547EBEavision EA-J150 · S/N JMZKJ150UAV602595828Boles Lee AN56529Piper PA-34-200 · S/N 34-7350346Built 1973 · Jilek Peter AN6073NBeech B23 · S/N M-1166Built 1968 · Rozinka Jay CN6246GCessna 150K · S/N 15071746Schlotte Benjamin RN6470BCessna 172 · S/N 29670Built 1957 · Schlotte Randall VN6545ACessna 180 · S/N 32442Wunrow Steven MN6600TCessna 172D · S/N 17249906Built 1962 · Jtf Aviation LLCN6612ACessna 172 · S/N 28712Built 1956 · Mazac Kennith MN6830UMooney M20D · S/N 201Built 1963 · Jilek Dominic AN7000RPiper PA-28-140 · S/N 28-21693Built 1966 · Jilek Peter AndrewN7170BPiper PA-18 · S/N 18-5200Built 1956 · Zimniewicz Matthew JN7444ZStephenson Wilbur R ZENAIR ZODIAC 601HDS · S/N 6-3444Built 1999 · Emeott Richard WN7707MMooney M22 · S/N 670003Built 1967 · Jilek Dominic AN7771WPiper PA-28-180 · S/N 28-1773Built 1964 · Whitman Edward GN8266KStinson 108-1 · S/N 108-1266Built 1946 · Jilek Dominic AN85910Petrone HOMEBUILT · S/N WRP-2Built 2013 · Weinreich Mark WN8868UCessna 172F · S/N 17252784Built 1965 · Muller Robert JN891SRCessna 172G · S/N 17253588Built 1966 · Omalley Benjamin PN89328Cessna 140 · S/N 8356Built 1946 · Schlotte Randy VN920JRCessna 525A · S/N 525A0060Built 2002 · Ramsey Hill Exploration LLCN9434JPiper PA-28-180 · S/N 28-3546Built 1966 · Schmidt Matthew FN9475KStinson 108-2 · S/N 108-2475Built 1947 · Amorelli Leon DN953RNNoll Roddy Brooks KELLY D · S/N RN4Built 1988 · Weinreich Mark W
Back to River Falls, WI