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.
65B38215Y1POST SUPPORT65B39010-10FITTING ASSY65B01990-2ACTUATOR FTG ASSY65B62115-2GUTTER65B03521Y47FAIRING65B15629U6WEB65B0185-14BRACKET ASSY65B10865U26SHEAR WEB65B15629-29WEB69B15700-2FITTING65B83019-2BRACE ASSY315T1045-4*COVER69B12619-2BRACKET69B62049-1FITTING69B63407-2FLOOR FITTING65B08548-604FITTING ASSEMBLY65B90729-12ROD ASSY65B90412-49FRAME65B01585-13BRACKET ASSY65B02060-1FITTING ASSY65B15644-1AFT ROLLER SPT ASSY69B01996-6SERRATED PLATE65B05887-6WEB ASSY BOND65B98819Y5AERODYNAMIC LIP65B10022-502FITTING ASSY65B21139-6SHROUD69B62265-1FLOOR FITTING65B63268-40QUICK RELEASE ASSY65B05172-20TUBING SUPPORT ASSY69B14501-3FITTING ASSY654U6625-1621FRAME-NAC STA 235.8569B90706-4PLATE ASSY65B22796-2FITTING ASSY65B93118U3CASTING65B41103U5STIFFENER65B63301-14PUSHDOWN65B13640Y1FAIRING65B62117-1COVER ASSY65B01990-1ACTUATOR FTG ASSY415T4305-3*SUPPORT FITTING65B01915Y429PANEL ASSY (LWR)65B70347-3BRACKET ASSY69B62109-1FITTING65B15525-8HINGE BRACE ASSY65B15256-80CHORD65B83427-1CROSS ASSY65B10022-25FITTING65B03560Y242SPLICE ASSY, BONDED65B50231-2CHANNEL ASSY65B03560Y241SPLICE ASSY, BONDED
Back to Boeing 747-230B