Menomonee Falls, WI
Registered aircraft · 24
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 = 'MENOMONEE 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 = 'MENOMONEE 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.
N1226YCessna 150B · S/N 15059626N1267TAmerican Champion 7GCBC · S/N 1477-2020N13719Cessna 172M · S/N 17262966N2027QCessna 177RG · S/N 177RG0427N240AKAmerican Champion 8KCAB · S/N 1129-2013N269TPSchweizer 269C-1 · S/N 0110N410LTAlfheim III EPIC LT · S/N 035N410SCEnstrom Helicopter 480 · S/N 5026N4728ATextron T206H · S/N T20609707N53FTFeibao Jets T-33 · S/N FBT-33MIN5503QMooney M20C · S/N 2940N642CHMooney M20R · S/N 29-0457N69398Stinson VULTEE V-77 · S/N 77-293N696BFDJI PHANTOM 3 ADVANCED · S/N P76DCG24A10490N71172Luscombe 8A · S/N 2599N76LMPavlovich M/Pavlovich L M RV6A · S/N 22604N77QBCessna 340A · S/N 340A0120N78MFCirrus Design SR20 · S/N 10760N828JVans RV-12 · S/N 120317N900JNDJI AGRAS T50 · S/N 1581F6BUB248U001FN2BN9020VBeech E-55 · S/N TE-768N92VGCirrus Design SF50 · S/N 0551N985GGoedde William J RANS S-12S AIRAILE · S/N 0295560N9BNBeech A36 · S/N E-2046
Back to Menomonee Falls, WI