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.
69B42183-1SUPPORT ASSY65B05160-64COMPLETE T.L ASSY65B01356-7FRAME - MECHANICAL T69B00259-2BUSHING69B40340-1GIMBLE ASSY-65B14240-64FILLER65B14240-47SKIN69B14583-2ANGLE65B70287-159CONDUIT69B13377-1BUSHING, BEARING69B80886-4CLIP69B80655-5BRACKET69B80037-1NUT69B70997-7FAIRLEAD ASSY-65B80113-3BRACKET65B82177-9PULLEY BRKT ASSY65B01585-17BRACKET69B00286-2BUSHING65B05350-3BUSHING69B80640-1WASHER65B01498-6BEARING65B14240-17TEE65B82177-9PULLEY BRKT ASSY65B70518-36CONDUIT ASSY-69B70619-2GUSSET69B80358-32ACTUATOR ASSY69B00241-4BUSHING - FEMALE END65B82045-11ZEE65B01529-29TUBE ASSY69B71234-1PLATE65B80129-7HOSE ASSY273U0019-1GUIDE65B84896-6BRACKET69B00237-3BUSHING65B14240-62ANGLE69B00314-1BUSHING65B01585-16BRACKET69B14581-2ANGLE65B01498-6BEARING65B01585-33BRACKET ASSY69B80226-1BEARING65B14240-112FILLER69B70732-2BOSS65B19941-7FITTING69B00216-3BUSHING65B01314-12STRIKER ARM69B00187-1HALF RING69B70796-1BOSS-65B14240-119ANGLE69B00388-1BUSHING
Back to Boeing 747-221F