Query
Template: /tires/queries.cfc:204
Execution Time: 50.3 ms
Record Count: 20
Cached: No
Lazy: No
SQL:
SELECT ts.intTireSpecID
,ts.intTireID
,ts.intAccountID
,ts.intBrandID
,ts.intTireImageID
,ts.vchrPartNumber
,ts.vchrName
,b.vchrName as brandName
,ts.vchrQuickDraw
,ts.vchrSize
,ts.vchrSideWall
,ts.decDiameter
,ts.decSectWidth
,ts.decAspectRatio
,ts.decDiameterInch
,ts.decWidthInch
,ts.vchrSpeedRating
,ts.chrType
,ts.chrLoadRange
,ts.intLoadIndex
,ts.decWeight
,ts.decHeight
,ts.vchrTreadDepth
,ts.decOverDiameter
,ts.vchrRimRange
,ts.vchrTreadConstruction
,ts.vchrSideConstruction
,ts.decDynomicBalanceOz
,ts.vchrSideWall
,ts.vchrWarranty
,ts.decWidth
,ts.decLenth
,ts.intMaxLoad
,ts.vchrMaxPSI
,ts.dtCreatedUpdated
FROM tbl_TireSpec ts WITH (NOLOCK)
INNER JOIN tbl_brand b ON ts.intBrandID = b.intID
INNER JOIN tbl_brandConfig bc ON bc.intBrandID = b.intID
WHERE ts.intTireID = 3108
AND bc.intConfigID = 404
ORDER BY decDiameter, vchrPartNumber
intTireSpecIDintTireIDintAccountIDintBrandIDintTireImageIDvchrPartNumbervchrNamebrandNamevchrQuickDrawvchrSizevchrSideWalldecDiameterdecSectWidthdecAspectRatiodecDiameterInchdecWidthInchvchrSpeedRatingchrTypechrLoadRangeintLoadIndexdecWeightdecHeightvchrTreadDepthdecOverDiametervchrRimRangevchrTreadConstructionvchrSideConstructiondecDynomicBalanceOzvchrWarrantydecWidthdecLenthintMaxLoadvchrMaxPSIdtCreatedUpdated
16163173108172540RFAT26565R17GRIPPER A/TFuel Tires265/65R17Blackwall1726565T11646.301330.57.5-9.5 055000002756{ts '2023-10-02 12:58:41'}
26163223108172540RFAT26570R17GRIPPER A/TFuel TiresLT265/70R17Blackwall1726570121/118SE/10PR022.301631.77.0-8.0-8.52P+2S+2N0 55000000319580PSI{ts '2023-10-02 12:58:41'}
36163243108172540RFAT28570R17GRIPPER A/TFuel TiresLT285/70R17Blackwall1728570121/118SE/10PR025.5016.332.87.5-8.5-10.02P+2S+2N0 5.55000000319580PSI{ts '2023-10-02 12:58:41'}
46163193108172540RFAT371250R17GRIPPER A/TFuel Tires37X12.50-17Blackwall1732012.5Q12980.4701736.88.5-11.0 050000004080{ts '2023-10-02 12:58:41'}
56163333108172540RFAT26560R18GRIPPER A/TFuel Tires265/60R18Blackwall1826560114TXL020.101330.57.5-8.0-9.52P+2S+2N2P 55500000260144PSI{ts '2023-10-02 12:58:42'}
66163233108172540RFAT27565R18GRIPPER A/TFuel TiresP275/65R18Blackwall1827565114TSTD018.201332.17.5-8.0-9.02P+2S+1N0 55500000260136PSI{ts '2023-10-02 12:58:41'}
76163273108172540RFAT28565R18GRIPPER A/TFuel TiresLT285/65R18Blackwall1828565125/122SE/10PR03201732.68.0-8.5-10.02P+2S+2N0 5.55000000364080PSI{ts '2023-10-02 12:58:41'}
86163253108172540RFAT29570R18GRIPPER A/TFuel TiresLT295/70R18Blackwall1829570129/126SE/10PR029.8016.334.37.5-8.5-10.03P+2S+2N0 5.55000000408080PSI{ts '2023-10-02 12:58:41'}
96163343108172540RFAT26550R20GRIPPER A/TFuel Tires265/50R20Blackwall2026555112SE/10PR042.5501330.58.0-9.0-10.02P+2S+2N0 5.5000247065PSI{ts '2023-10-02 12:58:42'}
106163293108172540RFAT27555R20GRIPPER A/TFuel Tires275/55R20Blackwall2027555117SXLXL021.801331.97.5-8.5-9.52P+2S+2N0 55500000283342PSI{ts '2023-10-02 12:58:41'}
116163263108172540RFAT28555R20GRIPPER A/TFuel TiresLT285/55R20Blackwall2028555124/121SE/10PR027.601632.48.0-9.0-10.02P+2S+2N0 5.55000000352580PSI{ts '2023-10-02 12:58:41'}
126163353108172540RFAT28565R20GRIPPER A/TFuel Tires285/65R20Blackwall2028555127SE/10PR12772.7501734.68.5-9.5-11.02P+2S+2N0 5.5000386080PSI{ts '2023-10-02 12:58:42'}
136163283108172540RFAT30555R20GRIPPER A/TFuel TiresLT305/55R20Blackwall2030555121/118SE/10PR031.8016.333.28.5-9.5-11.02P+2S+2N0 5.55000000319565PSI{ts '2023-10-02 12:58:41'}
146163213108172540RFAT32560R20GRIPPER A/TFuel TiresLT325/60R20(35X12.50R20)Blackwall2032560126/123RE/10PR034.201734.89.0-9.5-12.03P+2S+2N0 65000000374065PSI{ts '2023-10-02 12:58:41'}
156163183108172540RFAT351250R20GRIPPER A/TFuel Tires35X12.50R20Blackwall2032012.5R12134.201734.89.5-12.0 05000000319580PSI{ts '2023-10-02 12:58:41'}
166163363108172540RFAT371250R20GRIPPER A/TFuel Tires37X12.50-20Blackwall2032055128QF/12PR079.3701736.87.5-8.5-9.52P+2S+2N0 5.5000397080PSI{ts '2023-10-02 12:58:42'}
176163303108172540RFAT28550R22GRIPPER A/TFuel TiresLT285/50R22Blackwall2228550124/121SE/10PR029.101633.38.0-9.0-10.03P+2S+2N0 5.55000000352580PSI{ts '2023-10-02 12:58:41'}
186163323108172540RFAT32550R22GRIPPER A/TFuel TiresLT325/50R22Blackwall2232550127SE/10PR034.501734.89.5-10.0-12.03P+2S+2N0 5.55000000386080PSI{ts '2023-10-02 12:58:42'}
196163313108172540RFAT28540R28GRIPPER A/TFuel TiresLT285/40R28Blackwall2828540117/114RE/10PR027.8017378.25-9-11.02P+2S+2N0 6.55000000283380PSI{ts '2023-10-02 12:58:41'}
206163203108172540RFAT30530R28GRIPPER A/TFuel Tires305/30R28Blackwall2830530116TXL028.3014.435.210.5-11.0-12.02P+2S+2N0 6.55500000275650PSI{ts '2023-10-02 12:58:41'}
GRIPPER A/T - Fuel Off-Road Wheels

  Fuel Tires     Fuel Tires  

GRIPPER A/T
GRIPPER A/T
GRIPPER A/T

GRIPPER A/T

Fuel Tires GRIPPER A/T

265/50r20
265/70r17
285/70r17
275/65r18
285/65r18
295/70r18
275/55r20
285/55r20
305/55r20
325/60r20
285/50r22
325/50r22
285/40r28
305/30r28

Technical Specifications

Part Number Size Speed Rating Load Range Weight (lb) Tread Depth Max Load Max PSI Overall Diameter Rim Range Tread Construction Side Construction Dynamic Balance (oz) Warranty (miles)
RFAT26565R17 265/65R17 T n/a 46.3 13 2756 n/a 30.5 7.5-9.5 n/a 0 55000
RFAT26570R17 LT265/70R17 121/118S E/10PR 22.3 16 3195 80PSI 31.7 7.0-8.0-8.5 2P+2S+2N 0 5 50000
RFAT28570R17 LT285/70R17 121/118S E/10PR 25.5 16.3 3195 80PSI 32.8 7.5-8.5-10.0 2P+2S+2N 0 5.5 50000
RFAT371250R17 37X12.50-17 Q n/a 80.47 17 4080 n/a 36.8 8.5-11.0 n/a 0 50000
RFAT26560R18 265/60R18 114T XL 20.1 13 2601 44PSI 30.5 7.5-8.0-9.5 2P+2S+2N 2P 5 55000
RFAT27565R18 P275/65R18 114T STD 18.2 13 2601 36PSI 32.1 7.5-8.0-9.0 2P+2S+1N 0 5 55000
RFAT28565R18 LT285/65R18 125/122S E/10PR 32 17 3640 80PSI 32.6 8.0-8.5-10.0 2P+2S+2N 0 5.5 50000
RFAT29570R18 LT295/70R18 129/126S E/10PR 29.8 16.3 4080 80PSI 34.3 7.5-8.5-10.0 3P+2S+2N 0 5.5 50000
RFAT26550R20 265/50R20 112S E/10PR 42.55 13 2470 65PSI 30.5 8.0-9.0-10.0 2P+2S+2N 0 5.5 0
RFAT27555R20 275/55R20 117SXL XL 21.8 13 2833 42PSI 31.9 7.5-8.5-9.5 2P+2S+2N 0 5 55000
RFAT28555R20 LT285/55R20 124/121S E/10PR 27.6 16 3525 80PSI 32.4 8.0-9.0-10.0 2P+2S+2N 0 5.5 50000
RFAT28565R20 285/65R20 127S E/10PR 72.75 17 3860 80PSI 34.6 8.5-9.5-11.0 2P+2S+2N 0 5.5 0
RFAT30555R20 LT305/55R20 121/118S E/10PR 31.8 16.3 3195 65PSI 33.2 8.5-9.5-11.0 2P+2S+2N 0 5.5 50000
RFAT32560R20 LT325/60R20(35X12.50R20) 126/123R E/10PR 34.2 17 3740 65PSI 34.8 9.0-9.5-12.0 3P+2S+2N 0 6 50000
RFAT351250R20 35X12.50R20 R n/a 34.2 17 3195 80PSI 34.8 9.5-12.0 n/a 0 50000
RFAT371250R20 37X12.50-20 128Q F/12PR 79.37 17 3970 80PSI 36.8 7.5-8.5-9.5 2P+2S+2N 0 5.5 0
RFAT28550R22 LT285/50R22 124/121S E/10PR 29.1 16 3525 80PSI 33.3 8.0-9.0-10.0 3P+2S+2N 0 5.5 50000
RFAT32550R22 LT325/50R22 127S E/10PR 34.5 17 3860 80PSI 34.8 9.5-10.0-12.0 3P+2S+2N 0 5.5 50000
RFAT28540R28 LT285/40R28 117/114R E/10PR 27.8 17 2833 80PSI 37 8.25-9-11.0 2P+2S+2N 0 6.5 50000
RFAT30530R28 305/30R28 116T XL 28.3 14.4 2756 50PSI 35.2 10.5-11.0-12.0 2P+2S+2N 0 6.5 55000

These products can expose you to chemicals including chromium, nickel and lead which are known by the State of California to cause cancer, or birth defects, or other reproductive harm. For more information please visit: www.P65warnings.ca.gov