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 DALA2016030101555Cusp Web · crackedCRACKED RT CUSP WEB BS 224 BETWEEN X=-54 TO -60 AT PAX CABIN FLOOR STRUCTURE. CRACKED WAS ATTENDED IAW SRM 51-30-2, 53-05 131A-13, 51-10-3 PAR 14, 21, 38.SDR DALA2016030101554Seat Track · corrodedCORROSION OUT LIMITS ON RT SEAT TRACK BS X=-54, BS 416 AND 528 AT PAX CABIN. DAMAGE AREA WAS REMOVED IAW SRM 53-05, FIG 4A AND ER/A 485415-14MA. NEW HOLES OF REPAIRS WERE DRILLED IAW SRM 53-05, FIG 4A AREA AND NEW HOLES WERE TREATED AND PAINTED IAW SRM 51-10SDR DALA2016030101553Pan · crackedCRACK ON DOOR PAN INNER STRUCTURE AT FWD UPPER SIDE AND BEAM NR 5 OF FWD CARGO COMPARTMENT DOOR. INNER PAN WAS REPAIRED IAW SRM 52-03, FIG 8.SDR DALA2016030101552Floor Panel · crackedCRACK ON CHANNEL AT FLOOR PANEL 541A IN PASSENGER CABIN. FLOOR PANEL REPAIRED IAW SRM 53-05, FIG 131B, HFEC INSPECTION WAS PERFORMED AND NO CRACKS INDICATION WERE FOUND AFT STOP DRILL.SDR DALA2016030101551Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G AT PAX CABIN. FLOOR PANEL WAS REPLACED IAW SRM 51-10-3 PAR 14 AND 21 51-30-2 AND DWG 9957828, REV AB.SDR DALA2016030101550Door Frame · crackedCRACKED PREVIOUS REPAIR ON L1 AFT DOOR JAMB BS 207, LONG, 15LT. DAMAGE WAS REPAIRED IAW SRM 53-05, FIG 142, 51-30-5.SDR DALA2016030101549Pan · crackedCRACKED LT RING PAN ON LOWER, AFT CORNER BETWEEN BS 712 - 1022 AT PAX CABIN. DAMAGE WERE REMOVED AND REPAIR PARTS WERE FABRICATED TREATED AND PAINTED AND WERE INSTALLED IAW SRM 53-05, FIG 122.SDR DALA2016030101548Pan · crackedCRACKED LT RING PAN ON UPPER/AFT CORNER BETWEEN BS 1250/1231 AT PAX CABIN. DAMAGE WAS REMOVED AND REPAIR PARTS WERE FABRICATED, TREATED AND PAINTED AND WERE INSTALLED IAW SRM 53-05, FIG 122.SDR DALA2016030101547Pan · crackedCRACKED LT RING PAN ON UPPER/FWD CORNER BETWEEN BS 731 - 965 IN PAX CABIN. DAMAGE WERE REMOVED AND REPAIR PARTS WERE FABICATED TREATED AND PAINTED AND WERE INSTALLED IAW SRM 53-05, FIG 122.SDR DALA2016030101546Floor Panel · puncturedPUNCTURED 120B FLOOR PANEL UPPER SURFACE. DAMAGE WAS REPAIRED IAW SRM 53-01, 51-10-3, AND 51-30-2.SDR DALA2016030101545Pan · crackedCRACKED LT RING PAN ON LWR/FWD CORNER BTW BS 807-1117. DAMAGE REMOVED AND REPAIR FABRICATED TREATED AND PAINTED AND INSTALLED IAW SRM 53-05, FIG 122.SDR DALA2016030101544Floor Panel · delaminatedDELAMINATED FLOOR PANEL IN PAX CABIN. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016030101543Channel · crackedCRACKED W CHANNEL ON FLOOR PANEL 886C AT CABIN PAX. W CHANNEL ON FLOOR PANEL 886C AT CABIN PAX WAS REPLACED IAW DWG 9936639, REV P, SRM 51-30-1.SDR DALA2016030101541Floor Panel · delaminatedDELAMINATED FLOOR PANEL IN CABIN PAX. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016030101540Cusp Web · crackedCRACK ON RT CUPS WEB IN BS Y=218 X= -45, LOWERSIDE AT CABIN PAX. CUPS WEB WAS REPLACED IAW SRM 51-30-2, DWG 9930538-39, REV BW.SDR DALA2016030101542Access Panel · corrodedCORROSION ON COUNTERSINK AT WING ACCESS PLATE NR 1307C. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A.SDR DALA2016022901535Spar · not reportedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND, SEVEN DIFERENT FASTENERS OF PSE, LOWER SKIN REAR SPAR BETWEEN XRS=163 TO 168 AT LT WING. NRC IS ATTENDED WITH ER/A NR 543169-14AD, REV ORIGINAL.SDR DALA2016022901534Spar · not reportedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND, SEVEN DIFERENT FASTENERS OF PSE, LOWER SKIN REAR SPAR BETWEEN XRS=163 TO 168 AT RT WING. REPAIRED IAW ER/A NO 543169-14AD, REV ORIGINAL.SDR DALA2016022901531Cargo Track · corrodedCORROSION ON LT CARGO TRACK FROM BS 1003 - 1220 IN THE AFT CARGO BAY. THE CARGO TRACK WAS REPLACED IAW SRM 51-10-4 .SDR DALA2016022901530Sign · inoperativeMAINTENANCE FOUND THE COCKPIT DOOR EXIT SIGN ILLUMINATION OUT OF LIMITS. THE SIGN WAS REPLACED.SDR DALA2016022901529Web · puncturedPUNCTURED ON WEB BS 133 X 52 APPROXIMATELY AT COCKPIT. WEB WAS REPAIRED IAW SRM 53-01, FIG 4, SRM 51-10-3, PAR 14, 21, 38.SDR DALA2016022901528Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 731 - 750, X 54 TO X 60 AT CABIN STRUCTURE UPPER/LOWER SURFACE. CORROSION WAS ATTENDED IAW SRM 53-05, FIG 131A-7, SRM 51-30-2, 51-10-3, PAR 14, 21, 38.SDR DALA2016022901527Door Frame · crackedCRACKS ON RT/LT UPPER CORNERS OF VENTRAL STAIRWAY DOOR JAMB FRAME BS 1338 AT PAX CABIN INNER STRUCTURE. CRACK WAS REMOVED IAW 53-01, FIG 1 X=S/5, X=.650/5=.130. REWORKED AREA WAS TREATED, PAINTED IAW SRM 51-10-3, PAR 21/14.SDR DALA2016022901526Seat Track · not reportedOUT OF LIMITS SEAT TRACK BS 880 - 881, X -22. . REPAIRED IAW SRM 53-05, FIG 4A AND 51-10-3, PAR 14, 21.SDR DALA2016030401645Structure · missingFLAME SPRAY MISSING FROM CRITICAL ZONES ON RUDDER IAW SRM 55-03, PAGES 91 AND 92. R & R RUDDER IAW AMM 27-20.SDR DALA2016022801539Longeron · corrodedCORROSION ON LONG 23 LT BETWEEN BS 1287 AND 1309. DUE TO EXCESSIVE CORROSION LONGERON WAS REPAIRED IAW SRM 53-02, FIG 18.SDR DALA2016022901536Skin · damagedDAMAGED ALLUMINIZED ON RUDDER. METALLIZED ON RUDDER WAS REPAIRED IAW ER/A 092613-14MA, REV A.SDR DALA2016022901533Spar · not reportedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND SEVEN DIFFERENT FASTENERS OF THE PSE ON LT LOWER WING SKIN REAR SPAR BETWEEN BS XRS =162 TO XRS= 168. REPAIRED IAW ER/A NR 543146-14AD, REV ORIGINAL .SDR DALA2016022901532Spar · not reportedDURING NDT INSPECTION A DISCREPANT AREA WAS FOUND SEVEN DIFFERENT FASTENERS OF THE PSE ON RT LOWER WING SKIN REAR SPAR BETWEEN BS XRS= 162 TO XRS= 168.SDR DALA2016022801523Skin · crackedCRACKED FUSELAGE SKIN IN BS 535 BETWEEN LONG 18R AND 19R. REPAIRED IAW ETI-88-16-080 REV 3 AND ER/A 543170-14, REV ORIGINAL.SDR DALA2016022801517Skin · crackedCRACK ON SLAT PANEL NR 5 INNER SKIN BS XOS= 503 LT WING. DOUBLER WAS FABRICATED, TREATED AND PAINTED , INSTALLED IAW SRM 57-01, FIG 3, 51-10-3, 51-30-8.SDR DALA2016022801516Floor Support · damagedCRACKED AND WEAR ON FLOOR SUPPORT X=3 BETWEEN BS 1287 AND 1271. THE FLOOR SUPPORT WAS REPAIRED IAW SRM 53-01, FIG 2 , 51-10-3, P 14, 26, 51-30-2 AND 51-30-5.SDR DALA2016022801515Pan · crackedCRACK ON RT FWD LOWER CORNER RING PAN BS 1212-1231. FASTENERS AND DAMAGE AREA WERE REMOVED IAW SRM 51-30-2, 51-30-5 AND 53-05, FIG 122. REPAIR PARTS WERE FABRICATED IAW SRM 53-05, FIG 122. REPAIR PARTS WERE TREATED/PAINTED IAW 51-10-3 PAR 14 AND 21. REPAIRSDR DALA2016022801514Pan · crackedCRACK ON RT FWD LOWER CORNER RING PAN BS 1060-1079. FASTENERS AND DAMAGE AREA WERE REMOVED IAW SRM 51-30-2, 51-30-5 AND 53-05, FIG 122. REPAIR PARTS WERE FABRICATED IAW SRM 53-05, FIG 122. REPAIR PARTS WERE TREATED/PAINTED IAW SRM 51-10-3, PAR 14 AND 21. RESDR DALA2016022801513Cusp Web · crackedELONGATED HOLE ON RT CUSP WEB BS 1250 AND X=-49 UPPER SURFACE. FASTENERS WERE REMOVED, DAMAGE WAS REMOVED, REPAIR PART WAS FABRICATED, NEW REPAIR PART WAS TREATED, PAINTED AND INSTALLED. CIC WILL BE APPLIED WITH NRC 20000100381 CARD NR 20 ZONE 201 IAW SRM 53-SDR DALA2016022801512Pan · crackedCRACKED LOWER FWD CORNER OF LT RING PAN BETWEEN BS 1098 TO 1117, 1079 TO 1098 AND 1060 TO 1079 AT INTERNAL STRUCTURE CABIN. RING PAN WAS REPAIRED IAW SRM 53-05, FIG 122 AND ER/AS 493648-14MA, REV A AND 487747-14MA, REV ORIGINAL. AT BS 1098 TO 1117 AND BS 106SDR DALA2016022801511Pan · crackedCRACK ON RT FWD LOWER CORNER RING PAN BS 1174-1193. FASTENERS AND DAMAGE WERE REMOVED IAW SRM 51-30-2, 51-30-5 AND 53-05, FIG 122. REPAIR PARTS WERE FABRICATED IAW SRM 53-05, FIG 122. REPAIR PARTS WERE TREATED/PAINTED IAW SRM 51-10-3, PAR 14 AND 21. REPAIRSDR DALA2016022801510Cargo Track · corrodedCORROSION ON CARGO TRACK RT SIDE FROM BS 1003 - 1155 IN AFT CARGO COMPARTMENT. THE CARGO TRACK WAS REPLACED IAW SRM 51-10-4, SRM 51-30-1 AND DWG 5956705 REV AY.SDR DALA2016022801509Floor Panel · puncturedPUNCTURED FLOOR PANEL IN PAX CABIN. FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2016022801508Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FABRICATED IAW AMM 53-20-01-201.SDR DALA2016022701507Cusp Web · corrodedCORROSION ON LT CUPS WEB BETWEEN 655 TO 674, 674 TO 693 AND 693 TO 712, X=44 TO X=60 AT CABIN FLOOR STRUCTURE, UPPER, LOWER SURFACE. SEAT TRACK AND CUSP WEB WERE REMOVED SEAT TRACK ON BS 579- 712 CUSP WEB 598- 712 AND PARTS ON CUSP WEB , NEW CUSP WEB WAS DRILLSDR DALA2016022701506Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA OF WING ACCESS PLATE NR 1454C. ACCESS PLATE NR 1454C WAS REPLACED IAW SRM 51-22-2A, COND II.SDR DALA2016022701505Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AT WING ACCESS PLATE NR 1470C. ACCESS PLATE NR 1470C WAS REPLACED IAW SRM 51-22-2A, COND II.SDR DALA2016022701504Access Panel · corrodedCORROSION ON COUNTERSINK AND SETTLEMENT AREA AT WING ACCESS PLATE NR 1410C. FOUND TO BE OUT OF LIMITS AND WAS REPLACED IAW SRM 51-02-2A, COND II.SDR DALA2016022701503Access Panel · corrodedCORROSION ON COUNTER SKIN AND SETTLEMENT OF FUEL ACCESS PLATE 1311C. ACCESS PLATE WAS REPLACED IAW SRM 51-22-2A, CONDITION II.SDR DALA2016022801525Skin · wornWEAR ON PREVIOUS REPAIR DOUBLERS AT OUTER SKIN FWD AND AFT BOTTOM CORNERS OF FWD CARGO COMPARTMENT. DAMAGE REPAIR DOUBLERS WERE REPLACED IAW ERA 486624-14MA, REV ORIGINAL.SDR DALA2016022801524Hinge · wornFREE PLAY ON FWD AND AFT HINGE AT FWD CARGO DOOR. AFT HINGE OF FWD CARGO DOOR WAS REPAIRED IAW ER/A 497387-14 AND INSTALLED IAW AMM 52-31-02. FWD HINGE WAS REPLACED AND NEW ONE WAS INSTALLED IAW AMM 52-31-02. FWD CARGO DOOR WILL BE INSTALLED INTO CARD 5231-SDR DALA2016022801522Attach Bracket · corrodedAFT CARGO ENTRY LOWER ATTACH STRUCTURE CORRODED. REPAIRED IAW SRM 53-05, FIG 123 AND ER/A 499523-14MA.SDR DALA2016022801519Lanyard · misroutedMAINTENANCE FOUND THE TAILCONE RELEASE LANYARD ROUTED INCORRECTLY. THE TAILCONE RELEASE LANYARD WAS PROPERLY ROUTED. A FUNCTIONAL CHECK OF THE RELEASE SYSTEM WAS CONDUCTED AND CHECKED.SDR DALA2016022701502Shear Angle · damagedMINIMUM FASTENER REQUIRMENT ON SHEAR ANGLE FWD TAB, EITHER SIDE OF THE LOWER TEE CHORD CUT LINE DOES NOT COMPLY BS 1338 BETWEEN LONGERONS 26-27L, & 26-27R. REPAIR WAS PERFORMED IAW ER/A 543163-14, REV ORIGINAL
Back to Mcdonnell Douglas MD-88