# Registered aircraft: Clare, MI

A list on [Clare, MI](https://openairdocs.org/faa-place/MI/Clare.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N126WT](https://openairdocs.org/aircraft/N126WT.md): Reims CESSNA F182Q · S/N 0070 · Built 1978 · 123 Investments LLC
- [N15383](https://openairdocs.org/aircraft/N15383.md): Piper PA-32-260 · S/N 32-7300006 · Built 1972 · Nevill Donald L
- [N21296](https://openairdocs.org/aircraft/N21296.md): Taylorcraft BL-65 · S/N 1093 · Built 1938 · Witbeck Gerald B
- [N236HS](https://openairdocs.org/aircraft/N236HS.md): DJI AGRAS T40 · S/N 1581F574B227400102H0 · Sale reported
- [N24622](https://openairdocs.org/aircraft/N24622.md): DJI T40 · S/N 1581F574B223E00100SZ · Brown Raquel
- [N2623A](https://openairdocs.org/aircraft/N2623A.md): Destiny Powered Parachutes D2000 · S/N 1C0206 · Built 2000 · Dawson James C
- [N290KA](https://openairdocs.org/aircraft/N290KA.md): Beech E-90 · S/N LW59 · Built 1974 · N290ka LLC
- [N302JP](https://openairdocs.org/aircraft/N302JP.md): Bell 47G-3B-1 · S/N 3582 · 123 Investments LLC
- [N414KW](https://openairdocs.org/aircraft/N414KW.md): Cessna 414A · S/N 414A0281 · Built 1979 · Bolle Aviation LLC
- [N466SC](https://openairdocs.org/aircraft/N466SC.md): American Champion 8KCAB · S/N 1186-2020 · Built 2020 · 123 Investments LLC
- [N4869A](https://openairdocs.org/aircraft/N4869A.md): Piper PA-22-150 · S/N 22-4029 · Built 1956 · Nevill Bernard L
- [N618JA](https://openairdocs.org/aircraft/N618JA.md): Cirrus Design SR22 · S/N 4595 · Bolle Aviation LLC
- [N70763](https://openairdocs.org/aircraft/N70763.md): Piper J3C-65 · S/N 17781 · Built 1946 · Carter William C
- [N7720J](https://openairdocs.org/aircraft/N7720J.md): Piper PA-32-260 · S/N 32-1122 · 3c Aviation Lc
- [N7842](https://openairdocs.org/aircraft/N7842.md): DJI AGRAS T40 · S/N 1581F574B237300101U3 · Sale reported
- [N94GW](https://openairdocs.org/aircraft/N94GW.md): Cessna T182T · S/N T18208018 · Built 2001 · J & J 327 LLC
- [N97088](https://openairdocs.org/aircraft/N97088.md): Stinson 108-1 · S/N 108-1088 · Built 1946 · Kunse Ronald E
- [N97288](https://openairdocs.org/aircraft/N97288.md): Cessna 182Q · S/N 18267044 · Built 1979 · Bolle Aviation LLC

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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
```

This list as a web page: https://openairdocs.org/faa-place/MI/Clare/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.