Douglas DC-9-11
PMA parts · 9,789
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 ('A6WE')
AND len(list_intersect(tcds_models, ['DC-9-11'])) > 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 ('A6WE')
AND len(list_intersect(tcds_models, ['DC-9-11'])) > 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.
0FV9500A01G01GAshtray assembly0FV9700A01G01GAshtray assembly8489PBWMarker- Load etc.8414VWBMarker- Arrow8485PRWMarker- This etc.8476PRWMarker- Symbol8426PBWMarker- Max etc.8451PBWMarker- Maximum etc.8490PBWMarker- Load etc.8429VGWMarker- Maximum etc.8478PRWMarker- Symbol2602673-001Core Replacement Kit8438PRWMarker- Symbol8460CEBMarker- Windshear8496PRWMarker- Do etc.8474PRWMarker- Symbol8423PRWMarker- Hand etc.8278VYYMarker- Cargo etc.8427PGWMarker- Por etc.8450VWWMarker- Symbol8455PBWMarker- Ensure etc.8473PRWMarker- Symbol8440PXWMarker- Symbol8413VBWMarker- Maximum etc.8493MBSMarker- Warning etc.8454PBWMarker- Berthing etc.8466VBWMarker- Life etc.8445VBCMarker- Fasten etc.8477PRWMarker- Symbol8446PRWMarker- 8 etc.8433PGWMarker- Arrow8483PRWMarker- Escape etc8430MSBMarker- Fire etc.8422PRWMarker- No etc.8279CEBMarker- Fwd etc.8280CEBMarker- Aft etc.8491PBWMarker- Load etc.8465VYYMarker- Igniter etc.8462CEBMarker- Aft etc.8281MSBMarker- Vhf etc.8452PBWMarker- Maximum etc.4389VBCLMarker- Fuel etc.8277VYYMarker- Cargo etc.8449PRWMarker- Towel etc.8425PGWMarker- Spare etc.8456VRWMarker- One etc.8421PGWMarker- Linterna etc.8461CEBMarker- Fwd etc.8472PRWMarker- Symbol5782KITMarker- 737/DC9 Int. Kit
Back to Douglas DC-9-11