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.

Site Notification

Site Notification

United States Department of TransportationUnited States Department of Transportation

IFP Information Gateway Search Results

We were unable to render the report. Please limit your request to no more than 2,000 records to export.

For specific questions/comments about airports and/or procedures, please use the "E-Mail FAA" links next to the appropriate Procedure(s). For general questions/comments, please submit an .

Page last modified:

 ColdBox Debugging Information
   

Framework Info:
ColdBox SEEK 3.8.1.00076 1 John 5:12-13
Application Name:
AeroNav Information Gateway (environment=production)
TimeStamp:
Dec-337-2023 12:45:05 AM
Server Instance:
IP-0A1BE514
Current Event:
procedure.exportResults
Current Layout:
layout.main.cfm (Module: )
Current View:
procedure/noReport
Current Route:
N/A
Routed URL:
N/A
Routed Namespace:
N/A
LogBox Appenders:
DBAPPENDER
RootLogger Levels:
FATAL - WARN
Loaded Modules:
Timestamp Execution Time Framework Method
12:45:02.816 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
12:45:02.816 AM 0 ms invoking runEvent [Lifecycle.onRequestStart]
12:45:05.112 AM 2285 ms invoking runEvent [procedure.results]
12:45:05.112 AM 2285 ms invoking runEvent [procedure.exportResults]
12:45:05.175 AM 0 ms rendering View [procedure/noReport.cfm]
12:45:05.206 AM 62 ms rendering Layout [layout.main.cfm]
12:45:05.206 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 2390 ms
 CacheBox Monitor
Refresh Monitor: Loading...
CacheBox ID
241299065
Configured Caches
TEMPLATE,default
Scope Registration
{SCOPE={server},ENABLED={false},KEY={cachebox}}

Performance Report For Cache Loading...

Cache Name
default [class=coldbox.system.cache.providers.CacheBoxColdBoxProvider]
Performance
Hit Ratio: 99.35% ==> Hits: 64732 | Misses: 425 | Evictions: 0 | Garbage Collections: 0 | Object Count: 10
JVM Memory Stats
36.99 % Free | Max: 2,796,544 KB Total: 2,505,728 KB | Free: 1,034,387 KB
Last Reap
Dec-337-2023 12:44:37 AM

Cache Configuration

Cache Content Report

Please Wait, Processing...
Object Hits Timeout Idle Timeout Created Last Accessed Status CMDS
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.airport 29 120 30 Dec-02
11:59:39 PM		 Dec-03
12:44:05 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 311 120 30 Dec-02
11:06:00 PM		 Dec-03
12:44:43 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 1449 120 30 Dec-02
11:02:00 PM		 Dec-03
12:45:05 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 7 120 30 Dec-02
11:20:05 PM		 Dec-03
12:27:04 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 107 120 30 Dec-02
11:34:46 PM		 Dec-03
12:45:02 AM		 Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 448 120 30 Dec-02
11:02:00 PM		 Dec-03
12:45:05 AM		 Alive
wirebox-coldbox.system.plugins.json 1 120 30 Dec-03
12:43:09 AM		 Dec-03
12:43:09 AM		 Alive
wirebox-coldbox.system.plugins.jvmutils 449 120 30 Dec-02
11:02:00 PM		 Dec-03
12:45:05 AM		 Alive
wirebox-coldbox.system.plugins.messagebox 3 120 30 Dec-03
12:43:08 AM		 Dec-03
12:44:37 AM		 Alive
wirebox-coldbox.system.plugins.utilities 9 120 30 Dec-03
12:15:38 AM		 Dec-03
12:37:18 AM		 Alive
 ColdBox Modules

Below you can see the loaded application modules.

Module Author Version V.P.L L.P.L Load Time CMDS

* V.P.L = View Parent Lookup Order
* L.P.L = Layout Parent Lookup Order

 ColdBox Request Structures
Public Collection
results:
query
RESULTSET
query [Filtered - Top 2 of 50 rows]
  AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE AMDTNUM CHARTSEQ FILENAME FLAG ISSUBSCRIBED PROCEDURENAME RNUM TYPE VOL
1 LIVINGSTON 00R K00R LIVINGSTON MUNI TX [empty string] 10100 SC5TO.PDF [empty string] 0 TAKEOFF MINIMUMS 1 MIN SC-5
2 HARDIN 00U K00U BIG HORN COUNTY MT [empty string] 10100 NW1TO.PDF [empty string] 0 TAKEOFF MINIMUMS 2 MIN NW-1
CACHED false
EXECUTIONTIME 626
SQL SELECT a.*, 0 AS isSubscribed FROM ( SELECT DISTINCT o.chartSeq, o.procedureName,o.amdtnum, a.NFDC_ARPT_ID as AIRPORT_CODE, a.AIRNAV_ARPT_ID as AIRPORT_ICAO, a.ARPT_NM as AIRPORT_NAME, a.ARPT_CHART_LOC_CITY_TXT as AIRPORT_CITY, a.ST_CD as AIRPORT_STATE, o.volume AS vol, o.userAction AS flag, o.code AS type, o.fileName, row_number() OVER (ORDER BY chartseq, a.NFDC_ARPT_ID, o.procedurename) AS rnum FROM procedure o INNER JOIN NON_OFFICIAL_USE_ACTIVE_AIRPORT a ON a.NFDC_ARPT_ID = o.airportCode LEFT JOIN state s ON a.ST_CD = s.stateAbbreviation INNER JOIN cycle c ON o.cycleId = c.cycleId WHERE 1 = 1 AND c.startDate = (SELECT cycleDate FROM currentCycle) ) a WHERE rnum BETWEEN 1 AND 50 ORDER BY chartseq, a.AIRPORT_CODE, a.procedurename
selectedtab: N/A
pagehead: N/A
coordinationresultscount: 1233
resultscount: 24227
orderdirection: ASC
currentcycle:
query
RESULTSET
query
  CYCLENAME ENDDATE STARTDATE
1 2312 2023-12-28 00:00:00.0 2023-11-30 00:00:00.0
CACHED false
EXECUTIONTIME 15
SQL SELECT c.cycleName, c.startDate, c.endDate FROM cycle c WHERE c.startDate = (SELECT MAX(startDate) FROM cycle WHERE startDate <= sysdate)
hotspots:
query
RESULTSET
query [Filtered - Top 2 of 9 rows]
  FILENAME FOLDERNAME PROCEDURENAME REGION
1 ne_hotspot.pdf 30nov2023 A/FD HOT SPOT NE
2 nw_hotspot.pdf 30nov2023 A/FD HOT SPOT NW
CACHED false
EXECUTIONTIME 424
SQL SELECT DISTINCT h.region, h.procedureName, h.fileName, h.folderName FROM airportHotspots h WHERE h.airportCode IN ( SELECT a.NFDC_ARPT_ID as AIRPORT_CODE FROM procedure o INNER JOIN NON_OFFICIAL_USE_ACTIVE_AIRPORT a ON a.NFDC_ARPT_ID = o.airportCode LEFT JOIN state s ON a.ST_CD = s.stateAbbreviation INNER JOIN cycle c ON o.cycleId = c.cycleId WHERE 1 = 1 AND c.startDate = (SELECT cycleDate FROM currentCycle) ) ORDER BY procedureName
xe:
struct
accessDenied main.accessDenied
advancedSearch procedure.advanced
directory directory
export procedure.exportResults
search airport.results
self procedure.results
toggleNotification notification.toggle
event: procedure.exportResults
postcontent: N/A
productionplanresultscount: 4199
unfilteredquerystring: tab=charts
ndbrresultscount: 16133
tab: charts
title: IFP Information Gateway Search Results
startrow: 1
content: N/A
orderby: chartseq
querystring: tab=charts
hasnotification: NO
procedureresultscount: 24227
Private Collection
cbox_incomingcontexthash: 844248F028E8B96B78F6343DA17D5970
currentlayout: layout.main.cfm
currentview: procedure/noReport
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 609 ms