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

The IFP Information Gateway is your centralized instrument flight procedures data portal, providing a single-source for:

  • Charts — All Published Charts, Volume, and Type*.
  • IFP Production Plan — Current IFPs under Development or Amendments with Tentative Publication Date and Status.
  • IFP Coordination — All coordinated developed/amended procedure forms forwarded to Flight Check or Charting for publication.
  • IFP Documents - Navigation Database Review (NDBR) — Repository and Source Documents used for Data Validation of Coded IFPs.

Advanced Search

SJS PRESTONSBURG/BIG SANDY RGNL

Notify me of changes to SJS

Charts - All Published Charts, Volume, and Type.


Showing results 1 - 4 of 4

Procedure Sort Asc AMDT Airport Name Sort Desc Airport ID Sort Asc City/State Sort Asc Vol Flag Type
RNAV (GPS) RWY 03 2 BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY SE-1 C IAP
ALTERNATE MINIMUMS BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY SE-1 C MIN
TAKEOFF MINIMUMS BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY SE-1 C MIN
RNAV (GPS) RWY 21 3 BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY SE-1 C IAP

Showing results 1 - 4 of 4

Export to CSV

Flag Values:

"A"
Added since last cycle
"D"
Deleted since last cycle
"C"
Changed since last cycle

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-340-2023 07:50:28 PM
Server Instance:
IP-0A1BE514
Current Event:
procedure.results
Current Layout:
layout.main.cfm (Module: )
Current View:
procedure/results
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
07:50:27.489 PM 0 ms invoking runEvent [Lifecycle.onSessionStart]
07:50:27.489 PM 0 ms invoking runEvent [Lifecycle.onRequestStart]
07:50:28.411 PM 922 ms invoking runEvent [procedure.results]
07:50:28.443 PM 0 ms rendering View [main/quickSearchBox.cfm]
07:50:28.443 PM 0 ms rendering View [main/accountHeader.cfm]
07:50:28.458 PM 15 ms rendering View [procedure/results/charts.cfm]
07:50:28.458 PM 15 ms rendering View [procedure/results.cfm]
07:50:28.505 PM 78 ms rendering Layout [layout.main.cfm]
07:50:28.505 PM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 1016 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.40% ==> Hits: 257417 | Misses: 1546 | Evictions: 0 | Garbage Collections: 0 | Object Count: 8
JVM Memory Stats
14.46 % Free | Max: 2,796,544 KB Total: 1,443,328 KB | Free: 404,293 KB
Last Reap
Dec-340-2023 07:50:08 PM

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 40 120 30 Dec-06
06:24:04 PM
Dec-06
07:49:20 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 292 120 30 Dec-06
06:16:01 PM
Dec-06
07:50:08 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.email 1 120 30 Dec-06
07:21:02 PM
Dec-06
07:21:02 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 1306 120 30 Dec-06
06:12:00 PM
Dec-06
07:50:28 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 48 120 30 Dec-06
07:02:29 PM
Dec-06
07:50:27 PM
Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 426 120 30 Dec-06
06:12:00 PM
Dec-06
07:50:28 PM
Alive
wirebox-coldbox.system.plugins.jvmutils 422 120 30 Dec-06
06:12:00 PM
Dec-06
07:50:28 PM
Alive
wirebox-coldbox.system.plugins.messagebox 11 120 30 Dec-06
06:27:04 PM
Dec-06
07:24:44 PM
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
selectedtab: N/A
airport:
query
RESULTSET
query
  AIRPORT_CITY AIRPORT_CODE AIRPORT_NAME AIRPORT_STATE
1 PRESTONSBURG SJS BIG SANDY RGNL KY
CACHED false
EXECUTIONTIME 109
SQL SELECT a.NFDC_ARPT_ID as AIRPORT_CODE, a.ARPT_NM as AIRPORT_NAME, a.ARPT_CHART_LOC_CITY_TXT as AIRPORT_CITY, a.ST_CD as AIRPORT_STATE FROM NON_OFFICIAL_USE_ACTIVE_AIRPORT a WHERE lower(a.NFDC_ARPT_ID) = ?
SQLPARAMETERS
array - Top 1 of 1 rows
1 sjs
pagehead: N/A
orderdirection: ASC
postcontent: <script src="../assets/js/notification.js"></script> <script> $(function () { $.faaModal(true, { autoOpen: true, loadUrl: '../view/legalDisclaimer.cfm', loadCallback: function () { console.log('callback for ' + this.id); }, title: 'Disclaimer', dialogClass: this.id, buttons: { "Continue": function() { $(this).dialog("close"); } }, modal: true }); }); </script> <style> .layout label { width: 200px; } .layout .formRow.noLabel { padding-left: 211px; } .footerContactLink { display: none; } form.cmxform label.error, label.error { color: red; font-style: italic; padding-left: 205px; width: 300px; text-align: left; } div.error { display: none; } </style> <script src="//ajax.aspnetcdn.com/ajax/jquery.validate/1.12.0/jquery.validate.min.js" ></script> <script> $(function () { $("#filterOptions").on('click', function (e) { e.preventDefault(); $.faaModal(true,{ autoOpen: true, loadUrl: $(this).attr("href") + " .modalContent", title: "Filter Options for Charts", loadData: { "queryString":"tab=charts&amp;nasrId=SJS" }, width: 544 }); }); }); </script>
event: procedure.results
unfilteredquerystring: tab=charts&amp;nasrId=SJS
ndbrresultscount: 6
startrow: 1
content: N/A
orderby: airportName
procedureresultscount: 4
results:
query
RESULTSET
query [Filtered - Top 2 of 4 rows]
  AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE AMDTNUM CHARTSEQ FILENAME FLAG ISSUBSCRIBED PROCEDURENAME RNUM TYPE VOL
1 PRESTONSBURG SJS KSJS BIG SANDY RGNL KY 2 53525 06991R3.PDF C 0 RNAV (GPS) RWY 03 3 IAP SE-1
2 PRESTONSBURG SJS KSJS BIG SANDY RGNL KY [empty string] 10200 SE1ALT.PDF C 0 ALTERNATE MINIMUMS 2 MIN SE-1
CACHED false
EXECUTIONTIME 94
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 a.ARPT_NM ASC, a.NFDC_ARPT_ID) 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) AND lower(a.NFDC_ARPT_ID) = ? ) a WHERE rnum BETWEEN 1 AND 50 ORDER BY a.AIRPORT_NAME ASC, a.AIRPORT_CODE
SQLPARAMETERS
array - Top 1 of 1 rows
1 sjs
coordinationresultscount: 2
resultscount: 4
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 93
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
  FILENAME FOLDERNAME PROCEDURENAME REGION
1 se_hotspot.pdf 30nov2023 A/FD HOT SPOT SE
CACHED false
EXECUTIONTIME 94
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) AND lower(a.NFDC_ARPT_ID) = ? ) ORDER BY procedureName
SQLPARAMETERS
array - Top 1 of 1 rows
1 sjs
xe:
struct
accessDenied main.accessDenied
advancedSearch procedure.advanced
directory directory
export procedure.exportResults
search airport.results
self procedure.results
toggleNotification notification.toggle
productionplanresultscount: 3
tab: charts
nasrid: SJS
title: IFP Information Gateway Search Results
querystring: tab=charts&amp;nasrId=SJS
hasnotification: NO
Private Collection
cbox_incomingcontexthash: DDCED4FA9655BAD9C37A1A3137CAD7AC
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 422 ms