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.
69B55466-1LATCH CHANNEL416U6042-2STREAMER65B57619-35PACKBOARD65B54580-16NET65B57636-94PACKBOARD ASSY69B55905-11SLIDER65B58314-2CONE, SLIDE/RAFT65B54931-13TUBE65B52512-11PANEL65B52480-20STRAP65B52480-29STRAP69B51509-4PULLEY65B58188-12PLATE65B50372-2STRAP ASSY OF65B52483-3COVER ASSY65B52480-38STRAP416U6020-1SHAFT COVER65B57638-62STRAP ASSY65B54025-16PANEL ASSY65B52726-97COVER65B54025-24PANEL416U6037-20STIFFENER65B52751-13PACK69B55912-1STRAP ASSY65B57636-59SHELL ASSY65B52727-11MECHANISM65B52502-10PACKBOARD65B58537-23MAIN COVER ASSY69B40294-11STRAP ASSY69B53535-2PAWL65B58476-2POUCH ASSY65B58188-6PLATE416U6016-1HOOK CONNECTOR65B60165-1NET ASSY69B52050-1TUBE SUPPORT ASSY65B57391-194SLIDE PACK ASSY65B57619-27PACKBOARD ASSY69B55970-1STRAP ASSY65B58188-3CATCH65B57391-145SLIDE PACK ASSY65B52519-12TIE69B53275-2PLATE69B51596-2CONE65B57391-5CORD65B58537-2MAIN COVER ASSY65B57633-12MOUNTING PLATE ASSY416U6037-24STIFFENER69B55477-1CHANNEL65B57636-64PACKBOARD ASSY65B54556-16MECH
Back to Boeing 747-230B