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 DALA2016073105663Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER OF LT CUSP WEB BETWEEN BS 1174 - 1193 AND X 54 - 60. THE DOUBLER WAS REPLACED IAW SRM 53-05 FIG 131A-7, SRM 51-30-5, AND SRM 51-10-3.SDR DALA2016073105662Cusp Web · corrodedCORRODED PREVIOUS REPAIR DOUBLER ON LT CUSP WEB BETWEEN BS 446 - 459 , X 54 - 60. THE DOUBLER WAS REPLACED IAW SRM 53-05 FIGURE 131A-2.SDR DALA2016073105661Cusp Web · corrodedCORRODED REPAIR DOUBLERS ON LT CUSP WEB BETWEEN BS 984 - 1003, AND BS 1003 - 1022, X 54 - 60. REPAIR REPLACED IAW SRM 53-05 FIG. 131A-4, 131A-6, 51-10-3 PAR. 14,21,38, 51-30-2 AND 51-30-5.SDR DALA2016073105660Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 965 - 984 AND X 54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIGURE 131A-2.SDR DALA2016080105710Doubler · corrodedCORROSION ON REPAIR DOUBLER BS 446 - 465 AND X -44 TO -60. AREA WAS REPAIRED IAW SRM 53-05 FIG.131A-11, 51-10-3, 51-30-1, 51-30-2 & 51-30-5.SDR DALA2016080105700Longeron · crackedCRACK ON LONGERON 3R BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG.18.SDR DALA2016080105694Frame · corrodedCORROSION ON LONGERONS AND FRAME, FWD AND AFT SIDE OF FRAME AND FROM L28R TO L28L. REMOVED CORROSION IAW SRM 53-01, FIG 1 AND REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016080105693Light · inoperativeAISLE EMERGENCY LIGHTS INOPERATIVE FROM ROW 31 AFT. FOUND CONNECTIONS AT LIGHT ASSY L2-846 IN TAIL COMPARTMENT. RECONNECTED L2-846 LIGHT ASSY CORRECTLY AND REPLACED F1 FUSE AT B5-212 POWER SUPPLY. ALL LIGHTS OPS CK GOOD.SDR DALA2016080105692Cusp Web · crackedCRACK ON LT CUSP WEB OF STA Y642 BETWEEN STA X54 TO X60 AT PAX CABIN. REPAIRED IAW SRM 53-05 FIG 131A-14, 51-30-2, 51-10-3 PAR 21,14, 51-30-5 AND 51-10-3.SDR DALA2016080105691Intercostal · crackedCRACKED INTERCOSTAL X=0 BETWEEN STA Y=1041 TO Y=1022,Y=769 TO Y=788 AND Y=1287 TO Y=1307 ALSO X=4, STA Y=1287 TO Y=1271 AT FLOOR STRUCTURE CABIN. REPLACED INTERCOSTAL STA=1287 TO STA=1271 INTERCOSTAL STA=769 TO STA=788 WAS REPAIRED. 2 CRACKS 1- .250 AND 2- .SDR DALA2016080105690Frame · crackedCRACKS ON FRAME Y=1452 BETWEEN LONGERONS 1, 8L-9L AT AFT ACCESSORY COMPARTMENT. FRAME WAS REPLACED IAW DWG 9911860, REV L AND SRM 51-30-2,51-30-5 AND 51-10-3.SDR DALA2016073105659Skin · cracked.250 INCH CRACK IN FUSELAGE SKIN BS 1380 BETWEEN LONGERONS 12 - 13L. REPAIRED IAW SRM 53-04 FIG18 SHEET 1,2 AND 53-01 FIG 4 SHEET 4.SDR DALA2016073105658Longeron · crackedCRACKED LONGERON 2R, BS 1418. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18.SDR DALA2016073005657Door Frame · corrodedCORROSION ON FWD CARGO COMPARTMENT LWR DOOR FRAME BETWEEN BS 370 - 427. THE DOOR FRAME WAS REPAIRED IAW SRM 53-05 FIG.55A.SDR DALA2016073005656Cusp Web · corrodedCORROSION ON CUSP WEB BETWEEN BS 560 - 579, X 54 - 60. THE CUSP WEB WAS REPAIRED IAW SRM 51-30-2, SRM 51-10-3 PAR. 38, 26, 21 & 14, NDT SPM 04-00-07 PAR 5 FIG.3 SHEET 1-2, SRM 53-05 PAR 166, SRM 53-05 FIG. 131A-14, AND SRM 51-30-5.SDR DALA2016073005655Longeron · crackedCRACKED LONGERON 12L, BS 1437. LONGUERON WAS REPLACED IAW SRM 53-14-4 & 51-30-2 & 51-30-5.SDR DALA2016073005654Stringer · crackedA CRACK WAS FOUND OF 1.500" LENGTH ON STRINGER 11(OUTSIDE) AT THE OUTBD FLAP, INBD DRIVE HINGE AT XRS=164. STRINGER 11 WAS REPAIRED UNDER TASK CARD 5712-01030-03 AND SERVICE REWORK DRAWING SR09570100 REV B.SDR DALA2016073005653Beam · crackedCRACKED NR 8 BEAM AT L1 DOOR. BEAM WAS REPAIRED IAW SRM 52-05D PAR.83 FIG.111.SDR DALA2016111108693Cusp Web · corrodedCORROSION ON REPAIR DOUBLER ON RT CUSP WEB BETWEEN BS 522 AND 544. THE REPAIR DOUBLER WAS REPLACED IAW SRM 53-05 FIG 131A-7, SRM 51-30-5, SRM 51-10-3.SDR DALA2016110408692Frame · corrodedCORROSION ON FRAME PREVIOUS REPAIR BS 1309 BETWEEM LONGERONS 28 AND 29L. THE REPAIR WAS REPLACED IAW SRM 53-03D FIG 2A.SDR DALA2016081605983Tab · delaminatedDELAMINATED RT CONTROL TAB AT RT ELEVATOR. REPLACED WITH SERVICEABLE CONTROL TAB.SDR DALA2016072905665Wire · damagedTHE NR 2 ENGINE OIL TEMP SLOWLY CLIMB TO THE 135 DEGREE LIMIT, FLIGHT CREW FOLLOWED QRH PROCEDURE AND OIL TEMPERATURE COOLED FOR A SHORT TIME. OIL TEMPERATURE EVENTUALLY EXCEEDED 165 DEGREES AND FLIGHT CREW SHUTDOWN THE NR 2 ENGINE AND DECLARED AN EMERGENCY. SDR DALA2016072905652Wire Harness · inoperativeDURING SERVICE CHECK, FOUND SEAT 15E EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSY IAW CMM 33-50-63. OPS NORMAL.SDR DALA2016111108695Cusp Web · corrodedCORROSION ON CUSP WEB BTW STA Y=592 TO Y=517 AND STA X=54 TO 60 AT PAX CABIN. CORROSION FINDING WAS ATTENDED PER SRM 53-05 FIG 131-A, 51-30-2, 51-30-5, 51-10-3 PAR 14,21 AND 38.SDR DALA2016111108694Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS 489 AND 493. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A, 51-30-2, 51-10-3 PAR 14,21 AND 38.SDR DALA2016072805651Longeron · crackedCRACKED LONGERON 7L, BS 1338. LONGERON WAS REPLACED IAW DWG 4912515 REV.H AND SRM 51-30-5.SDR DALA2016072805650Longeron · crackedCRACK ON LONGERON 2L, BS 1418. LONGERON WAS REPLACED IAW SRM 51-30-5.SDR DALA2016072805649Stop Fitting · crackedCRACKED OUTER PAN BELOW STOP FITTING NR 2 AFT EDGE AT FWD CARGO COMPARTMENT DOOR . FWD CARGO COMPARTMENT DOOR WAS REPAIRED PER DC-9/MD80 SRM 52-03 FIG.8.SDR DALA2016072805648Longeron · crackedCRACKED LONGERON 2R, BS 965. LONGERON WAS REPAIRED IAW SRM 53-02 FIG.18.SDR DALA2016072805666Vane · wornWEAR ON LOWER SKIN OF INBD FLAP,INBD VANE XW 4 RT WING. THE SKIN ON INBD FLAP,INBD VANE WAS REPAIRED IAW SRM 57-03D PAR11.SDR DALA2016072805628Wire · looseEMERGENCY LIGHT INOPERATIVE AT SEATS 17D AND 27D. CONNECTED A LOOSE CONNECTION. CHECKED GOOD.SDR DALA2016072805627Connector · damagedEMERGENCY LIGHTS INOPERATIVE FROM ROW 35 AFT. FOUND PUSHED PIN IN QUICK DISCONNECT. REPAIRED THE CONNECTOR AND CHECKED GOOD.SDR DALA2016072805647Cusp Web · crackedCRACKED RT CUSP WEB BS 225, X -58. CUSP WEB WAS FABRICATED AND REPLACED IAW SRM 53-05 FIG.131A-24.SDR DALA2016072705599Cusp Web · corrodedCORROSION ON CUSP WEB FROM BS 1220 - 1231, X -54 AND X -60. CUSP WEB REPAIRED IAW 53-05 FIG 131A-1.SDR DALA2016072705598Doubler · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER OF LT CUSP WEB BS 1221 - 1231, X 54 - 60. THE DOUBLER WAS REPAIRED IAW 53-05 FIG 131A-2.SDR DALA2016072705597Cusp Web · corrodedCORROSION OUT OF LIMITS ON CUSP WEB BS 1233, X 54 TO 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-14,51-30-6, 51-30-1,51-10-3 PAR 14,21 AND 38.SDR DALA2016072705595Angle · corrodedCORROSION ON CUSP ANGLE BS 196 AND X 59. CUSP ANGLE REPAIRED IAW SRM 53-05 FIG.55.SDR DALA2016072705594Doubler · dentedSEVERAL DENTS ON PREVIOUS REPAIR DOUBLER ON INBD FLAP, INBD VANE ON RT WING. REPAIRED IAW SRM 57-03D P.11.SDR DALA2016072705593Access Panel · puncturedPUNCTURE ON SECONDARY ACCESS PANEL 1303C ON LT WING. THE ACCESS PANEL WAS REPAIRED IAW ER/A 530866-14 AD MA REV ORIGINAL.SDR DALA2016072705592Cusp Web · crackedCRACK ON RT CUSP WEB BS 214, RBL 55. CUSP WEB REPLACED IAW SRM 53-14-1 .SDR DALA2016072705591Cusp Web · corrodedCORROSION ON LT CUSP WEB UPPER AND LOWER SURFACE BS 788 TO 807 X 44 TO X 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-14,51-30-2,51-30-1,51-10-3 PAR 14 AND 21.SDR DALA2016072705590Cusp Web · corrodedCORROSION OUT OF LIMITS ON RT CUSP WEB ON BS 1229 X -54 TO - 60. REPAIRED IAW SRM 53-05 FIG.131A-10.SDR DALA2016072705589Longeron · crackedCRACK ON LONGERON 4R BS 522. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18,51-30-2,51-30-5,51-10-4 ,AMM 20-30-00.SDR DALA2016072605568Hand Rail · misinstalledFUNCTIONAL FAIL ON AFT EMERGENCY DOOR HANDLE. EMERGENCY VENTRAL DOOR HANDLE ASSEMBLIES REMOVED AND INSTALLED CORRECTLY AND FAILURE WAS CORRECTED IAW 52-63-1.SDR DALA2016072605567Jackscrew · wornWORN OUT THE HORIZONTAL STABILIZER ACTUATOR. END PLAY ON HORIZONTAL STAB ACTUATOR ASSEMBLY END PLAY IS 0.041. REPLACEMENT OF HORIZONTAL STABILIZER JACK SCREW IS ACCOMPLISHED UNDER CARD 2742-4540 JOB 00-0002.SDR DALA2016072605566Hinge · wornFREE PLAY ON FWD & AFT HINGE AT FWD CARGO DOOR. HINGES WERE REMOVED REPAIRED AND INSTALLED IAW ER/A 497387-14 REV B AND FREE PLAY WAS CORRECTED INSTALLATION OF HINGES WAS PERFORMED IAW AMM 52-31-02.SDR DALA2016072605565Hinge · wornFREE PLAY ON FWD & AFT HINGE AT MID CARGO DOOR. FWD. AFT HINGES REMOVED, REPAIRED AND INSTALLED IAW ERA 497387-14MA REV B AND AMM 52-31-02.SDR DALA2016072605564Cusp Web · corrodedCORROSION ON CUSP WEB FROM BS 1168 TO 1174 BETWEEN X -54 AND -60. REPAIRED IAW SRM 53-05 FIG 131A-1.SDR DALA2016072605563Cusp Web · corrodedCORROSION ON CUSP WEB FROM BS 655 - 674 BETWEEN X -54 TO X -60. CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-5.SDR DALA2016072605562Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 579 - 598, X 54-60. REPAIRED IAW SRM 53-05 FIG 131A-14.
Back to Mcdonnell Douglas MD-88