Boeing 747-221F
PMA parts · 57,567
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-200F 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-200F 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.
69B80887-1BRACKET ASSY65B01585-26CHANNEL69B14571-2FAIRING65B70509-11BRACKET69B00344-2BUSHING65B05317-7TUBE ASSY65B18278-1ADAPTER65B70468-6END PLATE69B70231-11BOX CONNECTOR69B14571-2FAIRING69B14772-1RUB BLOCK65B01437-5SPINDLE ASSY69B70442-3PLATE69B80168-14WASHER69B70789-7BRACKET65B05290-957D/STRUT69B83355-3BRACKET69B00207-1BUSHING65B84896-11ANGLE65B14240-20ANGLE69B14583-4ANGLE65B84896-14ANGLE65B14240-144WEB69B14295-4ANGLE69B04151-4BUSHING69B70613-4BRACKET ASSY65B80113-3BRACKET69B14582-8ANGLE69B00382-1BUSHING69B00353-2BUSHING69B14558-3RIB69B04172-2PIN69B00367-2BUSHING69B13315-4BUSHING65B80113-4BRACKET69B14977-1BUSHING69B70773-6BRACKET65B14240-17TEE65B01313-1STRIKER ARM ASSY69B00355-1SPACER65B84896-2BRACKET69B71131-1STRAP69B14570-2ANGLE65B82046-10BRACKET69B80358-30ACTUATOR ASSY69B80168-13WASHER65B70721-11COVER ASSY69B70828-5PAD69B42183-2RUBBER PAD65B01529-30TUBE ASSY
Back to Boeing 747-221F