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.
8301-916SAShroud, Upper Arm, R/H8102-401AAFood Tray Assembly, Std.8102-417Food Tray Assembly8102-411Food Tray Assembly8501-455DAPanel, Endbay Assembly, L/H4402-302Shroud, Upper Arm4404-311AAShroud, Upper ArmFW8301-917AAShroud, Arm, L/H8401-352AAPanel, Wall, R/H8301-915SAshroud, upper arm, l/h8102-403DAFood Tray Assembly, Std.8301-918AAShroud, Arm, R/H8501-456DAPanel, Endbay Assembly, R\H4501-922Panel, Lower Endbay R/H4403-301AAShroud, Upper ArmFW8301-919AAShroud, Arm4404-303AA2Shroud, Upper Arm4403-321AAShroud, Upper Arm8614-311Panel, Endbay Assembly10457N02F01Indicator, Fuel Flow/Fuel Used10457N02F01Indicator, Fuel Flow/Fuel UsedBOM 10457N02F01Indicator, Fuel Flow/Fuel UsedBOM 10457N02F01Indicator, Fuel Flow/Fuel Used302-0017-02Valve, Vent/Float, Toilet302-0017-03Valve, Vent/Float, Toilet302-0017-01Valve, Vent/Float, Toilet302-0003-02Valve, Vent/Float, Toilet302-0003-03Valve, Vent/Float, ToiletL-18440-000Dome Fixture10029High/Low Table Pedestal351589WEGear, Internal SpurAA708511BushingAA695802Liner, BearingAA695780Liner, BearingAA4288-07ALiner, BearingAA4287-24BLiner, BearingAA4288-14ALiner, BearingAA695805Liner, BearingAA4287-14ALiner, BearingAA4288-24BLiner, BearingAA695762Liner, BearingAA4287-07ALiner, Bearing3402VBWLMarker-"Oxygen etc."2002VWBMarker-"Annun etc."4772VRWMarker-"Emergency etc."4755VBWMarker-"Aileron etc."4417VWBLMarker-"C etc."2095VWBMarker-"115 etc"4790VRWMarker-"Caution etc."3959VRWMarker-"To open etc"
Back to Douglas DC-9-11