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.
65B01379-1PUSH ROD ASSY69B70927-1ELBOW ASSEMBLY65B70468-3BOX ASSY-WELDMENT65B14240-65TEE69B83354-1PLATE69B70231-17ELBOW 45 DEGREES69B00334-2BUSHING69B00249-1BUSHING65B70491-2CONDUIT-RIGID69B80079-1TRANSFER TUBE69B19329-1SLEEVE-WING GEAR69B14810-2SPACER65B01437-6SPINDLE69B71132-2BUMPER65B01367-1PUSH ROD ASSY65B70869-29COVER69B14583-2ANGLE65B14240-12TOE ANGLE65B40653-13PLATE, REAR69B70613-3BRACKET ASSY69B70488-6FAIRLEAD65B01378-2NUT69B00187-1HALF RING65B84896-16BRACKET65B70338-10LINKWELD ASSY-LWR69B14579-2ANGLE69B13307-1BUSHING65B11135-3STRAP ASSY65B70869-24BRACKET69B70950-1BLOCK65B08826-2FOLLOWER69B00148-1BUSHING69B71286-3PLATE69B70828-5PAD69B00313-1BUSHING69B00253-2BUSHING284T0748-1GASKET - HORN65B14240-88SKIN69B71247-3BRACKET69B70620-2TAB-MOUNTING69B00212-1BUSHING69B70731-2SOCKET-UPPER69B14977-1BUSHING65B14240-39ANGLE65B14240-13ANGLE65B84896-13PAD65B05350-3BUSHING69B12970-12LUG65B05262-8BOLT65B01481-7ROLLER SUPPORT
Back to Boeing 747-230B