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.
1167865-30Cable Assembly1167850-55Cable Assembly727700-33Measuring Stick Assembly727700-99Fuel Measuring Stick1167015-140Audio Control Panel1167879-48Cabel Assembly1167890-102Cable AssemblyIndex List No. 495300Passenger Game System617-5439-002SCREEN INSTL TRANSLINDEX LIST 062-0142VIDEO ENTERTAIN SYSTEM727700-88Fuel Measuring Stick980-9000-009REPRODUCER AUDIO ENT.621920Video Entertainment Systems1167878-45Cable Assembly1167010-141Audio Multiplexer1103102Terminator1167866-33Cable AssemblyDWG No. 620234Video Entertainment Systems727700-75Fuel Measuring Stick1167877-44Cable Assembly1167890-117Cable AssemblyDwg. List No. 488745Video Projection System727700-73Fuel Measuring Stick727700-43Fuel Measuring Stick1167869-41Cable Assembly652-4347-001ADAPTER ZEE MARK VI QRM EUD617-4528-002VIDEO PROJ INSTL910030-5107Digital Interface Unit1167858-18Cable Assembly727700-70Fuel Measuring Stick1103099Terminator1167864-29Cable Assembly1052-16CAdapter1167890-113Cable Assembly1167855-14Cable Assembly1167001-140Cabin Test Module4259-20Lavatory Drain Plug1167858-19Part Name Cable Assembly617-4314-004MOUNTING PLATE ASSY1150410-100Central Switching Unit1167853-10Cable Assembly1167873-214Cable Assembly1167860-23Part Name Cable Assembly727700-49Fuel Measuring StickIndex List No. 494921Video Entertainment Systems617-4528-003VIDEO PROJ INSTL980-9000-004TAPE MACHINE AUDIO1167894-54Cable Assembly60B40125-208Seat Electronics Box1167871-205Cable Assembly
Back to Boeing 747-230B