# Registered aircraft: Vermillion, SD

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

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

- [N1233M](https://openairdocs.org/aircraft/N1233M.md): Cessna 182P · S/N 18264251 · Built 1975 · French Rollie T
- [N1509V](https://openairdocs.org/aircraft/N1509V.md): Dehavilland DH104 DOVE 6A · S/N 04460 · Built 1955 · Kinney James R
- [N1821Y](https://openairdocs.org/aircraft/N1821Y.md): Cessna 172C · S/N 17249421 · Built 1962 · Kinney James R
- [N206TV](https://openairdocs.org/aircraft/N206TV.md): Beech B19 · S/N MB-660 · Built 1974 · Hpfm Inc
- [N3745G](https://openairdocs.org/aircraft/N3745G.md): Dehavilland DH104 DOVE 6A · S/N 04439 · Kinney James R
- [N5647L](https://openairdocs.org/aircraft/N5647L.md): Maule M-5-235C · S/N 7370C · Built 1981 · French Rollie T
- [N5889M](https://openairdocs.org/aircraft/N5889M.md): Cessna T-310P · S/N 310P0189 · Built 1969 · Kinney James R
- [N608DM](https://openairdocs.org/aircraft/N608DM.md): Martens Dennis D MIDGET MUSTANG · S/N M11576 · Martens Dennis
- [N62SD](https://openairdocs.org/aircraft/N62SD.md): Hawker Beechcraft B300 · S/N FL-620 · Built 2008 · Usdf2 LLC
- [N6699H](https://openairdocs.org/aircraft/N6699H.md): Piper J3C-65 · S/N 19910 · Built 1946 · Kinney James R
- [N669DH](https://openairdocs.org/aircraft/N669DH.md): South East Amphibs SEAREY · S/N 1MK463C · Built 2016 · Hertz David
- [N77ZB](https://openairdocs.org/aircraft/N77ZB.md): Piper PA-28-181 · S/N 28-7790359 · Ikiugu Moses
- [N78240](https://openairdocs.org/aircraft/N78240.md): Cessna 172K · S/N 17257541 · Built 1968 · Kinney Joan M
- [N89202](https://openairdocs.org/aircraft/N89202.md): Cessna 140 · S/N 8222 · Built 1946 · Kinney James R
- [N932DF](https://openairdocs.org/aircraft/N932DF.md): William L Mount VANS ACFT INC RV-9A · S/N 90342 · Built 2018 · Hertz David R
- [N93820](https://openairdocs.org/aircraft/N93820.md): Ercoupe 415-C · S/N 1143 · Built 1946 · Tenforty Inc

## 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 = 'VERMILLION'
ORDER BY g.n_number
```

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