resource_type, resource_ID, shortdesc, longdesc, Rental, assoconly, NotAvailAfter, Rate, DiscountRate, equiplist Where (Not assoconly) and resource_type='A' and Rental and NotAvailAfter >= #5/11/2008# Order by Rate A N5490B C152 Cessna 152 True False 12/31/2099 83 78 A N25904 C152 Cessna 152 True False 12/31/2099 83 78 A N24895 C152 Cessna 152 True False 12/31/2099 87 82 KLN-35A -GPS A N3898Q C172 Cessna 172 True False 12/31/2099 105 99 A N733US C172 Cessna 172 True False 12/31/2099 105 99 A N5106K C172 Cessna 172 True False 12/31/2099 105 99 A N2933A PA28 Piper Warrior II True False 12/31/2099 105 99 A N2935U PA28 Piper Archer II True False 12/31/2099 119 113 A N8680E PA28R Piper Arrow 200 True False 12/31/2099 157 147 A N8350P R-22 R-22 N8350P True False 12/31/2099 210 200 A N290ND PA44-180 Piper Seminole True False 12/31/2099 225 215 King KLN89B with a KCS 55A (HSI)