# Registered aircraft: Clinton, TN

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

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

- [N190JW](https://openairdocs.org/aircraft/N190JW.md): Williams James A EXEC 90 · S/N 5236 · Built 2001 · Burton Nicholas D
- [N2154D](https://openairdocs.org/aircraft/N2154D.md): Beech D35 · S/N D-3504 · Built 1953 · Burton Nicholas D
- [N2253](https://openairdocs.org/aircraft/N2253.md): Nicholas D Burton REVOLUTION MINI 500 · S/N NB06192021 · Burton Nicholas D
- [N233SV](https://openairdocs.org/aircraft/N233SV.md): Pilatus PC-24 · S/N 192 · Built 2020 · Vref LLC
- [N319JD](https://openairdocs.org/aircraft/N319JD.md): Cessna 525 · S/N 5250216 · Built 1997 · Hollingsworth Intergalactic LLC
- [N32JR](https://openairdocs.org/aircraft/N32JR.md): Rollow SONNERAL II · S/N 57 · Built 1976 · Rollow James A
- [N38448](https://openairdocs.org/aircraft/N38448.md): Piper PA-32R-300 · S/N 32R-7780428 · Built 1977 · Orphans Hands Inc
- [N424AC](https://openairdocs.org/aircraft/N424AC.md): American Champion 7GCAA · S/N 418-99 · Built 1999 · Gilliam Robert L
- [N4951V](https://openairdocs.org/aircraft/N4951V.md): Beech C35 · S/N D-3197 · Built 1952 · Branam John R
- [N542JH](https://openairdocs.org/aircraft/N542JH.md): Higginbotham John P REVOLUTION MINI 500 · S/N 2009-01 · Built 2011 · Burton Nicholas D
- [N59412](https://openairdocs.org/aircraft/N59412.md): Keighan Scott VELOCITY FGE · S/N DMO365 · Built 1998 · Long Gregory B
- [N769JB](https://openairdocs.org/aircraft/N769JB.md): Cessna 172K · S/N 17257380 · Built 1968 · Gibson Randy L
- [N82812](https://openairdocs.org/aircraft/N82812.md): Aeronca 7AC · S/N 7AC-1459 · Built 1946 · Gibson Randy L
- [N86021](https://openairdocs.org/aircraft/N86021.md): Aeronca 11AC · S/N 11AC-440 · Built 1946 · Riner Gary E
- [N86JD](https://openairdocs.org/aircraft/N86JD.md): Robinson Helicopter R44 II · S/N 10539 · Built 2004 · Burton Nicholas D
- [N90VH](https://openairdocs.org/aircraft/N90VH.md): Nicholas Burton EXEC · S/N 202301 · Burton Nicholas D
- [N9317R](https://openairdocs.org/aircraft/N9317R.md): Cessna TR182 · S/N R18200687 · Built 1979 · Lloyd William E Jr
- [N9521H](https://openairdocs.org/aircraft/N9521H.md): Cessna 172M · S/N 17266197 · Built 1975 · Jordan Recreation Development LLC
- [N999PH](https://openairdocs.org/aircraft/N999PH.md): Robinson Helicopter R22 BETA · S/N 0514 · Burton Nicholas

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

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