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

Federal Aviation Administration

News Stories

Recent Regulations and Guidelines

Look Up N-Numbers

N-Number format

An N-Number can be in any of these formats

  • One to five digits (N12345)
  • One to four digits followed by one letter (N1234Z)
  • One to three digits followed by two letters (N123AZ)

N-Numbers do not have

  • A zero (0) as the first digit
  • The letters I or O

COVID-19 Response

Drones/​Unmanned Aircraft Systems (UAS)

Airport Status and Delays

  • Airport Closures are unavailable.
  • Ground Stoppages are unavailable.
  • Ground Delays are unavailable.
  • Arrivals/Departures are unavailable.

There are no ground delays at this time.

There are no airport closures at this time.

There are no airport ground stoppages at this time.

There are no arrival/departure delays at this time.

All flight delay information

Featured Topics and Events


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


Execution Time

Total Time Avg Time Count Template
860 ms 860 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/index.cfm
830 ms 830 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/view/dspIndex.cfm
491 ms 123 ms 4 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
282 ms 282 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/4/plugins/social/twitter/dspFeed.cfm
261 ms 261 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/TwitterService.cfc | getPosts(user = faanews) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/TwitterService.cfc
261 ms 261 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/monkehTweet.cfc | getUserTimeline(count = 15, screen_name = faanews) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/monkehTweet.cfc
259 ms 259 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/view/dspRGOrdersNotices.cfm
135 ms 135 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(statusIDList = 2, sortOrder = desc, versionTypeID = 2, maxRows = 3, documentTypeID = 2, sortColumn = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
134 ms 134 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 = 0, SORTORDER = desc, RESTRICTIONCODEID = 0, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = dateIssued, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 2, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = 2, VERSIONTYPEID = 2, ALPHASUFFIX = , MAXROWS = 3, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
134 ms 134 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(statusIDList = 2, sortOrder = desc, maxRows = 5, documentTypeID = 1, restrictionCodeID = 3, sortColumn = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
134 ms 134 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/view/dspRGForms.cfm
132 ms 132 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 = 0, SORTORDER = desc, RESTRICTIONCODEID = 3, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = dateIssued, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 1, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = 2, VERSIONTYPEID = 0, ALPHASUFFIX = , MAXROWS = 5, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
123 ms 123 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(statusIDList = 2, sortOrder = desc, versionTypeID = 2, maxRows = 3, documentTypeID = 3, sortColumn = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
120 ms 120 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 = 0, SORTORDER = desc, RESTRICTIONCODEID = 0, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = dateIssued, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 3, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = 2, VERSIONTYPEID = 2, ALPHASUFFIX = , MAXROWS = 3, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
99 ms 99 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc | getDocuments(statusIDList = 2, sortOrder = desc, versionTypeID = 2, maxRows = 5, documentTypeID = 5, sortColumn = dateIssued) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/documentLibrary/model/documentLibrary.cfc
99 ms 99 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/view/dspRGACs.cfm
98 ms 98 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 = 0, SORTORDER = desc, RESTRICTIONCODEID = 0, DOCUMENT = , OFFICENUMBER = , STARTROW = 0, GETCOUNTONLY = false, OFFICEID = 0, SORTCOLUMN = dateIssued, SEQUENCENUMBER = 0, DOCUMENTTYPEID = 5, DOCUMENTTYPEIDLIST = , SUBJECTCLASSPREFIX = , STATUSIDLIST = 2, VERSIONTYPEID = 2, ALPHASUFFIX = , MAXROWS = 5, SIGNIFICANTDOCUMENTSONLY = 0, ENDROW = 0, DOCUMENTIDLIST = ) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
25 ms 25 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/template.cfm
24 ms 24 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/template.cfm
21 ms 21 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/view/dspStatusDelays.cfm
20 ms 20 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/delays/index.cfm
19 ms 19 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/AirportService.cfc | getAirportDelays() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/AirportService.cfc
12 ms 12 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | signRequest(oConsumer = CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthconsumer, oToken = CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthtoken, oSignatureMethod = CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthsignaturemethod_hmac_sha1) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
11 ms 11 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthsignaturemethod_hmac_sha1.cfc | buildSignature(CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthrequest, CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthconsumer, CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthtoken) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthsignaturemethod_hmac_sha1.cfc
10 ms 10 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/TwitterService.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/TwitterService.cfc
7 ms 7 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | getSignableParameters() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
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 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/monkehTweet.cfc | init(consumerKey = z5oXzrBZOLvckMCZ6zaV9ZOdg, parseResults = true, consumerSecret = 4WqDemEhDPYgjhUcbgQ74gCAgc0mdGzhSN6Hb6yGR9iNG1SDAv, userAccountName = faanews, oauthToken = 160946337-04T4mR38nXKIWbcibHsxSQ42qEUa6uKZ87qIn0Pu, oauthTokenSecret = alDbShqv3iLb1zETGkeg25eUpqQ1gs29BTChaZZGeoh9q) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/monkehTweet.cfc
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 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | toURL() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
5 ms 5 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspTemplate.cfm
4 ms 4 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | toHeader() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
4 ms 4 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/Application.cfm
3 ms 3 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | fromConsumerAndToken(oConsumer = CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthconsumer, oToken = CFC: FAAEmployees.social.components.coldfumonkeh.oauth.oauthtoken, sHttpURL = https://api.twitter.com/1.1/statuses/user_timeline.json, sHttpMethod = GET, stParameters = [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/applicationCode.cfm
3 ms 3 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/plugins/actExternalLinks.cfm
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/4/plugins/social/actCacheFeed.cfm
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/templates/6/view/dspBody.cfm
2 ms 2 ms 1 //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/udf/udfGlobal.cfm
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | init(sHttpURL = https://api.twitter.com/1.1/statuses/user_timeline.json, sHttpMethod = GET, stParameters = [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc | CLEARKEY(socialMedia_twitter_FAANews) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc | CLEARKEY(socialMedia_twitter_FAASafetyBrief) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc | lookup(socialMedia_twitter_FAANews) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc | set(socialMedia_twitter_FAANews, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | clear(socialmedia_twitter_faanews) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | set(socialmedia_twitter_faanews, [complex value], 10, 30) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
1 ms 1 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/DocumentAdService.cfc | searchDocuments(argumentCollection = [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/DocumentAdService.cfc
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/view/dspRGADs.cfm
0 ms 0 ms 4 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/documentLibrary/model/dao/documentGateway.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc | getConsumerKey() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc | getConsumerSecret() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc | getOAuthToken() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc | getOAuthTokenSecret() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc | init(argumentCollection = [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/authDetails.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthconsumer.cfc | getKey() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthconsumer.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthconsumer.cfc | getSecret() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthconsumer.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthconsumer.cfc | init(sSecret = 4WqDemEhDPYgjhUcbgQ74gCAgc0mdGzhSN6Hb6yGR9iNG1SDAv, sKey = z5oXzrBZOLvckMCZ6zaV9ZOdg) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthconsumer.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | getNormalizedHttpMethod() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc | getNormalizedHttpURL() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthrequest.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthsignaturemethod_hmac_sha1.cfc | getName() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthsignaturemethod_hmac_sha1.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc | getKey() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc | getSecret() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc | init(sSecret = alDbShqv3iLb1zETGkeg25eUpqQ1gs29BTChaZZGeoh9q, sKey = 160946337-04T4mR38nXKIWbcibHsxSQ42qEUa6uKZ87qIn0Pu) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc | isEmpty() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthtoken.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(1.0) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(15) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(160946337-04T4mR38nXKIWbcibHsxSQ42qEUa6uKZ87qIn0Pu) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(1766036443) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(4WqDemEhDPYgjhUcbgQ74gCAgc0mdGzhSN6Hb6yGR9iNG1SDAv) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(EBF9DF3B252C5C6B618CC6EC08C8DA33E51AE4DE) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(GET) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(HMAC-SHA1) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(alDbShqv3iLb1zETGkeg25eUpqQ1gs29BTChaZZGeoh9q) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(bEzHrmvgaXOHAfKWiV2BdCYLDJ0=) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(checkheader) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(checkheader=false&count=15&oauth_consumer_key=z5oXzrBZOLvckMCZ6zaV9ZOdg&oauth_nonce=EBF9DF3B252C5C6B618CC6EC08C8DA33E51AE4DE&oauth_signature_method=HMAC-SHA1&oauth_timestamp=1766036443&oauth_token=160946337-04T4mR38nXKIWbcibHsxSQ42qEUa6uKZ87qIn0Pu&oauth_version=1.0&screen_name=faanews) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(count) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(faanews) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(false) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(https://api.twitter.com/1.1/statuses/user_timeline.json) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_consumer_key) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_nonce) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_signature) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_signature_method) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_timestamp) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_token) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(oauth_version) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 2 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(screen_name) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 3 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | encodePercent(z5oXzrBZOLvckMCZ6zaV9ZOdg) ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 4 CFC[ //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc | init() ] from //webops-fsx-prod.faa.gov/share/external/chh/employees/social/components/coldfumonkeh/oauth/oauthutil.cfc
0 ms 0 ms 5 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/CacheFactory.cfc | getDefaultCache() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/CacheFactory.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc | CLEARKEY(socialMedia_youtube) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/providers/CacheBoxColdBoxProvider.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | clear(socialmedia_twitter_faasafetybrief) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | clear(socialmedia_youtube) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | get(socialmedia_twitter_faanews) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | getSize() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc | lookup(socialmedia_twitter_faanews) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/ConcurrentStore.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/indexers/MetadataIndexer.cfc | clear(socialmedia_twitter_faanews) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/indexers/MetadataIndexer.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/indexers/MetadataIndexer.cfc | setObjectMetadata(socialmedia_twitter_faanews, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/store/indexers/MetadataIndexer.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/util/CacheStats.cfc | miss() ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/cache/util/CacheStats.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/core/events/EventPoolManager.cfc | processState(afterCacheElementInsert, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/core/events/EventPoolManager.cfc
0 ms 0 ms 1 CFC[ //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/core/events/EventPoolManager.cfc | processState(afterCacheElementRemoved, [complex value]) ] from //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/cachebox/system/core/events/EventPoolManager.cfc
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/actTopTasks.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/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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
865 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

00:40:43.043 - Application Exception - in //webops-fsx-prod.faa.gov/share/external/www.faa.gov/Webcont/services/AirportService.cfc : line 26
	    JSON parsing failure at character 1:'C' in Connection Failure
	    


SQL Queries

Variables.qHomeNews (Datasource=developersdb, Time=0ms, Records=5) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\view\dspIndex.cfm @ 00:40:42.042
SELECT   *
			FROM     qHomeNews
			ORDER BY publishDate desc
qGetColumns (Datasource=developersdb, Time=24ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:42.042
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetDocumentType (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:42.042
SELECT
					documentTable
				FROM
					dlDocumentType
				WHERE
					documentTypeID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 5

qGetColumns (Datasource=developersdb, Time=11ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:42.042
SELECT
						*
					FROM
						dlAdvisoryCircular
					WHERE
						1 = 0
qGetObjects (Datasource=developersdb, Time=49ms, Records=5) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:42.042
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
				
						, docTypeMetadata.ADVISORYCIRCULARID 
						, docTypeMetadata.OPR 
						, docTypeMetadata.RELATEDREGULATIONS 
						, docTypeMetadata.SECTIONNUMBERS 

			FROM
				dlDocument docs

			
				INNER JOIN
					dlAdvisoryCircular docTypeMetadata
				ON
					docs.documentID = docTypeMetadata.documentID
			

			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.documentTypeID = 5 
				AND docs.statusID IN (2)
			
				AND docs.versionTypeID = 2 
							ORDER BY docs.dateIssued desc, docs.subjectClass desc, docs.sequenceNumber desc, docs.alphaSuffix desc, docs.divisionArea desc
Local.searchDocuments (Datasource=document_library, Time=0ms, Records=5, Cached Query) in \\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\services\DocumentAdService.cfc @ 00:40:43.043
SELECT
					documentNumber,publishdate,issueDate,id,title,uri,subject 
				FROM	(
					SELECT
						documentNumber,publishdate,issueDate,id,title,uri,subject,
						
							requiredId,
						
						row_number()
						
							OVER (ORDER BY PUBLISHDATE desc, title)
						
						AS rnum
					FROM (
						SELECT
							
							
								DISTINCT
							documentNumber,adPublishDate AS PUBLISHDATE,adIssueDate AS ISSUEDATE,rglAdId AS ID,title,documentUrl AS URI,subject 
								, d.rglAdId AS requiredId
							
			FROM		adRgl d
			WHERE		1 = 1
			
				AND		d.adIssueDate >= (sysdate - 2000)
			
				AND		d.adPublishDate >= (sysdate - 2000)
			
					AND	d.canceled = 0
				
					)
				)
				
				
				WHERE		rnum BETWEEN ?
							AND	? 
					ORDER BY	PUBLISHDATE desc, title
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1
Parameter #2(cf_sql_integer) = 5

qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetDocumentType (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
					documentTable
				FROM
					dlDocumentType
				WHERE
					documentTypeID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 1

qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
						*
					FROM
						dlForm
					WHERE
						1 = 0
qGetObjects (Datasource=developersdb, Time=73ms, Records=5) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
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
				
						, docTypeMetadata.CITYSTATEZIP 
						, docTypeMetadata.CONTINUANCE 
						, docTypeMetadata.COUNT 
						, docTypeMetadata.C_C_DATE 
						, docTypeMetadata.DATEEDITION 
						, docTypeMetadata.DATEEDITIONOLD 
						, docTypeMetadata.EMAIL 
						, docTypeMetadata.EXCELURL 
						, docTypeMetadata.FAX 
						, docTypeMetadata.FEDSTYPEID 
						, docTypeMetadata.FORMCATEGORY 
						, docTypeMetadata.FORMCOMMENTS 
						, docTypeMetadata.FORMFLOWURL 
						, docTypeMetadata.FORMID 
						, docTypeMetadata.FORMTYPE 
						, docTypeMetadata.FORMTYPEID 
						, docTypeMetadata.ISCANCELLED 
						, docTypeMetadata.ISEXCEL 
						, docTypeMetadata.ISFORMFLOW 
						, docTypeMetadata.ISLANDSCAPE 
						, docTypeMetadata.ISOMNI 
						, docTypeMetadata.ISOTHER 
						, docTypeMetadata.ISPDF 
						, docTypeMetadata.ISPICTURE 
						, docTypeMetadata.ISWORD 
						, docTypeMetadata.KEYWORDS 
						, docTypeMetadata.LASTEDITBY 
						, docTypeMetadata.LASTEDITDATE 
						, docTypeMetadata.MAILINGADDRESS1 
						, docTypeMetadata.MAILINGADDRESS2 
						, docTypeMetadata.MAILINGADDRESS3 
						, docTypeMetadata.OLDFORMID 
						, docTypeMetadata.OMNIURL 
						, docTypeMetadata.OPR 
						, docTypeMetadata.OTHERURL 
						, docTypeMetadata.OVERPRINTNUMBER 
						, docTypeMetadata.PDFURL 
						, docTypeMetadata.PICTUREURL 
						, docTypeMetadata.PRESCRIBINGDOCUMENTID 
						, docTypeMetadata.REPLACEDBY 
						, docTypeMetadata.REPLACES 
						, docTypeMetadata.STOCKPOINT 
						, docTypeMetadata.UNITOFISSUE 
						, docTypeMetadata.URL 
						, docTypeMetadata.USERCOMMENTS 
						, docTypeMetadata.WORDURL 

			FROM
				dlDocument docs

			
				INNER JOIN
					dlForm docTypeMetadata
				ON
					docs.documentID = docTypeMetadata.documentID
			

			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.documentTypeID = 1 
				AND docs.statusID IN (2)
			
				AND docs.restrictionCodeID = 3 
							ORDER BY docs.dateIssued desc, docs.subjectClass desc, docs.sequenceNumber desc, docs.alphaSuffix desc, docs.divisionArea desc
qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetDocumentType (Datasource=developersdb, Time=11ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
					documentTable
				FROM
					dlDocumentType
				WHERE
					documentTypeID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 2

qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
						*
					FROM
						dlDirective
					WHERE
						1 = 0
qGetObjects (Datasource=developersdb, Time=75ms, Records=3) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
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
				
						, docTypeMetadata.ACTION 
						, docTypeMetadata.AMENDMENTNUMBER 
						, docTypeMetadata.CANCELLEDBY 
						, docTypeMetadata.CONTACTADDRESS1 
						, docTypeMetadata.CONTACTADDRESS2 
						, docTypeMetadata.CONTACTCITY 
						, docTypeMetadata.CONTACTFAX 
						, docTypeMetadata.CONTACTSTATE 
						, docTypeMetadata.CONTACTZIP 
						, docTypeMetadata.DIRECTIVEID 
						, docTypeMetadata.DISPLAYDOCUMENTPARTS 
						, docTypeMetadata.DOCUMENTSUMMARY 
						, docTypeMetadata.DOCUMENTURL 
						, docTypeMetadata.EFFECTIVEDATE 
						, docTypeMetadata.ENTEREDBY 
						, docTypeMetadata.FEDERALREGISTERPUBLICATIONDATE 
						, docTypeMetadata.GENOTID 
						, docTypeMetadata.HQDISTE 
						, docTypeMetadata.HQDISTW 
						, docTypeMetadata.HQDISTX 
						, docTypeMetadata.HQDISTY 
						, docTypeMetadata.HQDISTZ 
						, docTypeMetadata.INSTRUCTIONS 
						, docTypeMetadata.ISCANCELLED 
						, docTypeMetadata.ISGENOT 
						, docTypeMetadata.ISINTERNAL 
						, docTypeMetadata.ISNATIONALDIRECTIVE 
						, docTypeMetadata.ISPUBLISHED 
						, docTypeMetadata.ISSUEDATE 
						, docTypeMetadata.OLDREGIONID 
						, docTypeMetadata.OMBCONTROLNUMBER 
						, docTypeMetadata.OPR 
						, docTypeMetadata.ORDERSKEY 
						, docTypeMetadata.OTHERDIST 
						, docTypeMetadata.REGIONID 
						, docTypeMetadata.RELATEDORDERID 
						, docTypeMetadata.REVALDATE 
						, docTypeMetadata.SIGNEDBY 
						, docTypeMetadata.UPDATEDBY 
						, docTypeMetadata.ZLIST1 
						, docTypeMetadata.ZLIST2 
						, docTypeMetadata.ZLIST3 

			FROM
				dlDocument docs

			
				INNER JOIN
					dlDirective docTypeMetadata
				ON
					docs.documentID = docTypeMetadata.documentID
			

			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.documentTypeID = 2 
				AND docs.statusID IN (2)
			
				AND docs.versionTypeID = 2 
							ORDER BY docs.dateIssued desc, docs.subjectClass desc, docs.sequenceNumber desc, docs.alphaSuffix desc, docs.divisionArea desc
qGetColumns (Datasource=developersdb, Time=22ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
				*
			FROM
				dlDocument
			WHERE
				1 = 0
qGetDocumentType (Datasource=developersdb, Time=12ms, Records=1) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
					documentTable
				FROM
					dlDocumentType
				WHERE
					documentTypeID = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 3

qGetColumns (Datasource=developersdb, Time=23ms, Records=0) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
SELECT
						*
					FROM
						dlDirective
					WHERE
						1 = 0
qGetObjects (Datasource=developersdb, Time=62ms, Records=3) in \\webops-fsx-prod.faa.gov\share\external\chh\employees\documentLibrary\model\dao\documentGateway.cfc @ 00:40:43.043
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
				
						, docTypeMetadata.ACTION 
						, docTypeMetadata.AMENDMENTNUMBER 
						, docTypeMetadata.CANCELLEDBY 
						, docTypeMetadata.CONTACTADDRESS1 
						, docTypeMetadata.CONTACTADDRESS2 
						, docTypeMetadata.CONTACTCITY 
						, docTypeMetadata.CONTACTFAX 
						, docTypeMetadata.CONTACTSTATE 
						, docTypeMetadata.CONTACTZIP 
						, docTypeMetadata.DIRECTIVEID 
						, docTypeMetadata.DISPLAYDOCUMENTPARTS 
						, docTypeMetadata.DOCUMENTSUMMARY 
						, docTypeMetadata.DOCUMENTURL 
						, docTypeMetadata.EFFECTIVEDATE 
						, docTypeMetadata.ENTEREDBY 
						, docTypeMetadata.FEDERALREGISTERPUBLICATIONDATE 
						, docTypeMetadata.GENOTID 
						, docTypeMetadata.HQDISTE 
						, docTypeMetadata.HQDISTW 
						, docTypeMetadata.HQDISTX 
						, docTypeMetadata.HQDISTY 
						, docTypeMetadata.HQDISTZ 
						, docTypeMetadata.INSTRUCTIONS 
						, docTypeMetadata.ISCANCELLED 
						, docTypeMetadata.ISGENOT 
						, docTypeMetadata.ISINTERNAL 
						, docTypeMetadata.ISNATIONALDIRECTIVE 
						, docTypeMetadata.ISPUBLISHED 
						, docTypeMetadata.ISSUEDATE 
						, docTypeMetadata.OLDREGIONID 
						, docTypeMetadata.OMBCONTROLNUMBER 
						, docTypeMetadata.OPR 
						, docTypeMetadata.ORDERSKEY 
						, docTypeMetadata.OTHERDIST 
						, docTypeMetadata.REGIONID 
						, docTypeMetadata.RELATEDORDERID 
						, docTypeMetadata.REVALDATE 
						, docTypeMetadata.SIGNEDBY 
						, docTypeMetadata.UPDATEDBY 
						, docTypeMetadata.ZLIST1 
						, docTypeMetadata.ZLIST2 
						, docTypeMetadata.ZLIST3 

			FROM
				dlDocument docs

			
				INNER JOIN
					dlDirective docTypeMetadata
				ON
					docs.documentID = docTypeMetadata.documentID
			

			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.documentTypeID = 3 
				AND docs.statusID IN (2)
			
				AND docs.versionTypeID = 2 
							ORDER BY docs.dateIssued desc, docs.subjectClass desc, docs.sequenceNumber desc, docs.alphaSuffix desc, docs.divisionArea desc


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\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=AkamaiEdge=true; AWSALBTG=zw8W+Gv0djYidfICgIjroi94pXM3w1zQphknNCLaKSO9evRhs3a9EjXxA6Gg23UN5zwbGobpKFGF2jrgHHcKqMIUAOPhbNz+tBUS344PqFiWmk2k332/l/OkLGaqjrb5ztEqrszbNLT5ktzoAXdEyBA7F/8qhHq4FKcfjc/0apS4; JSESSIONID=B02DA1722FD9E7F55E6E41380FF6BF37.www; AWSALBTGCORS=zw8W+Gv0djYidfICgIjroi94pXM3w1zQphknNCLaKSO9evRhs3a9EjXxA6Gg23UN5zwbGobpKFGF2jrgHHcKqMIUAOPhbNz+tBUS344PqFiWmk2k332/l/OkLGaqjrb5ztEqrszbNLT5ktzoAXdEyBA7F/8qhHq4FKcfjc/0apS4; AWSALBCORS=aV1G+oWXeJsTbbejNJMmory+PDTnB6ZiCEuBOpWzw+ejuv+e/4dCh+ej1qyUekZ1waUuxpxnGk0u1UpuqguNlivX6CmP9RcT9aZLM2fRw+l6FDtzPFUxWrtdId0O; AWSALB=aV1G+oWXeJsTbbejNJMmory+PDTnB6ZiCEuBOpWzw+ejuv+e/4dCh+ej1qyUekZ1waUuxpxnGk0u1UpuqguNlivX6CmP9RcT9aZLM2fRw+l6FDtzPFUxWrtdId0O
HTTP_HOST=www.faa.gov
HTTP_REFERER=http://www.faa.gov/index.cfm/apa/1462
HTTP_URL=/index.cfm/apa/1462
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=/apa/1462
PATH_TRANSLATED=\\webops-fsx-prod.faa.gov\share\external\www.faa.gov\Webcont\index.cfm
QUERY_STRING=
REMOTE_ADDR=10.27.195.236
REMOTE_HOST=10.27.195.236
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/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:
AWSALB=aV1G oWXeJsTbbejNJMmory PDTnB6ZiCEuBOpWzw ejuv e/4dCh ej1qyUekZ1waUuxpxnGk0u1UpuqguNlivX6CmP9RcT9aZLM2fRw l6FDtzPFUxWrtdId0O
AWSALBCORS=aV1G oWXeJsTbbejNJMmory PDTnB6ZiCEuBOpWzw ejuv e/4dCh ej1qyUekZ1waUuxpxnGk0u1UpuqguNlivX6CmP9RcT9aZLM2fRw l6FDtzPFUxWrtdId0O
AWSALBTG=zw8W Gv0djYidfICgIjroi94pXM3w1zQphknNCLaKSO9evRhs3a9EjXxA6Gg23UN5zwbGobpKFGF2jrgHHcKqMIUAOPhbNz tBUS344PqFiWmk2k332/l/OkLGaqjrb5ztEqrszbNLT5ktzoAXdEyBA7F/8qhHq4FKcfjc/0apS4
AWSALBTGCORS=zw8W Gv0djYidfICgIjroi94pXM3w1zQphknNCLaKSO9evRhs3a9EjXxA6Gg23UN5zwbGobpKFGF2jrgHHcKqMIUAOPhbNz tBUS344PqFiWmk2k332/l/OkLGaqjrb5ztEqrszbNLT5ktzoAXdEyBA7F/8qhHq4FKcfjc/0apS4
AkamaiEdge=true
CFID=249382
CFTOKEN=1c35585e3e65cfb6-DFBF772F-DDE2-3EAE-B99B6F81E464DB46
JSESSIONID=B02DA1722FD9E7F55E6E41380FF6BF37.www
Session Variables:
cbox_flash_scope=Struct (1)
cbstorage=Struct (3)
sessionid=B02DA1722FD9E7F55E6E41380FF6BF37.www
urltoken=CFID=249382&CFTOKEN=1c35585e3e65cfb6-DFBF772F-DDE2-3EAE-B99B6F81E464DB46&jsessionid=B02DA1722FD9E7F55E6E41380FF6BF37.www
Debug Rendering Time: 27 ms