Bell-Mid-America Helicopters 47J
PMA parts · 117
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 ('2H1')
AND len(list_intersect(tcds_models, ['47J'])) > 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 ('2H1')
AND len(list_intersect(tcds_models, ['47J'])) > 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.
01-0790906-00LED Landing LightAG844000-23Gasket – UHF/VHF AntennaAG844000-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-120-014-023Split Ring Assy - Rotor HubSB47-722-269-029Cable Assembly, Anti-Torque Controls, Fwd.74-140-134-1Clamp, Stabilizer, Dampener Frame74-140-134-1MClamp, Stabilizer, Dampener FrameSB47-645-239-103Bearing- Tail Rotor Drive ShaftSB47-J-5736-13MountSB47-612-171-123CMount Assembly - Engine SupportSB47-110-021-003Bolt, Rotor Blade, Type 10SB47-631-131-003Control Assembly Fuel Shutoff74-140-252-3Bearing, Rod End, Main Rotor Pitch Change74-140-252-5Bearing, Rod End, Main Rotor Pitch ChangeSB47-661-031-001Bearing, Cooling FanSB47-645-238-001Bearing, Gear Box, Tail Rotor DriveSB47-645-238-003Bearing, Gear Box, Tail Rotor DriveSB47-110-378-001Rod, Tie, Main Rotor Hub CTWTSB47-110-363-001Trim Tab Assembly, Main Rotor BladeSB47-110-363-103Trim Tab Assembly, Main Rotor BladeSB47-620-669-001Centrifugal clutch assemblySB47-512-111-013Cross tube assembly, float gear kitSB47-512-111-003Cross tube assembly, float gear kitSB47-500-024-001Plate, stop landing gearSB47-512-111-015Cross tube assembly, float gear kitSB47-512-111-007Cross tube assembly, float gear kitSB47-512-111-009Cross tube assembly, float gear kitSB47-512-111-011Cross tube assembly, float gear kitSB47-512-111-001Cross tube assembly, float gear kitSB47-512-111-005Cross tube assembly, float gear kit01-0770058-03A625 Series Strobe Light assembly.01-0770029-35Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770028-05HDA-CF Power Supply01-0770029-36Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-33Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-34Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-31Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-32Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-38Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-29Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-37Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770029-30Self contained Comet Flash strobe anti-collision Light assembly Model HR,CFA Series01-0770019-21Strobe Light Assembly A470A series01-0770019-15Strobe Light Assembly A470 series
Back to Bell-Mid-America Helicopters 47J