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.
65B25046-2WEIGHT BALANCE69B14976-2BUSHING69B42005-4GASKET69-35374-4NUTPLATE ASSY69B40516-1GASKET69B55036-1CABLE ASSY69B01548-6BUSHING69B60251-1SPRING69B81740-18BUSHING69B01548-5BUSHING69B42448-16GASKET69B11323-3PIN ASSY69B00371-1BUSHING69B14925-1WASHER69B00632-3BUSHING-CLAMP-UP65B08579-7BUSHING69B00488-25BUSHING-PLAIN69B10918-1PIN ASSY69B80852-1SPRING65B15945-11FITTING ASSY69-45838-1GASKET69B14112-2SPACER69B81106-4BUSHING69B12343-1BUSHING69B13438-501WASHER69B02154-1BUSHING69B01542-1ADJ. WEIGHT69B00363-2BUSHING69B81740-23BUSHING65B80130-2BUSHING113U0013-16BOLT-SPECIALIZED65B60140-24CABLE ASSY69B13121-4CUSHION69B00314-1BUSHING65B83752-4GASKET69B00488-15BUSHING-PLAIN65B01985-603BUSHING65B82652-9CABLE ASSY FP1A65B83251-79SHIM-LAMINATED65B21129-17BUSHING65B08516-1BUSHING69B50918-1HOLDER ASSY69-43493-1THUMB NUT69B00480-2BUSHING, FLANGED69B63431-2SPRING - TORSION65B25046-1WEIGHT BALANCE69B81950-2BUSHING69B10870-1BUSHING69B90371-1CABLE ASSY69B04140-1WASHER, KEY
Back to Boeing 747-221F