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.
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
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.
N12562Cessna 172M · S/N 17262075N140DACessna 525A · S/N 525A0140N14HFMaule MT-7-235 · S/N 18084CN156MLCessna 525 · S/N 525-0156N1999VCessna 140 · S/N 14210N2004YTaylorcraft F21 · S/N F-1008N219SMHines Ronald L RV6A · S/N 24094N222APiaggio P.136-L1 · S/N 194N2581APiper PA-18-135 · S/N 18-2157N2683PConsolidated Aeronautics LAKE LA-4-200 · S/N 891N29396Culver LCA · S/N 189N3067MPiper PA-12 · S/N 12-1754N3113BPereyra Arnet AVENTURA II · S/N AP2A0100N36654Aeronca 65-CA · S/N C17311N386CBDJI AGRAS T40 · S/N 64TBLBH0020022N40907Piper J3C-65 · S/N 7585N4216BBeech F35 · S/N D-4175N4NBCessna 182M · S/N 18259860N532BBeech A35 · S/N D-1547N546AJEavision EA-J150 · S/N JMZKJ150UAV602595158N547EBEavision EA-J150 · S/N JMZKJ150UAV602595828N56529Piper PA-34-200 · S/N 34-7350346N6073NBeech B23 · S/N M-1166N6246GCessna 150K · S/N 15071746N6470BCessna 172 · S/N 29670N6545ACessna 180 · S/N 32442N6600TCessna 172D · S/N 17249906N6612ACessna 172 · S/N 28712N6830UMooney M20D · S/N 201N7000RPiper PA-28-140 · S/N 28-21693N7170BPiper PA-18 · S/N 18-5200N7444ZStephenson Wilbur R ZENAIR ZODIAC 601HDS · S/N 6-3444N7707MMooney M22 · S/N 670003N7771WPiper PA-28-180 · S/N 28-1773N8266KStinson 108-1 · S/N 108-1266N85910Petrone HOMEBUILT · S/N WRP-2N8868UCessna 172F · S/N 17252784N891SRCessna 172G · S/N 17253588N89328Cessna 140 · S/N 8356N920JRCessna 525A · S/N 525A0060N9434JPiper PA-28-180 · S/N 28-3546N9475KStinson 108-2 · S/N 108-2475N953RNNoll Roddy Brooks KELLY D · S/N RN4
Back to River Falls, WI