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 DALA2015060503609Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THE AFT OVERWING EMERGENCY EXIT LIGHT TO BE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE OPS CHECK WAS GOOD.SDR DALA2015060403597Wire · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 14D IN THE CABIN WAS INOPERATIVE. MAINTENANCE FOUND WIRES DAMAGED IN THE UNDERSEAT HARNESS. THE WIRE HARNESS WAS REPAIRED AND THE SYS RETURNED TO NORMAL OPERATION. LP 6717398.SDR DALA2016111008547Doubler · corrodedCORROSION ON DOUBLER BS 826 - 845, X -54 TO X -60. REMOVED CORROSION IAW 51-10-3 PAR 26, AND A NEW DOUBLER FABRICATED IAW 51-10-2, DRAWING PL9910151.SDR DALA2016111008546Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 1022 - 1041, X 54 TO X 60. THE CUSP WEB WAS REPAIRED IAW SRM 51-10-3 PAR 14, 21, 51-30-2, 53-05 FIG 131A-7, 51-30-1, 51-30-3 PAR 38.SDR DALA2016111008545Seat Track · corrodedCORROSION ON LT SEAT TRACK X 22, BS 1231 - 1235. THE SEAT TRACK WAS REPLACED IAW SRM 53-05, 51- 10-4, 51-30-1, 51-30-5, AND 51-10-3 PAR 14 AND 21.SDR DALA2016111008544Intercostal · corrodedSURFACE CORROSION ON INTERCOSTAL, LONGERON 29L, BS 1136 - 1155. THE INTERCOSTAL WAS REPLACED IAW SRM 53-14-3 TYPE E2 FIG 3A AND 51-10-2.SDR DALA2016111008543Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 1090 - 1098, X 54 TO X 60. REPAIRED IAW SRM 51-30-5 AND 51-30-2SDR DALA2015060503608Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THE AFT OVERWIND EMERGENCY EXIT LIGHTS TO BE INOPERATIVE. MAINTENANCE REPLACED THE BATTERY PACK AND THE OPS CHECK WAS GOOD.SDR DALA2015060303607Skin · damagedDURING REMOVAL OF THE RT TDG NO FOD HEATER BLANKET, THE NR 10 FASTENER HOLE IAW TDG DWG 3093, LOCATED AT XCW=116.6 APPROXIMATELY ON THE T/E WAS FOUND EXCESSIVELY COUNTERSUNK AND ELONGATED THRU THE UPPER WING SKIN PN 5930502-118. AREA WAS REPAIRED IAW ER/A 534SDR DALA2016111008542Access Panel · corrodedCORRODED COUNTERSINKS ON THE FUEL ACCESS PANEL 1478C FOR RT WING. THE CORROSION WAS REMOVED IAW SRM 51-10-3 AND FOUND OUT OF LIMITS IAW SRM 51-22-2A. THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008541Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1454C ON RT WING. THE CORROSION WAS REMOVED IAW SRM 51-103 AND FOUND OUT OF LIMITS IAW SRM 51-22-2A. THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008540Cusp Web · corrodedCORROSION ON LT CUSP WEB, BS 890 - 1008, X 54 TO X 60. THE AREA WAS REPAIRED IAW SRM 53-05 FIG. 131A-21 FIG. 131A-10 AND SRM 51-10-3 PAR 14, 21, 38, AND SRM 51-30-2.SDR DALA2016111008539Cusp Web · corrodedREPAIR DOUBLER CORRODED ON THE RT CUSP WEB, X 54 TO X 60, BS 455 - 461. REPAIRED IAW SRM 51-30-5, 51-30-1, 51-30-2, 53-05 FIG 131A-14, 51-10-3 PAR 21, 14, AND SRM 51-30-2, 51-30-5, 51-30-1.SDR DALA2016111008538Cusp Web · corrodedCORROSION ON THE LT CUSP WEB X 55 TO X 60, BS 581 - 596. REPAIRED IAW SRM 53-05 FIG 131-A-7, 51-10-3 PAR 14, 21, AND 38, 51-30-2, AND 51-30-5.SDR DALA2015061103669Compressor · stalledFLIGHT RETURNED TO DEPARTURE FOLLOWING A COMPRESSOR STALL AND RESULTING HIGH EGT IN THE NR 2 ENGINE. THE CREW SHUTDOWN THE NR 2 ENGINE AND LANDED UNEVENTFULLY ON 1 ENGINE. MAINTENANCE HAS REPLACED THE ENGINE.SDR WX0A2015060372638Unknown · odorJUST BEFORE DESCENT INTO PIE 3 OF 4 FLIGHT ATTENDANTS CLAIM THEY FELT DIZZY & BECAME NAUSEOUS. COMPLAINED OF SMELLS LIKE GUNPOWDER & A MECHANIC SHOP AROUND ROW 6, NO PAX COMPLAINED. INSPECTED O2 GEN THRU ROW 10 LT & RT WITH NO DEFECTS NOTED. INSPECTED PRIMASDR DALA2016111008537Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 912 - 940, X -54 AND X -60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131 A.SDR DALA2016111008536Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR OF THE CUSP WEB, BS 1142, X 54 AND X 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-1, SRM 51-10-3 PAR 21, 14, AND SRM 51-30-2.SDR DALA2016111008535Cusp Web · corrodedCORROSION ON LT CUSP WEB X 54 TO X 60, BS 766 - 764. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-13, 51-10-3 PAR 21, 38, 14, AND 51-30-05.SDR DALA2016111008522Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 850, X -54 AND X -60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-13.SDR DALA2016111008521Seat Track · corrodedCORROSION ON LT SEAT TRACK X 22 BS 934 - 937. REPAIRED IAW SRM 53-05 FIG 4A SHEET 1, SRM 51-10-3 PAR 14-21, AND SRM 51-10-4.SDR DALA2016111008519Cusp Web · corrodedCORRODED REPAIR ON CUSP WEB BS 769 - 788, X -54 TO X -60. THE REPAIR WAS REPLACED IAW SRM 51-30-2 AND 53-05 FIGURE 131A.SDR DALA2016111008518Cusp Web · corrodedCORROSION OUT LIMITS ON CUSP WEB BS 1062 TO 1066 AND X 56 TO X 60. DAMAGE WAS REMOVED AND A REPAIR WAS FABRICATED IAW SRM 53-05 FIG. 131A-13, 51-30-2, 51-10-3 PAR. 21 AND 14.SDR DALA2015060103595Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT SIGN FOR THE FWD OVERWING EXIT WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERIES. OPS CHECKED GOOD.SDR DALA2016111008517Cusp Web · corrodedCORROSION OUT OF LIMITS ON THE RT CUSP WEB BS 1261-1264, X -54 AND X -60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-13.SDR DALA2016111008516Cusp Web · corrodedCORROSION ON RT CUSP WEB, X -54 TO X -60, BS 655 - 674. THE AREA WAS REPAIRED IAW SRM 53-05 FIG 131A-1 SHEET, 51-10-3 PAR 14, 21, 51-30-2, AND 51-30-8.SDR DALA2015060103596Connector · damagedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY LIGHTING AT SEAT 3D IN THE CABIN WAS INOPERATIVE. MAINTENANCE REINSTALLED A PULLED PIN IN THE CONNECTOR AND THE LIGHTS RETURNED TO AN OPERATIONAL CONDITION. LP 7068108.SDR WX0A2015060172623Switch · looseLEVEL AT FL330, RECEIVED THE, LAV SMOKE, ANNUNCIATOR & CHIME. FLIGHT ATTENDANT`S SEARCHED LAV & REPORTED NO SMOKE OR FIRE. WE RAN QRH 26.9, THE FLIGHT ATTENDANT`S THEN REPORTED A LOOSE LAV FLUSH MOTOR SWITCH. PULLED THE TWO BREAKERS IN THE LAV IN THE QRH THSDR DALA2016111008515Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1355C ON THE LT WING. THE CORROSION WAS REMOVED IAW SRM 51-22-2A AND FOUND OUT OF LIMITS. THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008514Cusp Web · corrodedCORROSION OUT OF LIMITS ON CUSP WEB BS 1223 TO 1228, X -54 AND X -60. THE DAMAGE WAS REMOVED AND A REPAIR FABRICATED IAW SRM 53-05 FIG-131A -3. THE REPAIR WAS INSTALLED IAW SRM 51-30-5.SDR DALA2016111008513Cusp Web · corrodedCORROSION ON LT CUSP WEB BS 545 BETWEEN X 54 TO X 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-13, 53-30-5, AND 51-10-3 PAR. 21 AND 14.SDR DALA2016111008512Access Panel · corrodedCORROSION ON COUNTERSINK OF ACCESS PANEL1436C ON THE RT WING. THE CORROSION WAS REMOVED IAW SRM 51-10-3 AND FOUND OUT OF LIMITS IAW SRM 51-22-2A. THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008511Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1357C ON LT WING. THE CORROSION WAS REMOVED IAW SRM 51-10-3 AND FOUND OUT OF LIMITS IAW SRM 51-22-2A AND THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008510Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PANEL 1363C ON LT WING. CORROSION WAS REMOVED IAW SRM 51-10-3 AND FOUND OUT OF LIMITS IAW SRM 51-22-2A AND THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008509Access Panel · corrodedCORROSION ON COUNTERSINKS OF FUEL ACCESS PANEL 1464C ON THE RT WING. THE CORROSION WAS REMOVED IAW SRM 51-10-3 AND FOUND OUT OF LIMITS IAW SRM 51-22-2A. THE ACCESS PANEL WAS REPLACED.SDR DALA2016111008507Cusp Web · corrodedCORROSION ON THE LT CUSP WEB X 55 TO X 60 FROM BS 562 - 578. INSTALLED A REPAIR IAW SRM 51-30-1, SRM 51-30-2, SRM 53-05 FIG 131A-14 SHEET 1, SRM 51-10-3 PAR 21-14-38SDR DALA2016111008506Cargo Track · corrodedCORROSION WAS FOUND ON THE LT CARGO TRACK BS 1220 - 1322. THE CARGO TRACK WAS REPLACED IAW SRM 51-10-4, 51-30-1, AND DWG 5936660SDR DALA2016111008505Longeron Splice · corrodedCORROSION ON LONGERON SPLICE 25R BETWEEN BS 1136 AND 1155. THE LONGERON SPLICE WAS REPLACED IAW SRM 51-10-4, 51-30-5, AND 51-10-3 PAR. 14, 21, AND 38.SDR DALA2015060203594Skin · damagedDAMAGED METALLYZED ON RT SIDE BETWEEN LOWER EDGE TO ZR 32, ZR 42- ZR 93 AND ZR 108- ZR 159 ALSO LT SIDE BETWEEN ZR 45-ZR 52 AND ZR 104-ZR 108 AT RUDDER, CARD 47, ZONE 65, METALLIZED ON RT SIDE AND LT WERE REPAIRED IAW SRM 51-70-1A, PARR 23 AND OPN 1031, A/C 09SDR DALA2015053003593Frame · crackedCRACK ON FRAME BS 427 BETWEEN LONGERONS 24 - 25R. DAMAGE WAS REMOVED IAW AND REPAIR FABRICATED, TREATED, PAINTED, AND INSTALLED IAW ER/A 534376-14 REV ORIGINAL.SDR DALA2015053003574Service Panel · corrodedAFT LAV SERVICE PANEL WITH CORROSION PILLOWING, LOWER AFT EDGE. REPAIRED IAW PRI 536216-14, REV 1 AND C/W ER/A 536216-14, REV ORIGINAL.SDR DALA2016111008503Cusp Web · damagedCUSP WEB BETWEEN BS 1199 AND 1206 X -54 TO X -60 DAMAGED. THE DAMAGE WAS REMOVED IAW SRM 53-05 FIG 131A-1 AND A REPAIR WAS FABRICATED, TREATED, AND PAINTED IAW SRM 51-10-3 PAR-21 AND 14, AND INSTALLED IAW SRM 51-30-5.SDR DALA2016111008502Cusp Web · corrodedCORROSION ON RT CUSP WEB BS 564 BETWEEN X -54 TO X -60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-13.SDR DALA2016111008501Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G. THE FLOOR PANEL WAS REPLACED IAW SRM 51-30-2; 51-30-5, 51-10-3 PAR 14, 21, AND DWG 9957828 REV AB.SDR DALA2016111008499Frame · corrodedCORROSION ON REPAIR SPLICE OF FRAME AT BS 1307 BETWEEN LONGERONS 29L TO 29R. REPAIRED THE FRAME IAW SRM 53-03 D FIG 2A.SDR DALA2016111008498Frame · corrodedCORROSION ON FRAME BS 1322 LONGERON 29L. THE FRAME WAS REPAIRED IAW SRM 53-03D FIG 2.A SHEET 3.SDR DALA2015060103557Battery Pack · inoperativeDURING LINE CHECK, MAINTENANCE FOUND THE EMERGENCY CEILING LIGHTS INOPERATIVE AT ROW 34. MAINTENANCE INSTALLED NEW BATTERIES AND THE OPS CHECKED GOOD.SDR DALA2015060103556Connector · damagedDURING LINE CHECK, MAINTENANCE FOUND THE EMERGENCY LIGHTS INOPERATIVE AT SEAT ROWS 16 RT, 01 RT AND 31 RT. MAINTENANCE REPINNED THE CONNECTORS AND THE OPS CHECK WAS GOOD. LP 7002245.SDR DALA2015052803555Door Frame · corrodedSEVERE CORROSION ON OUTER SURFACE OF DOOR FRAME FROM BS 370-427 AND LONGERON 28R. DOOR FRAME SECTION WAS REMOVED AND NEW SECTION INSTALLED IAW SRM 53-05, FIG 44A.SDR DALA2016111008497Frame · corrodedCORROSION ON FRAME BS 1380 BETWEEN LONGERONS 24R TO 24L. THE FRAME WAS REPLACED IAW DWG 9912246 REV. DE, SRM 51-30-2, 51-30-5, 51-10-4, AND 51-10-3.
Back to Mcdonnell Douglas MD-88