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.
69B46126-9Module Assy65B46180-9Module Assy65B64099-42Panel Assy (2L)69B46838-1M/A Strut Ouht69B46562-4Module Assy65B47522-30Control Box Assy65B58207-1Panel Assy65B46113-153Module Assy65B50622-18Panel Assy65B46137-39Module Assy69B46049-5Module Assy65B47693-33Control Panel Assy285T1115-13Printed Circuit Assy65B64099-427Panel Assy65B47508-47Card File Assy69B46121-1Module Assy65B47511-170Accessory Box Assy-65B47505-68Card File Assy65B64099-477Panel Assy (3R)65B58205-1Panel Assy65B47508-69Card File Assy65B47505-52Card File Assy65B47572-62Accessory Box Assy65B50620-18Panel Assy69B46101-6Module Assy69B56132-10Switch Assy69B46582-18Module Assy69B46024-16Module Assy65B47649-4Cargo Control Assy65B46189-5Module Assy65B46118-174Module Assy69B48274-1Transformer Assy65B47522-36Control Box Assy65B47634-7Intercom Assy65B64099-90Panel Assy (4L)69B46135-24Module Assy65B47642-1Cargo Control Assy65B46040-10Module Assy65B47628-8Cargo Control Assy65B47573-105Accessory Box Assembly, Auto Flight Control65B47577-120Accessory Box Assy69B46026-52Module Assy65B47511-113Accessory Box Assy233U1059-3Module Assy69B46121-13Module Assy65B50701-307Shell Assy65B46118-70Module Assy65B46040-9Module Assy1011751-055-FG05Video Arm Assembly65B47622-7Box Assy
Back to Boeing 747-230B