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 AALA202509170700Lever · misinstalledAIRCRAFT IN BASE MAINTENANCE: R1 DOOR ARMING LEVER YELLOW PAD WITH RME SHOULD BE MOUNTED ON FORWARD SIDE OF LEVER. MAINTENANCE CORRECTLY INSTALLED SLIDE ARMING LEVER PER AMM 52-11-22.SDR AALA202509170709Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT PAX-CREW DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509172835Pin · not seatedAIRCRAFT IN BASE MAINTENANCE: SEAT 20C EMERGENCY LIGHT NOT WORKING. MAINTENANCE CHECKED THE WIRING, FOUND AN UNSEATED PIN IN ONE OF THE PLUGS, RESET PIN INTO CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202509175407Lever · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT ADVISES THAT THE SLIDE DISARM LEVER AT DOOR 3R IS LOOSE. MAINTENANCE RESECURED SLIDE DISARM LEVER PER AMM 52-20-00.SDR AALA202509179806Plate · looseAIRCRAFT WAS NOT GROUNDED: CABIN CREW REPORTED THE R2 DOOR YELLOW PALM PRESS (WITH LETTERS -ARM-) IS LOOSE FROM THE ARMING LEVER. MAINTENANCE TIGHTENED LOOSE NUT ATTACHING ARM PLATE TO DOOR ARMING LEVER.SDR AALA202509176573Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509175148Battery · no testAIRCRAFT WAS NOT GROUNDED: BATERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR YENA2025091700942Outflow Valve · faultedFLT#2260, MAD-BOS. (ETOPS) "AVIONICS SYS FAULT - SKIN AIR OUTLET VALVE ( SKIN AIR OUTLET VALVE (AVIONICS) ); REMOVED AND REPLACED SKIN AIR OUTLET VALVE (22HQ) IAW AMM 21-26-53 OPS CHK OK NO FAULTS NOTED AT THIS TIME A/C OK FOR SVC MDDR CLEARED PLACARD REMOVED SDR SIMA20250916001Glowstrip · discoloredPHOTOLUMINESCENT STRIP FWD OF FIRST CLASS DISCOLORED AND NOT ILLUMINATED. RAR PHOTOLUMINESCENT STRIP FWD OF FIRST CLASS IAW AMM 33-50-21.SDR SCNA20250917379Ring · crackedRH AFT SVC DOOR GIRT BAR STOP RING IS CRACKED. REPLACED RH AFT SVC DOOR GIRT BAR STOP RING WITH A SERVICABLE UNIT. REF AMM 25-66-01.SDR DXTA2025091704988Pin · out of adjustWHEN CLOSING MAIN CABIN DOOR FROM INSIDE HANDLE WILL NOT MOVE DOWN. IT IS STUCK UP. ADJUSTED FORWARD LOWER PIN ROD MECHANISM ALL WORK DONE PER CE 700 AMM 52-10-43 PERFORM SEVERAL OPERATIONAL TESTS OF THE MAIN ENTRY DOOR SUCCESSFULLY ALL WORK DONE PER CE700 AM SDR DXTA2025091704992Light · no discrepancyEXIT LIGHT OVER MAIN CABIN DOOR NOT FUNCTIONING ACCOMPLISHED EMERGENCY LIGHTING ADJUSTMENT /TEST MULTIPLE TIMES WITH EMERGENCY LIGHTING OVER MAIN DOOR FUNCTIONING WITH NO DEFECTS NOTED. ALL EMERGENCY EXIT LIGHT OPS CHECK GOOD WITH NO DEFECTS NOTED AT THIS TIMESDR CALA2025091709004Wing · damagedLEFT WING TIP STRUCK VEHICLE GROUND CREW AND AUTOMATIC PARK CLEA RED PICS INCLUDED. PIC. REMOVED LEFT WINGLET WING TIP IAW 57-31-21-000-801, REMOVED WINGLET LOWER BLADE IN REF TO AMM 57-31-21-000-802 INSTALLED NEW LOWER BLADE TO ORIGINAL UPPER BLADE REF AMM 57SDR CALA2025091709000Floor Support · corrodedEXFOILATED CORROSION BETWEEN STA 947 & STA 967 RBL -50. REMOVED AND REPLACED FLOOR SUPPORT BETWEEN STA 947.5 AND STA 967 RBL 50 IAW SRM 51-40-05-0G-0,SRM 51-40-02-0G-0 AND DWG 147A5760SDR CALA2025091708999Wire Harness · brokenSEAT 24C SEAT TRIM BROKEN OFF. EMERGENCY LIGHT WIRING PULLED OUT. EMERGENCY LIGHT WIRING CONNECTOR PULLED OUT OF SEAT SIDE WIRING HARNESS. CAPPED AND STOWED SEAT SIDE EXPOSED WIRES. REPLACED SEAT TRIM REF AMM 25-21-41, REMOVED AND REPLACED SGL LIGHT FIXTURE SDR CALA2025091708998Lens · brokenEMERGENCY LIGHTS, OPS TEST, ROW 23 WHITE EMERGENCY LIGHT LENS BROKEN. LIGHT OPERATES NORMALY, REPLACED LIGHT ASSY IAW AMM 33-51-11-403-069. OPS CHECK GOODSDR CALA2025091708986Battery Pack · inoperativeSEATS 12-21 ABC AND LT FWD EXTERIOR EMERGENCY EXIT DOOR LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AT SEAT 10 ABC, DADO PANEL LOCATION IAW AMM 33-51-06-960-805, ALL THE LIGHTS AND SIGNS CONNECTED TO THE BATTERY PACK COME ON.SDR CALA2025091608985Light · inoperativeAISLE EMERGENCY PATH MARKING LIGHTS AT 34 D AND 32 F FOUND DAMAGED AND REQUIRE REPLACING. LIGHT STILL OPS AISLE EMERGENCY PATH MARKING LIGHT AT 32F REMOVED & REPLACED IAW AMM TASK 33-51-10-962-105, OP CHECK OKAY. AISLE EMERGENCY PATH MARKING LIGHT AT 34D. RSDR CALA2025091608984Fuse · failedEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. AISLE PATH EMERGENCY LIGHTS ROWS 6ABC, 7ABC, 8ABC, 9ABC, 10ABC, 11ABC INOPERATIVE. REPLACED POWER SUPPLY FUSES ALONG SIDEWALL BEHIND MID LAV IAW AMM 33-51-06-960-804. OPS CK GOOD OF AISLE PATH LIGHTS.SDR DALA2025091606824Pump · failedDE/MISC- DUE TO LOSS OF RIGHT HYDRAULIC SYSTEM QUANTITY. REPLACED RIGHT ENGINE DRIVEN HYDRAULIC PUMP. (LP 7189964)SDR JR2R20250916695Cap · crackedL/H HORIZ STAB TIP CAP END RIB CRACKED IN RADIUS. REPLACEDSDR IPXA2025091628055Coalescer Bag · odorNOTICED AN ODOR AT 11,000 FT DISSIPATED AT 15,000 FT FO SAID IT SMELLED LIKE BURNING RUBBER. REMOVED AND REPLACED NR 2 PACK WATER SEPARATOR CONICAL COALESCER IAW AMM 21-54-04, LEAK CHECK GOOD. DURING ENGINE RUN ISOLATED NR 2 PACK FOR 5 MINS WITH NO NOTABLE OSDR IPXA2025091626914Panel · crackedPANEL 831AZ CRACKED (2 LOCATIONS)SDR IPXA2025091630389Liner · crackedMCD, LINING PANEL 221HW HAS CRACKS, DEFORMED AND BROKEN EDGES. DOT 103-672SDR DALA2025091606803Engine · failedSHIP 3819 - DIV, IFSD, DE - AIRCRAFT DIVERTED TO CVG DUE TO RIGHT ENGINE FAILURE. CORRECTIVE ACTION: METAL FOUND IN TAIL PIPE, ENGINE REPLACED ON LOG PAGE 1197295.SDR JR2R20250916775Spar · gougedR/H WINGTIP, FWD MOUNT FLANGE IS GOUGED ON UPPER AND LOWER SIDES. REPAIREDSDR JR2R20250916774Spar · gougedL/H WINGTIP, AFT UPPER O/B MOUNT FLANGE BUSHING/HOLE IS GOUGED. REPAIREDSDR ABXA20250916228Proximity Switch · defectiveDURING PUSH BACK AFTER ENGINE START STATUS MSG OF LDG GEAR MONITOR CAME ON, AC RETURNED TO THE GATE (BTB), MTX GROUNDED AC AND TROUBLESHOT, USING B767 FIM 32-09. FT 803. REMOVED AND REPLACED PSEU, IAW B767 AMM 32-09-04. AND CLEANED SENSOR S234 AND S235. PERFSDR JR2R20250916772Spar · gougedL/H WINGTIP, UPPER AND LOWER, FWD MOUNT FLANGE IS GOUGED. REPAIRED.SDR FDEA202509161711Skin · crackedMFEC INSPECTION FOUND 01 EA CRACK ON NO.5 SLAT EXTERNAL SKIN FROM O/B TO I/B 3.5 INCHES OF OSCS 732 ON UPPER ROW FASTENERS. 01 EA CRACK ON NO.5 SLAT EXTERNAL SKIN FROM O/B TO I/B 3.5 " OF OSCS 732 ON UPPER ROW FASTENERS REPAIRED AS PER B777 SRM 57-43-01SDR FDEA202509161710Skin · crackedMFEC INSPECTION FOUND 01 EA CRACK ON NO.5 SLAT EXTERNAL SKIN FROM O/B TO I/B 2.5 INCHES OF OSCS 732 ON UPPER ROW FASTENERS. 01 EA CRACK ON NO.5 SLAT EXTERNAL SKIN FROM O/B TO I/B 2.5 " OF OSCS 732 ON UPPER ROW FASTENERS REPAIRED AS PER B777 SRM 57-43-01-2RSDR FDEA202509161709Former · crackedRIGHT WING - LEADING EDGE COMPARTMENT LOWER FORMER AT STATION XOS 559 FOUND CRACK ABOUT 0.4 INCHES. RIGHT WING LEADING EDGE COMPARTMENT LOWER CRACKED FORMER AT STATION XOS 559 REMOVED AS PER MD-11 SRM 51-35-01-0G AND 51-33-01-0G. FABRICATED FORMER AS PER SDR FDEA202509161708Seat Track · wornMAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1674 X= -8.5" CROWN WORN RIGHT HAND SIDE. CABIN - MAIN DECK CARGO COMPARTMENT SEAT TRACK AT STATION 1674 X = -8.5" WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD11 SRM 53-00-52-1A FIGURE 101 ALLOWASDR FDEA202509161707Skin · crackedHIGH FREQUENCY EDDY CURRENT INSPECTION ON CORNER 11 - FUEL ACCESS DOOR FORWARD INBOARD CORNER ON LEFT HAND FIXED LEADING EDGE SKIN FOUND CRACK APPROXMIMATELY 0.4 INCHES AT STATION XOS 610.844. LEFT HAND WING APPROXMIMATELY STATION 610.844 FIXED LEADING EDGSDR FDEA202509161706Skin · crackedFUSELAGE EXTERIOR SKIN APPROXIMATELY LEFT HAND STATION 475, FORWARD OF NOSE LANDING GEAR FORWARD DOOR FOUND CRACK APPROXIMATELY 1.5 INCHES. CRACK AT FUSELAGE EXTERIOR SKIN APPROXIMATELY LEFT HAND STATION 475, FORWARD OF NOSE LANDING GEAR FORWARD DOOR REPAISDR JR2R20250916773Spar · gougedL/H WINGTIP, FWD O/B MOUNT FLANGE IS GOUGED. REPAIRED.SDR JR2R20250916832Fitting · gouged#1 ENGINE I/B AFT EXHAUST COWL HOWS EVIDENCE OF GOUGING. REPAIRED PER ETDSDR CALA2025091608958Slide · deployedDOOR 1L SLIDE DEPLOYED. REPLACED DOOR 1L SLIDE. REF AMM 25-62-44-400-006-A. REPLACED DIAPHRAGM IN THE PERCUSSION MECHANISM. REF AMM 52-10-00-610-001-A. CHARGED THE EMERGENCY OPERATION CYLINDER. REF AMM 52-10-00-614-001-A. ALL OPS CHECK GOOD. AMM 25-62SDR CALA2025091608955Battery · no testEPSU BATTERY FWD L FAULT DURING EMERGENCY LIGHT TEST. R & R FWD LT EPSU BATTERY REF AMM 33-51-38. OPS CHECK PASSED. PARTS USED: 18-3351-3-0001, QTY :1SDR KCSA202509161160Bulkhead · cracked1 FASTENER HOLE NOTED ON LOWER R/H STA 2598 BULKHEAD AFT INNER CHORD HAS CRACK INDICATIONSDR JR2R20250916698Rib · crackedR/H HORIZ STAB, RIB 12 CRACKED ON UPPER FLANGE AT 4TH AND 5TH FASTENER HOLES. REPLACEDSDR JR2R20250916699Rib · crackedR/H HORIZ STAB, RIB 11 CRACKED ON UPPER FLANGE AT 5TH FASTENER HOLE. REPLACEDSDR JR2R20250916700Rib · crackedL/H HORIZ STAB, RIB 12 CRACKED ON UPPER FLANGE AT 4TH AND 5TH FASTENER HOLES. REPLACEDSDR KCSA202509161159Beam · corrodedLH WING TE FIXED TRAILING EDGE BEAM UPPER CHORD @ APPROX WBL 340 CORRODEDSDR JJBA20250916023Battery · inoperative#2 EMERGENCY BATTERY INOPERATIVE. REMOVED AND REPLACED #2 EMERGENCY BATTERY. OPS CHECK GOOD.SDR K11A2025091600339Pump · faultedLOW PRESSURE HYDRAULIC LIGHT ILLUMINATED ON ELECTRIC PUMP #1, "B" SIDE. R AND R SYSTEM "B" EMDP IAW AMM 29-15-22, OPS AND LEAK CHECK GOOD IAW AMM 29-15-00.SDR KCSA202509161158Tension Tie · crackedFOUND CRACK INDICATION IN FRAME AT TENSION TIE STA 1140 L/HSDR 2025FA0000646Intake Duct · rupturedR/H ENGINE MP WILL NOT GO OVER 32 INCHES ABOVE 15,000. PRESSURE TESTED THE RH ENGINE INTAKE SYSTEM AND FOUND THE REAR INTAKE PIPE TORN.SDR IXXA20250916002Skin · corrodedRIGHT WING UPPER SURFACE SKIN CORRODED AT WSTA 204.5, STR 1 AND STR 3 NR 181429-0600-0047 AND REA 47676REA55SDR IXXA20250916001Skin · corrodedRIGHT WING UPPER SURFACE SKIN CORRODED AT AFT SPAR WSTA 177.5 -231.5