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.2J - Contractions (Cancelled)

Document Information

Type
Order
Number
JO 7340.2J
Title
Contractions
Date issued
2019-06-03
Date cancelled
2020-09-10
Cancelled by
JO 7340.2K
Office of Primary Responsibility
AJV-0, VP Mission Support
Access restriction
Public
Order purpose statement

This order contains the approved word and phrase contractions used by personnel of the Federal Aviation Administration (FAA). It is also used by other agencies that provide air traffic control, communications, weather, charting, and associated services.

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.601 20/47 COMPANY NAME CHANGE FOR ICAO 3LD/TELEPHONY “JED/JET EAST”; AND CANCELLATION OF U.S. SPECIAL CALL SIGN DESIGNATOR/TELEPHONY “PHXA/PHOENIX AIR” 2020-09-30 2021-09-30
JO 7340.600 20/46 DELETE U.S. SPECIAL CALL SIGN “CITY/CITY FLIGHT” 2020-08-20 2021-08-20
JO 7340.599 20/45 DELETE U.S. SPECIAL CALL SIGN “CONN/CONNECTION” 2020-08-19 2021-08-19
JO 7340.596 20/44 ADDITION OF ICAO THREE LETTER DESIGNATOR (3LD)/TELEPHONY “NIT/NIGHTTRAIN”; AND CANCELLATION OF U.S. SPECIAL CALL SIGN DESIGNATOR/TELEPHONY “MDKT/MIDKNIGHT” 2020-09-01 2021-09-01
JO 7340.597 20/42 ICAO THREE LETTER DESIGNATOR (3LD) “FDJ” AND ASSOCIATED CALL SIGN “FREEDOM JET” 2020-08-20 2021-08-20
JO 7340.598 20/43 ICAO THREE LETTER DESIGNATOR (3LD) “LFA” AND ASSOCIATED CALL SIGN “BUCKY” 2020-08-19 2021-08-19
JO 7340.595 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2020-08-14 2021-08-14
JO 7340.594 20/41 ICAO THREE LETTER DESIGNATOR (3LD) “JLF” AND ASSOCIATED CALL SIGN “JETLYFT” 2020-08-14 2021-08-14
JO 7340.593 20/40 ICAO THREE LETTER DESIGNATOR (3LD) “HER” AND ASSOCIATED CALL SIGN “HERA” 2020-08-06 2021-08-06
JO 7340.592 20/38 ICAO THREE LETTER DESIGNATOR (3LD) “CPZ” AND ASSOCIATED CALL SIGN “COMPASS” 2020-07-27 2021-07-27
JO 7340.591 20/37 COMPANY NAME CHANGE: VALKYRIE LEASING, LLC 2020-07-22 2021-07-22
JO 7340.589 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2020-07-14 2021-07-14
JO 7340.590 20/36 ICAO THREE LETTER DESIGNATOR (3LD) “CAK” AND ASSOCIATED CALL SIGN “CACTUS” 2020-07-17 2021-07-17
JO 7340.588 20/35 ICAO THREE LETTER DESIGNATOR (3LD) “MAD” AND ASSOCIATED CALL SIGN “MALONE” 2020-07-03 2021-07-03
JO 7340.587 20/34 ICAO THREE LETTER DESIGNATOR (3LD) “RLJ” AND ASSOCIATED CALL SIGN “REAL JET” 2020-06-18 2021-06-18
JO 7340.586 20/33 ICAO THREE LETTER DESIGNATOR (3LD) “FTK” AND ASSOCIATED TELEPHONY “(FIRETAC)” 2020-06-14 2021-06-14
JO 7340.585 20/31 ICAO THREE LETTER DESIGNATOR (3LD) “RGL” AND ASSOCIATED CALL SIGN “RIDGELINE” 2020-06-08 2021-06-08
JO 7340.583 20/30 COMPANY NAME CHANGE: FELIX AIR, INC. 2020-05-22 2021-05-22
JO 7340.584 20/29 ICAO THREE LETTER DESIGNATOR (3LD) “BEN” AND ASSOCIATED CALL SIGN “FRANKLIN” 2020-05-25 2021-05-25
JO 7340.580 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2020-05-13 2021-05-13
JO 7340.581 20/27 CANCELLATION OF ICAO THREE LETTER DESIGNATOR (3LD) “AAE” AND ASSOCIATED CALL SIGN “ARIZONA” 2020-05-20 2021-05-20
JO 7340.582 20/28 COMPANY NAME CHANGE: AEROSUN INTERNATIONAL, INC. 2020-05-20 2021-05-20
JO 7340.579 20/26 ICAO THREE LETTER DESIGNATOR (3LD) “MHY” WITH NO ASSOCIATED CALL SIGN. 3LD IS NOT FOR ATC OPERATIONS. 2020-05-12 2021-05-12
JO 7340.578 20/25 ICAO THREE LETTER DESIGNATOR (3LD) “WMN” AND ASSOCIATED CALL SIGN “WATERMAN” 2020-05-12 2021-05-12
JO 7340.577 20/24 ICAO THREE LETTER DESIGNATOR (3LD) “NFX” AND ASSOCIATED CALL SIGN “SUNSET” 2020-05-12 2021-05-12
JO 7340.576 20/21 ICAO THREE LETTER DESIGNATOR (3LD) “JSP” AND ASSOCIATED CALL SIGN “SPOOLER” 2020-05-06 2021-05-06
JO 7340.575 20/20 ICAO THREE LETTER DESIGNATOR (3LD) “BGE” AND ASSOCIATED CALL SIGN “AEROBRIDGE” 2020-05-04 2021-05-04
JO 7340.573 20/18 ICAO THREE LETTER DESIGNATOR (3LD) “CVD” 2020-04-15 2021-04-15
JO 7340.574 20/19 DELETE U.S. SPECIAL CALL SIGN “MSQT/MESQUITE” 2020-04-14 2021-04-14
JO 7340.571 20/17 COMPANY NAME CHANGE: EXPRESS AIR, INC. (PHOENIX, AZ) 2020-04-15 2021-04-15
JO 7340.572 20/16 ICAO THREE LETTER DESIGNATOR (3LD) “NXT” AND ASSOCIATED CALL SIGN “NEXTNET” 2020-04-15 2021-04-15
JO 7340.570 20/15 DELETE U.S. SPECIAL CALL SIGN “RDDL/RIDDLE” 2020-04-06 2021-04-06
JO 7340.569 20/13 ICAO THREE LETTER DESIGNATOR (3LD) “ERU” AND ASSOCIATED CALL SIGN “RIDDLE” 2020-04-06 2021-04-06
JO 7340.568 20/12 DELETE U.S. SPECIAL CALL SIGN DESIGNATOR “JTBND” AND ASSOCIATED TELEPHONY “JETBOUND” 2020-03-18 2021-03-18
JO 7340.567 20/11 ICAO THREE LETTER DESIGNATOR (3LD) “TRF” AND ASSOCIATED CALL SIGN “THRUST” 2020-03-23 2021-03-23
JO 7340.566 20/10 ICAO THREE LETTER DESIGNATOR (3LD) “MZN” AND ASSOCIATED CALL SIGN “AMAZON” 2020-03-18 2021-03-18
JO 7340.564 20/09 ICAO THREE LETTER DESIGNATOR (3LD) “OME” AND ASSOCIATED CALL SIGN “OMEGA TANKER” 2020-03-09 2021-03-09
JO 7340.565 20/08 ICAO THREE LETTER DESIGNATOR (3LD) “MXY” AND ASSOCIATED CALL SIGN “MOXY” 2020-03-09 2021-03-09
JO 7340.563 20/06 CHANGE TO ICAO THREE LETTER DESIGNATOR (3LD) “IAS” AND ASSOCIATED TELEPHONY “STARFLEET” 2020-01-30 2021-01-30
JO 7340.561 20/04 COMPANY NAME CHANGE FOR ICAO 3LD “FRE” AND ASSOCIATED TELEPHONY “FREEDOM” 2020-01-15 2021-01-15
JO 7340.562 20/05 DELETE U.S. SPECIAL CALL SIGN DESIGNATOR “HORNT” AND ASSOCIATED TELEPHONY “HORNET” 2020-01-15 2021-01-16
JO 7340.559 20/03 ICAO THREE LETTER DESIGNATOR (3LD) “ERR” AND ASSOCIATED CALL SIGN “ERAH” 2020-01-20 2021-01-20
JO 7340.560 20/02 ICAO THREE LETTER DESIGNATOR (3LD) “ERH” AND ASSOCIATED CALL SIGN “ERA HELI” 2020-01-20 2021-01-20
JO 7340.558 20/01 ICAO THREE LETTER DESIGNATOR (3LD) “JCY” AND ASSOCIATED CALL SIGN “JET CITY” 2020-01-13 2021-01-13
JO 7340.557 19/49 ICAO Three Letter Designator (3LD) “JLJ” and Associated Call Sign “HIGHBORN” 2019-12-18 2020-12-18
JO 7340.556 19/48 ICAO Three Letter Designator (3LD) “DOS” and Associated Call Sign “DOSAIR” 2019-12-09 2020-12-09
JO 7340.554 19/46 ICAO Three Letter Designator (3LD) “RKK” and Associated Call Sign “ROCKTOWN” 2019-11-27 2020-11-27
JO 7340.555 19/47 ICAO Three Letter Designator (3LD) “AUU” and Associated Call Sign “ARGO” 2019-11-27 2020-11-27
JO 7340.553 19/45 Company Name Change for - ICAO Three Letter Designator (3LD) “CRE” and Associated Call Sign “CREAM CITY” 2019-11-26 2020-11-26
JO 7340.549 19/42 - ICAO Three Letter Designator (3LD) “STT” and Associated Call Sign “SAWTOOTH” 2019-11-22 2020-11-22
JO 7340.550 19/43 ICAO Three Letter Designator (3LD) “IDD” and Associated Call Sign “IDA 2019-11-22 2020-11-22
JO 7340.551 19/44 ICAO Three Letter Designator (3LD) “PDU” and Associated Call Sign “PURDUE” 2019-11-22 2020-11-22
JO 7340.552 19/41 ICAO Three Letter Designator (3LD) “LVT” and Associated Call Sign “ELEVATE” 2019-11-22 2020-11-22
JO 7340.548 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2019-11-08 2020-11-08
JO 7340.546 19/40 ICAO Three Letter Designator (3LD) “TIV” and Associated Call Sign “THRIVE” 2019-11-13 2020-11-13
JO 7340.547 19/39 ICAO Three Letter Designator (3LD) “LSO” and Associated Call Sign “STARCOM” 2019-11-13 2020-11-13
JO 7340.545 19/38 ICAO Three Letter Designator (3LD) “WVU” and Associated Call Sign “COUNTRY ROADS" 2019-10-30 2020-10-30
JO 7340.544 19/37 CORRECTION TO GENOT 19/36: ICAO THREE LETTER DESIGNATOR (3LD) “ARB” AND ASSOCIATED CALL SIGN “AIRBAHN” 2019-10-23 2020-10-23
JO 7340.542 19/36 ICAO Three Letter Designator (3LD) “ARB” and Associated Call Sign “AIRBAHN” 2019-10-23 2020-10-23
JO 7340.543 19/35 Addition of Three-Letter Designator (3LD)/Telephony “HNW/Honeywell”; and Cancellation Of U.S. Special Call Sign Designator/Telephony “HONW/Honeywell” 2019-10-23 2020-10-23
JO 7340.541 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2019-10-11 2020-10-11
JO 7340.538 19/34 ICAO Three Letter Designator (3LD) “SJA” and Associated Call Sign “SAWYER” 2019-10-09 2020-10-09
JO 7340.539 19/33 ICAO Three Letter Designator (3LD) “QXE” and Associated Call Sign “HORIZON AIR” 2019-10-09 2020-10-09
JO 7340.540 19/32 ICAO Three Letter Designator (3LD) “CON” and Associated Telephony “CONOCO” 2019-10-09 2020-10-09
JO 7340.537 19/31 ICAO Three Letter Designator (3LD) “PHM” and Associated Telephony “PETROLEUM” 2019-10-03 2020-10-03
JO 7340.534 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2019-09-13 2020-09-13
JO 7340.535 19/30 ICAO Three Letter Designator (3LD) “RMA” and Associated Call Sign “ROCKY MOUNTAIN” 2019-09-20 2020-09-20
JO 7340.536 19/29 ICAO Three Letter Designator (3LD) “SCN” and Associated Call Sign “SILICON” 2019-09-20 2020-09-20
JO 7340.533 19/28 ICAO Three Letter Designator (3LD) “XGN” and Associated Call Sign “NEXGEN” 2019-08-14 2020-08-14
JO 7340.532 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2019-08-07 2020-08-07
JO 7340.531 19/27 ICAO THREE LETTER DESIGNATOR (3LD) “MTU” AND ASSOCIATED CALL SIGN “BLUE RAIDER” 2019-08-07 2020-08-07
JO 7340.529 19/23 Company Modification for U.S. Special Call Sign MSQT/MESQUITE 2019-07-03 2020-07-01
JO 7340.527 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2019-06-25 2020-06-25
Cancels
Cancelled documents
Number Title Date
JO 7340.2H Contractions 2018-03-06


Debugging Information
ColdFusion Server Enterprise 2023,0,15,330825
Template /regulations_policies/orders_notices/index.cfm
Time Stamp 18-Dec-25 05:07 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
265 ms 265 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fusebox5.cfm
265 ms 265 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/index.cfm
255 ms 255 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
254 ms 254 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/parsed/document.information.cfm
208 ms 208 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/dspDocumentInformation.cfm
43 ms 43 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
43 ms 43 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
43 ms 43 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChanges(documentID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
43 ms 43 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(cancelledByDocumentID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
43 ms 43 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/layouts/template.cfm
41 ms 41 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
40 ms 40 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChanges(DOCUMENTID = 1036028) ] 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/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getObjects(CHANGENUMBER = 0, DOCUMENTNUMBER = , GETGENOTSONLY = 0, SEARCHCRITERIA = , DIVISIONAREA = , FORMATTEDDOCUMENTTITLE = 0, OBJECTID = 0, SUBJECTCLASS = , CANCELLEDBYDOCUMENTID = 1036028, 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 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
35 ms 35 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getOrdersAndNotices(documentID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
34 ms 34 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
34 ms 34 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
34 ms 34 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getRelatedNotices(parentDocumentID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
29 ms 10 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
22 ms 22 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 = 1036028, GETNATIONALDIRECTIVES = 0, STATUSIDLIST = , SORTORDER = DESC, DOCUMENTIDLIST = , SORTCOLUMN = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
22 ms 22 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getRelatedDirectives(PARENTDOCUMENTID = 1036028, STATUSID = 0, DOCUMENTIDLIST = , RELATIONTYPEID = 3) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
22 ms 22 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
22 ms 22 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDirectiveSupplements(documentID = 1036028) ] 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/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
14 ms 14 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
13 ms 13 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
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getRelatedDrafts(documentID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc | getObjectResources(OBJECTID = 1036028, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
10 ms 10 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getRelatedDrafts(DOCUMENTID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
10 ms 10 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspTemplate.cfm
9 ms 9 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getDirectiveSupplements(DOCUMENTID = 1036028) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
7 ms 7 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.cfm
7 ms 7 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/dspBody.cfm
5 ms 5 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/Application.cfm
4 ms 4 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
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/plugins/actExternalLinks.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 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
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/view/dspFooter.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspHeader.cfm
1 ms 1 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspPageTools.cfm
0 ms 0 ms 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 | 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/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/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
5 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
275 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

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

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

qGetDocumentTypeData (Datasource=developersdb, Time=9ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:07:24.024
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetSupplements (Datasource=developersdb, Time=9ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:07:24.024
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) = 1036028

qGetDocumentTypeData (Datasource=developersdb, Time=9ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:07:24.024
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetObjects (Datasource=developersdb, Time=22ms, Records=73) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:07:24.024
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) = 1036028
Parameter #2(cf_sql_numeric) = 3

Variables.qGetCurrentNotices (Datasource=developersdb, Time=1ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\view\dspDocumentInformation.cfm @ 05:07:24.024
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=73) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\view\dspDocumentInformation.cfm @ 05:07:24.024
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=21ms) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 05:07:23.023

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  1036028    
 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/1036028
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/1036028
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.251
REMOTE_HOST=10.27.195.251
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=289679
CFTOKEN=da7a3b0294d2f1e3-E9490368-CADA-CE25-3075E73E859DEE34
Session Variables:
sessionid=C2AF8C0656C3FCAAD4AABAE852F2C548.www
urltoken=CFID=289679&CFTOKEN=da7a3b0294d2f1e3-E9490368-CADA-CE25-3075E73E859DEE34&jsessionid=C2AF8C0656C3FCAAD4AABAE852F2C548.www
Debug Rendering Time: 29 ms