# Registered aircraft: La Follette, TN

A list on [La Follette, TN](https://openairdocs.org/faa-place/TN/La%20Follette.md).

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

- [N112SM](https://openairdocs.org/aircraft/N112SM.md): MS RV-10 · S/N 40463 · Built 2014 · Reisdorfer Mark J
- [N143LK](https://openairdocs.org/aircraft/N143LK.md): Robbins Larry K SH-2FT · S/N 190 · Built 1994 · Robbins Larry K
- [N1636J](https://openairdocs.org/aircraft/N1636J.md): Cirrus Design SR22 · S/N 4541 · Built 2017 · Brc Holdings LLC
- [N20DP](https://openairdocs.org/aircraft/N20DP.md): Piper PA-46-310P · S/N 4608140 · Built 1988 · Ervin Eric
- [N213PH](https://openairdocs.org/aircraft/N213PH.md): Beech 200 · S/N BB-486 · Built 1979 · Pyro Shows Equipment LLC
- [N216PM](https://openairdocs.org/aircraft/N216PM.md): Autogyro Of The Carolinas CAVALON · S/N V00065 · Built 2012 · Bolinger Andy L
- [N227RT](https://openairdocs.org/aircraft/N227RT.md): Cirrus Design SR22 · S/N 2357 · Built 2007 · Barnard David W
- [N3246B](https://openairdocs.org/aircraft/N3246B.md): Beech 58 · S/N TH-1746 · Built 1995 · Rb3246b LLC
- [N4824G](https://openairdocs.org/aircraft/N4824G.md): Cessna 172N · S/N 17273372 · Built 1979 · Hickman Robert B
- [N48V](https://openairdocs.org/aircraft/N48V.md): Korth S R QUESTAIR VENTURE · S/N 18 · Ervin Eric A
- [N4961J](https://openairdocs.org/aircraft/N4961J.md): Piper PA-28R-180 · S/N 28R-30710 · Built 1968 · Jones Charles W
- [N4985](https://openairdocs.org/aircraft/N4985.md): Beech A45 · S/N 34-125 · Built 1953 · Crawford Loel H
- [N5076V](https://openairdocs.org/aircraft/N5076V.md): Alliant DESTINY XLT · S/N 4C0593 · Built 2006 · Bolinger Andy L
- [N6014Y](https://openairdocs.org/aircraft/N6014Y.md): Netzer Dave VANS RV-6 · S/N 24367 · Built 1997 · Backscheider Eric D
- [N6082C](https://openairdocs.org/aircraft/N6082C.md): Christen Industries PITTS S-2B · S/N 5153 · First renewal notice · Built 1988 · Ervin Eric A
- [N718C](https://openairdocs.org/aircraft/N718C.md): Campbell Harold A JR VANS RV-8 · S/N 81929 · Built 2006 · Ervin Eric
- [N7253T](https://openairdocs.org/aircraft/N7253T.md): Beech 58 · S/N TH-1462 · Built 1985 · Pyro Shows Inc
- [N824PK](https://openairdocs.org/aircraft/N824PK.md): Driscoll Patrick J VANS RV8 · S/N 81048 · Built 2004 · Reisdorfer Mark J
- [N87MR](https://openairdocs.org/aircraft/N87MR.md): Maule M-7-235B · S/N 23010C · Built 1994 · Reisdorfer Mark J

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

This list as a web page: https://openairdocs.org/faa-place/TN/La%20Follette/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
