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

October 02, 2021

Night Authorization Available for Part 107 Drone Pilots

'Provides A Permanent Solution For Part 107 Drone Pilots To Operate In Controlled Airspace At Night'

The capabilities of licensed drone operators are taking another leap forward with the news that the FAA is allowing for night operations via the LAANC authorization process... which continues to mature. Drone pilots with current Part 107 Remote Pilot Certificates may now obtain near real-time authorizations to fly at night through FAA-approved providers of Low Altitude Authorization and Notification Capability (LAANC) services. LAANC is an automated system for drone pilots requesting to fly below 400 feet in controlled airspace often found around airports. Drone pilots need FAA approval prior to flying in controlled airspace.

Read More

Sealand, RED Aircraft Anticipate First Flight

Timescale To Determine If Test Flight Will Be On Floats Or Wheels

Sealand Aviation of Campbell River, BC, anticipates the first flight of their modified DHC-2 Beaver. One of their De Havilland Beavers has been outfitted with the RED A03 engine developed by RED Aircraft in Germany. The RED A03 is now undergoing checks and calibration and has already been fixed to the airframe. The next steps include the aircraft undergoing further maintenance such as custom-made cowling and the installation of the Full Authority Digital Engine Control.

Read More

Boeing’s Chinook Celebrates 60 Years of Flight

Continued Development Shows Promise For 40 More Years

Boeing and Chinook operators celebrate 60 years of Chinook flight as the company builds a new generation of the renowned rotorcraft. September 21, 1961 marked the day the first flight of the aircraft took off from Philadelphia. Since then, Boeing has continued operations for development and improvement of this aircraft at this location. The Chinooks have a rich history, serving as a backbone for combat, logistics and humanitarian missions for the Army, Special Operations Forces and 19 international operators. Continued development shows promise for the Chinooks to stay in service at least 40 more years.

Read More

Classic Aero-TV: Kyle Franklin -- Acro Flying With Showmanship

From 2014: One Of the Airshow Industry's Most Creative Performers Talks Shop With ANN

While at EAA AirVenture 2014, ANN News Editor Tom Patton caught up with Kyle Franklin at the Concorde Battery display booth. Patton has been checking up on the health of the airshow industry and he asked Franklin to give his views. Franklin indicated that, in his opinion, the industry is coming back from the doldrums it was in last year. Franklin ranks as one of the most popular performers because of the type of routines he performs and the airplane

Read More

New Software Eliminates Taxi Delays

Improved Traffic Management Saves Time, Fuel for Operators

The FAA has announced its new traffic control software aimed at minimizing ground delays in airports across the country. The system is only one component of the upcoming Terminal Flight Data Manager Program, but expected to roll out independently in test locations in the near future. Using this software, an aircraft will be able to arrive with minimal delay, land, taxi directly to a gate, and push back for takeoff, all without lengthy waiting times on the taxiway. 

Read More

NTSB Prelim: Bulfer James G Genesis

Airplane Was On The Base Leg Of The Traffic Pattern When The Engine Lost Power

On September 6, 2021, about 1100 central daylight time, a SlipStream Genesis light sport airplane, N105BJ, was substantially damaged when it was involved in an accident near Fairmont, Minnesota. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. The pilot stated that he originally built this airplane and has been the only owner. On the accident flight, the airplane was on the base leg of the traffic pattern when the engine lost power. He was unable to maintain altitude and descended into trees. The airplane came to rest in the trees about 30 ft high.

Read More

Advertisement

AD: RUAG Aerospace Services GmbH

AD 2021-19-06 Requires Inspecting Certain Carbon Brake Assemblies And Corrective Actions If Necessary

The FAA is superseding Airworthiness Directive (AD) 2007-02-13, which applied to certain Dornier Luftfahrt GmbH (type certificate currently held by RUAG Aerospace Services GmbH) Model Dornier 228-212 airplanes.  AD 2007-02-13 required inspecting the landing gear carbon brake assembly. This AD requires inspecting certain carbon brake assemblies and corrective actions if necessary. This AD was prompted by mandatory continuing airworthiness information (MCAI) issued by the European Union Aviation Safety Agency (EASA) to correct an unsafe condition on an aviation product. The MCAI identifies the unsafe condition as loose bolts and nuts on th

Read More

AD: Hélicoptères Guimbal Helicopters

AD 2021-19-07 Requires Replacing An Affected MR Non-Rotating Scissor Link With A Serviceable Part

The FAA is adopting a new airworthiness directive (AD) for certain Hélicoptères Guimbal Model CABRI G2 helicopters. This AD was prompted by a report that, during scheduled maintenance on two helicopters, cracks were found on a certain main rotor (MR) non-rotating scissor link. This AD requires replacing an affected MR non-rotating scissor link with a serviceable part. The FAA is issuing this AD to address the unsafe condition on these products. This AD is effective November 4, 2021. The Director of the Federal Register approved the incorporation by reference of a certain document listed in this AD as of November 4, 2021.

Read More

ANN's Daily Aero-Linx (10.02.21)

Aero Linx: Centennial of Flight Commission On Dec. 17, 1903, at 10:35 a.m., two brothers driven by tenacity, creativity and courage completed the world's first successful powered, heavier-than-air flight at Kill Devil Hills, N.C. for a 12-second, 120-foot journey. A new industry was born and a new way of life followed closely behind. The Wright brothers accomplished what people had only imagined since the beginning of time. The national "Centennial of Flight: Born of Dreams - Inspired by Freedom" celebration commemorates this achievement and 100 years of aviation history.

Read More

ANN's Daily Aero-Term (10.02.21): Obstacle Departure Procedure (ODP)

Obstacle Departure Procedure (ODP) A preplanned instrument flight rule (IFR) departure procedure printed for pilot use in textual or graphic form to provide obstruction clearance via the least onerous route from the terminal area to the appropriate en route structure. ODPs are recommended for obstruction clearance and may be flown without ATC clearance unless an alternate departure procedure (SID or radar vector) has been specifically assigned by ATC.

Read More

Aero-News: Quote of the Day (10.02.21)

“The mighty Chinook continues to be the most advanced, affordable and battle-tested heavy-lift helicopter in the world. This aircraft is positioned to fly for at least 100 years, and that’s a testament to the enduring partnership of Boeing, its industry partners and Chinook users across the globe.” Source: Andy Builta, Boeing vice president and H-47 program manager, celebrating the  60th year of Chinook flight as the company builds a new generation of the renowned rotorcraft. September 21, 1961 marked the day the first flight of the aircraft took off from Philadelphia. Since then, Boeing has continued operations for development and improvement of this aircraft at this location.

Read More




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:48 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
480 ms 480 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/parsed/main.archive.cfm
480 ms 480 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
377 ms 377 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/actArchive-v.cfm
63 ms 63 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryArchiveList.cfm
14 ms 14 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/model/main/qryAudio.cfm
8 ms 8 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/model/main/actWidgets.cfm
4 ms 4 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
2 ms 2 ms 1 C:/inetpub/wwwroot/clients/aero-news.net/view/layout/dspWidgets.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/view/display/dspArchive-v.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 1 ms 1 CFC[ C:/inetpub/wwwroot/clients/aero-news.net/components/utils.cfc | lastdayofMonth(10) ] 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/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 | init(fusebox, [complex value], [complex value]) ] from C:/inetpub/wwwroot/clients/aero-news.net/fb551/fusebox5/myFusebox.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/qryNewscats.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/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 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 | tagstripper(<h2><a href="https://youtu.be/dl_jT5F82AM"><u><strong><span style="color:rgb(0, 0, 255)">From 2014:</span></strong></u></a> <u><strong><a href="https://youtu.be/dl_jT5F82AM"><span style="color:rgb(0, 0, 255)">One Of the Airshow Industry's Most Creative Performers Talks Shop With ANN</span></a></strong></u></h2>

While at EAA AirVenture 2014, ANN News Editor Tom Patton caught up with Kyle Franklin at the Concorde Battery display booth. Patton has been checking up on the health of the airshow industry and he asked Franklin to give his views. Franklin indicated that, in his opinion, the industry is coming back from the doldrums it was in last year. Franklin ranks as one of the most popular performers because of the type of routines he performs and the 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>'Provides A Permanent Solution For Part 107 Drone Pilots To Operate In Controlled Airspace At Night'</strong></u></h2>

The capabilities of licensed drone operators are taking another leap forward with the news that the FAA is allowing for night operations via the LAANC authorization process... which continues to mature. Drone pilots with current Part 107 Remote Pilot Certificates may now obtain near real-time authorizations to fly at night through FAA-approved providers of Low Altitude Authorization and Notification Capability (LAANC) services. LAANC is an automated system for drone pilots requesting to fly below 400 feet in controlled airspace often found around airports. Drone pilots need FAA approval prior to flying in controlled airspace.

, 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 2021-19-06 Requires Inspecting Certain Carbon Brake Assemblies And Corrective Actions If Necessary</strong></u></h2>

The FAA is superseding Airworthiness Directive (AD) 2007-02-13, which applied to certain Dornier Luftfahrt GmbH (type certificate currently held by RUAG Aerospace Services GmbH) Model Dornier 228-212 airplanes.&nbsp;&nbsp;AD 2007-02-13 required inspecting the landing gear carbon brake assembly. This AD requires inspecting certain carbon brake assemblies and corrective actions if necessary. This AD was prompted by mandatory continuing airworthiness information (MCAI) issued by the European Union Aviation Safety Agency (EASA) to correct an unsafe condition on an aviation product. The MCAI identifies the unsafe condition as loose bolts and nuts on th, 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 2021-19-07 Requires Replacing An Affected MR Non-Rotating Scissor Link With A Serviceable Part</strong></u></h2>

The FAA is adopting a new airworthiness directive (AD) for certain H&eacute;licopt&egrave;res Guimbal Model CABRI G2 helicopters. This AD was prompted by a report that, during scheduled maintenance on two helicopters, cracks were found on a certain main rotor (MR) non-rotating scissor link. This AD requires replacing an affected MR non-rotating scissor link with a serviceable part. The FAA is issuing this AD to address the unsafe condition on these products. This AD is effective November 4, 2021. The Director of the Federal Register approved the incorporation by reference of a certain document listed in this AD as of November 4, 2021.

, 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>Airplane Was On The Base Leg Of The Traffic Pattern When The Engine Lost Power</strong></u></h2>

On September 6, 2021, about 1100 central daylight time, a SlipStream Genesis light sport airplane, N105BJ, was substantially damaged when it was involved in an accident near Fairmont, Minnesota. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91 personal flight. The pilot stated that he originally built this airplane and has been the only owner. On the accident flight, the airplane was on the base leg of the traffic pattern when the engine lost power. He was unable to maintain altitude and descended into trees. The airplane came to rest in the trees about 30 ft high.

, 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>Continued Development Shows Promise For 40 More Years</strong></u></h2>

Boeing and Chinook operators celebrate 60 years of Chinook flight as the company builds a new generation of the renowned rotorcraft. September 21, 1961 marked the day the first flight of the aircraft took off from Philadelphia. Since then, Boeing has continued operations for development and improvement of this aircraft at this location. The Chinooks have a rich history, serving as a backbone for combat, logistics and humanitarian missions for the Army, Special Operations Forces and 19 international operators. Continued development shows promise for the Chinooks to stay in service at least 40 more years.

, 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>Improved Traffic Management Saves Time, Fuel for Operators</strong></u></h2>

The FAA has announced its new traffic control software aimed at minimizing ground delays in airports across the country. The system is only one component of the upcoming Terminal Flight Data Manager Program, but expected to roll out independently in test locations in the near future. Using this software, an aircraft will be able to arrive with minimal delay, land, taxi directly to a gate, and push back for takeoff, all without lengthy waiting times on the taxiway.&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>Timescale To Determine If Test Flight Will Be On Floats Or Wheels</strong></u></h2>

Sealand Aviation of Campbell River, BC, anticipates the first flight of their modified DHC-2 Beaver. One of their De Havilland Beavers has been outfitted with the RED A03 engine developed by RED Aircraft in Germany.&nbsp;The RED A03 is now undergoing checks and calibration and has already been fixed to the airframe. The next steps include the aircraft undergoing further maintenance such as custom-made cowling and the installation of the Full Authority Digital Engine Control.

, 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>Obstacle Departure Procedure (ODP)</u></strong></span></h3>

A preplanned instrument flight rule (IFR) departure procedure printed for pilot use in textual or graphic form to provide obstruction clearance via the least onerous route from the terminal area to the appropriate en route structure. ODPs are recommended for obstruction clearance and may be flown without ATC clearance unless an alternate departure procedure (SID or radar vector) has been specifically assigned by ATC.

, 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: Centennial of Flight Commission</span></u></strong></h3>

On Dec. 17, 1903, at 10:35 a.m., two brothers driven by tenacity, creativity and courage completed the world's first successful powered, heavier-than-air flight at Kill Devil Hills, N.C. for a 12-second, 120-foot journey. A new industry was born and a new way of life followed closely behind. The Wright brothers accomplished what people had only imagined since the beginning of time. The national "Centennial of Flight: Born of Dreams - Inspired by Freedom" celebration commemorates this achievement and 100 years of aviation history.

, 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 mighty Chinook continues to be the most advanced, affordable and battle-tested heavy-lift helicopter in the world. This aircraft is positioned to fly for at least 100 years, and that&rsquo;s a testament to the enduring partnership of Boeing, its industry partners and Chinook users across the globe.&rdquo;</strong>

<strong>Source:&nbsp;</strong>Andy Builta, Boeing vice president and H-47 program manager, celebrating the &nbsp;60th year of Chinook flight as the company builds a new generation of the renowned rotorcraft. September 21, 1961 marked the day the first flight of the aircraft took off from Philadelphia. Since then, Boeing has continued operations for development and improvement of this aircraft at this location.

, 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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
487 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

list (Datasource=AeroNews, Time=62ms, Records=11) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryArchiveList.cfm @ 05:48:25.025
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) = 2021
		AND Month(Display) = 10
		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) = 2021
		AND Month(published) = 10
		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) = 2021
		AND Month(ApprovedDate) = 10
		AND Day(ApprovedDate) = 2 


Order By published DESC, sortorder DESC
aYears (Datasource=AeroNews, Time=254ms, Records=23) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 05:48:25.025
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=50ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 05:48:25.025
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) = 2021
Order BY Month(Display)
aDays (Datasource=AeroNews, Time=70ms, Records=31) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actArchive-v.cfm @ 05:48:25.025
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) = 2021
		AND Month(Display) = 10
qryAudio (Datasource=AeroNews, Time=13ms, Records=0) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\qryAudio.cfm @ 05:48:25.025
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:48:25'} ANd ApprovedDate > {ts '2025-11-28 05:48:25'} 

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:48:25.025
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=3ms, Records=12) in C:\inetpub\wwwroot\clients\aero-news.net\model\main\actWidgets.cfm @ 05:48:25.025
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:48:25.025
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:48:25.025
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=CFTOKEN=35d3b42325f6ed51-B2C3753C-B28D-958A-7C15BAEC9946995E; JSESSIONID=B0073B9286C81BCF7BE40BF6AE2F1BB2.cfusion; CFID=5153915
HTTP_HOST=www.aero-news.net
HTTP_REFERER=http://www.aero-news.net/Subscribe.cfm?do=main.archive&month=10&year=2021
HTTP_URL=/Subscribe.cfm?do=main.archive&month=10&year=2021
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=10&year=2021
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=5153915
CFTOKEN=35d3b42325f6ed51-B2C3753C-B28D-958A-7C15BAEC9946995E
JSESSIONID=B0073B9286C81BCF7BE40BF6AE2F1BB2.cfusion
Session Variables:
sessionid=B0073B9286C81BCF7BE40BF6AE2F1BB2.cfusion
urltoken=CFID=5153915&CFTOKEN=35d3b42325f6ed51-B2C3753C-B28D-958A-7C15BAEC9946995E&jsessionid=B0073B9286C81BCF7BE40BF6AE2F1BB2.cfusion
URL Parameters:
do=main.archive
month=10
year=2021
Debug Rendering Time: 24 ms