Bell-Snohomish Co Sheriffs OFF 47G-3B
PMA parts · 320
Current parts manufacturer approvals (PMA): parts the FAA has approved companies to make as replacements or modifications. Each record lists its models as free text; OpenAirDocs matched them to this model on its data sheet, so check the FAA record before relying on it. Newest first.
Query with SQL
duckdb -csv -c "SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('2H3')
AND len(list_intersect(tcds_models, ['47G-3B'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT drs_guid, part_number, part_name, holder, pma_number, replaces_part, supplement_date, tcds_models
FROM 'https://openairdocs.org/data/latest/faa_type_certificate_pma.parquet'
WHERE tcds_number IN ('2H3')
AND len(list_intersect(tcds_models, ['47G-3B'])) > 0
ORDER BY supplement_date DESC, drs_guid DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
WF336342Filter Element, LubeMDL TD 031851VA-1A( )AndAccessoriesTA2093-1Heli- Preheat KitTA2093-2Heli- Preheat Kit01-0790906-00LED Landing LightNo part numberNo part numberAG844000-15Gasket – UHF/VHF AntennaAG728000-52Gasket – Satcom AntennaAG627000-23Gasket – Marker BeaconR1224JAlternator Controller (Voltage Regulator)AG358000-08Gasket – ELT AntennaAG627000-12Gasket – Marker Beacon AntennaAG843000-17Gasket-UHF/VHF AntennaSB47-645-269-001Shaft, Tail Rotor, 90° GearboxSB47-722-270-021Cable Assembly, Anti-Torque Controls, AftAG822000-03Gasket - TCAS AntennaSB47-120-014-023Split Ring Assy - Rotor HubAG843000-17Gasket - UHF/VHF AntennaSB47-722-269-029Cable Assembly, Anti-Torque Controls, Fwd.AG843000-15Gasket - VHF AntennaAG247000-04Gasket - L-Band AntennaSB47-120-250-001Spring, Dynamic Flap RestraintSB47-644-232-009Shaft, Tail Rotor Drive, Assy ofSB47-120-250-001Spring, Dynamic Flap RestraintSB47-644-232-009Shaft, Tail Rotor Drive, Assy ofSB 910Assembly, Barrier Air Filter BoxSB47-722-290-021Cable, Assy of, Flight ControlSB47-725-870-101Rod Assembly, Upper Lateral Cyclic Control74-140-134-1Clamp, Stabilizer, Dampener Frame74-140-134-1MClamp, Stabilizer, Dampener FrameSB47-645-239-103Bearing- Tail Rotor Drive ShaftSB47-620-629-007Bearing- Tail Rotor Drive SleeveSB47-350-009-007Cross Tube AssemblySB47-500-011-003Tube AssemblySB47-500-011-001Cross Tube Assy., Heavy Duty KitSB47-500-011-007Tube AssemblySB47-J-5736-13MountSB47-660-3132-1CouplingSB47-660-2354-2N2 Tach Generator Shear ShaftSB47-612-171-123CMount Assembly - Engine SupportCD21500Ignition, UniversalCD21399Linear RheostatCDL21035Dataplate, Repair StationCD60535Spark Plug GrommetCD21505Terminal BlockSB47-645-205-003Shaft, Tail Rotor DriveCD21255Control, Thermostat Rotary RheostatCD21346Filter & O-ring Repair KitCD21428Switch, Air
Back to Bell-Snohomish Co Sheriffs OFF 47G-3B