I can't remember if I posted this in the past but I will try to clear some things uo.
4 1/2 and 5 1/2 casing are for water wells usually except in some places here in the east wher the wells are fairly shallow.
Most of the pipe I have seen on the 6500 cars checked out by counting the pipes and dividing into the deck width looked like either 8 5/8 or 9 5/8 line pipe (no couplings). It is also 39' long which will fit on the 6500 cars where as range 3 casing is 45' random so it is between about 40 and 45 ft long (95% within a foot I think or some such requirement)(been too long since I was in the pipe business).
All Drill pipe is upset but not all tubing is, it depends upon the type of end finish (thread joint) the manufacturere sells. Some "quick stab" joints are upset but I think that the majority of the tubing sold was straight thread. Note some casing was also upset for special threaded joints.
Oil well pipe sizes for casing start at 6 5/8 and in the case of our mill in Ambridge PA (no longer there) we made pipe up to 13 3/8 (6 5/8, 7 5/8, 8 5/8, 9 5/8, 10 3/4, 11 3/4(?) 12 3/4, 13 3/8 inc.
All were seamless in ranges 1,2, and 3, though range 3 was the most common.
Drill pipe was almost always upset, and there were many styles of upset depending upon the type of tool joint attached to the pipe. Some were threaded for the tool joint and some had the tool joint welded on at the mill. We also made the tool joints that were shipped with the pipe. As I remember most drill pipe was 4 1/2, 5 1/2, and 6 5/8 diameter and range 2 was most common as the wall thickness is greater than casing and the weight(and length) was as much as fwe could get out of one billet on out mill. All pipe is measured in Outside diameter.
I do not know for sure but I think from what I have seen that the Farmington area wells were in the range of 9,000 or 10,000 feet deep which takes larger pipe than shallower wells to get the production.
All for now:
Frank