Skip to content

Mcdonnell Douglas DC-8-21

PMA parts · 4,744

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 ('4A25')
    AND len(list_intersect(tcds_models, ['DC-8-21'])) > 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 ('4A25')
  AND len(list_intersect(tcds_models, ['DC-8-21'])) > 0
ORDER BY supplement_date DESC, drs_guid DESC

Run 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.

4614429-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4614429-501 · Jul 21, 1992 3890467-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3890467-1 · Jul 21, 1992 3768859-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3768859-1 · Jul 21, 1992 3804125-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3804125-1 · Jul 21, 1992 4802653-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4802653-501 · Jul 21, 1992 3893393-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3893393-1 · Jul 21, 1992 3772513-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3772513-1 · Jul 21, 1992 3896237-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3896237-501 · Jul 21, 1992 3767973Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3767973 · Jul 21, 1992 3804127-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3804127-1 · Jul 21, 1992 3751789-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3751789-1 · Jul 21, 1992 4776852-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4776852-501 · Jul 21, 1992 4753341-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4753341-501 · Jul 21, 1992 4890494-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4890494-1 · Jul 21, 1992 3896435-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3896435-1 · Jul 21, 1992 4762997-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4762997-1 · Jul 21, 1992 4888468-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4888468-1 · Jul 21, 1992 3888496-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888496-1 · Jul 21, 1992 3892546-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3892546-1 · Jul 21, 1992 5633881-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5633881-1 · Jul 21, 1992 3887985-2Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3887985-2 · Jul 21, 1992 3887985-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3887985-1 · Jul 21, 1992 3762976Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3762976 · Jul 21, 1992 3758985-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3758985-1 · Jul 21, 1992 370689-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 370689-501 · Jul 21, 1992 4888156-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4888156-1 · Jul 21, 1992 5711750Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 5711750 · Jul 21, 1992 4888484-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4888484-1 · Jul 21, 1992 3762976-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3762976-501 · Jul 21, 1992 3887710-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3887710-1 · Jul 21, 1992 4412558-505Light MaskSpectra Lux Corp · Replaces McDonnell Douglas 4412558-505 · Jul 21, 1992 5777008-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5777008-1 · Jul 21, 1992 3757443-503Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3757443-503 · Jul 21, 1992 4801063-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4801063-1 · Jul 21, 1992 3612190Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3612190 · Jul 21, 1992 3804125-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3804125-501 · Jul 21, 1992 3714756-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3714756-501 · Jul 21, 1992 3889659-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3889659-1 · Jul 21, 1992 4754461-503Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4754461-503 · Jul 21, 1992 3804309-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3804309-1 · Jul 21, 1992 3754651-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3754651-1 · Jul 21, 1992 3768990-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3768990-1 · Jul 21, 1992 3778091-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3778091-501 · Jul 21, 1992 3895638-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3895638-1 · Jul 21, 1992 4614038-503Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4614038-503 · Jul 21, 1992 4888706-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4888706-1 · Jul 21, 1992 5804164-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5804164-1 · Jul 21, 1992 3753734-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3753734-1 · Jul 21, 1992 3758010-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3758010-1 · Jul 21, 1992 3764891-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3764891-1 · Jul 21, 1992

Back to Mcdonnell Douglas DC-8-21