Aero-News Network: The aviation and aerospace world's daily/real-time news and information service
Aero-News Network
RSS icon RSS feed
podcast icon MP3 podcast
Subscribe Aero-News e-mail Newsletter Subscribe

Hide/Show Archive Navigation.

All News

April 02, 2022

Blue Origin Successfully Completes 4th Crewed Flight

NS-20 Enjoys a Happy, Beautiful, and Thankfully - Uneventful Launch

Blue Origin's postponed NS-20 flight safely launched, taking its crew of 6 into suborbital space for a brief window before returning back to Earth. The astronauts returned uneventfully less than 15 minutes after their launch at 09:58 am from Origin's Launch Site One in West Texas. The occasion went by somewhat unnoticed by the general public, perhaps a side effect of the loss of celebrity passengers this time around. Blue Origin's past launches have included high-profile figures like founder/owner Jeff Bezos, William Shatner, and Michael Strahan, a perfect way to build brand recognition for the exceedingly expensive experience while raking in free publicity.

Read More

MD Helicopters Reaches Asset Purchase Agreement

Future Looking Up for Little Bird Manufacturer

Things are finally "coming up Milhouse" for MD Helicopters following the announcement that will see the company through its current rough patch after an infusion of $60 million in new capital. MD Helicopters, famous manufacturer of the Hughes MD 500, or 'Little Bird' after its common military nickname, has entered into an agreement with a creditor consortium led by Bardin Hill and MBIA Insurance Corporation.

Read More

Mark Vande Hei Hitches a Ride With Roscosmos

Space Veteran Ends 355-Day Space Living Streak

Mark Vande Hei ended his 355-day streak for the longest single spaceflight in history by an American, heading to Earth on March 30. He began making his way back home alongside a pair of Roscosmos cosmonauts Anton Shkaplerov and Pyotr Dubrov, proving that cooperation between the Russian space program and NASA can continue where it counts. The trio departed the ISS and made a safe, parachute-assisted landing in Dzhezkazgan, Kazakhstan. Vande Hei will be an interesting case study in long-duration spaceflight on humans, coming in at a fine time as the agency picks up momentum for the Artemis program.

Read More

DJI Releases Next-Gen Enterprise Drone System

DJI has expanded its portfolio, stretching itself further into the business range of UAS aircraft with the new Matrice 30 Enterprise Drone

The new system contains a range of novel equipment for DJI, like a more refined and controllable FlightHub 2 Control System for remote planning, flying, and data management for not just one drone, but a fleet of them. The DJI Dock acknowledges the level of operational independence that so many operators are hungry for, offering an automated, remotely manageable way to launch, retrieve, store, and recharge drones without any human intervention for lengthy periods of time.

Read More

Classic Aero-TV: Avionics Cooling Fans -- Sandia's Temperature Control Solutions

From 2011 (YouTube version): How Cool Is YOUR Cockpit???

Aviation publications LOVE to write about all the new wiz-bangs that are seen front and center is today's cockpits... the latest generation of cockpit displays are about a slick as things get these and look sexy as hell. BUT... what about the BEHIND the scenes... those components that allow all those super-cool new technologies to remain... well, super cool?

Read More

Gogo Business Aviation Marks Millionth Internet-Connected Flight

Sees 38% Bump in Megabytes Used per Flight, 29% Increase in Flights

Gogo Business Aviation announced the passage of another milestone as they continue their march through the inflight internet market, boasting the completion of 1 million flights backed by the firm's internet connectivity services. The AVANCE system, whether in its older L3 or cutting-edge L5 trim, has become the "most successful broadband product ever launched in business aviation, with 2,504 business aircraft flying with an AVANCE L5 or L3 system onboard,” according to Gogo spokesman William Davis.

Read More

Advertisement

Published Study Announces Availability of Micro/Nano UAV Studies

Advancements in Miniaturization, Tech Integration, Automation Set Prime Tiny UAS Segment for Growth

Market Forecast, headquartered in Amsterdam, publicized its completed study on the growing micro, mini, and nano drone market. Uncrewed, autonomous and semi-autonomous aircraft have been growing quickly on all fronts, easily outpacing previous generations of technological advancement. A stream of developments in miniaturization and battery improvements have brought a steady stream of smaller, lighter, higher-performance equipment. 

Read More

NTSB Prelim: McDonnell Douglas 500N

...Rotation Became More Aggressive As The Helicopter Began To Descend

On February 19, 2022, about 1834 Pacific standard time, a McDonnell Douglas 500N, N521HB, was substantially damaged when it was involved in an accident in Newport Beach, California. The pilot sustained minor injuries, and the tactical flight officer (TFO) was fatally injured. The helicopter was operated as a public aircraft flight by the Huntington Beach Police Department. The helicopter was owned by the City of Huntington Beach and was providing law enforcement air support under a contract service agreement for the City of Newport Beach.

Read More

ANN's Daily Aero-Linx (04.02.22)

Aero Linx: The New Mexico Pilots Association The New Mexico Pilots Association is a grass roots organization of members with a passion for general aviation in New Mexico.  Our mission is promoting general aviation, aviation safety, pilot camaraderie, and preservation of airfields and airspace. JOIN US! You’ll get to know a network of pilots and aviation enthusiasts who enjoy flying, discovering new places, and having fun! By joining NMPA, you support aviation in New Mexico!   NMPA provides proactive leadership on issues and concerns of interest to general aviation pilots statewide. 

Read More

AD: The Boeing Company Airplanes

AD 2022-06-18 Requires Replacing The Alternative Ventilation Duct Having A Certain Part Number

The FAA is adopting a new airworthiness directive (AD) for all The Boeing Company Model 767-2C series airplanes. This AD was prompted by a report of multiple nuisance caution "RECIRC SMOKE" engine indication and crew alerting system (EICAS) messages that may occur when water accumulates in the alternative ventilation system (AVS) duct. This AD requires replacing the alternative ventilation duct having a certain part number with a new part number, and for certain airplanes, changing the insulation blanket to install the drain hose. This AD also prohibits the installation of an alternative ventilation duct, part number (P/N) 216T2101-704, on any airplane.

Read More

ANN's Daily Aero-Term (04.02.22): Profile Descent

Profile Descent An uninterrupted descent (except where level flight is required for speed adjustment; e.g., 250 knots at 10,000 feet MSL) from cruising altitude/level to interception of a glideslope or to a minimum altitude specified for the initial or intermediate approach segment of a nonprecision instrument approach. The profile descent normally terminates at the approach gate or where the glideslope or other appropriate minimum altitude is intercepted.

Read More

Aero-News: Quote of the Day (04.02.22)

"I've obviously been thinking about what this experience will be like for our astronauts, and to experience it myself was a joy. It was 10 times more intense than I thought it would be, or anything that I've ever experienced in my life physically, mentally, emotionally."  Source: Spoken by Gary Lai, the chief architect for the New Shepard NS-20 rode upon during their recent sub-orbital space trip. He was the only unpaid ticket on the trip, generously allowed to experience his handiwork from the customers' side of the launch pad. Lai's journey as an astronaut was an emotional one. 

Read More

Advertisement




Advertisement

Advertisement

Podcasts

AeroTwitter

© 2007 - 2025 Web Development & Design by Pauli Systems, LC


Debugging Information
ColdFusion Server Enterprise 2023,0,16,330828
Template /Subscribe.cfm
Time Stamp 02-Dec-25 05:44 AM
Locale English (US)
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 10.0.20.1
Host Name 10.0.20.1


Execution Time

Total Time Avg Time Count Template
476 ms 476 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onRequest(/Subscribe.cfm) ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc
475 ms 475 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/parsed/main.archive.cfm
385 ms 385 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/actArchive-v.cfm
52 ms 52 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryArchiveList.cfm
10 ms 10 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryAudio.cfm
7 ms 7 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/actWidgets.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/display/dspArchiveList.cfm
4 ms 4 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/dspWidgets.cfm
3 ms 3 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onRequestStart(/Subscribe.cfm) ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc
2 ms 2 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/dspBannerAds.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/fusebox.init.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryNewscats.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/dspSidebar.cfm
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onRequestEnd(/Subscribe.cfm) ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc
1 ms 0 ms 11 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | RandomNumber() ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><u><strong>Sees 38% Bump in Megabytes Used per Flight, 29% Increase in Flights</strong></u></h2>

Gogo Business Aviation announced the passage of another milestone as they continue their march through the inflight internet market, boasting the completion of 1 million flights backed by the firm's internet connectivity services.&nbsp;The AVANCE system, whether in its older L3 or cutting-edge L5 trim, has become the "most successful broadband product ever launched in business aviation, with 2,504 business aircraft flying with an AVANCE L5 or L3 system onboard,&rdquo; according to Gogo spokesman William Davis.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxAction.cfc | getAccess() ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxAction.cfc
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc | compileRequest(main.archive, CFC: fckeditor.fb551.fusebox5.myFusebox) ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/CustomTags/bph/QuerySim.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/actFooter.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryWidVideo.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/display/dspArchive-v.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/dspNewscats.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/layAnnNew.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_admin.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_flashAd.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_podcasts.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_search.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_today.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_topvideos.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/widgets/widget_twitter.cfm
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onSessionStart() ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | lastdayofMonth(4) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><a href="https://youtu.be/gYjI0vtwCY0"><span style="color:rgb(0, 0, 255)"><u><strong>From 2011 (YouTube version): How Cool Is YOUR Cockpit???</strong></u></span></a></h2>

Aviation publications LOVE to write about all the new wiz-bangs that are seen front and center is today's cockpits... the latest generation of cockpit displays are about a slick as things get these and look sexy as hell. BUT... what about the BEHIND the scenes... those components that allow all those super-cool new technologies to remain... well, super cool?

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><strong><u>Advancements in Miniaturization, Tech Integration, Automation Set Prime Tiny UAS Segment for Growth</u></strong></h2>

Market Forecast, headquartered in Amsterdam, publicized its completed study on the growing micro, mini, and nano drone market.&nbsp;Uncrewed, autonomous and semi-autonomous aircraft have been growing quickly on all fronts, easily outpacing previous generations of technological advancement. A stream of developments in miniaturization and battery improvements have brought a steady stream of smaller, lighter, higher-performance equipment.&nbsp;

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><strong><u>Future Looking Up for Little Bird&nbsp;Manufacturer</u></strong></h2>

Things are finally "coming up Milhouse"&nbsp;for MD Helicopters following the announcement that will see the company through its current rough patch after an infusion of $60 million in new capital.&nbsp;MD Helicopters, famous manufacturer of the Hughes MD 500, or 'Little Bird' after its common military nickname, has entered into an agreement with a creditor consortium led by Bardin Hill and MBIA Insurance Corporation.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><strong><u>NS-20 Enjoys a Happy, Beautiful, and Thankfully - Uneventful Launch</u></strong></h2>

Blue Origin's postponed NS-20 flight safely launched, taking its crew of 6 into suborbital space for a brief window before returning back to Earth. The astronauts returned uneventfully less than 15 minutes after their launch at 09:58 am from Origin's Launch Site One in West Texas. The occasion went by somewhat unnoticed by the general public, perhaps a side effect of the loss of celebrity passengers this time around. Blue Origin's past launches have included high-profile figures like founder/owner Jeff Bezos, William Shatner, and Michael Strahan, a perfect way to build brand recognition for the exceedingly expensive experience while raking in free publicity.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><u><strong>...Rotation Became More Aggressive As The Helicopter Began To Descend</strong></u></h2>

On February 19, 2022, about 1834 Pacific standard time, a McDonnell Douglas 500N, N521HB, was substantially damaged when it was involved in an accident in Newport Beach, California. The pilot sustained minor injuries, and the tactical flight officer (TFO) was fatally injured. The helicopter was operated as a public aircraft flight by the Huntington Beach Police Department. The helicopter was owned by the City of Huntington Beach and was providing law enforcement air support under a contract service agreement for the City of Newport Beach.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><u><strong>AD 2022-06-18 Requires Replacing The Alternative Ventilation Duct Having A Certain Part Number</strong></u></h2>

The FAA is adopting a new airworthiness directive (AD) for all The Boeing Company Model 767-2C series airplanes. This AD was prompted by a report of multiple nuisance caution "RECIRC SMOKE" engine indication and crew alerting system (EICAS) messages that may occur when water accumulates in the alternative ventilation system (AVS) duct. This AD requires replacing the alternative ventilation duct having a certain part number with a new part number, and for certain airplanes, changing the insulation blanket to install the drain hose. This AD also prohibits the installation of an alternative ventilation duct, part number (P/N) 216T2101-704, on any airplane. , strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc

0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><u><strong>DJI has expanded its portfolio, stretching itself further into the business range of UAS aircraft with the new Matrice 30 Enterprise Drone</strong></u></h2>

The new system contains a range of novel equipment for DJI, like a more refined and controllable FlightHub 2 Control System for remote planning, flying, and data management for not just one drone, but a fleet of them. The DJI Dock acknowledges the level of operational independence that so many operators are hungry for, offering an automated, remotely manageable way to launch, retrieve, store, and recharge drones without any human intervention for lengthy periods of time.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h2><u><strong>Space Veteran Ends 355-Day Space Living Streak</strong></u></h2>

Mark Vande Hei ended his 355-day streak for the longest single spaceflight in history by an American, heading to Earth on March 30.&nbsp;He began making his way back home alongside a pair of Roscosmos cosmonauts Anton Shkaplerov and Pyotr Dubrov, proving that cooperation between the Russian space program and NASA can continue where it counts. The trio departed the ISS and made a safe, parachute-assisted landing in Dzhezkazgan, Kazakhstan. Vande Hei will be an interesting case study in long-duration spaceflight on humans, coming in at a fine time as the agency picks up momentum for the Artemis program.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h3><span style="color:rgb(255, 0, 0)"><strong><u>Profile Descent</u></strong></span></h3>

An uninterrupted descent (except where level flight is required for speed adjustment; e.g., 250 knots at 10,000 feet MSL) from cruising altitude/level to interception of a glideslope or to a minimum altitude specified for the initial or intermediate approach segment of a nonprecision instrument approach. The profile descent normally terminates at the approach gate or where the glideslope or other appropriate minimum altitude is intercepted.

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(<h3><strong><u><span style="color:rgb(255, 0, 0)">Aero Linx: The New Mexico Pilots Association</span></u></strong></h3>

The New Mexico Pilots Association is a grass roots organization of members with a passion for general aviation in New Mexico.&nbsp; Our mission is promoting general aviation, aviation safety, pilot camaraderie, and preservation of airfields and airspace. JOIN US! You&rsquo;ll get to know a network of pilots and aviation enthusiasts who enjoy flying, discovering new places, and having fun!&nbsp;By joining NMPA, you support aviation in New Mexico! &nbsp; NMPA provides proactive leadership on issues and concerns of interest to general aviation pilots statewide.&nbsp;

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | tagstripper(

<strong>"I've obviously been thinking about what this experience will be like for our astronauts, and to experience it myself was a joy. It was 10 times more intense than I thought it would be, or anything that I've ever experienced in my life physically, mentally, emotionally."&nbsp;</strong>

<strong>Source:</strong> Spoken by Gary Lai, the chief architect for the New Shepard NS-20&nbsp;rode upon during their recent sub-orbital space trip. He was the only unpaid ticket on the trip, generously allowed to experience his handiwork from the customers' side of the launch pad. Lai's journey as an astronaut was an emotional one.&nbsp;

, strip, h2) ] from C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc | expandFuseboxPath(parsed/) ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc | getCoreToAppRootPath() ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc | getVersion() ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxApplication.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxEvent.cfc | init([complex value], [complex value], CFC: fckeditor.fb551.fusebox5.myFusebox) ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxEvent.cfc
0 ms 0 ms 2 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc | getMyself() ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc | getSelf() ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc | init(fusebox, [complex value], [complex value]) ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc
0 ms 0 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc | trace(Fusebox, Request completed) ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.cfc
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
483 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

list (Datasource=AeroNews, Time=52ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryArchiveList.cfm @ 05:44:11.011
SELECT 
cb.ContentBlockID as id,
convert(varchar(38), cb.ContentBlockID) as myid,
cb.ContentBlockName as title,
Cast(cb.HTMLContent AS Varchar(2000)) as description, 
Cast(t.TeaserText AS Varchar(800)) as teaser,
cb.display as published,
SPACE(2) AS filelocation,
SPACE(2) as categoryid,
CAST('text' AS char(8)) as mytype,
convert(varchar(20), cb.Display, 111) AS GroupDate,
SPACE(2) AS previewimage,
cb.sortorder

FROM
	vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
	LEFT OUTER JOIN Teaser t
	ON cb.ContentBlockID = t.ContentBlockID AND t.TeaserType <> 'L'
WHERE
 		
	  Year(Display) = 2022
		AND Month(Display) = 4
		AND Day(Display) = 2
	 
	AND ct.CategoryCode LIKE 'NEWS'
	AND (cb.Status = 60 OR cb.Status = 80)
	
UNION ALL
SELECT
	videoId as id, 
	convert(varchar(38), videoId) as myid, 
	title, 
	CAST(description AS Varchar(2000)) as description, 
	Cast(teaser AS Varchar(800))as teaser,
	published,
	filelocation, 
	categoryid,
	CAST('video' AS char(8)) as mytype,
	published as GroupDate,
	previewimage,
	0 AS sortorder
	
FROM Videos
WHERE active = 1 AND approved = 1 
		AND Year(published) = 2022
		AND Month(published) = 4
		AND Day(published) = 2 

UNION ALL
SELECT 
	NewID() as id,
	CAST(episodesid AS VARCHAR(38)) as myid,
	title,
	CAST(subtitle  AS Varchar(800)) as teaser, 
	CAST(summary AS Varchar(2000)) as description,
	ApprovedDate as published,
	episodefile as filelocation, 
	podcastsid as categoryid,
	CAST('audio' AS char(8)) as mytype,
	ApprovedDate as GroupDate,
	SPACE(2) AS previewimage,
	0 AS sortorder
FROM episodes
	WHERE Approved = 1 
		AND Year(ApprovedDate) = 2022
		AND Month(ApprovedDate) = 4
		AND Day(ApprovedDate) = 2 


Order By published DESC, sortorder DESC
aYears (Datasource=AeroNews, Time=293ms, Records=23) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 05:44:11.011
SELECT DISTINCT Year(Display) as year
from vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
WHERE ct.CategoryCode LIKE 'NEWS'
	AND (cb.Status = 60 OR cb.Status = 80)
	AND Year(Display) > 2002
Order By Year(Display)
aMonths (Datasource=AeroNews, Time=46ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 05:44:11.011
SELECT DISTINCT Month(Display) as month
from vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
WHERE ct.CategoryCode LIKE 'NEWS'
		AND (cb.Status = 60 OR cb.Status = 80)
		AND Year(Display) = 2022
Order BY Month(Display)
aDays (Datasource=AeroNews, Time=44ms, Records=30) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 05:44:11.011
SELECT DISTINCT Day(Display) as days
from vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
WHERE  ct.CategoryCode LIKE 'NEWS'
	AND (cb.Status = 60 OR cb.Status = 80)
		AND Year(Display) = 2022
		AND Month(Display) = 4
qryAudio (Datasource=AeroNews, Time=8ms, Records=0) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryAudio.cfm @ 05:44:11.011
SELECT NewID() as id,
	CAST(episodesid AS VARCHAR(38)) as myid,
	title,
	CAST(subtitle  AS Varchar(800)) as teaser, 
	CAST(summary AS Varchar(2000)) as description,
	ApprovedDate as published,
	episodefile as filelocation, 
	podcastsid as categoryid,
	CAST('audio' AS char(8)) as mytype,
	ApprovedDate as GroupDate,
	SPACE(2) AS previewimage,
	0 AS sortorder
FROM episodes
	WHERE Approved = 1 
		
	AND ApprovedDate <{ts '2025-12-02 05:44:11'} ANd ApprovedDate > {ts '2025-11-28 05:44:11'} 

Order By published DESC, sortorder DESC
qryWidVideo (Datasource=AeroNews, Time=0ms, Records=3, Cached Query) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryWidVideo.cfm @ 05:44:11.011
SELECT TOP 3
videoId as id, 
	convert(varchar(38), videoId) as myid, 
	title, 
	CAST(description AS Varchar(2000)) as description, 
	Cast(teaser AS Varchar(800))as teaser,
	published,
	filelocation, 
	categoryid,
	CAST('video' AS char(8)) as mytype,
	published as GroupDate,
	previewimage,
	0 AS sortorder
	
FROM Videos
WHERE active = 1 AND approved = 1 AND published <{ts '2025-12-02 05:00:00'} 
ORDER BY published DESC
widgetsorted (Datasource=, Time=4ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actWidgets.cfm @ 05:44:11.011
SELECT *
	FROM qryWidgets
	ORDER BY sortorder
NewsCategories (Datasource=AeroNews, Time=0ms, Records=7, Cached Query) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryNewscats.cfm @ 05:44:11.011
SELECT 
			ContentTypeName, ContentTypeCode
		FROM ContentType 
		WHERE CategoryCode = 'NEWS' AND CONTENTTYPECODE <> 'ATRVNW'
		ORDER BY ContentTypeName
NewsCategories2 (Datasource=AeroNews, Time=0ms, Records=8, Cached Query) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryNewscats.cfm @ 05:44:11.011
SELECT 
			ContentTypeName, ContentTypeCode
		FROM ContentType 
		WHERE CategoryCode = 'NEWS'
		ORDER BY ContentTypeName


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=C:\inetpub\wwwroot\clients\aero-news.net\subscribe.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.aero-news.net
HTTP_REFERER=
HTTP_URL=/Subscribe.cfm?do=main.archive&month=4&year=2022
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.20.10
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\aero-news.net\subscribe.cfm
QUERY_STRING=do=main.archive&month=4&year=2022
REMOTE_ADDR=10.0.20.1
REMOTE_HOST=10.0.20.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/Subscribe.cfm
SERVER_NAME=www.aero-news.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CFID=5153217
CFTOKEN=7f15d8f266a2f1bb-B29CED4B-F93D-1900-4DD8C9B00DF43F67
Session Variables:
sessionid=DBE3AE2C82ACF964067F9A0E79B0F8AE.cfusion
urltoken=CFID=5153217&CFTOKEN=7f15d8f266a2f1bb-B29CED4B-F93D-1900-4DD8C9B00DF43F67&jsessionid=DBE3AE2C82ACF964067F9A0E79B0F8AE.cfusion
URL Parameters:
do=main.archive
month=4
year=2022
Debug Rendering Time: 30 ms