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.
63040-603-950GAshtray4916919-1G/ -501G/ -503GPin - Aft Galley Ceiling2925763-1GWasher - Flat, Brake Stud, M.L.G.51296-311Ashtray - RH2575-0125-01GInsert2925763-501GWasher - Flat, Brake Stud, M.L.G.83481-001GAshtray20023-560Arm Assembly - Stop20140-560Ashtray5937044-1G, -501G, -503G, -505GSleeve - Wheel Bearing, MLG62-0208-1GSpacer - Flanged, Coffee Maker51380-311Ashtray Assembly51424-311Ashtray1A113-0139-1G, -101G, -103GAshtray & Receptacle Assembly2520-0019-01GVent - Oven Door51417-311-2Ashtray51423-311Ashtray94844-01GAshtray20131-560Recess - Food Cart51425-311Stud - Latch84629-1GAshtray20077-560Ashtray30091-046, -1, -2, -3, -4, -5, -6, -7, -8, -9, -10Spacer - Bolt30105-046, -1Washer - Leg Stud51335-311Ashtray51417-311Ashtray51335-311Ashtray51292-311Ashtray Assembly30085-046, -1, -2, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13, -14, -15, -16, -17, -18Washer30086-046Washer20203-560Ashtray45067-510-3Ashtray30028-046, -1, -2, -3, -4, -5, -6, -7, -8, -9,-10, -11, -12, -13, -14, -15, -16BushingA38405-21GAshtray78844R1G, 78844R2GLatch Assembly19205-023TGAshtray3923092-1G, -501G, -503G, -505G, -507G, -509G, -511G, -513G, -515GBushing, Sleeve Landing Gear2575-0030-01GVent Cover30028-046, -1, -2, -3, -4, -5, -6, -7, -8, -9, -10, -11, -12, -13, -14, -15, -16, -17Bushing413-105-705GAshtray094844-013GAshtray822619-405GAshtray43-3051-1Skin-Shroud Upper43-3053-1Skin-Shroud Upper, SSGE16731-2SMILamp Assembly8292VGWMarker- Maximum etc.8178PGWMarker- Sanitary etc.8201VWRMarker- Catwalk etc.8289PGWMarker- Solo etc.8287PGWMarker- Use etc.
Back to Douglas DC-9-11