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.
65B57391-89SLIDE PACK ASSY69B53506-1BRACKET65B54026-14RELEASE CONES65B57633-7RELEASE MECH ASSY65B57634-25CHANNEL416U6024-1END PLATE65B67367-16NET-ARTICLE RETAINER453U0049-51FIBERGLASS BAG ASSY69B63810-1SPRING65B57638-57SIDE COVER ASSY69B53508-1BAIL416U6037-8POCKET69B55478-2DOUBLER65B57391-133SLIDE PACK ASSY416U6037-26WEBBING65B54219-11PLATE65B57636-75PACKBOARD ASSY65B57638-1SIDE COVER ASSY65B58546-31COVER ASSY69B52096-9CABLE ASSYBACS38A149A6NSTRAP ASSY65B57638-65CROSS COVER ASSY69B55476-1PIVOT STUD69B52096-8CABLE69B51667-1RETAINER65B58959-8STRAP65B52514-8PANEL65B58314-6PIN65B52726-140COVER69B52818-5TRIGGER416U6004-1CABLE ASSY69B43329-1HOSE ASSY65B52480-19STRAP69B55942-2GUIDE69B55840-1BELLCRANK65B25908-1DIVIDER65B58960-20STRAP ASSY65B57391-121SLIDE PACK ASSY69B51575-1CLIP65B52480-28COVER65B58546-25COVER ASSY65B52480-39STRAP65B54026-25FABRIC69B53546-3BELLCRANK65B56055-11COVER65B52513-8PANEL65B57636-6WIRE RETAINER ASSY69B52027-2BRACKET65B57391-67SLIDE PACK ASSY65B57636-13SHELL ASSY
Back to Boeing 747-230B