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.
015U0579-73Fitting69B51210-2BRACKET65B14054Y9Fitting65B08319-19Stop Fitting69B18880-1BUSHING65B11743U3FITTING65B12239U3CHORD65B15256U80Splice Ftg015U0579-74TOP KIT-FITTING65B11743U4FITTING015U0579-77Fitting65B11744U3FITTING65B14056U1BEAM65B15629Y6WEB65B08175U18CHORD69B13823Y3FITTING ASSY65B22858U5SUPPORT65B11744U4FITTING654U6624-197Support Fitting Assembly65B08208-612Stop Plate69B13823Y4FITTING ASSY69B15392Y3RETAINER69B10566Y9HINGE ASSY69B13650-600Retainer - Hinge Pin65B12091Y10FITTING ASSY65B15629Y5WEB69B15392Y2RETAINER69B15392Y1RETAINER69B15392Y4RETAINER69B11630Y5FITTING ASSY65B08175U17CHORD65B12091Y9FITTING ASSY69B15392Y5RETAINER65B15450-45Attach Fitting69B14547-7Striker Plate65B22858-8Support65B11654-4Lens65B14061-2Channel69B10143-4Key65B15089-9Filler69B13736-1Stop Cap65B10920-141Seal65B08347-46Latch Track69B11987-3Link Assembly69B11672-1Clip69B41154-1Clip Assembly65B11743-4Fitting65B21129-17Bushing65B11744-3Fitting65B12239-3Chord
Back to Boeing 747-230B