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 DALA2016030801752Access Panel · corrodedCORROSION ON COUNTERSUNK AT FUEL ACCESS PLATE NR 1307C. CORROSION ON COUNTERSINK WAS REMOVED AND MEASURED 3 HOLES ADJACENT WERE FOUND OUT LIMITS WITH 0.664", 0.671" AND 0.688". THEREFORE IT IS OUT LIMITS AND IT WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016030801751Angle · crackedCRACK ON FRAME ANGLE BS 1309, LONG 16LT. ANGLE WAS REPLACED IAW SRM 51-30-5 AND DWG 9912243, SRM 53-14-3.SDR DALA2016030801750Beam · crackedCRACKED BEAM Z=30.187 AND BS 173.5 AT FWD AREA OF FWD SERVICE DOOR. DAMAGE BEAM WAS REPLACED IAW SRM 51-30-2, 51-30-5.SDR DALA2016030801749Angle · corrodedCORROSION ON CUSP ANGLE UNDER R1 DOOR JAMB PAN APPROXIMATELY BS 190. EXCESSIVE CORROSION WAS FOUND, THEREFORE AREA WAS REPAIRED IAW SRM 53-05, FIG 55, 51-30-1, 51-30-2, 51-30-5, 51-10-3, 51-10-4 AMM 21-20-00, 21-00-00 AND ER/A 543175-14 REV ORIGINAL.SDR DALA2016030901782Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL REPAIRED IAW AMM 53-20-01.SDR DALA2016030801754Shutoff Valve · malfunctionedACFT WOULD NOT PRESSURIZE AFTER T/O RAN QRH PROCEDURES. NO HELP. CABIN SUPPLY TEMP REACHED 150F NO AIRFLOW AFTER T/O COULD FEEL AIRFLOW CYCLE 2 OR 3 TIMES ON THEN BACK OFF DURING FLIGHT. R & R LT PRSOV IAW AMM 21-31. LT FLOW CONTROL VALVE SLOW TO OPERATE. RESDR DALA2016030701748Beam · crackedCRACKED BEYOND STOP DRILL ON FWD EDGE OF BEAM NR 1 AT FWD ENTRY DOOR. FWD EDGE OF BEAM NR 1 WAS REPAIRED IAW SRM 52-05D, FIG 98.SDR DALA2016030701710Structure · crackedCRACK ON RT WING L/E BS XOS=286. REPAIRED IAW ER/A 397957-14MA, REV ORIGINAL.SDR DALA2016030701708Frame · corrodedCORROSION ON PREVIOUS DOUBLER REPAIR ON FRAME BS 1250, BETWEEN LONGERON 27LT - 27RT AT AFT CARGO COMPARTMENT. AREA RT WAS CLEANED AND CORROSION NO WAS FOUND, PREVIOUS DOUBLER REPAIR, LT WAS REPLACED IAW SRM 53-03, FIG 2A, PS. 900-1-2-1 N 01. (LP2384607)SDR DALA2016030701707Web · crackedCRACK ON WEB BS 218 BETWEEN X=-40 TO X= -44 AT FLOOR STRUCTURE CABIN. CRACK WAS REMOVED BY DRILLING IT AND OPENING A HOLE OF 0.125" IAW SRM 51-10-4 AND 53-01, FIG 1, SHEET 2 PLUG WAS INSTALLED IAW SRM 51-60-0 AND 51-30-8.SDR DALA2016030701706Static Port · damagedOUT OF LIMITS MISMATCH OF LT ALTERNATE STATIC PORT. DUE TO EXCESSIVE DAMAGE AREA WAS REPAIRED IAW ETI-88-16-083 AND ERA 543168-14, REV ORIGINAL.SDR DALA2016030701705Channel · crackedCRACK ON LT FORMER CHANNEL BS 46 NLG DOOR JAMB WHEEL WELL. DAMAGE WAS REMOVED AND DOUBLER REPAIR WAS TREATED, PAINTED AND INSTALLED IAW SRM 53-05, FIG 110, SRM 51-10-3 PAR 14, 21 AND 51-30-5.SDR DALA2016030701704Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AT WING ACCESS PLATE NR 1464C. CORROSION WAS REMOVED, COUNTERSINKS WERE MEASURED AND MAXIMUN DIAMETER ALLOWABLE IS .532" AND WAS FOUND 1 COUNTERSINK OUT OF LIMITS MEASURE .568", THEREFORE HOLE AND COUNTERSINK WAS REWORKSDR DALA2016030701703Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AT WING ACCESS PLATE NR 1367C. CORROSION WAS REMOVED, COUNTERSINKS WERE MEASURED, MAXIMUN DIAMETER ALLOWABLE IS .532" AND WERE FOUND 2 COUNTERSINK OUT OF LIMITS MEASURED .551" AND .554" THEREFORE HOLES AND COUNTERSINKS SDR DALA2016030701702Skin · corrodedCORROSION ON INTERNAL SKIN BS 689 BETWEEN LONGERON 30 TO 29 RT AT MID CARGO COMPARTMENT. INTERNAL SKIN WAS REPAIRED IAW ETI-88-16-084, REV 2 AND ERA 543173-14, REV. ORIG WITHIN EVERY 8,000 CYCLES AFTER ACCOMPLISHMENT OF ERA 543173-14, REV ORIG SECTION I REPAISDR DALA2016030701701Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF WING ACCESS PLATE 1363C. CORROSION WAS REMOVED, MEASURED SETTLEMENT WAS ACCOMPLISHED, ORIGINAL THICKNESS IS .150", REMAINING THICKNESS IS .137" THEREFORE IT IS WITHIN LIMITS, COUNTERSINKS WERE MEASURED, MAXIMUN SDR DALA2016030701700Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF WING ACCESS PLATE NR 1472C. CORROSION WAS REMOVED, MEASURED SETTLEMENT AREA WAS ACCOMPLISHED ORIGINAL THICKNESS IS .150", REMAINING THICKNESS .138" THEREFORE IT IS WITHIN LIMITS, COUNTERSINK WERE MEASURED MAXIMUMSDR DALA2016030701699Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA AT WING ACCESS PLATE NR 1478C. CORROSION WAS REMOVED, MEASURED SETTLEMENT WAS ACCOMPLISHED ORIGINAL THICKNESS IS .150", REMAINING THICKNESS IS .138", THEREFORE IT IS WITHIN LIMITS, COUNTERSINKS WERE MEASURED AND MSDR DALA2016030701698Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF WING ACCESS PLATE 1377C. CORROSION WAS REMOVED, MEASURED SETTLEMENT AREA WAS ACCOMPLISHED, ORIGINAL THICKNESS IS .150" REMAINING THICKNESS IS .140", THEREFORE IS WITHIN LIMITS, COUNTERSINKS WERE MEASURED AND MAXSDR DALA2016030701697Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF FUEL ACCESS PLATE 1414C. CORROSION WAS REMOVED, MEASURED ON SETTLEMENT WAS ACCOMPLISHED, ORIGINAL THICKNESS IS .180" REMAINING THICKNESS IS .172" THEREFORE IT IS WITHIN LIMITS, COUNTERSINKS WERE MEASURED AND MINSDR DALA2016030701696Pan · crackedCRACK PAN BELOW STOP FITTING NR 4 AT AFT CARGO COMPARTMENT DOOR. PAN WAS REPAIRED IAW SRM 52-05, FIG 50.SDR DALA2016030701695Fitting · crackedCRACKED FITTING ON FWD EDGE BS 636 AND BEAM 5 ATMID CARGO COMPARTMENT DOOR. SEAL RETAINER AND T-FITTING WERE REMOVED IAW SRM 51-30-1 AND 51-30-2. NEW T-FITTING WAS DRILLER IAW SRM 51-10-4. NEW T- FITTING WAS TREATED PAINTED AND INSTALLED IAW SRM 51-10-3 PAR 1SDR DALA2016030701694Intercostal · crackedCRACK ON INTERCOSTAL OF INTERNAL STRUCTURE BETWEEN BEAMS NR 4 TO NR 5 AND BS 186 AT FWD ENTRY DOOR. INSTERCOSTAL OF INTERNAL STRUCTURE BETWEEN BEAM NR 4 TORN 5 WAS REMOVED DUE TO CRACK, AND NEW INSTERCOSTAL WAS INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2016030701692Skin · wornWORN INBD AFT CORNER ON RT WING OTBD FLAP OTBD GUIDE VANE. INBD AFT CORNER ON RT WING OTBD FLAP OTBD GUIDE VANE WAS REPAIRED IAW SRM 57-03D, PAR II.SDR DALA2016030701688Skin · delaminatedDELAMINATED UPPER SURFACE ON INBD GUIDE VANE AT LT WING OTBD FLAP, POSITION 3, BS XV1=170. UPPER SURFACE ON INBD GUIDE VANE AT LT WING OTBD FLAP WAS REPAIRED IAW SRM 57-03D, PAR II.SDR DALA2016030701687Door Frame · puncturedPUNCTURED MID CARGO DOOR JAMB WEB BS 629, PROJECTION LONGERON 26RT AT C2. DAMAGE WAS REPAIRED IAW SRM 51-70-4.SDR DALA2016030701686Skin · corrodedCORROSION ON INTERNAL SKIN BS 689 BETWEEN, LONG 30 TO 29 RT AT MID CARGO COMPARTMENT. INTERNAL SKIN WAS REPAIRED IAW ETI-8816-084, REV 2 AND ERA 543173-14, REV ORIGINAL.SDR WX0A2016030773099Engine · failedDURING THE TAKEOFF THE CREW NOTED A LOUD BANG FOLLOWED BY ALL PARAMETERS FLASHING ON THE RT ENG. FIRST OFFICER CALLED THE ABORT AT 100 KTS AFTER SEEING ALL OIL QTY GONE & DASHES ON THE N1. THERE WAS SMOKE IN THE CABIN AT THE TIME OF THE EVENT. THE CREW DECLSDR DALA2016030701711Skin · damagedRT WING AILERON UPPER SURFACE NUMEROUS LOCATIONS WITH EXPOSED COMPOSITE. R & R RT AILERON REF AMDS WC 2710-4124-RT AND NR 176, AILERON CONTROL TAB REF AMDS WC 2710-4376-RT AND NR 333 AND AND AILERON TRIM TAB REF AMDS WC 2710-4627 -RT AND NR 335.SDR DALA2016030701709Skin · crackedTAIL INTERIOR CROWN, SKIN SPLICE DOUBLER HAS CRACK WHICH ORIGINATES UNDER VERTICAL STABILIZER SPLICE PLATE, VISIBLE END HAS BEEN MARKED USING HFEC, 4" INBD OF L3L, BS 1429. REPAIRED IAW PRI 544011-14 AND REV AND COMPLIED WITH ERA 544011-14, REV ORIG.SDR DALA2016030701693Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF WING ACCESS PLATE NR 2302C. CORROSION WAS REMOVED, MEASURED SETTLEMENT AREA WAS ACOMPLISHED ORIGINAL THICKNESS IS .172" THEREFORE IT IS WITHIN LIMITS, COUNTERSINKS WERE MEASURED AND MAXIMUM DIAMETER ALLOWABLE ISSDR DALA2016030701691Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA AT WING ACCESS PLATE 2301C. CORROSION WAS REMOVED, MEASURE SETTLEMENT WAS ACCOMPLISHED ORIGINAL THICKNESS IS .180" REMAINING THICKNESS IS .172", THEREFORE IT IS WITHIN LIMITS, COUNTERSINKS WERE MEASURED AND MAXIMUMSDR DALA2016030701690Support · corrodedCORROSION ON SUPPORTS BS, 2EA AT LWR AREA OF AFTER ACCESSORIES BS 1343. SUPPORTS INTERCOSTAL WERE REPLACED IAW SRM 51-302, 51-30-5 DWG: 9915520, REV M.SDR DALA2016030701689Access Panel · corrodedCORROSION ON COUNTERSINK OF WING ACCESS PLATE 1365C. CORROSION WAS REMOVED, COUNTERSINKS WERE MEASURED MAXIMUM DIAMETER ALLOWABLE IS .532 AND FOUND COUNTERSINK OUT OF LIMITS IN .547, THEREFORE HOLE AND COUNTERSINK WERE REWORKED AND MEASURED WITH ID HOLE .330SDR DALA2016030601682Skin · dentedDENT ON PREVIOUS REPAIR EXTERNAL SKIN AT BS 579 BETWEEN LONG 28 AND 30 RT. DUE TO EXCESSIVE DENTS AREA WILL BE REPAIR IAW SRM 53-04-1, PAR 7. C, 5, A, 1 AND ER/A 543172-14. REPAIR WAS ACCOMPLISHED IAW SRM 51-30-2, 51-30-5, 51-10-3 AND ER/A 543172-14, REV ORIGSDR DALA2016030601681Web · crackedCRACK ON MEMBRANE BS 864 X=47 AT LT FLOOR CABIN PAX. REPAIR WAS ACCOMPLISHED IAW SRM 53-05, FIG 131A-121.SDR DALA2016030601679Rib · crackedCRACKED RIB BS XOS.553 AT RT WING FIXED L/E IN REF CARD 89, ZONE 10. RIB WAS REPAIRED IAW ER/A 543160-14 AND SRM 51-10-2, 51-10-3 PAR 14 AND 21, SRM 57-06A.SDR DALA2016030601678Access Panel · corrodedCORROSION ON COUNTERSINK AT WING ACCESS PLATE 1373 C. CORROSION WAS REMOVED , COUNTERSINKS WERE MEASURED. MAXIMUM DIAMETER ALLOWABLE IS .532" AND WERE FOUND 2 COUNTERSINKS OUT OF LIMITS IN .540" AND .559" THEREFORE HOLES AND COUNTERSINKS WERE REWORKED AND WESDR DALA2016030601677Access Panel · corrodedCORROSION ON COUNTERSINK AT WING ACCESS PLATE NR 1357C. SM, CARD 407, ZONE 100. CORROSION WAS REMOVED, COUNTERSINK WERE MEASURED AND MAXIMUM DIAMETER ALLOWABLE IS .532" AND WERE FOUND 2 COUNTERSINKS OUT OF LIMITS, MEASURED .539" AND .539" THEREFORE HOLES ANDSDR DALA2016030601675Frame · wornWEAR ON FRAME BS 1497 CANT 10 HRS POSITION AT AFT ACC COMPARTMENT. WEAR WAS BLENDED OUT, MEASURE ORIGINAL THICKNESS 0.040, REMAINING 0.039 WITH IN LIMITS REWK AREAS WERE TREATED AND PAINTED IAW ER/A 511165-14 AM REV C AND SRM 51-10-3, PAR 14/21.SDR DALA2016030601674Floor Panel · delaminatedDELAMINATION PASSENGER FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016030601673Floorbeam · crackedCRACKED FLOORBEAM X 54, BS 927 AT FLOOR STRUCTURE CABIN. CRACKED FLOORBEAM WAS REMOVED AND NEW FLOORBEAM WAS DRILLED AND WAS INSTALLED IAW SRM 51-30-2 AND 51-30-5 AND 51-10-3 AND DWG 5930561, REV AC.SDR DALA2016030601672Cusp Web · corrodedCORROSION ON CUSP WEB FROM BS 1060 TO 1079, X -60 TO X -54. CUSP WEB REPLACED IAW SRM 51-30-2 , 51-30-5 , 51-30-1 AND DWG 9930612, 51-10-3, PAR 14 AND 21.SDR DALA2016030601671Angle · corrodedCORROSION ON FWD SERVICE DOOR FRAME LOWER CUSP ANGLE. THE CUSP ANGLE WAS REPAIRED IAW SRM 53-05, FIG 18 AND ETI 88-16-056, REV 1 AND ER/A 543155-14, REV ORIGINAL.SDR DALA2016030601676Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016030501669Skin · dentedDENTS ON UPPER SURFACE LT OTBD FLAP INBD GUIDE VANE AT BS XV1=190, XV1=187, XV1=160 AND XV1=161. DENTS XVI=160 AND XVI=161 WERE REPAIRED UNDER ERA 543162-14, REV. A.SDR DALA2016030501668Longeron · crackedCRACKED LONGERON 2L BS 180. DAMAGED WAS REMOVED, A NEW LONGERON AND SPLICE WERE DRILLED, TREATED, PAINTED, AND INSTALLED IAW SRM 51-30-2, 51-30-5, 53-02, FIG 18 51-10-3, PAR 14 AND 21.SDR DALA2016030501667Floor Panel · crackedCRACK ON FLOOR PANEL SKIN 1003A. FLOOR PANEL WAS REPAIR IAW SRM 53-05, FIG 4.SDR DALA2016030501666Cusp Web · crackedCRACKED CUSP WEB BELOW SEAT TRACK X=-54, BS 885 AND 906 IN PASSENGER CABIN. CUSP WEB WAS REPAIRED IAW SRM 51-30-2 , 51-30-5 , 51-10-3, PAR 11, 21 AND 38, 53-05, FIG 131A.SDR DALA2016111608875Longeron · corrodedAFT CARGO BILGE, L29L HAS SMALL SPOT OF CORROSION, BS1231. REPAIRED PER SRM.
Back to Mcdonnell Douglas MD-88