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.
7YE0020A53M01PlacardUS743730-67Electrical WiresG80762018-29PlacardUS745730-53Electrical WiresUS745100-167Plate7YE0020A53M06PlacardUS743730-7Electrical WiresUS745730-35Electrical WiresUS745730-83Electrical WiresUS743100-175ShimG80762018-31PlacardG80762018-41PlacardUS745730-23Electrical Wires7YE0020A53M02PlacardG11032008-301PlacardUS743100-159PlateUS740P07-3Name PlacardG80762018-39PlacardUS743100-173PlateUS745170-9DoublerUS745730-43Electrical Wires7066M26P02DECLimiter Deflection1314M14P01DECDisk-Deflection Limiter1107064-07Harness1101075-1Shoulder Harness1107064-17Restraint System1117119-01Restraint System1107064-09Restraint System1107064-11Restraint System1117032-01Restraint System1117119-03Restraint System0108161-3Dual Reel Assy1117032-05Restraint System1107064-19Restraint System0108901-01Restraint System1107064-01Restraint System1101074-9Rotary Buckle w/Shoulder Harness1107064-03Restraint System1117032-03Restraint System0108161-13Dual Reel Assy0108161-1Dual Reel Assy1107064-05Restraint System1107064-15Restraint System65-21831-30Actuator65B82585-4Actuator69B80187-3Valve Assy66-13873-8Bearing Plate66-13873-3Bearing Plate69B70231-1Nut-Jam162U1520-1Bolt
Back to Boeing 747-230B