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

Series 150 Advisory Circulars (ACs) for Airport Projects

Search Results

Number, title, description, or office

Series 150 Advisory Circulars (ACs) for Airport Projects search results
Number Title Status Office Date
150/5340-26C Maintenance of Airport Visual Aid Facilities

This AC provides guidance and specifications for the Maintenance of airport Visual Aid Facilities.

 Active AAS-100 2014-06-20
150/5340-30J Design and Installation Details for Airport Visual Aids

This AC provides guidance and recommendations on the installation of airport visual aids. See the Principal Changes paragraph for a list of major changes to the document since the last version.

 Active AAS-100 2018-02-12
150/5340-18H Standards for Airport Sign Systems

This Advisory Circular (AC) contains the Federal Aviation Administration (FAA) standards for the siting, design, and installation of signs on airport runways and taxiways.

 Active AAS-110 2024-09-30
150/5340-5D Segmented Circle Airport Marker System

This AC provides standards for a system of airport marking consisting of certain pilot aids and traffic control devices.

 Active AAS-100 2013-09-25
150/5340-1M Standards for Airport Markings

This AC contains the FAA standards for markings used on airport runways, taxiways, and aprons. Consolidated to include Change 1, dated December 23, 2020.

 Active AAS-100 2019-05-10

Debugging Information
ColdFusion Server Enterprise 2023,0,15,330825
Template /airports/resources/advisory_circulars/index.cfm
Time Stamp 18-Dec-25 12:09 AM
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.251
Host Name 10.27.195.251

Execution Time

Total Time Avg Time Count Template
215 ms 215 ms 1 top level \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\airports\resources\advisory_circulars\index.cfm
215 ms 215 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fusebox5.cfm
207 ms 207 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | onRequest(/airports/resources/advisory_circulars/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
206 ms 206 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/parsed/document.list.cfm
99 ms 99 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/FusionSearchService.cfc | search(apiParams = [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/FusionSearchService.cfc
99 ms 99 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/model/actQueryFusion.cfm
63 ms 32 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getTopics(documentTypeIDList = 5, parentTopicID = 11) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
62 ms 31 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = topic, stuArgumentCollection = [complex value], method = getObjects) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
58 ms 29 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc | getObjects(OBJECTID = 0, DOCUMENTTYPEIDLIST = 5, PARENTTOPICID = 11, PARENTTOPICSONLY = false) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc
34 ms 34 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/plugins/globalVariables.cfm
33 ms 33 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/view/dspSearchForm.cfm
26 ms 26 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/view/layouts/template.cfm
24 ms 24 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
24 ms 24 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
7 ms 7 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.cfm
6 ms 6 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actMenu.cfm
6 ms 6 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspTemplate.cfm
4 ms 4 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | onRequestStart(/airports/resources/advisory_circulars/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
4 ms 4 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/airports/resources/advisory_circulars/view/dspSearchResults.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
2 ms 2 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc | compileRequest(document.list, CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.myFusebox) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/model/actConfigureFusion.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 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc | init(Airports_AdvisoryCirculars_Public, [complex value], [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/FusionSearchService.cfc | init(suggestQueryProfile = AC150Suggest, queryProfile = AC150) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/FusionSearchService.cfc
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actChatbot.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/dspHeader.cfm
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/topicGateway.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | bleed([complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | onRequestEnd(/airports/resources/advisory_circulars/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(ADDURIQUERYKEY, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(ASSETQUERYSTRING, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(ATTRIBUTES, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(DETECTTIER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(DOCUMENTVIEWER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(EMAILFORM, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(FORMATFILESIZE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(FUSEBOX_APPLICATION_KEY, Airports_AdvisoryCirculars_Public) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(FUSEBOX_APPLICATION_PATH, ) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(FUSEBOX_CALLER_PATH, //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(FUSEBOX_PARAMETERS, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(GETFILESIZE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(GETFILETYPE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(GETPAGEURI, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(IMAGEFORMAT, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(KILLXSSINSTRING, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(MATCHER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(MATCHERNOCASE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(MATCHURI, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(PAGEREDIRECT, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(PARSEURI, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(REMATCHER, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(REMATCHERNOCASE, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(REMOVEURIQUERYKEY, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(REPLACEURIQUERYKEY, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(STRIPHTML, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(THROWERROR, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(__FUSEBOXAPPCFC, CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.Application) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | override(_item, replaceUriQueryKey) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxAction.cfc | getAccess() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxAction.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc | expandFuseboxPath(parsed/) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc | getCoreToAppRootPath() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc | getVersion() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxEvent.cfc | init([complex value], [complex value], CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.myFusebox) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxEvent.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc | trace(Fusebox, Request completed) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.cfc
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/airports/resources/advisory_circulars/functions/udfQueryToCSV.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/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/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/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
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
223 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

Exceptions

00:09:38.038 - MissingInclude Exception - in //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc : line 167
	    Could not find the included template ../airports/resources/advisory_circulars/fusebox.init.cfm.

SQL Queries

qGetObjects (Datasource=developersdb, Time=29ms, Records=15) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\topicGateway.cfc @ 00:09:39.039
SELECT DISTINCT
					topics.topicID, topics.topic, associations.parentTopicID,
					(
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID WHERE dt.topicID = topics.topicID
							
								AND d.documentTypeID IN (5)
							
					) AS documentCount
				FROM
					dlDocumentTopic docTopics
				INNER JOIN dlDocument docs ON docs.documentID = docTopics.documentID
				INNER JOIN dlTopic topics ON topics.topicID = docTopics.topicID
				INNER JOIN dlTopicAssociation associations ON topics.topicID = associations.topicID
				WHERE docs.documentTypeID IN (5)
				AND (
					(
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID WHERE dt.topicID = topics.topicID
						
							AND
								d.documentTypeID IN (5)
						
					) > 0
					OR (
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID
						WHERE
							dt.topicID IN (
								SELECT
									topicID
								FROM
									dlTopicAssociation
								WHERE
									parentTopicID = topics.topicID
							)
						
							AND d.documentTypeID IN (5)
						
					) > 0
				)
				
					AND (associations.parentTopicID = 11 OR associations.topicID = 11)
				

				UNION
				SELECT
					pt.topicID,
					pt.topic,
					pta.parentTopicID,
					(
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID WHERE dt.topicID = pt.topicID
							
								AND d.documentTypeID IN (5)
							
					) AS documentCount
				FROM
					dlTopic pt
				INNER JOIN
					dlTopicAssociation pta ON pt.topicID = pta.topicID
				WHERE
					pt.topicID IN (
						SELECT
							parentTopicID
						FROM
							dlTopicAssociation
						WHERE
							topicID IN (
								SELECT DISTINCT
									topics.topicID
								FROM
									dlDocumentTopic docTopics
								INNER JOIN
									dlDocument docs ON docs.documentID = docTopics.documentID
								INNER JOIN
									dlTopic topics ON topics.topicID = docTopics.topicID
								INNER JOIN
									dlTopicAssociation associations ON topics.topicID = associations.topicID
								WHERE
									docs.documentTypeID IN (5)
							)
					)
					AND (
						(
							SELECT
								count(*)
							FROM
								dlDocumentTopic dt
							INNER JOIN
								dlDocument d ON dt.documentID = d.documentID
							WHERE
								dt.topicID = pt.topicID
								
									AND d.documentTypeID IN (5)
								
						) > 0
					OR (
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID
						WHERE
							dt.topicID IN (
								SELECT
									topicID
								FROM
									dlTopicAssociation
								WHERE
									parentTopicID = pt.topicID)
									
										AND d.documentTypeID IN (5)
									
							) > 0
					)
					
						AND (pta.parentTopicID = 11 OR pta.topicID = 11)
					
					ORDER BY topic ASC
qGetObjects (Datasource=developersdb, Time=28ms, Records=15) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\topicGateway.cfc @ 00:09:39.039
SELECT DISTINCT
					topics.topicID, topics.topic, associations.parentTopicID,
					(
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID WHERE dt.topicID = topics.topicID
							
								AND d.documentTypeID IN (5)
							
					) AS documentCount
				FROM
					dlDocumentTopic docTopics
				INNER JOIN dlDocument docs ON docs.documentID = docTopics.documentID
				INNER JOIN dlTopic topics ON topics.topicID = docTopics.topicID
				INNER JOIN dlTopicAssociation associations ON topics.topicID = associations.topicID
				WHERE docs.documentTypeID IN (5)
				AND (
					(
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID WHERE dt.topicID = topics.topicID
						
							AND
								d.documentTypeID IN (5)
						
					) > 0
					OR (
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID
						WHERE
							dt.topicID IN (
								SELECT
									topicID
								FROM
									dlTopicAssociation
								WHERE
									parentTopicID = topics.topicID
							)
						
							AND d.documentTypeID IN (5)
						
					) > 0
				)
				
					AND (associations.parentTopicID = 11 OR associations.topicID = 11)
				

				UNION
				SELECT
					pt.topicID,
					pt.topic,
					pta.parentTopicID,
					(
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID WHERE dt.topicID = pt.topicID
							
								AND d.documentTypeID IN (5)
							
					) AS documentCount
				FROM
					dlTopic pt
				INNER JOIN
					dlTopicAssociation pta ON pt.topicID = pta.topicID
				WHERE
					pt.topicID IN (
						SELECT
							parentTopicID
						FROM
							dlTopicAssociation
						WHERE
							topicID IN (
								SELECT DISTINCT
									topics.topicID
								FROM
									dlDocumentTopic docTopics
								INNER JOIN
									dlDocument docs ON docs.documentID = docTopics.documentID
								INNER JOIN
									dlTopic topics ON topics.topicID = docTopics.topicID
								INNER JOIN
									dlTopicAssociation associations ON topics.topicID = associations.topicID
								WHERE
									docs.documentTypeID IN (5)
							)
					)
					AND (
						(
							SELECT
								count(*)
							FROM
								dlDocumentTopic dt
							INNER JOIN
								dlDocument d ON dt.documentID = d.documentID
							WHERE
								dt.topicID = pt.topicID
								
									AND d.documentTypeID IN (5)
								
						) > 0
					OR (
						SELECT
							count(*)
						FROM
							dlDocumentTopic dt
						INNER JOIN
							dlDocument d ON dt.documentID = d.documentID
						WHERE
							dt.topicID IN (
								SELECT
									topicID
								FROM
									dlTopicAssociation
								WHERE
									parentTopicID = pt.topicID)
									
										AND d.documentTypeID IN (5)
									
							) > 0
					)
					
						AND (pta.parentTopicID = 11 OR pta.topicID = 11)
					
					ORDER BY topic ASC

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\airports\resources\advisory_circulars\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=/airports/resources/advisory_circulars/index.cfm/go/document.list/?appliedFacets=%7B%22subjectclass%22%3A%22150%2F5340%22%7D
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=/go/document.list/
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\airports\resources\advisory_circulars\index.cfm
QUERY_STRING=appliedFacets=%7B%22subjectclass%22%3A%22150%2F5340%22%7D
REMOTE_ADDR=10.27.195.251
REMOTE_HOST=10.27.195.251
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/airports/resources/advisory_circulars/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=243578
CFTOKEN=614e066ed3757a25-DEA31140-CCB7-C583-991B6F7A50996F79

Session Variables:
sessionid=2F54417D68637269824ED87A88D7619A.www
urltoken=CFID=243578&CFTOKEN=614e066ed3757a25-DEA31140-CCB7-C583-991B6F7A50996F79&jsessionid=2F54417D68637269824ED87A88D7619A.www

URL Parameters:
appliedFacets={"subjectclass":"150/5340"}
Debug Rendering Time: 19 ms