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.
P245845Washer109500Printer ACARSV1400J016A00Lav Service NippleTA4075L0814BracketV1400J012A00Water Service NippleV9092J016A00Lav Service NippleV4259J064S20Drain PlugV0016BM12A02Water Service NippleV2651D516C00Waste Drain ValveV9092J012A00Service NippleV0016BM16A02Water Service NippleTA4063D0608BracketV8941J016C00Nipple AssemblyV2651J126A00Drain NippleV9541AR12A00Water Service NippleV2651J154A00Drain NippleTA4076G3412BracketV2651D516COAWaste Drain Valve3880VWBLMarker-"31 etc."4766MBSLMarker-"Coffee etc."1283CEBMarker-"Windshield etc."4744MSBLMarker-"Modified etc."1527VBWMarker-"PBE etc."4990VWBMarker-"Toilet etc."4809MSBLMarker-"Modified etc."4970VWRMarker-"Warning etc."5281PRWLMarker-"Lifeline"1497CEBMarker-"Ground etc."4838CEBMarker-"R aoa etc."1403VBWMarker-"Battery etc."1528VBWMarker-"Cigarette etc."4255VBWMarker- Dc-9 etc.4085VBWLMarker-"Life etc."5661PRWLMarker-"First etc."1475VRWMarker-"Emergency etc."4420MSBLMarker-"This etc."1282CABMarker-"Speed etc."4270MBSLMarker-"Coffee etc."0228ADMarker-"Exxon etc."4947MSBMarker-"Fluid etc."1558VRCMarker-"Exit"4765MBSLMarker-"Coffee etc."5387PWRLMarker- Fire etc.1526PRWMarker-"Oxygen etc."4793VRWMarker-"American etc."1534PRWMarker-"Doors etc."1533VBWMarker-"Book etc."4576VMWMarker-"Tire etc."5746KITMarker-"Galley Kit"5745KITMarker-"Galley Kit"
Back to Douglas DC-9-11