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.
CN0966A16A10SN-040CONNECTORCN0966B14G07P6-040PLUG-832-9548-011Core Software for CMU-900 (822-1239-151)CN0966B14G15S9Y040PLUGC48-16R14Y15P-430PLUGCN0966B14G03P9-040CONNECTORC48-16R14-7P6-415PLUGCN0966A14A04SN-040PLUGCN0966A14A07PN-040PLUGCN0966B14G07S8-040CONNECTORCN0966B12S12SNY040CONNECTOR832-9548-007Core Software for CMU-900 (822-1239-151)CN0966B12G03PN-040CONNECTORCN0966A12A12SNY040CONNECTORCN0966A14A07SN-040CONNECTORCN0966B14S07S8-040CONNECTORCN0966A12A03S9-040PLUG832-1748-201Core Software for CMU-900 (822-1239-151)C48-16R18-14P-430PLUGCN0966B12S03S8-040CONNECTORCN0966B12G12P7Y040CONNECTORCN0966B10G05S8Y040CONNECTORCN0966B14G07S9-040CONNECTORCN0966B10G05S10Y040CONNECTORCN0966B10G05S7Y040CONNECTORCN0966A10A05S6Y040CONNECTORCN0966B12S12PNY040CONNECTORCN0966B10S05S6Y040CONNECTORCN0966B14G15P8Y040CONNECTORC48-16R14Y12P9-406CONNECTORCN0966B12G03P8-040CONNECTORCN0966B14G07S7-040CONNECTORCN0966B10S05S7Y040PLUGCN0966A10A05SNY040CONNECTORC48-16R22Y55P8-402PLUGCN0966A14A07P7-040CONNECTORC48-16R22Y55S8-402PLUGCN0966B14S07P7-040CONNECTORC48-16R16-10S-430PLUGCN0966B10S20S6-040CONNECTORC48-16R14-7S-415PLUGCN0966A14A07S6-040CONNECTORCN0966B16G10P7-040PLUGC48-16R20Y28S9-406CONNECTORC48-16R14Y12P7-406CONNECTORCN0966B12G12P6Y140CONNECTORC48-16R20Y28P7-406CONNECTORL8901609-1Seal Assembly-Outer SleeveC48-00R14-3S-406CONNECTORC0909A10-05S6Y040CONNECTOR
Back to Boeing 747-230B