Skip to page content

United States Department of Transportation

AC 20-189 - Management of Open Problem Reports (OPRs)

Document Information

Number

20-189

Title

Management of Open Problem Reports (OPRs)

Status

Active

Date issued

2022-09-16

Office of Primary Responsibility

AIR-600, Policy and Innovation Division

Description

This advisory circular (AC) describes an acceptable means for showing compliance with the applicable airworthiness regulations for the management of open problem reports (OPRs) in technical standard order (TSO) authorization and type certification for the system, software, and airborne electronic hardware (AEH) domains.This document contains guidance that is not legally binding in its own right nor will be relied upon by the Department of Transportation or the Federal Aviation Administrationas a separate basis for affirmative enforcement action or other administrative penalty. Moreover, conformity with this guidance document (as distinct from existing statutes andregulations) is voluntary only, and nonconformity will not affect rights and obligations under statutes and regulations. This document is intended only to provide clarity to the public regarding existing requirements under the law or agency policies. However, if you use the means described in this AC, you should follow it in all applicable respects unless alternate means are proposed and accepted by the FAA.

Content

20-189 (PDF)

Debugging Information

ColdFusion Server Enterprise	2023,0,15,330825
Template	/regulations_policies/advisory_circulars/index.cfm
Time Stamp	17-Dec-25 05:56 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
209 ms	209 ms	1	\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\advisory_circulars\index.cfm
208 ms	208 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fusebox5.cfm
196 ms	196 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| onRequest(/regulations_policies/advisory_circulars/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
196 ms	196 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/advisory_circulars/parsed/document.information.cfm
166 ms	166 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/advisory_circulars/view/dspDocumentInformation.cfm
82 ms	41 ms	2	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getObjects) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
50 ms	50 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getDocumentChanges) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
50 ms	50 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocumentChanges(documentID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
47 ms	47 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getDocumentChanges(DOCUMENTID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
44 ms	44 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocuments(cancelledByDocumentID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
41 ms	41 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getObjects(CHANGENUMBER = 0, DOCUMENTNUMBER = , GETGENOTSONLY = 0, SEARCHCRITERIA = , DIVISIONAREA = , FORMATTEDDOCUMENTTITLE = 0, OBJECTID = 0, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 1032306, SORTORDER = ASC, RESTRICTIONCODEID = 0, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = documentID, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 0, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = , VERSIONTYPEID = 0, ALPHASUFFIX = , MAXROWS = 0, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
40 ms	40 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocuments(documentID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
36 ms	36 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getObjects(CHANGENUMBER = 0, DOCUMENTNUMBER = , GETGENOTSONLY = 0, SEARCHCRITERIA = , DIVISIONAREA = , FORMATTEDDOCUMENTTITLE = 0, OBJECTID = 1032306, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 0, SORTORDER = ASC, RESTRICTIONCODEID = 0, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = documentID, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 0, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = , VERSIONTYPEID = 0, ALPHASUFFIX = , MAXROWS = 0, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
26 ms	26 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/advisory_circulars/view/layouts/template.cfm
25 ms	25 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
24 ms	24 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
17 ms	17 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = resource, stuArgumentCollection = [complex value], method = getObjectResources) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
17 ms	17 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getDocumentResources(documentID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
15 ms	15 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc \| getObjectResources(OBJECTID = 1032306, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
14 ms	14 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc \| callObjectGatewayMethod(objectType = document, stuArgumentCollection = [complex value], method = getRelatedDrafts) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
14 ms	14 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc \| getRelatedDrafts(documentID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
13 ms	13 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| getRelatedDrafts(DOCUMENTID = 1032306) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
8 ms	8 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actMenu.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	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc \| onRequestStart(/regulations_policies/advisory_circulars/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
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	//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
4 ms	4 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
3 ms	3 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspBody.cfm
1 ms	1 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc \| compileRequest(document.information, CFC: aeronavfiles.www.faa.gov.Webcont.fusebox.myFusebox) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fuseboxApplication.cfc
1 ms	1 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/advisory_circulars/plugins/globalVariables.cfm
1 ms	1 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/menu/actBuildMenu.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/dspPageTools.cfm
0 ms	0 ms	4	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc \| init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
0 ms	0 ms	1	CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc \| init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.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(/regulations_policies/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, 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/regulations_policies/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 \| init(AdvisoryCirculars_Public, [complex value], [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/myFusebox.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/regulations_policies/advisory_circulars/functions/udfQueryToCSV.cfm
0 ms	0 ms	1	//webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/advisory_circulars/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/actExternalLinks.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/dspHeader.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
215 ms			TOTAL EXECUTION TIME

red = over 250 ms average execution time

Exceptions

17:56:06.006 - 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 ../regulations_policies/advisory_circulars/fusebox.init.cfm.

SQL Queries

qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0

qGetObjects (Datasource=developersdb, Time=14ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT

			
				docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				
					docs.documentTitle,
				
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				UPPER(TRIM(docs.subjectClass)) AS subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				docs.dateCreated,
				docs.dateModified,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				

			FROM
				dlDocument docs

			

			INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
			LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
			LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
			LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			LEFT OUTER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
			WHERE 1 = 1

			
				AND docs.documentID = 1032306 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC

qryGetObjects (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 17:56:06.006

SELECT resources.resourceID,
					resources.resourceNumber,
					resources.resourceURI,
					resources.resourceTitle1,
					resources.resourceTitle2,
					objectResources.isPrimaryFile,
					objectResources.isPrimaryWeb,
					resources.dateEffective,
					resources.comments,
					resources.dateCreated,
					resources.dateModified
				FROM dlDocumentResource objectResources
				INNER JOIN dlResource resources ON objectResources.resourceID = resources.resourceID
				WHERE 1=1
				
					AND objectResources.documentID = 1032306 
				ORDER BY resources.resourceNumber ASC

qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0

qGetObjects (Datasource=developersdb, Time=13ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT

			
				docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				
					docs.documentTitle,
				
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				UPPER(TRIM(docs.subjectClass)) AS subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				docs.dateCreated,
				docs.dateModified,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				

			FROM
				dlDocument docs

			

			INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
			LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
			LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
			LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			LEFT OUTER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
			WHERE 1 = 1

			
				AND docs.documentID = 1032306 
							ORDER BY docs.dateIssued DESC, docs.subjectClass DESC, docs.sequenceNumber DESC, docs.alphaSuffix DESC, docs.divisionArea DESC

qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT changes.changeID, changes.documentID, changes.changeNumber, changes.changeTitle AS documentTitle, changes.changeDescription AS description, changes.dateIssued, changes.statusID,
			statuses.status
			FROM dlChange changes
			LEFT OUTER JOIN dlDocumentStatus statuses ON changes.statusID = statuses.statusID
			WHERE documentID = ?
			ORDER BY changeNumber ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_numeric) = 1032306

qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0

qGetObjects (Datasource=developersdb, Time=19ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT

			
				docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				
					docs.documentTitle,
				
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				UPPER(TRIM(docs.subjectClass)) AS subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				docs.dateCreated,
				docs.dateModified,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				

			FROM
				dlDocument docs

			

			INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
			LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
			LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
			LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			LEFT OUTER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
			WHERE 1 = 1

			
				AND docs.cancelledByDocumentID = 1032306 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC

qGetObjects (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 17:56:06.006

SELECT docs.documentID,
				docs.officeID,
				docs.statusID,
				docs.cancelledByDocumentID,
				REGEXP_REPLACE(docs.documentTitle, '^[^a-zA-Z0-9""'']+(.*)', '\1') AS documentTitle,
				docs.documentTypeID,
				docs.documentNumber,
				docs.divisionArea,
				docs.subjectClass,
				docs.sequenceNumber,
				docs.alphaSuffix,
				docs.changeNumber,
				docs.dateEffective,
				docs.dateIssued,
				docs.dateCancelled,
				docs.cancelNotes,
				docs.description,
				docs.createdByUserID,
				docs.modifiedByUserID,
				docs.contactFirstName,
				docs.contactLastName,
				docs.contactEmail,
				docs.contactPhone,
				docs.govDeliveryCode,
				docs.restrictionCodeID,
				docs.versionTypeID,
				docs.commentsDeadlineDate,
				docs.dateCreated,
				docs.dateModified,
				docs.newRevisedComments,
				docs.orderPurposeStatement,
				(SELECT MAX(revisionDate) FROM dlDocumentRevision WHERE documentID = docs.documentID) AS maxRevisionDate,
				offices.officeNumber, offices.officeName, offices.officeURL,
				docTypes.documentType,
				cancelDoc.documentNumber AS cancelledByDocumentNumber,
				statuses.status,
				versionTypes.versionType
				FROM dlDocument docs
				INNER JOIN dlDocumentType docTypes ON docs.documentTypeID = docTypes.documentTypeID
				INNER JOIN dlVersionType versionTypes ON docs.versionTypeID = versionTypes.versionTypeID
				LEFT OUTER JOIN dlOffice offices ON docs.officeID = offices.officeID
				LEFT OUTER JOIN dlDocumentStatus statuses ON docs.statusID = statuses.statusID
				LEFT OUTER JOIN dlDocument cancelDoc ON docs.cancelledByDocumentID = cancelDoc.documentID
			
			WHERE
			docs.documentID IN (
				SELECT childDocumentID
				FROM dlDocumentRelation
				WHERE parentDocumentID = ?
				AND relationTypeID = ?
			)
			AND docs.statusID = ?
			ORDER BY changeNumber ASC

Query Parameter Value(s) -

			
			    
			        Parameter #1(cf_sql_numeric) = 1032306

			    
			        Parameter #2(cf_sql_numeric) = 5

			    
			        Parameter #3(cf_sql_numeric) = 2

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\regulations_policies\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=/regulations_policies/advisory_circulars/index.cfm/go/document.information/documentID/1032306
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.information/documentID/1032306
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\advisory_circulars\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.27.195.250
REMOTE_HOST=10.27.195.250
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/regulations_policies/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=175134
CFTOKEN=cae4b5efa268d0aa-D1473FF4-9C5B-9BAE-5C78C0A8169FCB50

Session Variables:
sessionid=89C8C1767EA65F63DF0C34677C7C19A8.www
urltoken=CFID=175134&CFTOKEN=cae4b5efa268d0aa-D1473FF4-9C5B-9BAE-5C78C0A8169FCB50&jsessionid=89C8C1767EA65F63DF0C34677C7C19A8.www

Debug Rendering Time: 22 ms

USA Banner

AC 20-189 - Management of Open Problem Reports (OPRs)

Document Information

U.S. Department of Transportation