Skip to content

Murfreesboro, TN

Registered aircraft · 225

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

Query with 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 = 'MURFREESBORO' ORDER BY g.n_number

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

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 = 'MURFREESBORO'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1089UCessna 172M · S/N 17266838Built 1976 · Jkg LLC N110MTCirrus Design SR22T · S/N 10677Built 2025 · Middle Tennessee State University N1155FCessna 172G · S/N 17254750Built 1966 · Dejesus Rodolfo B N1244TDiamond Aircraft Ind DA 40 · S/N 40.1191Built 2015 · Middle Tennessee State University N124MTPiper PA-28R-201 · S/N 2844092Built 2003 · Middle Tennessee State University N128MTPiper PA-44-180 · S/N 4496171Built 2003 · Middle Tennessee State University N129MTPiper PA-44-180 · S/N 4496172Built 2003 · Middle Tennessee State University N130MTPiper PA-44-180 · S/N 4496477Built 2019 · Middle Tennessee State University N132MTPiper PA-44-180 · S/N 4496540Built 2022 · Middle Tennessee State University N13484Cessna 177B · S/N 17702426Built 1976 · Aero-Flite Corp N134MTPiper PA-44-180 · S/N 4496593Built 2024 · Middle Tennessee State University N135MTPiper PA-44-180 · S/N 4496594Built 2024 · Middle Tennessee State University N13887Cessna 172M · S/N 17263029Built 1974 · Jkg LLC N138AFColumbia Aircraft Mfg LC41-550FG · S/N 41702Built 2006 · Schultz David N139MTPiper PA-44-180 · S/N 4496541Built 2022 · Middle Tennessee State University N140CFCessna 140A · S/N 15369Built 1949 · Bowser Brett A N147MTPiper PA-18-150 · S/N 18-7409136Built 1974 · Middle Tennessee State University N1589SBeech 35-B33 · S/N CD-538Built 1962 · Hunton Paul S N15BECessna TR182 · S/N R18201806Built 1981 · Avalon Aviation USA Corp N16243Cessna 150L · S/N 15073567Built 1972 · Como Jerry Wayne N16440Piper PA-28-235 · S/N 28-7310097Built 1973 · Bolen Darin L N182TNCessna 182Q · S/N 18265181Built 1977 · Potter Timothy E N1881LBeech 95-B55 (T42A) · S/N TC-1968Built 1976 · Swept Wing Aviation LLC N188BCAmerican Champion 8GCBC · S/N 598-2019Built 2019 · Waldron Elijah L N19138Cessna 150L · S/N 15074193Built 1972 · Hagewood James D N209RWBombardier CL-600-2B19 · S/N 7864Built 2003 · Aaa Airplane LLC N21180Cessna 172S · S/N 172S9624L&W Leasing LLC N2130EAeronca 7AC · S/N 7AC-5701Built 1946 · Marshman Robert M N215TPBeech 400 · S/N RJ-64Middle Tennessee State University N21AYCirrus Design SF50 · S/N 0283Sale reportedBuilt 2021 N222KDPiper AEROSTAR 600 · S/N 60-0557-181Hudgin James P N231TTMooney M20K · S/N 25-0857Built 1985 · Kf Aircraft LLC N23738Piper PA-38-112 · S/N 38-79A1049Built 1979 · Laureano Reynaldo N243HBeech C35 · S/N D-3272Built 1952 · Eason Michael P N2468TPiper PA-28-140 · S/N 28-7225074Built 1971 · Mackie Robbie L N247CDDiamond Aircraft Ind DA 40 · S/N 40.1193Built 2014 · Middle Tennessee State University N257RDBeech C23 · S/N M-21374 Flying Z'S LLC N2625CCessna 172R · S/N 17280436Built 1998 · L&W Leasing LLC N264DKQuest KODIAK 100 · S/N 100-0264Built 2019 · Stonewall Aviation LLC N264MTAltavian NOVA F7200 · S/N MTFIXSANOVA001Middle Tennessee State University (Mtsu)N265MTAltavian NOVA F7200 · S/N MTFIXSANOVA002Middle Tennessee State University (Mtsu)N266MTDJI MATRICE 600 PRO · S/N MTDJIX6002Middle Tennessee State University (Mtsu)N27960Halsmer Joseph L JR VARIEZE · S/N 780Built 1983 · Zeafla Steven J N280MTDJI PHANTOM 4 · S/N MTDJIX4004Middle Tennessee State University (Mtsu)N281MTDJI PHANTOM 4 · S/N MTDJIX4005Middle Tennessee State University (Mtsu)N283MT3D Robotics SX-X8 · S/N MT3DRX8001Middle Tennessee State University N284MTDJI MATRICE 600 PRO · S/N MTDJIX6003Middle Tennessee State University (Mtsu)N285MTDJI PHANTOM 4 PRO · S/N MTDJIX4008Middle Tennessee University N286MTDJI PHANTOM 4 PRO · S/N MTDJIX4009Middle Tennessee State University (Mtsu)N287MTDJI INSPIRE 2 · S/N MTDJIX4010Middle Tennessee State University (Mtsu)

Back to Murfreesboro, TN