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 DALA2015021801419Door Frame · crackedTWO CRACKS OF 1.375 AND 1.250 APPROXIMATELY WERE FOUND ON AFT LOWER DOOR FRAME CORNER INTERNAL DOUBLER AT C1. DAMAGED AREA WAS REPAIRED IAW SRM 53-05, FIG 105.SDR DALA2015021701384Skin · crackedCRACK LOWER SKIN XOS 240.081 AT RT SLAT PANEL NR 2. THIS REPAIR WAS ATTENDED IAW ERA 519116-14MA, REV ORIGINAL AND ETI-88-14-002.SDR DALA2015021601364Service Panel · corrodedCORROSION ON AFT LAVATORY SERVICE PANEL. SERVICE PANEL WAS REPLACED IAW DWG 5914792 AND SRM 51-30-2/51-30-5/51-10-3 AND 51-10-4.SDR DALA2015021701341Cusp Web · corrodedCORROSION ON RT CUSP WEB FROM BS 1174 - 1187 AND BETWEEN X -54 AND X -60. CUSP WEB REPAIRED IAW SRM 53-05, FIG 131, A-1.SDR DALA2015021501339Angle · crackedCRACKS ON RT/LT NLG WHEEL WELL ANGLES BETWEEN STA Y=38 AND X=17, X=-17. CRACKS ON RT/LT NLG WHEEL WELL ANGLES BETWEEN STA Y=30 AND X=17, X=-17 WERE REPLACE IAW SRM 53-14-1 FIG 4.SDR DALA2015021501336Skin · crackedCRACKED LOWER SKIN XOS 136.421 AT RT SLAT PANEL NR 1. RT SLAT PANEL NR 1 WAS REPAIRED IAW ETI-88-15-034, REV ORIG AND ERA 531400-14, REV ORIGINAL.SDR DALA2015021401333Cusp Web · crackedCUSP WEB WAS FOUND CRACKED IN BS 1230 AND BETWEEN X -44 AND X -54. CUSP WEB REPAIRED IAW SRM 51-30-2, SRM 53-05, FIG 131 A -17 AND SRM 51-10-3 PAR 14, 21 & 38.SDR DALA2015021401332Skin · dentedDENT ON LOWER SKIN AT LT ANTI-FLOAT TAB. LT ANTI-FLOAT TAB WAS REPAIRED IAW SRM 55-04, PAR 2 AND OPEN 1031A.SDR DALA2015021401330Floor Support · crackedCRACKS ON BEAM SUPPORT THE FLOORBEAM, BETWEEN STA Y=1022 TO Y=1041, X=0, CENTER AREA. NEW BEAM SUPPORT WAS REPLACED IAW SRM 51-30-5 AND 51-30-2, 51-10-3 PARA 14 AND 21.SDR DALA2015021401329Access Panel · corrodedCORROSION ON COUNTERSINKS AT RT MAIN FUEL TANK ACCESS PLATE NR 1464 C. OUT OF LIMITS IAW SRM 52-22-2A. ACCESS PLATE NR 1464C WAS REPLACED.SDR DALA2015021401328Access Panel · corrodedCORROSION ON COUNTERSINKS AT RT MAIN FUEL TANK ACCESS PLATE NR 1410C. OUT OF LIMITS IAW SRM 51-22-2A. ACCESS PLATE NR 1410C WAS REPLACED AND WILL BE INSTALLED UNDERCARD 2800-0390 JOB 001-0392.SDR DALA2015021401327Access Panel · corrodedCORROSION ON COUNTERSINKS AT RT MAIN FUEL TANK ACCESS PLATE NR 1462C. OUT OF LIMITS IAW SRM 51-22-2A. ACCESS PLATE 14626 WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0120, JOB 001-0386.SDR DALA2015021401326Web · corrodedCORROSION ON WEB BETWEEN BS 363 - 370, LONGERON 24-26R. REPAIRED IAW ER/A 5325-19-14, REV ORIGINALSDR DALA2015021401325Access Panel · corrodedCORROSION ON COUNTERSINKS AT RT MAIN FUEL TANK ACCESS PLATE 1409C. ACCESS DOOR WAS REPLACED AND WILL BE INSTALLED UNDER CARD 2800-0390, JOB 061-0392.SDR DALA2015021401324Cusp Web · crackedCRACKED RT CUSP WEB BETWEEN BS 1098-1117 X -54 X -60. CUSP WEB REPAIRED IAW SRM 53-05, FIG 131A-7.SDR DALA2015021401323Access Panel · corrodedCORROSION ON COUNTERSINK OF FUEL ACCESS PLATE NR 1464C AT RT WING. DAMAGE ON ACCESS PLATE NR 1464C WAS REWORKED IAW SRM 51-22-2A, PAR 6, CONDITION II REWORKED AREA WAS MEASURED. DIAMETER 0.3235" AND COUNTERSINK 0.620" AND REPAIR BUSHING WAS FABRICATED AND ISDR DALA2015021401320Rib · corrodedCORROSION ON RIB XOS 380.229-481.438. DAMAGED RIB FOUND OUT OF LIMITS OF DBP. BUSHINGS WERE FABRICATED AND INSTALLED IAW SRM 57-02, PAR 9. DAMAGE ON RIB INBD WERE REWORKED IAW ETI-88-15-032, REV 1AND ER/A 531398-14, REV ORIG.SDR DALA2015021401318Pan · crackedCRACKED DOOR PAN INNER STRUCTURE AT INTERSECTION WITH ZEE CHANNEL ON FWD RT OVERWING EMERGENCY EXIT. INNER SKIN, STOP FITTING AND CLIP WERE REMOVED IAW SRM 51-30-2, SRM 51-30-1 AND 51-30-5. CRACK WAS STOP DRILLED IAW SRM 51-01, PAR 21. HFEC INSPECTION WAS SDR DALA2015021401317Web · corrodedCORROSION ON WEB BS 427 - 434 LONGERON 24 - 27R. REPAIRED IAW ERA 511165-14 MA, REV B.SDR DALA2015042202860Doubler · corrodedTHE AFT LAV CUTOUT DOUBLER WAS CORRODED AND REPAIRED, IAW ER/A 532435-14.SDR DALA2015021901466Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN STA Y846-851, 964-966, 970-974 AT PASSENGER CABIN STRUCTURE. CORROSION WAS REMOVED, TREATED, PAINTED IAW SRM 51-10-3 P 14, 21, 26 (UT) IAW NDT SRM 04-00-07, PAR 5, FIG 3, SH 1 AND 2 WAS ACCOMPLISHED: ORIGINAL THICKNESS IS BETWSDR DALA2015021501349Stop Fitting · crackedCRACKED STOP FITTINGS, ON FWD EDGE AND AFT EDGE BETWEEN BEAMS 1-2 AT FWD CARGO DOOR. DAMAGE STOPS FITTINGS WERE REMOVED. NEW STOP FITTINGS WERE DRILLED. HOLES OF STOP FITTINGS WERE TREATED AND PAINTED. NEW FITTINGS WERE INSTALLED IAW SRM 51-30-5, 51-30-1, SDR DALA2015021501348Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FABRICATED A NEW FLOOR PANEL IAW AMM 53-20-01-201 AND PS900-5-2 NR 2.SDR DALA2015021501347Skin · corrodedCORROSION ON FUSELAGE SKIN AT LT WING L/E FILLET PANEL AREA BETWEEN BS 726 - 807 AND LONGERONS 17-30L. CORROSION WAS REMOVED AND REWORKED AREAS WERE MEASURED ORIGINAL THICKNESS ON STA Y=805, LONGERON 29-28 LT IS 0.157" AND REMAINS 0.142" ON STA Y=803, LONG 29-SDR DALA2015021501345Skin · corrodedCORROSION ON FUSELAGE SKIN AT RT OVERWING FILLET PANEL AREA BETWEEN BS 807 - 1033 AND LONGERONS 17 - 18R. REMOVE CORROSION AND REWORKED AREAS WERE MEASURED. ORIGINAL THICKNESS ON STA Y=927-950, LONG 18-17 RT IS 0.160" AND REMAINING'S 0.157" ON STA Y=960-1003SDR DALA2015021701342Skin · corrodedCORROSION ON REPAIR DOUBLER BS 1774 - 1184 BETWEEN LONGERONS 22 - 23L. DOUBLER REPLACED IAW SRM 53-04, FIG 12D AND SRM 51-30-2, SRM 51-30-5 AND 51-10-3 PAR 14, 21, 38.SDR DALA2015021501340Skin · corrodedCORROSION ON FUSELAGE SKIN AT RT FWD UNDERWING FILLET PANEL AREA BETWEEN BS 807 - 864 AND LONGERONS 28 - 30R. CORROSION WAS REMOVED AND REWORKED AREA WAS MEASURE STAY=824, LONGERON 30-29 RT IS 0.160" AND REMAINING'S 0.147". ON STA Y= 820-817 LONGERON 30-29, RSDR DALA2015021501338Skin · corrodedCORROSION ON FUSELAGE SKIN AT LT FWD UNDERWING FILLET PANEL AREA BETWEEN BS 807 - 864 AND LONGERONS 28 - 30L. CORROSION WAS REMOVED AND REWORKED AREA WAS MEASURE. ORIGINAL THICKNESS ON STA Y=815-820, LONG 30-29 LT IS 0.080" AND REMAINING'S 0.076" AND STA Y=82SDR DALA2015021501337Skin · corrodedCORROSION ON FUSELAGE SKIN LT OVERWING FILLET PANEL AREA BETWEEN BS 807 - 1033 AND LONGERONSS 17 - 18LT. CORROSION WAS REMOVED AND REWORKED AREA WAS MEASURE. ORIGINAL THICKNESS ON STA Y=819-824, LONG 18-17 LT IS 0.063" AND REMAINING IS 0.061". ON STA Y=859-86SDR DALA2015021501335Stiffener · crackedCRACKED STIFFENER, BS 1338, 12 HRS POSITION AT AFT CABIN FUSELAGE. REMOVED STIFFENER. FABRCATED NEW STIFFENER. TREATED AND PAINTED NEW STIFFENER. INSTALL NEW STIFFENER IAW SRM 51-30-5 AND 51-30-2, DWG 9915562, REV ET 51-10-3 PAR 14 AND 21.SDR DALA2015021401322Skin · corrodedCORROSION ON EXTRNAL FUSELAGE SKIN BENEATH RUB STRIPS FILLET PANELS FROM BS 886-1003 LONGERON 18R. REMOVED CORROSION AND FOUND WITHIN LIMITS IAW SRM 53-04, PAR 57 51-10-3, PAR 26 51-10-3, PAR 14 AND 21.SDR DALA2015021401321Tab · dentedDENTS ON UPPER AND LOWER SKIN AT LT GEARED TAB. LEFT GEARED TAB WAS REPAIRED IAW SRM 55-04, PAR 2.SDR DALA2015021401316Longeron · corrodedCORROSION ON LONGERON 29L BS 1338. THE LONGERON WAS REPLACED IAW SRM 51-10-3 AND 51-30-5.SDR DALA2015021301315Channel · corrodedCORROSION AND WEAR ON CHANNELS AT LT AFT LAVATORY PAN. CHANNELS REMOVED. NEW CHANELS WERE TRIMMED, DRILLED, TREATED, PAINTED AND WERE INSTALLED IAW SRM 53-24-0, 51-20-0, 51-10-3 PAR 21,14.SDR DALA2015021301314Skin · damagedDAMAGED PAINT COAT AND METALIZED ON BOTH SIDES OF RUDDER SKIN. BOTH SIDES OF RUDDER SKIN WAS REPAIRED FLAME SPRAY AND PAINTED IAW PS 900-3-6. N 36.SDR DALA2015021301313Longeron · crackedCRACKED LONGERON 2L BS 1418. LONGERON REPAIRED IAW SRM 53-02 FIG 18, 51-10-3 AND 51-30-5.SDR DALA2015021301312Longeron · crackedCRACKED LONGERON 13L BS 1437. LONGERON REPAIRED IAW SRM 53-02, FIG. 18, 51-30-5, 51-30-2 AND 51-10-3.SDR DALA2015021301311Floor Panel · crackedCRACKED FLOOR PANEL CHANNEL. FLOOR PANELS WERE REPAIRED IAW SRM 53-05, FIG 131C.SDR DALA2015021301310Longeron · crackedCRACKED LONGERON 2R FROM BS 1418. LONGERON REPAIRED IAW SRM 53-02, FIG 18, 51-10-3 AND 51-30-5.SDR DALA2015021301309Cusp Web · corrodedCORROSION ON LT CUSP WEB BETWEEN BS 465 - 484 X 54 TO X 60. CUSP WEB REPAIRED IAW SRM 53-05, FIG 131A-A AND 51-10-3, PAR 21, 14, 38.SDR DALA2015021301307Cusp Web · corrodedCORROSION ON REPAIR DOUBLER CUSP WEB AT BS 580 - 586 AND X -54 TO X -60. REPLACED IAW SRM 51-10-3, PARA 14, 21, 38, 51-30-2.SDR DALA2015021301306Spacer · corrodedCORROSION ON REPAIR SPACER AT CENTER LOWER CARGO BAY DOOR FRAME BS 636-693. REPAIR SPACER WAS REPLACED IAW SRM 53-05, FIG 123A SRM 51-10-3 PAR 14, 21.SDR DALA2015021301305Longeron · crackedCRACK ON LONGERON 4L BS 1309. LONGERON REPAIRED IAW SRM 53-02, P12, FIG 18.SDR DALA2015021301303Longeron · crackedCRACK ON LONGERON 16R BS 1437. LONGERON REPLACED IAW SRM 51-30-5, 51-30-2, 51-10-4, 51-10-3 PAR 14 AND 21, 53-14-4.SDR DALA2015021301300Longeron · corrodedCORROSION ON LONGERON 22L BETWEEN BS 1287 - 1338. NEW LONGERON WAS TREATED AND PAINTED IAW SRM 51-10-3, PAR 14 AND 21. THE LONGERON WAS REPLACED IAW SRM 53-02, FIG 18.SDR DALA2015021301299Intercostal · crackedCRACKED INTERCOSTAL X 0 BETWEEN BS 769 - 788. THE INTERCOSTAL WAS REMOVED IAW SRM 51-30-2. CRACK WAS STOPPED IAW SRM 51-01, P21. DOUBLER WAS FABRICATED IAW SRM 53-01, FIG 2 DOUBLER AND INTERCOSTAL WAS TREATED AND PAINTED IAW SRM 51-10-3 P21 AND 14. INSTALLESDR DALA2015021401343Skin · corrodedCORROSION ON EXTERNAL FUSELAGE SKIN BENEATH RUB STRIPS FILLET PANELS FROM STA Y=1136 TO Y=1003 BETWEEN LONGERON 24 AND 18 RT. REMOVE CORROSION TREAT AND PAINT AREA MEASURE THICKNESS ORIGINAL 0.080" REMAINING THICKNESS 0.070" THEREFORE IT'S WITHIN LIMITS IAW SSDR DALA2015021301216Rib · corrodedCORROSION FOUND ON RIB XOS=240.081. DAMAGE REWORKED, AND REAMED AND FOUND OUT OF LIMITS. REPAIR BUSHINGS WERE FABRICATED AND INSTALLED IAW SRM 57-02, PAR 9.SDR WX0A2015022572438Support · crackedLEFT FAIRING SUPPORT CRACKED AT KEEL BEAM. PERMANENT REPAIR, REPAIRED MLG JAMB SUPPORT IAW SRM 53-05 FIG 81.SDR WX0A2015022572437Support · crackedRIGHT FAIRING SUPPORT CRACKED AT KEEL BEAM. PERMANENT REPAIR, REPAIRED MLG JAMB SUPPORT IAW SRM 53-05 FIG 81.
Back to Mcdonnell Douglas MD-88