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.
BAC27WEL1259MarkerBAC27WEL1266MarkerBAC27WEL1261MarkerBAC27WEL1256MarkerBAC27WEL1267MarkerBAC27WEL1258MarkerBAC27WEL1257MarkerBAC27WEL1262MarkerBAC27WEL1269MarkerBAC27WEL1260MarkerBAC27WEL1264MarkerBAC27WEL1272MarkerBAC27WEL1300MarkerBAC27WEL1321MarkerBAC27WEL1277MarkerBAC27WEL1322MarkerBAC27WEL1301MarkerBAC27WEL1304MarkerBAC27WEL1275MarkerBAC27WEL1303MarkerBAC27WEL1302MarkerBAC27WEC145MarkerBAC27WEL1274MarkerBAC27WEL1273MarkerBAC27WEL1278Marker2235300-35Enhanced Airborne Data Loader (eADL)2235300-32Enhanced Airborne Data Loader (eADL)2235300-31Enhanced Airborne Data Loader (eADL)BAC1522-648Tube ExtrusionBAC1522-954Miscellaneous, Plastic, ExtrudedBAC1522-951Miscellaneous, Plastic, ExtrudedBAC1521-567Seal ExtrusionBAC1522-216Plastic ExtrudedBAC1522-1063Plastic ExtrudedBAC1522-452Miscellaneous, Plastic, ExtrudedBAC1522-1014Plastic Extruded10-60754-159Seal10-60754-817SealBAC1522-18Plastic Extruded10-60754-729SealBAC1522-1006Plastic ExtrudedBAC1522-709Miscellaneous, Plastic, ExtrudedBAC1521-922Seal ExtrusionBAC1522-945Miscellaneous, Plastic, ExtrudedBAC1522-732TrimBAC1522-1082Plastic ExtrudedBAC1522-411Miscellaneous, Plastic, ExtrudedBAC1522-80Cabin Molding ExtrusionBAC1522-896Miscellaneous, Plastic, Extruded10-60754-353Seal
Back to Boeing 747-400D