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.
BAC1522-855Miscellaneous, Plastic, ExtrudedBAC1522-943Miscellaneous, Plastic, ExtrudedBAC1522-794Miscellaneous, Plastic, ExtrudedVA-2530-R01Electro-Mechanical RelayVA-2540-H01Immersion Stick HeaterVA-2530-T01Water Tank Welded AssyVA-2530-H01Immersion Stick Heater AssyAG723000-27Gasket - Radio Altimeter AntennaAG822000-08Gasket - TCAS AntennaAG477000-01Gasket - GPS Antenna1314M14P01DECDisk-Deflection Limiter1314M14P01DECDisk-Deflection Limiter7066M26P02DECLimiter Deflection7066M26P02DECLimiter DeflectionDEC121750-1Shaft Assembly, Flexible97417-35-1Hose Assembly96431-2Hose Assembly95952C0094KK180Hose Assembly95952C0123TT175Hose Assembly115491-8Hose Assembly95952F0243FFHose Assembly115491-7Hose Assembly95952C0166CCHose Assembly224-2301-71DECWear Strip1378M16P01DECLink1378M17G01DECLink Assy-ArmDEC38-053-501CapacitorDEC59-001-501Hook-Engine Roller HingeDEC59-003-503Hook-Engine Roller HingeDEC59-089-501Hook-Engine Roller HingeDEC59-002-501Hook-Engine Roller HingeDEC59-003-501Hook-Engine Roller HingeSSMB541DDSD633BEARINGSSMB541DDSD633ZNBEARINGSSMB541DDSD683ZNBEARINGSSMB542DDSD633ZNBEARINGSSMB543DDSD633BEARINGSSMB542SD669BEARINGSSMB543DDSD633ZNBEARINGSSMB541DDSD685BEARINGSSMB541SD684ZNBEARINGSSMB542DDSD633BEARINGSSMB542SD634BEARINGSSMB541SD684BEARINGSSMB542DDSD668BEARINGSSMB541SD669BEARINGSSMB540SD686BEARINGSSMB542DDSD685BEARINGSSMB542DDSD683ZNBEARINGSSMB543DDSD668BEARING
Back to Boeing 747-230B