The TFNRegistry™ (tfnregistry.somos.com) stores ALL dates and times in UTC timezone, hence SQL queries executed through SFTP/SQL*Net will return data in UTC timezone. You have to convert UTC to the desired timezone in the query.
The following SQL statement can be used to convert (which shows UTC to CST conversion):
to_char(<column_name>,'mm/dd/yyyy hh12:mi am') statusChangeDate_in_utc,
to_char(from_tz(cast( statusChangeDate as timestamp(6)),'UTC') at time zone 'CST','mm/dd/yyyy hh12:mi am')