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.
65B83251-67STRAP ASSY65B05172-18TUBING SUPPORT65B08845-2PIN69B80626-5WASHER69B04008-3BOLT ASSY65B19935-1SLEEVE69B04155-1WASHER65B70518-27CONDUIT ASSY65B10197-21WASHER69B13380-5BEARING ASSY69B42183-1SUPPORT ASSY69B04134-1LOCK-TAB65B08104-44BUSHING-FLANGED65B10713-14BRACKET ASSY65B05193-3SLEEVE-AXLE66-12687-1Pin69B00311-1SLEEVE65B47753-2SWITCH SUPPORT69B80997-8BRACKET ASSY69B04047-1NUT65B05144-3ROLLER ASSY66-9776-1Collar65B70287-165CONDUIT ASSEMBLY65B70298-11FLEX CONDUIT ASSY69B14917-1PLUG ASSY65B53931-4Bracket Assy65B05467-1SPACER69B00245-1WASHER,TANG SPECIAL69B00306-2WASHER, SPRING RET65B08862-3INSERT ASSYBACN10JD3CDNUT, CASTELLATED69B00187-1HALF RING69B04082-1WASHER65B08104-194Bushing-Flanged69B71278-1PIVOT ASSYBACP11K4PACKINGBACB30LJ4D15BOLT, HEX HEADBAC27ELG21MARKER65B08865-7INSERT ASSY69B04084-3BOLT ASSY69B70231-11BOX CONNECTOR69B80882-1PIN65B04251-10Arrow65B01361-3LEVER ASSY69B83355-4BRACKET65B05481-3BOLT ASSY69B04024-1NUT69B70828-4BRACKET ASSY69B40672-1ACTUATOR ASSY65B19934-4Carrier Assy
Back to Boeing 747-230B