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.
69B04084-3BOLT ASSY69B70231-11BOX CONNECTOR69B80882-1PIN65B04251-10Arrow65B01361-3LEVER ASSY69B83355-4BRACKET65B05481-3BOLT ASSY69B04024-1NUT69B70828-4BRACKET ASSY69B40672-1ACTUATOR ASSY69B14103-3PIN ASSY69B00386-3NUT-WALKING BEAM65B05316-8TUBE ASSY65B05316-7TUBE ASSY65B05317-6TUBE ASSY69B70511-6BRACE69B00278-2NUT-SPECIAL65B08892-3BOLT69B13303-1LOCK-TAB65B08103-302Bushing-Plain65B83251-61PAD, RUBBER65B15945-11FITTING ASSY65B05378-3BOLT65B08868-1BRACKET69B12026-1SUPPORT-YOKE69B04133-3BOLT ASSY65B05456-3BOLT65B08872-2BOLT-TRUNNION PIN69B00355-1SPACER69B83017-1BOLT65B05222-3SLEEVE LUB ASSY65B23287-1BUSHING ASSY69B13390-1CLIP65B80254-115Block69B04044-3BOLT ASSY65B05412-5PIN ASSY65B05491-4BOLT69B80168-25WASHER65B83251-64PAD, RUBBER65B19937-1CARRIER ASSY69B04123-1BOLT65B05172-20TUBING SUPPORT ASSY65B81491-1PULLEY BRACKET ASSY69B04126-1PIN, SHEAR65B19933-1SLEEVE69B04097-2NUT65B01378-1NUT ASSY65B08104-37BUSHING-FLANGED69B00394-1WASHER-TANG, SPECIAL65B05444-4BOLT-UPPERSIDE BRACE
Back to Boeing 747-SR