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 DALA2016120109433Intercostal · crackedCABIN FLOOR STRUCTURE, CRACK ON INTERCOSTAL BTW STA Y=769 TO Y= 788 X= 0. INTERCOSTAL STA Y=769 TO Y=788 WAS REPLACE PER SRM 51-30-5, 51-30-2 AND DWG 9936580 REV BW.SDR DALA2016120109432Seat Track · corrodedCORROSION ON PREVIOUS REPAIR PLUG AT Y=1000 X=-54. PREVIOUS REPAIR PLUG WAS REPLACED PER SRM 53-05 FIG 4A (SHEET 1) AND SRM 51-30-1.SDR DALA2016120109431Floor Panel · crackedCRACK ON GENERATION FLOOR PANEL NBR 541A. GENERATION FLOOR PANEL NBR 541A WAS REPAIR THE CRACK PER SRM 53-05 PAR 145 FIG 131B.SDR DALA2016120109429Longeron · crackedHIDDEN DAMAGE, CRACKED LONGERON 25 AND 22 RT STA Y=218 AT E&E COMPARTMENT. LONGERONS WERE REPAIRED PER SRM 53-02 FIGURE 18.SDR DALA2016120109428Pan · crackedFWD CARGO COMPARTMENT. CRACKED INNER PAN ON BEAM 5 STA Y= 370 AND 426 AT FWD CARGO DOOR INNER STRUCTURE. CRACK ON PAN STA Y=426 WAS REPAIRED PER SRM 52-03 D FIG 8 AND CRACK ON PAN STA Y=370 WAS REPAIRED PER ETI-88-16-444 REV ORIGINAL AND ERA 551769-14 REV ORIGSDR DALA2016120109426Floor Support · corrodedCORROSION ON FLOOR SUPPORT FROM STA Y=160 TO Y=200 AND X 7. SUPPORT WAS REPLACED PER SRM 51-10-4 AND DWG 9936534 REV ORG.SDR DALA2016120109425Frame · crackedAFT ACCESSORY COMPARTMENT, CRACKED TITANIUM FRAME ON STA Y=1346 BTW X=14L TO 14R. TITANIUM FRAME ON STA Y=1346 BTW X=14L TO X=14R WAS REPAIRED PER ER/A 094719-14 MA REV A STEPS 6, AND 7.SDR DALA2016120109424Diaphragm · corrodedHIDDEN DAMAGE, CORROSION ON WEB STA Y=210 BTW X=-44 TO X=-60 AT PAX CABIN. DIAPHRAGM WAS REPLACED PER SRM 53-14-1 FIG 11.SDR DALA2016120109423Intercostal · crackedCRACKED INTERCOSTAL ON LOWER SIX PULLEY BRACKET. INTERCOSTAL ON LOWER SIX PULLEY BRACKET WAS REPAIRED PER SRM 53-01 FIG 2, SRM 51-30-2 AND 51-30-5.SDR DALA2016120109422Cusp Web · corrodedCORROSION ON LT CUSP WEB BTW STA Y=712 TO 719 BTW X=54 TO 60 AT PAX CABIN. CUSP WEB BTW STA Y=712 TO Y=719 AND BTW X=54 TO X=60 WAS REPAIRED PER SRM 53-05 FIG.131A-10.SDR DALA2016120109421Cusp Web · corrodedCORROSION ON LT CUSP WEB BTW STA Y=543 TO Y=548 AND Y=582 TO Y=594, X=54-60. CUSP WEB ON STA Y=543 TO Y=548 AND Y=582 TO Y=594 WERE REPAIRED PER SRM 53-05 FIG 131 A- 14.SDR DALA2016113009419Battery · dischargedEMERGENCY POWER CEILING LIGHTS INOP AT ROW 22-26, 33 AND 36. REMOVED & REPLACED 4 EA BATTERY PACK BATTERIES. CEILING LIGHTS AT 22-26 & 33-36. OPS CCK GOOD.SDR DALA2016120109427Angle · corrodedFWD WET AREA, CORROSION ON CUSP ANGLE STA Y=160 TO Y=200 X=-60 RIGHT SIDE. CUSP ANGLE WAS REPAIRED PER SRM 53-05 FIG 55.SDR DALA2016113009439Warning System · false activationON GEAR EXTENSION RIGHT OUTBOARD ANTISKID LIGHT ILLUMINATED. PERFORMED GO AROUND AND AFTER EXTENSION ON NEXT APPROACH NO LIGHTS ILLUMINATED ALL NORMAL. ACCOMPLISHED ANTISKID SYS TEST IAW AMM 32-43. TEST NORMAL. PER MC REMOVED NR 4 MLG TIRE HUB CAP AND INSP XDCSDR DALA2016113009437Bracket · looseGIRT BAR CABLE BRACKET CAME LOOSE. REINSTALLED GIRT BAR CABLE CKS OK.SDR DALA2016113009402Cusp Web · corrodedCORROSION ON CUSP WEB BS 522-530, BS 554-560 AND BS 581-590. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-14.SDR DALA2016113009400Cusp Web · corrodedCORROSION ON LT CUSP WEB, LWR AND UPPER SURFACE BETWEEN LBL 60 - 44 AND BS 598 - 712. THE WEB WAS REPLACED IAW DWG 9930538 REV BF, SRM 51-30-2,51-30-1 AND 51-30-5.SDR DALA2016113009399Longeron · crackedCRACKED LONGERON 4R AT CROWN BS 522. THE LONGERON WAS REPAIRED IAW SRM 53-02 PAR.12 FIG.18.SDR DALA2016113009398Pan · crackedCRACKED PAN ON RT FWD OVERWING EMERGENCY DOOR FRAME BS 905, LONGERON 16R. REPAIRED IAW SRM 51-70-4 FIG 2 SHEET 1.SDR DALA2016113009397Diaphragm · corrodedDIAPHRAGM CORROSION BS 185 TO 200 AND RBL 50 TO 54. REPAIRED IAW SRM 51-70-4.SDR DALA2016113009396Cusp Web · corrodedCUSP WEB CORROSION ON BS 668 - 670, BS 678 - 681 AND BS 700 - 703. CUSP WEB REPAIRED IAW SRM 53-05 FIG. 131-A.SDR DALA2016113009395Spacer · corrodedAFT CARGO BAY, CORROSION ON PREVIOUS REPAIR SPACER AT DOOR JAMB BEAM. PREVIOUS REPAIR SPACER AT DOOR JAMB BEAM WAS REPLACED PER DC-9/MD-80 SRM 51-30-5 AND SRM 53-05 FIG. 123.SDR DALA2016113009394Doubler · crackedCRACKED L1 DOOR EXTERNAL DOUBLER AFT LOWER SECTION. EXTERNAL SKIN WAS REPAIRED IAW SRM 52-05 PARAGRAP 39 FIGURE 37.SDR DALA2016112909376Switch · failedON APPROACH, RECEIVED NOSE GEAR UNSAFE LIGHT DURING GEAR EXTENSION. COMPLIED WITH QRH AND NORMAL EXTENSION FOLLOWED. IAW MCC, AN EMERGENCY WAS DECLARED. MAINTENANCE REPLACED THE NOSE GEAR INTERLOCK SWITCH WITH POSITIVE RESULTS DURING MULTIPLE NOSE GEAR EXTENSISDR DALA2016113009420Battery Pack · dischargedLT AND RT OVERHEAD, OVERWING EXIT LIGHTS W/N ILLUMINATE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-53.SDR DALA2016112909403Controller · malfunctionedCABIN PRESSURE AUTO INOPERATIVE, AUTO 1 INOPERATIVE, AUTO 2 INOPERATIVE, ALL ILLUMINATED COMPLIED WITH QRH. AN EMERGENCY WAS DECLARED. PERFORMED BITE OF AUTO PRESSURE CONTROLLER NR 1 AND 2. BITE SHOWS A/C MOTOR. PERFORMED RESET OF CONTROLLER NR 2 FWD.SDR DALA2016112909374Light · inoperativeEMERGENCY LIGHTS IN 1ST CLASS WILL NOT COME ON. DISCONNECTED AND RECONNECTED BATTERY PACKS, LIGHTS CHECKED GOOD IAW MM 33-53.SDR DALA2016112909372Structure · crackedCRACK ON INSIDE ANGLE AT STOP FITTING 2, THE PAN AT STOP 14 CRACKED. REPAIRED IAW SRM 52-05 FIG. 51.SDR DALA2016112909371Pan · crackedFWD RT EMERGENCY EXIT DOOR PAN CRACKED BETWEEN STOPS 4 AND 5. REPAIRED IAW SRM 52-05-FIG. 51SDR DALA2016112909368Door Frame · crackedCRACKED PAN ON THE LT AFT OVERWING EMERGENCY DOOR FRAME BS 905 LONGERON 16L. REPAIRED IAW SRM 53-01 FIG 2 SHEET 3.SDR DALA2016112909367Frame · crackedCRACKED FRAME ANGLE BS 1380 BETWEEN LONGERONS 13 - 14R. THE FRAME ANGLE WAS REPAIRED IAW SRM 53-01 FIG 2 SHEET 4.SDR DALA2016112909366Cusp Web · crackedCORROSION ON THE CUSP WEB LOWER AND UPPER SURFACE, BS 845 - 905, RBL 44 - 60. THE CUSP WEB WAS REPLACED IAW SRM 53-05 FIG 131A-24, 51-10-3 PAR 14 -21, AND 51-30-2.SDR DALA2016112909365Pan · crackedCRACKED FWD UPPER CORNER PAN OF THE L1 DOOR. THE PAN WAS REPAIRED IAW SRM 52-05 PAR 14 FIG 18A.SDR DALA2016112909364Cusp Web · crackedCRACK ON CUSP WEB BS 997, LBL 57. REPAIRED IAW SRM 53-05 FIG 131A-4.SDR DALA2016122210025Vane · debondedDISBONBED PREVIOUS REPAIR DOUBLER ON LOWER SKIN AT STA XOVIF = 58 ON RT WING INBD FLAP OUTBD GUIDE VANE. FLAP OUTBD GUIDE VANE ARE OUT BOUNDS BY CORROSION IAW SRM 57-03D PAR.11 AND INBD FLAP OUTBD GUIDE VANE WAS REPLACED IAW AMM 27-51-03.SDR DALA2016112809375Engine · failedRETURNED TO DEPARTURE DUE TO RIGHT ENGINE ISSUES. THE CREW REPORTED THAT ON TAKEOFF AT FL50 THE NR 2 ENGINE LOST OIL PRESSURE, HYDRAULICS AND STARTED VIBRATING. THE QRH WAS FOLLOWED AND THE ENGINE WAS SHUT DOWN. THE NR 2 ENGINE WAS REPLACED.SDR DALA2016112809294Battery Pack · inoperativeCOCKPIT AND FWD ENTRY EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK. OPS CHECKED OK IAW AMM 33-50.SDR DALA2016112809293Engine · failedAFTER TAKEOFF, APPROACHING 5000 MSL, LOST OIL PRESSURE AND RIGHT ENGINE HAD SEVERE VIBRATIONS, LOSS OF RIGHT HYDRAULIC SYSTEM. VIBRATIONS STILL PRESENT ON WINDMILLING ENGINE. RETURNED FOR SINGLE ENGINE LANDING. NR 2 ENGINE WAS REPLACED.SDR DALA2016112809292Tab · missingFLAME SPRAY MISSING ON RUDDER TAB. REMOVED & REPLACED RUDDER TAB. OK FOR SERVICE.SDR DALA2016112809291Structure · missingFLAME SPRAY MISSING ON RUDDER. REMOVED & REPLACED RUDDER. OK FOR SERVICE.SDR DALA2016112809290Floorbeam · corrodedCORROSION WAS FOUND ON THE FLOORBEAM BS 180 RBL 7 - 44. THE FLOORBEAM WAS REPLACED IAW SRM 51-10-4.SDR DALA2016112809289Floor Support · corrodedCORROSION ON FLOOR SUPPORT BS 160 - 200 AND LBL 54. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-4.SDR DALA2016112809286Door Frame · corrodedMID CARGO BAY CORROSION WAS FOUND ON THE LOWER DOOR FRAME PREVIOUS REPAIR BS 636 - 693. THE SPACER WAS REPLACED IAW SRM 53-05 FIG 123.SDR DALA2016112809283Step · corrodedCORROSION ON VENTRAL STAIR STEPS 2, 3, 4, 5, 10, AND 12. ALSO A BROKEN RETAINERS ON STEPS 3 AND 4. STEPS 3 AND 12 WERE REPLACED DUE TO CORROSION. CORROSION ON STEPS 2, 4, AND 5 WERE REMOVED, THE RETAINERS ON STEPS 3 AND 4 WERE REPLACED.SDR DALA2016112709282Bracket · corrodedCORROSION FOUND ON AFT BRACKET SUPPORT OF PREMIER LAVATORY. BRACKET WAS FABRICATED IAW DWG MD081101 ECO NO A-3.SDR DALA2016112709281Cable · dislodgedLEFT FIRE TEE HANDLE FEELS SPONGY. FOUND CABLE GOING TO HYD SHUTOFF VALVE OFF THE PULLEY. REPOSITIONED IAW AMM 20-10. OPS CHECKED NORMAL. INSPECTED PULLEY AND GUARDS. CHECKED GOOD.SDR DALA2016112709280Web · puncturedA PUNCTURED WEB AT BS 203, LBL 22 AND 44. THE WEB WAS REPAIRED IAW SRM 53-01 FIG 4, AND 51-10-3 PAR 14, 21, 38.SDR DALA2016112709279Cusp Web · corrodedCORROSION ON LT CUSP WEB PREVIOUS REPAIR, BS 446 - 465. THE REPAIR WAS REPLACED IAW SRM 53-05 FIGURE 131A-13 AND SRM 51-30-5.SDR DALA2016112709278Pan · crackedA CRACK ON RT FWD UPPER CORNER BS 807 AND RT FWD LOWER CORNER BS 1060 OF WINDOW RING PAN. REPAIRED IAW SRM 53-05 FIG. 122, ER/A 487747-14MA REV. A, AND ER/A 493648-14MA REV. A.SDR DALA2016112709277Pan · crackedCRACK ON LH AFTER UPPER CORNER BS 1079 OF WINDOW RING PAN AT CABIN PASSENGER. REPAIRED IAW SRM 53-05 FIG. 122, ER/A 487747-14MA REV. A AND ER/A 493648-14MA REV. A.
Back to Mcdonnell Douglas MD-88