OpenAirDocs.org
Smyrna, TN

Registered aircraft · 90

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

N101CNBombardier CL-600-2B19 · S/N 7625Built 2022 · Corporate Flight Management Inc DBAN114BCCabe Robert D WITTMAN TAILWIND W-8 · S/N 376Boatman John H JrN11526Embraer EMB-135LR · S/N 145410Built 2001 · Corporate Flight Managment IncN11565Embraer EMB-145LR · S/N 145621Built 2002 · Corporate Flight Management IncN118ETCessna 172R · S/N 17280019Built 1997 · L & W Leasing LLCN118RPPerkins Robert GLASAIR SH-2 · S/N 629Boatman John H JrN124PLCessna 172S · S/N 172S8194Built 1999 · L & W Leasing LLCN12552Embraer EMB-145LR · S/N 145583Built 2002 · Corporate Flight Management IncN136AMBeech A36 · S/N E2641Built 1991 · Butler Aviation LlpN13MLCirrus Design SR22 · S/N 2573Built 2007 · M3l LLCN154EABombardier CL-600-2B19 · S/N 7629Built 2002 · Aaa Airplane LLCN15509Embraer EMB-135ER · S/N 145238Built 2000 · Corporate Flight Management IncN15527Embraer EMB-135LR · S/N 145413Built 2001 · Corporate Flight Management IncN1559CCessna 180 · S/N 30259Built 1953 · Hardee David BN16501Embraer EMB-135ER · S/N 145145Built 1999 · Corporate Flight Management IncN16502Embraer EMB-135ER · S/N 145166Built 1999 · Corporate Flight Management IncN16510Embraer EMB-135ER · S/N 145251Built 2000 · Corporate Flight Management IncN16511Embraer EMB-135ER · S/N 145267Built 2000 · Corporate Flight Management IncN16525Embraer EMB-135LR · S/N 145403Built 2001 · Corporate Flight Management DBAN16GHTextron 172S · S/N 172S13519Built 2026 · Greysky LLCN17513Embraer EMB-135LR · S/N 145292Built 2000 · Corporate Flight Management IncN1983TGlines Kenneth TAILWIND W-8 · S/N 306Boatman John H JrN222SNBellanca 17-31ATC · S/N 31004Built 1969 · Norris Jason MN258PSBombardier CL-600-2B19 · S/N 7941Built 2004 · Corporate Flight Management Inc DBAN26549Embraer EMB-145LR · S/N 145571Built 2002 · Corporate Flight Management IncN27512Embraer EMB-135ER · S/N 145274Built 2000 · Corporate Flight Management IncN278JGShriner John W RV-6A · S/N JS-001Built 1998 · Thompson Barrett RN286TACostruzioni Aeronautiche Tecna P2006T · S/N 136/USBuilt 2014 · Mfga LLCN312SMCessna 172N · S/N 17270091Built 1977 · Shelbyville Flight Academy LLCN31VRCessna 337G · S/N 33701731Built 1976 · Glaze Roy JN35491Cessna 172R · S/N 17281069L&W Leasing LLCN3703EAeronca 11AC · S/N 11AC-1855Built 1947 · Thompson Barrett RN384PABritish Aerospace BAE JETSTREAM 3101 · S/N 723Built 1986 · Tn Jetstream LLCN424PTRicky Dale Russell COZY MARK IV · S/N 1387Russell Ricky DaleN438SWBombardier CL-600-2B19 · S/N 7574Built 2001 · Corporate Flight Management Inc DBAN443SWBombardier CL-600-2B19 · S/N 7638Corporate Flight Management IncdbaN457RSRambo Steve SPIRIT XL · S/N 2931Built 2003 · Mccraven Craig SN458WPiper PA-28-140 · S/N 28-24511Tls Aviation LLCN461SPCessna 172S · S/N 172S8360Built 2000 · L & W Leasing LLCN46LEBeech A36 · S/N E726Kepley Aviation LLCN472CABombardier CL-600-2B19 · S/N 7667Built 2002 · Corporate Flight Management IncN475AHHester James Arthur RV-6 · S/N 20475Boatman John H JrN485VCessna 172S · S/N 172S8316Built 1999 · L & W Leasing LLCN489BBJohn H Boatman JR BUTTERCUP · S/N JB001Boatman John H JrN48RGTextron 172S · S/N 172S12953Built 2023 · Blueskies LLCN4912GCessna 172N · S/N 17273459Built 1979 · Hardee Christopher DN501UPCessna 560XL · S/N 560-5252Built 2002 · Corporate Flight Management Inc DBAN508UPCessna 560XL · S/N 560-5546Built 2005 · Corporate Flight Management IncdbaN530CNEmbraer EMB-135KL · S/N 145425Built 2001 · Corporate Flight Management Inc DBAN531CNEmbraer EMB-135KL · S/N 145469Built 2001 · Corporate Flight Management Inc DBA
Back to Smyrna, TN