OpenAirDocs.org
Charlevoix, MI

Registered aircraft · 31

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 = 'CHARLEVOIX'
  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.

N1153LLake LA-4 · S/N 315Built 1965 · Seelye Donald CN12008Maule M-4 · S/N 18Built 1963 · Dvoracek Dana JN141DZPacific Aerospace 750XL · S/N XL 150Built 2008 · Liam 750 IncN1903XCessna 182H · S/N 18256003Built 1965 · Aivcon IncN2032XCessna 182H · S/N 18256132Built 1965 · Aiv Con IncN2403QCessna 182J · S/N 18257603Built 1966 · Skydive Harbor Springs IncN26368Grumman American Avn. AA-5A · S/N AA5A0544Built 1978 · Parker Dennis AN264MDRichardson Michael J KOLB MARK III · S/N M3-189Built 1999 · Stolpmann KarenN287TCCessna 182N · S/N 18260183Built 1969 · Aiv Con IncN3191SCessna 182G · S/N 18255691Built 1964 · Skydive Harbor Springs IncN34531Aeronca 65-CA · S/N C15191Built 1941 · Parker Dennis AN3927UPartenavia P.68C · S/N 282Built 1983 · Fresh Air Aviation IncN406CWBritten-Norman BN2A-26 ISLANDER · S/N 891Built 1980 · Mcphillips Flying Service DBAN41HWBeech 65 (L23F) · S/N LF73Fresh Air Aviation IncN42649Cessna 182L · S/N 18259123Built 1968 · Skydive Harbor Springs IncN47051Aeronca 0-58B · S/N 058B-11363Registration pendingBuilt 1943N4772ECessna 172N · S/N 17271637Built 1978 · Drost Larry LN477BGGrumman American Avn. AA-5A · S/N AA5A0364Built 1977 · Parker Dennis AN5078GBeech 65 · S/N LF-8Built 1960 · Fresh Air Aviation IncN5355SPiper PA46-500TP · S/N 4697136Built 2002 · John Galt Industries LLCN58944Cessna 182P · S/N 18262415Built 1973 · Cassada Josh AN6AJPiper J3C-75 · S/N 2732Built 1939 · Parker Dennis AN71149Cessna 182M · S/N 18259511Built 1968 · Skydive Harbor Springs IncN71551Cessna 182M · S/N 18259662Built 1969 · Aivcon IncN750VLPacific Aerospace 750XL · S/N 182Built 2012 · Liam 750 IncN75NLPartenavia P.68C · S/N 312Fresh Air Aviation IncN7638YPiper PA-30 · S/N 30-717Built 1965 · Scientific Motive Systems IncN768TUVans RV-12IS · S/N 121191Built 2022 · Grieb Michael HN9450ECessna 182R · S/N 18268412Built 1984 · Aivcon IncN9497ECessna 182R · S/N 18268420Built 1984 · Aivcon IncN95BNBritten-Norman BN-2A-8 · S/N 95Built 1969 · Mcphillips Flying Service Inc
Back to Charlevoix, MI