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 DALA2017060904572Skin · crackedCRACKED LOWER SKIN ON THE LT WING REAR SPAR XCW 75. THE SKIN WAS REPAIRED IAW ETI-88-17-178, REV 7, AND ERA 558148-14AD, REV ORIG.SDR DALA2017060804571Beam · corrodedCORROSION ON THE AFT CARGO DOOR FRAME LOWER BEAM, LONG 28R. CORROSION WAS REMOVED, REWORKED AREAS WERE TREATED AND PAINTED IAW SRM 51-10-3 PAR 26, 14, 21, & 38.SDR DALA2017060804570Floor Panel · damagedPUNCTURES AND DAMAGE FERRULES ON FLOOR PANEL. THE FLOOR PANEL WAS REPLACED IAW AMM 53-20-01-201SDR DALA2017060804569Doubler · wornWEAR ON PRODUCTION DOUBLER AT LOWER AFT CORNER OF MID CARGO COMPARTMENT DOOR. THE DOUBLER WAS REPLACED IAW SRM 51-30-2.SDR DALA2017060804568Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 769 & 788 , BL 0. THE FLOOR SUPPORT WAS REPAIR IAW SRM 51-70-5 FIG 1.SDR DALA2017060704535Structure · puncturedDURING A SERVICE CHECK, FOUND A DENT WITH A PUNCTURE ON BACKSIDE OF RT NR 1 SLAT, 45 INCHES FROM INBOARD, 2.25 X 1.87 L X .195 DEEP. REMOVED AND REPLACED THE SLAT IAW AMDS CARD 2700-4224-RH-01.SDR DALA2017060704538Cusp Web · corrodedCORROSION ON LEFT CUSP WEB BS 1244 BETWEEN LBL 54 TO 60. REPAIR FABRICATED AND INSTALLED IAW SRM 53-05, FIG 131A-13, AND SRM 51-30-5.SDR DALA2017060704537Cusp Web · corrodedCORROSION ON RIGHT CUSP WEB BS 918, RBL 54 - 60. THE CUSP WEB WEB REPAIRED IAW SRM 53-05, FIG 131A-13.SDR DALA2017060704536Cusp Web · corrodedCORROSION ON THE LT CUSP WEB BETWEEN BS 1060 - 1079. CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-14 AND 51-30-2.SDR DALA2017060704534Cusp Web · corrodedCORROSION ON RT CUSP WEB, BS 434 - 451, RBL 54 - 60. DAMAGE AREA WAS REPAIRED IAW SRM 53-05 FIG 131A-10. HFEC INSPECTION WAS ACCOMPLISHED, NO CRACKS WERE FOUND AFTER DAMAGE REMOVED IAW NDT SPM 06-10-01.001.SDR DALA2017060704533Floor Panel · delaminatedDELAMINATION ON FLOOR PANEL. THE FLOOR PANEL WAS REPLACED IAW AMM 53-20-01-201.SDR DALA2017060704532Skin · crackedTWO CRACKS WERE FOUND ON FUSELAGE SKIN AND INTERNAL DOUBLER BS 161 AND 162 BETWEEN LONGERONS 11R TO 12R AT UPPER FORWARD DOOR FRAME OF FWD SERVICE DOOR. THE SKIN WAS REPAIRED IAW SRM 53-05, FIG 176.SDR DALA2017060704530Floor Panel · crackedCRACK ON FLOOR PANEL. THE FLOOR PANEL WAS REPARED IAW SRM 51-10-2, 51-30-2, AND 53-05, FIG 131B.SDR DALA2017060704529Longeron · crackedCRACKED LONGERON 2L, BS 1401. REPAIRED THE LONGERON IAW SRM 53-02, PAR 12, FIG 18, 51-30-2, 51-30-5, AND 51-10-3, PAR 14, 21.SDR DALA2017060704528Pan · crackedCRACK ON INNER PAN AT OUTBD EDGE, BS 693 BETWEEN BEAMS 1 AND 2 IN MID CARGO DOOR. THE PAN WAS REPAIRED IAW SRM 52-05, FIG 26A.SDR DALA2017060704527Tee Fitting · crackedCRACKED CARGO DOOR TEE ANGLE BETWEEN BEAMS 5 AND BS 427. REPLACED IAW SRM 51-30-1, 51-30-2 AND 51-30-5.SDR DALA2017060704526Longeron · crackedCRACKED LONGERON 2L, BS 1401. REPAIRED THE LONGERON IAW SRM 53-20, PAR 12, FIG 18, 51-30-2, 51-30-5, AND 51-10-3, PAR 14, 21.SDR DALA2017060604497Cusp Web · crackedCRACKED RT CUSP WEB BS 845, RBL 58. THE CUSP WEB WAS REPAIR IAW SRM 53-05, FIG 131 A-2, SHEET 1.SDR DALA2017060604489Cusp Web · crackedCRACKED RT CUSP WEB BETWEEN BS 351 TO 370, RBL 54 TO 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A, 51-30-5, AND 51-30-2.SDR DALA2017060604488Channel · crackedCRACKS ON CHANNEL OF FLOOR PANEL 1174F. THE CHANNEL WAS REPAIR IAW SRM 53-05, FIG 131B.SDR DALA2017060604487Frame · wornWORN TITANIUM FRAME ON BS BS 1344, BTW LBL 20 TO RBL 20. THE FRAME WAS REPAIRED IAW ER/A 094719-14MA REV A.SDR DALA2017060504475Doubler · corrodedCORRODED PREVIOUS REPAIR DOUBLER ON RT CUSP WEB STA Y 716 AND X- 57 AT PAX CABIN. DOUBLER AND RING DOUBLER ON RT CUSP WEB STA Y=716 AND X- 57, WAS REPLACE PER SRM 51-30-2; 51-30-5; 53-05 FIG 131A-14; AND 51-10-3 PAR 21 AND 14.SDR DALA2017060504474Cusp Web · corrodedCORROSION IN LT CUSP WEB AT STA Y=1009 AND X=54 TO X= 60. CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131A-13.SDR DALA2017060404476Battery · dischargedDURING SVC CHK FOUND EMERGENCY WING EXIT SIGNS NOT ILLUMINATING. REPLACED BATTERIES IN TWO BATTERY PACKS IAW AMM 33-53-00. OPS CHK GOOD.SDR DALA2017060404473Ball · not seated"TAIL CONE UNSAFE" ILLUM ON OAP. FOUND BALL UNSEATED AT OUTSIDE HANDLE RELEASED INSERTED BALL BACK INTO OUTSIDE MECHANISM. LIGHT OUTS ALL RUN IN GOOD CONDITION PER MM 25-62-01. INSPECTED CABLES ON INTERNAL AND EXTERNAL HANDLES. OK FOR SERVICE RII.SDR DALA2017060404468Access Panel · corrodedCORROSION ON AREA COUNTERSINK ON FUEL TANKS ACCESS PLATES NR 1409C AND 1464C. PANELS WERE REPLACED.SDR DALA2017060604492Vane · gougedFOUND THREE GOUGES ON INTERMEDIATE FLAP, RT WING, JUST AFT OF 2ND FLAP HINGE. REPLACED THE THE FLAP INBD FIXED VANE IAW AMM 27-51-03.SDR DALA2017060404472Floor Support · corrodedCORROSION FLOOR SUPPORTS ON STA Y=1155 BTW LT SEAT TRACKS X 22 AND X 44 AT PAX CABIN. FLOOR SUPPORT ON STA Y 1155 WAS REPLACED PER PER SRM 51-30-5.SDR DALA2017060404471Floor Support · corrodedCORROSION ON ANGLE OF FLOOR SUPPORT STA Y=160 BTW X=12 TO X=54. ANGLE OF FLOOR SUPPORT STA Y=160 BTW X=12 TO X=54 WAS REPLACED PER DWG 9955780 REV LA, AND WAS INSTALLED PER SRM 51-30-1 AND 51-30-2.SDR DALA2017060404470Bracket · corrodedCORROSION ON PULLEY BRACKETS (2 E/A), ON FRAME STA Y=1463 CANT 12 HRS POSITION AT AFT ACCESSORY COMPARTMENT. REPAIRED PER ERA 558121-14.SDR DALA2017060404469Access Panel · corrodedCORROSION ON LT WING ACCESS PANEL 1307C. REPLACED PANEL.SDR DALA2017060304467Channel · crackedCRACK ON CHANNEL AT FLOOR PANELS NR 389G AND 465A. FLOOR PANEL 389G AND 465A WAS STOP DRILLED THE END OF CRACK WITH 0.250" PER SRM 53-05 FIG 131B. DOUBLER (2) WAS FABRICATED AND INSTALLED PER SRM 51-10-2 AND 53-05 FIG 131B AND 51-30-2.SDR DALA2017060304466Diaphragm · corrodedCORROSION ON DIAPHRAGM BTW STA Y=200-210 BTW X=-44 TO X=-54. AT PAX CABIN FLOOR STRUCTURE. CORROSION REMOVED AND DOUBLER REPAIR WAS FABRICATED PER SRM 53-05 FIG 131A-1 AND WAS INSTALLED PER SRM 51-30-8.SDR DALA2017060304465Longeron · crackedCRACKED LONGERON 2R, ON STA Y=1418. SECTION REPLACED PER SRM 51-30-5.SDR DALA2017060304464Pan · crackedCRACKED UPPER/FWD CORNER ON RT WINDOW PAN STA Y= 886. REPAIRED PER SRM 53-05 FIG 122 AND ERA 493648-14MA.SDR DALA2017060304463Window · crackedCRACKED LOWER/AFT CORNER ON RT WINDOW PAN STA Y= 905. REPAIRED PER SRM 53-05 FIG 122 AND ER/A 493648-14MA.SDR DALA2017060304462Longeron · crackedCRACKED LONGERON 3L AT STA 160. REPAIRED PER SRM 53-02 FIG 18.SDR DALA2017060204427Web · crackedCRACKED WEB Y=148 ABOVE LONGERON 27L AT E&E COMPARTMENT. REPAIRED PER SRM 53-01 FIG 2.SDR DALA2017060104426Floor Support · corrodedCORROSION ON FLOOR SUPPORTS STA X=-44 AND X=54 FROM STA Y=160 TO Y=200 AT PAX CABIN. REPAIRED PER SRM 51-30-2 & 51-30-5.SDR DALA2017060104425Floor Support · corrodedCORROSION AND ELONGATED HOLE ON FLOOR SUPPORT STA Y= 180, Y=197, Y=200 BTW X=-22 TO X=-54. REPAIRED PER SRM 51-30-2 AND 51-30-5.SDR DALA2017060104424Support · corrodedCORROSION IN L1 SCUFF PLATE SUPPORT BTW STA Y=195 TO Y=200 AND X=56. REPAIRED PER 51-30-2 & 51-30-8.SDR DALA2017060104396Fitting · crackedCRACKED UPPER AFT CLIP OF RT FWD EMERGENCY EXIT. CLIP WAS REPLACED PER SRM 51-30-1, 51-30-5 AND DWG 9957735 REV G.SDR DALA2017060104395Stop Fitting · crackedCRACKED UPPER FWD STOP OF RT FWD EMERGENCY OVERWING EXIT DOOR. UPPER FWD SECTION PAN WAS REPAIRED PER SRM 52-05 PAR 53 FIG 51.SDR DALA2017053104380Longeron · crackedCRACKED LONGERON 4L AT STA 160. CRACKED LONGERON 4L AT STA 160 WAS REPAIRED PER SRM 53-02 FIG 18.SDR DALA2017053104379Longeron · crackedCRACKED LONGERON 2L AT BS 160. THE LONGERON WAS REPAIRED IAW SRM. 53-02, FIG 18.SDR DALA2017060104397Pump · malfunctionedON TAKEOFF ROLL CENTER FUEL PRESS LO LIGHT ILLUMINATED. CB J21 AND J23 WERE FOUND POPPED ON CLIMBOUT. T/S PER MM REF 28-20-07-101 THRU STEP 4 - WIRING CK AT TERMINAL STRIP S3-10 CKS OK. REF WDM 28-21-00 RANG LT AND RT BOOST PUMPS PHASES A B C TO GRD AND PHASESDR DALA2017053104389Battery · dischargedCEILING EMERGENCY LIGHTS OUT AT SEATS 16, 17, 18, 19, 20, 26, 27, 28, 29, AND 30. REPLACED BATTERIES AT POWER UNITS SN-22713 AND SN-27406. REFERENCE AMM 33-53-00-401. OPS CHECK OK. PN'S ON FOUR 41B004AD07G3 BATTERIES.SDR DALA2017053104388Cusp Web · crackedCRACK IN LT CUSP WEB STA 812. LT CUSP WEB STA 812 WAS REPAIRED PER SRM 53-05 FIG 131A.SDR DALA2017053004381Life Raft · low pressureFWD LT LIFE RAFT PRESSURE LESS THAN 3000PSI. REMOVED AND REPLACED LIFE RAFT ASSY PER AMM 25-62-02.SDR DALA2017053004377Lanyard · no testTAILCONE SLIDE LANYARD FAILS SNAP PULL TEST. REPLACED THE LANYARD. A CCOMPLISHED A PULL TEST IAW AMDS 5350-4644.
Back to Mcdonnell Douglas MD-88