resource_type, resource_ID, shortdesc, longdesc, Rental, tdh_spot, NotAvailAfter, DiscountRate, Rate, PrepayRate, note Where resource_type='A' and Rental and tdh_spot <> 'A' and NotAvailAfter >= #8/7/2008# Order by longdesc A N2132W C172SP 2003 172SP N2132W True 1 12/31/2099 159 169 144 A N2135S C172SP 2003 172SP N2135S True 1 12/31/2099 159 169 144 A N21527 C172SP 2003 172SP N21527 True 1 12/31/2099 159 169 144 A Hawk AST AST Hawk Flight Simulator True 1 12/31/2099 55 65 45 A N6245N C182TG1000 C182T G1000 N6245N True 1 12/31/2099 250 265 240 A N2163M C206G1000 C206G1000 N2163M True 1 12/31/2099 295 315 275 A N2458M C172G1000 N2458M C172G1000 True 1 12/31/2099 169 179 155 A N6026P C172G1000 N6026P C172G1000 True 1 12/31/2099 169 179 155 A N658RA Baron B58 N658RA Beech Baron B58 True 1 12/31/2099 600 650 550 A N727LF Seminole N727LF Seminole True 1 12/31/2099 270 280 260 A N9947C C182RG N9947C Cessna 182 RG True 1 12/31/2099 195 205 185 A N659MA SuperD SuperD Decathlon N659MA True 1 12/31/2099 160 170 150 A N14513 CT182TG1000 Turbo 182T G1000 N14513 True 1 12/31/2099 250 265 240