combined query = (SELECT companies.Company AS company2, companies.Tradename AS tradename, yaxley.Num, yaxley.Model AS Model2, yaxley.TubeList, yaxley.Resistor, yaxley.YSLR, yaxley.chassis FROM companies, yaxley WHERE yaxley.Company_ID = companies.Company_ID AND yaxley.TubeList LIKE '%6d6%' AND yaxley.TubeList LIKE '%6a7%' AND yaxley.TubeList LIKE '%75%' AND yaxley.TubeList LIKE '%43%' AND yaxley.Num = '5' ) UNION (SELECT companies.Company AS company2, companies.Tradename AS tradename, combinedtable.Num, combinedtable.Model AS Model2, combinedtable.TubeList, combinedtable.Resistor, combinedtable.YSLR, combinedtable.chassis FROM companies, combinedtable WHERE combinedtable.Company_ID = companies.Company_ID AND combinedtable.YSLR LIKE 'S' AND combinedtable.TubeList LIKE '%6d6%' AND combinedtable.TubeList LIKE '%6a7%' AND combinedtable.TubeList LIKE '%75%' AND combinedtable.TubeList LIKE '%43%' AND combinedtable.Num = '5' ) UNION (SELECT companies.Company AS company2, companies.Tradename AS tradename, redbook.Num, redbook.Model AS Model2, redbook.TubeList, redbook.Resistor, redbook.YSLR, redbook.chassis FROM companies, redbook WHERE redbook.Company_ID = companies.Company_ID AND redbook.TubeList LIKE '%6d6%' AND redbook.TubeList LIKE '%6a7%' AND redbook.TubeList LIKE '%75%' AND redbook.TubeList LIKE '%43%' AND redbook.Num = '5' )

Mallory-Yaxley Radio Encylopedia Database

Free radio look-up information

Type in any known information. At least one field needs to be entered or nothing will be shown.
Additional instructions and background info can be found here.

Please select the database to search:
Records 1 to 20 of 238
Company Tradename Model Chassis # Tubes Tube List BallastDatabase
Aetna Radio Corp. (Walgreen Drug Co.) 5T '36 5 6A7, 6D6, 75, 43, 25Z5 Y
Aetna Radio Corp. (Walgreen Drug Co.) 700 5 6A7, 6D6, 75, 43, 25Z5 Y
Air King Products Company, Inc. Air King 202 5 6A7, 6D6, 25Z5, 43, 75 340S
Air King Products Company, Inc. Air King 260 5 6A7, 6D6, 25Z5, 43, 75 S
Air King Products Company, Inc. Air King 260 5 6A7, 6D6, 75, 43, 25Z5, 42H Y
Air King Products Company, Inc. Air King 27, 28A 5 6A7, 6D6, 25Z5, 43, 75 52HS
Air King Products Company, Inc. Air King 27, 28A 5 6A7, 6D6, 75, 43, 25Z5 Y
Air King Products Company, Inc. Air King 33, 60 5 6A7, 6D6, 25Z5, 43, 75 52HS
Air King Products Company, Inc. Air King 403 5 6A7, 6D6, 25Z5, 43, 75 340S
Air King Products Company, Inc. Air King 403-1 5 6A7, 6D6, 25Z5, 43, 75 K36HS
Air King Products Company, Inc. Air King 47. 48 5 6A7, 6D6, 25Z5, 43, 75 52HS
Air King Products Company, Inc. Air King 528 5 6A7, 6D6, 25Z5, 43, 75 52HS
Air King Products Company, Inc. Air King 57, 58 5 6A7, 6D6, 25Z5, 43, 75 52HS
Air King Products Company, Inc. Air King 62, 66, 66C 5 6A7, 6D6, 25Z5, 43, 75 340S
Air King Products Company, Inc. Air King 66 5 6A7, 6D6, 75, 43, 25Z5 Y
Air King Products Company, Inc. Air King 67, 67C 5 6A7, 6D6, 25Z5, 43, 75 52HS
Air King Products Company, Inc. Air King 720, 721 5 6A7, 6D6, 75, 43, 25Z5 M49HGY
Air King Products Company, Inc. Air King 722 5 6A7, 6D6, 25Z5, 43, 75 M49HGS
Air King Products Company, Inc. Air King 770 5 6A7, 6D6, 75, 43, 25Z5 M49HGY
Air King Products Company, Inc. Air King 870, 871 5 6A7, 6D6, 75, 43, 25Z5 Y

Next Last