# Registered aircraft: Jonesborough, TN

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

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

- [N131SM](https://openairdocs.org/aircraft/N131SM.md): Hart Sean M RANS RAVEN · S/N 05150044 · Built 2024 · Hart Sean M
- [N2168T](https://openairdocs.org/aircraft/N2168T.md): Piper PA-28-180 · S/N 28-7205018 · Built 1971 · Glass Kelly R
- [N218DB](https://openairdocs.org/aircraft/N218DB.md): Flight Design CTSW · S/N 06-07-13 · Built 2006 · Johnson George R
- [N227TG](https://openairdocs.org/aircraft/N227TG.md): Letourneau Eugene AVID FLYER · S/N 1227D · Built 2006 · Swires Tim
- [N290SC](https://openairdocs.org/aircraft/N290SC.md): DJI AGRAS T100 · S/N 1581F8ZLC259N00252C6 · Silvercrest Ag & Turf LLC
- [N320JW](https://openairdocs.org/aircraft/N320JW.md): Jim Wimberly RANS S-6ES · S/N 12101941 · Built 2011 · Lee William L
- [N330WL](https://openairdocs.org/aircraft/N330WL.md): Wingtip To Wingtip LLP PANZL S-330 · S/N 011 · Built 2015 · Lee William L
- [N44396](https://openairdocs.org/aircraft/N44396.md): Taylorcraft BC12-D · S/N 10196 · Built 1946 · Uphill Holdings LLC
- [N4510K](https://openairdocs.org/aircraft/N4510K.md): Head Balloons AX8-88 · S/N 186 · First renewal notice · Built 1992 · Mcmanus William E Jr
- [N48JW](https://openairdocs.org/aircraft/N48JW.md): White James F JR PITTS S1S-E · S/N 2 · Built 1989 · Lee William L
- [N523J](https://openairdocs.org/aircraft/N523J.md): Mcbride Richard L RANS S-7S COURIER · S/N 0906446 · Sale reported · Built 2011
- [N5631V](https://openairdocs.org/aircraft/N5631V.md): Leonard Wilson L HIMAX 1700R · S/N JDT81 · Built 2005 · Jessie James C
- [N620BL](https://openairdocs.org/aircraft/N620BL.md): Luptowski Bennie F JR KITFOX IV · S/N C94090062 · Mathews Kenneth Milton III
- [N704CU](https://openairdocs.org/aircraft/N704CU.md): Cessna 150M · S/N 15078513 · Built 1976 · Rogers Gale Allen
- [N7237S](https://openairdocs.org/aircraft/N7237S.md): Cessna 150H · S/N 15067937 · Metcalf Rodney K
- [N741LM](https://openairdocs.org/aircraft/N741LM.md): Larry L Murphy RANS S7S · S/N 0615617 · Ward Jasper E
- [N769HP](https://openairdocs.org/aircraft/N769HP.md): DJI PHANTOM 3 ADVANCED · S/N P76DCH04011515 · Long Kyle B
- [N9208G](https://openairdocs.org/aircraft/N9208G.md): Cessna 182N · S/N 18260748 · Built 1971 · Adams Shane M
- [N958M](https://openairdocs.org/aircraft/N958M.md): Globe GC-1B · S/N 2259 · Mcgaha James M
- [N98626](https://openairdocs.org/aircraft/N98626.md): Piper J3C-65 · S/N 18847 · Built 1946 · Mcgaha James 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 = 'TN' AND g.registrant_city = 'JONESBOROUGH'
ORDER BY g.n_number
```

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