Skip to page content

USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

United States Department of Transportation United States Department of Transportation

Terminal Procedures

Basic Search

Next Editions will be available 20 days prior to their effective date. Report any application errors and provide comments via the portal's Website category.

Change notice cycle (2nd half of 56-day cycle)

Examples: OKC or KOKC

Additional Resources

d-TPP Metafile XML

Page last modified:


Debugging Information
ColdFusion Server Enterprise 2023,0,15,330825
Template /air_traffic/flight_info/aeronav/digital_products/dtpp/search/index.cfm
Time Stamp 17-Dec-25 06:57 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.27.195.250
Host Name 10.27.195.250


Execution Time

Total Time Avg Time Count Template
81 ms 81 ms 1 top level \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\search\index.cfm
20 ms 20 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
19 ms 19 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc | getCyclesDtpp() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
11 ms 11 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc | getDtppxml() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
11 ms 11 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc | getStates(pac = 1) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
11 ms 11 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc | getVolumes() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
10 ms 10 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc | getCyclesDafd() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
6 ms 6 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actMenu.cfm
5 ms 5 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/Application.cfm
5 ms 5 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspTemplate.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/Application.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/applicationCode.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspBody.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actExternalLinks.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspFooter.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspHeader.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspPageTools.cfm
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc | init(datasource = aeronav) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/actGetServices.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/search/view/dspIndex.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/view/dspRightSidebar.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actCheckLegacyMode.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actParamVars.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actChatbot.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actEnableColumns.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actTopTasks.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/menu/actBuildMenu.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/top_tasks/dspAeronav.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_footer.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_head.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_header.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfAssetQueryString.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfDetectTier.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfDocumentViewer.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfEmailForm.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfExpressionManager.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfImageFormat.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfPageRedirect.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfUriManager.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
88 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qryGetCycles (Datasource=aeronav, Time=12ms, Records=2) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\model\AeronavService.cfc @ 18:57:08.008
SELECT
				cycleName,
				startDate,
				endDate,
				cycleType
			FROM
				cycle
			ORDER BY
				startDate DESC
qryGetcycleXML (Datasource=aeronav, Time=11ms, Records=2) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\model\AeronavService.cfc @ 18:57:08.008
SELECT
				cycleName,
				startDate,
				endDate,
				cycleType,
				TRUNC(enddate) - TRUNC(SYSDATE) AS difference,
				'CE' AS edition
			FROM
				CYCLE
			WHERE
				TRUNC(startDate) <= TRUNC(SYSDATE)
			AND
				TRUNC(endDate) > TRUNC(SYSDATE)
			UNION ALL
			SELECT
				cycleName,
				startDate,
				endDate,
				cycleType,
				TRUNC(startdate) - TRUNC(SYSDATE) AS difference,
				'NE' AS edition
			FROM
				CYCLE
			WHERE
				TRUNC(startDate) > TRUNC(SYSDATE)
			AND
				TRUNC(endDate) > TRUNC(SYSDATE)
qryGetStates (Datasource=aeronav, Time=11ms, Records=54) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\model\AeronavService.cfc @ 18:57:08.008
SELECT * FROM (
				SELECT stateName, stateAbbreviation
				FROM state
				WHERE isterritory = 0 OR LOWER(stateAbbreviation) = 'pr' OR LOWER(stateAbbreviation) = 'vi'
				
					UNION
					SELECT 'Pacific Territories' AS stateName, 'XX' AS stateAbbreviation FROM state
				
			)
			ORDER BY stateName
qryGetVolumes (Datasource=aeronav, Time=10ms, Records=26) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\model\AeronavService.cfc @ 18:57:08.008
SELECT *
			FROM volume
			ORDER BY volumeName
qryGetCyclesDAFD (Datasource=aeronav, Time=10ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\model\AeronavService.cfc @ 18:57:08.008
SELECT
				cycleName,
				startDate,
				(endDate + 29) AS endDate,
				cycleType
			FROM
				CYCLE
			WHERE
				LOWER(cycleType) = 'tpp'
			AND
				TRUNC(startDate-21) < TRUNC(SYSDATE)
			AND
				TRUNC(endDate+29) > TRUNC(SYSDATE)
			ORDER BY
				cycleName


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=256
CERT_SECRETKEYSIZE=2048
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert Global G2 TLS RSA SHA256 2020 CA1
CERT_SERVER_SUBJECT=C=US, S=District of Columbia, L=Washington, O=Federal Aviation Administration, CN=www.faa.gov
CERT_SUBJECT=
CF_TEMPLATE_PATH=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\search\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=on
HTTPS_KEYSIZE=256
HTTPS_SECRETKEYSIZE=2048
HTTPS_SERVER_ISSUER=C=US, O=DigiCert Inc, CN=DigiCert Global G2 TLS RSA SHA256 2020 CA1
HTTPS_SERVER_SUBJECT=C=US, S=District of Columbia, L=Washington, O=Federal Aviation Administration, CN=www.faa.gov
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=www.faa.gov
HTTP_REFERER=
HTTP_URL=/air_traffic/flight_info/aeronav/digital_products/dtpp/search/index.cfm?cycle=1901&dir=asc&ident=TCM
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.27.229.24
PATH_INFO=
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\search\index.cfm
QUERY_STRING=cycle=1901&dir=asc&ident=TCM
REMOTE_ADDR=10.27.195.250
REMOTE_HOST=10.27.195.250
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/air_traffic/flight_info/aeronav/digital_products/dtpp/search/index.cfm
SERVER_NAME=www.faa.gov
SERVER_PORT=8085
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=186472
CFTOKEN=f1a35faa9a48d0cb-D3761450-AD12-8CA0-00C5B3D3ED78031E
Session Variables:
sessionid=378580EA805C6DD8482F55004FBD93C1.www
urltoken=CFID=186472&CFTOKEN=f1a35faa9a48d0cb-D3761450-AD12-8CA0-00C5B3D3ED78031E&jsessionid=378580EA805C6DD8482F55004FBD93C1.www
URL Parameters:
cycle=1901
dir=asc
ident=TCM
Debug Rendering Time: 9 ms