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 DALA2017020601005Doubler · wornRIGHT WING, WEAR ON REPAIR DOUBLER AT FIXED LEADING EDGE AT XCW=121 . DOUBLER REPAIR WAS REPLACED IAW SRM 51-30-2,51-30-5 AND 57-06B PAR. 27 FIG.29 SHEET 2.SDR DALA2017020601001Floor Panel · wornWEAR ON FLOOR PANEL 886C CHANNEL. REPLACED IAW DWG 9936639 REV. P.SDR DALA2017020601000Floor Support · crackedCRACKS FOUND ON THE FLOOR SUPPORT BETWEEN BS 1287 - 1307 BL 0. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-2 AND 51-30-5.SDR DALA2017020600999Structure · crackedAFT CARGO DOOR CRACKED ON PREVIOUS DOUBLER REPAIR. THE REPAIR WAS REPLACED IAW SRM 52-03D, FIG 8.SDR DALA2017020600998Skin · corrodedCORROSION ON UPPER SKIN BELOW STATIC DISCHARGE BASE AT LT AILERON . THE SKIN WAS REPAIRED IAW SRM 51-70-1A, PAR. 12.SDR DALA2017020600997Bulkhead · damagedRIGHT AFT PRESSURE BULKHEAD LOWER SHEAR ANGLE DAMAGED. REPAIRED IAW ERA 554877-14 REV ORIG.SDR DALA2017020600996Bulkhead · damagedLEFT AFT PRESSURE BULKHEAD LOWER SHEAR ANGLE DAMAGED. REPAIRED IAW PRI 554877-14 REV 0 AND COMPLIED WITH ERA 554877-14 REV ORIG.SDR DALA2017020500995Wire · brokenSEAT 30 DE SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. FOUND WIRE BROKEN AT CONTACT PIN IN CONNECTOR. TERMINATED THE WIRE IAW SWPM 20-90-03. CHECKED GOOD.SDR DALA2017020500994Cusp Web · crackedCRACKED CUSP WEB BETWEEN BS 1206 - 1210 LBL 54 - 60. THE DAMAGED AREA WAS REPAIRED IAW 53-05, FIG 131-A.SDR DALA2017020500993Cusp Web · crackedCRACKED ON RT CUSP WEB FROM BS 1287 - 1308 AND RBL 44 - 60. DAMAGE AREA WAS REPAIRED IAW SRM 53-05 FIG 131A.SDR DALA2017020500992Angle · crackedAFT ACCESORIES BAY HAD A CRACKED ANGLE ON BS 1418 BETWEEN LONGERON 1 & 2R. THE ANGLE WAS REPLACED IAW SRM. 53-14-4 FIG. 1 (SHEET 1), 51-30-5, AND 51-10-3 PAR. 21, 14 AND 38.SDR DALA2017020500988Frame · crackedFRAME BS 1437 FWD SIDE HAS A 2 INCH LONG CRACK THRU THREE FASTENER HOLES, RBL 7. REPAIRED IAW PRI 554290-14 REVISIONS 1, 2, AND 3 AND COMPLY WITH ERA 554290-14 REVISION ORIGINAL.SDR DALA2017020500987Frame · crackedFRAME BS 1437, FWD SIDE HAS A 2 INCH LONG CRACK, LBL 7. REPAIRED IAW PRI 554290-14, REVISIONS 1, 2, AND 3 AND COMPLIED WITH ERA 554290-14 REVISION ORIGINAL.SDR DALA2017020500984Floor Panel · delaminatedFLOOR PANEL FOUND DELAMINATED. REPLACED THE FLOOR PANEL IAW AMM 53-20-01-201.SDR DALA2017020400982Floor Support · corrodedFWD WET AREA HAS CORROSION THAT IS OUT OF LIMITS ON FLOOR SUPORT, BS 160 - 200, LBL 54. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-30-2, 51-30-5, AND 51-10-3, PAR 21, AND 14.SDR DALA2017020400981Access Panel · corrodedCORROSION ON FUEL TANK ACCESS PANEL 1303C AND 1335C. THE FUEL ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A, PAR. 6, CONDITION II.SDR DALA2017020400953Fitting · crackedCRACK ON CLIP UPPER FWD CORNER BEAM 6 AT AFT CARGO DOOR C3. CLIP WAS REPLACED PER SRM 51-30-5 AND DWG 3934011 REV D.SDR DALA2017020400952Beam · crackedL1 DOOR, CRACKED BEAM NR 8 AFT END. BEAM NR 8 WAS REPAIRED PER SRM 52-05 PAR 83 FIG 111.SDR DALA2017020400951Floor Support · crackedFWD WET AREA, CRACK ON FLOOR SUPPORT STA Y=237 BTW X=44LH TO X=RH44. SUPPORT WAS REPLACED PER SRM 53-14-2 FIG 4A.SDR DALA2017020400950Shear Tie · crackedTAIL INTERIOR, CROWN SHEAR TIE HAS 2 CRACKS, BS 1437, RBL 8. REPAIR PER DWG 9953016.SDR DALA2017020400949Skin · crackedLEFT WING, CRACKED SKIN ON LT SLAT PANEL NR 2 AT STA XOS=240. REPAIRED PER SRM 57-01 FIG 3 (SHEET 2).SDR DALA2017020300906Bulb · inoperativeMULTIPLE EMERGENCY CEILING BULBS ARE OUT. REPLACED THE BULBS.SDR DALA2017020400983Floor Support · corrodedFWD WET AREA HAS CORROSION ON THE FLOOR SUPPORT BS 200 LBL 54. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-30-5, DWG 9910078, REV JC, AND SRM 51-10-2,SDR DALA2017020300904Frame · crackedLEFT WING MAIN FRAME STRINGER 11 AT XRS 160 CRACKED 2.5 INCHES. REPAIRED IAW SR09570100 REV. B.SDR DALA2017020300903Pan · crackedL1 DOOR PAN CRACKED BETWEEN TOP AND BEAM NR 1. THE PAN WAS REPAIRED IAW SRM 52-05 PAR 14 FIG 18A.SDR DALA2017020300902Door Frame · corrodedCORROSION ON LOWER DOOR FRAME BS 1155 - 1212 IN THE AFT CARGO. REPAIRED IAW SRM 53-05 FIG.123 SHEET 2, 51-10-3 PAR 14,21,26,38 AND 51-30-4.SDR DALA2017020300901Floor Support · corrodedCORROSION WAS FOUND ON THE FLOOR SUPPORT BS 200 LBL 54. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-30-5, DWG 9910078 REV JC, AND SRM 51-10-2.SDR DALA2017020300900Floor Support · corrodedCORROSION ON FLOOR SUPPORT BS 200 LBL 54. THE FLOOR SUPPORT WAS REMOVED IAW SRM 51-30-5. A NEW FLOOR SUPPORT WAS FABRICATED IAW DWG 9910078 REV JC AND SRM 51-10-2. THE FLOOR SUPPORT WAS INSTALLED IAW SRM 51-30-5.SDR DALA2017020300899Skin · nickedNICK ON FWD LWR EDGE LT WINDOW BELT. THE NICKS BS 658 - 714 WERE BLENDED AND FOUND WITHIN LIMITS IAW SRM 53-05, FIGURE 111, 51-10-3 PARAGRAPH 21 AND ERA 554135-14 REV. ORIGINAL.SDR DALA2017020300898Skin · nickedNICK ON FWD LOWER EDGE LT WINDOW BELT IAW ER/A 554127-14 REV,ORIG. THE NICKS WERE BLENDED AND FOUND WITHIN LIMITS IAW SRM 53-05, FIGURE 111, 51-10-3 PARAGRAPH 21, AND ER/A. 554136-14 REV. ORIGINAL,SDR DALA2017020300897Longeron · crackedCRACKED LONGERON 4R, BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG. 18.SDR DALA2017020300894Longeron · crackedCRACKED LONGERON 4L, BS 1437. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG.18, 51-10-3 PAR 14,21, 51-10-4, 51-30-2, AND 51-30-5.SDR DALA2017020300893Seat Track · wornWEAR ON SEAT TRACK RBL 44, BS 200 - 247. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05, FIG 4F.SDR DALA2017020300892Door Frame · corrodedCORROSION ON LOWER CARGO DOOR FRAME FROM BS 1155 - 1211. THE DOOR FRAME WAS REPAIRED IAW SRM 53-05, PARAGRAPH 140, FIGURE 123.SDR DALA2017020300890Door Frame · corrodedAFT CARGO BAY HAD CORROSION ON THE LOWER DOOR FRAME FROM BS 1155 - 1212. REPAIRED IAW SRM 53-05 FIG.123 SHEET 2, 51-10-3 PAR 14,21,26,38, AND 51-30-4.SDR DALA2017020300889Pan · crackedCRACK ON UPPER PAN AT THE LT FWD OVERWING EMERGENCY EXIT DOOR. THE PAN WAS REPAIRED IAW SRM 52-05 FIG. 51.SDR DALA2017020300888Seat Track · out of limitsSEAT TRACK RBL 22, BS 1065 - 1067 OUT OF LIMITS. THE SEAT TRACK WAS REPAIRED IAW SRM 53-04 FIG 4A.SDR DALA2017020300887Door Frame · corrodedCORROSION ON APU RIGHT DOOR FRAME. DAMAGE AREA WAS REPAIRED IAW SRM 52-05 FIG.10.SDR DALA2017020300886Spacer · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER OF LOWER DOOR FRAME BEAM. SPACER WAS REPLACED IAW SRM 53-05 FIG. 123.SDR DALA2017020300885Cusp Web · corrodedCRACKED ON RT CUSP WEB FROM BS 905 - 927, RBL 44 - 60. REPAIRED IAW SRM 53-05 FIG. 131 A-1.SDR DALA2017020300884Cusp Web · corrodedCORROSION ON RT CUSP WEB, BS 633 - 640, RBL 54 - 60 UPPER AND LOWER SURFACE. REPAIRED IAW SRM 53-05 FIG 131 A-11.SDR DALA2017020300883Longeron · crackedAFT ACCESORIES COMPARTMENT HAD A CRACKED LONGERON 2R, BS 1418. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18.SDR DALA2017020300881Skin · crackedTAIL SKIN HAS A CRACK BETWEEN TWO RIVETS AT BS 1437, LONGERON 4 & 5L. REPAIRED IAW PRI 554872-14 REV 0RIGINAL AND COMPLIED WITH ERA 554872-14 REV ORIGINAL.SDR DALA2017020300880Vane · corrodedRIGHT WING CORRODED ON LOWER SURFACE INBD SIDE AT RT OTBD FLAP OTBD VANE. THE VANE WAS REPLACED .SDR DALA2017020300879Longeron · crackedAFT ACCESORIES COMPARTMENT, CRACKED LONGERON 2L, BS 1418. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG 18.SDR DALA2017020200872Lanyard · brokenPAX CABIN, MISSING LOCK PIN AND BROKEN RELEASE LANYARD WIRE AT FWD SERVICE DOOR EVACUATION SLIDE. LOCK PIN WAS INSTALLED AND LANYARD WIRE WAS REPLACED AT FWD SERVICE DOOR EVACUATION SLIDE IN REFERENCE AMM 25-62-00.SDR DALA2017020200871Web · corrodedCORROSION ON WEB STA Y =1212- 1218 BTW LONG 26R. WEB WAS REPAIRED PER SRM 53-01 FIG 4 SHEET 4.SDR DALA2017020200908Seat · detachedROW 13ABC SEATS CAME DETACHED AT THE FLOOR ON THE FRONT. ENTIRE ROW TIPPED BACK ON TAKEOFF. ADJUSTED AND SECURED SEAT ROW IAW AMM 25-23. ALL OPS NORMAL.SDR DALA2017020200878Fan · failedFLT LEVEL 340, FLIGHT ATTENDANT REPORTED ELECTRICAL SMELL WITH A HAZE IN THE CABIN. AFTER THE SMELL REACHED THE COCKPIT, ELECTRICAL, WE DIVERTED TO CAE. FOUND RECIRC FAN BAD. FWD TO MEL 21-00-43 AND PLA. C/W (M) PROCEDURES.SDR DALA2017020200877Cargo Track · corrodedAFT CARGO COMPARTMENT, CORROSION ON RT TIE TRACK FROM Y=1003 TO Y=1155, Y=1212 TO Y=1322. DUE TO EXCESIVE CORROSION WERE REPLACE TIE TRACKS. NEWS TIE TRACKS WERE DRILLED PER SRM. 51-10-4. NEWS TIE TRACK RT Y=1212 TO Y=1322 AND TIE TRACK RT Y=1103 TO Y=1155 WER
Back to Mcdonnell Douglas MD-88