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 DALA2016102407520Floorbeam · corrodedCORROSION OUT OF LIMIT ON FLOORBEAM STA Y= 1322 X=-33 AT RIGHT AFT LAVATORY FLOOR STRUCTURE. FLOORBEAM WAS REPAIRED PER SRM 53-05 FIG 20A.SDR DALA2016102407519Door Frame · crackedCRACKED DOOR JAMB WEB STA Y=207 LONG 15L AT PAX CABIN. CRACKED DOOR JAMB WEB STA Y=207 LONG 15L AT PAX CABIN WAS REPAIRED PER SRM 53-05 FIG 142.SDR DALA2016102507543Turbine · damagedRETURNED TO OKC DUE TO A RIGHT ENGINE FAILURE. THE CREW REPORTED THAT AT FL200 THE ENGINE FAILED WITH AN ASSOCIATED EGT RISE. THE QRH WAS FOLLOWED AND THE ENGINE WAS SHUT DOWN. MAINTENANCE FOUND TURBINE DAMAGE AND METAL IN THE TAILPIPE. THE ENGINE WAS REPLSDR DALA2016102407527Release Cable · frayedUPPER LEFT HAND TAILCONE RELEASE CABLE IS FRAYED. REPLACED AND RIGGED TAILCONE RELEASE CABLE PER AMM 53-53-00 AND AMDS 5350-01077-0101.SDR DALA2016102407526Cable · frayedTAIL CONE CABLE FRAYED AND DETERIORATED. REPLACED CABLE PER AMM 53-53-00.SDR DALA2016102307518Skin · dentedDENTS AND SCRATCHES ON RT ANTI-FLOAT TAB SKIN P/N 5930497-502 53344. RT ANTI-FLOAT TAB SKIN WAS REPAIRED PER SRM 55-04 PAR 2 C3.SDR DALA2016102307517Channel · crackedCRACK CHANNEL ON FLOOR PANELS 617A, 313A AND 313E. CRACK ON CHANNEL THE FLOOR PANELS 617A, 313A AND 313E WERE REPAIR PER SRM 53-05 FIG 131B.SDR DALA2016102307516Cusp Web · corrodedCORROSION ON RT CUSP WEB X -60 TO X - 44 UPPER AND LOWER BTW STA Y 389 TO 503. WEB WAS REPLACED PER SRM 51-30-2 AND 51-30-5.SDR DALA2016102307515Cusp Web · corrodedCORROSION ON LT CUSP WEB BTW Y=845 TO Y=864,Y=864 TO Y=886, Y=886 TO Y=905, X=44-X=60 AT CABIN FLOOR STRUCTURE, UPPER AND LOWER SURFACE. CUSP WEB WAS REPLACED PER SRM 53-05 FIG 131A-7.SDR DALA2016102307514Doubler · crackedDURING OPPORTUNITY INSPECTION, BS 1429 SKIN SPLICE. SPLICE DOUBLER CRACKED RBL 10". COMPLIED WITH PRI 551376-14 REV ORIGINAL, AND ER/A 551376-14 REV ORIGINAL.SDR DALA2016102207513Frame · crackedDURING OPPORTUNITY INSPECTION FOUND FRAME 1418 CRACKED AT LONGERON 1L. REPAIRED PER PRI 551806-14 REV 0 AND COMPLIED WITH ERA 551806-14 REV ORIG.SDR DALA2016102807862Sidewall Panel · damagedAFT AIRSTAIR SIDE WALL PANEL ON CAPTAIN'S SIDE AT TOP IF STEPS NEAR EXIT DOOR BENT DOWN AND PREVENTING EGRESS. REPAIRED IAW ERA.SDR DALA2016102407544Battery · dischargedCEILING EMERGENCY LIGHTS INOP BETWEEN ROW 21 AND 34. REPLACED BATTERIES IN EMERGENCY POWER PACK FOR LIGHTS AT ROW 21-34 CHECKS GOOD IAW AMM 33-53.SDR DALA2016102407542Warning System · activatedTAILCONE UNSAFE LIGHT IN FLIGHT. INSERTED LOCKING CABLE IN RETAINING HOLE IN SUPPORT FITTING UNTIL SECURE PER AMM 53-53 PARAGRAPH 3 STEP 10.SDR DALA2016102207512Cusp Web · crackedCRACK ON LT CUSP WEB STA Y= 1184 TO BTW X=54 TO X=60 AT PAX CABIN. FASTENERS AND REPAIR PART WERE INSTALLED PER SRM 53-05 FIGURE 131A -14, 51-30-2.SDR DALA2016102207511Cusp Web · corrodedCORROSION ON RT CUSP WEB BTW Y=826 TO Y=845 X=44-X=60 AT CABIN FLOOR STRUCTURE. CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131A-10.SDR DALA2016102207510Longeron · corrodedCORROSION ON LONGERON 23LH BTW STA Y=1283 TO Y=1290. LONGERON SECTION 23 LT BTW STA Y=1281 TO 1328 WAS REPAIRED PER SRM 53-02 FIG 18.SDR DALA2016102207509Cusp Web · crackedCRACKED LT CUSP WEB X=59 STA Y=816 AT PAX CABIN FLOOR STRUCTURE. WEB WAS REPAIRED PER SRM 53-05 FIG 131A.SDR DALA2016102207508Frame · crackedCRACK ON WEB OF FRAME STA Y = 1437 RT SIDE 2 HRS POSITION AT AFT ACC COMPARTMENT. WEB WAS REPAIRED PER SRM 51-70-4 FIG1.SDR DALA2016102207507Longeron · crackedCRACKED LONGERON 24R STA Y=200 AT E&E COMPARTMENT. LONGERON WAS REPAIRED PER SRM 53-02 FIGURE 18.SDR DALA2016102207506Longeron · crackedCRACKED LONGERON NR 12L ON STA Y 1437 AT AFT ACC COMPARTMENT. CRACKED LONGERON WAS REMOVED AND REPLACED PER SRM 53-14-4 AND 51-30-2, 51-30-5 AND 51-10-4 AND 51-10-3 PAR 21, 14.SDR DALA2016102207505Door Frame · crackedCRACK ON LT AFT EMERGENCY EXIT DOOR JAMB UPPER AREA. CRACK (0.843") ON DOOR JAMB WAS REPAIRED PER SRM 53-05 FIG 32.SDR DALA2016102207503Floor Panel · delaminatedDELAMINATION ON FLOOR PANEL NR 927C, 1250B, 1155B. FLOOR PANELS NR: 1250B,1155B WERE FABRICATED PER AMM 53-20-01-201 AND FERRULES WERE REPLACED PER AMM 53-20-01-201.SDR DALA2016102207502Cusp Web · corrodedCORROSION ON LT CUSP WEB FROM X= 54 TO X= 60 BTW STA Y= 1212 TO Y= 1231 UPPER AND LOWER SURFACE AT PAX CABIN. LT CUSP WEB FROM X= 54 TO X= 60 BTW STA Y= 1212 TO Y= 1231 WAS REPAIRED PER SRM 53-05 FIG 131 A.SDR DALA2016102207501Cusp Web · corrodedCORROSION ON LT CUSP WEB BTW STA Y=550-562 AND Y= 589-596 X=54-60. LT CUSP WEB BTW STA Y=550-562 AND Y=589-596 X=54-60 WAS REPAIRED PER SRM 53-05 FIG 131A-11, SRM 51-30-5, 51-10-3 PAR 21 AND 14.SDR DALA2016102207504Door Frame · corrodedCORROSION ON AFT BULKHEAD DOOR JAMB LOWER SECTION UPPER AND LOWER SURFACE. DOOR JAMB WAS REPAIRED PER SRM 53-05 PAR 45 FIGURE 34.SDR DALA2016102107468Slide · crackedL1 DOOR SLIDE BACK BOARD IS CRACKED. REMOVED AND REPLACED L1 DOOR SLIDE IAW AMDS WC 2561-4964.SDR DALA2016102107464Frame · damagedRT WING MLG WW CUT OUT FWD FRAME HAS A PREVIOUSLY INSTALLED FRAME REPAIR AND IS BULGED OUT AND CRACKED. REMOVED AND REPLACED FRAME IAW DWG 5930584.SDR DALA2016102107419Floor Panel · crackedCRACKS ON GENERATION FLOOR PANELS NR: 256A, 465A, 617A 693A, 927A, 1003A, 1079A. GENERATION FLOOR PANELS NR: 256A, 465A, 617A 693A, 927A, 1003A, 1079A WERE REPAIRED PER SRM 53-05 PAR 145 AND 51-70-1 PAR 10.SDR DALA2016102107418Cusp Web · crackedCORROSION OUT OF LIMITS ON RT CUSP WEB FROM STA 1071 TO 1074 BTW X -54 AND -60. WEB WAS REPAIRED PER SRM 53-05 FIG 131A-13.SDR DALA2016102107417Cusp Web · corrodedCORROSION ON RT CUSP WEB BTW X= -54 TO X= -60 FROM Y= 503 TO Y= 598 AT PAX CABIN. CUSP WEB WAS REPLACED PER SRM 51-10-4, 51-30-1, 51-30-2, 51-30-5, 51-10-3 PAR 14 AND 21.SDR DALA2016102107416Skin · delaminatedDELAMINATION ON UPPER SKIN APPROX STA XOVIF= 97 AT LT WING INBOARD FLAP OUTBOARD VANE. LT WING INBOARD FLAP OUTBOARD VANE WAS REPAIRED BY SRM 57-03D PAR 11.SDR DALA2016102107415Pan · crackedCRACKED LT WINDOW RING PAN AFT/LOWER CORNER STA Y=905 AT CPAX. RING PAN WAS REPAIRED PER SRM 53-05 FIG 122, 51-30-02, 51-30-05, 51-10-03, PAR 21,14.AND ER/A 487747-14MA REV A, 493648-14MA. REV A.SDR DALA2016102107414Longeron · crackedCRACKED LONGERON 16L ON STA Y 1437 AT AFT ACC COMPARTMENT. CRACKED LONGERON WAS REMOVED AND REPLACED PER SRM 53-14-4 AND 51-30-2, 51-30-5 AND 51-10-4 AND 51-10-3 PAR 21, 14.SDR DALA2016102107413Floor Panel · delaminatedDELAMINATED FLOOR PANELS NR 148A,148B, 148C, 148D, 160 A, 160B, 160C, 160B, 160E, 200B, 200C, 200D, 200E AT W1 AREA. FLOOR PANELS NR 148A,148B, 148C, 148D, 160A, 160B, 160C, 160D, 160E, 200B, 200C, 200D AND 200E WERE FABRICATED PER AMM 53-20-01-201.SDR DALA2016102107412Cusp Web · puncturedPUNCTURED LT CUSP WEB Y=1007 BTW X=44 AT CABIN FLOOR STRUCTURE. CUSP WEB WAS FABRICATED AND REPLACED PER SRM 53-05 FIGURE 131A.SDR DALA2016102007396Floor Panel · delaminatedDELAMINATION ON FLOOR PANEL NR 1307B. FLOOR PANEL 1307B WAS FABRICATED PER AMM 53-20-01-201.SDR DALA2016102007382Bellcrank · wornEMPENNAGE, LT ELEVATOR GEAR TAB O/B BELL CRANK IS WORN FROM FAIRING CHAFE. REPLACED GEARED TAB PER AMDS 2730-4130 LT.SDR DALA2016102007397Pan · crackedCRACKED INNER PAN ON FWD EDGE BTW BEAM 2 AND 3 AT FWD SERVICE DOOR INNER STRUCTURE. REPAIR DOUBLER WERE REPLACED PER ERA 487761-14 REV A.SDR DALA2016102007395Doubler · corrodedCORROSION ON RT CUSP WEB REPAIR DOUBLER BTW STA X= - 60 TO X= - 44 ON STA Y=1098 TO Y=1117. REPAIR DOUBLER WAS REPLACED PER SRM 53-05 FIGURE 131A-7.SDR DALA2016102007381Seat Track · damagedOUT OF LIMITS RT TIE TRACK FROM STA Y=1007 TO STA Y=1155 C3. NEW TIE TRACK WAS REPLACED PER SRM 51-10-4 2. HOLES TREATED AND PAINTED SRM 51-10-3 PAR 14 AND 21.SDR DALA2016101907358Longeron · crackedCRACKED LONGERON 10R BS 1431. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18.SDR DALA2016101907357Longeron · crackedCRACKED LONGERON 9R BS 1431. THE LONGERON WAS REPAIRED IAW SRM 53-02.SDR DALA2016101907383P&D Valve · leakingFLT 0377 RETURNED TO ATL AFTER THE LT ENGINE FAILED AFTER TAKE-OFF. THE CREW REPORTED THAT ON CLIMB OUT THAT THE ENGINE ROLLED BACK AND SHUT DOWN. MAINTENANCE FOUND FUEL LEAKING AT THE P&D VALVE FLANGE. THE P&D VALVE WAS REPLACED. THE MAGNETIC CHIP DETECTOSDR DALA2016101907380Fuse · blownEMERGENCY EXIT LIGHTING IN FIRST CLASS INOP. REPLACED FUSE NR 1 ON RT F/C EMERGENCY LIGHT BATTERY PACK, NOW OPS NORMAL. OK FOR SERVICE.SDR DALA2016101907356Longeron · crackedCRACK ON LONGERON 4L AND BS 541. THE LONGERON WAS REPAIRED IAW SRM. 53-02 FIG. 18, 51-10-3 PAR. 14,21, 51-30-2 AND 51-30-5.SDR DALA2016101907355Longeron · crackedCRACKED LONGERON 10R BS 484. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18, 51-10-3 PAR 14, 21, 51-30-5, 51-30-2.SDR DALA2016101907354Hinge Fitting · corrodedNR 2 RT FLAP HINGE UPPER INBD AND LOWER INBD MOUNTING STUDS CORRODED. REPLACED THE HINGE FITTING AND UPPER & LOWER MOUNTING STUDS IAW AMDS 5710-01110-05B.SDR DALA2016101907353Floor Panel · damagedFLOOR PANEL DAMAGED. THE FLOOR PANEL WAS REPLACED IAW AMM 53-20-01-201 PARAGRAPH 7B.SDR DALA2016101907352Packing · damagedDAMAGE PACKING OF TAIL CONE EVACUATION SLIDE. THE SLIDE WAS REPLACED AND WAS INSTALLED IAW CARD 5350-4644, JOB 001-0195.
Back to Mcdonnell Douglas MD-88