# Registered aircraft: Greenbrier, TN

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

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

- [N163PS](https://openairdocs.org/aircraft/N163PS.md): Diamond Aircraft Ind DA 50 C · S/N 50.C.A.A.015 · Built 2022 · Just Winging It LLC
- [N26279](https://openairdocs.org/aircraft/N26279.md): Stinson 10 · S/N 7560 · Built 1940 · Dorris Terry E
- [N27DH](https://openairdocs.org/aircraft/N27DH.md): Beech V35B · S/N D-9149 · Built 1970 · Mcavoy Sean M
- [N309LL](https://openairdocs.org/aircraft/N309LL.md): Cessna 177RG · S/N 177RG1346 · Sweepyacres LLC
- [N4605M](https://openairdocs.org/aircraft/N4605M.md): Beech A36 · S/N E-1246 · Built 1978 · Johnson Plane Services LLC
- [N483TS](https://openairdocs.org/aircraft/N483TS.md): Diamond Aircraft Ind DA 42 · S/N 42.AC083 · Built 2007 · Double Diamond Aviation LLC
- [N603MH](https://openairdocs.org/aircraft/N603MH.md): Cirrus Design SR22 · S/N 4629 · Built 2018 · Plane Company LLC
- [N60779](https://openairdocs.org/aircraft/N60779.md): Cessna 162 · S/N 16200219 · Built 2012 · Baggett Robert E
- [N7123U](https://openairdocs.org/aircraft/N7123U.md): Mooney M20C · S/N 2742 · Built 1964 · Matherly Frank
- [N7581W](https://openairdocs.org/aircraft/N7581W.md): Piper PA-28-180 · S/N 28-1523 · Built 1964 · Sutherland Joel C
- [N787RM](https://openairdocs.org/aircraft/N787RM.md): Beech F33A · S/N CE-1719 · Built 1993 · Johnson Plane Services
- [N803DJ](https://openairdocs.org/aircraft/N803DJ.md): Cessna 150M · S/N 15078798 · Built 1976 · Lyle Chase Thomas
- [N8071P](https://openairdocs.org/aircraft/N8071P.md): Piper PA-24-250 · S/N 24-3318 · Built 1962 · Matherley Frank
- [N825ME](https://openairdocs.org/aircraft/N825ME.md): Cubcrafters CC11-160 · S/N CC11-00372 · Plane Company LLC
- [N860A](https://openairdocs.org/aircraft/N860A.md): Beech F33A · S/N CE-934 · Built 1980 · Johnson Plane Services LLC
- [N88EC](https://openairdocs.org/aircraft/N88EC.md): Eurocopter EC120B · S/N 1195 · Built 2001 · Plane Company LLC
- [N96EJ](https://openairdocs.org/aircraft/N96EJ.md): Schickli Edward J JR PIEL EMERAUDE · S/N 001 · Dorris Terry

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

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