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 DALA2016101907351Cusp Web · corrodedCORROSION OUT OF LIMITS ON RT CUSP WEB X -54 TO -60 BETWEEN BS 710 - 728. REPAIRED IAW SRM 51-30-2,51-30-3, 51-30-1,53-05 FIG. 131A-7 , 51-10-3 PAR. 21,14 AND 38.SDR DALA2016101807350Frame · crackedCRACK ON FRAME ANGLE BS 1450 BETWEEN LONGERON 1 AND 3L & RT SIDE. THE FRAME ANGLE WAS REPLACED IAW DWG 9911860 REV. "L" AND SRM 51-30-5.SDR DALA2016101807343Intercostal · crackedCRACK ON INTERCOSTAL BS 1287 - 1307, X 0. THE INTERCOSTAL WAS REPAIRED IAW ER/A 380524-14 MA REV. ORIG. AND SRM 51-30-5.SDR DALA2016101807342Pan · crackedCRACKED INNER PAN ON FWD UPPER CORNER AREA AT MAIN ENTRANCE DOOR INNER STRUCTURE. THE PAN WAS REPAIRED IAW SRM 52-05 FIG. 18A.SDR DALA2016101807341Pan · crackedCRACK ON LT FWD UPPER CORNER WINDOW RING PAN BS 886. THE AREA WAS REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14MA REV A, 493648-14MA REV A.SDR DALA2016101807340Pan · crackedCRACK ON LT FWD UPPER CORNER WINDOW RING PAN BS 598, 750 AND 845. AREA WAS REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02 ,51-30-05, 51-10-03, PAR 21, 14.AND ER/A 487747-14MA REV A, 493648-14MA REV A.SDR DALA2016101807339Pan · crackedCRACK ON LT FWD LOWER CORNER WINDOW RING PAN STA Y = 1022 AND Y = 1041 AT PAX CABIN. AREA WAS REPAIRED PER SRM 53-05 FIG 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14MA REV A, 493648-14MA REV A.SDR DALA2016101807338Frame · crackedCRACK ON WEB AT STA Y=1463 CANT BTW 10HRS AND 11HRS POSITION IN AFT ACCESSORY COMPARTMENT. DAMAGE AREA WAS REPAIRED PER SRM 53-03D FIG 38A, 51-30-2 & 51-30-5, 51-10-3 PAR 21 AND 14.SDR DALA2016101807337Pan · crackedCRACKED RT WINDOW RING PAN AFT/UPPER CORNER ON STA Y= 1060, STA Y=1079, STA Y=1098 AND STA Y=1117 AT CPAX. AREAS WERE REPAIRED PER SRM 53-05 FIG 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14MA REV A, 493648-14MA REV A.SDR DALA2016101807336Pan · crackedCRACKED RT WINDOW RING PAN AFT/UPPER CORNER ON STA Y= 1155, STA Y=1212, STA Y=1231 AND STA Y=1250 AT CPAX. AREAS WERE REPAIRED PER SRM 53-05 FIG 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14. AND ER/A 487747-14MA REV A, 493648-14MA REV A.SDR DALA2016101807335Pan · crackedCRACKED RT WINDOW RING PAN FWD/UPPER CORNER ON STA Y= 807 AT CPAX. AREA WAS REPAIRED PER SRM 53-05 FIG 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14. AND ER/A 487747-14MA REV A, 493648-14MA REV A.SDR DALA2016101807334Cusp Web · corrodedCORROSION ON LT CUSP WEB X= 54 TO X= 60 BTW Y=389 TO Y= 465 AT PAX CABIN. PREVIOUS DOUBLER WAS REPLACED PER SRM 53-05 FIG 131A-13.SDR DALA2016101807333Cusp Web · puncturedPUNCTURED ON LT CUSP WEB X= 53 AND STA Y= 1062 AT PAX CABIN. PUNCTURED ON LT CUSP WEB X=53 AND Y=1062 WAS REPAIRED PER SRM 53-01 FIG 1 SHEET 2.SDR DALA2016101707305Pan · crackedCRACK ON THE LT AFT LOWER CORNER WINDOW RING PAN BS 1079 AND 1098. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14. AND ER/A 487747-14MA REV.A, 493648-14MA REV.A.SDR DALA2016101707304Pan · crackedCRACK ON THE LT AFT UPPER CORNER WINDOW RING PAN BS 1231 AND 1250. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02 ,51-30-05, 51-10-03, PAR 21,14.AND ER/A 487747-14MA REV.A, 493648-14MA REV. A.SDR DALA2016101707303Pan · crackedCRACKED RT WINDOW RING PAN AFT & LOWER CORNER AT BS 769, 826 AND 1231. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02 ,51-30-05, 51-10-03, PAR 21,14.AND ER/A 487747-14MA, 493648-14MA.SDR DALA2016101707302Pan · crackedCRACK FOUND ON THE LT FWD LOWER CORNER WINDOW RING PAN BS 1060 AND 1079. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14. AND ER/A 487747-14MA, 493648-14MA.SDR DALA2016101707298Floor Support · crackedCRACK AND CORROSION ON FLOOR SUPPORT. REPAIRED IAW SRM 53-05 FIGURE 131 B.SDR DALA2016101707297Pan · crackedCRACKED RT WINDOW RING PAN AFT & LOWER CORNER AT BS 864. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14MA REV.A, 493648-14MA REV.A .SDR DALA2016101707296Pan · crackedCRACKED RT WINDOW RING PAN FWD & UPPER CORNER AT BS 886. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02 ,51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14MA REV. A, 493648-14MA REV. A.SDR DALA2016101707295Pan · crackedCRACKED RT WINDOW RING PAN AFT & UPPER ANGLE AT BS 1003. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02 ,51-30-05, 51-10-03, PAR 21,14.AND ER/A 487747-14MA.SDR DALA2016101707292Beam · crackedCRACKED PREVIOUS REPAIR DOUBLER ON BEAM NR 8 ON THE INNER STRUCTURE OF THE PAX DOOR. REPAIRED IAW SRM DWG 9955759 REV. P.SDR DALA2016101707291Skin · crackedCRACKED OUTER SKIN AT THE PAX DOOR. THE SKIN WAS REPAIRED IAW ERA 486216-14 MA REV A.SDR DALA2016101707290Pan · crackedCRACKED RT WINDOW RING PAN FWD/LOWER CORNER AT BS 1117, 1136, 1193 AND 1212. REPAIRED IAW SRM 53-05 FIG. 122 , 51-30-02 ,51-30-05, 51-10-03, PAR 21, 14.AND ER/A 487747-14MA REV.A, 493648-14MA REV.A.SDR DALA2016101707289Pan · crackedCRACKED RT WINDOW RING PAN FWD & LOWER CORNER AT BS 984, 1041, 1079 AND 1098. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02, 51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14 MA REV.A, 493648-14MA. REV. A.SDR DALA2016101707288Pan · crackedCRACKED THE RT WINDOW RING PAN FWD & LOWER CORNER AT BS 598, 788, 845 AND 1174. REPAIRED IAW SRM 53-05 FIG. 122, 51-30-02 , 51-30-05, 51-10-03, PAR 21, 14 AND ER/A 487747-14MA REV. A, 493648-14MA REV.A.SDR DALA2016101707287Cusp Web · crackedA CRACK WAS FOUND ON THE LT CUSP WEB BS 275, X 49. THE CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG. 131A-15.SDR DALA2016101707286Floor Panel · damagedFLOOR PANEL DAMAGED. REPLACED THE FLOOR PANEL IAW AMM 53-20-01-201 AND AMM 25-00-00-201.SDR DALA2016101707285Pan · crackedCRACK FOUND ON THE RT WINDOW RING PAN FWD UPPER CORNER AND THE AFT LOWER CORNER BETWEEN BS 886 AND 905. THE RING PAN WAS REPAIRED IAW ER/A 333615-14MA REV. G.SDR DALA2016101707284Seat Track · corrodedCORROSION ON RT SEAT TRACK AT X -22 BETWEEN BS 270-273. THE SEAT TRACK WAS REPAIRED IAW SRM 53-05 FIG. 4F, 51-10-3 PAR. 21, 14, 51-10-4 AND 51-30-1.SDR DALA2016101707283Beam · crackedCRACKED AFT END OF BEAM 1 AT THE FWD SERVICE DOOR. THE BEAM WAS REPLACED IAW SRM 51-30-2.SDR DALA2016101707282Doubler · corrodedCORROSION ON DOUBLERS BETWEEN BS 1174 AND 1212, X 54-60. REPLACED THE DOUBLERS IAW SRM 53-05 FIG.131A-8 AND SRM 51-30-5.SDR DALA2016101707281Intercostal · crackedCRACK ON PREVIOUS REPAIR DOUBLER OF INTERCOSTAL BA 1355, X -24. THE INTERCOSTAL WAS REPAIRED IAW SRM 53-01 FIG.2.SDR DALA2016101707279Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR PARTS OF LT CUSP WEB BETWEEN BS 598 - 617, X=44-X=60 . REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-5, AND 53-05 FIG 131A-24.SDR DALA2016101707278Cusp Web · corrodedCORROSION OUT LIMITS ON RT CUSP WEB X -54 TO -60, BS 598 - 610. REPAIRED IAW SRM 53-05 FIG 131A-14.SDR DALA2016101707308Battery Pack · inoperativeLEFT AND RIGHT FWD OVERWING EXIT LIGHTS INOPERATIVE DURING TEST. REPLACED THE BATTERY PACKS. CHECKED GOOD.SDR DALA2016101707301Handle · looseTAILCONE INTERIOR RELEASE HANDLE. FOUND THE HANDLE FWD RETENTION CLIP DAMAGED. REMOVED AND REPLACED INTERIOR RELEASE HANDLE IAW AMM 25-62.SDR DALA2016101707300Support Frame · crackedTAILCONE SUPPORT FRAME BS 1510 CRACKED. REPLACED THE SUPPORT FRAME IAW DWG 9911843.SDR DALA2016101707299Support Frame · crackedTAIL CONE SUPPORT FRAME BS 1510 CRACKED. REPLACED THE FRAME IAW DWG 9911843. (LP2726274)SDR DALA2016101707293Connector · disconnectedEMERGENCY LIGHTS AT ROW 25 INOPERATIVE. CONNECTED THE CONNECTOR AND OPS CHECKED GOOD.SDR DALA2016101607277Longeron · crackedCRACKED LONGERON BS 1338, LONGERON 1. LONGERON REPLACED IAW SRM 53-14-3 FIGURE 4, 51-10-3 PAR 14,21, 51-30-5, 51-10-2A, AND 51-10-2.SDR DALA2016101607274Floor Panel · damagedFLOOR PANEL DAMAGED. REPLACED THE FLOOR PANEL IAW AMM 53-20- 01-201.SDR DALA2016101607273Floor Panel · damagedFLOOR PANEL DAMAGED. REPAIRED IAW AMM 25-00-00-801SDR DALA2016101607272Cusp Web · crackedCRACK ON LT CUSP WEB BS 303 AND X= 45. CUSP WEB WAS REPAIRED IAW SRM 53-05 FIG 131A-1.SDR DALA2016101607271Cusp Web · crackedCRACK ON LT CUSP WEB BS 218 X=45. CUSP WEB REPAIRED IAW SRM 53-05 FIG 131A-5.SDR DALA2016101507269Frame · crackedBS 1437 LONGERON 2L FRAME LOWER CAP CRACKED. REPAIRED IAW ERA 551781-14 REV ORIG.SDR DALA2016101707306Doubler · wornAFT LOWER DOUBLER OF THE FWD CARGO DOOR FOUND WORN. THE DOUBLER WAS REPLACED IAW ERA 486624-14 MA REV ORIG.SDR DALA2016101507268Longeron · crackedCRACKED LONGERON 16R BS 1437. THE LONGERON WAS REPLACED IAW SRM 53-14-4 FIG 4, 51-30-2 AND 51-30-5.SDR DALA2016101407267Connector · damagedEMERGENCY LIGHT INOPERATIVE AT 12D. PINNED THE CONNECTOR IAW SWPM 20. OPS CHECKED NORMAL.SDR DALA2016101407244Pan · crackedCRACK ON LT WINDOW RING PAN LOWER FWD CORNER BS 845 AND 864. THE PAN WAS REPAIRED IAW ER/A 333615-14MA REV. G.
Back to Mcdonnell Douglas MD-88