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.
G80763004-17SpacerG80762007-15, G80762007-17, G80762007-19PlateG80762015-5Clip AssemblyG80762007-21Strap AssyG80763004-1, G80763004-3HousingG80763004-23HousingG80763004-21BushingG80763004-25, G80763004-5PlateG80762007-13Plate AssyG80763004-7, G80763004-9, G80763004-11Pad2038-0P1RSheet, Foam6534-18RPacking2550-3RCrush Washer2779-1RAnchor4010033-1RNut5408-1RGasket2897-3RPump2287-1RMold, Potting Compound4814-1RSpacer015U1743-5FLANGED CUP5723-1RLabel, Refrigerant Content Oil5408-2RGasket4011075-3RScrew6534-22RPacking2721-1RFilter, Air2740-2RToggle7119-1RReceptacle6534-15RPacking267-0P15RStrip, Hook6534-19RPacking7118-5RHead, Top Assy5408-3RGasket654U6625-666KIT141U1021-350ANGLE6534-10RPacking141U1021-119TIE2950-1RFulcromM1547770-5Ball Bearing2793904-101WDPin358596-1WDBearing, Annular Ball358595-1WDBearing, Annular Ball3176618-1WDBearing, Annular Ball8614PBW-52311Marker-Bin etc.8614PDG-11518Marker-Seat row etc.A5389VMMMarker-To be determined8614PRW-15924Marker-Pull etc.8614PGW-15360Marker-Load etc.8614PDG-11525Marker-Seat row etc.A5095VBCMarker-Inflate etc.8614PDG-11579Marker-Seat row etc.
Back to Boeing 747-230B