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.

3892534-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3892534-1 · Jul 21, 1992 3750403-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3750403-1 · Jul 21, 1992 2716835Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 2716835 · Jul 21, 1992 3888080-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888080-1 · Jul 21, 1992 4893426-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4893426-1 · Jul 21, 1992 4704436Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4704436 · Jul 21, 1992 3757989-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3757989-1 · Jul 21, 1992 3804148-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3804148-1 · Jul 21, 1992 4645098Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4645098 · Jul 21, 1992 3776333-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776333-1 · Jul 21, 1992 2715944Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 2715944 · Jul 21, 1992 5887477-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 5887477-1 · Jul 21, 1992 4753580-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4753580-501 · Jul 21, 1992 4777822-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4777822-501 · Jul 21, 1992 5890365-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5890365-501 · Jul 21, 1992 4753665-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4753665-1 · Jul 21, 1992 3753439-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3753439-1 · Jul 21, 1992 3775068-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3775068-1 · Jul 21, 1992 3892135-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3892135-1 · Jul 21, 1992 3892591-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3892591-1 · Jul 21, 1992 3889395-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3889395-1 · Jul 21, 1992 3888383-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888383-1 · Jul 21, 1992 4756182-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4756182-501 · Jul 21, 1992 3776208-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776208-1 · Jul 21, 1992 4751596-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4751596-1 · Jul 21, 1992 3776914-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776914-1 · Jul 21, 1992 3891961-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 3891961-1 · Jul 21, 1992 3612187-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3612187-501 · Jul 21, 1992 3613834-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3613834-1 · Jul 21, 1992 3888192-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3888192-1 · Jul 21, 1992 3767635Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3767635 · Jul 21, 1992 5890770-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5890770-1 · Jul 21, 1992 4760805-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4760805-501 · Jul 21, 1992 3716365Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3716365 · Jul 21, 1992 4751632-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4751632-1 · Jul 21, 1992 3757410-503Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3757410-503 · Jul 21, 1992 4715703Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4715703 · Jul 21, 1992 3776074-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776074-501 · Jul 21, 1992 3896421-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3896421-1 · Jul 21, 1992 4768437Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4768437 · Jul 21, 1992 4773287-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4773287-501 · Jul 21, 1992 4890854-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4890854-1 · Jul 21, 1992 4614038-501Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4614038-501 · Jul 21, 1992 4756185-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 4756185-1 · Jul 21, 1992 5804164-509Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 5804164-509 · Jul 21, 1992 3889683-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3889683-1 · Jul 21, 1992 3890351-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3890351-1 · Jul 21, 1992 3892584-501Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3892584-501 · Jul 21, 1992 3776210-1Light PlatesSpectra Lux Corp · Replaces McDonnell Douglas 3776210-1 · Jul 21, 1992 4890026-1Light PanelSpectra Lux Corp · Replaces McDonnell Douglas 4890026-1 · Jul 21, 1992

Back to Mcdonnell Douglas DC-8-21