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.
BAC29PPS11360Marker72071107DS1000 Steam Oven RHBAC29PPS11386MarkerBAC29PPS11414MarkerBAC29PPS13159MarkerBAC29PPS11413MarkerBAC29PPS11383Marker609054Mounting Rail Assy72015421Coffee Maker DA54-2BBAC29PPS11381MarkerBAC29PPS11415MarkerBAC29PPS1319MarkerBAC29PPS13288MarkerBAC29PPS13287MarkerBAC29PPS11408Marker4333100-02-6600DX3000 Steam Oven LHBAC29PPS11374MarkerBAC29PPS11372MarkerBAC29PPS11366MarkerBAC29PPS11369MarkerBAC29PPS11380MarkerBAC29PPS1329Marker72184003Water Heater DR40-1BAC27WPPS131MarkerBAC27WPPS201MarkerBAC29PPS11367MarkerBAC29PPS10380MarkerBAC29PPS10354MarkerBAC29PPS10367MarkerBAC29PPS18671MarkerBAC29PPS10242MarkerBAC29PPS10356MarkerBAC29PPS0201MarkerBAC29PPS10379MarkerBAC29PPS18668MarkerBAC29PPS0192MarkerBAC29PPS10363MarkerBAC29PPS10248MarkerBAC29PPS10375MarkerBAC29PPS10355MarkerBAC29PPS10244MarkerBAC29PPS10381MarkerBAC29PPS10359MarkerBAC29PPS18660MarkerBAC29PPS10377MarkerBAC29PPS10357MarkerBAC29PPS10366MarkerBAC29PPS0369MarkerBAC29PPS10372MarkerBAC29PPS10368Marker
Back to Boeing 747-400D