Mcdonnell-Douglas DC-10-30
Service difficulty reports · 2,776
Newest first. General aviation reporting is voluntary.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DC1030' ORDER BY difficulty_date 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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE aircraft_model_key = 'DC1030' ORDER BY difficulty_date DESC
Run 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.
SDR CNMA20090080Floorbeam · corrodedAT STA 1701, LBL 10 CORROSION ON FLOORBEAM. CORRODED FLOORBEAM REMOVED NEW FLOORBEAM INSTALLED IAW SRM VOL II 51-31-01.SDR CNMA20090079Bracket · crackedBS 1341, RBL N60 CTR WING LWR BARREL STRUCTURE CRACKED BRACKET. CRACKED ANGLE REMOVED, NEW ANGLE INSTALLED IAW SRM VOL II 51-31-01.SDR CNMA20090078Bracket · crackedBS 1341, LBL N60 CTR WING LWR BARREL STRUCTURE CRACKED BRACKET. DAMAGED BRACKET REMOVED. NEW BRACKET INSTALLED IAW SRM 51-31-01 ( VOL II).SDR CNMA20090077Angle · crackedBS 1321, LBL 65 CRACKED ANGLE UNDER WING TO BODY FAIRING. CRACKED ANGLE REMOVED. NEW ANGLE INSTALLED IAW SRM VOL II 51-31-01.SDR CNMA20090076Support · brokenBS 1781, RBL 60 ANGLE SUPPORT IS BROKEN AT CRT CARGO DOOR CUT OUT (AUS TANK AREA). BROKEN ANGLE REMOVED. NEW ANGLE INSTALLED (PN OAI-53-0007) USING MS7885/6-4-08 (B/N 40970-04). FASTENERS INSTALLED IAW SRM VOL II 51-31-01 FIG 2.SDR CNMA20090075Post · bentBS 1921, LBL 12 AND LBL 28 POSTS OF AFT WALL ARE BENT. DAMAGED POSTS REMOVED. NEW POSTS PN OAI-53-0010 AND OAI-53-0009 INSTALLED USING MS20470D6-5 RIVETS (B/N 311872-02) HL18PB6-5 (B/N 26206-04) AND HL70-6 COLLARS (B/N 53406-01) IAW SRM 51-31-01 (VOL II).SDR CNMA20090074Angle · brokenBS 1781 LBL 60 ANGLE IS BROKEN C/TO AFT WALL SUPPORTS. BROKEN ANGLE REMOVED. NEW ANGLE INSTALLED IAW SRM VOL II 51-31-01 FIG 2.SDR CNMA20090073Support · crackedBS 1781, LBL 64, THERE IS A CRACK ON AFT WALL SUPPORT. CRACKED PART REMOVED AND NEW PART OAI-53-0005 INSTALLED WITH FASTENERS IAW SRM VOL 2 51-31-01, BACR15CE5D-5 B/N 3847703.SDR CNMA20090072Floorbeam · corrodedBS 1781, LBL 0-LBL 20, CORROSION ON CARGO FLOORBEAM. CORRODED FLOORBEAM REMOVED. NEW FLOORBEAM INSTALLED IAW SRM VOL II 51-31-01 FIG 2.SDR CNMA20090071Post · bentBS 1921, RBL 12-28 POSTS OF AFT WALL ARE BENT. ONE POST WAS STRAIGHTENED AND FOUND FREE OF CRACKS AS STATED ON THE BACK OF THIS CARD. SECOND DAMAGED POST REMOVED NEW POST P/N OAI-53-0014 INSTALLED USING MS20470D6-5 (B/N 26206-04), HL18PB6-5 (B/N 31172-02) IAWSDR CNMA20090070Floor Support · brokenBS 879, RBL 60 ON FLOOR SUPPORT BROKEN. DAMAGED FLOOR SUPPORT REMOVED. NEW FABRICATED PN OAI-53-0004 IAW SAMPLE AN IAW SRM VOL 3 53-11-01, FIG 8 USING FASTENERS IAW SRM VOL 2 51-31-01 PN HL18PB-6-4 B/N 89623-01.879SDR CNMA20090069Floor Support · brokenBS 840 RBL 60 ON FLOOR SUPPORT BROKEN. DAMAGED FLOOR SUPPORT REMOVED. NEW FABRICATED PN OAI-53-0003 IAW SAMPLE AND IAW SRM VOL 3 53-13-01 FIG 8. USING WITH FASTENERS IAW SRM VOL 2 51-31-01 PN HL8PB6-4 B/N 89623-01.SDR CNMA20090068Angle · crackedBS 1902 RBL 10 AND LBL 44 CRACK ON ANGLES. DAMAGED ANGLE REMOVED. NEW FABRICATED PN OAI-53-0004 IAW SAMPLE AND IAW SRM VOL 3 53-13-01 FIG 8 USING WITH FASTENERS IAW SRM VOL 2 51-31-01. PN HL18PB6-4 B/N 89623-01.SDR CNMA20090067Intercostal · brokenBS 1783 BROKEN INTERCOSTALS. BROKEN PARTS REMOVED. NEW INTERCOSTALS AND ANGLE, & STRAP INSTALLED WITH FASTENERS IAW SRM VOL II FIG 2 51-3101.SDR CNMA20090066Floorbeam · corrodedBS 1039, RBL 45 CORROSION ON FLOORBEAM. CORRODED FLOORBEAM REMOVED. NEW FLOORBEAM INSTALLED IAW SRM VOL II 51-31-01.SDR CNMA20090065Frame · damagedBS 1039, LBL 49 DOUBLE HOLES ON FRAME. FLANGE WITH DOUBLE HOLES TRIMMED. REINFORCEMENT PART INSTALLED AS RQUIRED IAW SRM VOL I, 53-00-01, FIG 7.SDR CNMA20090064Stud · damagedBS 939, LBL 15 BROKEN ELEC SUPPORT STUD. DAMAGED AREA TRIMMED A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-00-01, FIG 8.SDR CNMA20090063Support · brokenBS 939, STR 47L BROKEN SUPPORT. TRIMMED FLANGE AT DAMAGE AREA. A REINFORCEMENT ANGLE, INSTALLED IAW SRM 53-00-01, FIG 8 (VOL I) INSTALLED FASTENERS IAW 51-31-01 VOL II.SDR CNMA20090062Support · corrodedBS 1581 STR 41L-42L CORROSION ON AFT LT FAIRING SUPPORT. CLEAN UP CORROSION AT NOTED AREA IAW SRM 51-21-01 AND AREA REINFORCED IAW SRM VOL I 53-00-01, FIG 7, IAW SRM 51-31-01.SDR CNMA20090061Structure · crackedCRACK FOUND STA 1721 ON LWR CHORD B/T STA 1721-1741 RBL - 0 B/T STR 51 TO 52 RT. TRIM OUT CRACK AND AREA REINFORCEMENT IAW SRM VOL 2 51-31-01.SDR CNMA20090060Floorbeam · damagedSTA 1741 LBL 50 DOUBLE HOLES ON FLOORBEAM. DAMAGED SUPPORT REMOVED NEW FLOORBEAM INSTALLED IAW SRM VOL II 51-31-01 IG 2.SDR CNMA20090059Floorbeam · crackedSTA 1781 LBL-8 LT UPPER FLOORBEAM TEE-CRACK ON FLOORBEAM AT UPPER TEE. REMOVED NEW SUPPORT INSTALLED IAW SRM VOL II 51-31-01.SDR CNMA20090058Floorbeam · crackedCRACK AND TORN ANGLE FLOORBEAM ON FWD FRAME STA 1521, RBL 15. REMOVED DAMAGED PART AND NEW PART OAI 53-0003 INSTALLED DUE TO FABRICATION PART IAW SRM 53-11-01, FIG 9, OMNI GMM 4.45, USING FASTENERS HL19PB6-4, B/N 56100-01, HL70-6 B/N 534106-01 AND BACR15CE6D-SDR CNMA20090057Structure · crackedCTR CARGO COMP BS 1681-1701 LT CHAIN HAT IS CRACKED. REPLACED BY NEW HAT MM 25-52-08.SDR CNMA20090056Structure · crackedCTR CARGO COMP BS 1721 - 1741 LT CHAIN HAT IS CRACKED. CTR CARGO COMP STA 1721 TO 1741 APPROX IN DOORWAY DAMAGED CHAIN HAT REPLACED IAW MM 25-57-00.SDR CNMA20080010Engine · malfunctionedNR 2 ENGINE OIL STRAINER CLOG LIGHT ILLUMINATED AT TOP OF CLIMB (29,000) INTERMITTENTLY. LIGHT BECAME SOLID AFTER 3 MINUTES. ENGINE SHUTDOWN IN FLIGHT IAW QRH PROCEDURE 4-1-2-19 AND CORRESPONDING CHECKLISTS. COMPLETED WORTAN 08-0368 R&R NR 2 ENGINE OIL STRASDR WRLA2008090Cable · misriggedDURING MAINTENANCE L4 DOOR FAILED TO OPEN WITH DOOR ARMED, EMERGENCY MODE. REMOVED LININGS, RIGGED AIR RELEASE CABLE AND ARMING ROD IAW DC10 MM 52-12-00. OPS CHECK GOOD. SERVICED DOOR OPENING RESERVOIR IAW DC10 MM 52-12-00. REPLACED L4 DOOR AND SURROUND LISDR 22AA20080906Inu · malfunctionedINERTIAL NAVIGATION SYSTEM (INS) NR 1 PRE-LAND TEST (PLT) FM FLOW OFF, LIGHT ON. ENTERED ON DMI 22099 IN ACCORDANCE WITH MEL 34-22, CATEGORY C. PLACARDS INSTALLED AS REQUIRED.
SDR WRLA2008076Insulation · out of positionFLT T8000/RMS/25 DURING FLIGHT BURN ODOR WAS NOTED IN COCKPIT AND CABIN. FLIGHT ATTENDANT OBSERVED LIGHT SMOKE AND BURN ODOR EMANATING FROM FORWARD AND MID GALLEY VENTS. C/A REMOVED INSULATION MATERIAL DEBRIS FROM THE INSIDE OF THE LAV VENT DUCT ASSY. LAV/GSDR CNM2008F00002Compressor · stalledDURING CRUISE AT FL 300 NR 3 ENG COMPRESSOR STALLED N1 DROPPED TO APPROXIMATELY 70 PERCENT VIBRATION FELT IN NR 3 THROTTLE/ FUEL LEVEL/ FIRE HANDLE AS WELL AS AIRFRAME. (K)SDR ARWA20080905Rheostat · failedCAPTAINS CHART HOLDER LIGHT IS CAUSING C/B E-8 TO POP. ELECT SMOKE ODOR AROUND CAPTAINS CHART HOLDER. FOUND CAPTAINS CHART HOLDER RHEOSTAT BAD. TRANSFERRED TO DMI NR 22073 AS PER MEL 33-1-0. CAT C. REPAIRED WIRE AT CAPTAINS CHART HOLDER IN ACCORDANCE WITH SDR WRLA2008106Fairing · puncturedFLIGHT 8010 09/06/08 KBWI/ETAR - DURING FLIGHT A THUMP WAS HEARD AND FELT 5 HOURS INTO FLIGHT AT FL310, NO ABNORMAL INDICATIONS OR HANDLING FOLLOWED. DURING POST FLIGHT INSPECTION, MAINTENANCE FOUND LT WING LDG EDGE WING/BODY FAIRING PUNCTURED AND CRACKED. RSDR CNM2008F00001Engine · overheatedDURING CLIMB THRU 15000 FT N2 103.4 TAT +20 NACELLE TEMP WAS 240 DEGREE C PREV SUPPLY SELECTED OFF AXCELL TEMP DECREASED 10 DEGREES C STILL 40 DEGREE C ABOVE QRH CHARTED VALVE (NR 1 ENG). (K)SDR WRLA2008088Skin · corrodedDURING C1 INSPECTION FOUND FASTENER HOLE CORRODED AT STA 2160 BETWEEN LONGERON 13R - 14R. REAMED HOLE TO REMOVE DAMAGE, EDDY CURRENT INSPECTION ACCOMPLISHED. MFG AND INSTALLED BUSHINGS AND REPAIR DOUBLER, TREAT, PRIME, SEAL AND PAINT IAW ENGINEERING REPAIR. SDR WRLA2008089Skin · corrodedDURING C1 INSPECTION FOUND FASTENER HOLE CORRODED AT STA 2160 BETWEEN LONGERON 13L-14L. REAMED HOLE TO REMOVE DAMAGE, EDDY CURRENT INSPECTION ACCOMPLISHED, MFG AND INSTALLED BUSHINGS AND REPAIR DOUBLER, TREAT, PRIME, SEAL AND PAINT IAW ENGINEERING REPAIR. (KSDR WRL2008F00010Skin · corrodedDURING C1 INSPECTION FOUND FASTENER HOLE CORRODED AT STA 2160 BETWEEN LONGERON 13L - 14L. REAMED HOLE TO REMOVE DAMAGE, EDDY CURRENT INSPECTION ACCOMPLISHED, MFG AND INSTALLED BUSHINGS AND REPAIR DOUBLER, TREAT, PRIME, SEAL AND PAINT IAW ENGINEERING REPAIR. SDR ARW2008F00001Windshield · crackedCAPTAIN`S WINDSHIELD ARCED; IT APPEARS TO HAVE AN APPROXIMATELY 6 INCH CRACK ON OUTER PANEL. PERFORMED ATT PROCEDURE "WINDSHIELD OR CLEARVIEW WINDOW CRACKED OR ARCING; FLIGHT RETURNED TO DEPARTURE IAW COMPANY`S REQUEST. REMOVED CAPTAIN`S WINDSHIELD IAW AMM 56SDR CNMA20080007Wire · burnedON PREFLIGHT FOUND FWD SECTION EMERGENCY LIGHTS INOP. CORRECTIVE ACTION: EXTENSIVELY TROUBLESHOT SYSTEM R&R FAULTY BATTERY POWER SUPPLY AND BATTERY PACK. PERFORMED CONTINUITY POWER GROUNDED CHECKS OF ALL FUNCTIONS AND SWITCHES. REPLACED CHARRED WIRE BETWEENSDR CNMA20090055Seat Track · corrodedLIGHT CORROSION ON SEAT TRACK (N6) LT UNDER THRESHOLD PAX DOOR 4 LT REMOVE THRESHOLD PLATE AND DRAIN VALVES ON DOOR NR 4 LT OK DONE AS AMM 53-10-01, REV 81. REMOVE CORROSION IAW SRM 51-21-01, VOL II, REV 93 PERFORMED AS REQUIRED MAX DEPTH 2.5 MM OUT OF SRM LISDR CNMA20090054Skin · dentedDENT ON FUSELAGE SKIN STA 729 - LONGERON 43. PERFORM REPAIR IAW SRM 53-20-00 FIG SH3, REV 45, VOL I, OK PERFORM REPAIR AS REQUIRED.SDR CNMA20090053Floorbeam · corrodedCORROSION ON FLOOR SUPPORT AT STA 815 X19. FABRICATED AND INSTALLED NEW PN ADA7326-1 IAW DWG ADA7326 AND 7548 AND SRM 51-35-01, STEP 1, VOL II, REV 94.SDR CNMA20090052Floorbeam · corrodedLIGHT CORROSION ON FLOORBEAM AT STA 859 X-72. REMOVED CORROSION IAW SRM 51-21-01, ERV 94, VOL II OUT OF LIMITS. REPLACED PN ADD 7160-2 IAW SRM 51-35-01, VOL II, REV 94, STEP 1 (REF DWG ADD 7163).SDR CNMA20090051Floorbeam · corrodedCORROSION ON FLOOR SUPPORT TEE AT AFTER PRESSURE BULKHEAD, STA 2007. X-40 - X-60, AND X 20. PERFORMED REPAIR IAW SRM 53-40-00, FIG 16, REF 94, VOL I.SDR CNMA20090050Support · crackedGALLEY SUPPORT CORRODED AT STA 459 XX24. REPLACED PN ACA7366-501 IAW DWG ACA7365 AND SRM51-35-01, VOL II, REV 94.SDR CNMA20090049Fitting · corrodedCORROSION ON FITTING GALLEY AT STA 879, X44. REMOVED CORROSION IAW SRM 51-21-24 VOL II, REV 94 WITHOUT LIMITS DEPTH MATERIAL REMOVED 3.5 MM. FABRICATED PN AWD7743-503, REF DWG AWD 7743 AND INSTALL NEW PN IAW SRM 51-31-03, VOL II, REV 94, PAGES 1 THRU 66 AS SDR CNMA20090048Floorbeam · corrodedLIGHT CORROSION ON FLOOR SUPPORT AT STA 815 X-18. FABRICATED AND INSTALLED NEW PN ADA7326-1 IAW DWG 7696 AND ADA7548 AND SRM 51-35-01 STEP 1, VOL II REV 94.SDR CNMA20090047Floor Support · corrodedCORROSION ON FLOOR SUPPORT AT STA 859 - 893 X73. REPLACED PN ADA7160-1 IAW DWG ADA7160 AND DWG 7163 AND MM 20-50-02 REV 81.SDR CNMA20090046Floor Support · corrodedLIGHT CORROSION ON FLOORBEAM SUPPORT BETWEEN STA 1820-1887 X36. REMOVED BEAM IAW SRM 51-31-01 VOL II REV 94. FABRICATED PN AGA7085-1 ED INSTALLED IAW DWG ASA 7127 AND MM 20-50-02 REV 81.SDR CNMA20090045Track · corrodedFOUND CORROSION ON DOWN TRACK AT STA 1871-2007 AND X=107.25. REMOVED CORROSION IAW SRM 51-21-01 V II REV 94 DIMENSIONS OUT OF LIMITS (120 X 50 X 2,3 MM). REPLACED PN NRA6222-9 IAW DWG NFA6222. INSTALLED PN AFA7789-535 IAW SRM 51-35-01 AND 51-33-01 V II INSTESDR CNMA20090044Track · corrodedFOUND CORROSION ON DOWN TRACK AT STA 1902 - 2007 AND X=75.25. CORROSION REMOVED IAW SRM 51-21-01 V G REV 94 DIMENTIONS ARE OUT OF LIMITS (240 X 8T X 2,4 MM) FABRICATED AND INSTALLED TRACK PN AGA7086-506 IAW DWG AGA7086 AND DWG ASA 7127 AND MM 205002 REV 81.
Back to Mcdonnell-Douglas DC-10-30