Service difficulty reports
1,771,708 reports of malfunctions and defects, newest first. Air carriers must report; 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' 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' 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 SWAA2025122651208Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK BS 685+2, RBL 50. THE SEAT TRACK REPLACED & RESOLVED ON TTG8Q019B8R6.SDR SWAA2025122651209Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK BS 685+7, RBL 50. THE SEAT TRACK REPLACED & RESOLVED ON TTG8Q019B8R6.SDR SWAA2025122651210Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK BS 706+14, RBL 50. THE SEAT TRACK REPLACED & RESOLVED ON TTG8Q019B8R6.SDR SWAA2025122651211Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK BS 727+8, RBL 50. THE SEAT TRACK REPLACED & RESOLVED ON TTG8Q019B8R6.SDR SWAA2025122651212Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK AT BS 727+11, RBL 50. THE SEAT TRACK REPLACED & RESOLVED ON TTG8Q019B8R6.SDR SWAA2025122651213Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK AT BS 727A+5, RBL 50. THE SEAT TRACK REPLACED & RESOLVED ON TTG8Q019B8R6.SDR SWAA2025122651196Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK BS 727H+2, RBL 50, SEAT TRACK REPLACED AND RESOLVED ON TTG8Q019B8RP.SDR SWAA2025122651222Seat Track · corrodedCORROSION ON RT OTBD SEAT TRACK, BS 827+19, RBL 50. SEAT TRACK REPLACED AND RESOLVED ON TTG8Q019B8RP.SDR IPXA2025121067021Door · bindingCREW ENTRY DOOR DIFFICULT TO OPEN AND APPEARS TO BIND IN FANNIE HANDLE DOES NOT STAY UP IN ELEVATED POSITION. UNSURE OF WHERE IT IS CATCHING. INSTALLED L1 DOOR REF AMM 52-11-11/401 UP TO AND 2 F (8).SDR SWIA2025122400010Shim · wornFWD PASSENGER DOOR FWD SERRATED SLIDE SHIM IS WORN. REMOVED AND REPLACED FWD PASSENGER DOOR FWD SERRATED SLIDE SHIM. REF EMB 175 AMM 53-10-21.SDR CALA2025122412429Skin · crackedCRACK FOUND ON RT HORIZONTAL STAB LOWER SKIN AT HSS 120.30, INBD ROW, 11 INCHES FROM REAR SPAR. CRACK LENGTH: 1 INCH. REMOVED PREVIOUS REPAIR , FABRICATE NEW DOUBLER & INSTALLED NEW REPAIR PARTS IAW SRM 55-10-01-2R-11, REPAIR 11, PAGE 7, TABLE 204.SDR QXEA2025122300371Floor Support · corrodedCORROSION FOUND ON FLOOR SUPPORT BETWEEN FRAMES 19 & 20, S17L. REMOVED AND REPLACED INBD & OTBD DOUBLER FLOOR SUPPORT IAW SRM 51-40-08.SDR SWAA2025121951402Scuff Plate · crackedCRACK ON CENTER SCUFF PLATE IN THE FWD CARGO CUT OUT. REPAIRED THE CENTER SCUFF PLATE IAW SRM 53-30-15-2R-1, REPAIR 1.SDR SWAA2025121951403Scuff Plate · crackedCRACK ON CENTER SCUFF PLATE IN THE FWD CARGO CUT OUT. REPAIRED CENTER SCUFF PLATE ON FWD SERVICE DOOR IAW SRM 53-10-15-2R-1, REPAIR 1.SDR CALA2025121912247Intercostal · corrodedMAIN CABIN AFT WET AREA CORROSION AT INTERCOSTAL BS 947.5-1, RBL 52. R & R THE INTERCOSTAL, BS 947.5 - 927, RBL 52 IAW SRM 51040-02-0G-0, & DWG 147A5760.SDR CALA2025121912245Floor Support · corrodedCORROSION ON AFT WET AREA BS 986+6, LBL45 UPPER FLOOR SUPPORT ANGLE. R & R FLOOR SUPPORT ANGLE STA 986.5 + 6, LBL 45, IAW SRM 51-40-02-0G-0, AND DWG 147A5700.SDR CALA2025121912243Floor Support · corrodedCORROSION AT AFT WET AREA BS 986+6, RBL 45 UPPER FLOOR SUPPORT. R & R THE FLOOR SUPPORT BS 986.5 + 6, RBL 45, IAW SRM 51040-02-0G-0, AND DWG 147A5700.SDR CALA2025121912241Intercostal · corrodedEXFOLIATED CORROSION AT AFT WET AREA BS 947 - 960, RBL 50 INTERCOSTAL. R & R THE INTERCOSTAL AT MAIN CABIN AFT WET AREA BS 947.5 - 967, RBL 50 IAW SRM 51-40-02-0G-0, & DWG 147A5760.SDR CALA2025121912239Support Angle · corrodedCORROSION AT AFT WET AREA, LBL 32 BETWEEN BS 982 - 1016 SUPPORT ANGLE. R & R MAIN CABIN AFT WET AREA SUPPORT ANGLE IAW SRM 51-40-02-0G-0, AND DWG 147A5700.SDR CALA2025121912237Support Plate · corrodedCORROSION AT AFT WET AREA BS 1016, RBL30 SUPPORT PLATE. R & R MAIN CABIN AFT WET AREA SUPPORT STRAP AT BS 1016 - 1022, RBL 30 IAW SRM 51-40-02-0G-0, AND DWG 147A5700.SDR HNAA2025121900861Shear Tie · crackedSHEAR TIE CRACKED AT FR26 BTW S15-16L. R & R SHEAR TIE IAW SRM 51-40-02.SDR SWAA2025121750999Wire · cutEMERGENCY EXIT LIGHT ATTACHED TO RT SIDEWALL PANEL 242ZAW, FOUND TO HAVE CUT WIRES. REMOVED AND REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-14-960-802. PERFORMED GOOD EMERGENCY LIGHT OPS TEST IAW AMM 33-51-00-710-801.SDR R61A2025121700527Skin · ground damageFUSELAGE SKIN DAMAGED FROM LAV TRUCK IMPACT ON LH SIDE OF FUSELAGE BETWEEN FRA 79 AND FRA 80 AND STR 26L TO 28L. CUTOUT DAMAGED AREA AND INSTALLED FILLER,DOUBLER AND TRIPLER IAW EMB SRM 53-23-01 REPAIR 10 A AND ETD2025-170-934093A.ALSO REF VP-053394-2025 FOR WSDR AALA202512168348Stringer · corrodedAIRCRAFT WAS GROUNDED: STRINGER AT ROUGHLY BS 285.62 AND STR 26R NEED EVALUATION FOR CORROSION. BARE ALUMINUM EXPOSED AFTER COFFEE SPILL. INSPECTED AREA, NO CORROSION NOTED. TREATED AREA AND REINSTALLED INSULATION, PER AMM 51-00-59 AND AMM 25-80-00.SDR AALA202512169203Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202512161085Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202512169040Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202512168036Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202512161900Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR AALA202512165707Wire · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ON SIDE OF SEAT 36C DOES NOT OPERATE DURING EMERGENCY LIGHTING TEST. MAINTENANCE FOUND A BROKEN WIRE AND REPAIRED IT PER ESPM 20-43-11. A SATISFACTORY OPERATIONAL CHECK WAS AQCCOMPLISHED WITH NO ISSUES NOTED.SDR ASAA2025121062976Snubber · bindingCATERING REPORTS DIFFICULTY OPENING L2 DOOR. GROUNDED - YES. OPENED L2 DOOR FROM INSIDE. INITIAL RESISTANCE FELT FROM SNUBBER. AFTER ACTUATING DOOR OPENED AND CLOSED, NO MORE ISSUES WERE NOTED. OPS CHECK GOOD, RETURNED TO SERVICE.SDR ASAA2025121062957Battery · inoperativeR1 DOOR OVERHEAD EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE. GROUNDED - YES. REMOVED, REPLACED, AND OP CHECKED GOOD R1 DOOR EMERGENCY EXIT LIGHT BATTERY IAW B737-800 AMM 33-51-06-960-805.SDR ANCF20251215038Outflow Valve · faultedVENT SKIN VALVE FAULT AT 4500 FT PROCEDURE DONE AND UNSUCCWAFUL RETURNED TO VUP. IAW AMM 21-26-00-040-002-A STEP 4.A.7.10 POSITION OF THE SKIN AIR OULET VALVE WAS VERIFY TO 45° AFTER DEACTIVATION. WAS FOUND WITH AMBAR XX ON ECAM. SUBSCUENTLY THE SKIN AIR OUSDR SWAA2025121551189Girt Bar · looseR1 DOOR GIRT BAR FITTINGS LOOSE. TORQUED THE R1 DOOR GIRT BAR FITTINGS IAW AMM 25-66-02-400-801.SDR SWIA202512150001Window · crackedCREW REPORTS DURING DEPARTURE FO WINDOW SHATTERED. (FLIGHT 6363) REMOVED AND REPLACED THE FO SIDE WINDOW WITH A SERVICABLE UNIT IAW WORK CARD 56-220-1000 . OPS CK GOOD.SDR R61A2025121000525Sensor · faultedFUEL 1 LOW LEVEL MSG. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED LH FUEL LOW LEVEL SENSOR.SDR DXTA2025121506060Door · out of adjustMAIN CABIN DOOR APPEARS TO IMPACT FWD STRIKE PLATE WHEN CLOSING. APPEARS DOOR SHIFTS AFT WHEN DOOR COMES IN CONTACT WITH STRIKE PLATE. DOOR ALSO REQUIRES PUSH TO OPEN. DOOR DOES NOT FALL OPEN NORMALLY. REMOVED AFT HINGE FWD BUSHING, CLEANED & REINSTALLED. R&SDR DXTA2025121506067Apu · leakingAFTER TURNING ON THE APU AND AIR-CONDITIONING, PACS, STRONG OIL/SMOKE ODOR FROM AIR-CONDITIONING. NOTICED IN COCKPIT. PERFORMED A BOROSCOPE INSPECTION. PERFORM OPS CHECK OF A/C SYS WITH APU BLEED & VERIFIED OIL ODOR IN COCKPIT. PERFORMED BOROSCOPE INPECTIONSDR DALA2025121509134Spar · damagedER/A 629782-14. REPAIR AT RH REAR SPAR AT XRS 164. C/W WITH ER/A 629782-14. (1345202)SDR DALA2025121509133Spar · damagedER/A 629782-14AD REV ORIGINAL. REPAIR TO RH WING REAR SPAR AT XRS 164. REPAIRED PER ER/A 14-629782. (1345195)SDR DXTA2025121506074Uplock · defectiveAFTER SELECTING THE LANDING GEAR LEVER TO THE DOWN POSITION. WE RECEIVED 2 MAIN GEAR INDICATORS IN THE DOWN AND LOCKED POSITION (GREEN) AND THE NOSE INDICATOR WAS A RED HATCHED BOX. WENT AROUND, PER THE QRH WE CYCLED THE GEAR, RECEIVED 3 GREEN INDICATORS AND DSDR AALA202512155707Light · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT ON SIDE OF SEAT 36C DOES NOT OPERATE DURING EMERGENCY LIGHTING TEST. (OPEN)SDR CALA2025121512136Control Unit · faultyLIGHT ON EMERGENCY EXIT DOOR 21F FLASHING. NEEDS REPLACED VERIFIED LIGHT FLICKERING AT EXIT ROW 21F. OPENED AND COLLARED C/B ON THE P92 PANEL. VERIFIED EMERGENCY EXIT LIGHTING OPERATES NORMALLY. REQ MEL 3302B. TOMC APPROVED C/W MEL 3302B. PLACARD APPLIED. NO SDR CALA2025121512088Floorbeam · corrodedCABIN FLOORBEAM STA 947.5 RBL 50 UPPER SURFACE WITH CORROSION AREA AROUND HARD POINT. CABIN FLOOR BEAM STA 947.5 RBL 50 UPPER SURFACE FOUND CORROSION OUT OF LIMITS REPAIRED IAW B737 SRM 53-70-51-2R-5 AND SRM 51-40-02-0G-0. INSTALLED REPAIR ON CABIN TRANSVERSSDR CALA2025121512086Stringer · crackedFORWARD CARGO STRINGER CLIP AT STA 500I STR26R FWD SIDE IS CRACKED. REMOVED, LOCATED AND DRILLED NEW CLIP STR PN 143A1010-48 PO 1138205.2 & INSTALLED IAW B737 SRM 51-40-05 SRM 51-40-02 BOEING DWG 143A1010 REV A FWD CARGO STRINGER CLIP STA 500I STR 26R.SDR AALA202512143994Striker · inoperativeAIRCRAFT WAS GROUNDED: REPEAT ITEM. COCKPIT DOOR OPEN LIGHT ILLUMINATED ON CLIMB OUT. STAYED ILLUMINATED ALL FLIGHT AND DOOR WAS CONFIRMED CLOSED WITHNO STRIKER LIGHTS. UPON LANDING AND BRAKING, THE DOOR SWUNG OPEN ON THE RUNWAY. THE OPEN LIGHT EXTINGUISHED USDR QMLA2025121320124Line · failedAIRSPEED INDICATOR FAILED IN FLIGHT, REMOVED DASH AND FOUND 1 DISCONNECTED PITOT LINE FROM THE AIRSPEED INDICATOR, R & R PRESSURE PITOT LINE P DHS212-720.20. PREFORMED CHECK OF THE PITOT LINE & AIRSPEED WITH NO DEFECTS NOTED IAW AMM 34-14-00,5-1. AIRSPEED ISDR AALA202512121925Brake · seizedAIRCRAFT WAS GROUNDED: AIRCRAFT PULLS TO THE LT EXCESSIVELY THERE IS A BURNED RUBBER ODOR ON TAKE OFF & LANDING. ACCOMPLISHED INSPECTION OF STEERING CABLE PULLEYS & OPS, IAW AMM 32-51-31. ACCOMPLISHED FULL NLG RIG CHECK. ADJUSTED NGPP-A CABLE TENSION (AALA2025SDR AALA202512128030Strut · underservicedAIRCRAFT WAS GROUNDED: AIRCRAFT PULLS TO THE LT EXCESSIVELY THERE IS A BURNED RUBBER ODOR ON TAKE OFF AND LANDING. ACCOMPLISHED INSPECTION OF STEERING CABLE PULLEYS & OPS, IAW AMM 32-51-31. ACCOMPLISHED FULL NLG RIG CHECK. ADJUSTED NGPP-A CABLE TENSION (AALA20SDR AALA202512128204Landing Gear · out of rigAIRCRAFT WAS GROUNDED: AIRCRAFT PULLS TO THE LEFT EXCESSIVELY THERE IS A BURNED RUBBER ODOR ON TAKE OFF AND LANDING. ACCOMPLISHED INSPECTION OF STEERING CABLE PULLEYS & OPS, IAW AMM 32-51-31. ACCOMPLISHED FULL NLG RIG CHECK. ADJUSTED NGPP-A CABLE TENSION (AALA