Marquette, MI
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 = 'MI' AND g.registrant_city = 'MARQUETTE' 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 = 'MARQUETTE' 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.
N1355WMooney M20C · S/N 2636N1462TPiper PA-28-140 · S/N 28-7225523N16128Cessna 150L · S/N 15073497N177GWCessna 177B · S/N 17702481N2486XCessna 182H · S/N 18256386N286DSDiamond Aircraft Ind DA 40 · S/N 40.286N30589Piper J3L-65 · S/N 4957N454JMAviat S-2C · S/N 6076N51306Cessna 150J · S/N 15069911N531MRBentlage Roger E VANS RV-7 · S/N 72035N556SBVans RV-12IS · S/N 121337N60447Cessna 150J · S/N 15070314N6348WPiper PA-28-140 · S/N 28-20406N7292GCessna 172K · S/N 17258992N75469Destiny RED DESTINY 2000 · S/N 4C0550N76203Cessna 120 · S/N 10606N80336Cessna 172M · S/N 17266530N90092Cessna 140 · S/N 9153N906WMDJI INSPIRE 2 · S/N 09YDE310040258N9443NPiper PA-28R-200 · S/N 28R-35157N9472JPiper PA-28-180 · S/N 28-3587N986FBPiper PA-28-181 · S/N 28-7790074
Back to Marquette, MI