# Registered aircraft: Lewisburg, TN

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

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

- [N103FC](https://openairdocs.org/aircraft/N103FC.md): Colyaer SL S100 FREEDOM · S/N 130-001-026 · Saltz Robert M
- [N149DF](https://openairdocs.org/aircraft/N149DF.md): Piaggio P149E · S/N 348 · Nelson Jim
- [N15523](https://openairdocs.org/aircraft/N15523.md): Piper PA-28R-200 · S/N 28R-7335065 · Built 1972 · Derryberry Clay
- [N1649A](https://openairdocs.org/aircraft/N1649A.md): Piper PA-22 · S/N 22-412 · Built 1952 · Hudgin James P
- [N16PH](https://openairdocs.org/aircraft/N16PH.md): Hudgin James P LANCAIR 320 · S/N 376-320-131-17P · Built 1994 · Hudgin James P
- [N2269P](https://openairdocs.org/aircraft/N2269P.md): Mooney M20F · S/N 670152 · Built 1966 · Blackwell Steve
- [N3435U](https://openairdocs.org/aircraft/N3435U.md): Cessna 182F · S/N 18254835 · Built 1963 · Jackson Terry W
- [N3496H](https://openairdocs.org/aircraft/N3496H.md): Erco 415-C · S/N 4121 · Blackwell Steve
- [N3816N](https://openairdocs.org/aircraft/N3816N.md): Beech A35 · S/N D-1045 · Built 1947 · Bailey James
- [N444CC](https://openairdocs.org/aircraft/N444CC.md): Beech F33A · S/N CE-845 · Built 1979 · Von Almen James Martin
- [N582KS](https://openairdocs.org/aircraft/N582KS.md): Pereyra Arnet AVENTURA HP · S/N APHP0005 · Saltz Robert M
- [N6401A](https://openairdocs.org/aircraft/N6401A.md): Piper PA-38-112 · S/N 38-78A0416 · Lynch Rick W
- [N816MD](https://openairdocs.org/aircraft/N816MD.md): Owens Rick RANS S-12 · S/N 0891121 · Saltz Robert M
- [N820RM](https://openairdocs.org/aircraft/N820RM.md): Schleicher ASW-20 · S/N 20367 · Murphy Ron
- [N88LF](https://openairdocs.org/aircraft/N88LF.md): Musson Merle D VARIEZE · S/N 2078 · Built 1980 · Bailey James L
- [N90032](https://openairdocs.org/aircraft/N90032.md): Head Balloons AX8-105 · S/N 521 · Built 2024 · Grimes Robert A
- [N901RV](https://openairdocs.org/aircraft/N901RV.md): Shannon Stan VANS ACFT RV9A · S/N 90001 · Built 2003 · Kyzer William P
- [N902KR](https://openairdocs.org/aircraft/N902KR.md): Andrew Philip Richardson SOLO SYSTEM ACE · S/N 005 · Built 2021 · Grimes Robert A

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

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