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

Order JO 7340.2G - Contractions (Cancelled)

Document Information

Type
Order
Number
JO 7340.2G
Title
Contractions
Date issued
2016-12-28
Date cancelled
2018-03-29
Cancelled by
JO 7340.2H
Office of Primary Responsibility
AJV-0, VP Mission Support
Access restriction
Public
Content

For more information, contact 9-awa-ait-directives@faa.gov.

Archived notices
Archived notices associated with this order
Number GENOT Title Effective Cancelled
JO 7340.445 18/06 ICAO Three Letter Designator (3LD) “AUD” And Associated Telephony “GENIE” 2018-03-25 2019-03-25
N JO 7340.444 18/05 ICAO Three Letter Designator (3LD) “GRN” and Associated Telephony “GRANDE” 2018-03-24 2019-03-24
JO 7340.443 18/04 ICAO Three Letter Designator (3LD) “MVP” and Associated Telephony “ALLSTAR” 2018-03-16 2019-03-16
JO 7340.442 18/03 ICAO Three Letter Designator (3LD) “YEL” And Associated Telephony “YELLOWSTONE" 2018-02-21 2019-02-21
JO 7340.441 18/02 ICAO Three Letter Designator (3LD) “FNX” And Associated Telephony “CRESCENT” 2018-02-09 2019-02-09
JO 7340.440 18/01 ICAO Three Letter Designator (3LD) “SIY” And Associated Telephony “SERENITY” 2018-01-26 2019-01-26
JO 7340.439 17/44 Virgin America Transition to Alaska Airlines ICAO 3LD “ASA” and Associated Telephony “ALASKA” 2018-01-11 2019-01-11
JO 7340.438 17/43 ICAO Three Letter Designator (3LD) “XSN” and Associated Telephony “SANTANA” 2017-12-31 2018-12-31
JO 7340.437 17/42 ICAO Three Letter Designator (3LD) “SFY” And Associated Telephony “SKY FLITE 2017-12-15 2018-12-15
JO 7340.436 17/41 ICAO Three Letter Designator (3LD) “SFY” And Associated Telephony “FLITE SAFETY” 2017-12-11 2018-12-12
JO 7340.434 17/39 ICAO Three Letter Designator (3LD) “FGR” And Associated Telephony “FRIGATE” 2017-12-04 2018-12-04
JO 7340.435 17/40 ICAO Three Letter Designator (3LD) “PAF” and Associated Telephony “PATHFINDER” 2017-12-04 2018-12-04
JO 7340.430 17/35 ICAO Three Letter Designator (3LD) “CUL” and Associated Telephony “COULSON” 2017-11-03 2018-11-03
JO 7340.431 17/36 ICAO Three Letter Designator (3LD) “OZT” and Associated Telephony “OZARK TECH” 2017-11-03 2018-11-03
JO 7340.432 17/37 ICAO Three Letter Designator (3LD) “CYT” and Associated Telephony “CRYSTAL AIR” 2017-11-03 2018-11-03
JO 7340.433 17/38 ICAO Three Letter Designator (3LD) “EGS” and Associated Telephony “EVERGLADES” 2017-11-03 2018-11-03
JO 7340.429 17/34 U.S. Special Call Sign Designator (TOWE) and Associated Telephony (TOWE) 2017-10-23 2018-10-23
JO 7340.428 17/33 ICAO THREE LETTER DESIGNATOR (3LD) “JRT” AND ASSOCIATED TELEPHONY “JETRIGHT” 2017-10-12 2018-10-12
JO 7340.427 17/32 ICAO THREE LETTER DESIGNATOR (3LD) “HWA” AND ASSOCIATED TELEPHONY “HILLWOOD” 2017-09-14 2018-09-14
JO 7340.426 17/31 ADDITION OF ICAO THREE LETTER DESIGNATOR (3LD)/TELEPHONY “CFR/CALFIRE”; AND CANCELLATION OF U.S. SPECIAL CALL SIGN DESIGNATOR/TELEPHONY “CALFR/CALFIRE” 2017-08-21 2018-08-21
JO 7340.424 17/29 ICAO THREE LETTER DESIGNATOR (3LD) “MVJ” AND ASSOCIATED TELEPHONY “MIRA VISTA” 2017-08-11 2018-08-11
JO 7340.425 17/30 ICAO THREE LETTER DESIGNATOR (3LD) “RDN” AND ASSOCIATED TELEPHONY “RED BARN” 2017-08-11 2018-08-11
JO 7340.422 17/27 ICAO THREE LETTER DESIGNATOR (3LD ADDITIONS: “JPR" AND ASSOCIATED TELEPHONY "JUMPER" 2018-07-24 2018-07-24
JO 7340.423 17/28 ICAO THREE LETTER DESIGNATOR (3LD) “SFX” AND ASSOCIATED TELEPHONY “SWAMP FOX 2017-07-27 2018-07-27
JO 7340.421 17/26 U.S. SPECIAL CALL SIGN DESIGNATOR (AAL75BK) AND ASSOCIATED TELEPHONY (AMERICAN75 BRAVO KILO) 2017-07-14 2017-08-31
JO 7340.419 17/23 U.S. SPECIAL CALL SIGN DESIGNATOR (ARCK) AND ASSOCIATED TELEPHONY (ARCK) 2017-07-05 2018-07-05
JO 7340.418 17/21 ICAO THREE LETTER DESIGNATOR (NEW) AND ASSOCIATED TELEPHONY (NORTHEASTERN) 2017-06-09 2018-06-09
JO 7340.416 17/19 Three Letter Designator (3LD) GDS and Associated Telephony Goldstrike 2017-05-19 2018-05-19
JO 7340.417 17/20 THREE LETTER DESIGNATOR (3LD) ERY AND ASSOCIATED TELEPHONY ERIE SHORE CHAPTER 3, SECTIONS 1, 2, 3, 4. 2017-05-19 2018-05-19
JO 7340.415 17/17 ROM/ROM 2017-05-05 2018-05-05
JO 7340.414 17/16 SEARU/SEARU 2017-04-27 2018-04-27
JO 7340.411 17/13 MOOSEHEAD/BERKS 2017-04-21 2018-04-21
JO 7340.412 17/14 CLEARWING/CWG 2017-04-18 2018-04-18
JO 7340.413 17/15 PENINSULA/NLA 2017-04-21 2018-04-21
JO 7340.410 17/12 WILDLAND/WLDLD 2017-04-24 2018-04-24
JO 7340.409 17/11 ROCKSTAR/RKS 2017-04-07 2018-04-08
JO 7340.407 17/09 SOUTHERN FLIGHT/SXF 2017-04-07 2018-04-07
JO 7340.408 17/10 HEXBUG/BUG 2017-04-07 2018-04-07
JO 7340.404 17/07 HOPE AIR/HPE 2017-03-10 2018-03-10
Cancels
Cancelled documents
Number Title Date
JO 7340.378 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4 2016-06-09
JO 7340.379 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4 2016-08-03
JO 7340.376 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-05-26
JO 7340.377 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-05-26
JO 7340.383 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-08-31
JO 7340.384 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-08-30
JO 7340.385 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-08-30
JO 7340.386 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-09-08
JO 7340.389 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-10-18
JO 7340.374 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1,2,3. 2016-03-14
JO 7340.382 ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1,2,3. 2016-08-10
JO 7340.370 Additions Per Order 7340.2, Contractions, Chapter 3, Sections 1, 2, 3, 4 2016-02-05
JO 7340.371 Additions Per Order 7340.2, Contractions, Chapter 3, Sections 1, 2, 3, 4 2016-02-25
JO 7340.372 Additions Per Order 7340.2, Contractions, Chapter 3, Sections 1, 2, 3, 4 2016-03-11
JO 7340.373 Additions Per Order 7340.2, Contractions, Chapter 3, Sections 1, 2, 3, 4 2016-03-11
JO 7340.2F Contractions 2015-10-15
JO 7340.381 DELETION OF CALL SIGN ASSIGNMENT PROCEDURES FROM FAA ORDER 7340.2, CONTACTIONS, CHAPTER 1, SECTION 3 2016-08-05
JO 7340.375 MODIFICATION PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1,2,3. 2016-05-13
JO 7340.388 SUBJECT: ADDITIONS PER ORDER 7340.2, CONTRACTIONS, CHAPTER 3, SECTIONS 1, 2, 3, 4. 2016-10-05
JO 7340.406 Traffic Flow Management Convective Forecast Product (TCF) 2017-03-22


Debugging Information
ColdFusion Server Enterprise 2023,0,15,330825
Template /regulations_policies/orders_notices/index.cfm
Time Stamp 18-Dec-25 01:25 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.236
Host Name 10.27.195.236


Execution Time

Total Time Avg Time Count Template
497 ms 497 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fusebox5.cfm
497 ms 497 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/index.cfm
490 ms 490 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | onRequest(/regulations_policies/orders_notices/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
490 ms 490 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/parsed/document.information.cfm
465 ms 465 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/dspDocumentInformation.cfm
214 ms 214 ms 1 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
214 ms 214 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(cancelledByDocumentID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
213 ms 213 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 = 1030449, 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
82 ms 82 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChanges(documentID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
81 ms 81 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
79 ms 79 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChanges(DOCUMENTID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
68 ms 68 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = directive, stuArgumentCollection = [complex value], method = getObjects) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
68 ms 68 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getOrdersAndNotices(documentID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
53 ms 53 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getObjects(DOCUMENTTYPEID = 0, DOCUMENTTYPEIDLIST = , GETGENOTSONLY = 0, SEARCHCRITERIA = , REGIONID = 0, FORMATTEDDOCUMENTTITLE = true, DISTRIBUTIONFIELDID = 0, OBJECTID = 1030449, GETNATIONALDIRECTIVES = 0, STATUSIDLIST = , SORTORDER = DESC, DOCUMENTIDLIST = , SORTCOLUMN = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
40 ms 40 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getRelatedNotices(parentDocumentID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
39 ms 39 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = directive, stuArgumentCollection = [complex value], method = getRelatedDirectives) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
36 ms 12 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
26 ms 26 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getRelatedDirectives(PARENTDOCUMENTID = 1030449, STATUSID = 0, DOCUMENTIDLIST = , RELATIONTYPEID = 3) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
26 ms 26 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc | callObjectGatewayMethod(objectType = directive, stuArgumentCollection = [complex value], method = getDirectiveSupplements) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/facade.cfc
26 ms 26 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDirectiveSupplements(documentID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
23 ms 23 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/layouts/template.cfm
21 ms 21 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
21 ms 21 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
18 ms 18 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
18 ms 18 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
17 ms 17 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1030449, 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 = 1030449) ] 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 = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
11 ms 11 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getDirectiveSupplements(DOCUMENTID = 1030449) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.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/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/templates/6/plugins/actLastUpdated.cfm
3 ms 3 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc | onRequestStart(/regulations_policies/orders_notices/index.cfm) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/Application.cfc
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/applicationCode.cfm
2 ms 2 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/udf/udfGlobal.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/plugins/globalVariables.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actCheckLegacyMode.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actExternalLinks.cfm
0 ms 0 ms 3 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/orders_notices/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, Public_Orders_Notices) ] 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/orders_notices/) ] 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 | 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
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(Public_Orders_Notices, [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/orders_notices/functions/udfQueryToCSV.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/dspRightSidebar.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/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/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
503 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

01:24:59.059 - 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/orders_notices/fusebox.init.cfm.
	    


SQL Queries

qGetDocumentTypeData (Datasource=developersdb, Time=12ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 01:25:00.000
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qryGetObjects (Datasource=developersdb, Time=16ms, Records=5) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 01:25:00.000
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 = 1030449 
				ORDER BY resources.resourceNumber ASC
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 01:25:00.000
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=44ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 01:25:00.000
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 = 1030449 
							ORDER BY docs.dateIssued DESC, docs.subjectClass DESC, docs.sequenceNumber DESC, docs.alphaSuffix DESC, docs.divisionArea DESC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 01:25:00.000
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) = 1030449

qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 01:25:00.000
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=189ms, Records=20) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 01:25:00.000
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 = 1030449 
							ORDER BY docs.documentTitle ASC, docs.subjectClass ASC, docs.sequenceNumber ASC, docs.alphaSuffix ASC, docs.divisionArea ASC
qGetObjects (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 01:25:00.000
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) = 1030449
Parameter #2(cf_sql_numeric) = 5
Parameter #3(cf_sql_numeric) = 2

qGetDocumentTypeData (Datasource=developersdb, Time=12ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 01:25:00.000
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetSupplements (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 01:25:00.000
SELECT supplementID, documentID, regionID, suppNum, suppDate, suppURL, isArchived, isNationalSupplement
			FROM dlDirectiveSupplement
			WHERE parentDocumentID = ?
			ORDER BY suppNum ASC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1030449

qGetDocumentTypeData (Datasource=developersdb, Time=12ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 01:25:00.000
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetObjects (Datasource=developersdb, Time=26ms, Records=39) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 01:25:00.000
SELECT
				relatedDocs.documentRelationID,
				relatedDocs.childDocumentID,
				relatedDocs.parentDocumentID,
				relatedDocs.relationTypeID,
				relationTypes.relationType,
				childDocInfo.documentNumber,
				childDocInfo.documentTitle,
				childDocInfo.dateEffective,
				childDocInfo.dateIssued,
				childDocInfo.dateCancelled,
				childDocInfo.cancelNotes,
				childDocInfo.statusID,
				childDocInfo.cancelledByDocumentID,
				childDocInfo.restrictionCodeID,
				childDocInfo.subjectClass,
				childDocInfo.divisionArea,
				childDocInfo.sequenceNumber,
				childDocInfo.alphaSuffix,
				childDocInfo.description,
				childDocInfo.changeNumber,
				parentDocInfo.documentID AS parentDocumentID,
				parentDocInfo.documentNumber AS parentDocumentNumber,
				REGEXP_REPLACE(parentDocInfo.documentTitle, '^[^a-zA-Z0-9""'']+(.*)', '\1') AS parentDocumentTitle,
				parentDocInfo.dateIssued AS parentDateIssued,
				parentDocInfo.dateEffective AS parentDateEffective,
				parentDocInfo.dateCancelled AS parentDateCancelled,
				parentDocInfo.cancelNotes AS parentCancelNotes,
				parentDocInfo.statusID AS parentStatusID,
				parentDocInfo.restrictionCodeID AS parentRestrictionCodeID,
				parentOffice.officeNumber AS parentOfficeNumber,
				docStatuses.status,
				childOffice.officeNumber,
				childDirInfo.isGenot,
				childDirInfo.genotID,
				childDirInfo.revalDate,
				cancelDocument.documentNumber AS cancelledByDocumentNumber
			FROM dlDocumentRelation relatedDocs
			INNER JOIN dlDocument parentDocInfo ON relatedDocs.parentDocumentID = parentDocInfo.documentID
			INNER JOIN dlDocument childDocInfo ON relatedDocs.childDocumentID = childDocInfo.documentID
			INNER JOIN dlDirective parentDirInfo ON parentDocInfo.documentID = parentDirInfo.documentID
			INNER JOIN dlDirective childDirInfo ON childDocInfo.documentID = childDirInfo.documentID
			INNER JOIN dlRelationType relationTypes ON relatedDocs.relationTypeID = relationTypes.relationTypeID
			INNER JOIN dlDocumentStatus docStatuses ON childDocInfo.statusID = docStatuses.statusID
			LEFT OUTER JOIN dlOffice childOffice ON childOffice.officeID = childDocInfo.officeID
			LEFT OUTER JOIN dlOffice parentOffice ON parentOffice.officeID = parentDocInfo.officeID
			LEFT OUTER JOIN dlDocument cancelDocument ON childDocInfo.cancelledByDocumentID = cancelDocument.documentID
			WHERE 1=1

			
					AND relatedDocs.parentDocumentID = ? 
				AND relatedDocs.relationTypeID = ? 

			ORDER BY childDocInfo.subjectClass DESC, childDocInfo.sequenceNumber DESC, childDocInfo.dateIssued DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1030449
Parameter #2(cf_sql_numeric) = 3

Variables.qGetCurrentNotices (Datasource=developersdb, Time=0ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\view\dspDocumentInformation.cfm @ 01:25:00.000
SELECT DISTINCT
							childDocumentID AS documentID,
							documentNumber,
							documentTitle,
							dateEffective,
							dateIssued,
							revalDate,
							genotID,
							restrictionCodeID
						FROM
							Variables.qGetRelatedNotices
						WHERE
							statusID = ?
						ORDER BY
							dateIssued DESC,
							dateCancelled DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 2

Variables.qGetArchivedNotices (Datasource=developersdb, Time=0ms, Records=39) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\view\dspDocumentInformation.cfm @ 01:25:00.000
SELECT DISTINCT
							childDocumentID AS documentID,
							documentNumber,
							documentTitle,
							dateEffective,
							dateIssued,
							revalDate,
							genotID,
							restrictionCodeID
						FROM
							Variables.qGetRelatedNotices
						WHERE
							statusID = ?
						ORDER BY
							dateIssued DESC,
							dateCancelled DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 3


Stored Procedures

pkg_docLib_directives_temp.spGetDirectives_temp (Datasource=developersdb, Time=53ms) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 01:25:00.000

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  1030449    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  0    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  0    
 IN  cf_sql_numeric  1    
 IN  cf_sql_numeric  0    
 IN  cf_sql_numeric  0    
 IN  cf_sql_numeric  0    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  0    
 IN  cf_sql_numeric  0    
 IN  cf_sql_numeric  0    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  0    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  dateIssued    
 IN  cf_sql_varchar  DESC    
 IN  cf_sql_numeric  0    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
    
resultsets
nameresultset
 qGetObjects  1


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\orders_notices\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/orders_notices/index.cfm/go/document.information/documentID/1030449
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/1030449
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.27.195.236
REMOTE_HOST=10.27.195.236
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/regulations_policies/orders_notices/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=256514
CFTOKEN=d219bc1b9458afe1-E154EC32-BF8E-39F5-44AEF82641ACA17E
Session Variables:
sessionid=6B87C7A567F023849F607744C4BE3023.www
urltoken=CFID=256514&CFTOKEN=d219bc1b9458afe1-E154EC32-BF8E-39F5-44AEF82641ACA17E&jsessionid=6B87C7A567F023849F607744C4BE3023.www
Debug Rendering Time: 19 ms