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.
65B54025-28PANEL ASSY69B54819-2GUARD65B54025-2PANEL ASSY69B50066-2CLIP65B52513-7PANEL65B52726-83STIFFENER65B52726-71COVER65B57634-10CLIP ANGLE65B63505-1STRAP ASSY65B57636-56PACKBOARD ASSY65B56055-10COVER65B52726-70COVER65B58187-1BRACKET416T2164-19PIN-ROLLER65B58335-30ESCAPE SLIDE ASSY65B52726-109FLAP65B57391-109SLIDE PACK ASSY416U6014-2BRACKET ASSY65B52726-130COVER65B43178-1BAG ASSY69B52062-1PLATE69B51430-1ANGLE69B53551-2BRACKET65B58537-10STRAP ASSY65B58335-4TIE65B54026-21COVER ASSY65B57636-67PACKBOARD ASSY65B52480-42STRAP65B52585-10PANEL65B52414-6TUBE ASSEMBLY69B55465-3RIVET SPACER65B54931-14TUBE65B52727-4SPACER65B52520-16PACKBOARD ASSY69B51442-4LANYARD65B57391-146SLIDE PACK ASSY65B58188-1LATCH ASSY69B55794-2SPRING ASSY65B58476-1STWG POUCH ASSY416U6037-30LACING CORD65B57636-92PACKBOARD ASSY69B55637-3STIFFENER BKT65B54026-23REINFORCING STRIP65B57636-22PACKBOARD ASSY69B55916-2SUPPORT ANGLE65B57634-18CHANNEL65B52585-8PANEL416U6001-3SPACER65B52726-30STIFFENER416U6029-2LINK ASSY
Back to Boeing 747-230B