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.

United States Department of Transportation United 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

E42 SPEARMAN/MAJOR SAMUEL B CORNELIUS FLD

Notify me of changes to E42

Charts - All Published Charts, Volume, and Type.


Showing results 1 - 3 of 3

Procedure Sort Asc AMDT Airport Name Sort Asc Airport ID Sort Asc City/State Sort Asc Vol Flag Type
TAKEOFF MINIMUMS MAJOR SAMUEL B CORNELIUS FLD E42 (KE42) SPEARMAN, TX SC-2 MIN
RNAV (GPS) RWY 02 0 MAJOR SAMUEL B CORNELIUS FLD E42 (KE42) SPEARMAN, TX SC-2 IAP
RNAV (GPS) RWY 20 0 MAJOR SAMUEL B CORNELIUS FLD E42 (KE42) SPEARMAN, TX SC-2 IAP

Showing results 1 - 3 of 3

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:
Feb-54-2024 05:29:23 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:29:23.223 AM 0 ms invoking runEvent [Lifecycle.onSessionStart]
05:29:23.223 AM 0 ms invoking runEvent [Lifecycle.onRequestStart]
05:29:23.462 AM 223 ms invoking runEvent [procedure.results]
05:29:23.494 AM 0 ms rendering View [main/quickSearchBox.cfm]
05:29:23.509 AM 15 ms rendering View [main/accountHeader.cfm]
05:29:23.509 AM 0 ms rendering View [procedure/results/charts.cfm]
05:29:23.509 AM 15 ms rendering View [procedure/results.cfm]
05:29:23.573 AM 79 ms rendering Layout [layout.main.cfm]
05:29:23.573 AM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 350 ms
 CacheBox Monitor
Refresh Monitor: Loading...
CacheBox ID
879805367
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.36% ==> Hits: 501767 | Misses: 3230 | Evictions: 0 | Garbage Collections: 0 | Object Count: 8
JVM Memory Stats
16.51 % Free | Max: 2,796,544 KB Total: 1,866,240 KB | Free: 461,651 KB
Last Reap
Feb-54-2024 05:28:00 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 39 120 30 Feb-23
04:05:39 AM
Feb-23
05:29:23 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 16 120 30 Feb-23
05:24:00 AM
Feb-23
05:28:00 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 368 120 30 Feb-23
04:57:46 AM
Feb-23
05:29:23 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 1 120 30 Feb-23
05:13:29 AM
Feb-23
05:13:29 AM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 120 120 30 Feb-23
03:40:04 AM
Feb-23
05:29:23 AM
Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 119 120 30 Feb-23
04:57:46 AM
Feb-23
05:29:23 AM
Alive
wirebox-coldbox.system.plugins.jvmutils 117 120 30 Feb-23
04:57:46 AM
Feb-23
05:29:23 AM
Alive
wirebox-coldbox.system.plugins.messagebox 12 120 30 Feb-23
03:55:39 AM
Feb-23
05:28:04 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 SPEARMAN E42 MAJOR SAMUEL B CORNELIUS FLD TX
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 e42
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=E42" }, width: 544 }); }); }); </script>
event: procedure.results
unfilteredquerystring: tab=charts&amp;nasrId=E42
ndbrresultscount: 0
startrow: 1
content: N/A
orderby: chartseq
procedureresultscount: 3
results:
query
RESULTSET
query [Filtered - Top 2 of 3 rows]
  AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE AMDTNUM CHARTSEQ FILENAME FLAG ISSUBSCRIBED PROCEDURENAME RNUM TYPE VOL
1 SPEARMAN E42 KE42 MAJOR SAMUEL B CORNELIUS FLD TX [empty string] 10100 SC2TO.PDF [empty string] 0 TAKEOFF MINIMUMS 1 MIN SC-2
2 SPEARMAN E42 KE42 MAJOR SAMUEL B CORNELIUS FLD TX 0 53525 06776R2.PDF [empty string] 0 RNAV (GPS) RWY 02 2 IAP SC-2
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 e42
coordinationresultscount: 0
resultscount: 3
currentcycle:
query
RESULTSET
query
  CYCLENAME ENDDATE STARTDATE
1 2402 2024-03-21 00:00:00.0 2024-02-22 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 25jan2024 A/FD HOT SPOT SC
CACHED false
EXECUTIONTIME 17
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 e42
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: E42
title: IFP Information Gateway Search Results
querystring: tab=charts&amp;nasrId=E42
hasnotification: NO
Private Collection
cbox_incomingcontexthash: A9870BF4EF6FA56A5395CC7E524B41F1
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 495 ms