Mcdonnell Douglas DC-9-13
PMA parts · 9,394
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-13'])) > 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-13'])) > 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.
30050Sidewall Game Table229-10Fixed Height Table Single Pedestal600918-101Gyro Siwtch Unit600921-100SW. Unit600905-101SW. Unit600917Compass Switch UnitCH34803Igniter Assembly53368-1Cable AssemblyA800100-1Disposable Fire ExtinguisherDEC31-087-501Ring, Bearing HousingDEC31-085-503Bearing, Sleeve, Fuel PumpDEC31-085-505Bearing, Sleeve, Fuel PumpDEC31-087-503Ring, Bearing HousingDEC31-094-501Housing, Dual Orifice AtomizerDEC31-095-501Bearing Set, Sleeve, MatchedDEC31-096-503Plate Set, Metering, MatchedDEC31-085-501Bearing, Sleeve, Fuel PumpDEC31-085-507Bearing, Sleeve, Fuel PumpDEC31-095-503Bearing Set, Sleeve, MatchedDEC31-093-501Spacer, Bearing - TurbineDEC31-077-501Carrier, FlyweightDEC61-039-501Rack and Roller LeverDEC31-058-501Shaft, TorsionDEC31-078-501Spacer, Nozzle, Turbine976J252-8Generator, AC, Aircraft4958738-1GBushing - Idler Link, Thrust Reverser30042-046-4Ashtray3958373-1GBearing, Sleeve - Lower, Shock Strut, MLG4933883-1G, -501G, 503GBushing - Rib Assembly4918114-1G, -501GFitting - Horiz Stab Side Roller2923189-1GBushing - Ram Scoop Link, APU2920545-1G, -501G, 503GBushing - Slat Track Roller51038 311Ashtray3929723-1GBushing - Deflector, NLG4914749-1GBushing - Flt Spoiler3954557-1G, 3, 5Link Assembly - Drive, Flight Spoiler Actuating MechanismDEC31-056-513Bushing, BearingDEC31-057-503Bushing, BearingDEC31-057-509Bushing, BearingDEC31-056-509Bushing, BearingDEC31-057-505Bushing, BearingDEC31-056-511Bushing, BearingDEC31-057-507Bushing, BearingDEC31-056-515Bushing, BearingDEC31-056-503Bushing, BearingDEC31-057-501Bushing, BearingDEC31-056-505Bushing, BearingDEC31-056-501Bushing, BearingDEC31-056-507Bushing, BearingAD-4002PBattery
Back to Mcdonnell Douglas DC-9-13