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 DALA2016062004785Skin · dentedDENT ON LOWER FACE NEAR TO EDGE, 1EA AT RT ELEVATOR CONTROL TAB. REPAIRED IAW SRM 55-04, PAR 2 AND 51-70-2 AND CARD 2000-8149-01.SDR DALA2016062004784Floor Panel · delaminatedDELAMINATION AND FERRULES DAMAGED ON FLOOR PANELS 826B, 826C, 826D, 826E, 827C, 886B, 886C, 927B. FLOOR PANEL NR 826E WAS FABRICATED, FLOOR PANELS 8216C, 826B, 826D, 886C AND 927C DAMAGE FERRULES WERE REPLACED. AMM 53-20-01-201 AND FLOOR PANEL 927B WAS WORKESDR DALA2016062004783Longeron · crackedCRACK ON LONGERON NR 12 LT AND STA Y=1437 AT AFT ACCESSORIES COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18, 51-10-3 PAR 21, 14, 51-30-2 AND 51-30-5, CRACK ON LONGERON L=1.125.SDR DALA2016062004782Longeron · crackedCRACKED LONGERON END 1 AT STA Y=1338. LONGERON END WAS REPLACED IAW SRM 51-30-5, 51-10-2, 51-10-3 PAR 21, 14 AND DWG 4912515 REV H, 51-30-2.SDR DALA2016062004781Longeron · crackedCRACK ON LONGERON END 1338, LONGERON 7 LT. LONGERON END WAS REPLACED IAW SRM 51-30-5, 51-10-2, 51-10-3, PAR 21 AND 14 DWG 4912515, REV H, 51-30-2.SDR DALA2016062004780Longeron · crackedCRACK ON LONGERON END BS 1338, LONGERON 15 RT. LONGERON END WAS REPLACED IAW SRM 51-30-5, 51-10-2, 51-10-3 PAR 21 AND 14, DWG 4912515, REV H 51-30-2.SDR DALA2016062004771Skin · crackedUPPER RT HORIZONTAL STABILIZER AFT SKIN HAS .2500" CRACK INDICATION. TRIMMED OUT CRACK WITH .75" MIN RADIUS, RLW 744338. ACCOMPLISHED CLOSE VISUAL OK TO TREAT AND PAINT. FABRICATED AND INSTALLED FILLER IAW STEP 8 AND 9 IAW DWG SR 09550028. REQUIRED INSPECTSDR DALA2016062004777Battery · dischargedDURING SERVICE CHECK, FOUND COCKPIT, R1, L1 OVERHEAD EMERGENCY LIGHTS INOPERATIVE.
REPLACED EMERGENCY POWER PACK BATTERIES IAW AMM 33-50. OPS CHECK GOOD.SDR DALA2016062004775Battery · dischargedDURING SERVICE CHECK FOUND EMERGENCY LIGHTS AT CEILING ROW 13-15 INOPERATIVE. R & R EMERGENCY LIGHT BATTERIES. OPS CHECK NORMAL. ACFT OK FOR SERVICE.SDR DALA2016062004773Cusp Web · crackedCRACKED RT CUSP WEB STA Y=845 X=54 TO 56 RT AT CPAX. AREA WAS REPAIRED IAW SRM 53-05, FIG 131-A.SDR DALA2016062004770Longeron · crackedCRACKED LONGERON 12 LT, STA Y= 1437 AT AFT ACC COMPARTMENT. LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016062004769Frame · wornWEAR ON FRAME STA Y=1510 CANT AFT FACE BETWEEN 5 HRS TO 6 HRS AT AFT ACCESSORY COMPARTMENT. FRAME LOWER RT SIDE WAS REPLACED IAW SRM 51-30-2, SRM 51-10-4, SRM 51-10-3 PAR 14.21 AND DWG 9911843, REV AC.SDR DALA2016061904768Cusp Web · crackedCRACK ON RT CUSP WEB BETWEEN BS Y=862 TO 866 X=54 TO 56 AT CPAX. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-3.SDR DALA2016061904767Cusp Web · crackedCRACK ON LT CUSP WEB, STA Y=905 BETWEEN X=54 TO X=60 AT CABIN FLOOR STRUCTURE. LT CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-1.SDR DALA2016061904766Doubler · corrodedCORROSION ON PREVIOUS REPAIR UNDER AFT LAVATORY SERVICE PANEL ACCESS AT FUSELAGE SKIN. AREA WAS REPAIRED IAW ER/A 547808-14, REV ORIGINAL.SDR DALA2016061904765Tab · damagedPART RACKS DAMAGED, METALLIZED ON RUDDER CONTROL TAB. METALLIZED ON RUDDER CONTROL TAB WAS REPAIR IAW SRM 51-70-1A-D, PARA 23.SDR DALA2016061804758Door Frame · corrodedAFT CARGO ENTRY LOWER JAMB CORRODED AT FWD AND AFT ENDS. DISCREPANT AREA REF ER/A 546990-14, REV O.SDR DALA2016062004779Cover · unsecureDOOR L1 SLIDE COVER NOT SECURED. R & R SLIDE.SDR DALA2016062004778Door · crackedLEFT LANDING GEAR DOOR FOUND CRACK AFT EDGE AT CURVE. R & R LT MLG DOOR ASSY IAW AMM 32-12, GEAR SWING CKS GOOD.SDR DALA2016062004776Slide · defectiveL1 SLIDE BUSTLE FELL OUT. R & R L1 DOOR SLIDE.SDR DALA2016061904764Doubler · crackedCRACK ON PRODUCTION DOUBLER AT C3 DOOR EXTERNAL HANDLE CUTOUT. CRACKED PRODUCTION DOUBLER WAS REPLACED IAW SRM 52-05D, FIG 30 AND 51-30-5 HFEC WAS PERFORMED, NO CRACKS WERE FOUND ON NEW DOUBLER.SDR DALA2016061804759Cusp Web · corrodedCORROSION ON LT FLOOR CUSP WEB UPPER/LOWER SURFACE X=54 TO X=60 BETWEEN STA Y=1174 AND Y=1180, BETWEEN Y=1271 AND Y=1237. DAMAGE AREA BETWEEN Y=1174 TO 1180 WAS REPAIRED WITH CARD 103, A/C ZONE 201. DAMAGE AREA BETWEEN Y=1237 TO 1271, REPAIR WAS ACCOMPLISHEDSDR DALA2016061804757Cusp Web · corrodedCORROSION ON LT CUSP WEB X=54 TO X= 60, BETWEEN STA Y= 877 TO 880, CABIN FLOOR STRUCTURE. LT CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-4.SDR DALA2016061804756Skin · dentedDENTS ON OUTER SKIN, 5 EA BETWEEN BEAM 4 AND 5 AT FWD CARGO COMPARTMENT DOOR. DENTS WERE ATTENDED WITH ER/A 547800-14MA, REV ORIGINAL.SDR DALA2016061804755Skin · damagedOUT OF LIMITS FOR THICKNESS REMAIN ON PREVIOUS BLEND OUT, STA Y= 355 BETWEEN LONGERON 18 LT TO 19 LT AT OUTER FUSELAGE SKIN. AREA OUT OF LIMITS WAS REPAIRED. PERFORMED GENERAL VISUAL INSPECTION, INITIAL 8000 CYCLES REPETITIVE EVERY 8000 CYCLES IAW SRM 53-04-SDR DALA2016061804754Access Door · corrodedCORROSION ON SETTLEMENT AREA OF FUEL ACCESS DOOR 1409C AT RT WING. FUEL ACCESS DOOR WAS REPLACED.SDR DALA2016062004772Former · crackedCRACKED RT FORMER FWD FACE STA Y = 936, X= -6 A PROXY KEELBEAM AREA. CRACK WAS ATTENDED IAW SRM 53-05D, FIG 810D AND 51-30-5.SDR DALA2016061704760Power Supply · inoperativeEMERGENCY OVERWING LIGHTS INOPERATIVE, R & R EMERGENCY POWER SUPPLY AND BATTERY IAW AMM 33-53. OPS CK NORMAL. AIRCRAFT OK FOR SERVICE. EMERGENCY POWER SUPPLY.SDR DALA2016061704753Cusp Web · corrodedINITIAL CORROSION ON LT CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE BETWEEN STA Y=636 AND Y=655 BETWEEN X=54 TO X=60. FLOOR CUSP WEB WAS REPARED BETWEEN STA Y=636 AND STA Y=655 BTW X=54 TO X=60 IAW SRM 53-05, PAR 144, FIG 131A-6; 51-30-3 PAR 8, 51-30-1, 51-30-5 SDR DALA2016061704751Doubler · damagedWORN AND BENT PREVIOUS PAN REPAIR DOUBLER STA Y= 1154 BETWEEN BEAM 1 AND 2 AT C3 DOOR. WORN AND BENT PREVIOUS PAN REPAIR DOUBLER STA Y= 1154 BETWEEN BEAM 1 AND 2 AT C3 DOOR WAS REPLACED IAW SRM 52-05, FIG 26B, SRM 51-30-1 AND SRM 51-30-2.SDR DALA2016061704750Floor Panel · delaminatedDELAMINATION ON FLOOR PANELS 769D, 693B, 389C, 313B, 541D, 465D, 617C, 541C AND 313C. FLOOR PANEL 541C, 465D, 617C, 389C AND 313C WERE FABRICATED IAW AMM 53-20-01-201. FLOOR PANEL 693B, 541D AND 313B ONLY 1 DAMAGE IN FERRULE AND THIS WAS INSTALLED IAW AMM 53SDR DALA2016061704749Cusp Web · crackedCRACK ON RT CUSP WEB, STA Y=883 TO 885, X=54 TO 56 AT CPAX. RT CUSP WEB, WAS REPAIRED IAW SRM 53-05, FIG 131 A.SDR DALA2016061704748Longeron · crackedCRACKED LONGERON 9 RT, STA Y=1431, CANT AT AFT ACC COMPARTMENT. NEW LONGERON WAS REPLACED IAW SRM 51-30-2 AND 51-30-5. HFEC 01, CRACK OF 0.2" OF LENGTH ON LONGERON IAW NDT SPM 06-10-01.001.SDR DALA2016061704752Doubler · damagedWORN AND BENT PREVIOUS PAN REPAIR DOUBLER STA Y= 1212 BETWEEN BEAM 1 AND 2 ON C3 DOOR. WORN AND BENT PREVIOUS PAN REPAIR DOUBLER STA Y= 1212 BETWEEN BEAM 1 AND 2 ON C3 DOOR WAS REPLACED IAW SRM 52-05, FIG 26 B AND SRM 51-30-1 AND SRM 51-30-2.SDR DALA2016061504721Power Supply · inoperativeON SERVICE, FOUND FIRST CLASS EMERGENCY PATH LIGHTS INOPERATIVE. T/S AND FOUND BATTERY AND POWER SUPPLY BAD. R & R POWER SUPPLY AND BATTERY IAW AMM 33-53. OP CHECK GOOD, OK FOR SERVICE.SDR DALA2016061604720Skin · dentedDENTS ON AFT COMPARTMENT DOOR EXTERNAL SKIN BETWEEN BEAM 3 AND 4, 5 E/A, BETWEEN STA Y=1193 AND 1211, C3. SEVERAL DENTS WERE MEASURED AND WAS ATTENDED WITH ER/A:547806-14, REV ORIGINAL. 10X AND DVI ON INTERNAL STRUCTURE WAS PERFORMED AND NO DAMAGE WAS FOUND SDR DALA2016061604719Skin · delaminatedLT ELEVATOR CONTROL TAB UPPER SURFACE HAS .7500" SPOT OF DELAMINATION, BULGE, APPROXIMATELY 44" OTBD OF INBD END, 1" FWD OF T/E. REMOVED AND INSTALLED LT ELEVATOR CONTROL TAB IAW AMDS 2730-4634.SDR DALA2016061604718Structure · damagedDAMAGED RUDDER FLAME SPRAY. DAMAGE FLAME SPRAY WAS REPAIRED IAW ER/A 092613-14MA REV A, SRM 51-70-1D, REP 23.SDR DALA2016061604717Channel · crackedCRACKS ON CHANNEL AT FLOOR PANEL 389A. CRACKS .100", .125", .150" WERE REPAIRED IAW SRM 53-05, FIGURE 131B AND ER/A 481746-14, REV ORIGINAL.SDR DALA2016061604716Longeron · crackedCRACKED LONGERON 11 LT, STA Y=1431, CANT AT AFT ACCESSORY COMPARTMENT. LONGERON WAS REPLACED, LENGTH OF CRACK: 0.600" IAW SRM 51-30-2, 51-30-5, 51-10-4 AND 51-10-3, PAR 21, 14.SDR DALA2016061604715Access Door · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS DOOR NR 1454C. ACCESS PLATE WAS REPLACED.SDR DALA2016061604714Doubler · crackedCRACKED REPAIR DOUBLER ON FWD DOOR JAMB X=7, STA= 939 AT LT WHEEL WELL AREA. CHANNEL WAS REPLACED IAW SRM 51-10-4, SRM 51-30-2 AND SRM 51-30-5.SDR DALA2016061604713Cusp Web · crackedCRACKED LT CABIN FLOOR CUSP WEB UNDER PRODUCTION DOUBLER AT STA Y=844 BETWEEN X=54 TO X=60. WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-6.SDR DALA2016061604712Cusp Web · corrodedCORROSION ON LT CABIN FLOOR CUSP WEB UPPER, LOWER SURFACE BETWEEN STA Y=693 AND Y=712 AT X=54 TO X=60. CUSP WEB STA Y=693 AND 712 WAS REPAIRED IAW SRM 53-05, FIG 131A-14.SDR DALA2016061604711Floor Panel · delaminatedDELAMINATION AND FERRULES DAMAGED ON FLOOR PANELS NR`S: 120E, 120C, 148A, 148B, 148C, 148D, 160A, 160B, 160C, 160D, 160E, 160F, 200B, 200D, 200E, 256C, 256B, 256D, 313C, 313D. FLOOR PANELS NR`S: 148A, 148B, 148C, 148D, 160A, 160B, 160C, 160D, 160E, 160F, 120CSDR DALA2016061604710Floor Panel · delaminatedDELAMINATION AND FERRULES DAMAGED ON FLOOR PANELS NR`S 927B, 1003C, 1003D, 1073D, 1079B, 1174C, 1250C, W2. FLOOR PANELS NR`S 1003C, 1003D AND 1250C WERE FABRICATED IAW AMM 53-20-01-201. FLOOR PANELS NR`S 927B, 1079B, 1079D, 1174D, 1174C WERE REPLACED, FERRULSDR DALA2016061604708Floor Panel · delaminatedDELAMINATION AND FERRULES DAMAGED ON FLOOR PANELS NR`S 389B, 465B, 465C, 465D, 541B, 541D, 579E, 693C, 693D, 769B, 769C. FLOOR PANEL NR'S: 541D, 769C, 541B, 769B, 693C, 693D, 465B, 489B, 465D AND 465C WERE FABRICATED IAW AMM 53-20-01-201.SDR DALA2016061604707Channel · crackedCRACKED COMPOSITE CHANNEL ON FIRST GENERATION FLOORS NR 1155A AND 1079A. COMPOSITE CHANNEL ON FIRST GENERATION FLOORS NR 1155A AND 1079A WERE REPAIRED IAW SRM 51-70-1.SDR DALA2016061604706Cusp Web · corrodedCORROSION ON LT CABIN FLOOR CUSP WEB UPPER, LOWER SURFACE AT X=54 TO X=60 BETWEEN
STA Y=674 AND Y= 693. LT CUSP WEB FROM X=54 TO X=60 BETWEEN Y=674 AND Y=693 WAS REPAIRED IAW SRM 53-05, FIG 131A-7.SDR DALA2016061604704Cusp Web · corrodedAWR HIDDEN DISCREPANCY: CORROSION ON RT CUSP WEB BETWEEN STA Y: 518 TO 541 AND STA X: -54 TO -60 AT PASSENGER CABIN. CUSP WEB STA Y=518 TO 541 WAS REPAIRED IAW SRM 53-05, FIG 131A-5, SHEET 1.
Back to Mcdonnell Douglas MD-88