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.
ACMKP29BS FS428BearingACMDPP4 FS428Bearing7NBC1015YZPBearingMKP16B FS428BearingR9307K A4298BearingCCTT-42075BearingGRR4M6-7 FS428BearingREP5M7 FS428BearingMKP6A FS428Bearing65B46214-1085Module Assy. - Fuel CAHTT-46093BearingKP49B FS428BearingR207K A4298BearingAHRSC-1CFR6BearingMKP10A FS428BearingKSP3L FS428BearingR9306PP PRB A4298BearingCC-20209BearingPACMB545DD FS428BearingKSP5A FS428BearingKP33BS FS428Bearing16NBC2028YZPBearingATF-14-T8BearingREP3H5 FS436BearingKP10 FS428BearingKP8 FS428BearingREP4M7-2 FS428BearingAACREP4M7-2BearingKP21B FS428BearingGRR4M7-2 FS428BearingACMB540DD FS428BearingPACMKP6A FS28Bearing65B46214-1103Module Assy. - Fuel CREP3M6-2N FS428BearingAACREP4ML6BearingAC-41619BearingKP5 FS428BearingPACMKP23BS FS28BearingKP23B FS428BearingCDTT-45743BearingDSP4 FS428BearingATL-6-T8BearingYN56WOPP2 CR A1144BearingAHRSC-6CFR16BearingCCTT-44772BearingKP4A FS428BearingATF-8-T8BearingREP4F5 FS428BearingKP20A FS428BearingAC5538WZZ FS428Bearing
Back to Boeing 747-230B