Mequon, WI
Registered aircraft · 22
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 = 'MEQUON' 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 = 'MEQUON' 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.
N122BVans RV-12IS · S/N 121231N1517UCessna 207 · S/N 20700117N1522RCessna 172S · S/N 172S10716N2996FCessna 182J · S/N 18257096N3533Finco John R R2005 · S/N EXHB5233N3533WCessna T182T · S/N T18208029N518PCCessna 340A · S/N 340A0433N6040RBeech 58 · S/N TH-1026N609CCirrus Design SR22 · S/N 0440N692AWCirrus Design SR22T · S/N 11149N700YBBombardier BD-700-1A10 · S/N 9377N721HWSchlei Howard W A600LR · S/N 6995N733HBHawker Beechcraft HAWKER 750 · S/N HB-73N737JBBoeing 737-7BC · S/N 30572N738SSCessna 172N · S/N 17270206N8933Beech F33A · S/N CE-1384N895CMPiper PA 46-350P · S/N 4636826N900CMTextron 680 · S/N 680-0591N917LMCirrus Design SR20 · S/N 2383N9495NPiper PA-28R-200 · S/N 28R-35216N9535JPiper PA-28-180 · S/N 28-3662N9963WCirrus Design SR22T · S/N 9097
Back to Mequon, WI