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

IFP Production Plan - Current IFPs under Development or Amendments with Tentative Publication Date and Status.


Showing results 1 - 3 of 3

Procedure Sort Asc Airport Name Sort Asc Airport ID Sort Desc City/State Sort Asc Scheduled Pub Date Sort Asc Status Sort Asc Actual Pub Date Sort Asc
RNAV (GPS) RWY 21, AMDT 3 BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY 11/30/2023 Published 11/30/2023
RNAV (GPS) RWY 3, AMDT 2 BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY 11/30/2023 At Flight Check
TAKEOFF MINIMUMS AND OBSTACLE DP, AMDT 3 BIG SANDY RGNL SJS (KSJS) PRESTONSBURG, KY 11/30/2023 Published 11/30/2023

Showing results 1 - 3 of 3

Export to CSV

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-341-2023 05:08:33 AM
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
05:08:33.410 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
05:08:33.410 AM 0 ms invoking runEvent [Lifecycle.onRequestStart]
05:08:33.660 AM 250 ms invoking runEvent [procedure.results]
05:08:33.691 AM 0 ms rendering View [main/quickSearchBox.cfm]
05:08:33.691 AM 0 ms rendering View [main/accountHeader.cfm]
05:08:33.707 AM 16 ms rendering View [procedure/results/productionPlan.cfm]
05:08:33.707 AM 16 ms rendering View [procedure/results.cfm]
05:08:33.753 AM 62 ms rendering Layout [layout.main.cfm]
05:08:33.753 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 343 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.39% ==> Hits: 271016 | Misses: 1662 | Evictions: 0 | Garbage Collections: 0 | Object Count: 10
JVM Memory Stats
9.26 % Free | Max: 2,796,544 KB Total: 1,934,848 KB | Free: 258,825 KB
Last Reap
Dec-341-2023 05:07:56 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 14 120 30 Dec-07
04:20:03 AM
Dec-07
05:03:33 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 131 120 30 Dec-07
04:22:41 AM
Dec-07
05:08:02 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.email 1 120 30 Dec-07
04:43:08 AM
Dec-07
04:43:08 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 719 120 30 Dec-07
04:16:02 AM
Dec-07
05:08:33 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 4 120 30 Dec-07
04:42:17 AM
Dec-07
05:03:22 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 120 120 30 Dec-07
03:21:52 AM
Dec-07
05:08:33 AM
Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 248 120 30 Dec-07
04:16:02 AM
Dec-07
05:08:33 AM
Alive
wirebox-coldbox.system.plugins.json 2 120 30 Dec-07
04:16:02 AM
Dec-07
04:42:12 AM
Alive
wirebox-coldbox.system.plugins.jvmutils 242 120 30 Dec-07
04:16:02 AM
Dec-07
05:08:33 AM
Alive
wirebox-coldbox.system.plugins.messagebox 4 120 30 Dec-07
04:42:12 AM
Dec-07
05:03:21 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 3 rows]
  ACTUALPUBDATE ACTUALPUBDATEFORMATTED AIRPORTIDORDER AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE CITYAIRPORT ID ISSUBSCRIBED PROCEDURENAME PRODUCTIONPLANAIRPORTID PRODUCTIONPLANCITY RNUM SCHEDULEDPUBDATE SCHEDULEDPUBDATEFORMATTED STATUS
1 2023-11-30 00:00:00.0 11/30/2023 SJS PRESTONSBURG SJS KSJS BIG SANDY RGNL KY Prestonsburg/Big Sandy Rgnl KSJS 0 RNAV (GPS) RWY 21, AMDT 3 KSJS KY 1 2023-11-30 00:00:00.0 11/30/2023 Published
2 [empty string] [empty string] SJS PRESTONSBURG SJS KSJS BIG SANDY RGNL KY Prestonsburg/Big Sandy Rgnl KSJS 0 RNAV (GPS) RWY 3, AMDT 2 KSJS KY 2 2023-11-30 00:00:00.0 11/30/2023 At Flight Check
CACHED false
EXECUTIONTIME 32
SQL SELECT n.*, 0 AS isSubscribed FROM ( SELECT n.*, row_number() OVER (ORDER BY lower(n.airportidorder) ASC, n.scheduledpubdate, lower(n.procedurename)) AS rnum FROM ( SELECT p.procedureName, a.NFDC_ARPT_ID as AIRPORT_CODE, a.AIRNAV_ARPT_ID as AIRPORT_ICAO, NVL(a.ARPT_NM, 'N/A') AS AIRPORT_NAME, a.ARPT_CHART_LOC_CITY_TXT as AIRPORT_CITY, a.ST_CD as AIRPORT_STATE, p.scheduledPubDate, to_char(p.scheduledPubDate, 'MM/DD/YYYY') AS scheduledPubDateFormatted, p.status, p.actualPubDate, to_char(p.actualPubDate, 'MM/DD/YYYY') AS actualPubDateFormatted, NVL(p.id, s.stateAbbreviation) AS productionPlanAirportId, s.stateAbbreviation AS productionPlanCity, p.id, p.cityAirport, decode(length(p.id), 2, p.id, a.NFDC_ARPT_ID) AS airportIdOrder FROM productionPlan p LEFT JOIN NON_OFFICIAL_USE_ACTIVE_AIRPORT a ON a.AIRNAV_ARPT_ID = p.id LEFT JOIN state s ON (a.ST_CD= s.stateAbbreviation OR p.id = s.stateAbbreviation) WHERE 1 = 1 AND lower(a.NFDC_ARPT_ID) = ? AND ( trunc(p.scheduledPubDate) BETWEEN (SELECT MIN(cycleDate) FROM cycleWindow) AND (SELECT MAX(cycleDate) FROM cycleWindow) ) ) n ) n WHERE rnum BETWEEN 1 AND 50 ORDER BY lower(n.airportidorder) ASC, n.scheduledpubdate, lower(n.procedurename)
SQLPARAMETERS
array - Top 1 of 1 rows
1 sjs
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 16
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
coordinationresultscount: 2
resultscount: 3
orderdirection: ASC
xe:
struct
accessDenied main.accessDenied
advancedSearch procedure.advanced
directory directory
export procedure.exportResults
search airport.results
self procedure.results
toggleNotification notification.toggle
event: procedure.results
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 () { //Search results filters $("#filterOptions").on('click', function (e) { e.preventDefault(); $.faaModal(true,{ autoOpen: true, loadUrl: $(this).attr("href") + " .modalContent", title: "Filter Options for IFP Production Plan", loadData: { "queryString":"tab=productionPlan&amp;nasrId=SJS" ,"filterOperator":"or" }, width: 561, loadCallback: function() { $("#scheduledPubStart,#scheduledPubEnd").datepicker(); } }); }); }); </script>
productionplanresultscount: 3
unfilteredquerystring: tab=productionPlan&amp;nasrId=SJS
ndbrresultscount: 6
tab: productionPlan
nasrid: SJS
title: IFP Information Gateway Search Results
startrow: 1
content: N/A
orderby: airportId
querystring: tab=productionPlan&amp;nasrId=SJS
hasnotification: NO
procedureresultscount: 4
Private Collection
cbox_incomingcontexthash: 38D0BCD8EDE042AA1D4DB51FA02535C1
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 422 ms