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.
S010432AerTrim LWS011646AerTrim LWS6701AerFilm LHRS012512AerFilm LHRS5484AerFilm LHRS8373AerFilm LHRS50064-001-P2AerFilm LHRS04066-002-P2AerFilm LHRS7415AerFilm LHRS03935-010-P2AerTrim LWS012576AerFilm LHRS4901AerFilm LHRS04900-012-P2AerFilm LHRS5488AerFilm LHRS012159AerFilm LHRS010132AerFilm LHRS1659AerFilm LHRS13270-002-P2AerFilm LHR8158AerFilm LHRS7055AerFilm LHRS010471AerFilm LHRS06081-002-P2AerFilm LHRS3516AerFilm LHR8158AerFilm LHRS05003-007-P2AerFilm LHRS6734AerFilm LHRS011214AerFilm LHRS015592AerFilm LHRS009535AerTrim LWS7777AerFilm LHRS04092-001-P2AerFilm LHRS1685AerFilm LHRS8156AerFilm LHRS011683AerFilm LHRS3118AerFilm LHRS010098AerTrim LWS012044AerTrim LWS04032-001-P2AerFilm LHRS013153AerFilm LHRS2010AerFilm LHRS2978AerFilm LHRS04083-012-P2AerFilm LHRS012158AerFilm LHRS08015-001-P2AerFilm LHRS08288-001-P2AerFilm LHRS016318AerTrim LWS07250-001-P2AerFilm LHRS08931-001-P2AerFilm LHRS1281AerTrim LWS1802AerFilm LHR
Back to Boeing 747-400D