OpenAirDocs.org
Northwestern Michigan College

Registered aircraft · 21

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

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_name = 'NORTHWESTERN MICHIGAN COLLEGE' OR list_contains(g.other_registrant_names, 'NORTHWESTERN MICHIGAN COLLEGE')
  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.

N157KCCessna 172S · S/N 172S11037Built 2010 · Traverse City, MIN172FACessna 172S · S/N 172S11167Built 2012 · Traverse City, MIN17GMTextron 172S · S/N 172S12769Built 2021 · Traverse City, MIN17MVTextron 172S · S/N 172S12598Built 2020 · Traverse City, MIN182NWCessna 172S · S/N 172S11043Built 2010 · Traverse City, MIN183NWCessna 172S · S/N 172S11083Built 2011 · Traverse City, MIN184NWCessna 172S · S/N 172S11085Built 2010 · Traverse City, MIN195NWCessna 172S · S/N 172S11095Built 2011 · Traverse City, MIN228NWDJI AGRAS T20P · S/N 64UBL85002001VTraverse City, MIN27MVTextron 172S · S/N 172S12599Built 2020 · Traverse City, MIN296NWCessna 172S · S/N 172S11096Built 2011 · Traverse City, MIN404CHPiper PA-23-250 · S/N 27-7654191Built 1976 · Traverse City, MIN52519Cessna 172S · S/N 172S10903Built 2009 · Traverse City, MIN5252JCessna 172S · S/N 172S10904Built 2009 · Traverse City, MIN644DRPiper PA-18A-135 · S/N 18-2867Built 1953 · Traverse City, MIN671MCPiper PA-44-180 · S/N 4496601Built 2025 · Traverse City, MIN672MCPiper PA-44-180 · S/N 4496640Built 2026 · Traverse City, MIN78BYAmerican Champion 8KCAB · S/N 974-2005Built 2005 · Traverse City, MIN821STTextron 172S · S/N 172S12772Built 2021 · Traverse City, MIN9181PCessna 172S · S/N 172S11084Built 2011 · Traverse City, MIN921BBTextron 172S · S/N 172S13232Built 2024 · Traverse City, MI
Back to Northwestern Michigan College