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

0R7 COUSHATTA/THE RED RIVER

Notify me of changes to 0R7

Charts - All Published Charts, Volume, and Type.


Showing results 1 - 2 of 2

SC - A/FD Hot Spot (PDF)
Legend and General Information (PDF)
Procedure Sort Asc AMDT Airport Name Sort Desc Airport ID Sort Asc City/State Sort Asc Vol Flag Type
RNAV (GPS) RWY 18 0 THE RED RIVER 0R7 (K0R7) COUSHATTA, LA SC-4 IAP
TAKEOFF MINIMUMS THE RED RIVER 0R7 (K0R7) COUSHATTA, LA SC-4 MIN

Showing results 1 - 2 of 2

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-336-2023 03:17:35 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
03:17:34.155 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
03:17:34.155 AM 0 ms invoking runEvent [Lifecycle.onRequestStart]
03:17:35.184 AM 1029 ms invoking runEvent [procedure.results]
03:17:35.200 AM 0 ms rendering View [main/quickSearchBox.cfm]
03:17:35.200 AM 0 ms rendering View [main/accountHeader.cfm]
03:17:35.216 AM 16 ms rendering View [procedure/results/charts.cfm]
03:17:35.216 AM 16 ms rendering View [procedure/results.cfm]
03:17:35.247 AM 47 ms rendering Layout [layout.main.cfm]
03:17:35.263 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 1108 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.38% ==> Hits: 29054 | Misses: 180 | Evictions: 0 | Garbage Collections: 0 | Object Count: 10
JVM Memory Stats
14.59 % Free | Max: 2,796,544 KB Total: 1,139,712 KB | Free: 408,007 KB
Last Reap
Dec-336-2023 03:15: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 3 120 30 Dec-02
03:15:37 AM		 Dec-02
03:16:09 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 62 120 30 Dec-02
02:56:00 AM		 Dec-02
03:16:56 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 262 120 30 Dec-02
02:52:28 AM		 Dec-02
03:17:35 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 2 120 30 Dec-02
03:02:25 AM		 Dec-02
03:17:32 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 19 120 30 Dec-02
02:57:17 AM		 Dec-02
03:17:34 AM		 Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 92 120 30 Dec-02
02:52:28 AM		 Dec-02
03:17:35 AM		 Alive
wirebox-coldbox.system.plugins.json 2 120 30 Dec-02
02:52:28 AM		 Dec-02
03:02:25 AM		 Alive
wirebox-coldbox.system.plugins.jvmutils 87 120 30 Dec-02
02:52:29 AM		 Dec-02
03:17:35 AM		 Alive
wirebox-coldbox.system.plugins.messagebox 2 120 30 Dec-02
03:02:25 AM		 Dec-02
03:17:31 AM		 Alive
wirebox-coldbox.system.plugins.utilities 1 120 30 Dec-02
03:10:55 AM		 Dec-02
03:10: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
selectedtab: N/A
airport:
query
RESULTSET
query
  AIRPORT_CITY AIRPORT_CODE AIRPORT_NAME AIRPORT_STATE
1 COUSHATTA 0R7 THE RED RIVER LA
CACHED false
EXECUTIONTIME 110
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 0r7
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=0R7" }, width: 544 }); }); }); </script>
event: procedure.results
unfilteredquerystring: tab=charts&amp;nasrId=0R7
ndbrresultscount: 2
startrow: 1
content: N/A
orderby: airportName
procedureresultscount: 2
results:
query
RESULTSET
query
  AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE AMDTNUM CHARTSEQ FILENAME FLAG ISSUBSCRIBED PROCEDURENAME RNUM TYPE VOL
1 COUSHATTA 0R7 K0R7 THE RED RIVER LA 0 53525 10410R18.PDF [empty string] 0 RNAV (GPS) RWY 18 2 IAP SC-4
2 COUSHATTA 0R7 K0R7 THE RED RIVER LA [empty string] 10100 SC4TO.PDF [empty string] 0 TAKEOFF MINIMUMS 1 MIN SC-4
CACHED false
EXECUTIONTIME 110
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 0r7
coordinationresultscount: 1
resultscount: 2
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 sc_hotspot.pdf 30nov2023 A/FD HOT SPOT SC
CACHED false
EXECUTIONTIME 93
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 0r7
xe:
struct
accessDenied main.accessDenied
advancedSearch procedure.advanced
directory directory
export procedure.exportResults
search airport.results
self procedure.results
toggleNotification notification.toggle
productionplanresultscount: 0
tab: charts
nasrid: 0R7
title: IFP Information Gateway Search Results
querystring: tab=charts&amp;nasrId=0R7
hasnotification: NO
Private Collection
cbox_incomingcontexthash: DDE6CB7137017F71A37425B36B0F5933
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 297 ms