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

Search Results

Procedure effective date: 0901Z August 16 to 0901Z September 12, 2018 (1809)
Identifier: AFN

Change search criteria

Showing results 1–5 of 5

Search results

State Sort Asc

City Sort Asc

Airport Sort Asc
Ident (ICAO) Sort Asc
Vol Sort Asc

Flag Sort Asc

Type Sort Asc
Procedure Sort Asc
Compare
NH JAFFREY JAFFREY AIRPORT-SILVER RANCH AFN (KAFN) NE-1 MIN TAKEOFF MINIMUMS (PDF) N/A
NH JAFFREY JAFFREY AIRPORT-SILVER RANCH AFN (KAFN) NE-1 MIN ALTERNATE MINIMUMS (PDF) N/A
NH JAFFREY JAFFREY AIRPORT-SILVER RANCH AFN (KAFN) NE-1 IAP RNAV (GPS)-B (PDF) N/A
NH JAFFREY JAFFREY AIRPORT-SILVER RANCH AFN (KAFN) NE-1 IAP RNAV (GPS)-C (PDF) N/A
NH JAFFREY JAFFREY AIRPORT-SILVER RANCH AFN (KAFN) NE-1 IAP VOR-A (PDF) N/A

Showing results 1–5 of 5

Flag Values (since last effective date)

"A"
Added
"D"
Deleted
"C"
Changed

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/results/index.cfm
Time Stamp 17-Dec-25 06:32 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
1853 ms 1853 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/search/results/index.cfm
1830 ms 1830 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/search/results/model/actSetVars.cfm
901 ms 901 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 | getSearchResultsDtpp(filterDeleted = , airport = , volume = , state = , hotSpots = , countOnly = true, diagrams = , city = , ident = AFN, filterAdded = , pageNumber = 1, cycle = 1809, filterChanged = ) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
890 ms 890 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 | getSearchResultsDtpp(filterDeleted = , airport = , volume = , state = , hotSpots = , dir = asc, diagrams = , city = , ident = AFN, filterAdded = , pageNumber = 1, sort = , cycle = 1809, filterChanged = ) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/air_traffic/flight_info/aeronav/digital_products/dtpp/model/AeronavService.cfc
19 ms 19 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
19 ms 19 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
15 ms 15 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 | getCycle(cycle = 1809) ] 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 | getCyclesDafd() ] 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
7 ms 7 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
4 ms 4 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/Application.cfm
4 ms 4 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
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.cfm
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actParamVars.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/plugins/actTopTasks.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/results/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/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/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/templates/6/view/dspFooter.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspHeader.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspPageTools.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
1860 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qryGetCyclesDAFD (Datasource=aeronav, Time=11ms, 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:32:22.022
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
qryGetcycleXML (Datasource=aeronav, Time=10ms, 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:32:22.022
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)
qryGetSearchResultsDTPP (Datasource=aeronav, Time=900ms, 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:32:22.022
SELECT COUNT(*) AS resultsCount
			
			FROM (
				SELECT stateAbbr, cityName, airportName, airportCode, icao, chartSeq, volume, userAction, code, procedureName, fileName, civil, row_number() OVER (ORDER BY chartSeq, procedureName, airportCode  DESC, cityName, stateAbbr, airportName, volume, code) AS rnum, CASE WHEN LOWER(airportCode) LIKE ? THEN 0 ELSE 1 END AS priority
				FROM procedure
				WHERE cycleId = (SELECT cycleId FROM cycle WHERE cycleName = ?)
				
					AND ( LOWER(airportCode) LIKE ? OR LOWER(icao) LIKE ? )
				
				ORDER BY chartSeq, procedureName, priority, airportCode  DESC, cityName, stateAbbr, airportName, volume, code
			)
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = %afn%
Parameter #2(cf_sql_integer) = 1809
Parameter #3(cf_sql_varchar) = %afn%
Parameter #4(cf_sql_varchar) = %afn%

qryGetSearchResultsDTPP (Datasource=aeronav, Time=890ms, Records=5) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\air_traffic\flight_info\aeronav\digital_products\dtpp\model\AeronavService.cfc @ 18:32:23.023
SELECT *
			
			FROM (
				SELECT stateAbbr, cityName, airportName, airportCode, icao, chartSeq, volume, userAction, code, procedureName, fileName, civil, row_number() OVER (ORDER BY chartSeq, procedureName, airportCode  ASC, cityName, stateAbbr, airportName, volume, code) AS rnum, CASE WHEN LOWER(airportCode) LIKE ? THEN 0 ELSE 1 END AS priority
				FROM procedure
				WHERE cycleId = (SELECT cycleId FROM cycle WHERE cycleName = ?)
				
					AND ( LOWER(airportCode) LIKE ? OR LOWER(icao) LIKE ? )
				
				ORDER BY chartSeq, procedureName, priority, airportCode  ASC, cityName, stateAbbr, airportName, volume, code
			)
			
				WHERE
					rnum BETWEEN 1 AND 50
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = %afn%
Parameter #2(cf_sql_integer) = 1809
Parameter #3(cf_sql_varchar) = %afn%
Parameter #4(cf_sql_varchar) = %afn%

qryGetCycle (Datasource=aeronav, Time=15ms, 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:32:23.023
SELECT startDate, endDate, cycleType
			FROM cycle
			WHERE cycleName = ?
			ORDER BY cycleName
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1809


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\results\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/results/index.cfm?cycle=1809&dir=asc&ident=AFN
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\results\index.cfm
QUERY_STRING=cycle=1809&dir=asc&ident=AFN
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/results/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=181489
CFTOKEN=60731364cd44b656-D293352A-E8BD-ADB1-96BD47F7B590E626
Form Fields:
ADVANCED=0
AIRPORT=
AIRPORTDROPDOWN=
CITY=
CITYDROPDOWN=
CYCLE=
DIAGRAMS=
FILTERADDED=
FILTERCHANGED=
FILTERDELETED=
HOTSPOTS=
IDENT=
IDENTDROPDOWN=
STATE=
VOLUME=
Session Variables:
sessionid=B460033759E1261E398860857272F684.www
urltoken=CFID=181489&CFTOKEN=60731364cd44b656-D293352A-E8BD-ADB1-96BD47F7B590E626&jsessionid=B460033759E1261E398860857272F684.www
URL Parameters:
cycle=1809
dir=asc
ident=AFN
Debug Rendering Time: 12 ms