Mcdonnell Douglas MD-88
Service difficulty reports · 21,991
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 = 'MD88' 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 = 'MD88' 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 DALA2016101407243Pan · crackedCRACK ON RT WINDOW RING PAN UPPER FWD CORNER BS 845 AND 864. THE PAN WAS REPAIRED IAW ER/A 333615-14MA REV. G.SDR DALA2016101407242Pan · crackedCRACK ON LOWER AFT CORNER ON LT WINDOW RING PAN BS 886 AND 905. THE PAN WAS REPAIRED IAW ER/A 333615-14MA REV. G.SDR DALA2016101407241Pan · crackedCRACK ON LT WINDOW RING PAN UPPER FWD CORNER BETWEEN BS 332 - 351. THE PAN WAS REPAIRED IAW ER/A 333615-14MA REV. G.SDR DALA2016101407240Longeron · crackedCRACK ON LONGERON 16L BS 1437. THE LONGERON WAS REPLACED IAW SRM 53-14-4 FIG 4,51-30-2 AND 51-30-5.SDR DALA2016101407239Pan · crackedCRACK ON INTERNAL PAN BS 162 BTWEEN UPPER EDGE AND BEAM 1 AT MAIN ENTRANCE DOOR. HFEC INSPECTION WAS ACCOMPLISHED ON INTERNAL PAN. ONE CRACK OF 2.340 WAS FOUND. STOP DRILL WAS PERFORMED, HFEC WAS ACCOMPLISHED AFTER STOP DRILL AND NO CRACKS WERE FOUND. INTERNALSDR DALA2016110708339Vane · crackedCRACKED RT WING INBD FLAP OUTBD GUIDE VANE AT UPPER SKIN INBD LWR CLEVIS HARDWARE ACCESS. THE VANE WAS REMOVED IAW AMM 27-51-03-201.SDR DALA2016101707307Connector · damagedFOUND CABIN EMERGENCY LIGHTS AT ROWS 20C AND 29C INOPERATIVE. CONNECTED THE WIRE ROW 29C IAW AMM 33-53. SEAT 20C. REPINNED CONNECTOR AT 20C, CHECKS NORMAL.SDR DALA2016101307238Battery Pack · inoperativeMULTIPLE FIRST CLASS EMERGENCY LIGHTS ARE INOPERATIVE. REMOVED & REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2016101307237Battery Pack · inoperativeOVERHEAD EMERGENCY LIGHTS INOPERATIVE AT ROWS 11 TO 15. REPLACED THE BATTERY PACK IAW AMM 33-53-00 OP CHECKED GOOD.SDR DALA2016101307235Door Frame · crackedCRACK ON WEB AT L1 DOOR FRAME STRUCTURE BTWEEN BS 200 AND 210, LONGERON 11L. WEB REPAIRED IAW SRM 53-05 FIG 143.SDR DALA2016101307234Frame · crackedTAILCONE ATTACH FRAME CRACKED AT 3 OCLOCK AND 2 O`CLOCK POSITIONS. REMOVED DAMAGED FRAME SECTION AND STARTED INSTALLING NEW SECTION. INSTALLED NEW FRAME IAW DWG 5966769.SDR DALA2016101307232Angle · crackedCRACK ON ANGLE BS 195 BELOW OF BEAM 1 AT FWD SERVICE DOOR. THE ANGLE WAS REPLACED IAW SRM 51-30-5 AND DWG 9911579 REV L.SDR DALA2016101307192Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 712 - 737, X 54 - 60. REPAIRED IAW SRM 53-05 FIG. 131A-13 (SHEET 1) AND 53-05 FIG. 131A-13 (SHEET 5).SDR DALA2016101307191Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 503 TO 522 , X 44 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A.SDR DALA2016110108122Skin · dentedDENT ON UPPER SURFACE OF CONTROL TAB AT RT ELEVATOR BTW STA APPROX XHS 30 TO XHS 78. CONTROL TAB WAS REPLACED PER IPC 55-20-00-05.SDR DALA2016101207190Vane · damagedHOLE IN INBD FIXED VANE, OTBD SECTION OF RT WING TE FLAP. REMOVED AND REPLACED THE VANE IAW AMM 27-51-03 P 201.SDR DALA2016101207189Intercostal · out of positionTAIL CONE ACTIVATION CABLE SUPPORT INTERCOSTAL IS OUT OF POSITION AT AFT END BS 1510. REPLACED THE INTERCOSTAL IAW DWG 9917701. TREATED AND PRIMED IAW SRM 51-10-03.SDR DALA2016101107183Battery Pack · inoperativeFWD GALLEY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2016101207182Tee Fitting · corrodedCORROSION FOUND ON THE TEE ANGLE BS 1380 AND LONGERONS 24L TO 24R. THE TEE WAS REPLACED PER DC9/MD80 DWG 9912246-115. (LP2721089)SDR DALA2016101207181Longeron · crackedCRACKED LONGERON 3L BS 160. THE LONGERON WAS REPLACED IAW SRM 53-02 FIG.18.SDR DALA2016101207180Beam · crackedCRACK ON BEAM NR 6 BS 177 AT MAIN ENTRANCE DOOR. THE BEAM WAS REPAIRED IAW ERA 413018-14 MA REV ORIG.SDR DALA2016101207179Web · crackedCRACK ON INTERNAL WEB BS 192 OF THE L1 DOOR. THE WEB WAS REPAIRED IAW SRM 52-01 FIGURE 4.SDR DALA2016101207178Skin · crackedFUSELAGE SKIN CRACKED AT BS 1437, 5 INCHES OTBD VERTICAL STAB. REPAIRED IAW ERA#551476-14 REV. ORIGINAL.SDR DALA2016101207177Floor Panel · puncturedFLOOR PANEL PUNCTURED. FABRICATED A NEW FLOOR PANEL IAW AMM 53-20-01-201.SDR DALA2016101207174Angle · crackedCRACKED ANGLE ON BEAM 1 AT FWD SERVICE DOOR INNER STRUCTURE. THE ANGLE WAS REPLACED IAW SRM 51-30-5 AND DWG 9911581 REV. U.SDR JR2R20161011298Web · corrodedCABIN FLOOR CORRODED ON VERTICAL WEB. REPAIRED WEB IAW EA 40-2016-317.SDR DALA2016101107176Tab · damagedRUDDER CONTROL TAB HAS FLAME SPRAY MISSING IN CRITICAL AREAS. REMOVED & REPLACED RUDDER CONTROL TAB IAW WORK CARD 2720-4321. OK FOR SERVICE.SDR DALA2016101107149Spacer · corrodedCORROSION ON SPACER OF LOWER BEAM BS 642 AT MID CARGO COMPARTMENT DOOR FRAME. THE SPACER WAS REPLACED IAW 53-05 FIG 123.SDR DALA2016101107148Beam · crackedCRACK ON BEAM NR 8 (AFT EDGE) AT MAIN ENTRANCE DOOR. BEAM WAS REPAIRED IAW SRM 52-05 FIG. 95 SHEET 3.SDR DALA2016101107147Spacer · corrodedCORROSION ON SPACER AT AFT CARGO BAY LOWER DOOR FRAME. SPACER WAS REPLACED IAW SRM 53-05 FIG 123 SHEET 5 AND 51-30-5, 51-30-4.SDR DALA2016101107146Pan · crackedCRACK ON PAN, AFT EDGE BETWEEN BEAM 1 AND BEAM 2 AT AFT CARGO COMPARTMENT DOOR. REPAIRED IAW SRM 52-05 FIG. 26A, SRM 51-30-2 AND SRM 51-30-5.SDR DALA2016101107145Longeron · crackedCRACKED LONGERON 4R BS 541. LONGERON WAS REPAIRED IAW SRM 53-02 FIGURE 18,51-30-5, 51-30-2, 51-10-3 PAR 14, 21,51-30-1.SDR DALA2016101107175Wire · brokenROW 17 SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. INSPECTED PLUG AT SEAT FOR EMERGENCY LIGHTING, FOUND WIRE BROKEN. REPAIR THE WIRE, CHECKED GOOD.SDR DALA2016101007134Cable · damagedTAILCONE FUNCTION- BALL END OF CABLE TO LOCK IN CLIP. FIGURE 2. ITEM 13. REPLACED THE CABLE IAW AMDS 5350-010177-0101.SDR DALA2016101007133Conduit · out of positionTAIL CONE FUNCTION CHECK FAILED STEP 7D (5). LOCKING CABLE CLAMP DOES NOT CLEAR LOWER END OF CONDUITS AT LEAST 1/2". REPOSITIONED CONDUITS PER STEP 5 RECHECKED. IAW AMDS 5350-01077-0101.SDR DALA2016101007128Intercostal · crackedCRACKS ON INTERNAL STRUCTURE LOWER SECTION BS 1174 ON INTERCOSTAL, REPAIRED IAW SRM 52-03D FIG.8, 51-30-1, 51-30-2 AND 51-30-5.SDR DALA2016101007155Duct · crackedAT FL250 THE "FLOW" LIGHT ILLUMINATED WITH CABIN ALTITUDE RISING. CREW DESCENDED TO 10,000 FEET. CORRECTIVE ACTION: MAINTENANCE FOUND RIGHT SPIDER DUCT CRACKED.SDR DALA2016101007135Engine · making metalTHE NUMBER 2 ENGINE SHUTDOWN AT FL340 AND THE FLIGHT WAS DIVERTED. MAINTENANCE FOUND METAL ON THE CHIP DETECTOR. THE NUMBER 2 ENGINE WAS REPLACED AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR DALA2016100907127Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR OF LT CUSP WEB BTW BS 541 TO 560, X 44 - X 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-7.SDR DALA2016100807126Access Panel · damagedELONGATED HOLES ON FUEL ACCESS PANEL 1436. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016101007132Spar · damagedDURING NDT INSPECTION, A DISCREPANT AREA WAS FOUND ON LOWER SKIN REAR SPAR BTW XRS=163 TO 168 AT L WING. REPAIRED IAW ER/A 550332-14AD REV.ORIGINAL.SDR DALA2016101007131Skin · damagedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND ON LOWER SKIN REAR SPAR BTW XRS=163 TO 168 AT RT WING. REPAIRED IAW ER/A 550332-14AD REV.ORIGINAL.SDR DALA2016101007130Skin · dentedTWO DENTS ON UPPER SKIN OF RT MID VANE AT OUTBOARD FLAP. THE VANE WAS REPAIRED IAW SRM 57-03D PAR 11.SDR DALA2016100807125Floor Panel · brokenBROKEN COCKPIT FLOOR PANEL 120E. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016100807124Cusp Web · corrodedCORROSION ON LT CUSP WEB BTW BS 446 - 465 BTW X 54-60 AT PAX CABIN. REPAIR INSTALLED SRM 53-05 FIG.131A-13.SDR DALA2016100707098Spar Cap · crackedRT WING REAR SPAR LOWER CAP PER W/C 5710-0110-05A SHOWS A CRACK INDICATION AT 6:30 POSITION TOTAL LENGTH OF CRACK TO BE DETERMINED AFTER DISASSEMBLY PER W/C 57-10-0110-05B. HFEC INSPECTION WAS ACCOMPLISHED ON RH WING REAR SPAR LOWER CAP ONE CRACK WAS FOUND (LSDR DALA2016100707097Doubler · wornWEAR ON TITANIUM DOUBLER AT AFT LAV SERVICE PANEL AREA. TITANIUM DOUBLER WAS FABRICATED IAW DWG 5911423 REV. CD. 2, TITANIUM DOUBLER WAS PAINTED IAW SRM 51-10-3 PAR 14.SDR DALA2016111508798Valve · failedAFT VENTRAL AIRSTAIRS WILL NOT CLOSE ALL THE WAY. CLOSED AND SECURED VENTRAL AIRSTAIRS. HYD VALVE WAS REPLACED. AND THE HYD ACTUATOR WAS REPLACED.SDR DALA2016102607732Tab · dentedSEVERAL DENTS ON LT ELEVATOR GEARED TAB UPPER SURFACE. GEARED TAB WAS REPLACED IAW SRM 55-04 PAR 2.SDR DALA2016102407466Tab · dentedSEVERAL DENTS ALONG UPPER SURFACE OF THE RT ELEVATOR ANTI-FLOAT TAB. THE TAB WAS REPLACED IAW WORK CARD 2730-4832.
Back to Mcdonnell Douglas MD-88