Boeing 747-400D
PMA parts · 105,720
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-400D 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-400D 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.
ATF-12-T8BearingACMKP16BS FS428BearingKP29BS FS428BearingAACREP4MS7-2BearingATL-12-T8-1BearingAAREP4FL5BearingR9105PP A4298BearingKP23BS FS428BearingAHRSC-3CFR11BearingR207PP A4298Bearing233U4204-17Module Assy - Gen MAKP25BS FS428BearingPACMKP3A FS428BearingKP4AR13 FS428BearingACMKP4A FS428BearingPACMKP20A FS428BearingAACREP3MR3BearingKP4R16 FS428Bearing6NBC914YZPBearingPACMB538DD FS428BearingAC-50483-T8BearingKP48BS FS428BearingACMKP5A FS428BearingATL-10-T8BearingACMB539DD FS428BearingAC-49827-T8BearingR9109PP A4298BearingR9108K A4298BearingAC-50479-T8BearingPACMKP5A FS28BearingPACMKP8A FS28BearingAAREPB3N3BearingREP4H5-2 FS436BearingAACREP3M6ABearingAC-50483BearingATF-20-T8BearingAHRSC-4CTKR16BearingR9305K A4298BearingACMKP37BS FS428Bearing233U4203-1009Module Assy - SquibAACREP3M6-2NBearingR9308PP PRB A4298BearingACMB542DD FS428Bearing7NBK1021YZPBearing27906CM005-301Crew Rest Emergency Light Instl Kit27906CM004-305Bunk Curtain and Header Instl Kit27906EM003-301Flt Crew Rest PC Power Electrical Instl Kit27906CM006-301PED/ISPS Bracket Instl Kit27906EM002-301Flt Crew Rest Emer Lts Electrical Instl Kit27906MM002-301Crew Rest Heater/Gasper Instl Kit
Back to Boeing 747-400D