OpenAirDocs.org
Clare, MI

Registered aircraft · 18

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

N126WTReims CESSNA F182Q · S/N 0070Built 1978 · 123 Investments LLCN15383Piper PA-32-260 · S/N 32-7300006Built 1972 · Nevill Donald LN21296Taylorcraft BL-65 · S/N 1093Built 1938 · Witbeck Gerald BN236HSDJI AGRAS T40 · S/N 1581F574B227400102H0Sale reportedN24622DJI T40 · S/N 1581F574B223E00100SZBrown RaquelN2623ADestiny Powered Parachutes D2000 · S/N 1C0206Built 2000 · Dawson James CN290KABeech E-90 · S/N LW59Built 1974 · N290ka LLCN302JPBell 47G-3B-1 · S/N 3582123 Investments LLCN414KWCessna 414A · S/N 414A0281Built 1979 · Bolle Aviation LLCN466SCAmerican Champion 8KCAB · S/N 1186-2020Built 2020 · 123 Investments LLCN4869APiper PA-22-150 · S/N 22-4029Built 1956 · Nevill Bernard LN618JACirrus Design SR22 · S/N 4595Bolle Aviation LLCN70763Piper J3C-65 · S/N 17781Built 1946 · Carter William CN7720JPiper PA-32-260 · S/N 32-11223c Aviation LcN7842DJI AGRAS T40 · S/N 1581F574B237300101U3Sale reportedN94GWCessna T182T · S/N T18208018Built 2001 · J & J 327 LLCN97088Stinson 108-1 · S/N 108-1088Built 1946 · Kunse Ronald EN97288Cessna 182Q · S/N 18267044Built 1979 · Bolle Aviation LLC
Back to Clare, MI