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 SCNA20251120447SApu · odorREPLACED APU REF AMM 49-15-11 FUME EVENT IN CABIN.SDR ASAA2025111962623Transition Panel · corrodedRIGHT TRANSITION SIDEPLATE IS CORRODED BETWEEN BS 727G+12 TO 767. GROUNDED - YES. REPAIRED TRANSITION SIDEPLATE BS 727G+12 TO 767 IAW SRM 53-00-53-2R-5. W 1, O .063, R .000, L 3, D .063.SDR ASAA2025111962622Transition Panel · corrodedLEFT TRANSITION SIDEPLATE IS CORRODED BETWEEN STA 727G+12 TO 747+12. GROUNDED - YES. REPAIRED LT TRANSITION SIDEPLATE STA 727F+12 TO 747+12 IAW B737-900 SRM 53-00-53-2R-5. W 1.3, O .040, R .015, L 15, D.025.SDR IPXA2025112537400A/C Pack · odor**SUPPLEMENTAL SDR** ONCE TAKE OFF POWER WAS SET A TERRIBLE DIRTY WET SOCK SMELL FLOODED THE COCKPIT WE TURNED OFF THE RIGHT PACK AND THE FOUL SMELL WENT AWAY. REVERSED DMP AND RAN R/H PACK WITH R/T ENG, AND APU, ISOLATED VARIOUS LINES AND CLEANED WATER SEPARASDR AALA202511257955Placard · missingAIRCRAFT IN BASE MAINTENANCE: R4 DOOR GIRT BAR ARMED INDICATOR ORANGE ARROW IS MISSING FROM FLOOR. MAINTENANCE INSTALLED R4 DOOR GIRT BAR ARMED PLACARDED PLATE ON FLOOR PANEL 262LG PER AMM 53-42-12.SDR JJBA20251125104Gusset · corrodedCENTER GUSSET BTW FR 59-61 FOUND CORRODED. CENTER GUSSET BTW FR 59-61 BLENDED AND FOUND OUT OF LIMIT. CENTER GUSSET BTW FR 59-61 REMOVED AND REPLACED.SDR AALA202511249876Flap Track · lack of lubeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAP INDICATOR SHOWED FLAPS UP WITH A SLIGHT SPLIT BETWEEN THE TWO NEEDLES AND THE FLAP HANDLE AT 15 DEGREES EXTENSION, FLAPS WERE EXTENDED TO 15 DEGREES VIA THE ALTERNATE FLAP SWITCH. AIRCRAFT EMERGENCYSDR AALA202511245820Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EMERGENCY GROUND ILLUMINATION LIGHT INOPERATIVE. REMOVED AND REPALCED BULB. PER AMM 31-51-04.SDR AALA202511248015Sign · brokenAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY CEILING MOUNTED EXIT SIGN BROKEN IN MULTIPLE LOCATIONS. REMOVED AND REPLACED AFT ENTRY CEILING MOUNTED EXIT SIGN ASSEMBLY, OPERATIONAL CHECKED GOOD. PER AMM 33-51-01.SDR SWIA2025112400019Winglet · dentedRIGHT WINGLET AFT DENT ABOVE RIB 9 MEASURING APPROXIMATELY 7.0" LONG 2.5" WIDE AND .070 DEEP.CREATED FROM FORWARD DISCREPANCY. REPAIRED RIGHT WINGLET ABOVE RIB 9 IAW ETD 2025-170-932587 REV. A,SDR JBZA20251124001Fadec · inoperativePILOT EXPERIENCED A NUMBER TWO FADEC FAILURE AND THE RESPECTIVE CAUTION LIGHTS ILLUMINATED, PILOT DETECTED A BURNING SMELL IN THE COCKPIT DIVERTED TO NUT TREE AIRPORT. TROUBLE SHOOTING REVEALED NR 2 FADEC TO BE THE SOURCE OF THE ODOR.SDR CALA2025112411403Unknown · odorSTRONG ELECTRICAL ODOR NOTICED IN THE AREA OF THE MOST AFT GALLEY COMPLEX. ODOR BEGINS PAST THE MED 4L, AFT; (AIRCRAFT HAD BEEN STATIC WITH NO SYSTEMS "ON" FOR APPX 8HRS). NEED TO INVESTIGATE ALL AREAS, INCLUDING ABOVE CEILINGS AND AFT BULK PIT AREA. NOTICED NSDR DALA2025112108523Handle · brokenL4 DOOR EXTERIOR HANDLE MECHANISM BROKEN. REMOVED HANDLE MECHANISM, ADJUSTED AND RE-INSTALLED 4L DOOR HANDLE MECHANISM IAW AMM 52-11. ALL OPS CHECKED GOOD. (7161130)SDR DALA2025112108519Plate · out of limitsFLOOR SETTLEMENT PLATE LBL 65 BTW BS 1010 - 1030 OF CENTER BOX AREA IS OUT LIMITS. CORROSION LEVEL 2, FLOOR SETTLEMENT PLATE LBL 65 BTW BS 1010 - 1030 OF CENTER BOX AREA WAS REPAIRED PER SRM 53-00-13-2R PROCEDURE 2 REPAIR 2. (1311884)SDR DALA2025112108518Seat Track · corrodedCORROSION FOUND IN LEFT OUTBOARD SEAT TRACK CROWN AREA ON BS 690 - 710, & BS 879. CORROSION LEVEL 2, CORROSION ON LEFT OUTBOARD SEAT TRACK CROWN AREA AT PASSENGER CABIN BETWEEN ON STA 640 TO STA 710 AND BETWEEN BS 780 - 879 WAS REMOVED IAW SRM 51-10-02-0G, ASDR DALA2025112108517Strap · crackedCRACKED STABILIZER STRAP BTW BS 365 - 377, 24 LBL FLOOR STRUCTURE LEVEL OF PASSENGER CABIN. THE STABILIZER STRAP WAS REPAIRED IAW SRM 53-00-51-2R, PROCEDURE 12, REPAIR 12. (1312165)SDR F3LA202511210329Floorbeam · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. AFT CABIN WET AREA AT FR68, FLOORBEAM Y765 HAS DEEP CORROSION ON TOP SURFACE AND AROUND ATTACHMENT HOLES. REMOVED AND REPLACED CORRODED FLOORBEAM Y-765 IAW SRM 51-72-911-001 AND EVALUATED IAW SRM 53-SDR F3LA202511210328Web · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. CABIN FWD WET AREA AT FR 21 LT SIDE FLOORBEAM NEXT TO L1 DOOR AFT FRAME HAS CORROSION A LONG TOP SURFACE. REMOVED AND REPLACED CORRODED WEB AT FR21 LT WING IAW SRM 51-72-11-911-001 MX ACTION IS ACCEPSDR F3LA202511210327Engine · leakingODOR & FUME ISSUE STRONG DIRTY SOCK + CHEMICAL SMELL THE WHOLE CABIN SMELL OCCURRED ON FINAL. T/S IAW TSM 05-50-00-810-831-A FOUND #2 ENGINE TO BE THE SOURCE OF THE ODOR, FAN SHAFT COVER SEAL LEAKING. REMOVED AND REPLACED FAN SHAFT COVER SEAL IAW AMM 72-15SDR DALA2025112108511Hinge Fitting · wornWEAR WAS FOUND ON THE RH MLG DOOR FWD HINGE FITTING AT THE FWD LUG, FWD FACE AND THE FLANGED BUSHING WAS FOUND DAMAGED. REPAIRED PER ERA 630159-14. (1311751)SDR VNAA2025112111101Controller · faultedLT PACK TEMP CAUTION AT 26,000 CLIMBING. RAN QRH AT 30,000. RT PACK TEMP CAUTION. BEGAN DESCENT AND RAN QRH. CABIN ALT CAUTION THEN WARNING. RAN QRC/QRH. CABIN O2 MASKS DEPLOYED IN FLIGHT. / REMOVED AND REPLACED LEFT ACSC IAW CRJ700 AMM 21-61-04-000/400-801-A0SDR DALA2025112108504Skin · damagedNOTED DAMAGE TO SKIN AFT OF RUDDER (M)(P). SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0233:2721-2001/001 00405 COMPLIED WITH PRI 629357 REV 0, 1, AND ERA 629357-14 REV B.SDR AALA202511211244Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR ASSIST BOTTLE PRESSURE IS LOW. MAINTENANCE SERVICED L2 DOOR ASSIST BOTTLE IAW A319 AMM 52-10-00.SDR AALA202511218508Latch · stickingAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR VERY DIFFICULT TO OPEN. TOP LATCH NOT FULLY OPENING WITH HANDLE ROTATION. FLIGHT CREW HAD TO USE FINGER TO PULL LATCH TO LEFT ENOUGH TO RELEASE LATCH. MAINTENANCE REPLACED FLIGHT DECK DOOR UPPER LATCH ASSEMBLY AND ACCOMPSDR DALA2025112108501Frame · damagedFRAME 64, S1R. ELONGATED HOLES AND TOOLING DAMAGE. REPAIRED PER ERA 626729-14 REV A. (1312341)SDR FDEA202511192195Girt Bar · fodR1 DOOR SLIDE WILL NOT ARM. ECAM SLIDE INDICATION SYSTEM FOR R1 DOOR - INOP. DOOR ESCAPE SLIDE ARMING SYSTEM IS TO BE VERIFIED AS FULLY ARMED PRIOR TO EACH DEPARTURE.MSN DID A GVI OF GIRT BAR FOR DEBRIS & OPERATION IAW AMM 25-61-21-04, NO DEFECTS NOTED. SDR AALA202511217847Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE, LOCATED IN RT ECS BAY, AT BS 663.5 S22R. REPLACED THE ATTACH ANGLE IAW AARD 51-00-05-1.SDR AALA202511212014Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.5, S22L. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202511210899Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER SECTION REAR SPAR VAPOR BARRIER ATTACH ANGLE AT BS 663.5, S22L. REPLACED ANGLE PER AARD 51-00-05-1.SDR UIEA2025111901313Duct · damagedBLEED 2 DUCT LEAK RH STATUS MSG. R & R R4 PDU PNEUMATIC DUCT IAW AMM 27-81-03-002-001. OPS & LEAK CHECKED OK.SDR UIEA2025111901316First Aid Kit · openFIRST AID KIT FOUND WITH BROKEN SEAL(<P>REMOVED AND REPLACED FIRST AID KIT AT AFT FLIGHT ATTENDANT STATION IAW AMM 25-64-03. NO FURTHER DEFECTS NOTED</P>)SDR CALA2025112111402Processor · faultedREPEAT ISSUE, RT TANK QTY STUCK AT 6.93 FOR 30 MINS IN CRUISE & THEN RAPIDLY DECREASED. PERFORMED BITE TEST OF THE FQIS, TESTED GOOD, AS A PRECAUTION, REMOVED AND REPLACED WITH A NEW FUEL QUANTITY PROCESSOR UNIT IAW TASK 28-41-81-000-801, AND TASK 28-41-81-4SDR CALA2025112111378Girt Bar · no discrepancyR1 GIRT BAR FABRIC SOMEHOW NOT LINED UP, CAUSING ISSUES DISARMING GRAY FABRIC NEED PUSH, LEFT. PERFORMED INSPECTION OF GIRT BAR FABIC & FOUND Z-FOLD REQUIRED TO BE REPERFORMED IAW AMM 25-66-01. RECHECKED ARMING AND DISARMING OF DOOR 1R WITH NO DEFECTS FOUND PSDR CALA2025112111377Anti-Ice Valve · no discrepancyTIA VALVE LIGHT WITH EICAS WHEN THRUST IS BELOW 30 N1 ON TAXI NORMAL INDICATION PER CONDITIONS DESCRIBED. NO FURTHER ACTION NEEDED. IAW AMM 30-21-00.SDR CALA2025112111376Slide · no discrepancyFA REPORTS THAT FWD GALLEY SVC DOOR SLIDE NEED TO BE REPACKED. FA QUESTIONED R1 DOOR LATCH BRACKET ASSEMBLY. NO ISSUES WITH GIRT MATERIAL AND LATCH BRACKET ASSEMBLY IAW AMM 25-66-01-601-804.SDR CALA2025112111375Gauge · no discrepancyR2 DOOR SLIDE GAUGE IS NOT READABLE. R2 DOOR SLIDE GAUGE IS IN THE GREEN BAND AND READABLE.SDR QXEA2025112000347Brake · seizedFLIGHT 2099. WHILE TAXIING, AIRCRAFT PULLS RIGHT SIGNIFICANT POWER IS NEEDED TO TAXI RIGHT INBD BRAKE TEMP INCREASES WHILE TAXIING NO BRAKE OVERHEAT EICAS MESSAGE. REMOVED FROM SERVICE. INSPECTED RT INBOARD BRAKE FOUND BRAKE SEIZED. REMOVED RT INBOARD BRAKE ASDR SWAA2025112036811Pump · leakingLOSS OF A HYDRAULICS QUANTITY ZERO R & R SYSTEM A EMDP PUMP IAW AMM 29-11-21-000 IAW SUB TASK 729-PRD-01-01.SDR SWAA2025112037150Actuator · leakingLOSS OF A HYDRAULICS, QUANTITY ZERO. R & R SYSTEM A ED PUMP IAW AMM 29-11-21-000 IAW SUB TASK 729-PRD-01-01. REMOVED & REPLACED THE NR 1 OTBD GROUND SPOILER ACTUATOR OPS AND LEAK CHECK GOOD IAW AMM 27-62-94. LEAK CHECKED EMDP AND EDP HYDRAULIC PUMPS AND FSDR SWAA2025112036885Unknown · odorCABIN HAS ACRID BURNING SMELL. PERFORMED CABIN FUME CONDITIONAL INSPECTION IAW AMM 05-51-56. NO ODORS NOTED AT THIS TIME.SDR GTIA2025112039186Skin · puncturedPENETRATION DAMAGE FOUND ON CROWN SKIN AT FRAME 49-50 STRINGERS 5L-5R. RAF-01 3072220-01 CREATED. -REF W/O 346076 ON LOGPAGE 3072221-2 FOR PERMANENT REPAIR.SDR ASAA2025111961783Battery · inoperativeWHILE PERFORMING EMERGENCY LIGHTING SYSTEM TEST TASK CARD. FOUND 4R EMR LIGTHS INOP. NEED TO R&R WCU BATTERY @ 4R. GROUNDED - YES. REMOVED AND REPLACED 4R WBU PER AMM 33-51-07. OPS CHECK GOOD. OK FOR SVC.SDR ABXA20251119303Escape Rope · unsecureCAPTAIN'S ESCAPE ROPE WILL NOT STAY STOWED. STOWED CAPTAINS ESCAPE ROPE IAW B767 AMM 25-61-02.SDR FDEA202511192192Wire · shortedDURING PREFLIGHT FOUND ALT EXT CONT C.B. FOUND POPPED. T/S PER AWDG 32-35-11. WITH C/P DISCONNECTED ON HYD PRESSURE SWITCH IN NOSE WHEEL WELL. C/B STAYS IN. NIS ON PRESSURE SWITCH. AMM: 32-35-51-4 PRESSURE SWITCH S10366 CONNECTOR D4360 JUMPERED CONTACTSDR FDEA202511192191Floor Panel · dentedMAIN CARGO COMP. AT APROX BS 300 ABOVE FLOOR PANEL 222BFF RBL33 TO RBL54.75 SURFACE SKIN HAS INDENTATION. FABRICATED NEW FLOOR PANEL 222BFF, MPN: 141T5856-106, RBL 33- RBL 54.75, STA 285-412 IN REF. TO DWG 141T5856-106, AND SR67-53-009. SEE JPF FOR ALL SDR FDEA202511192190Lamp · inoperativeR1 DOOR SLIDE LIGHT INOPERATIVE. RELAMPED R1 DOOR SLIDE LIGHT IAW AMM 33-51-06-2. OPS CHKD SERVICEABLE.SDR VNAA2025112011101Selector Valve · faultedSTEERING INOP CAUTION AFTER ROTATION. / REMOVED AND REPLACED LANDING GEAR SELECTOR VALVE IAW CRJ-900 FIM 32-51-50-810-801 AND AMM 32-32-10-000/400-801. OPS TEST GOOD AND LEAK TEST GOODSDR DXTA2025112005757Battery Pack · weakWHILE IN FLIGHT CABIN EMERGENCY LIGHTS TURNED ON AND OFF CONTINUOUSLY. REMOVED AND REPLACED BATTERY 1 & BATTERY 2 IAW AMM 33-52-00. OPS CHECK GOOD.ESDR DXTA2025112005770Battery · inoperativeDURING CLIMB EMER LIGHTS ILLUMINATED WITH THE EMER LT SWITCH IN THE ARM POSITION. AFTER SOME TIME, THEY BEGAN FLICKERING SPORATICALLY. REMOVE FAULTY FORWARD EMERGENCY LIGHT BATTERY & INSTALLED NEW FORWARD EMERGENCY LIGHT BATTERY. REMOVE FAULTY AFT EMERGENCY SDR DALA2025112008497Light · damagedEMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP. ATTACHED WOTH 2-SIDED TAPE AND NO LONGER MOUNTED TO SEAT. NEEDS TO BE REMOUNTED. SECURED AS REQUIRED. (LP: 1311690)