Boeing 747-SR
PMA parts · 38,389
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, ['747SR 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, ['747SR 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.
65B08104-77BUSHING-FLANGED69B04102-1WASHER-TANG65B05471-4PIVOT PIN69B00177-2WASHER66-12688-1Bushing65B18247-1BULKHEAD ASSY69B14927-2REDUCER69B04139-1NUT65B05190-1WASHER69B70488-6FAIRLEAD69B04027-1NUT65B05489-1COUPLING69B40660-13SHIM69B04108-3NUT, SPECIAL65B05271-3BRACE ASSY65B70518-25CONDUIT ASSEMBLY69B83911-4PLATE65B83251-67STRAP ASSY65B05172-18TUBING SUPPORT65B08845-2PIN69B80626-5WASHER69B04008-3BOLT ASSY65B19935-1SLEEVE69B04155-1WASHER65B70518-27CONDUIT ASSY65B10197-21WASHER69B42183-1SUPPORT ASSY69B04134-1LOCK-TAB65B08104-44BUSHING-FLANGED65B05193-3SLEEVE-AXLE66-12687-1Pin69B00311-1SLEEVE65B47753-2SWITCH SUPPORT69B04047-1NUT65B05144-3ROLLER ASSY66-9776-1Collar65B70287-165CONDUIT ASSEMBLY65B70298-11FLEX CONDUIT ASSY69B14917-1PLUG ASSY65B05467-1SPACER69B00245-1WASHER,TANG SPECIAL69B00306-2WASHER, SPRING RET65B08862-3INSERT ASSY69B00187-1HALF RING69B04082-1WASHER69B71278-1PIVOT ASSYBACP11K4PACKINGBACB30LJ4D15BOLT, HEX HEADBAC27ELG21MARKER65B08865-7INSERT ASSY
Back to Boeing 747-SR