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.

4892137-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4892137-1 · Jul 21, 1992 3888871-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888871-1 · Jul 21, 1992 3887685-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3887685-1 · Jul 21, 1992 4716791Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4716791 · Jul 21, 1992 3888862-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888862-1 · Jul 21, 1992 3896238-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3896238-1 · Jul 21, 1992 4889597-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4889597-1 · Jul 21, 1992 4764274Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4764274 · Jul 21, 1992 3753234-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3753234-1 · Jul 21, 1992 4717611Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4717611 · Jul 21, 1992 4772349-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4772349-1 · Jul 21, 1992 3889003-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3889003-501 · Jul 21, 1992 2765111Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 2765111 · Jul 21, 1992 2763625Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 2763625 · Jul 21, 1992 4778820-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4778820-1 · Jul 21, 1992 4715059Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4715059 · Jul 21, 1992 5757698-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 5757698-501 · Jul 21, 1992 4889579-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4889579-1 · Jul 21, 1992 4895801-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4895801-1 · Jul 21, 1992 5890365-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5890365-1 · Jul 21, 1992 3712765Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3712765 · Jul 21, 1992 3776207-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776207-1 · Jul 21, 1992 3889249-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3889249-1 · Jul 21, 1992 3716244Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3716244 · Jul 21, 1992 3718606Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3718606 · Jul 21, 1992 3701678Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3701678 · Jul 21, 1992 4641486Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4641486 · Jul 21, 1992 4754576-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4754576-1 · Jul 21, 1992 4768862-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4768862-1 · Jul 21, 1992 4765078Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4765078 · Jul 21, 1992 4888850-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4888850-1 · Jul 21, 1992 3889180-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3889180-1 · Jul 21, 1992 5804164-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5804164-501 · Jul 21, 1992 5804164-503Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5804164-503 · Jul 21, 1992 3776207-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776207-501 · Jul 21, 1992 3612188Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3612188 · Jul 21, 1992 4751198-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4751198-1 · Jul 21, 1992 3888400-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3888400-1 · Jul 21, 1992 3755606-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3755606-1 · Jul 21, 1992 3896468-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3896468-1 · Jul 21, 1992 3750995-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3750995-1 · Jul 21, 1992 3777644-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3777644-501 · Jul 21, 1992 3751801-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3751801-1 · Jul 21, 1992 3889591-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3889591-1 · Jul 21, 1992 4751597-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4751597-1 · Jul 21, 1992 3774881-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3774881-1 · Jul 21, 1992 3714756Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3714756 · Jul 21, 1992 3768679-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3768679-1 · Jul 21, 1992 4892473-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4892473-1 · Jul 21, 1992 3893520-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3893520-1 · Jul 21, 1992

Back to Mcdonnell Douglas DC-8-21