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.
65B41664-3CUSHIONED CLAMP ASSY65B18278-1ADAPTER69B70796-5BOSS-69B80993-2RETAINER60B00210-7VALVE ASSY69B14570-1ANGLE69B00212-1BUSHING65B84896-8ROD69B70619-1GUSSET65B19929-2GUIDE BLOCK ASSY65B81493-4MOUNTING PLATE65B01378-1NUT ASSY60B00180-25BEARING, PLAIN, SPHE65B70468-1BOX ASSY69B14586-1WEB69B00217-3BUSHING65B08854-10SPHER BRG ASSY-AFT69B13121-3CUSHION65B84896-6BRACKET69B14297-6CLIP161U1001-2BUSHING69B80877-1GUIDE ASSY69B70440-1WASHER65B14240-18TEE65B05378-3BOLT65B83183-5UPPER SUPPORT65B14240-71FILLER65B47753-2SWITCH SUPPORT69B71116-3FILLER65B70468-3BOX ASSY-WELDMENT69B00348-2BUSHING65B11667-9BRACKET ASSY69B14772-1RUB BLOCK65B70468-2COVER ASSY65B70509-6BRACKET ASSY69B00247-1BUSHING65B82558-2ACTUATOR ASSY69B83911-4PLATE69B00176-1WASHER65B14240-36ANGLE65B14240-42ANGLE69B80655-2HOSE BRACKET ASSY69B00368-1BUSHING69B14976-1BUSHING69B80886-6CLIP69B83582-1UNION65B80122-1BRACKET69B13300-1SHIM65B01529-30TUBE ASSY69B00336-1WASHER
Back to Boeing 747-230B