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.
65B70869-13SUPPORT69B00217-3BUSHING65B80122-2CASTING69B80643-3BRACKET69B14582-8ANGLE65B01313-2STRIKER ARM69B00349-2BUSHING69B71105-1ARM ASSY65B11667-17CLAMP65B14240-92ANGLE65B14240-21ANGLE65B14240-37ANGLE69B70488-6FAIRLEAD69B70731-3SOCKET-LOWER69B80887-1BRACKET ASSY65B05449-2BOLT UPPER TRIPOD69B14976-2BUSHING69B14601-1ANGLE65B83254-7SPACER-TAPERED65B05389-6INSERT65B01517-3PISTON69B15136-2CASTING, KEY65B19932-2CARRIER HALF65B80266-13VALVE ASSY65B14240-67ANGLE65B70327-10JUNCTION BOX65B14240-112FILLER69B00397-2NUT69B81783-11CLIP65B70468-4BOX SIDE65B11667-20CLAMP69B14297-5CLIP65B70287-158CONDUIT ASSEMBLY, WI69B40657-3STIFFENER65B01356-8FRAME - MECHANICAL T69B14568-5WEB65B70285-6PIN ASSY65B80452-6CASTING69B84222-1RETAINER65B05462-2STRUT - UPPER SIDE69B00359-3BUSHING65B14240-85SKIN69B80993-3RETAINER65B05316-6TUBE ASSY69B70812-3SEAL69B80993-3RETAINER69B80300-6STRAP65B80119-1BRACKET162U1500-19COMPONENT ASSY65B01553-1ADAPTER
Back to Boeing 747-221F