OpenAirDocs.org
Franklin, TN

Registered aircraft · 104

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 = 'FRANKLIN'
  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.

N108KBPeter Kelsey SPORTSMAN GS-2 · S/N 7482Built 2019 · Powell Joseph HN114CFPiper PA-28-180 · S/N 28-7505080Built 1974 · Aw Chartering LLCN1163FCessna 172N · S/N 17272962Built 1979 · Mid-Tenn Aero Club IncN119JJBombardier BD-700-1A11 · S/N 9879Built 2019 · Johnson Willis JN119RKCessna 182P · S/N 18261574Built 1972 · Htv Music CoN120TMSwearingen SA226-T(B) · S/N T-405Built 1981 · Interstate Automotive Services IncN1282ZBeech N35 · S/N D-6711Built 1961 · Brickhouse Aviation LLCN13LJCirrus Design SR22T · S/N 2135Built 2020 · Ls Leasing LLCN150JNIsrael Aircraft Industries GULFSTREAM G150 · S/N 212Built 2006 · G150mt LLCN171MECessna 172S · S/N 172S8460Built 2000 · Patriot Leasing LLCN17732Beech E-55 · S/N TE-1102Built 1977 · Wright Brian LN17WAWallace Anderson RV-9 · S/N 92284Built 2020 · Kaestner Henry ToddN1921DBeech C35 · S/N D-3193Brickhouse Aviation LLCN20807Dyess William C RV-6 · S/N 25772Built 2005 · Dyess William CN2123KPiper PA-28-181 · S/N 28-7990238Built 1979 · Stone Kent HN212SCarter Christopher L VANS RV-7 · S/N 72812Built 2008 · Carter Christopher LN231SBeech V35 · S/N D-8058Built 1966 · Vinegaroon Aviation LLCN234PECessna 177 · S/N 17701078Built 1968 · Dunn Linwood BN247VERichard Blazier/Raymond Steal ZENITH CH701 · S/N 4224Built 2026 · Magli Cooper SN26961Gulfstream American AA-5A · S/N AA5A0840Built 1979 · Slater Thomas RN284CDCirrus Design SR22 · S/N 1294Built 2005 · Old Hickory FlyersN284MECessna 172S · S/N 172S8542Built 2000 · Patriot Leasing LLCN2890FCessna 182J · S/N 18256990Built 1966 · Aeolus Aviation LLCN308JPPoland Stephen R JABIRU J400 · S/N 76Built 2005 · Poland Stephen RN323RTTextron T206H · S/N T20609731Royal Blue LLCN32NSCirrus Design SF50 · S/N 0260Built 2021 · Ls Leasing LLCN345KWBeech G33 · S/N CD-1260Built 1971 · Hasch Edward L JrN3537NMooney M20F · S/N 680089Creaney William GeraldN3574RPiper PA-32-300 · S/N 32-7940287Built 1979 · Garner Financial Management IncN3740NBeech 35 · S/N D-956Built 1947 · Crimmins Christopher EN3809KBeech 58 · S/N TH-1219Built 1981 · General Aviation Services LLCN3BARaytheon B300 · S/N FL-181Built 1997 · Construction Enterprises IncN3LXSchleicher ASW-24 · S/N 24002Built 1988 · Myers Peter SN417MHCessna 525A · S/N 525A-0054Built 2002 · Wkdn Jets LLCN41WKRolladen-Schneider LS 4A · S/N 4448Built 1984 · Morgan MarkN4237CCessna 414 · S/N 414-0535Built 1974 · Breakaway Group Aviation LLCN424EGCirrus Design SR22 · S/N 0887Built 2004 · S&R Flying LLCN44BEpic E1000 · S/N K109Built 2026 · Epic Flights LLCN457PRaytheon G36 · S/N E3679Broussard Patrick AN467CCCirrus Design SR22T · S/N 8619Built 2022 · Old South Construction Of Tennessee LLCN4698JPiper PA-28R-180 · S/N 28R-30601Built 1968 · Shea William PrestonN47KRKrug Keith L RV-9A · S/N 91240Built 2020 · Krug Keith LN48HPTextron B200GT · S/N BY-489Hayes Aviation IncN5101GPiper PA-28-180 · S/N 28-3969Built 1967 · Wash StephenN520TRCirrus Design SF50 · S/N 0450Built 2023 · Bbr Air LLCN5218NCessna 182Q · S/N 18267579Built 1980 · Morin Shawn DN5246LPiper PA-28-180 · S/N 28-4541Built 1967 · Smithson Thomas EN528BSCessna 525B · S/N 525B0243Built 2008 · Lofty Ventures LLCN52915Cirrus Design SR20 · S/N 1411Built 2004 · Lacy Design And Consulting LLCN5327LPiper PA-28-180 · S/N 28-4631Built 1968 · Leipzig Richard R
Back to Franklin, TN