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.
416U6037-25D-RING ASSY65B54025-7HINGE ASSY65B60553-70DIVIDER ASSY65B48695-42DUCT ASSY65B57619-43PACKBOARD ASSY65B57634-30PLATE MTG65B57638-48CROSS COVER ASSY65B54025-26RUB STRIP65B57638-61VELCRO HOOK69B54819-1GUARD65B54025-30HINGE ASSY69B52050-2GUARD69B51512-1SPRING65B57619-15PAD69B55465-5DOUBLER65B52480-13STRAP65B54025-1PANEL ASSY69B52096-6PIN65B52752-20PACK416U6028-1HOOK PLATE69B53610-1CLIP65B52726-39STIFFENER65B57636-48PACKBOARD ASSY65B57391-100SLIDE PACK ASSY65B52480-25COVER ASSY65B58546-34COVER ASSY69B55639-3WINDOW-GAUGE65B57638-59SIDE COVER65B52520-12PACKBOARD65B57391-134SLIDE PACK ASSY65B57636-57PACKBOARD ASSY65B57391-144SLIDE PACK ASSY65B53244-1GIRT BAR ASSEMBLY65B58537-30REINFORCEMENT STRAP69B54541-2PLATE65B60323-13DIVIDER ASSY416U6012-2MTG PLATE ASSY65B67367-27NET-ARTICLE RETAINER69B55794-1SPRING ASSY65B54026-24FABRIC65B52726-112COVER65B54556-17MECH65B52479-12PACKBOARD ASSEMBLY65B56055-3COVER65B57619-36RUB STRIP65B54026-22STRIP ASSY65B54556-9MECH69B53273-1STRAP69B52096-2CABLE69B55479-1BLOCK ASSY
Back to Boeing 747-230B