Menomonie, WI
Registered aircraft · 48
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 = 'MENOMONIE' 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 = 'MENOMONIE' 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.
N104FSCessna 172S · S/N 172S8253N11214Xag P100 PRO · S/N 82194257KN24N1121LLake LA-4 · S/N 283N11854Bellanca 7ECA · S/N 825-72N12919Cessna 172M · S/N 17262372N142JWMoravan Aircraft Works Z 142C · S/N 0549N142MPMooney M20L · S/N 26-0023N150ABeech T-34A · S/N G-10N18UFSchempp-Hirth VENTUS CM · S/N 94N201BUMooney M20J · S/N 24-0320N2292YCessna 177 · S/N 17700092N2834HErcoupe 415-C · S/N 3459N31729Lorberter Daryl R LORBERTER/CHALLNGRII · S/N CH2-0206-2720N3547SCessna 172E · S/N 17250747N3561CCessna 170B · S/N 26605N3940JCessna 150G · S/N 15065240N39647Piper PA-32RT-300 · S/N 32R-7885233N40004Piper PA-28R-201 · S/N 28R-7737126N424RWWestphal Reuben G LONGEZE · S/N 728N45028Cessna 150M · S/N 15076706N4539APiper PA-22-150 · S/N 22-3848N4679UCessna 180G · S/N 18051379N4769JJoshua A Bergmann RV-10 QUICKBUILD · S/N 42532N484CCMooney International M20V · S/N 33-0009N500BKErcoupe 415-C · S/N 442N5173ZPiper PA-22-108 · S/N 22-8837N5551FPiper PA-28-140 · S/N 28-24890N5796NRockwell International 114 · S/N 14369N5874ACessna 172 · S/N 28474N6599UTurner Vernon H KITFOX III · S/N 813N6710Svenningsen Joshua J SAFARI 400 · S/N 1000N6849PPiper PA-24-250 · S/N 24-1983N684JSSvenningsen Joshua J JS-1 · S/N 1001N701HCClausing Howard CH 701 · S/N 7-1358N723DJCessna T182T · S/N T18208328N735TPCessna 182Q · S/N 18265673N75866Cessna 172N · S/N 17268009N7591SCessna 182Q · S/N 18265240N76BABeech A36 · S/N E-783N77266Cessna 120 · S/N 11394N800EQBeech 65 · S/N LF-24N8297SCessna 150F · S/N 15061897N8340WPiper PA-28-180 · S/N 28-2523N8434XCessna 172C · S/N 17248934N93343Cessna A185F · S/N 18503225N933PCChristen Industries PITTS S-2B · S/N 5193N9582UMooney M20K · S/N 25-0496N997JMSocata TBM 700 · S/N 244
Back to Menomonie, WI