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.

4751345-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4751345-1 · Jul 21, 1992 3895756-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3895756-1 · Jul 21, 1992 4761054-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4761054-1 · Jul 21, 1992 3753423-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3753423-501 · Jul 21, 1992 3891505-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3891505-1 · Jul 21, 1992 4756184-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4756184-1 · Jul 21, 1992 4897287-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4897287-1 · Jul 21, 1992 4897184-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4897184-1 · Jul 21, 1992 3889007-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3889007-1 · Jul 21, 1992 3893707-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3893707-1 · Jul 21, 1992 3753579-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3753579-1 · Jul 21, 1992 2710645-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 2710645-501 · Jul 21, 1992 3761711-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3761711-501 · Jul 21, 1992 3761482Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3761482 · Jul 21, 1992 3804128-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3804128-1 · Jul 21, 1992 3889182-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3889182-1 · Jul 21, 1992 3896237-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3896237-1 · Jul 21, 1992 4646577Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4646577 · Jul 21, 1992 4888753-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4888753-1 · Jul 21, 1992 4757440-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4757440-1 · Jul 21, 1992 2704413Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 2704413 · Jul 21, 1992 3767749Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3767749 · Jul 21, 1992 4614428-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4614428-501 · Jul 21, 1992 3712567Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3712567 · Jul 21, 1992 5707635Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 5707635 · Jul 21, 1992 3712765-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3712765-501 · Jul 21, 1992 4887295-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4887295-1 · Jul 21, 1992 3778170-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3778170-1 · Jul 21, 1992 4768890-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4768890-1 · Jul 21, 1992 4765081-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4765081-501 · Jul 21, 1992 3757443-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3757443-1 · Jul 21, 1992 3757443-505Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3757443-505 · Jul 21, 1992 3776209-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776209-1 · Jul 21, 1992 5887973-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5887973-1 · Jul 21, 1992 4715205Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4715205 · Jul 21, 1992 3895642-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3895642-1 · Jul 21, 1992 3778080-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3778080-1 · Jul 21, 1992 3717238Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3717238 · Jul 21, 1992 3717061Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3717061 · Jul 21, 1992 3888013-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3888013-1 · Jul 21, 1992 3717059Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3717059 · Jul 21, 1992 4761054-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4761054-501 · Jul 21, 1992 3777983-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3777983-1 · Jul 21, 1992 3893546-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3893546-1 · Jul 21, 1992 4777981-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4777981-501 · Jul 21, 1992 4888389-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4888389-501 · Jul 21, 1992 3888506-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888506-1 · Jul 21, 1992 3888193-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888193-1 · Jul 21, 1992 4800280-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4800280-1 · Jul 21, 1992 3777643-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3777643-501 · Jul 21, 1992

Back to Mcdonnell Douglas DC-8-21