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 Asc Airport ID Sort Asc City/State Sort Asc Vol Flag Type
TAKEOFF MINIMUMS THE RED RIVER 0R7 (K0R7) COUSHATTA, LA SC-4 MIN
RNAV (GPS) RWY 18 0 THE RED RIVER 0R7 (K0R7) COUSHATTA, LA SC-4 IAP

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-343-2023 08:13:39 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
08:13:39.353 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
08:13:39.353 AM 0 ms invoking runEvent [Lifecycle.onRequestStart]
08:13:39.541 AM 188 ms invoking runEvent [procedure.results]
08:13:39.572 AM 0 ms rendering View [main/quickSearchBox.cfm]
08:13:39.572 AM 0 ms rendering View [main/accountHeader.cfm]
08:13:39.572 AM 0 ms rendering View [procedure/results/charts.cfm]
08:13:39.572 AM 16 ms rendering View [procedure/results.cfm]
08:13:39.619 AM 63 ms rendering Layout [layout.main.cfm]
08:13:39.619 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 266 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: 373684 | Misses: 2247 | Evictions: 0 | Garbage Collections: 0 | Object Count: 8
JVM Memory Stats
20.18 % Free | Max: 2,796,544 KB Total: 1,455,104 KB | Free: 564,261 KB
Last Reap
Dec-343-2023 08:12:10 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 56 120 30 Dec-09
06:19:54 AM		 Dec-09
08:13:39 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 193 120 30 Dec-09
07:02:02 AM		 Dec-09
08:12:14 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.email 2 120 30 Dec-09
07:19:41 AM		 Dec-09
07:44:33 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 1546 120 30 Dec-09
06:40:49 AM		 Dec-09
08:13:39 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 5 120 30 Dec-09
07:26:18 AM		 Dec-09
08:05:15 AM		 Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 252 120 30 Dec-09
06:16:29 AM		 Dec-09
08:13:39 AM		 Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 491 120 30 Dec-09
06:40:49 AM		 Dec-09
08:13:39 AM		 Alive
wirebox-coldbox.system.plugins.jvmutils 488 120 30 Dec-09
06:40:49 AM		 Dec-09
08:13:39 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 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 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: chartseq
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 [empty string] 10100 SC4TO.PDF [empty string] 0 TAKEOFF MINIMUMS 1 MIN SC-4
2 COUSHATTA 0R7 K0R7 THE RED RIVER LA 0 53525 10410R18.PDF [empty string] 0 RNAV (GPS) RWY 18 2 IAP SC-4
CACHED false
EXECUTIONTIME 15
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 chartseq, a.NFDC_ARPT_ID, o.procedurename) 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 chartseq, a.AIRPORT_CODE, a.procedurename
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 0
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 16
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: D32239EB88F035025BFEA631EF922E15
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 391 ms