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

January 02, 2023

Airport Worker Killed in Horrific Ramp Accident

Montgomery Regional Airport (MGM) Tragedy Under Investigation

A baggage handler in the employ of Piedmont Airlines—a wholly owned subsidiary of American Airlines group—lost his life on 31 December 2022 after reportedly being ingested into the operating turbine engine of an Embraer E175LR regional jet parked on the ramp of Alabama’s Montgomery Regional Airport (MGM).

Read More

Vertical Landing F-35 Temporarily Grounded

Recent High Profile Crash Brings Attention to F-35B Program

A widely shared and watched clip of an F-35B's SNAFU has resulted in a temporary halt to flight operations as the F-35 Joint Program Office investigates the mishap. The crash was an odd one, catching the attention of many as yet another apparent misstep in a highly expensive fighter program. The aircraft, landing at the Naval Air Station Joint Reserve Base Fort Worth, Texas, ended its flight with a slow, seemingly languid crash that caught the attention of legions of untrained civilian eyes. 

Read More

ANN Wishes Our Readers, Listeners And Viewers VERY Happy Holidays!

Happy Holidays!

No matter which holiday you're celebrating these days (and believe me, we're covered back here at ANN... with a diverse variety of Christian, Jewish and Buddhists among our families, these days). The hard-working and long-suffering gnomes that publish ANN, Airborne, and Aero-TV will finally get to take a short holiday break this week [we gnomes thank you --ed]. ANN's normal DAILY news schedule will be on a somewhat reduced Holiday schedule, through the 2nd of January.

Read More

Leonardo tenders first AW 169 to Austrian MoD

Order Doubled from 18 to 36 to Replace 60's-Era Alouette IIIS

The first of 18 AW169M helicopters was delivered to the Austrian Ministry of Defense, building on a burgeoning Italian/Austrian collaboration for the LUH program. Options for another 18 helicopters have been exercised in the framework of the country's G2G initiative, an agreement aimed at reinforcing the collaboration between the two countries while establishing a strategic partnership in the rotorcraft sector.

Read More

Klyde Morris (12.31.22)

Klyde's Not A Big Fan of Activists Targeting Aviation

FMI: www.klydemorris.com

Read More

Classic Aero-TV: EAA Night Airshow--Lighting up the Night Sky at AirVenture 2011

From 2011 (YouTube Version): A Spectacular Way To End Aviation's Big Week

There are some things that are very difficult to describe. The night airshow which has capped off the last two years at AirVenture at Oshkosh is one of those things that almost has to be seen to be fully appreciated. Fortunately, Aero-TV was there to capture the airshow on the final day of this year's EAA gathering. So what were some of the reactions we got from people who saw the show?  "It's just the coolest thing ever."

Read More

Advertisement

NTSB Report: Storch Replica Collision at October Air Show

Location: Houston, Texas Accident Number: CEN23LA023 Date & Time: Oct 29, 2022 Aircraft: MS-500 Morane-Saulnier (French-Built Fiesler Storch) Registration: N778MS  Event: Ground Collision Injuries: 1 Minor Flight Conducted Under: Part 91, Air Race/Show Another NTSB investigation has covered a recent “D’oh!” moment at a Houston airshow, where an MS-500 (similar to a Storch) pilot forgot to complete his shutdown checklist after an unsuccessful attempt to start the engine. 

Read More

AD: Airbus SAS Airplanes

AD 2022-27-01 Requires Replacing Affected Fasteners And Applying Additional Head Nut Cap Protection...

The FAA is adopting a new airworthiness directive (AD) for certain Airbus SAS Model A350-941 and -1041 airplanes. This AD is prompted by a report that during flight and fatigue testing it was detected that some fasteners installed in the center wing box (CWB) rotated inside their fastener holes. This AD requires replacing affected fasteners and applying additional head nut cap protection at the front and rear spars in the CWB, as specified in a European Union Aviation Safety Agency (EASA) AD, which is incorporated by reference. The FAA is issuing this AD to address the unsafe condition on these products. This AD is effective February 2, 2023

Read More

AD: Dassault Aviation Airplanes

AD 2022-27-05 Was Prompted By A Determination That Replacing Certain Brake Servo-Valves Is Necessary

The FAA is superseding Airworthiness Directive (AD) 2022-09-15, which applied to all Dassault Aviation Model FALCON 2000 and FALCON 2000EX airplanes. AD 2022-09-15 required relocating affected servo-valves and revising the existing airplane flight manual (AFM) to provide temporary information necessary to operate airplanes fitted with at least one affected brake servo-valve. AD 2022-09-15 also limited or prohibited the installation of affected brake servo-valves.

Read More

ANN's Daily Aero-Linx (01.02.23)

Aero Linx: The International Cessna 120-140 Association The International Cessna 120-140 Association is an all volunteer group of approximately 1,000 owners, pilots and others who share a common interest in restoring, maintaining and flying the Models 120, 140 and 140A aircraft manufactured by the Cessna Aircraft Company in 1946-1951. Though over sixty years old, these aircraft provide a combination of performance, ease and economy of operation and maintenance unmatched by many currently produced aircraft.

Read More

ANN's Daily Aero-Term (01.02.23): Automatic Carrier Landing System

Automatic Carrier Landing System U.S. Navy final approach equipment consisting of precision tracking radar coupled to a computer data link to provide continuous information to the aircraft, monitoring capability to the pilot, and a backup approach system.

Read More

Aero-News: Quote of the Day (01.02.23)

“The F-35 Joint Program Office has issued a Time Compliance Technical Directive (TCTD) to restrict some aircraft, which have been evaluated to be of higher risk, from flight operations while the investigation into the mishap on December 15 continues and until procedures can be developed for their return to flight,” the JPO said. “The affected aircraft have been identified, and the JPO will work with services and partners to ensure compliance with the TCTD.” Source: From a statement made as a widely shared and watched clip of an F-35B's SNAFU has resulted in a temporary halt to flight operations as the F-35 Joint Program Office investigates the mishap. 

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 /index.cfm
Time Stamp 02-Dec-25 04:30 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
7991 ms 7991 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/parsed/main.archive.cfm
7991 ms 7991 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onRequest(/index.cfm) ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc
6663 ms 6663 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/actArchive-v.cfm
1310 ms 1310 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryArchiveList.cfm
5 ms 5 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/display/dspArchiveList.cfm
4 ms 4 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onRequestStart(/index.cfm) ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc
3 ms 3 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/actWidgets.cfm
3 ms 3 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/dspWidgets.cfm
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/qryWidVideo.cfm
1 ms 1 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/display/dspArchive-v.cfm
1 ms 1 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/Application.cfc | onRequestEnd(/index.cfm) ] from C:/inetpub/wwwroot/clients/aero-news.net/Application.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
1 ms 1 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
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/qryAudio.cfm
0 ms 0 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryNewscats.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/dspSidebar.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 11 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | RandomNumber() ] 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 | lastdayofMonth(1) ] 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(<div id="teaser"> <h2><u><strong>Happy Holidays!</strong></u></h2>

No matter which holiday you're celebrating these days (and believe me, we're covered back here at ANN... with a diverse variety of Christian, Jewish and Buddhists among our families, these days). The hard-working and long-suffering gnomes that publish ANN, Airborne, and Aero-TV will finally get to take a short holiday break this week [we gnomes thank you --ed]. ANN's normal DAILY news schedule will be&nbsp;on a somewhat reduced Holiday schedule,&nbsp;through the&nbsp;2nd of January.

</div>, 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><a href="https://youtu.be/Aou2NJTBDWk" target="_blank"><span style="color: rgb(0, 0, 255);">From 2011 (YouTube Version):&nbsp;A Spectacular Way To End Aviation's Big Week</span></a></h2>

There are some things that are very difficult to describe. The night airshow which has capped off the last two years at AirVenture at Oshkosh is one of those things that almost has to be seen to be fully appreciated.&nbsp;Fortunately, Aero-TV was there to capture the airshow on the final day of this year's EAA gathering. So what were some of the reactions we got from people who saw the show?&nbsp;

"It's just the coolest thing ever."

, 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>Montgomery Regional Airport (MGM) Tragedy Under Investigation</u></strong></h2>

A baggage handler in the employ of Piedmont Airlines&mdash;a wholly owned subsidiary of American Airlines group&mdash;lost his life on 31 December 2022 after reportedly being ingested into the operating turbine engine of an Embraer E175LR regional jet parked on the ramp of Alabama&rsquo;s Montgomery Regional Airport (MGM).

, 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>Order Doubled from 18 to 36 to Replace 60's-Era Alouette IIIS</u></strong></h2>

The first of 18 AW169M helicopters was delivered to the Austrian Ministry of Defense, building on a burgeoning Italian/Austrian collaboration for the LUH program.&nbsp;Options for another 18 helicopters have been exercised in the framework of the country's G2G initiative, an agreement aimed at reinforcing the collaboration between the two countries while establishing a strategic partnership in the rotorcraft sector.

, 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>Recent High Profile Crash Brings Attention to F-35B Program</u></strong></h2>

A widely shared and watched clip of an F-35B's SNAFU has resulted in a temporary halt to flight operations as the F-35 Joint Program Office investigates the mishap.&nbsp;The crash was an odd one, catching the attention of many as yet another apparent misstep in a highly expensive fighter program. The aircraft, landing at the Naval Air Station Joint Reserve Base Fort Worth, Texas, ended its flight with a slow, seemingly languid crash that caught the attention of legions of untrained civilian eyes.&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><u><strong>AD 2022-27-01 Requires Replacing Affected Fasteners And Applying Additional Head Nut Cap Protection...</strong></u></h2>

The FAA is adopting a new airworthiness directive (AD) for certain Airbus SAS Model A350-941 and -1041 airplanes.&nbsp;This AD is prompted by a report that during flight and fatigue testing it was detected that some fasteners installed in the center wing box (CWB) rotated inside their fastener holes. This AD requires replacing affected fasteners and applying additional head nut cap protection at the front and rear spars in the CWB, as specified in a European Union Aviation Safety Agency (EASA) AD, which is incorporated by reference. The FAA is issuing this AD to address the unsafe condition on these products. This AD is effective February 2, 2023, 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-27-05 Was Prompted By A Determination That Replacing Certain Brake Servo-Valves Is Necessary</strong></u></h2>

The FAA is superseding Airworthiness Directive (AD) 2022-09-15, which applied to all Dassault Aviation Model FALCON 2000 and FALCON 2000EX airplanes.&nbsp;AD 2022-09-15 required relocating affected servo-valves and revising the existing airplane flight manual (AFM) to provide temporary information necessary to operate airplanes fitted with at least one affected brake servo-valve. AD 2022-09-15 also limited or prohibited the installation of affected brake servo-valves.

, 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>Klyde's Not A Big Fan of Activists Targeting Aviation</strong></u></h2> <h6><strong>FMI: <a href="http://www.klydemorris.com"><span style="color:rgb(0, 0, 255)">www.klydemorris.com</span></a></strong></h6>, 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>Automatic Carrier Landing System</u></strong></span></h3>

U.S. Navy final approach equipment consisting of precision tracking radar coupled to a computer data link to provide continuous information to the aircraft, monitoring capability to the pilot, and a backup approach system.

, 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 International Cessna 120-140 Association</span></u></strong></h3>

The International Cessna 120-140 Association is an all volunteer group of approximately 1,000 owners, pilots and others who share a common interest in restoring, maintaining and flying the Models 120, 140 and 140A aircraft manufactured by the Cessna Aircraft Company in 1946-1951. Though over sixty years old, these aircraft provide a combination of performance, ease and economy of operation and maintenance unmatched by many currently produced aircraft.

, 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>&ldquo;The F-35 Joint Program Office has issued a Time Compliance Technical Directive (TCTD) to restrict some aircraft, which have been evaluated to be of higher risk, from flight operations while the investigation into the mishap on December 15 continues and until procedures can be developed for their return to flight,&rdquo; the JPO said. &ldquo;The affected aircraft have been identified, and the JPO will work with services and partners to ensure compliance with the TCTD.&rdquo;</strong>

<strong>Source:</strong> From a statement made as a widely shared and watched clip of an F-35B's SNAFU has resulted in a temporary halt to flight operations as the F-35 Joint Program Office investigates the mishap.&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>Location:</strong> Houston, Texas<br /> <strong>Accident Number:</strong> CEN23LA023<br /> <strong>Date &amp; Time:</strong> Oct 29, 2022<br /> <strong>Aircraft:</strong> MS-500 Morane-Saulnier (French-Built Fiesler&nbsp;Storch)<br /> <strong>Registration:</strong> N778MS&nbsp;<br /> <strong>Event:</strong> Ground Collision<br /> <strong>Injuries:</strong> 1 Minor<br /> <strong>Flight Conducted Under:</strong> Part 91, Air Race/Show

Another NTSB investigation has covered a recent &ldquo;D&rsquo;oh!&rdquo; moment at a Houston airshow, where an MS-500 (similar to a Storch)&nbsp;pilot forgot to complete his shutdown checklist after an unsuccessful attempt to start the engine.&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/fuseboxAction.cfc | getAccess() ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/fuseboxAction.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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
7999 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

list (Datasource=AeroNews, Time=1310ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryArchiveList.cfm @ 04:30:50.050
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) = 2023
		AND Month(Display) = 1
		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) = 2023
		AND Month(published) = 1
		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) = 2023
		AND Month(ApprovedDate) = 1
		AND Day(ApprovedDate) = 2 


Order By published DESC, sortorder DESC
aYears (Datasource=AeroNews, Time=4266ms, Records=23) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 04:30:54.054
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=1239ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 04:30:56.056
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) = 2023
Order BY Month(Display)
aDays (Datasource=AeroNews, Time=1157ms, Records=31) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 04:30:57.057
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) = 2023
		AND Month(Display) = 1
qryAudio (Datasource=AeroNews, Time=0ms, Records=0, Cached Query) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryAudio.cfm @ 04:30:57.057
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 04:30:49'} ANd ApprovedDate > {ts '2025-11-28 04:30:49'} 

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 @ 04:30:57.057
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 04:00:00'} 
ORDER BY published DESC
widgetsorted (Datasource=, Time=2ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actWidgets.cfm @ 04:30:57.057
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 @ 04:30:57.057
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 @ 04:30:57.057
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\index.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://www.aero-news.net/index.cfm?do=main.archive&month=1&year=2023
HTTP_URL=/index.cfm?do=main.archive&month=1&year=2023
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\index.cfm
QUERY_STRING=do=main.archive&month=1&year=2023
REMOTE_ADDR=10.0.20.1
REMOTE_HOST=10.0.20.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.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=5141409
CFTOKEN=fe71ebab93c52acc-AFFD51CF-A41F-DBF9-1341721E160BD325
Session Variables:
sessionid=67D0ED0AD02085BB38EEEA7AAA0CD9E4.cfusion
urltoken=CFID=5141409&CFTOKEN=fe71ebab93c52acc-AFFD51CF-A41F-DBF9-1341721E160BD325&jsessionid=67D0ED0AD02085BB38EEEA7AAA0CD9E4.cfusion
URL Parameters:
do=main.archive
month=1
year=2023
Debug Rendering Time: 28 ms