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

Document Information

Type
Order
Number
JO 7340.2K
Title
Contractions
Date issued
2020-09-09
Date cancelled
2021-12-02
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.671 21/52 ICAO THREE LETTER DESIGNATOR (3LD) “WSP” AND ASSOCIATED CALL SIGN “WHISPER JET” 2021-11-30 2022-11-30
JO 7340.672 21/54 COMPANY NAME CHANGE: CORPORATE AIR TRAVEL, LLC 2021-11-30 2022-11-30
JO 7340.673 21/53 3LD AND CALL SIGN DELETION: PPJ / PREMIER JETS 2021-11-30 2022-11-30
JO 7340.670 Foreign ICAO 3LD Additions, Modifications, and Deletions (excluding U.S.) 2021-11-24 2022-11-24
JO 7340.669 21/51 COMPANY NAME CHANGE: JET TEST AND TRANSPORT, LLC 2021-11-04 2022-11-04
JO 7340.668 Foreign ICAO 3LD Additions and Modifications (excluding U.S.) 2021-10-27 2022-10-27
JO 7340.667 21/50 COMPANY NAME CHANGE: MEDJET INTERNATIONAL, INC. (BIRMINGHAM, AL) 2021-10-22 2022-10-22
JO 7340.666 21/49 ICAO THREE LETTER DESIGNATOR (3LD) “OMD” AND ASSOCIATED CALL SIGN “NOMADIC” 2021-10-06 2022-10-06
JO 7340.665 21/48 COMPANY NAME CHANGE: UNIVERSITY OF ILLINOIS INSTITUTE OF AVIATION (SAVOY, IL) 2021-09-21 2022-09-21
JO 7340.664 21/47 U.S. SPECIAL CALL SIGN DESIGNATOR “SHPRD” AND ASSOCIATED TELEPHONY “SHEPHERD” 2021-09-20 2022-09-20
JO 7340.662 21/46 ICAO THREE LETTER DESIGNATOR (3LD) “DVY” AND ASSOCIATED CALL SIGN “DEVIL RAY” 2021-08-27 2022-08-27
JO 7340.663 21/45 COMPANY NAME CHANGE FOR XOJET, INC. (MCLELLAN, CA) 2021-08-27 2022-08-27
JO 7340.661 21/44 ICAO THREE LETTER DESIGNATOR (3LD) “WVE” AND ASSOCIATED CALL SIGN “CLEAR WAVE” 2021-08-19 2022-08-19
JO 7340.660 Foreign ICAO 3LD Additions and Modifications (excluding U.S.) 2021-08-13 2022-08-13
JO 7340.659 21/43 ICAO THREE LETTER DESIGNATOR (3LD) “NJM” AND ASSOCIATED CALL SIGN “NORTHERN JET” 2021-08-13 2022-08-13
JO 7340.658 21/42 CALL SIGN AND DESIGNATOR CHANGE FOR STEELMAN AVIATION INC 2021-08-12 2022-08-12
JO 7340.657 21/41 U.S. SPECIAL CALL SIGN DESIGNATOR “IWGLD” AND ASSOCIATED TELEPHONY “IOWA GOLD” 2021-08-20 2021-09-17
JO 7340.656 21/40 COMPANY NAME CHANGE FOR “SJN/SAN JUAN” 2021-08-04 2022-08-04
JO 7340.654 21/38 COMPANY NAME CHANGE FOR “MRR/MARINER” 2021-08-02 2022-08-02
JO 7340.655 21/39 ICAO THREE LETTER DESIGNATOR (3LD) “PVA” AND ASSOCIATED CALL SIGN “PRIVATE AIR” 2021-08-02 2022-08-02
JO 7340.651 12/35 ICAO THREE LETTER DESIGNATOR (3LD) “ISH” AND ASSOCIATED CALL SIGN “ISLAND HOP” 2021-07-26 2022-07-26
JO 7340.652 21/37 THREE LETTER DESIGNATOR (3LD) CHANGE FOR “PHA/GRAY BIRD” 2021-07-23 2022-07-23
JO 7340.653 21/34 ICAO THREE LETTER DESIGNATOR (3LD) “SGO” AND ASSOCIATED CALL SIGN “SPEEDGOAT” 2021-07-26 2022-07-26
JO 7340.650 21/36 ICAO THREE LETTER DESIGNATOR (3LD) “HPP” AND ASSOCIATED CALL SIGN “SKY HOP” 2021-07-26 2022-07-26
JO 7340.649 21/33 COMPANY CHANGE FOR ICAO 3LD “WCP” AND ASSOCIATED TELEPHONY “WHITECAP” 2021-07-19 2022-07-19
JO 7340.648 21/32 COMPANY CHANGE FOR ICAO 3LD “SFY” AND ASSOCIATED TELEPHONY “SKY FLITE” 2021-06-28 2022-07-01
JO 7340.646 21/31 ICAO THREE LETTER DESIGNATOR (3LD) “PLZ” AND ASSOCIATED CALL SIGN “PALS HOPE” 2021-06-30 2022-06-30
JO 7340.647 21/30 ICAO THREE LETTER DESIGNATOR (3LD) “GLH” AND ASSOCIATED CALL SIGN “GULFHAWK” 2021-06-30 2022-06-30
JO 7340.645 21/29 ICAO THREE LETTER DESIGNATOR (3LD) “JTZ” AND ASSOCIATED CALL SIGN “STEEL JET” 2021-06-22 2022-06-22
JO 7340.643 Foreign ICAO 3LD Additions and Modifications (excluding U.S.) 2021-06-16 2022-06-16
JO 7340.644 21/28 ICAO THREE LETTER DESIGNATOR (3LD) “HOB” AND ASSOCIATED CALL SIGN “HOBBY JET” 2021-06-21 2022-06-21
JO 7340.642 21/27 ICAO THREE LETTER DESIGNATOR (3LD) “NTW” AND ASSOCIATED CALL SIGN “NORTHWOODS” 2021-06-14 2022-06-14
JO 7340.640 21/25 ICAO THREE LETTER DESIGNATOR (3LD) “BKE” AND ASSOCIATED CALL SIGN “AIR BROCK” 2021-05-21 2022-05-21
JO 7340.641 21/26 ICAO THREE LETTER DESIGNATOR (3LD) “WZM” AND ASSOCIATED CALL SIGN “MATILDA” 2021-05-21 2022-05-21
JO 7340.637 21/23 ICAO THREE LETTER DESIGNATOR (3LD) “MMU” AND ASSOCIATED CALL SIGN “SKY TOUR” 2021-05-17 2022-05-17
JO 7340.638 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2021-05-12 2022-05-12
JO 7340.639 21/24 ICAO THREE LETTER DESIGNATOR (3LD) “JYA" AND ASSOCIATED CALL SIGN “SUN BIZ” 2021-05-17 2022-05-17
JO 7340.636 21/22 ICAO THREE LETTER DESIGNATOR (3LD) “DOS” AND ASSOCIATED TELEPHONY “DOSAIR” 2021-04-29 2022-04-30
JO 7340.635 21/21 ICAO THREE LETTER DESIGNATOR (3LD) “RTY” AND ASSOCIATED CALL SIGN “AIMS COLLEGE” 2021-05-05 2022-05-05
JO 7340.634 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2021-04-28 2022-04-28
JO 7340.633 21/20 COMPANY NAME CHANGE: LINEAR AIR (BEDFORD, MA) 2021-04-22 2022-04-22
JO 7340.632 21/19 CALL SIGN AND 3LD CHANGE FOR COMPANY “THRO AVIATION, INC.” 2021-04-07 2022-04-07
JO 7340.630 21/18 DELETE ICAO THREE LETTER DESIGNATOR (3LD) AND ASSOCIATED CALL SIGN “TXA/OKAY AIR” AND “TXS/TEXAIR”; ADD ICAO 3LD “TXA” AND ASSOCIATED CALL SIGN “TEXAIR” 2021-04-05 2022-04-05
JO 7340.631 21/17 ICAO THREE LETTER DESIGNATOR (3LD) “MAK” AND ASSOCIATED CALL SIGN “MAKLEE” 2021-04-05 2022-04-05
JO 7340.628 21/16 ICAO THREE LETTER DESIGNATOR (3LD) “JIT” AND ASSOCIATED CALL SIGN “JET IT” 2021-03-26 2022-03-26
JO 7340.629 21/15 COMPANY NAME CHANGE: MOUNTAIN CREST FARM, LLC 2021-03-26 2022-03-26
JO 7340.627 21/14 COMPANY NAME CHANGE: VOLO AVIATION, LLC (STRATFORD, CT) 2021-03-22 2022-03-22
JO 7340.626 21/11 ICAO THREE LETTER DESIGNATOR (3LD) “MVK” AND ASSOCIATED CALL SIGN “MINN STATE” 2021-03-04 2022-03-04
JO 7340.624 21/10 ICAO THREE LETTER DESIGNATOR (3LD) “PPJ” AND ASSOCIATED CALL SIGN “PREMIER JETS” 2021-02-24 2022-02-24
JO 7340.625 21/09 CALL SIGN, 3LD, AND COMPANY NAME CHANGE TO ICAO CALL SIGN “CASINO EXPRESS” AND 3LD “CXP” 2021-02-24 2022-02-24
JO 7340.622 21/08 ICAO THREE LETTER DESIGNATOR (3LD) “JLC” AND ASSOCIATED CALL SIGN “ANGELIC” 2021-02-18 2022-02-18
JO 7340.623 21/07 ICAO THREE LETTER DESIGNATOR (3LD) “GZR” AND ASSOCIATED CALL SIGN “GEZIRA” 2021-02-18 2022-02-18
JO 7340.621 Foreign ICAO 3LD Additions, Deletions, and Modifications (excluding U.S.) 2021-02-05 2022-02-05
JO 7340.619 21/06 ICAO THREE LETTER DESIGNATOR (3LD) “VYR” AND ASSOCIATED CALL SIGN “VEYRON” 2021-02-08 2022-02-08
JO 7340.620 21/05 ICAO THREE LETTER DESIGNATOR (3LD) “LLN” AND ASSOCIATED CALL SIGN “ALLEN” 2021-02-08 2022-02-08
JO 7340.618 21/04 CALL SIGN AND COMPANY NAME CHANGE TO ICAO THREE LETTER DESIGNATOR (3LD) “SCA” 2021-02-01 2022-02-01
JO 7340.615 01/01 ICAO THREE LETTER DESIGNATOR (3LD) “KPO” AND ASSOCIATED CALL SIGN “KRYPTO” 2021-01-26 2022-01-26
JO 7340.616 01/02 ICAO THREE LETTER DESIGNATOR (3LD) “SCU” AND ASSOCIATED CALL SIGN “SKELLY” 2021-01-26 2022-01-26
JO 7340.617 01/03 ICAO THREE LETTER DESIGNATOR (3LD) “UWD” AND ASSOCIATED CALL SIGN “UPWARD” 2021-01-26 2022-01-26
JO 7340.614 20/60 ICAO THREE LETTER DESIGNATOR (3LD) “BLK” AND ASSOCIATED CALL SIGN “AERO BLACK” 2021-01-05 2022-01-05
JO 7340.613 20/59 3LD AND COMPANY NAME CHANGE TO ICAO CALL SIGN “GEMINI” 2020-12-24 2021-12-24
JO 7340.612 20/58 ICAO THREE LETTER DESIGNATOR (3LD) “LEX” AND ASSOCIATED CALL SIGN “LEXAIR” 2020-12-15 2021-12-15
JO 7340.611 20/57 ICAO THREE LETTER DESIGNATOR (3LD) “XSL” AND ASSOCIATED CALL SIGN “SATSLAB” 2020-12-01 2021-12-01
JO 7340.609 20/56 COMPANY NAME CHANGE: WESTERN GLOBAL AIRLINES, LLC 2020-11-20 2021-11-20
JO 7340.610 20/55 ICAO THREE LETTER DESIGNATOR (3LD) “FPC” AND ASSOCIATED CALL SIGN “PRO CONNECT” 2020-11-20 2021-11-20
JO 7340.607 20/53 ICAO THREE LETTER DESIGNATOR (3LD) “LGF” AND ASSOCIATED CALL SIGN “LEGACY FREIGHT” 2020-11-16 2021-11-16
JO 7340.608 20/54 ICAO THREE LETTER DESIGNATOR (3LD) “WMU” AND ASSOCIATED CALL SIGN “SKYBRONCO” 2020-11-16 2021-11-16
JO 7340.606 20/52 ICAO THREE LETTER DESIGNATOR (3LD) “TAG” AND ASSOCIATED CALL SIGN “TAG U-S” 2020-11-11 2021-11-11
JO 7340.605 20/51 ADD ICAO THREE LETTER DESIGNATOR (3LD) “EPI” AND ASSOCIATED CALL SIGN “EPIC RED”; AND DELETE U.S. SPECIAL CALL SIGN DESIGNATOR/TELEPHONY “EPIA/EPIC AIR” 2020-10-12 2021-10-12
JO 7340.603 20/50 ICAO THREE LETTER DESIGNATOR (3LD) “WDE” AND ASSOCIATED CALL SIGN “SANDSTONE” 2020-10-07 2021-10-07
JO 7340.604 20/49 ICAO THREE LETTER DESIGNATOR (3LD) “CPS” ANDASSOCIATED CALL SIGN “SWIFT BIRD” 2020-10-07 2021-10-07
JO 7340.602 20/48 COMPANY NAME CHANGE: TRANS-PACIFIC AIR CHARTER, LLC 2020-09-30 2021-09-30
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.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.586 20/33 ICAO THREE LETTER DESIGNATOR (3LD) “FTK” AND ASSOCIATED TELEPHONY “(FIRETAC)” 2020-06-14 2021-06-14
Cancels
Cancelled documents
Number Title Date
JO 7340.2J Contractions 2019-06-03


Debugging Information
ColdFusion Server Enterprise 2023,0,15,330825
Template /regulations_policies/orders_notices/index.cfm
Time Stamp 17-Dec-25 08:37 PM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.27.195.250
Host Name 10.27.195.250


Execution Time

Total Time Avg Time Count Template
297 ms 297 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/fusebox/fusebox5.cfm
297 ms 297 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/index.cfm
288 ms 288 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
286 ms 286 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/parsed/document.information.cfm
252 ms 252 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/dspDocumentInformation.cfm
52 ms 52 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(cancelledByDocumentID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
51 ms 51 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
51 ms 51 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
51 ms 51 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentChanges(documentID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
49 ms 49 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getDocumentChanges(DOCUMENTID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
49 ms 49 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 = 1038014, 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
44 ms 44 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
44 ms 44 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getRelatedNotices(parentDocumentID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
42 ms 42 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getOrdersAndNotices(documentID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
41 ms 41 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/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
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
30 ms 30 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/regulations_policies/orders_notices/view/layouts/template.cfm
29 ms 29 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getRelatedDirectives(PARENTDOCUMENTID = 1038014, STATUSID = 0, DOCUMENTIDLIST = , RELATIONTYPEID = 3) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
28 ms 28 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
27 ms 27 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
27 ms 27 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDirectiveSupplements(documentID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
27 ms 27 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
25 ms 25 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 = 1038014, GETNATIONALDIRECTIVES = 0, STATUSIDLIST = , SORTORDER = DESC, DOCUMENTIDLIST = , SORTCOLUMN = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
16 ms 16 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocumentResources(documentID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/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
15 ms 15 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
15 ms 15 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getRelatedDrafts(documentID = 1038014) ] 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/resourceGateway.cfc | getObjectResources(OBJECTID = 1038014, OBJECTTYPE = document) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/resourceGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc | getDirectiveSupplements(DOCUMENTID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/directiveGateway.cfc
13 ms 13 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | getRelatedDrafts(DOCUMENTID = 1038014) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
7 ms 7 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actMenu.cfm
7 ms 7 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspTemplate.cfm
6 ms 6 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actLastUpdated.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/templates/6/view/dspBody.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/applicationCode.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
2 ms 2 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
2 ms 2 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 | expandFuseboxPath(parsed/) ] 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/view/dspHeader.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 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/actCheckLegacyMode.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/model/actParamVars.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actChatbot.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actEnableColumns.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/menu/actBuildMenu.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_footer.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_head.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspDrupal_cms_header.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspFooter.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspPageTools.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfAssetQueryString.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfDetectTier.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfDocumentViewer.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfEmailForm.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfExpressionManager.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfImageFormat.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfPageRedirect.cfm
0 ms 0 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfUriManager.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
305 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

20:37:02.002 - 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 @ 20:37:02.002
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qryGetObjects (Datasource=developersdb, Time=13ms, Records=5) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\resourceGateway.cfc @ 20:37:02.002
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 = 1038014 
				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 @ 20:37:02.002
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=13ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 20:37:02.002
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 = 1038014 
							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 @ 20:37:02.002
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) = 1038014

qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 20:37:02.002
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetObjects (Datasource=developersdb, Time=25ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 20:37:02.002
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 = 1038014 
							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 @ 20:37:03.003
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) = 1038014
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 @ 20:37:03.003
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetSupplements (Datasource=developersdb, Time=12ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 20:37:03.003
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) = 1038014

qGetDocumentTypeData (Datasource=developersdb, Time=12ms, Records=10) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 20:37:03.003
SELECT
				documentTypeID,
				documentType
			FROM
				dlDocumentType
qGetObjects (Datasource=developersdb, Time=29ms, Records=76) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 20:37:03.003
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) = 1038014
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 @ 20:37:03.003
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=76) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\regulations_policies\orders_notices\view\dspDocumentInformation.cfm @ 20:37:03.003
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=25ms) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\directiveGateway.cfc @ 20:37:02.002

    
parameters
typeCFSQLTypevaluevariabledbVarName
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_varchar  NULL    
 IN  cf_sql_numeric  1038014    
 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/1038014
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/1038014
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.250
REMOTE_HOST=10.27.195.250
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=204815
CFTOKEN=c2759321ea28562e-D708AE46-A3E4-8890-60E024BD3B5414B2
Session Variables:
sessionid=604AC016CAF46414F6E51868F5A3872B.www
urltoken=CFID=204815&CFTOKEN=c2759321ea28562e-D708AE46-A3E4-8890-60E024BD3B5414B2&jsessionid=604AC016CAF46414F6E51868F5A3872B.www
Debug Rendering Time: 24 ms