Popular transistor data in spreadsheet format?

Greetings,

Does anyone know of a spreadsheet (a comma separated variable format is better) that contains data for popular transistors? A single device fills each row, with columns for part number, maximum rating, electrical characteristics, small signal characteristics, and switching characteristics.

Thank you,

--
Don Kuenz
Reply to
Don Kuenz
Loading thread data ...

The Mouser and Digikey sites are handy for searching for candidate parts, across multiple manufacturers. Of course, you have to load and read the PDFs for the deep details.

--
John Larkin                  Highland Technology Inc 
www.highlandtechnology.com   jlarkin at highlandtechnology dot com    
 Click to see the full signature
Reply to
John Larkin

I've made one for my own stash of parts (which aren't really 'popular transistors'). It's a bit less useful than 3 x 5 cards (with pinouts, to be refrigerator-magnet posted above the workbench as I wire gizmos up).

If you build your own format, remember to put price/date/supplier info somewhere.

It used to be, that libraries would get (dead-trees) catalog cards from the book publisher with each volume. Yes, it WOULD be wonderful to get a shortform data archive. Several have been started.... does anyone recall the GIICM?

Reply to
whit3rd

Back in 2012 a fellow made up a huge list of transistor cross-reference that he was selling on CD - here is his contact info:

Rob Legg Power Electronics Specialist legg (at) magma (dot)ca

I bought a CD and it is extremely comprehensive...and no, I don't make copies - the guy put a lot of work into it so he is entitled to get some small return on his time.

John :-#)#

--
(Please post followups or tech inquiries to the newsgroup) 
John's  Jukes Ltd. 2343 Main St., Vancouver, BC, Canada V5T 3C9 
 Click to see the full signature
Reply to
John Robertson

Such a list is primarilyy useful for replacement purposes in non-critical a pplicartions. Like audio outputs and such. there are really too many import ant parameters to do it that wat for design. I have a thirty year old trans istor specs book published by Howard W. Sams which od great for doing like vintage audio work. But for design I would rather see the gain curves and a ll that, as well as their published SOA graph and a bunch of other things.

Later cam the "Japanese Transistor Manual" whaich had almost all the types to date, but had no JEDEC (2N, only 2S). Well, that was OK as well buy I wi ll never give up the old book because all types are in there, up to about 1

975 or something. It even has specs on those five digit RCA transistors, li ke the 40022 and shit. (PNP germanium about 40 volts and a couple of amps, TO-3) Came in handy working on a vintage HK Citartion 12. the print you get online says you can use a 2N3055 for the outputs but that is NOT true. Wel l I wouldn't. Even though the gain is slightly lower I decided on 2N3773s. Since the drivers were blown I replced them as well with slightly higher ga in units. I do not remember the numbers offhand but all in all, the thing w orks. Sounds good.

there are other parametersa that are not so apparent. When you just go by v oltage, current, hfe and power, you don't always get what you want. I worke d on a TV a long time ago that had a shitty picture. the gamme was all f*ck ed up. I mean the shades of grey were just not right. It wasn't clipped per se, but it was f***ed up.

Turned out someone has changed a video transistor and used a device that wa s designed for RF outpur stages. the gain in such units is not linear and i s intended to be not linear.

An examination of the complete specs of that transistor would have told a c ompetent tech that it was not a suitable replacement.

So, really, it is nice to have a compedoium of all these registered devices , but in no way can it replace a detailed dataasheet.

Reply to
jurb6006

anybody recall the RCA SK series and NTE replacement parts? I didn't deal with them much, but I recall the "proper" method was dig up the datasheets for the original part, then compare to the suggested substitute specs and decide from there if it was close enough.

They eventually had some software version of the cross-ref database, but it did not tell you the specs of the original parts.

Reply to
Cydrome Leader

here is one 46000 transistors file

formatting link

--

Jean-Yves.
Reply to
jeanyves

Thanks :)

Reply to
Sjouke Burry

You can also use the following link to NTE for cross referencing transistors etc to an NTE equivalent.

Dan

formatting link
$$Search?OpenForm

Reply to
dansabrservices

for an inline cross reference search I prefer this one :

formatting link

regards,

--

Jean-Yves.
Reply to
jeanyves

Off hand I think GE and ECG (Sylvania) were the first two that went head-to-head in the substitution wars. The SK and NTE, which I always though was odd, NTE basically copied the ECG line, came later on.

They printed these phone book sized substitution guides, usually the first sections showing the complete line, with specs and the major section of transistor numbers to which substitute device. Generally the last section was some IC's and other linear devices.

I think it boiled down to A) most U.S. made stuff used 2N transistors and the Japanese had the 2SA 2SB 2SC ones, which for all practical purposes did have equivalents in the 2N arsenal and B) there really are a lot of transistors similar to each other where using one for the other just doesn't make any difference.

NTE was really an oddball, besides being a copy of ECG (a NTE-123 was the same part as ECG-123), they even copied Sylvania's book, where somewhere around 1983 or so, were sued by Sylvania because Sylvania buried fake part numbers (transistor numbers that didn't exist) and NTE copied them exactly.

Another thing NTE did, all their parts had like a 1 year, no questions asked, warranty on them. That was pretty handy for some of the high power ones, like that scr/triac thing that Sony used for horizontal sweep in the Trinitron models. Those things went bad looking at them cross-eyed and they were not cheap.

Plus the NTE line was almost half of the ECG price across the board.

By the mid/late 80's, IC's pretty much spelled out the death of the substitution wars although I remember still getting substitution reference manuals thru the 90's. But like the Radio Shack and Sears catalogs, they were getting thinner and thinner as time went on.

-bruce snipped-for-privacy@ripco.com

Reply to
Bruce Esquibel

SK? Started using them in the mid '60s NTE was a clone of the Sylvania ECG series. I was using ECG parts in

1970. ECG published a set of three databooks on their components. Then it was sold to Philips, and finally to NTE when Philips got out of that business.

Motorola had their HEP series.

General Electric had their GE series.

Workman Electronics had a smaller series of parts, along with a couple dozen other short lived companies who tried to enter that business.

formatting link
is the NTE website

--
Anyone wanting to run for any political office in the US should have to 
have a DD214, and a honorable discharge.
Reply to
Michael A. Terrell

And the results seemed to vary.

I remember some big blunders in the HEP catalog, but so blatant that they couldn't be anything but errors. But Radio Shack's replacement line wsa pretty small, and what I remember is them trying to match a lot of devices with the small number they had, and failing badly as a result. HEP had a decent selection, so the cross reference tended to be useful, if not perfct.

I had an HEP replacement guide, free in the mail, about 1972. But I never remember buying any HEP replacement device, I remember even warning a kid at school (he said "but I don't want to make a mistake", trusting the article rather than third party advice that it was just a simple op-amp). I just used the guide to find information about unknown devices, so usefull decades back when we might not have databooks from all the companies, and of course, checking something in one book was easier than checking multiple books.

When I finally saw an ECG guide, late eighties, it was a vast improvement over the HEP guide I had.

Michael

Reply to
Michael Black

The semiconductor industry had matured a lot in a decade. The problem with the ECG & NTE books were that they dropped all references to any part they dropped from their line. You might have the part in stock, but there was no way to find it without a pile of old books.

--
Anyone wanting to run for any political office in the US should have to 
have a DD214, and a honorable discharge.
Reply to
Michael A. Terrell

It looks like it has gone the way of the vacuum tube industry. Except for a small number of specialized tubes (transmitting, high end audio), what is left is either NOS (new old stock), and generic replacements sold as various models depending upon who is buying them.

For example, there is a rumor (which is probably not wrong) that all small signal NPN transistors made today are 2n2222's. If you want something else, you can buy a million marked anything you want, cheap enough to retail at a penny each including shipping from China.

For example, I bought some 2n5109 (reltively high power (1.5w), wide frequency response (good over 144mhz) RF amps from a repespected dealer in the UK. I noticed they did not act or look like NOS Motorola ones, and he offered to refund my money, saying he got them from a trusted dealer in the EU, and they were well received by customers.

They had 2n5109 stenciled on the side, no other markings and the Motorla ones had a sealed metal can, these were in a metal can, but had resin on the bottom. They had 4 wires (one cut), the Motorola had 3.

I looked up the Chinese spec sheet for them and the Central Semiconductor ones are not clearly shown to tell if they are metal or resin, but they are not 2n5109's, they are a new "better" transistor (higher frequency response, more gain) sold as the old ones. I wonder how many other numbers these transistors get stamped on them. :-)

Geoff.

--
Geoffrey S. Mendelson,  N3OWJ/4X1GM/KBUH7245/KBUW5379
Reply to
Geoffrey S. Mendelson

There is a die number, etched into the silicon. You can decap or decapsulate a suspect part, and see what it really is.

The 2N5109 was used in CATV headend equipment, well past 300 MHz. I replaced a few in an RCA (Design bought from EIE, then later sold to Catel) headend with some intermittent spurs. They modulated at the IF frequency, or converted an off air signal to IF, then used output converters to put the signal on the desired channel. That was 30 years ago, but I might still have a manual in my files. :)

--
Anyone wanting to run for any political office in the US should have to 
have a DD214, and a honorable discharge.
Reply to
Michael A. Terrell

I bought them to use in HF active antennas (PA0RDT type). Since then I have found NOS 2n3866 work just as well at 1/5 the price along with 2N5179 and BSX20 transistors. They are really there because they have a 50ohm output impedance, and the smaller (2n5179/BSX20) transistors have a much smaller chance of oscilatting and burning out. :-)

I also found out the hard way that the PA0RDT design works ok at 9 volts, better at 12 volts (noticably higher gain) and oscillates at 13.8 volts. Next one will be built with a silicon rectifier string to drop the 13.8 to

12, unless the 7809's arrive from China. :-)

Geoff.

--
Geoffrey S. Mendelson,  N3OWJ/4X1GM/KBUH7245/KBUW5379
Reply to
Geoffrey S. Mendelson

I keep a lot of different regulators in stock, for projects. I used to buy lots of dead C-band LNAs, LNbs and LNCs for a couple dollars each. Most had a bad regulator, so I had around $1.50 in each repaired item that sold for $30. :)

Do you really need 1A? The 78L09 is good to 100 mA, and is a lot smaller.

--
Anyone wanting to run for any political office in the US should have to 
have a DD214, and a honorable discharge.
Reply to
Michael A. Terrell

Thanks, 100ma is a lot closer to what I need, does it shut down or current limit when it is overloaded like the larger version, or is it damaged.

When the transistor goes into oscilation it draws a lot of current and the idea is to prevent it from burning out other parts.

I bought the larger ones because they are more useful to me, and I have a 4 to 6 week lead time from China. 2-3 week lead time from the UK, but usually twice the price.

Geoff.

--
Geoffrey S. Mendelson,  N3OWJ/4X1GM/KBUH7245/KBUW5379
Reply to
Geoffrey S. Mendelson

It's on the first page of the datasheet.

formatting link

Reply to
JW

ElectronDepot website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.