OpenAirDocs.org
La Crosse, WI

Registered aircraft · 36

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 = 'LA CROSSE'
  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.

N10011Schleicher KA 10 · S/N 10011Fullerton Alan DN126WBAmerican Champion 8KCAB · S/N 983-2005Built 2005 · Flying Blank LLCN1636YCessna 172C · S/N 17249336Built 1962 · Hokanson Anthony DrakeN242SCCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 06SC005Built 2006 · Wilhelm DanielN299CAAviat A-1B · S/N 2294Built 2005 · Scenic Concepts LLCN350CTBeech 35-C33A · S/N CE-14Built 1966 · Maas Karl GN3788VCessna 140A · S/N 15209Built 1949 · Graves Kenneth DN3846ASchweizer SGS 1-23G · S/N 43Fullerton Alan DN388UTCessna T206H · S/N T20608620Free Bird Air LLCN4365FPiper PA-28-181 · S/N 28-8490082Built 1984 · Bumgardner Jerry CN44384Taylorcraft BC12-D1 · S/N 10184Built 1946 · Thomas William EN46489Piper J3C-65 · S/N G-124Built 1945 · Findlay Benjamin JN47808Cessna 152 · S/N 15283253Built 1979 · Colgan Aviation LLCN4851HPiper PA-17 · S/N 17-151Built 1948 · Baumgartner Thomas AN486HPBeech F33A · S/N CE-1342Built 1989 · Slipstream Aviation LLCN5480ECessna 172N · S/N 17271877Built 1978 · Colgan Aviation LLCN5659ACessna 172 · S/N 28259Built 1957 · Chaouki RebeccaN618GLAirbus Helicopters Deutschland MBB-BK 117 C-2 · S/N 9760Built 2016 · Gundersen Lutheran Medical Center IncN6618WPiper PA-28-140 · S/N 28-20713Built 1965 · Le AriyaN6GSSpeer AEROSPORT QUAIL · S/N 1Built 1976 · Bornheimer Martin AN718PTMooney M20R · S/N 29-0294Built 2003 · Technology Transportation Co IncN725BBCessna 172N · S/N 17267802Built 1976 · Scenic Concepts LLCN7350RCessna R182 · S/N R18200646Built 1978 · Scenic Concepts LLCN7603TCessna 172A · S/N 47203First renewal noticeMurphy Brian KN79172Cessna 172K · S/N 17257934First renewal noticeBuilt 1969 · Colgan Aviation LLCN816FCCessna 525B · S/N 525B-0096Built 2006 · Fortney Companies IncN841JWCessna 172M · S/N 17264340Built 1974 · Scenic Concepts LLCN865LTPilatus P3 · S/N A-865Built 1959 · Hogan David AN8720NPiper PA-28-140 · S/N 28-25532Built 1969 · Hogan David AN88579Piper J3C-65 · S/N 16205Built 1946 · Graves Kenneth DN88981Aer-Pegaso M-100S · S/N 041Built 1963 · Fullerton Alan DN906GLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9089Gundersen Lutheran Medical Center IncN915ENVans RV-12 · S/N 120959Built 2018 · Driftless Region Youth FlightN948SMCessna 172RG · S/N 172RG1057Built 1982 · Scenic Concepts LLCN9536MCirrus Design SR22 · S/N 4143Built 2014 · Dsn Holdings LLCN95423Piper PA-28-140 · S/N 28-25941Built 1969 · Fullerton Alan D
Back to La Crosse, WI