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.
65B14240-121SKIN69B40690-2SPACER69B70733-6SPACER69B70625-2LINK65B84896-1HAND HOLD ASSY65B82570-3BAND65B70338-7TUBE65B81706-2CASTING65B01485-1HOUSING SPRING69B80655-9BRACKET69B80689-3SLEEVE69B12830-1CHANNEL ASSY65B14240-120ANGLE69B80423-1BRACKET65B70285-3ROD69B80997-10TUBE65B01444-8INNER CYL ASSY65B14240-24COVER69B83909-1CLAMP65B01585-21BRACE69B14300-4ANGLE65B83251-61PAD, RUBBER65B82570-2INDEX BAND ASSY69B00388-1BUSHING69B04121-1BUSHING69B42183-2RUBBER PAD69B10838-2SPACER69B00373-3BUSHING65B14240-57RIB69B00360-2BUSHING69B00160-1BUSHING69B71116-1BRACKET69B14559-4WEB69B04057-1BUSHING65B01585-30BRACE ASSY69B70789-6BRACKET69B71107-1ARM ASSY-65B70869-13SUPPORT69B00217-3BUSHING65B80122-2CASTING69B80643-3BRACKET69B14582-8ANGLE65B01313-2STRIKER ARM69B00349-2BUSHING69B71105-1ARM ASSY65B11667-17CLAMP65B14240-92ANGLE65B14240-21ANGLE65B14240-37ANGLE69B70488-6FAIRLEAD
Back to Boeing 747-230B