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 DALA2017020200876Cargo Track · corrodedAFT CARGO, CORROSION ON LT TIE TRACKS STA Y=1007 TO STA Y=1231 ON AFT CARGO CMPT. LT TIE TRACK STAY=1007 TO 1231 ORIG THICKNESS IS 0.060" AND SECTION CENTER EXTRUSION IS 0.100" MIN REMAINING IS 0.023" AND 0.087" RESPECTIVELY, THEREFORE ITS OUT OF LIMITS PER SRSDR DALA2017020200875Floor Support · damagedAFT CARGO COMPARTMENT, ELONGATED HOLE ON FLOOR SUPPORT ABOVE LONG 28R BTW STA Y = 1117 TO 1155. SUPPORT "Z" WAS REMOVED AND INSTALLED PER SRM 51-30-1 AND 51-30-2 NEW SUPPORT "Z" WAS DRILLED PER SRM 51-10-4. NEW SUPPORT "Z" WAS TREATED AND PAINTED PER SRM 51-1SDR DALA2017020200874Arm · corrodedLEFT WING, PITTING CORROSION ON OUTBD FLIGHT SPOILER REACTION ARM, TORSION BAR AND CAM ARM. OUTBD FLIGHT SPOILER REACTION ARM, TORSION BAR AND CAM ARM WERE REMOVED PER AMM 27-61-06, AND NEW REACTION ARM, TORSION BAR AND CAM ARM WERE INSTALLED PER MD88 AMM 27-6SDR DALA2017020200870Skin · nickedFUSELAGE, NICKS ON AFT LWR EDGE LT WINDOW BELT STA Y=748. REF ERA 554116-14 REV ORIG SEC II.SDR DALA2017020200869Intercostal · crackedCRACKED 2 INTERCOSTALS AND PLATE AT KEEL BEAM STA 937 BETWEEN X=7 AND X=-7. INTERCOSTALS (2 E/A) AND PLATE WAS REMOVED, FABRICATED AND INSTALLED PER DWG 9936368 REV AW SRM 51-30-5 AND 53-14-3.SDR DALA2017020200868Insert · missingMISSING INSERTS AND CRACK ON AFT CARGO COMPARTMENT CENTER FLOOR PANEL 181DF. FLOOR PANEL WAS REPLACED PER AMM 25-52-01-801.SDR DALA2017020200867Cargo Track · corrodedAFT CARGO COMPARTMENT, CORROSION ON LT TIE TRACK FROM Y=1003 TO Y=1322. NEWS TIE TRACK LT Y=1003 TO Y=1220 AND TIE TRACK LT Y=1220 TO Y=1322 WERE INSTALLED PER SRM 51-30-1 AND 51-30-2 HOLES WERE TREATED AND PAINTED PER SRM 51-10-3 PAR 14 AND 21.SDR DALA2017020200866Intercostal · corrodedAFT CARGO COMPARTMENT, CORROSION ON INTERCOSTAL STA=1003 TO STA=1022 BTW LONG 28L. INTERCOSTAL WAS REMOVED, FABRICATED AND INSTALLED PER DWG 9958212 ITEM 503 REV ED.SDR DALA2017020200865Cusp Web · puncturedPUNCTURE ON RT CUSP WEB BTW STA Y=786 AND X=-53. PUNCTURE ON CUSP WEB WAS REPAIRED PER SRM 53-01 FIG 1 SHEET 2/51-10-3 PAR 21 AND 14/51-30-5.SDR DALA2017020200864Cusp Web · corrodedPAX CABIN, CORROSION ON LT CUSP WEB FROM STA Y=586 TO STA Y=591 BTW X=54 TO X=60 UPPER AND LOWER SURFACE. AREA WAS PROTECT PER SRM 51-00-12 PAR 3 AND WAS ATTENDED AND REPAIRED PER SRM 53-05 FIG 131 A-13.SDR DALA2017020200863Intercostal · crackedCRACKED ANGLE ON FLOOR SUPPORT AT STA Y=1361 X=-22 Z=0. INTERCOSTAL WAS REPAIRED PER SRM, 53-01 FIG 1 51-10-2, 51-30-5.SDR DALA2017020200862Cusp Web · corrodedCORROSION ON DOUBLER REPAIR OF LT CUSP WEB BTW STA Y=826 TO 845 AND X=60 TO 54. CUSP WEB WAS REPAIRED PER SRM 53-05 FIG 131A-2.SDR DALA2017020200861Fitting · crackedR1 DOOR, CRACKED FWD CLIP ON BEAM NR 1. CLIP WAS REPLACED PER SRM 51-30-4, 51-30-5 AND DWG 9911579 REV L.SDR DALA2017020200860Beam · crackedR1 DOOR, CRACKED BEAM NR 1 FWD END. BEAM WAS REPLACED PER SRM 51-30-2 AND 51-30-5.SDR DALA2017020200859Doubler · crackedAFT ACCESSORY COMPARTMENT, CRACKED DOUBLER ON STA Y= 1463 CAT BTW LONG 17L TO 18L. DOUBLER ON STA Y= 1463 CAT BTW LONG 17L TO 18L WAS REPAIRED PER SRM 53-01 FIG 2 (SHEET 4).SDR DALA1702990925Stringer · not reportedWING MAIN FRAME STRINGER 11. REPAIRED IAW 5712-01030, SECT 04.SDR DALA2017021001124Relief Valve · corrodedFWD CARGO BAY CORRODED ON AFT POSITIVE PRESSURE RELIEF VALVE AT FWD CARGO BAY. REPLACED FOR A NEW VALVE IAW AMM 21-32-07-201.SDR DALA2017020200873Spar · corrodedLT PYLON, CORROSION ON UPPER FRONT SPAR BORE AT FWD ENGINE MOUNT YOKE ON STA Y=1307. CORROSION ON UPPER BORE WAS REPAIRED PER SRM 54-04D PAR 14 F.SDR DALA2017020100832Access Panel · corrodedCORROSION ON FUEL TANK ACCESS PANEL 1409C. THE ACCESS PANEL WAS REPLACED.SDR DALA2017020100831Tab · damagedRUDDER CONTROL TAB, COMPOSITE MATERIAL WAS FOUND DAMAGED. DAMAGE AREA WAS REPAIRED IAW SRM 51-90-0 PARAGRAPH 8.K.SDR DALA2017020100829Longeron · crackedCRACKED LONGERON 4R BS 541. THE LONGERON WAS REPAIRED IAW SRM 53-02 FIG. 18.SDR DALA2017020100828Structure · corrodedCORROSION ON BUSHING BORE OF LT MLG. THE CORROSION WAS REMOVED AND FOUND WITHIN LIMITS IAW DWG SR 09570087 REV. BB.SDR DALA2017020100827Skin · crackedRIGHT WING, CRACKED ON PREVIOUS REPAIR DOUBLER AT RIGHT WING LEADING EDGE XRS 253. DOUBLER WAS REPLACED IAW ER/A 490036-14 REV B.SDR DALA2017020100825Frame · crackedAFT ACCESSORY COMPARTMENT. CRACKED FRAME BS 1497. THE FRAME WAS REPAIRED IAW SRM 53-01 FIG. 2.`SDR DALA2017020100824Beam · crackedL1 DOOR NR 1 BEAM CRACKED AT FWD EDGE. THE BEAM WAS REPAIRED IAW SRM 52-05 FIG 98.SDR DALA2017020100823Spar · crackedRIGHT WING REAR SPAR CRACKED AT XRS 164 LOWER AFT CORNER OF FLAP HINGE FITTING. REPAIRED THE SPAR IAW DWG J060271 REV T.SDR DALA2017020100822Spar · crackedRIGHT WING REAR SPAR CRACKED AT XRS 164 LOWER AFT CORNER OF FLAP HINGE FITTIING. REPAIRED THE SPAR IAW DWG J060271 REV T.SDR DALA2017020100821Stringer · crackedRIGHT MAIN FUEL TANK STRINGER 11 CRACKED. CUT OUT THE DAMAGED SECTION AND REPAIRED RT WING STRINGER AT XRS 160-164 IAW DWG SR09570100 REV B, AND ERA 553842-14 REV O.SDR DALA2017020100819Access Panel · corrodedRIGHT WING, CORROSION ON ACCESS PANEL 1409C. THE ACCESS PANEL WAS REPLACED IAW SRM 51-22-2A PAR. 6 CONDITION III.SDR DALA2017020100818Frame · crackedAFT ACCESSORY COMPARTMENT. CRACKED FRAME BS 1485, LONGERON 16L. THE FRAME WAS REPARED IAW SRM 53-01 FIG 2 (SHEET 3), 51-10-3 PAR 14, 21 AND 51-30-2.SDR DALA2017020100817Intercostal · crackedAFT ACCESSORY COMPARTMENT. CRACKED INTERCOSTAL BS 1407, LONGERON 25R. THE INTERCOSTAL WAS REPAIRED IAW SRM 53-01 FIG.2 SHEET 4.SDR DALA2017013100797Web · corrodedCORROSION ON WEB BS 148.5 X.9. THE WEB WAS REPAIRED IAW SRM 51-70-4, FIG 1.SDR DALA2017013100796Frame · crackedCRACKED FRAME ANGLES BS 1231 BETWEEN LONGERONS 4 AND 7L. THE FRAME ANGLES WERE REPLACED IAW SRM 53-14-3, AND 51-30-2.SDR DALA2017013100795Angle · crackedR1 DOOR HAD A CRACKED FWD, LOWER ANGLE ON BEAM NR 1. THE ANGLE WAS REPLACED IAW SRM 51-30-5, AND DWG 9911579 REV L.SDR DALA2017013100794Doubler · dentedRIGHT WING DENTED ON A PREVIOUS REPAIR DOUBLER INBD FLAP INBD GUIDE VANE. THE GUIDE VANE WAS REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2017013100793Tee Fitting · crackedNR 2 CARGO DOOR HAD A CRACKED TEE AT BS 655, BEAM 1 TO LOWER EDGE AT MID CARGO DOOR. THE TEE WAS REPLACED IAW SRM 51-30-5, AND 51-30-2, AND DWG 9957664 REV N.SDR DALA2017013000790Battery Pack · inoperativeCENTER CEILING EMERGENCY LIGHTS 11-20 LEFT SIDE INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACKS AT BS 731 AND 500 IAW AMM 33-53. OPS CHECKED GOOD.SDR DALA2017013100763Actuator · failedON APPROACH INTO BHM WHEN GEAR SELECTED DOWN, THE NLG FAILED TO EXTEND. CREW ACCOMPLISHED QRH PROCEDURE AND PERFORMED AN ALTERNATE GEAR EXTENSION. NLG EXTENDED NORMALLY WITH GREEN DOWN/LOCKED INDICATION, CREW STOWED ALTERNATE EXTENSION LEVEL AND LANDED NORMALLSDR DALA2017013100762Duct · disconnectedFLIGHT RETURNED TO ATL DUE TO ODOR AND VISIBLE HAZE IN FIRST CLASS GALLEY AREA. CREW REPORTED WHEN AIRFOIL ANTI-ICE WAS SELECTED ON, A LOUD NOISE WAS HEARD, FOLLOWED BY RUSHING AIR NOISE WITH ASSOCIATED SMOKE/ODOR. AIRFOIL ANTI-ICE WAS SELECTED OFF AND NOISE CSDR DALA2017013000799Skin · scratchedLEFT WING :SCRATCHED ON THE LOWER FACE AT THE OTBD FLAP MID GUIDE VANE. REPAIRED IAW SRM 57-03D, PAR 11.SDR DALA2017013000791Cable · damagedRIGHT MLG WHEEL WELL HAD DAMAGED LACING OF HYD ELECTRIC MOTOR DRIVEN AUXILIARY PUMP FEED CABLE. THE LACING WAS REPLACED IAW ER/A 767688-14,MAAD, REVISION D AND SWPM 20-10-01.SDR DALA2017013000789Intercostal · crackedL1 DOOR CRACKED ANGLE ON FWD INTERCOSTAL BETWEENS BEAMS NR 4 AND 5. THE INTERCOSTAL WAS REPLACED IAW SRM 51-30-2.SDR DALA2017013000787Access Panel · corrodedCORROSION ON ACCESS PANELS 1303C AND 1404C. REPLACED THE ACCESS PANELS.SDR DALA2017013000786Cargo Track · corrodedLEFT CARGO TRACK IN AFT CARGO BAY, FROM BS 1220 TO 1322 CORRODED OUT OF LIMITS IAW SRM 53-05, FIG. 4C. THE CARGO TRACK WAS REPLACED IAW SRM 53-14-3.SDR DALA2017013000785Cargo Track · corrodedMID CARGO BAY HAD CORROSION ON THE LT AND RT CARGO TRACKS BETWEEN BS 522 AND 788. THE CARGO TRACKS WERE REPLACED IAW SRM 51-10-4, 51-10-3, PAR 26, 14, AND 21, 51-30-2, 51-30-1, 51-30-5, AND 53-05 FIG 4C.SDR DALA2017013000783Angle · crackedAFT ACCESORIES COMPARTMENT HAD A CRACKED ANGLE BS 1437 BETWEEN LONGERONS 12 - 13R. THE ANGLE WAS REPLACED IAW DWG 9911840, REV DC.SDR DALA2017013000782Angle · crackedAFT ACCESORIES COMPARTMENT HAD A CRACKED ANGLE BS 1437 BETWEEN LONGERONS 12 & 13R. THE ANGLE WAS REPLACED IAW DWG 9911840, REV DC.SDR DALA2017013000780Cusp Web · corrodedCORROSION ON RIGHT CUSP WEB, BS 620 - 623 AND BETWEEN RBL 54 - 60 UPPER AND LOWER SURFACE. FOUND TO BE OUT OF LIMITS AND REPAIRED IAW SRM 51-70-4, FIGURE 2 AND INSTALLED IAW SRM 51-30-5.SDR DALA2017013000779Lanyard · brokenR1 DOOR HAD A BROKEN SLIDE LANYARD. THE SLIDE LANYARD WAS REPLACED IAW AMM 25-62-00-201.SDR DALA2017013000778Frame · crackedAFT ACCESSORY COMPARTMENT HAD A CRACKED FRAME ANGLE BS 1380 BETWEEN LONGERONS 13 & 18R. THE FRAME ANGLE WAS FABRICATED AND REPLACED IAW SRM 53-14-4,51-30-2, AND 51-30-5.
Back to Mcdonnell Douglas MD-88