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 DALA2017032902523Fairing · damagedCRACK ON RT ELEVATOR CONTROL TAB FAIRING. TAB FAIRING WAS REPAIRED IAW SRM 55-01 FIG.2.SDR DALA2017032902521Cusp Web · corrodedCORROSION ON CABIN FLOOR CUSP WEB UPPER/LOWER SURFACES RBL 54 - 60, BS 1255 - 1266. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131 A-7.SDR DALA2017032902522Fairing · damagedPROTUBERANCE ON FAIRING BETWEEN ANTIFLOAT TAB AND GEARED TAB ON LT ELEVATOR. FAIRING WAS REPAIRED IAW SRM 55-01 FIG. 2.SDR DALA2017032802471Skin · scratchedSCRATCHES WERE FOUND AFFECTING THE LT WINDOW BELT PANEL BTW STA Y=598 - 674 IN REF TO NRC S/N 00159. SCRATCHES ON WINDOW BELT WERE REPAIRED PER ETI-88-17-084 REV ORIGINAL AND ER/A 556323-14 REV ORIGINAL.SDR DALA2017032802469Step · corrodedCORROSION AT VENTRAL STAIRWAY STEP NR 12. STEP NR 12 WAS REPLACED PER SRM 52-60-0.SDR DALA2017032802468Cusp Web · corrodedCORROSION ON CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE X=-54 X=-60 FROM STA Y=807 TO STA Y=845. AREA OUT LIMITS BTW STA Y= 826 TO 845 WAS REPAIRED PER SRM 53-05 FIG 131A-10. AREA BTW STA Y=807 TO 826 WAS RE-INSPECTED AND NOT CORROSION WAS FOUND.SDR DALA2017032802467Cusp Web · corrodedCORROSION ON CABIN FLOOR CUSP WEB UPPER/LOWER SURFACE X=-54 X=-60 FROM STA Y=1079 TO STA Y=1098. CUSP WEB WAS REPLACED PER SRM 51-30-2 AND 51-30-5.SDR DALA2017032802466Floor Panel · delaminatedDELAMINATED ON FLOOR PANEL. FLOOR PANEL WERE FABRICATED PER AMM 53-20-01-201.SDR DALA2017032802465Cusp Web · crackedDERIVED OF INSPECTION HFEC ON CUSP WEB WAS FOUND CRACK OF STA Y=1039 BTW X -54 TO X - 60 AT CABIN PAX. CUSP WEB WAS REPAIRED OF STA Y=1039 BTW X-54 TO X-60 PER SRM 53-05 FIG 131A-9.SDR DALA2017032802464Support · crackedLT WING, CRACKED LWR MLG SUPPORT STA XCW 104, ALSO LOOSE FASTENERS. CRACKED LWR MLG SUPPORT STA XCW 104, ALSO LOOSE FASTENERS. (LW), WERE REPAIRED PER ETI -88-17-087 REV 6 & ERA 556328-14 REV ORIGINAL.SDR DALA2017032902528Brake · draggingNR 4 BRAKE DRAGGING. REPLACED THE NR 4 BRAKE ASSY IAW AMM 32-42.SDR DALA2017032802520Frame · crackedDURING A WALKAROUND, RAMP REPORTED MID CARGO DOOR HARD TO OPEN. FOUND MID CARGO DOOR LOWER FRAME CRACKED 4-6 INCHES ALONG RIVET ROW WHERE SKIN ATTACHES. REPAIRED IAW MM 52-31SDR DALA2017032702435Mechanism · corrodedAFT ACCESSORY COMPARTMENT, CORROSION ON BELLCRANK AT RUDDER THROW-LIMITER MECHANISM. BELLCRANK AT RUDDER THROW-LIMITER MECHANISM WAS REPLACED AND INSTALLED PER RII AMDS 2720-2325 STEP NR 6 AND MUST BE ADJUSTED PER RII AMDS 2720-2325 STEP NR 7.SDR DALA2017032702434Floor Support · crackedAFT WET AREA, CRACK AND BEND FLOOR SUPPORT ON STA Y= 1309 TO STA= 1347 AND X= -17 AMDS 5300-2586. NEW FLOOR SUPPORT WAS REPLACED PER SRM 51-30-1 AND DWG 9936656 REV AM.SDR DALA2017032702431Frame · crackedCRACK ON FRAME AT STA 1510 AT GUIDE PIN HOLE APPROX 4:00 OCLOCK POSITION. INSTALLED DOUBLER AND FILLER PER ERA 497316-14MA REV C.SDR DALA2017032702428Step · corrodedCORROSION ON VENTRAL STAIRWAY STEPS 1, 3, 4, 5, AND 6 SETTLEMENT AREA. STEPS 5, AND 6 WERE DRILLED AND ADJUSTED IAW SRM 52-60-0, CORROSION WAS REMOVED ON VENTRAL STAIRWAY STEPS 1, 3, & 4.SDR DALA2017032702427Doubler · wornL1 DOOR HAS WEAR ON THE EXTERNAL DOUBLER, HOOK AREA. EXTERNAL DOUBLER WAS REPLACED IAW SRM 52-05, FIG 20A.SDR DALA2017032702426Pan · crackedCRACK FOUND ON RT UPPER CORNER RING PAN BS 845. RT UPPER CORNER RING PAN WAS REPAIRED IAW SRM 53-05, FIG. 122, AND ER/AS 493648-14MA.SDR DALA2017032702425Pan · crackedCRACKED INNER PAN ON FWD EDGE BELLOW STOP FITTING NR 3 AT AFT CARGO DOOR. THE INNER PAN WAS REPAIRED IAW SRM 52-05, FIG 50.SDR DALA2017032702423Cusp Web · crackedCRACKED LEFT CUSP WEB BETWEEN BS 767 - 769 AND LBL 50 AND 60. THE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131, A-18.SDR DALA2017032702437Support Bracket · crackedRT FLT SPOILER O/B TORQUE ARM SUPPORT BRACKET CRACKED. REPAIRED BRACKET PER SRM 57-09 FIG 33 AND REMOVED AND RE-INSTALLED TORSION BAR PER AMM 27-61-06.SDR DALA2017032702433Floor Support · corrodedAWR SECOND TIER: CORROSION ON TRACK AT WET AREA 1 BTW STA Y=148 AND Y=200 AT X=7. FLOOR SUPPORT WAS REPLACED PER SRM 51-30-1.SDR DALA2017032702432Floor Support · corrodedFWD WET AREA: CORROSION ON FLOOR SUPPORTS BTW STA Y=148 AND Y=218 BTW X=0 AND X=-60. FLOOR SUPPORTS WERE REPLACED PER SRM 51-30-2 AND 51-30-5.SDR DALA2017032702429Skin · corrodedLEFT WING TE FLAP SKIN CORRODED, UPPER AND LOWER SURFACES AT THE OTBD FLAP, OTBD GUIDE VANE. REPLACED IAW DWG 5910043 REV AU.SDR DALA2017032602421Finger Doubler · debondedDEBONDED FINGER DOUBLER ON PREVIOUS REPAIR ON INTERNAL FUSELAGE SKIN BETWEEN BS 218 - 256, LONGERON 16 - 17L. THE FINGER DOUBLER WAS REPLACED IAW SRM 53-04-3, FIG.12 (SHEET2).SDR DALA2017032602420Angle · corrodedCORROSION ON THE LT AND RT ANGLES AT LOWER AFT ENTRY DOOR AREA. THE ANGLES WERE REPLACED IAW SRM 51-30-4, 51-30-5, AND DWG 9915565, REV BD.SDR DALA2017032602419Fitting · cracked:CRACKED FITTING BS 1174 UPPER EDGE INTERNAL STRUCTURE. THE FITTING WAS REPLACED IAW SRM 51-30-2, AND 51-30-5.SDR DALA2017032602418Frame · crackedCRACK ON THE FRAME AT BS 845, LONGERON 11R. THE SPLICE AND FRAME ANGLE WERE REPLACED IAW DWG 9936517, REV ORG, AND SRM 53-03 D, FIG 3.SDR DALA2017041703095Skin · dentedRIGHT WING DENTED ON SKIN LOWER SURFACE AT THE INBD FLAP, OTBD GUIDE VANE. THE GUIDE VANE IAW SRM 57-03D, PAR 11 WAS REPLACED.SDR DALA2017032802473Control Cable · out of adjustAILERONS AND ELEVATOR STIFF-DIFFICULT TO MOVE IN FLIGHT. FOUND AILERON CABLES 7&8 TENSION OUT OF LIMITS (TOO LOW) ADJUSTED CABLES IN REF TO AILERON CABLES 7&8 TENSION ADJUSTMENTS & SAFETIES PER AMM 27-10. LUBED LATERAL CONTROL MIXER IN REF TO AIM 12-21. FOUND SDR DALA2017032602422Pin · wornTAIL CONE LOCK PINS WORN, RIGHT SIDE UPPER & LOWER. R & R BOTH RT UPPER & LOWER LOCK PIN ASSEMBLIES IAW AMM 53-53-00-501.SDR DALA2017032502417Seat Track · corrodedCORROSION ON SEAT TRACK LBL 22, FROM BS 516 - 518. THE DAMAGED AREA WAS REPAIRED IAW SRM 53-05, FIG 4A.SDR DALA2017032502416Door Frame · crackedCRACK ON THE RT AFT EMERGENCY EXIT DOOR FRAME IN UPPER SECTION. THE DOOR FRAME WAS REPAIR IAW SRM 53-05, FIG. 32.SDR DALA2017032502415Frame · crackedAFT ACCESORIES COMPARTMENT HAD A CRACKED FRAME BS 1510, BETWEEN 1 TO 2 HRS POSITION AND 5 HRS POSITION. THE FRAME WAS REPAIRED AT 1 HRS POSITION IAW ER/A 497316-14MA, REV ORIGINAL, AND SECTIONS WERE REPLACED BETWEEN 3 TO 6 HRS POSITION IAW SRM 51-30-1, 51-30-SDR DALA2017032502414Longeron · crackedCRACK ON LONGERON 4R, BS 541 AT INTERNAL FUSELAGE STRUCTURE BEHIND LIFE RAFT SUPPORT. THE LONGERON WAS REPAIRED IAW 53-02, FIG 18.SDR DALA2017032402377Cusp Web · damagedCORROSION ON CUSP WEB UPPER/LOWER SURFACE RBL 54 - 60, BS 1022 - 1079. FOUND CRACKED. REPAIRED IAW ER/A 511165-14MA.SDR DALA2017032802472Guide · wornBAD VIBRATION AT FRONT OF AIRPLANE CLIMBING OUT ABOVE 300 KNOTS. PERFORMED GVI FOUND EXCESSIVE PLAY ON RADOME GUIDE PIN HOLES R&R RADOME REF AMM 53-51.SDR DALA2017032802470Doubler · corrodedFUSELAGE INTERNAL DOUBLER LAV SERVICE PANEL STA 287 S-21L CORROSION REPAIR. REPAIR WAS ACCOMPLISHED PER ETI-88-17-086 REV ORIGINAL AND ER/A 493067-14 REV "B".SDR DALA2017032702436Floor Panel · damagedCARPET HAS A SOFT SPOT ABOUT 5 BY 5 INCHES. REPLACED CABIN FLOOR PANEL 256C AT CENTER OF F/C CABIN.SDR DALA2017032702430Skin · wornLEFT WING HAS A WORN INBD FLAP INBD VANE SKIN. THE FLAP WAS REPAIRED IAW SRM 57-03D, PARAGRAPH 11, FIG 11.SDR DALA2017032402376Pan · crackedL1 DOOR CRACKED ON INNER PAN , THE PAN WAS REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-4 AND 51-30-5.SDR DALA2017032402375Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN BS 218 AND 237, RBL 54 AND 60. REPAIRED IAW SRM 53-05, FIG 131A-13. HFEC INSPECTION WAS ACCOMPLISHED, NO CRACKS WERE FOUND.SDR DALA2017032402372Unknown · odorPASSING 6,000 MSL FLIGHT ATTENDANT CALLED TO REPORT A STRONG PLASTIC BURNING SMELL IN CABIN THAT GOT STRONGER FURTHER BACK IN CABIN. NO SMOKE OR HAZE OBSERVED. FAINT OILY SMELL OBSERVED IN FLIGHT DECK. RAN QRH PAGE 8.6 FOR SMOKE, FIRE OR FUMES. RETURNED TO CVGSDR DALA2017032302348Battery · dischargedAIR STAIR EMER LIGHTS INOP. REPLACED BATTERIES AFT EMER LIGHT BATTERY PACK REF AMM 33-53.SDR DALA2017032302352Handset · odorFWD FA HANDSET INOP AND HAS SLIGHT ELECTRICAL ODOR. REPLACED HANDSET. CKS GOOD.SDR DALA2017032302351Bushing · corrodedCORROSION ON UPPER BUSHING AT RUDDER UPPER HINGE. UPPER BUSHING ON UPPER HINGE RUDDER WAS REPLACED PER SOPM 20-10-7.SDR DALA2017032302350Pan · crackedPAX CABIN, CRACK ON RT UPPER CORNER RING PAN STA Y =1003. RING PAN WAS REPAIRED PER SRM 53-05 FIG 122 AND ER/AS 493648-14MA REV A.SDR DALA2017032302349Skin · crackedLT WING, CRACKED INNER SKIN OF SLAT PANEL NR 2 AT SLAT TRACK NR 7 RIB CUTOUT. SLAT PANEL NR 2 WAS REPLACED UNDER AMDS 2700-4224-LH-02 JOB 000-002 S/N: ON DL42, OFF DL32.SDR DALA2017032302337Repair · corrodedCORROSION ON LT PREVIOUS REPAIR CUSP WEB STA Y=1178 BTW X=54 TO X=60 AMDS 5300-2586. PREVIOUS REPAIR WAS REPLACED PER SRM 53-05 FIG 131A-6.SDR DALA2017032302336Seat Track · corrodedCORROSION ON RT SEAT TRACK X=-22 BTW STA Y=200 AND Y=256. SEAT TRACK WAS REPLACED PER SRM 53-05 FIG 4H AND 51-30-1, 51-30-2 AND 51-30-5.
Back to Mcdonnell Douglas MD-88