Boeing 747-230B
PMA parts · 62,097
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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-200B Series'])) > 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 ('A20WE')
AND len(list_intersect(tcds_models, ['747-200B Series'])) > 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.
8019-1Seal Assembly - Shaft859989-20WERing, Piston358504-1WEBearing, Ball65B60672-1WEGuide Arm-Manual Retractable Center766108G7WEPiston and Slipper Assembly69494J110WEPacking, Preformed774632-12WELink799737-4WERing, Convex774632-22WEBall3502132-10WESpring Assembly4004C8-8-8WEBearing63-9651-2WEIndicator, Rotary Latch, Nacelle Access Door69494J15WEPacking, Preformed707775JWEGear, Spur (Increased Gear Thickness)358655-1WEBearing, Ball695451WERace, Roller Bearing Inner4004-6-6-25WERoller, Bearing364436-1WEGear Set69494J17WEPacking, Preformed813392-1WEWasher, Wave Spring700051-16WAPoppet, Flow Restrictor4004-5-5-6WERoller, Bearing Element60-75569WEImpeller358029WESeal Assembly, Plain Encased352003WEBearing-Yoke1171-075WELockwasher, Cup40695WEPin, Spring, Spiral10-60754-15WESeal4005-7-13-18WERoller Element858224-6WERing-Piston3507298-1 WESeal123423-3-2WEScrew3882698-1 WEGearshaft - Spur Driven774564-15WESwitch, Hermetically Sealed5909999-1WESwitch, Push20335WESeal785659-1WEGasket, Corrugated774632-12WELink857760-3WESeal Assembly Shaft Bi- Directional887582WEAdapter4004-6-6-14WERoller, Bearing Element69494J12WEPacking, Preformed708511WEBushing3501741-2WEGearshaft, Spur362851-4WEWheel - Turbine4004C8-11-26WERoller, Bearing4004C8-8-22WERoller, Bearing3501212-3WESeal - Turbine Wheel60-72114WEAdapter - Inlet766108G4WEPiston and Slipper Assembly
Back to Boeing 747-230B