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 '%6A7%' AND yaxley.TubeList LIKE '%25Z5%' AND yaxley.TubeList LIKE '%43%' AND (companies.Company LIKE '%Air%' OR companies.tradename LIKE '%Air%') 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 '%6A7%' AND combinedtable.TubeList LIKE '%25Z5%' AND combinedtable.TubeList LIKE '%43%' AND (companies.Company LIKE '%Air%' OR companies.tradename LIKE '%Air%') 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 '%6A7%' AND redbook.TubeList LIKE '%25Z5%' AND redbook.TubeList LIKE '%43%' AND (companies.Company LIKE '%Air%' OR companies.tradename LIKE '%Air%') AND redbook.Num = '5' )
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.
| Company | Tradename | Model | Chassis | # Tubes | Tube List | Ballast | Database |
|---|---|---|---|---|---|---|---|
| Air King Products Company, Inc. | Air King | 722 | 5 | 6A7, 6D6, 25Z5, 43, 75 | M49HG | S | |
| Air King Products Company, Inc. | Air King | 770 | 5 | 6A7, 6D6, 75, 43, 25Z5 | M49HG | Y | |
| Air King Products Company, Inc. | Air King | 870, 871 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Air King Products Company, Inc. | Air King | Atlas 5T Universal | 5 | 6A7, 78, 75, 43, 25Z5 | Y | ||
| Fairbanks Morse & Company | Fairbanks Morse | 68 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Fairbanks Morse & Company | Fairbanks Morse | 68T6 | 5 | 6A7, 6D6, 25Z5, 43, 75 | 165L4 | S | |
| Fairbanks Morse & Company | Fairbanks Morse | 69 | 5 | 6A7, 6D6, 76, 43, 25Z5 | Y | ||
| Fairbanks Morse & Company | Fairbanks Morse | 69T7 | 5 | 6A7, 6D6, 25Z5, 43, 76 | 165L4 | S | |
| Montgomery Ward And Company | Airline | 62-260 | 5 | 6A7, 78, 75, 43, 25Z5 | Y | ||
| Montgomery Ward And Company | Airline | 62-601 (Early) | 5 | 6A7, 78, 75, 43, 25Z5 | Y | ||
| Montgomery Ward And Company | Airline | 93BR-601 | 5 | 6A7, 76, 75, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 5200 | 5 | 6A7, 78, 75, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 55U | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 570 | 5 | 6A7, 78, 75, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 590 | 5 | 6A7, 75, 78, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 599 | 5 | 6A7, 78, 75, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 71U | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Sentinel | See United Air Cleaner Corp | 85U, 85UE | 5 | 6A7, 6D6, 75, 43, 25Z5 or 6A7, 6D6, 75, 6G5, 43, 25Z5 | M49B or M42B | Y | |
| Spiegel, Incorporated | Aircastle | 132 | 5 | 6A7, 6D6, 75, 43, 25Z5 | Y | ||
| Spiegel, Incorporated | Aircastle | 509 | 5 | 6A7, 6D6, 25Z5, 43, 75 | S |
| First | Previous | Next | Last |