# Registered aircraft: Canton, SD

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

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

- [N238GS](https://openairdocs.org/aircraft/N238GS.md): Gerald B Stofer VANS RV-12 · S/N 120933 · Built 2018 · Wollman Phillip
- [N24362](https://openairdocs.org/aircraft/N24362.md): Taylorcraft BC-65 · S/N 1698 · Built 1940 · Luebke David M
- [N26DB](https://openairdocs.org/aircraft/N26DB.md): Sutterlin Elmer R RV-4 · S/N 007 · Built 1993 · Den Besten Dale L
- [N2911U](https://openairdocs.org/aircraft/N2911U.md): Cessna 172D · S/N 17250511 · Built 1963 · Night Sky LLC
- [N3355R](https://openairdocs.org/aircraft/N3355R.md): Cessna 182L · S/N 18258655 · Built 1967 · Skyhawks Flying Club Inc
- [N3536T](https://openairdocs.org/aircraft/N3536T.md): Taylorcraft BC12-D · S/N 6973 · Luebke David M
- [N36061](https://openairdocs.org/aircraft/N36061.md): Taylorcraft BC12-65 · S/N 3028 · Built 1941 · Luebke Henry W
- [N3857B](https://openairdocs.org/aircraft/N3857B.md): Beech F35 · S/N D-4124 · Built 1955 · Christensen Marshall J
- [N39244](https://openairdocs.org/aircraft/N39244.md): Taylorcraft BC12-D · S/N 6498 · Built 1945 · Luebke David M
- [N4219Y](https://openairdocs.org/aircraft/N4219Y.md): Air Tractor AT-802A · S/N 802A-0352 · Built 2010 · Tri State Aerial LLC
- [N497GA](https://openairdocs.org/aircraft/N497GA.md): Air Tractor AT-400A · S/N 400A-0502 · Built 1984 · Tri-State Aerial LLC
- [N5968Q](https://openairdocs.org/aircraft/N5968Q.md): Mooney M20C · S/N 3202 · Chess House LLC
- [N6432B](https://openairdocs.org/aircraft/N6432B.md): Cessna 172 · S/N 29632 · Built 1957 · Luebke David M
- [N750LW](https://openairdocs.org/aircraft/N750LW.md): Luebke H/Wilts G CH 750 · S/N 75-8020 · Built 2011 · Luebke Henry W
- [N75476](https://openairdocs.org/aircraft/N75476.md): Sabre Trike SABRE 447 · S/N 101579 · Built 2007 · Williams Stephen L
- [N7697Z](https://openairdocs.org/aircraft/N7697Z.md): Piper PA-25-235 · S/N 25-3856 · Built 1966 · Tri-State Aerial LLC
- [N825CG](https://openairdocs.org/aircraft/N825CG.md): Greenstreet Scott RV-10 · S/N 41922 · Built 2021 · Wollman Phillip
- [N96484](https://openairdocs.org/aircraft/N96484.md): Taylorcraft BC12-D · S/N 8784 · Built 1946 · Luebke David M

## 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 = 'SD' AND g.registrant_city = 'CANTON'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/SD/Canton/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.
