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.
S3387AerTrim LWS7361AerTrim LWS1247AerTrim LWS2916AerTrim LWS6782AerFilm LHRS014276AerTrim LWS06465-004-P2AerFilm LHRS013183AerFilm LHRS5109AerTrim LWS52267-007-P2AerFilm LHRS08222-001-P2AerFilm LHRS1512AerTrim LWS4713AerFilm LHRS3013AerFilm LHRS8708AerTrim LWS6808AerFilm LHRS010087AerTrim LWS013535AerFilm LHRS011792AerFilm LHRS13205-002-P2AerFilm LHRS3117AerFilm LHRS6739AerFilm LHRS011215AerFilm LHRS8257AerTrim LWS3927AerFilm LHRS012133AerFilm LHRS5466AerTrim LWS6192AerFilm LHRS4531AerFilm LHRS012258AerTrim LWS4748AerTrim LWS3580AerFilm LHRS5617AerFilm LHRS5210AerFilm LHRS011293AerTrim LWS08029-001-P2AerFilm LHRS1573AerFilm LHRS6000AerFilm LHRS08228-001-P2AerFilm LHRS011394AerFilm LHRS1271AerFilm LHRS1682AerFilm LHRS4495AerTrim LWS51273-002-P2AerFilm LHRS8843AerFilm LHRS3944AerFilm LHRS7019AerFilm LHRS7912AerFilm LHRS013989AerFilm LHRS013181AerFilm LHR
Back to Boeing 747-400D