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.
65B70287-149CONDUIT ASSEMBLY, WI65B01529-47ACTUATOR ASSY LH65B80254-144CHANNEL65B83251-61PAD, RUBBER65B01515-1END CAP69B42739-1RADIUS FILLER65B83251-51STRAP65B14240-32ANGLE69B00186-1HALF RING65B01473-1DRAG STRUT ASSY - LO65B14240-64FILLER69B13123-2R SIDE RIB69B04069-1BUSHING69B14977-4BUSHING65B05172-18TUBING SUPPORT65B14240-10WEB69B13121-3CUSHION65B01518-21ROD69B16428-1STOP65B70869-15BOX69-24433-3RETAINER ASSY65B83183-4UPPER SUPPORT ASSY69B00156-1SPRING69B00381-1WASHER-TANG, SPECIAL69B71105-4BOSS65B81492-4SUMMING LEVER69B14299-1WEB-AFT69B00229-3BUSHING65B14240-19ANGLE69B14299-3WEB-FWD69B70980-1INDEX BRACKET65B70287-150CONDUIT ASSEMBLY, WI69B80423-1BRACKET69B14295-2INTERCOSTAL69B14584-1ANGLE65B80124-1BRACKET69B70832-3INDEX BRACKET65B14240-110SPLICE CHANNEL69B70620-2TAB-MOUNTING69B83911-3PLATE65B40387-3TUBE69B00357-2NUT-SPECIAL65B01529-19CUSHION69B70997-12SUB KIT ASSY65B01585-18BRACKET65B11667-5ATTACH FTG ASSY65B70509-12BRACKET69B14584-2ANGLE65B05135-5TORSION LINK ASSY -69B80647-2BRACKET
Back to Boeing 747-221F