# Registered aircraft: Ooltewah, TN

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

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

- [N1220L](https://openairdocs.org/aircraft/N1220L.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 723 · Built 1975 · Scott Roger W
- [N124JW](https://openairdocs.org/aircraft/N124JW.md): Cirrus Design SR20 · S/N 10791 · Built 2025 · Cloud Aviation LLC
- [N167TF](https://openairdocs.org/aircraft/N167TF.md): Beech V35 · S/N D-8472 · Built 1967 · Whitney David W
- [N178GW](https://openairdocs.org/aircraft/N178GW.md): Textron 172S · S/N 172S12491 · Built 2020 · Bravo Aircraft LLC
- [N218GJ](https://openairdocs.org/aircraft/N218GJ.md): Beech B200 · S/N BB-1013 · Built 1982 · Jaztec LLC
- [N242JW](https://openairdocs.org/aircraft/N242JW.md): Textron 172S · S/N 172S12279 · Built 2019 · Aviation Leasing Co LLC
- [N3242F](https://openairdocs.org/aircraft/N3242F.md): Mooney M20E · S/N 670035 · Built 1967 · Sbflyer LLC
- [N345LA](https://openairdocs.org/aircraft/N345LA.md): Josh Richling NLA-275-FR-C · S/N 1004 · Built 2021 · Five Lime Alpha LLC
- [N354BC](https://openairdocs.org/aircraft/N354BC.md): Beech A36 · S/N E-2485 · Built 1989 · Chamberlain Donald H
- [N388TC](https://openairdocs.org/aircraft/N388TC.md): Cessna 172 · S/N 29601 · Built 1956 · Dopson Joel A
- [N459PC](https://openairdocs.org/aircraft/N459PC.md): Pilatus PC-12/45 · S/N 459 · Built 2002 · Proper Technique LLC
- [N49SB](https://openairdocs.org/aircraft/N49SB.md): Beech A36 · S/N E-2661 · Built 1991 · Garcia Edward
- [N5003H](https://openairdocs.org/aircraft/N5003H.md): Piper PA-17 · S/N 17-203 · Built 1948 · Gospel Mission Aviation Inc
- [N500PJ](https://openairdocs.org/aircraft/N500PJ.md): Mitsubishi MU-2B-36 · S/N 668 · Built 1974 · Fly2mellc
- [N50750](https://openairdocs.org/aircraft/N50750.md): Cessna 150J · S/N 15069529 · Built 1968 · Fly Chattanooga LLC
- [N5110J](https://openairdocs.org/aircraft/N5110J.md): Cessna 310R · S/N 310R0230 · Built 1975 · Arbogast Matthew G
- [N5122A](https://openairdocs.org/aircraft/N5122A.md): Cessna 172 · S/N 28122 · Dopson Joel A
- [N55BQ](https://openairdocs.org/aircraft/N55BQ.md): Quallich R A/Essel R TITAN TORNADO · S/N D92503S0HK0039 · Built 1993 · Crane John C
- [N6566T](https://openairdocs.org/aircraft/N6566T.md): Cessna 150 · S/N 17966 · Built 1960 · Jensen Christopher
- [N746DS](https://openairdocs.org/aircraft/N746DS.md): Diamond Aircraft Ind DA 40 · S/N 40.746 · Cp LLC
- [N75U](https://openairdocs.org/aircraft/N75U.md): Aero Commander 690A · S/N 11218 · Five Uniform LLC
- [N8004R](https://openairdocs.org/aircraft/N8004R.md): Consolidated Aeronautics LAKE LA-4-200 · S/N 1028 · Arbogast Matthew G
- [N811CT](https://openairdocs.org/aircraft/N811CT.md): Textron 172S · S/N 172S12492 · Built 2020 · Bravo Aircraft LLC
- [N8215E](https://openairdocs.org/aircraft/N8215E.md): North American SNJ-5 · S/N 90670 · Built 1948 · Faulkner Bryan T
- [N828SK](https://openairdocs.org/aircraft/N828SK.md): Bombardier BD-100-1A10 · S/N 20258 · Jaztec LLC
- [N853CF](https://openairdocs.org/aircraft/N853CF.md): Cirrus Design SR22 · S/N 8539 · Built 2022 · Proper Technique LLC
- [N8629N](https://openairdocs.org/aircraft/N8629N.md): Piper PA-32-300 · S/N 32-7140022 · Built 1971 · N8629n Inc
- [N875JJ](https://openairdocs.org/aircraft/N875JJ.md): DJI MAVIC 2 PRO · S/N 163DFCP001VB4J · Macatiag Juminn Jay O
- [N875KM](https://openairdocs.org/aircraft/N875KM.md): DJI INSPIRE 2 · S/N 09YDF1H0040109 · Macatiag Juminn Jay O
- [N8971M](https://openairdocs.org/aircraft/N8971M.md): Cessna 177RG · S/N 177RG0371 · Built 1973 · Dixon Gary Lynn II
- [N90426](https://openairdocs.org/aircraft/N90426.md): Consolidated Vultee/Hops L-13A · S/N 47359 · Built 1947 · Faulkner Linda W Trustee
- [N978AP](https://openairdocs.org/aircraft/N978AP.md): Cessna 172S · S/N 172S10710 · Built 2008 · Aviation Leasing Company LLC
- [N9791Q](https://openairdocs.org/aircraft/N9791Q.md): Smith AEROSTAR 601 · S/N 61-0426-121 · Built 1977 · Fly Chattanooga LLC

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

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