Commerce Township, MI
Registered aircraft · 27
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 = 'MI' AND g.registrant_city = 'COMMERCE TOWNSHIP' 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 = 'MI' AND g.registrant_city = 'COMMERCE TOWNSHIP' 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.
N1200XMooney M20E · S/N 103N203WPat Hernandez CCK-2000 · S/N CCK-2000-0047N205RGame Composites GB1 GAMEBIRD · S/N 0021N214WPAero Adventure AVENTURA II · S/N 02N25713Balloon Works FIREFLY 8B-15 · S/N F8B-465N262RTRobinson Helicopter R66 · S/N 1252N30379Piper J5A · S/N 5-184N310WGCessna 310Q · S/N 310Q0412N313EZCirrus Design SR22T · S/N 8957N325ZCirrus Design SR20 · S/N 1407N349CAviat A-1B · S/N 2043N482KPiper PA-34-200T · S/N 347770272N519PDCirrus Design SR22T · S/N 9977N5981LAmerican AA-1 · S/N AA1-0281N637XLLiberty Aerospace XL-2 · S/N 0108N69513Cameron Balloons Z-90 · S/N 6835N735LWCessna 182Q · S/N 18265518N746TMCirrus Design SR20 · S/N 1654N758BBPiper J3C-65 · S/N 14420N8337YPiper PA-30 · S/N 30-1483N841TMTimothy L Mcginnis BD4+1 MODIFIED · S/N TM01N870TCTop Cat Engineering DJI FLAME WHEEL 450 · S/N TC-450-1N875TCTop Cat Engineering DJI FLAME WHEEL 550 · S/N TC-550-1N922DEAmerican Champion 8KCAB · S/N 1117-2013N960HACompagnie Daher TBM 700 · S/N 1619N9700LBeech B19 · S/N MB-506N9990BCessna 172RG · S/N 172RG1109
Back to Commerce Township, MI