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 SWAA2025091112683Lamp · inoperativeEMERGENCY EXIT SIGN CAPT SIDE INOP. R & R EMERGENCY EXIT SIGN LAMP IAW AMM 33-51-01.SDR SWAA2025091112635Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED, REPLACED AND PERFORMED A GOOD TEST OF THE R2 DOOR EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-04.SDR SWAA2025091112687Access Panel · looseACCESS PANEL FOR EMERGENCY EXIT ROW DOOR 14 CAPT SIDE FALLING OFF. RESECURED L/H FWD EMERG. EXIT DOOR LANYARD COVER & INSPECTED DOOR PER AMM 52-22-00 & NO DEFECTS FOUND.SDR DALA2025091106719Cover · looseEMERGENCY EXIT SIGN COVER LOOSE / LOCATIONS:606. RESECURED SEAT 27F COVER. (1188969)SDR GTIA2025091139071Engine · odorAFTER START OF DESCENT FA'S REPORTED SMELL OF ROTTEN EGGS IN AFT CABIN W/ PACK 2 OFF. DESCRIPTION OF ODOR/FUMES: TEMPORARY, BODY ODOR/BIOHAZRD SMELL. APPARENT CABIN SOURCE: UNKNOWN. MID CABIN AND AFT CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.SDR GTIA2025091139070Unknown · odorCABIN ODOR IN FLIGHT. AIR QUALITY FORM SUBMITTED. DESCRIPTION OF ODOR/FUMES: CONTINUOUS AND DISCOMFORTABLE, DIRTY SOCKS/MUSTY DRY/ BODY ODOR/ BIOHAZED/WASTE SMELL. APPRENT CABIN SOURCE: UNKNOWN. FWD CABIN/GALLEY(LAV), MID CABIN, AND AFT CABIN/GALLEY(LAV). NO VSDR 8G9R202509110001Pump · making metalHYDRAULIC SYSTEM FOUND CONTAMINATED WITH METAL FROM FAILED L/H ENGINE-DRIVEN HYDRAULIC PUMP.SDR AALA202509110859Control Unit · faultedAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED RIGHT BRAKE HARD SHUTTER WHILE BRAKING AT SLOW SPEEDS 1-3 KNOTS. MAINTENANCE REPLACED THE #4 MAIN LANDING GEAR TACHOMETER PER AMM 32-42-57 (AALA202509111082) AND BSCU PER AMM 32-42-34. (AALA202509110859) A SATISFACTOSDR AALA202509118803Striker · faultedAIRCRAFT WAS NOT GROUNDED: THE FLIGHT DECK DOOR WILL NOT OPEN WITH HANDLE ON THE DOOR FROM INSIDE OF THE FLIGHT DECK, IT WILL ONLY OPEN WITH FLIGHT DECK DOOR SWITCH. MAINTENANCE FOUND A FAULT MESSAGE FOR THE BOTTOM STRIKER DUE TO PIN #6 BEING DAMAGED AND REPLASDR AALA202509111082Tachometer · faultedAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED RIGHT BRAKE HARD SHUTTER WHILE BRAKING AT SLOW SPEEDS 1-3 KNOTS. MAINTENANCE REPLACED THE #4 MAIN LANDING GEAR TACHOMETER PER AMM 32-42-57 (AALA202509111082) AND BSCU PER AMM 32-42-34. (AALA202509110859) A SATISFACTOSDR AALA202509116122Spring · brokenAIRCRAFT IN BASE MAINTENANCE: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER UPPER SPRING BROKEN. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14-400-001-B,SDR AALA202509111291O-Ring · leakingAIRCRAFT WAS GROUNDED: YELLOW HYD SYS RSV LOW. AIR INTERRUPTED BACK TO PHL. NO EMERGENCY DECLARED. THE AIRCRAFT WAS NOT OVERWEIGHT FOR LANDING. THE FLIGHT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND BAD O-RING/FITTING CRACKED AT ALT BRAKE DISTRIBUTION DUALVALVESDR CALA2025091108793None · noneBIRD STRIKE ON RADOM. PERFORMED BIRD STRIKE INSPECTION. AND INSPECTIONS, INCLUDING RADOME, NO DELAMINATION OR DAMAGE FOUND.OK TO CONTINUE.REF AMM TASK 05-51-18-212-001SDR CALA2025091108756None · noneRIGHT OVERWING SLIDE INFLATION BOTTLE PINNED FOM, REMOVED PIN, REACTIVATED RH BOTTLE REF AMM 25-62-00-081-001-A. VERIFIED REMOVAL OF THE PIN FROM THE R/H OFF WING SLIDE BOTTLE IN REF TO AMM 25-62-00-061-001-A.SDR CALA2025091108754Control Panel · malfunctionedLIGHT ON PANEL 2L INOPERATIVE, CONFIRMED LT CONTROL PANEL AT L2 DOOR WOULD NOT COMMAND THE AFT ENTRY LIGHTS ON. RESET CONTROL PANEL. AFT ENTRY LTS NOW COMMAND NORMAL. IAW AMM 33-21-00-710-801SDR TAMF20250910053Engine · bird ingestionDURING THE PREFLIGHT WALKAROUND INSPECTION, EVIDENCE OF A BIRD STRIKE WAS IDENTIFIED ON ENGINE 1. DURING THE BORESCOPE INSPECTION OF ENGINE 1, DAMAGE WAS IDENTIFIED ON STAGE 1 OF THE INTERMEDIATE PRESSURE (IP) COMPRESSOR. THE REPLACEMENT OF ENGINE 1 IS CURRENSDR ASAA2025090860767Light · no discrepancyFA REPORTS WHITE EXIT LIGHT AT 16A REMAINS BRIGHTLY ILLUMINATED IN FLIGHT AND WILL NOT GO OUT. GROUNDED - YES. PERFORMED OPS CHECK IAW AMM 33-51-03. EXIT LIGHT AT 16A OPERATES NORMAL. NO DEFECTS NOTED.SDR WX0A2025091032560Battery · no test(AIRCRAFT NOT GROUNDED) BATTERY FAULT AFTER CAPACITY TEST. REMOVED AND REPLACED EPSU REF WO530669.SDR N6WA2025091001Angle · corrodedCORROSION ON RH ANGLE ON FRAME 939. REPAIRED CORROSION ON RH SUPPORT ANGLE ON FRAME 939 IAW AWATS EO-25-CRJ5-53-264.SDR DALA2025091006684Cover · detachedSHIP 1819 EXIT SIGN COVER MISSING AT 3L. FOUND AND INSTALLED EXIT SIGN COVER. OK FOR SVC (7625268)SDR AALA202509100092Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT DOOR 883 DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509108442Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFTER MAIN CABIN DOOR CLOSED, CIDS PANEL SHOWED L1 DOOR SLIDE DISARMED / CHECK PRESSURE. MAINTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509102220Battery · no testAIRCRAFT WAS NOT GROUNDED: L1 FLIGHT ATTENDANT SEAT RIGHT HAND SIDE EMERGENCY FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202509103898Door · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO OPEN AND CLOSE. MANITENANCE ADJUSTED THE FLIGHT DECK DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-51-00.SDR AALA202509105825Strap · out of positionAIRCRAFT WAS NOT GROUNDED: FORWARD RIGHT GALLEY DOOR HAS SLIDE STRAPS HANGING DOWN. MAINTENANCE RESTOWED SLIDE STRAP FWD RT GALLEY DOOR, CKS OK PER AMM 25-62-50.SDR UIEA2025090801169Hook And Loop · damagedHOOK AND LOOP FOR EVAS ON CAPT SIDE NEEDS TO BE ATTACHED. EVAS IS SECURED WITH BOLTS. NO HOOK AND LOOP ON EVAS IAW AMM 25-60-99. NO FURTHER DEFECTS NOTEDSDR CALA2025091008738Elec Connector · damagedB SIDE HYD OVHT LIGHT ILLUMINATED. FOUND ELEC HYD PUMP B CONNECTOR (D2666) DAMAGED. REMOVED ALL OLD CONTACTS AND RETERMINATED ALL WIRES WITH NEW CONTACTS AND INSTALLED IN CONNECTOR D2666 IAW WDM 29-11-12-1 & VERIFYING CONTINUITY BACK TO R318 IN THE P91 PANESDR CALA2025091008736Floor Support · corrodedCORROSION AT AFT CARGO PIT FLOOR S TRINGER STA 1330 LBL 11 UNDER THE NUTPLATES. FLOOR SUPPORT WAS REPAIRED IAW SRM 53-00-53-2R.SDR CALA2025091008735Floor Support · corrodedCORROSION AT AFT CARGO PIT FLOOR SUPPORT BS 1330 LBL 8 UNDER THE NUTPLATES. FLOOR SUPPORT REPAIRED IAW SRM 53-00-53-2R.SDR CALA2025091008732Floorbeam · corrodedCORROSION FWD WET AREA AT FLOORBEAM STA 344 LBL 57. REMOVED CORROSION AT FWD WET AREA FLOORBEAM STA 344 LBL 57" IAW SRM 51-10-02-0G-0-.MEASURED THE AREA,ORIGINAL MATERIAL 0.175, MATERIAL LOSS 0.112", MATERIAL REMAINING 0.063", FOUND TO BE OUT OF LIMITS IAWSDR CALA2025091008729Floor Support · corrodedCORROSION AT AFT CARGO PIT FLOOR SUPPORT BS 1330 RBL 3 UNDER THE NUTPLATES. FLOOR SUPPORT WAS REPAIRED IAW SRM 53-00-53-2R.SDR CALA2025091008728Wire · burnedMAIN EQUIPMENT CENTER AT BS 395 RT UPPER POWER FEEDER IS BURNED. REMOVED AND REPLACED POWER FEEDER WIRE W3412-0003-210 AND W3412- 0010-210 IAW WDM 24-21-21 AND SWPM 20-10-21 21-30-13 AND 20-10-20 T97654 OPS CHECK OK IAW AMM 71-00-00-795-032 -R03.SDR CALA2025091008726Fan · faultedNOTICED BURNING SMELL COMING FROM UPPER VENT BY COCKPIT ENTRY DOOR AND AMBER 'FAN' WARNING ON AIRCONDITIONING ECAM PAGE COMPLETED CABIN TEMP CONTROL TEST REF AMM TASK 21-21-00-710-052-B AND TEST FAILED. RECIEVED 'RECIRC FAN 2 OR SUPPLY' MESSAGE CREATED SEPERATSDR CALA2025091008724Wire Harness · burnedREF EA3611-01469. ENGINE 2 STRUT, UPPER SURFACE, RH SIDE, BY STA PPS 174.30, WIRE BUNDLE HAS CHAFING AND BURN MARKS. ESDR COMPLETED. REMOVED AND REPLACED POWER FEEDER WIRE W3412-0006-110 ON ENG #2 IAW AND M 24-21-21 AND SWPM 20-10-11 AMM 24-11-20-404-01 2 T011SDR CALA2025091008722Warning Message · false activationCABIN CONTROL PANELS 1L 2L 3L SHOW SMOKE DET MESSAGE NO SMOKE PRESENT IAW FIM 26-14 TASK 811. RESET CSCP MESSAGE CLEARED. NO EVIDENCE OF SMOKE OR ODOR THROUGHOUT CABIN, NO SMOKE RELATED MESSAGES FOUND IN HISTORY.SDR CALA2025091008714Sensor · out of alignmentDOOR R FWD EMER EXIT ECAM. DOOR IND OPEN. PRESS NORMAL PERFORMED RENDER SAFE FOR RT FWD OVERWING EXIT HATCH. SLIDE INDICATION OF HATCH IS DEFECTIVE ON LOWER ECAM, HATCH IS IN THE ARM MODE, EMERGENCY EXIT INDICATION IS DEFECTIVE ON LOWER ECAM DU, HATCH IS COSDR SCNA20250910373Window · arcedARCING ON UPPER INBOARD SIDE OF R1 WINDSCREEN. R&R R1 WINDOW PER AMM 56-11-11. LEAK CHECK AND OPS CHECKS GOOD REMOVED COLLARS AND REST BREAKERS ON P18-3,B1,B3,D1,D2,E1,E2 P6-3 A9,A10 P6-11B,B8,B9 P6-12 B8,B9SDR ASAA2025090860705Battery Pack · no testWHILE WORKING TC 78233001, EMERGENCY LIGHTING BATTERIES FAILED CAPACITANCE CHECKS. LH & RH OWE LIGHTS, L2 DOOR EXIT LIGHTS & 18-26 ABC. GROUNDED - YES. M1694, M1695, M1675 & M1670 POWER SUPPLY BATTERY PACKS REMOVED & REPLACED REF AMM 33-51-00-960-805. OPS CHECSDR QXEA2025090900302Fuel Feed · faultedFLIGHT 2007. AT LOW SPEED FUEL FEED (2) FAULT APPEARED LESS THAN 40% N1. TAKEOFF WAS ABORTED. REMOVED FROM SERVICE. INFO ONLY. RESET FUEL FEED 2 IAW E175 AOM V1 3.8.25 WAS DIRECTED BY CONTROLLER 1034390 & GPM 8.2.2.4 SYSTEM RESTORED. RETURNED TO SERVICE. NO PASDR SWIA2025090900008Thrust Reverser · warning messageLEFT REV UNLOCKED MESSAGE IN FLIGHT. LT REV UNLOCKED IN FLIGHT. RAN QRC AND QRH. IN GRB. IS NOT DEPLOYED. DEFERRED LEFT THRUST REVERSER PER MEL 78-30-1. MX PROCEDURE COMPLIED WITH. PLACARDED AS REQUIRED.SDR SWAA2025090912957Fseu · faultedTRAILING EDGE FLAPS INOPERATIVE. FIM 27-59 TASK 808 CARRIED OUT. OHMED FOR CONTINUITY, SHORTS, INSULATION RESISTANCE & DAR TEST IAW WDM 27-53-21. NO FINDINGS. REPLACED FSEU IAW AMM 27-51-01. OPS CHECKED GOOD.SDR YENA2025090900923Valve · faultedFLT# 8079, BOS-EDI. (ETOPS) "ENG 2 CLS 2 FADEC FAULT ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1)FAULT(S) INDICATED BY ENG (1 AND/OR 2) FADEC ); REMOVED AND REPLACED TURBINE ACTIVE CLEARANCE CONTROL AIR VALVE IAW AMM SDR YENA2025090900922Generator · faultedFLFLT# 842, DUB-BOS. (ETOPS) "AC GEN CLASS II MX MSG ( CLASS II MX MSG - GPCU OR AC GEN ); PERFORMED BITE TEST OF EPGS REF TSM 24-22-00-810-832-A. AC GEN 2 PASS. NO FAULTS. MDDR CLR. MX-4 UPD. PLACARD REMOVEDSDR BAGA2025090900001Pcu · failedRUDDER FAIL AT 30,000 FEET. FOLLOWED CHECKLIST AND LANDED AT NEAREST SUITABLE AIRPORT. LANDED WITH OUT RUDDER. REMOVED AND REPLACED UPPER PCU. ALL RUDDER OPS CHECKS AND PCU AUTO RIGGING CHECKS GOOD.SDR DALA2025090906681Lamp · inoperative(LOG 7836326) LT LOWER AFT FUSELAGE SLIDE EMERGENCY LIGHT INOP. RELAMPED LT AFT LOWER FUSELAGE EMEG SLIGE LIGHT IAW B737 AMM 33-51.SDR DALA2025090906680Plate · corroded(LOG 1188507) CORROSION OUT OF LIMITS ON LH SIDE PLATE BTW STA 727 TO STA 727J, STA 727J TO STA 847 ALSO RH SIDE PLATE BTW STA 727 TO 727J, STA 727J TO 787. LH SIDE PLATE BTW STA 727 TO STA 847 ALSO RH SIDE PLATE BTW STA 727 TO 787. WERE REPLACED AND INSTALLEDSDR DALA2025090906679Wire Harness · damaged(LOG 7390363) DURING SERVICE CHECK FOUND IN SEAT EMERGENCY LIGHT AT 20DE INOP. FOUND HARNESS WIRE DAMAGED. R/R HARNESS FOR EMERGENCY LIGHTS ON SEAT 20DE IAW CMM 25-22-56.SDR DALA2025090906678Frame · not reported(LOG 1187857) ACCOMPLISH AMDS 5311-01251-02A - LEFT HAND STA. 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02. COMPLIED WITH AMDS CARD 5311-01251-02A. INSTALL A NEW SHIM LH SIDE STA. 727 FRAME INNER CHORD S-18A. (AD 2023-06-15) (BOEING SERVICE BULLETIN 737-SDR DALA2025090906677Frame · not reported(LOG 1187828) ACCOMPLISH AMDS 5311-01251-02B - RIGHT HAND STA. 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02. COMPLIED WITH AMDS CARD 5311-01251-02B. INSTALL A NEW SHIM RH SIDE STA. 727 FRAME INNER CHORD S-18A. (AD 2023-06-15) (BOEING SERVICE BULLETIN 737SDR DALA2025090906676Floor Support · damaged(LOG 1187391) ELONGATED HOLE ON FLOOR STRINGER LBL12 PREVIOUS REPAIR BTW STA 727I AND STA 727J AT AFT CARGO COMPARTMENT. PREVIOUS REPAIR ON FLOOR STRINGER LBL12 BTW STA 727I AND STA 727J AT AFT CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 53-00-53-2R PROCED