OpenAirDocs.org
Collegedale, TN

Registered aircraft · 21

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

N1756CCessna 180 · S/N 30456Built 1953 · Gospel Ministries International IncN218AMccutchan Anthony L VANS RV8-A · S/N 80954Chambers RockyN22APBell 47G · S/N 1144Gospel Ministries International IncN26EDRay Lee A RV6A · S/N 24840Built 1999 · Turboprop Co LLCN300YBMooney M20J · S/N 24-3010Built 1986 · Gospel Ministries International IncN3538FCessna 182J · S/N 18257538Built 1966 · Gospel Ministries International IncN412LZWitham Roger D CHINOOK PLUS 2 · S/N 02283XSBuilt 2008 · Gospel Ministries International IncN425RMCessna 425 · S/N 425-0180Built 1983 · Gospel Ministries International IncN45VXSud Aviation/Eurocopter ALOUETTE II SE313B · S/N 1229Built 1959 · Gospel Ministries International IncN49LDCessna 560 · S/N 560-0803Built 2008 · Mckee Foods Transporation LLCN5256NCessna 182Q · S/N 18267605Built 1980 · Gospel Ministries InternationalN653BWCirrus Design SR22 · S/N 1195Small FrankN6640CCessna 414A · S/N 414A0044Built 1978 · Gospel Ministries International IncN7190YPiper PA-30 · S/N 30-214Built 1963 · Miller KevinN73560Cessna 172M · S/N 17267539Built 1976 · Gospel Ministries International IncN74490Bellanca 14-13-2 · S/N 1603Built 1948 · Wheeler Joellyn KN89LDEmbraer EMB-135LR · S/N 145648Built 2005 · Mckee Foods Transportation LLCN9113MCessna 182P · S/N 18264683Built 1976 · Gospel Ministries International IncN96952Cessna 182Q · S/N 18266909Built 1979 · Gospel Ministries InternationalN986GMCessna 414A · S/N 414A0089Built 1978 · Gospel Ministries International IncN9TLCessna 182P · S/N 18262680Built 1973 · Gospel Ministries International Inc
Back to Collegedale, TN