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.
A0774VYYMarker- Masking etc.A0848VWBMarker- Mode etc.9874VYYMarker- Eng etc.VL1336WE1GasketA-3916571-5JD72Handle -Passenger DoorA-3916571-1JF85Handle Passenger DoorA 3916571 1JD72Handle -Passenger DoorA-3916571-5JF85Handle -Passenger Door5756000-501SENSOR assembly - WARNING8532643Packing-Preformed2M100-3SValve2M100Valve2M100-2Valve2M100-3Valve4299VBWMarker- Mirror etc.0611MBSMarker- OpenA0750KITMarker- KitA0798PRWMarker- All etc.0610MBSMarker- Water etc.0608MBSMarker- Overflow etc.0300VMWMarker- Close etc.5-1632-700Controlled Gap Seal28-1578-700Mating RingA0815CCBMarker- G etc.CM2011632-1Ball Bearing1-1875-705O Ring Face Seal5-1631-713Controlled Gap Seal1-1875-706O Ring Face Seal1-530-708Controlled Gap SealH6370WasherH57524Valve CoreH59776Seal BossH13362Gasket Dem&ValveP245845WasherH10003578WasherH55620-01PackingH55620-02PackingP842117Fill Fitting AssemblyP802503Check AssemblyH6555GasketH5032GasketH3RC100HT3CylinderHA805506-4Pressure GaugeP245824Rupture Disc5951093-501SDSEALP805505SeatH5032GasketA0582PRWMarker- Use etc.A0762VRWMarker- Warning etc.4244PRWLMarker- Fire etc.
Back to Douglas DC-9-11