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.
69B71105-1ARM ASSY65B01484-6NUT ASSY-SPECIAL69B04172-2PIN69B70981-2FILLER - OUTBD69B42182-1CHANNEL69B84222-1RETAINER69B80643-2BRACKET65B01442-5LOWER SPINDLE ASSY65B70327-8JUNCTION BOX ASSY69B81783-12BRACKET69B70828-2ACTUATOR BRACKET69B13120-4CLAMP69B14581-3ANGLE69B71132-1BUMPER ASSY65B14240-143ANGLE69B70231-1NUT-JAM69B40340-3BRACKET-GIMBLE65B83251-42CHANNEL65B14240-105FILLER60B70001-34FLEX CONDUIT69B00336-1WASHER65B83251-38BRACKET69B00343-2BUSHING69B15565-3BRACKET69B70789-6BRACKET65B70514-5COVER69B71247-3BRACKET69B14554-5WEB69B71104-1HANGER ASSY65B83248-11NAME TAG65B70345-3PULL BOX ASSY65B14240-24COVER69B80886-5CLIP65B82045-11ZEE69B14573-2WEB65B83251-41CHANNEL65B18260-1BULKHEAD65B01481-8ROLLER SUPPORT69B00224-3BUSHING65B14240-7SKIN-UPPER69B80648-3BRACKET69B14584-5ANGLE69B80300-6STRAP69B12970-12LUG65B14240-103FILLER69B70771-7CHANNEL69B14551-1ATTACH PLATE ASSY69B14976-1BUSHING69B80168-18WASHER65B80113-1BRACKET ASSY
Back to Boeing 747-230B