Commercial Alternative to WebFLIS Menu

Get a free trial and you'll have access to all of the features and data that LogiQuest has to offer.


Advanced Search Free LogiQuest Trial
Click here to request your free LogiQuest trial today.
Search Syntax Examples: (Searches are not case sensitive)
  Space separated terms like BALL BEARING find records containing both BALL AND BEARING
  Comma separated terms like BALL, BEARING find records containing either BALL OR BEARING
  Search terms can include multi-character() or single-charater(%) wildcards.

LogiQuest® Lite  A Commercial Alternative to WebFLIS

LogiQuest Lite provides instant access to information on millions of items in the Federal Supply Catalog.
National Stock Number(NSN): 4730-00-266-3897 (4730002663897, 002663897)

NIIN: 00-266-3897 Item Name: UNION,TUBE INC: 03788
FSC: 4730 Assignment Date: Jan-01-1961 CRIT: X IIG: 03788
ISC: 2 Date Standardized: Dec-15-1974 HMIC: N DODIC:
NSC: 0 Cancellation Date: PMIC: U FIIG: A080B0
ESD: Schedule B: 7411.10.5000 DEMIL: A DEMIL INT:
TIIC: 4 Originator: AX ADPEC: RPDMRC: 3
Advantages & Benefits to a full LogiQuest subscription:

With a full subscription to LogiQuest, you can affordably maintain readiness of US military equipment, view current and historical NSN pricing, find substitutable manufacturer’s part numbers, analyze weapon systems, view detailed vendor data, proactively address DMSMS and bid on government selling opportunities. Directly search 60+ databases from Navy, Army, Air Force, Marines, and commercial sources. Examples include APL, AMDF, Milspecs, CAGE, SAM, EPLS, QPL, QPD, and many more.

The full version of LogiQuest has information related to NSN 4730-00-266-3897 in each of the following databases.

 • PROCUREMENT - Procurement History
 • BIZOPPS_ARC - Archived Business Opportunities
 • PID - Procurement Item Description
 • SUPPTECH - Supplemental Technical Information
 • APL - Allowance Parts List
 • AEL - Allowance Equipage List
 • AWARDS - Awards Information
 • CRF - NICP Cross Reference File
 • LIRSH - List of Items Requiring Special Handling
 • MSD - Materiel Support Division
 • NICN - Navy Item Control Number to NIIN
 • NMDF - Navy Master Data File
 • NNRF - Navy NIIN Reference File
 • PROJECTIONS - Projected Future Procurements
 • SNUD - Stock Number User Directory
 • WHEREUSED - Where NIIN Used
 • WPS - Weapons Systems
 • CAGE - Commercial And Government Entity
 • H6 - Federal Item Name Directory
 • FSC - Federal Supply Class
 • Schedule B - Export Commodity Classifications

Contact us to request your free trial of LogiQuest® today.

Learn More

To learn more about LogiQuest® click here.

Please note that LogiQuest Lite is an informational service only.  Clicking on the CAGE codes below will provide contact information for possible sources of supply.


  Contact an advertising partner for price and availability for this item.
Part Information
Part Number CAGE Company Status RN CC RN VC DAC RN AAC RN FC RN SC RN JC SADC HCC MSDS
102 3/8IN 18906 ELKHART PRODUCTS CORP C 5 1 6 AX D
402 11699 KENNECOTT CORP CHASE EXTRUSIONS DIV C 5 9 6 AX 3 D
4023-8IN 11699 KENNECOTT CORP CHASE EXTRUSIONS DIV C 5 9 6 AX 3 B
A-A-59617 58536 FEDERAL COMMERCIAL ITEM DESCRIPTION PROMULGATED BY GENERAL SERVICES ADMINISTRATION WASHINGTON DC C 4 1 E ZZ
AA59617-21 58536 FEDERAL COMMERCIAL ITEM DESCRIPTION PROMULGATED BY GENERAL SERVICES ADMINISTRATION WASHINGTON DC C 2 2 E ZZ
Additional Part Information
Part Number CAGE Company Source RN CC RN VC DAC RN AAC RN FC RN SC RN JC SADC HCC MSDS
W8002 41947 MUELLER BRASS CO. AEL
Management Information
MOEC SOS A A C R C S L C CIIC U P Q U S C Unit Price UI UICF MCD Action Date C/H
DF SMS J N 0 U 1 F $9.79 EA SF9---N Oct-01-2025 C
DN SMS J 0 U 1 N $9.79 EA 9B----- Oct-01-2025 C
DS SMS J N 0 U 1 D $10.74 EA ------- Oct-01-2022 H
DS SMS J N 0 U 1 I $9.79 EA ------- Oct-01-2025 C
Technical Characteristics Information
MRC Requirement Statement Reply Statement
ACSP REDUCER TYPE CONCENTRIC
AHNC CONNECTION STYLE L30A SOCKET (TUBE) ALL ENDS
AWLS CONNECTION TYPE UNTHREADED INTERNAL TUBE ALL ENDS
BYJF SEAT TYPE BEVELED
CQNM COUPLING FLANGE SHAPE HEXAGON
CWFD NOMINAL OUTSIDE DIAMETER TUBE ACCOMMODATED 0.375 INCHES ALL ENDS
CWFR NOMINAL OVERALL LENGTH 2.000 INCHES
FEAT SPECIAL FEATURES BOTH TUBING WALL THICKNESS AT EACH END CAN BE COMPROMISED,LENGTH CAN BE COMPROMISED
MATT MATERIAL COPPER ALLOY SHOULDER
MATT MATERIAL COPPER ALLOY TAILPIECE
MATT MATERIAL COPPER ALLOY THREAD PIECE
STYL STYLE DESIGNATOR E107 SCREWED
MOE Rules Information
MOE Rule Former MOER Effective AMC AMSC IMC IMCA Collaborators Receivers
N9BC N9CD Apr-01-2005 1 G Z GH GX|HD GH|GX
FXGC FXAX Apr-01-2005 1 G Z SX GX|TU GX|TU
ZU01 Jun-01-2005 ZU ZU
Replacement & Obsolete Information
Obsolete NIIN Information
FSC NIIN DEMIL NSC Cancelled
4730 00-266-3898 A 5 Apr-01-2017
Freight Information

Description: PIPE, TUBING, FITTINGS SUB21 Originating Activity: XX
Hazardous Material: National Motor Freight Classification Number: 052200
Less Than One Truckload: W NMFC Sub-Item: Z
Uniform Freight Classification Number: 00000 Rail Variance Code:
Less Than One Carload: Water Commodity Code: 576
Type of Cargo Code: Z Special Handling Code: 9
Air Commodity Special Handling Code: BZ Air Dimension Code: A
Integrity Code:
Packaging Information

Source: P Primary Inventory Control Activity (PICA) Status: C
Pri/Sec ICC: P Container NSN: Category Code: 18ZZ
Lvl A Pkg Req:  Q  Unit Pack Size: Pres Material: 00
Lvl B Pkg Req:  Q  Unit Pack Weight: 0.3 Pres Method: 10
Lvl C Pkg Req:    Unit Pack Cube: 0.001 Wrapping Mat: JA
Opt Proc Ind:  O  Unpkg Item Dims: Spec Marking: 00
Supp Inst: IP056: MERCURY OR MERCURY 
Container FSC: SPI Number: SPI Revision:   
Unpkg Weight: SPI Date: Pkg Design Activity: 16236
Inter Container Qty: AAA Inter Container Code: ED Clean/Dry Procedure: 1
Unit Container: D3 Item Type Storage:  B  Unit Container Level:   
    Cush/Dun Material: NA Cush/Dun Thickness: C
Contact us to request your free trial of LogiQuest® today.   Click here to learn more about LogiQuest®.
Company Logo
Phone Icon (978) 774-7999 x600 Email Icon 

© 2026 Copyright Terabase Corporation.  All rights reserved. ® LogiQuest is a registered trademark of Terabase Corporation. ® Terabase is a registered trademark of Terabase Corporation. Website design by Sperling Interactive.