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

0I2 BRAZIL/BRAZIL CLAY COUNTY

Notify me of changes to 0I2

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


Showing results 1 - 1 of 1

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 27,, ORIG-B BRAZIL CLAY COUNTY 0I2 (K0I2) BRAZIL, IN 6/12/2025 Pending

Showing results 1 - 1 of 1

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-335-2023 07:37:10 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
07:37:09.826 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
07:37:09.841 AM 0 ms invoking runEvent [Lifecycle.onRequestStart]
07:37:10.326 AM 485 ms invoking runEvent [procedure.results]
07:37:10.357 AM 0 ms rendering View [main/quickSearchBox.cfm]
07:37:10.357 AM 0 ms rendering View [main/accountHeader.cfm]
07:37:10.357 AM 0 ms rendering View [procedure/results/productionPlan.cfm]
07:37:10.357 AM 0 ms rendering View [procedure/results.cfm]
07:37:10.404 AM 63 ms rendering Layout [layout.main.cfm]
07:37:10.404 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 578 ms
 CacheBox Monitor
Refresh Monitor: Loading...
CacheBox ID
26515518
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.34% ==> Hits: 561890 | Misses: 3752 | Evictions: 0 | Garbage Collections: 0 | Object Count: 10
JVM Memory Stats
20.15 % Free | Max: 2,796,544 KB Total: 2,339,328 KB | Free: 563,535 KB
Last Reap
Dec-335-2023 07:36:01 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 33 120 30 Dec-01
06:57:04 AM		 Dec-01
07:36:30 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 304 120 30 Dec-01
05:52:00 AM		 Dec-01
07:36:01 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 187 120 30 Dec-01
07:24:53 AM		 Dec-01
07:37:10 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 16 120 30 Dec-01
06:14:40 AM		 Dec-01
07:36:44 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 124 120 30 Dec-01
06:02:39 AM		 Dec-01
07:37:09 AM		 Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 62 120 30 Dec-01
07:24:53 AM		 Dec-01
07:37:10 AM		 Alive
wirebox-coldbox.system.plugins.json 2 120 30 Dec-01
07:24:53 AM		 Dec-01
07:26:07 AM		 Alive
wirebox-coldbox.system.plugins.jvmutils 512 120 30 Dec-01
05:40:00 AM		 Dec-01
07:37:10 AM		 Alive
wirebox-coldbox.system.plugins.messagebox 2 120 30 Dec-01
07:26:07 AM		 Dec-01
07:35:26 AM		 Alive
wirebox-coldbox.system.plugins.utilities 2 120 30 Dec-01
07:21:41 AM		 Dec-01
07:23:56 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
  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] 0I2 BRAZIL 0I2 K0I2 BRAZIL CLAY COUNTY IN Brazil/Brazil Clay County K0I2 0 RNAV (GPS) RWY 27,, ORIG-B K0I2 IN 1 2025-06-12 00:00:00.0 06/12/2025 Pending
CACHED false
EXECUTIONTIME 78
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 0i2
selectedtab: N/A
airport:
query
RESULTSET
query
  AIRPORT_CITY AIRPORT_CODE AIRPORT_NAME AIRPORT_STATE
1 BRAZIL 0I2 BRAZIL CLAY COUNTY IN
CACHED false
EXECUTIONTIME 47
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 0i2
pagehead: N/A
coordinationresultscount: 0
resultscount: 1
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=0I2" ,"filterOperator":"or" }, width: 561, loadCallback: function() { $("#scheduledPubStart,#scheduledPubEnd").datepicker(); } }); }); }); </script>
productionplanresultscount: 1
unfilteredquerystring: tab=productionPlan&amp;nasrId=0I2
ndbrresultscount: 1
tab: productionPlan
nasrid: 0I2
title: IFP Information Gateway Search Results
startrow: 1
content: N/A
orderby: airportId
querystring: tab=productionPlan&amp;nasrId=0I2
hasnotification: NO
procedureresultscount: 2
Private Collection
cbox_incomingcontexthash: D5FF9302E9BF4B99DC846C5BC7BD3773
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 439 ms