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.
65B05195-2SLEEVE AXLE69B00174-2BUSHING65B70514-2PULL BOX ASSYBACB30UU6K19BOLT. 12 PT HEADBACC14AD06JCAP69B00316-1PLUG69B04021-1PLATE ASSY-STOP69B81658-2PIN65B05463-4BOLT-STRUT/SPINDLE65B82585-4Actuator Assy69B70950-1BLOCK65B70327-8JUNCTION BOX ASSY65B01498-7Bearing Assy65B08103-70BUSHING-PLAIN65B08882-3RETAINER ASSY69B00317-1WASHER-TANG65B05296-3PLUG ASSY65B08103-258Bushing-Plain69B11232-2NUT-SUPPORT PIN65B01314-10STRIKER ARM ASSY65B80254-158Channel65B01585-13BRACKET ASSY69B11223-3COLLAR69B13308-1SPACER, THREADED65B05452-3BOLT ASSY65B01553-1ADAPTER65B08882-5RETAINER ASSY65-35436-5Retainer66-15424-1Plate-Bearing65B08103-69BUSHING-PLAIN65B83251-39RADIUS FILLER66-12688-502Bushing69B82574-1SUPPORT ASSY65B80113-2BRACKET ASSY69B13363-3KEY65B08104-200Bushing-FlangedBACU24AA0806TUNION, BULKHEAD65B08104-224Bushing-Flanged65B08104-201Bushing-Flanged65B08104-226Bushing-Flanged65B05449-2BOLT UPPER TRIPOD332U2112-3Reinforcement Pad65B05260-2BOLTBACB30PN12-24BOLT, EXT WRENCHING69B04023-1WASHER-KEY69B00203-2NUT-SPACER65-35436-14RetainerBACC14AD06JLCAP69B70828-5PAD65B70537-19CONDUIT ASSY
Back to Boeing 747-230B