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

CRQ CARLSBAD/MC CLELLAN-PALOMAR

Notify me of changes to CRQ

Charts - All Published Charts, Volume, and Type.


Showing results 1 - 16 of 16

Procedure Sort Asc AMDT Airport Name Sort Asc Airport ID Sort Asc City/State Sort Asc Vol Flag Type
TAKEOFF MINIMUMS MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 MIN
ALTERNATE MINIMUMS MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 MIN
HOT SPOT MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 HOT
A / FD HOT SPOT MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 AHS
LEGOZ TWO (RNAV) MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 STAR
LEGOZ TWO (RNAV), CONT.1 MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 STAR
ILS OR LOC RWY 24 9D MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
RNAV (RNP) Z RWY 06 0 MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
RNAV (RNP) Z RWY 24 0B MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
RNAV (GPS) X RWY 24 0C MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
RNAV (GPS) Y RWY 06 0A MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
RNAV (GPS) Y RWY 24 3C MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
VOR-A 8A MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 IAP
AIRPORT DIAGRAM MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 APD
CWARD TWO (RNAV) MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 DP
PADRZ TWO (RNAV) MC CLELLAN-PALOMAR CRQ (KCRQ) CARLSBAD, CA SW-3 DP

Showing results 1 - 16 of 16

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-342-2023 06:06:27 PM
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
06:06:27.546 PM 0 ms invoking runEvent [Lifecycle.onSessionStart]
06:06:27.546 PM 0 ms invoking runEvent [Lifecycle.onRequestStart]
06:06:27.764 PM 203 ms invoking runEvent [procedure.results]
06:06:27.796 PM 0 ms rendering View [main/quickSearchBox.cfm]
06:06:27.796 PM 0 ms rendering View [main/accountHeader.cfm]
06:06:27.796 PM 0 ms rendering View [procedure/results/charts.cfm]
06:06:27.796 PM 0 ms rendering View [procedure/results.cfm]
06:06:27.889 PM 109 ms rendering Layout [layout.main.cfm]
06:06:27.889 PM 0 ms invoking runEvent [Lifecycle.onRequestEnd]
Total Framework Request Execution Time: 343 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.41% ==> Hits: 350315 | Misses: 2073 | Evictions: 0 | Garbage Collections: 0 | Object Count: 8
JVM Memory Stats
17.57 % Free | Max: 2,796,544 KB Total: 1,863,680 KB | Free: 491,306 KB
Last Reap
Dec-342-2023 06:04:30 PM

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 34 120 30 Dec-08
05:13:05 PM
Dec-08
06:04:57 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.directory 237 120 30 Dec-08
04:54:00 PM
Dec-08
06:06:02 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.email 1 120 30 Dec-08
05:38:56 PM
Dec-08
05:38:56 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.lifecycle 1455 120 30 Dec-08
04:32:08 PM
Dec-08
06:06:27 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.main 5 120 30 Dec-08
05:34:41 PM
Dec-08
06:04:42 PM
Alive
handlers-air_traffic.flight_info.aeronav.procedures.application.handlers.procedure 29 120 30 Dec-08
05:48:07 PM
Dec-08
06:06:27 PM
Alive
wirebox-air_traffic.flight_info.aeronav.procedures.application.plugins.messagebox 482 120 30 Dec-08
04:32:08 PM
Dec-08
06:06:27 PM
Alive
wirebox-coldbox.system.plugins.jvmutils 482 120 30 Dec-08
04:32:08 PM
Dec-08
06:06:27 PM
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 CARLSBAD CRQ MC CLELLAN-PALOMAR CA
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 crq
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=CRQ" }, width: 544 }); }); }); </script>
event: procedure.results
unfilteredquerystring: tab=charts&amp;nasrId=CRQ
ndbrresultscount: 8
startrow: 1
content: N/A
orderby: chartseq
procedureresultscount: 16
results:
query
RESULTSET
query [Filtered - Top 2 of 16 rows]
  AIRPORT_CITY AIRPORT_CODE AIRPORT_ICAO AIRPORT_NAME AIRPORT_STATE AMDTNUM CHARTSEQ FILENAME FLAG ISSUBSCRIBED PROCEDURENAME RNUM TYPE VOL
1 CARLSBAD CRQ KCRQ MC CLELLAN-PALOMAR CA [empty string] 10100 SW3TO.PDF [empty string] 0 TAKEOFF MINIMUMS 1 MIN SW-3
2 CARLSBAD CRQ KCRQ MC CLELLAN-PALOMAR CA [empty string] 10200 SW3ALT.PDF [empty string] 0 ALTERNATE MINIMUMS 2 MIN SW-3
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 crq
coordinationresultscount: 0
resultscount: 16
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 15
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 sw_hotspot.pdf 30nov2023 A/FD HOT SPOT SW
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 crq
xe:
struct
accessDenied main.accessDenied
advancedSearch procedure.advanced
directory directory
export procedure.exportResults
search airport.results
self procedure.results
toggleNotification notification.toggle
productionplanresultscount: 4
tab: charts
nasrid: CRQ
title: IFP Information Gateway Search Results
querystring: tab=charts&amp;nasrId=CRQ
hasnotification: NO
Private Collection
cbox_incomingcontexthash: 85E2EE95A29912456CE3E1504BCED125
currentlayout: layout.main.cfm
currentview: procedure/results
currentviewargs:
struct [empty]
viewmodule: N/A
Approximate Debug Rendering Time: 438 ms