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.
3605542-1DGSpider, Clutch Driven3605377-1DGSpacer, DiaphragmAR-29Commutator6901VYYStencil-Apu etc6855VBCMarker-Seat etc6870VRWMarker-Biohazard etc6915VYYStencil-Push6856VBCMarker-Seat etc6875VBYMarker-Maximum etc6907VYYStencil-Blankets etc6849VBCMarker-Load etc6890VBWMarker-Telephone etc6911VYYStencil-Jackpoint6905VYYStencil-Lav etc6862VWCMarker-Meal etc6884VBCMarker-Crash etc6854VWCMarker-Seat etc6848PWBMarker-32 etc6878VBCMarker-No 2 etc6910VYYStencil-Warning etc6913VYYStencil-Arrow6918VYYStencil-Locked6851VBCMarker-Life etc6937VBMMarker-Special etc6900VYYStencil-Emergency etc6873VBYMarker-Latch etc6902VYYStencil-Tail etc6872VBYMarker-Remove etc6929VYYStencil-Push etc6903VYYStencil-Arrow6883VWCMarker-Crash etc6917VYYStencil-Pull6921VYYStencil-Inside etc6920VYYStencil-Conditioned etc6859VBCMarker-Close etc6871VBYMarker-Maximum etc6771XXXMarker-Life etc6906VYYStencil-Apu etc6879VBCMarker-28 VDC etc6769VRCMarker-Thrust etc6925VYYStencil-Caution etc6882VWCMarker-Life etc6886VBCMarker-Head etc6892VWRMarker-Before etc6850VWCMarker-Life etc6912VYYStencil-Fuel etc6922VYYStencil-Open etc6908VYYStencil-Do etc6867PXWMarker-Oxygen etc6914VYYStencil-Apu etc
Back to Douglas DC-9-11