OpenAirDocs.org
Ooltewah, TN

Registered aircraft · 33

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

Query with SQL
duckdb -csv -c "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"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

N1220LConsolidated Aeronautics LAKE LA-4-200 · S/N 723Built 1975 · Scott Roger WN124JWCirrus Design SR20 · S/N 10791Built 2025 · Cloud Aviation LLCN167TFBeech V35 · S/N D-8472Built 1967 · Whitney David WN178GWTextron 172S · S/N 172S12491Built 2020 · Bravo Aircraft LLCN218GJBeech B200 · S/N BB-1013Built 1982 · Jaztec LLCN242JWTextron 172S · S/N 172S12279Built 2019 · Aviation Leasing Co LLCN3242FMooney M20E · S/N 670035Built 1967 · Sbflyer LLCN345LAJosh Richling NLA-275-FR-C · S/N 1004Built 2021 · Five Lime Alpha LLCN354BCBeech A36 · S/N E-2485Built 1989 · Chamberlain Donald HN388TCCessna 172 · S/N 29601Built 1956 · Dopson Joel AN459PCPilatus PC-12/45 · S/N 459Built 2002 · Proper Technique LLCN49SBBeech A36 · S/N E-2661Built 1991 · Garcia EdwardN5003HPiper PA-17 · S/N 17-203Built 1948 · Gospel Mission Aviation IncN500PJMitsubishi MU-2B-36 · S/N 668Built 1974 · Fly2mellcN50750Cessna 150J · S/N 15069529Built 1968 · Fly Chattanooga LLCN5110JCessna 310R · S/N 310R0230Built 1975 · Arbogast Matthew GN5122ACessna 172 · S/N 28122Dopson Joel AN55BQQuallich R A/Essel R TITAN TORNADO · S/N D92503S0HK0039Built 1993 · Crane John CN6566TCessna 150 · S/N 17966Built 1960 · Jensen ChristopherN746DSDiamond Aircraft Ind DA 40 · S/N 40.746Cp LLCN75UAero Commander 690A · S/N 11218Five Uniform LLCN8004RConsolidated Aeronautics LAKE LA-4-200 · S/N 1028Arbogast Matthew GN811CTTextron 172S · S/N 172S12492Built 2020 · Bravo Aircraft LLCN8215ENorth American SNJ-5 · S/N 90670Built 1948 · Faulkner Bryan TN828SKBombardier BD-100-1A10 · S/N 20258Jaztec LLCN853CFCirrus Design SR22 · S/N 8539Built 2022 · Proper Technique LLCN8629NPiper PA-32-300 · S/N 32-7140022Built 1971 · N8629n IncN875JJDJI MAVIC 2 PRO · S/N 163DFCP001VB4JMacatiag Juminn Jay ON875KMDJI INSPIRE 2 · S/N 09YDF1H0040109Macatiag Juminn Jay ON8971MCessna 177RG · S/N 177RG0371Built 1973 · Dixon Gary Lynn IIN90426Consolidated Vultee/Hops L-13A · S/N 47359Built 1947 · Faulkner Linda W TrusteeN978APCessna 172S · S/N 172S10710Built 2008 · Aviation Leasing Company LLCN9791QSmith AEROSTAR 601 · S/N 61-0426-121Built 1977 · Fly Chattanooga LLC
Back to Ooltewah, TN