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.
65B52480-14STRAP69B92434-1COVER65B54025-23PANEL65B58546-28COVER ASSY65B57634-22COVER311U2031-78BLANKET ASSY65B58537-29MAIN COVER ASSY65B52726-66COVER65B60166-20NET ASSY65B54556-13MECH69B58740-4BRACKET69B52096-10CABLE ASSY416U6037-28STIFFENER416U6007-1GUARD65B60810-7NET ASSY65B52511-2HINGE65B52480-10STRAP69B53273-4CUSHION65B52752-18SLIDE416U6017-1SHAFT CONNECTOR65B52585-7PANEL65B52502-2PANEL65B65132-4LANYARD65B52726-82STIFFENER65B52480-21STRAP65B60165-2NET ASSY65B52726-64FLAP69B52215-1BEARING65B54931-11COVER69B55831-4SPRING65B67367-26NET-ARTICLE RETAINER69B54482-1ANGLE65B64029-13MAIN COVER ASSY65B25950-1NET ASSY65B57638-60SIDE COVER69B53284-1STRIKER65B57636-39SHELL ASSY65B58537-22REINFORCEMENT STRAP65B57692-1PIVOT BRACKET ASSY69B52864-1CHANNEL416U6037-15TOP COVER ASSY69B55465-6PLATE SPACER65B57391-91SLIDE PACK ASSY65B54553-46BRACKET ASSY-65B52519-15PACK416U5021-2PACKBOARD AND65B57391-40SLIDE PACK ASSY65B54219-44PACK69B51510-2GUIDE69B52815-6BRACKET
Back to Boeing 747-230B