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

IFP Information Gateway Instructional Video

SQI /WHITESIDE COUNTY/JOS H BITTORF FLD

Notify me of changes to SQI

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 Asc City/State Sort Asc Scheduled Pub Date Sort Asc Status Sort Asc Actual Pub Date Sort Desc
RNAV (GPS) RWY 7, AMDT 1A WHITESIDE COUNTY / JOS H BITTORF FLD SQI (KSQI) IL 11/30/2023 Under Development
LOC BC RWY 7, AMDT 7 WHITESIDE COUNTY / JOS H BITTORF FLD SQI (KSQI) IL 11/30/2023 Under Development
RNAV (GPS) RWY 25, AMDT 1A WHITESIDE COUNTY / JOS H BITTORF FLD SQI (KSQI) IL 11/30/2023 Under Development

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:
Jun-09-2023 02:00:55 AM
Server Instance:
iactdzpvap825
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
02:00:55.127 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
02:00:55.129 AM 1 ms invoking runEvent [Lifecycle.onRequestStart]
02:00:55.330 AM 201 ms invoking runEvent [procedure.results]
02:00:55.345 AM 1 ms rendering View [main/quickSearchBox.cfm]
02:00:55.346 AM 0 ms rendering View [main/accountHeader.cfm]
02:00:55.350 AM 3 ms rendering View [procedure/results/productionPlan.cfm]
02:00:55.350 AM 9 ms rendering View [procedure/results.cfm]
02:00:55.396 AM 57 ms rendering Layout [layout.main.cfm]
02:00:55.397 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 270 ms
 CacheBox Monitor
Refresh Monitor: Loading...
CacheBox ID
1453458346
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: 98.45% ==> Hits: 242244 | Misses: 3802 | Evictions: 0 | Garbage Collections: 0 | Object Count: 7
JVM Memory Stats
23.07 % Free | Max: 2,796,544 KB Total: 1,467,392 KB | Free: 645,087 KB
Last Reap
Jun-09-2023 02:00:03 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 1 120 30 Jun-09
01:58:01 AM		 Jun-09
01:58:01 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 148 120 30 Jun-09
12:14:00 AM		 Jun-09
02:00:08 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 592 120 30 Jun-09
12:13:34 AM		 Jun-09
02:00:55 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 10 120 30 Jun-09
01:33:18 AM		 Jun-09
02:00:55 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.user 1 120 30 Jun-09
01:51:31 AM		 Jun-09
01:51:31 AM		 Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 200 120 30 Jun-09
12:13:34 AM		 Jun-09
02:00:55 AM		 Alive
wirebox-coldbox.system.plugins.jvmutils 192 120 30 Jun-09
12:13:34 AM		 Jun-09
02:00:55 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 [empty string] [empty string] SQI [empty string] SQI KSQI WHITESIDE COUNTY/JOS H BITTORF FLD IL Sterling/Rockfalls/Whiteside County/Jos H Bittorf Fld KSQI 0 RNAV (GPS) RWY 7, AMDT 1A KSQI IL 1 2023-11-30 00:00:00.0 11/30/2023 Under Development
2 [empty string] [empty string] SQI [empty string] SQI KSQI WHITESIDE COUNTY/JOS H BITTORF FLD IL Sterling/Rockfalls/Whiteside County/Jos H Bittorf Fld KSQI 0 LOC BC RWY 7, AMDT 7 KSQI IL 3 2023-11-30 00:00:00.0 11/30/2023 Under Development
CACHED false
EXECUTIONTIME 25
SQL SELECT n.*, 0 AS isSubscribed FROM ( SELECT n.*, row_number() OVER (ORDER BY n.actualpubdate ASC, lower(n.airportidorder)) 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.CITY_NM 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 n.actualpubdate ASC, lower(n.airportidorder)
SQLPARAMETERS
array - Top 1 of 1 rows
1 sqi
selectedtab: N/A
airport:
query
RESULTSET
query
  AIRPORT_CITY AIRPORT_CODE AIRPORT_NAME AIRPORT_STATE
1 [empty string] SQI WHITESIDE COUNTY/JOS H BITTORF FLD IL
CACHED false
EXECUTIONTIME 3
SQL SELECT a.NFDC_ARPT_ID as AIRPORT_CODE, a.ARPT_NM as AIRPORT_NAME, a.CITY_NM 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 sqi
pagehead: N/A
coordinationresultscount: 0
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=SQI" ,"filterOperator":"or" }, width: 561, loadCallback: function() { $("#scheduledPubStart,#scheduledPubEnd").datepicker(); } }); }); }); </script>
productionplanresultscount: 3
unfilteredquerystring: tab=productionPlan&amp;nasrId=SQI
ndbrresultscount: 4
tab: productionPlan
nasrid: SQI
title: IFP Information Gateway Search Results
startrow: 1
content: N/A
orderby: actualPubDate
querystring: tab=productionPlan&amp;nasrId=SQI
hasnotification: NO
procedureresultscount: 6
Private Collection
cbox_incomingcontexthash: 0A64F0A8ED4E9DA2A8E6AB7995D18000
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 408 ms