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.
50090Actuator, 30 Rotation, 115 VAC2137Valve-Rain repellant Supply, Solenoid Operated50080Motor Operated Shutoff Valve2144Valve - Solenoid, Rain Repellent1009100-7Radome - Nose McDonnell Douglas DC-9/ MD-80 Weather MASTER X-Band Radome8649VBWLMarker- Fasten etc.2516MSBMarker- Aerol etc.8634PGWMarker- Load etc.8412VBWMarker- Maximum etc.8619MBSMarker- Service etc.2514MSBMarker- Aerol etc.8636PWGMarker- Life etc.8642VBWMarker- For etc.8648MSBMarker- Assembly etc.6947VRWMarker- Warning etc.8509PWGMarker- Fasten etc.8443PCCMarker- Lens8508PWGMarker- Life etc.8641MSPMarker- Boeing etc.8505MBSMarker- Stabilizer etc.8623MBSMarker- Actuator etc.8643PGGMarker- Seat Row8645MSMMarker Main etc.8503MSBMarker Service etc.8650PRWMarker- Aed etc.8624PGWMarker- Load etc.8506VBJMarker- Life etc.8612MSBMarker- Gen etc.8639MBSMarker- Caution etc.0479ADMarker- Federal etc.8608MSBMarker- Valve etc.8637PWGMarker- Life etc.8622MSBMarker- AC etc.8644MSMMarker Main etc.8653VWRMarker- Turn etc.8605VMWMarker- Flag8647MSMMarker Main etc.8499MSBMarker- PN etc.2517MSBMarker- Aerol etc.8646MSMMarker Main etc.8635PGWMarker- Load etc.8633PGWMarker- Load etc.8504PRWMarker- Crash etc.8640VRWMarker- Warning etc.2515MSBMarker- Aerol etc.8500MSAMarker- Valve etc.8497MSPMarker- Assembly etc.8652PWGMarker- Life etc.8621MSBMarker- Service etc.0FV9600A01G01GAshtray assembly
Back to Douglas DC-9-11