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 DALA2016032202234Access Panel · corrodedCORROSION ON FUEL ACCESS PLATE. FUEL ACCESS PLATE WERE REPLACED IAW AMM 28-00-00.SDR DALA2016032202233Cap · crackedCRACKED LOWER CAP BS 1463, CANT 11 HRS POSITION AT AFT ACCESORIES COMPARTMENT. LOWER CAP WAS REPAIRED IAW ETI 88-16-059, REV 7 AND ER/A 543145-14, REV ORIG SECTION I, TEMPORARY REPAIR, LENGHT CRACK 4".SDR DALA2016032202232Spar Cap · crackedCRACKED VERTICAL STABILIZER SPAR CAP ON WEB BS 1463 CANT POS 11 HRS AT AFT ACCESORIES COMPARTMENT. VERTICAL STABILIZER SPAR CAP WAS REPAIRED IAW ER/A 543145-14, REV ORIGINAL AND ETI 88-16-059, REV 7, LENGHT CRACK 6".SDR DALA2016032202231Service Panel · corrodedCORROSION AT FWD LAVATORY SERVICE PANEL. LAVATORY SERVICE PANEL WAS REPLACED IAW SRM 51-02 PAR 6A AND DWG 5922013, REV AS AND SRM 51-10-3, 51-30-2.SDR DALA2016032102143Slide · dislodgedTHE 1L DOOR EMERGENCY ESCAPE SLIDE FELL OFF OF THE DOOR. MAINTENANCE INSPECTED THE SLIDE AND REINSTALLED IT. THE GIRT BAR WAS FOUND MIS-ALIGNED AND WAS THEN RE-ALIGNED PRIOR TO INSTALLATION.SDR DALA2016032502299Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS 596-617 AND RBL 54 - 60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-13, 51-10-3 PAR 14 AND 21, 51-30-2, 51-30-5.SDR DALA2016032302236Floor Panel · crackedCRACK ON FLOOR PANEL BETWEEN CAPTAIN SEAT AND COLUMN AT LT COCKPIT. FLOOR PANEL WAS REPLACED IAW SRM 51-10-03, 51-10-04 ON 51-30-01.SDR DALA2016032102147Wire Harness · damagedMAINTENANCE FOUND THE EMERGENCY LIGHT AT SEAT ROW 11 INOPERATIVE. MAINTENANCE REPLACED THE SEAT HARNESS AND THE LIGHT CHECKED OK.SDR DALA2016032102139Support · crackedCRACKED NUT ON HORIZONTAL STABILIZER LONGITUDINAL TRIM ACTUATING MECHANISM UPPER SUPPORT. NUT ON HORIZONTAL STABILIZER LONGITUDINAL TRIM ACTUATING MECHANISM UPPER SUPPORT WAS REPLACED IAW AMM 27-41-1.SDR DALA2016032102138Light · inoperativeMAINTENANCE FOUND EMERGENCY LIGHT AT SEAT ROW 15 INOPERATIVE. MAINTENANCE REPLACED THE LIGHT ASSEMBLY.SDR DALA2016032102137Door Frame · corrodedCORROSION ON LOWER DOOR JAMB BEAM AT MID CARGO COMPARTMENT. PREVIOUS REPAIR SPACER WAS REPLACED IAW SRM 53-05, FIG 123A AND ERA 504344-14, REV ORIGINAL.SDR DALA2016032102134Cusp Web · crackedCRACKED WEB, BS 232 X=34-60 RT AT W1. NEW CUSP WEB WAS DRILLED, TREATED, PAINTED AND INSTALLED IAW SRM 51-10-4, 51-10-3, PAR 14/21, 51-30-1, 51-30-2, 51-30-5.SDR DALA2016032102130Door Frame · corrodedCORROSION ON PREVIOUS REPAIR LOWER DOOR JAMB BS 1154-1212 CARGO BAY. PREVIOUS REPAIR WAS REPLACED IAW SRM 53-05, FIG 123.SDR DALA2016032102129Access Panel · corrodedCORROSION ON SETTLEMENT AREA OF FUEL ACCESS PLATE NR 1409C. FUEL ACCESS PLATE NR 1409C WAS REPLACED IAW SRM 51-22-2A AND IPC 57-30-00-31A.SDR DALA2016032102128Ferrule · damagedDAMAGE FERRULES ON FLOOR PANEL. REPLACED FERRULE IAW AMM 53-20-01-201.SDR DALA2016032102125Door Frame · crackedCRACK ON UPPER CENTER DOOR JAMB AT LT FWD EMERGENCY EXIT. CRACK ON UPPER DOOR JAMB LT WAS REPAIRED IAW SRM 53-05, FIG 32.SDR DALA2016032102124Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTER SINK AT FUEL ACCESS PLATE NR 1361C. FUEL ACCESS DOOR WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032102123Floor Panel · delaminatedFLOOR PANEL DELAMINATED FROM BS 826 TO BS 1003 IN CABIN PAX. FLOOR PANEL REPLACED IAW AMM 53-02-01-201.SDR DALA2016032102122Finger Doubler · corrodedCORROSION ON FINGER DOUBLER BS 234 BETWEEN LONGERON 26 LT TO 25 LT AT FWD CARGO COMPARTMENT. DUE EXCESSIVE CORROSION SECTION FINGER DOUBLER WAS REPAIRED IAW SRM 53-04, FIG 12E.SDR DALA2016040402523Structure · crackedLT MLG W/W DOOR IS CRACKED AT INBD FWD CORNER. REPLACED DOOR.SDR DALA2016040402510Structure · crackedLT MLG W/W DOOR IS CRACKED AT INBD FWD CORNER. REPLACED DOOR.SDR DALA2016032002146Skin · dentedSEVERAL DENTS OUTER SKIN BETWEEN BEAM 2 AND 5 AT AFT CARGO COMPARTMENT DOOR. DENTS WERE ATTENDED IAW ETI-88-16-115, ERA 543210-14, REV ORIGINAL. PERFORM A GVI OF THE DAMAGED AREAS WITHIN EVERY 3, 800 FLIGHT CYCLES. AFTER SECTION I ACCOMPLISHED OF ERA 543210-1SDR DALA2016032102140Bracket · damagedDAMAGE ON LT OTBD BEARING BRACKET JUST IN BEARING AREA AT ELEVATOR MECHANISM. LT OTBD BEARING BRACKET WAS REPLACED IAW AIPC 27-30-00 AND WILL BE INSTALLED UNDER JIC A/C 0994, CARD 2730-4234.SDR DALA2016032102132Skin · corrodedCORROSION ON RT HEATER BLANKET SKIN AROUND ACCESS PLATE 1410C. RT HEATER BLANKET SKIN WAS REPAIRED WITH ER/A 543147-14AD, REV ORIGINAL.SDR DALA2016032002121Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G AT W1. FLOOR PANEL WAS REPLACED IAW SRM 51-30-2, 51-10-2 AND 51-10-3, PAR 14, 21, 38 AND DWG: 9957828. REV "Y".SDR DALA2016032002120Access Panel · corrodedCORROSION AT FUEL ACCESS PANEL 1454C ON COUNTERSINK . CORROSION ON COUNTERSINK WAS REMOVED, 2 HOLES NO ADJACENT OUT OF LIMITS, HOLES AND COUNTERSINK OUT OF LIMITS WERE REWORKED AND REPAIRED IAW SRM 51-22-2A, CONDITION II. AREA REWORKED WERE TREATED IAW SRM 5SDR DALA2016032002119Access Panel · corrodedCORROSION AT FUEL ACCESS PANEL 1460C ON COUNTERSINK. CORROSION ON COUNTERSINK WAS REMOVED 3 HOLES ON ADJACENT OUT OF LIMITS, HOLES AND COUNTERSINK OUT OF LIMITS WERE REWORKED AND REPAIRED IAW SRM 51-22-2A, CONDITION II, AREA REWORKED WERE TREATED IAW SRM 5SDR DALA2016032002118Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINKS ON FUEL PANEL ACCESS NR 1377C, LT WING. CORROSION ON SETTLEMENT AREA AND COUNTERSINKS WAS REMOVED, 3 HOLES NO ADJACENT OUT OF LIMITS, HOLES AND COUNTERSINK OUT OF LIMITS WERE REWORKED AND REPAIRED IAW SRM 51-22-2ASDR DALA2016032002117Access Panel · corrodedCORROSION ON COUNTERSINK FUEL PANEL ACCESS NR 1478C, RT WING. CORROSION ON COUNTERSINK WAS REMOVED 3 HOLES NO ADJACENT OUT OF LIMITS, HOLES AND COUNTERSINK OUT OF LIMITS WERE REWORKED AND REPAIRED IAW SRM 51-22-2A CONDITION II. AREA REWORKED WERE TREATED IAWSDR DALA2016032002114Support Fitting · corrodedCORROSION ON RT HORIZONTAL STABILIZER SUPPORT FITTINGS BORES AT VERTICAL REAR SPAR. BORES AT VERTICAL REAR SPAR WERE REPAIRED, REAMED WITH FINAL DIMENTION OF REWORK: ID= 1.436" THEREFORE WITHIN LIMITS OF REWORK AND REPAIR BUSHINGS WERE FABRICATED AND INSTALLESDR DALA2016032002113Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 1234 BETWEEN X=-54 TO X=-60 AT PAX CABIN. CUSP WEB WAS REPAIRED IAW SRM 51-30-2, 51-30-5, 53-05, FIG 131A-7 AND 51-10-3, PAR 21 AND 14.SDR DALA2016032002112Frame · crackedCRACKED LOWER CAP BS 1463, CANT 11 HRS POSITION AT AFT ACCESORIES COMPARTMENT. LOWER CAP WAS REPAIRED IAW ETI-88-16-059, REV 7 AND ER/A 543145-14, REV ORIGINAL. SECTION I.SDR DALA2016032002111Cusp Web · corrodedCORROSION ON CUSP WEB FROM BS 503 TO BS 579 BETWEEN X=-60 TO X=-54 AT RT FLOOR CABIN. REASON FOR RE-WRITE: TOOL MARKS RT CUSP WEB BS 538, X=-60. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-9.SDR DALA2016032002110Cusp Web · corrodedCORROSION ON LT CUSP WEB ON BS 529 BETWEEN X=57 TO X=60 AT PAX CABIN. CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-9.SDR DALA2016032002109Spar Cap · crackedCRACKED VERTICAL STABILIZER SPAR CAP ON WEB BS 1463 CANT POS 11 HRS AT AFT ACCESSORIES COMPARTMENT. VERTICAL STABILIZER SPAR CAP WAS REPAIRED IAW ER/A 543145-14 REV ORIGINAL SECTION I AND ETI-88-16-059, REV 7, TEMPORARY REPAIR. THIS REPAIR WILL BE MONITORINSDR DALA2016032002108Strap · crackedCRACKED STRAP ON BEAM NR 6 AT L1 DOOR. STRAP ON BEAM NR 6 AT WAS REPLACE IAW SRM 51-30-2, 51-10-3 PAR 14 AND 21, AND 51-10-4.SDR DALA2016032002107Intercostal · crackedCRACKED INTERCOSTAL BETWEEN BEAMS 4-5 AT L1 DOOR. INTERCOSTAL BETWEEN BEAM 4-5 L1 DOOR WAS REPLASE IAW SRM 51-30-2, 51-10-3 PAR. 14 AND 21, 51-10-4 AND DWG: 9955763, REV: M.SDR DALA2016032002106Structure · brokenBROKEN LOWER SECTION OF RUDDER L/E. LOWER SECTION OF RUDDER L/E WAS REPAIRED IAW SRM 51-70-01AD PAR 3.SDR DALA2016032002105Skin · damagedEXPOSED METALLIZED AND DAMAGED PAINT ON RT AND LT SKINS OF RUDDER. METALLIZED AND DAMAGED PAINT ON RT AND LT SKIN OF RUDDER WAS REPAIRED IAW ER/A 092613-14MA, REV A.SDR DALA2016032002104Frame · crackedCRACKED FRAME ANGLE BS 1437 BETWEEN LONGERONS 3L - 3R. THE FRAME ANGLE WAS REPAIRED IAW ETI-88-16-113, REV 1 AND ER/A 543208-14, REVISION ORIGINAL.SDR DALA2016032002103Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1436C AT RT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002102Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1355C AT LT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002101Access Panel · corrodedCORROSION ON COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1307C AT LT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002100Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1371C AT LT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002099Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1373C AT LT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002098Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1377C AT LT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002097Access Panel · corrodedCORROSION ON SETTLEMENT AREA AND COUNTERSINK HOLES OF FUEL ACCESS PLATE NR 1466C AT RT WING. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016032002096Skin · dentedDENT FWD EDGE BETWEEN BEAM 1 AND 3 OUTER SKIN AT AFT CARGO COMPARTMENT DOOR. DENTS WERE ATTENDED IAW ETI-88-16-115, ERA 543210-14, REV ORIGINAL.SDR DALA2016032102142Connector · damagedFWD LAV WATER HEATER CONNECTOR P1-385 HEAT DAMAGE. REPLACED P1-385 IAW SWPM CH20 AND R & R WATER HEATER AMM 38-11, OPS AND LEAK CK GOOD.SDR DALA2016032102141Battery Pack · inoperativeFOUND THE LT AND RT AFT EMERGENCY OVERWING EXIT LIGHTS INOPERATIVE. REPLACED THE BATTERY PACK FOR THE EXIT LIGHTS. THE LIGHTS CHECKED OK.
Back to Mcdonnell Douglas MD-88