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 DALA2016012800691Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016012800690Support · crackedCRACKED AFT INBD FOLLOWER BEARING SUPPORT OF SLAT TRACK NR 5 AT LT WING. BEARING SUPPORT OF SLAT TRACK NR 5 AT LT WING WAS REPLACED IAW AMM 27-80-01.SDR DALA2016012800688Doubler · corrodedCORROSION ON INNER PRODUCTION DOUBLER AT AFT LAVATORY PANEL BS 1287-1309. REPAIR WAS ACCOMPLISHED IAW ERA 541618-14, REV ORIG SECTION I.SDR DALA2016012800687Longeron · cutLONGERON 22L BS 1287-1309 WAS CUT. LONGERON WAS CUT IAW 53-02, F18. SPLICE WAS FABRICATED IAW SRM 53-02, FIG 18. SPLICE WAS TREATED/PAINTED IAW SRM. 51-10-3 PAR 14 AND 21. SPLICE WAS INSTALLED IAW SRM 51-30-5. CIC WAS APPLIED IAW SRM 51-10-3, PAR 38.SDR DALA2016012800686Longeron · corrodedCORROSION ON LONGERON 29L END BS 1338. LONGERON END WAS REPLACED IAW SRM 51-30-5 AND DWG 4917650-1.SDR DALA2016012800685Floorbeam · damagedCORROSION ON REPAIR DOUBLER OF FLOORBEAM BETWEEN X=18 TO X=24, BS 1309 AT FLOOR STRUCTURE CAB. DOUBLER WAS REPLACED IAW SRM 51-10-3, PAR 14, 21 AND 38, 51-30-5 AND 53-05 FIG 20A.SDR DALA2016012700661Connector · disconnectedMAINTENANCE FOUND SEAT ROW 3C EMERGENCY EXIT LIGHTING INOPERATIVE. CONNECTOR AT SEAT 3C WAS FOUND DISCONNECTED AND RESECURED.SDR DALA2016012700659Structure · damagedLEFT HORIZONTAL STABILIZER TIP FOUND DAMAGED. INSTALLED LT HORIZONTAL STABILIZER TIP IAW STANDARD PRACTICES 2040.SDR DALA2016012700664Pan · crackedCRACK ON PAN FWD EDGE BEAM NR 4 AT R1 DOOR. PAN WAS REPAIRED IAW SRM 52-03D, FIG 3, 51-01 PAR 21, 51-30-1, 51-30-4.SDR DALA2016012700663Floor Support · corrodedCORROSION ON LT FLOOR SUPPORT, BS 1322 TO 1338 X 22. FLOOR SUPPORT REPAIRED IAW SRM 53-01, FIG 2.SDR DALA2016012700662Isolator · corrodedCORROSION ON INNER SURFACE OF HOUSING BOLTS ON RT ENGINE AFT VIBRATION ISOLATOR. ON RT ENGINE AFT VIBRATION ISOLATOR WAS CLEANED AND CORROSION WAS FOUND. DUE TO CORROSION REPLACED AND INSTALLED IAW AMM 71-20-02-201 AND PS 900-1-2-1, NR 01.SDR DALA2016012700660Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016012700658Beam · crackedCRACKED BEAM NR 4 FWD EDGE AT FWD SERVICE DOOR. NEW BEAM WAS DRILLED, TREATED, PAINTED AND INSTALLED IAW SRM 51-10-4, 51-10-3 PAR 14/21 AND 51-30-2 AND 51-30-5.SDR DALA2016012700657Cusp Web · corrodedCORROSION ON RT CUSP WEB BETWEEN X=-54 TO X=-60 AND BETWEEN BS 1060-1079, UPPER AND LOWER SURFACE AT CABIN FLOOR STRUCTURE. DUE TO AN EXCESSIVE DAMAGE CUSP WEB WAS REPAIRED IAW SRM 53-05, FIG 131A-7.SDR DALA2016012700656Fitting · corrodedCORROSION ON FRAME FITTING BS 522. FITTING WAS REPLACED IAW SRM 51-10-8, 51-10-3 PAR 14, 21.SDR DALA2016012700655Frame · crackedTAIL INTERIOR, CANTED FRAME WEB BS 1485 HAS A TWO INCH LONG CRACK NEAR SUPPORT STRUCTURE, APPROXIMATELY 8:00 POSITION. REPAIRED BY CUTOUT AND DOUBLER INSTALLATION. ALL REPAIR WORK ACCOMPLISHED AND RECORDED ON PRI 543285-14, REV 0 AND COMPLIES WITH FINAL ERA SDR DALA2016012700654Angle · crackedCRACK FRAME CLIP ON BS 1437 BETWEEN LONGERON 16 - 17R. CLIP WAS REMOVED AND WAS FABRICATED IAW SRM 51-30-5 AND IAW DWG 9911840-75, REV DC AND NEW CLIP WAS INSTALLED IAW SRM 51-30-5.SDR DALA2016012700653Pan · crackedCRACK FWD EDGE PAN WITH BEAM NR 5 OF FWD CARGO DOOR. CRACK ON FWD EDGE PAN WITH BEAM NR 5 WAS REPAIRED IAW SRM 52-03D, FIG 8.SDR DALA2016012700652Floor Panel · corrodedCORROSION ON FLOOR PANEL 160G IN PAX CABIN. THE FLOOR PANEL WAS REPLACED IAW SRM 51-30-2 AND DWG 9957828, REV AB.SDR DALA2016012700651Longeron · corrodedCORROSION ON LONGERON 23L, BETWEEN BS 1287 - 1307. THE LONGERON WAS REPAIRED IAW SRM 53-02, FIG 19, 51-30-2, 51-30-5, AND 51-10-3, PAR 26-21, 14.SDR DALA2016020300822Retainer · crackedCRACK AND WEAR RETAINER SEAL AT FWD CARGO DOOR. RETAINERS WERE FABRICATED IAW SRM 52-33-0, FIG 1.SDR DALA2016012600635Angle · crackedCRACKED FWD CLIP ON BEAM NR 1 AT FWD PASSENGER ENTRANCE DOOR L1. CLIP ON BEAM NR 1 AT FWD WAS REPLACE IAW DWG 9955752, REV K, 51-10-2 51-10-3 PARA 14 AND 21, 51-30-2.SDR DALA2016012600634Structure · damagedWEAR AND BEND FWD AND AFT LOWER EXTERNAL DOUBLERS AT FWD CARGO DOOR. DOUBLERS FWD AND AFT LOWER WERE REPLACED IAW ERA: 486624-14MA, REV ORIGINAL.SDR DALA2016012600633Pan · crackedCRACK FWD EDGE PAN WITH BEAM NR 1 OF FWD CARGO DOOR. CRACK ON FWD EDGE PAN WITH BEAM NR 1 OF FWD CARGO DOOR. WAS REPAIRED IAW SRM 52-3D, FIG 8.SDR DALA2016012600632Attach Angle · corrodedCORROSION ON ANGLE ATTACH LOWER DOOR JAMB OF VENTRAL STAIRWAY BETWEEN 18 TO 18, BS 1350. AREA WAS REPAIRED IAW SRM 53-05, FIG 34 AND 51-10-3 PAR 21 AND 14.SDR DALA2016012600631Floor Support · crackedCRACKED FLOOR SUPPORT JUST NEXT TO 6 PULLEY BRACKET, 18 BS 1348. THE FLOOR SUPPORT WAS REPAIRED IAW SRM 51-10-3, PAR 14 AND 21, 51-30-1, 51-30-2, 51-30-05A AND 53-01, FIG 2.SDR DALA2016012600630Door Frame · wornWEAR ON FWD ACCESSORY COMPARMENT DOOR JAMB. WEAR WAS ATTENDED IAW SRM 51-10-3, 53-01, ER/A 527558-14, REV ORIG.SDR DALA2016012600629Floor Panel · crackedCRACK ON FLOOR PANEL. FLOOR PANEL REPAIRED IAW SRM 53-05, FIG 131B, 51-10-3, PAR 14 AND 21, 21-30-2.SDR DALA2016012600628Floor Panel · delaminatedDELAMINATED FLOOR PANEL 617B. A NEW FLOOR PANEL WAS FABRICATED IAW AMM 53-20-01-201.SDR DALA2016012600627Floor Panel · delaminatedDELAMINATED FLOOR PANEL IN PASSENGER CABIN. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016012600626Beam · crackedCRACKED BEAM NR 1 AFT EDGE AT FWD PASSENGER ENTRANCE DOOR L1. BEAM NR 1 AFT EDGE WAS REPAIR IAW SRM 52-05D, FIG 81, SHEET 3, 51-30-1, 51-10-3 PAR. 14 AND 21.SDR DALA2016012600625Cusp Web · corrodedCORROSION ON PREVIOUS REPAIR DOUBLER AND CUSP WEB BETWEEN BS 446 TO 465 AND X 49 TO X 60. DOUBLER REPAIR WAS REPLACED IAW SRM 51-30-5, PAR 7,8, SRM 53-05, FIG 131A-14, SRM 51-10-3, PAR 14, 21, 38.SDR DALA2016012600624Longeron · crackedCRACKED LONGERON NR 3LT BS 1437. CRACK WAS ATTENDED IAW SRM 51-30-2, 51-10-4, 51-10-3 PAR 21,14, 53-02, FIG 18 51-10-2 AND 51-30-5.SDR DALA2016012600623Pan · crackedCRACK AFT EDGE PAN WITH BEAM NR 1 OF FWD CARGO DOOR. CRACK ON AFT EDGE PAN WITH BEAM NR 1 OF FWD CARGO DOOR WAS REPAIRED IAW SRM 52-03D, FIG. 8.SDR DALA2016012600622Skin · damagedLIGHTNING STRIKE ON EXTERNAL FUSELAGE SKIN, BS 927 BETWEEN LONGERON 1 AND LONGERON 2 RT. LIGHTNING STRIKE ON EXTERNAL FUSELAGE SKIN BS 927 BETWEEN LONGERON 1 AND 2 RT WAS REPAIRED IAW ETI-88-15-444, REV 2 AND ER/A 541593-14AD, REV ORIGINAL. REPAIR IS APPROVASDR DALA2016012600621Frame · corrodedCORROSION ON FRAME, BS 1380 BETWEEN LONGERON 24L TO 24R. FRAME BS 1380 WAS REPLACED IAW SRM 51-30-2, 51-30-5, 51-10-3 PAR 14 AND 21 AND DWG 9912246-115.SDR DALA2016012600620Floor Panel · delaminatedDELAMINATED FLOOR PANEL. FLOOR PANEL FABRICATED IAW AMM 53-20-01-201.SDR DALA2016012600619Longeron · crackedCRACKED LONGERON 7R ON BS 1338 AT INTERNAL CABIN STRUCTURE. LONGERON WAS REPLACED SRM 51-30-2, 51-30-5 AND 51-10-3, PAR 14 AND 21.SDR DALA2016012600618Longeron · crackedCRACKED LONGERON END NR 2L ON BS 1338 AT CABIN PASSENGER LONGERON ENDS, 2EA WERE REPLACED IAW SRM 51-30-2, 51-30-5 AND 51-10-3 PAR 14 AND 21.SDR DALA2016012600617Fitting · crackedCRACKED FITTING ON BS 1350 X -15 AND Z 22 AT AFT PRESSURE BULKHEAD VENTRAL DOOR. FITTING ON BS 1350 X=-15 AND Z=22 AT AFT PRESSURE BULKHEAD VENTRAL DOOR WAS REPLACED IAW DWG 5917579, REV DZ AND SRM 51-10-3B, 51-10-3, PAR 21.SDR DALA1619810916Web · crackedCANTED WEB, BS 1463, NEAR L7L, FWD WEB CRACKED.SDR DALA2016020300823Intercostal · crackedCRACKED INTERCOSTAL FROM BS 1287 TO BS 1307 X=0 AND 1271 TO 1287 X=5 AT PAX CABIN. INTERCOSTAL WAS REPAIRED IAW SRM 53-01, FIG 2 AND 51-10-3, PAR 21 AND 14 OTHER INTERCOSTAL WAS REPLACE ON BS 1287 TO 1307 X=0 WAS REPLACED IAW SRM 51-30-5 AND 51-30-2.SDR DALA2016012500569Wire · shortedTHE CREW ON FLIGHT 1565 FOUND THAT THE EMERGENCY EXIT PATH LIGHTS FROM ROW 31-38 INCLUDING THE CAT WALK WERE INOPERATIVE. MAINTENANCE FOUND SHORTED WIRES AT THE CATWALK ILLUMINATION ASSY L2.845.SDR DALA2016012500573Longeron · crackedCRACK ON LONGERON 4LT BS 160 AT CPAX. CEILING PANEL AT LONGERON 4 LT 160 WAS REMOVED IAW AMM 20-30-01-201, FASTENERS WERE REMOVED IAW SRM 51-30-5, HFEC INSPECTION ACCOMPLISHED IAW DC/MD NDTSPM 06-10-01- 001. NO CRACKS WERE FOUND CEILING PANEL, WAS RE-INSTALLSDR DALA2016012500572Connector · looseMAINTENANCE FOUND SEAT ROW 1 EMERGENCY LIGHT INOPERATIVE. A LOOSE CONNECTOR WAS FOUND AND RECONNECTED. THE LIGHT OPS CHECKED GOOD.SDR DALA2016012500571Wire · brokenMAINTENANCE FOUND THE EMERGENCY LIGHTING INOPERATIVE FROM SEAT ROWS 15 TO 23. A BROKEN WIRE WAS FOUND AT ROW 15 AND REPAIRED. THE LIGHTS CHECKED GOOD.SDR DALA2016012500559Skin · damagedSCRATCH ON RT WINDOW BELT BETWEEN BS 1155 - 1174 UPPER SURFACE. SCRATCHES WERE BLEND OUT FOUND WITHIN LIMITS IAW SRM 53-05, FIG 111 AND ER/A 543131.14, REV ORIGINAL. AREAS WERE TREATED IAW SRM 51-10-03, PAR 21.SDR DALA2016012500558Skin · wornWORN PREVIOUS REPAIR DOUBLER ON HOLD OPEN HOOK AREA AT PASSENGER ENTRANCE DOOR L1. REPAIR DOUBLER WAS REPLACED IAW ERA 486216-14 MA, REV A.SDR DALA2016012500557Beam · crackedCRACKED BEAM NR 8 AFT EDGE AT PASSENGER ENTRANCE DOOR L1. BEAM NR 8 AFT WAS REPAIR IAW SRM 52-05, D FIG 111, SHEET 3, 51-30-1, 51-30-2, AND 51-30-5.SDR DALA2016012500556Doubler · crackedCRACKED AFTER PAN REPAIR DOUBLER BETWEEN FRI 5/6 AT ROLLER TRACK AREA OF FWD ENTRY DOOR. DOUBLER WAS REPLACED IAW SRM 51-30-2, 51-30-1, 51-30-4, 51-10-2, 51-10-3 PAR 14 AND 21 AND DWG 5914121, REV AV.
Back to Mcdonnell Douglas MD-88