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.
302T0200-71GBushing - Nacelle Strut302T0200-23GBushing - Nacelle Strut302T0200-74GBushing - Nacelle Strut302T0200-40GBushing - Nacelle Strut302T0200-43GBushing - Nacelle Strut302T0200-99GBushing - Nacelle Strut302T0200-100GBushing - Nacelle Strut302T0200-90GBushing - Nacelle Strut302T0200-117GBushing - Nacelle Strut69B52215-4GBearing - Support Cover Retainer, Off-Wing Escape302T0200-28GBushing - Nacelle Strut302T0200-54GBushing - Nacelle StrutP00846Diaphragm832-1748-201Core Software for CMU-900 (822-1239-151)P00916Shaft Assembly, Drive66-23351-8EYE BOLT ASSY65B50749-8COVER ASSY65B08807-9INSERT ASSY69-43972-1SPRING272T6124-3SLEEVE65B41664-2CUSHION161U0002-1PIN-LOWER BEARING140U4001-1SPRING CLIP65-35436-15RETAINER161U0002-2PIN-LOWER BEARING69-35969-1WASHER66-2848GASKET-CHECK VALVE284T0748-1GASKET - HORNKT2707788-1Disk-Brake45399017SDCushion, Seat Bottom311U2031-61BLANKET ASSY65B80973-1PULLEY ASSYPF62D1066DiaphragmB747-3131-0001Micro Quick Access Recorder Installation Kit702409-1078ATSExit Indicator Assembly702409-1007ATSExit Indicator Assembly702409-1002ATSExit Indicator Assembly207377-1007ATSLens Assembly207377-1004ATSLens Assembly207377-1010ATSLens Assembly207377-1078ATSLens Assembly207377-1002ATSLens Assembly207377-1001ATSLens Assembly207330ATSBase Assembly702409-1010ATSExit Indicator Assembly702409-1001ATSExit Indicator Assembly702409-1004ATSExit Indicator Assembly140N2022-1Valve Assy104U4001-6Spring Clip104U4001-3Spring Clip
Back to Boeing 747-230B