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.
16135-21Hose Assembly10842-1Seal16135-56Hose Assembly14148-2Hose Assembly16135-16Hose Assembly69B00489-5BUSHING65B20254-4PIN, STOP16135-23Hose Assembly10842-2SealMM4001-(x)-(x)Clip nut (SUPP-01)P00054Turbine Rotor Matched SetAD-1175136-1Capacitor Tube Assy.65B90643-3ROD69B94177-1WASHER65B07948-61SEAL141U1021-350ANGLE69B10070-2SPRING-COMPRESSION63-2892-2ROD END141U1021-119TIE69B90623-1BEARING PLATE66-12688-1BUSHING69B94145-1SEAL - FIRESHIELD65B94286-11PLATE65B94286-12PLATE015U1743-5FLANGED CUP654U6625-666KITSP3810-01-4038Cartridge Valve Assy.SP3810-01-4017Hydraulic TimerSP2510-00-6050Plunger GuideAECI PN P4-01-0021AECBattery PackAECI PN P2-07-0003-001AECFlashlight Assembly4510-0001-01Beverage MakerKT743502Liner - PumpKT742140Liner - PumpWF336014Filter Element, HydraulicWF336112Filter Element, HydraulicWF336109Filter Element, Hydraulic69B48277-13PRINTED CIRCUIT ASSY285U0294-200CRADLE ASSY - CABIN INTERPHONEWF335105Filter Element, Lube280T1003-1SHORTING RECEPTABLE ASSY - CODING, AIRCRAFT I/DWF336991Filter Element, Oil69B48251-1MODULE ASSYWF336859Filter Element, OilWF331069Filter Element, OilWF336017Filter Element, Hydraulic69B47534-1PREAMPLIFIER ASSYP2793864-101DiaphragmP2793873-101Diaphragm AssemblyP2813961-101Tapered Pin
Back to Boeing 747-230B