Boeing 747-230B
PMA parts · 62,097
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-200B 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-200B 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.
65B80143-1CLAMP ASSY65B70410-7COVER65B01502-7ACTUATOR ASSY69B00236-2BUSHING65B40387-1HOUSING ASSY69B14584-6ANGLE65B19935-1SLEEVE69B14582-7ANGLE65B70869-13SUPPORT65B70338-12LINK ASSY-LOWER65B14240-127WEB69B13122-3RADIUS FILLER65B16450-3STRAP69B70796-4BOSS-65B01378-2NUT65B70410-13INSERT65B83251-37BRACKET65B05187-30OUTER CYLINDER65B14240-35ANGLE65B14240-26ANGLE69B83582-1UNION69B70238-3PIVOT69B14573-2WEB69B00152-1BUSHING65B19983-1PIN69B14551-1ATTACH PLATE ASSY69B80168-14WASHER65B14240-9COVER65B14240-18TEE69B71107-2ARM ASSY-65B14240-45ANGLE69B15565-1BRACKET ASSY69B70997-7FAIRLEAD ASSY-65B05467-1SPACER69B70442-8WASHER69B00166-1RADIUS FILLER69B70735-1BALL - SWIVEL65B14240-28ANGLE65B70721-1TERMINAL BOX ASSY69B12830-3RADIUS FILLER69B13121-2CUSHION65B08862-4INSERT LUBRICATION65B01442-5LOWER SPINDLE ASSY69B70612-1BRACKET-65B80124-2CASTING65B14240-15WEB65B01529-29TUBE ASSY69B70828-1ACTUATOR BRACKET65B05172-17TUBING SUPPORT65B01377-2PUSH ROD SWIVEL
Back to Boeing 747-230B