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.
65B08104-201BUSHING-FLANGED66-4302COLLAR65B08104-103BUSHING-FLANGED3161011-3WDPin, Straight Headed65B08104-76BUSHING-FLANGED313U2200U10FRAME STA 313 OUTBD69B13096-2PLATE - SERRATED65B08104-118BUSHING-FLANGED69B00292-1BUSHING65B07671-9SEAL65B07948-55SEAL65B07948Y75SEAL69B04073-1BUSHING65B08103-68BUSHING - PLAIN65B08104-156BUSHING-FLANGED66-21297-2BUSHING69B60593-4SPRING65B08104-117BUSHING-FLANGED69B04111-4BUSHING69B11230-7BUSHING, BUSHING - F311T2570-97SEAL STRIP65B08104-77BUSHING-FLANGED65B08103-45BUSHING - PLAIN379103D-15Emergency Descent Device654U6315-1TOP KIT - CSEU POWER SUPPLY015U0807-1COMPONENT KIT, SIGNAL COLLECTION TAIL IDENTIFICATION PRINTED CIRCUIT ASSEMBLY MODIFICATION832-1748-114CMU-900 Core Sofrware69B90623-1BEARING PLATE66-12688-1BUSHING69B94177-1WASHERAECI PN 15-20201AECGasket Wire Mesh63-2892-2ROD END65B90643-3ROD69B10070-2SPRING-COMPRESSION65B94286-11PLATE65B94286-12PLATE69B94145-1SEAL - FIRESHIELD65B07948-61SEALAECI PN 15-20020AECGasket Wire Mesh203104WDBearing, Ball728856-7WDSpacer, Bearing203103WDBearing Set, Annular Ball728856-6WDSpacer, Bearing728856-3WDSpacer, Bearing358474-1WEBearing, Annular BallNCC009Steel Brake ComponentsSP5378Rate ControlSP5594Rate ControlS774642JP-24BushingS750461JP-12Bushing
Back to Boeing 747-230B