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 AALA202512026400Light · no discrepancyAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT ON POWER UP 3R EMERGENCY EXIT SHOWS OPEN ON DOOR PAGE. MAINTENANCE ACCOMPLISHED TSM 52-22-00 AND NO FAULTS WERE NOTED BY MAINTENANCE. NOTE: NO SPECIFIC PART WAS IDENTIFIED BY MAINTENANCE THAT WOULD HAVE CAUSDR SWIA2025120124Skin · dentedEVALUATE DENT MARKED WITH YELLOW DOT ON LH FUSELAGE SKIN ABOVE FWD CARGO DOOR. (C-CHECK RO 11/30/2025)AFTER REMOVAL OF PAINT 3EA DENTS WERE IDENTIFIED WHERE YELLOW DOT WAS LOCATED. 2EA DENTS WERE WITHIN LIMITS OF CRJ 700 SRM 53-00-01-101-001-A01. THE THIRD DSDR DALA2025113008738Frame · damagedDTE ERA 630590-14AD REV ORIGINAL. REPAIR AT FR68 & STR22R, FRAME WEB HORIZONTAL FLANGE IS TIME LIMITED REQUIRING DTE FOLLOW UP PRIOR TO 76,799 TFC. REVISE AND UPDATE ERA 630590-14AD WITH DTE RESULTS PRIOR TO 76,799 TFC. REFERENCE AIRBUS DOSSIER 81694973. ASSOSDR AALA202511286400Warning Message · illuminatedAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED THAT ON POWER UP 3R EMERGENCY EXIT SHOWS OPEN ON DOOR PAGE. (OPEN)SDR AALA202511285291Hinge 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 VNAA2025112811101Heater · odorGALLEY HEATER OVERHEATED AFTER TAKEOFF CAUSING BURNING SMELL. BREAKER CPB-2 B11 POPPED / REMOVED AND REPLACED GALLEY HEATER IAW CRJ900 AMM 21-23-64-000/400-801-A04. OPS TEST GOOD AT THIS TIME.SDR CALA2025112811582Anti-Ice Valve · warning messageANTI ICE ENG2 VALVE OPEN IN FLIGHT CREW REPORTS THEY CYCLED NR 2 ANTI ICE SWITCH SWITCH ON GROUND AND MESSAGE CLEARED. NO MESSAGE ON ARRIVAL AT GATE. REF AMM 30-21-00/001 CONFIG 13SDR CALA2025112811571Fuel Cap · missingFUELERS REPORT, FUEL CAP MISSING. MEL COMPLIED WITH.SDR CALA2025112811566Anti-Ice Valve · faultedR COWL ANTI ICE LIGHT ILLUMINATED ON TO POWER. REDUCE THRUST. ANTI-ICE ON RTO AT 10KTS. COWL TAI VALVE IN THE OPEN POSITION AND DISCONNECTED AND STOWED CONNECTOR IAW DDP FOR MEL 3003D. APPLYING MEL. R & R NR 2 ENG ANTI-ICE TAI VALVE IAW MM 30-21-11-400-801.SDR CALA2025112811565Shutoff Valve · faultedENGINE ANTI-ICE AMBER LIGHT ON NR 2 ENGINE CAME ON. PER CREW ISSUE PRESENTED DURING CLIMB. REF FIM 36-21011 PILOT TRIED TO RECYCLE NO HELP. COMPLIED WITH MEL HPSOV IS DEACTIVATED CLOSED. MAINT PROCEDURE COMPLIED WITH. CB FOR NR 2 COLLARED. MSG INHIBITED. PLASDR CALA2025112811564Sensor · faultyFLAPS WONT EXTEND TO 1LOCK BY TOMC DEBREIFED CREW. LEADING EDGE SLATS DEPLOYED AND WENT GREEN HOWEVER TRAILING EDGE FLAPS WOULD NOT GO TO FLAPS 1 POSITION. INSPECTED WHEEL WELL FLAP TRANSMISSIONS AND NIETHER IS TRIPPED. INSPECTED AREA IN WHEEL WELL AND FOUND NSDR CALA2025112811546Lamp · inoperativeDOOR 4L ESCAPE SLIDE LIGHT INOP RELAMPED DOOR 4L (AFT MOST LEFT DOOR) PER AMM 33-51-06-902-082. OPS CHECKS GOOD.SDR CALA2025112811544Handle · looseON ENGINE SHTDOWN ECAM DOOR R FWD OVERWNG FAULT, FOUND OVERWING HANDLE COVER LOSE. RESECURED, AND PERFORMED CHECK OF DOOR LOCK SYSTEM. NO DEFECTS NOTED IAW AMM 52-22-00.SDR CALA2025112811540Wire Harness · pulledEMERGENCY LIGHTS OPS CHECK, FIRST CLASS FLOOR PROXIMITY LIGHTS INOPERATIVE TROUBLESHOT AND FOUND OPEN FUSE IN EMERGENCY LIGHT BATTERY PACK M2816, ISOLATED EACH FIRST-CLASS SEAT ROWS AND FOUND HARNESS PULLED TIGHT AT SEAT 2B AROUND RECLINE MECHAISM. REROUTED HSDR CALA2025112811539Slide · faultedR1 DOOR EMERGENCY EXIT SLIDE HANGS OUT EXCESSIVELY GIRT BAR AT R1 DOOR SLIDE STOWED PROPERLY. VISUAL INSPECTION SHOWS PROPER MOUNTING WITH NO LOOSE COVER. GIRT BAR SLIDE ATTACHMENT SHOWES NO INTERFERENCE.SDR CALA2025112811538Lamp · inoperativeTWO OF THE RT EMERGENCY SLIDE LIGHTS INOP REMOVED AND REPLACED RT AFT TWO EMERGENCY SLIDE LAMPS IAW AMM 33-51-06-902-082.OPS CHECK GOOD.SDR CALA2025112811537Lamp · inoperativeSEAT EMERGENCY LIGHT ON SEAT 10ABC INOP RELAMPED EMERGENCY LIGHT ON SEAT 10C PER AMM 33-51-18-000-801-C-1, FAILED OPERATIONAL CHECK, FUTHER TROUBLESHOOTING IS NEEDED FOUND DAMAGED WIRE, SPLICED IN NEW WIRE, IN ACCORDANCE WITH AWM 33-51-06 PAGE 900B, AND ESPM 2SDR CALA2025112811535Engine · fodIN CLIMB WITH CLIMB POWER SET EXCESSIVE VIBRATION LEFT ENGINE. 5 .0 VIB WITH FEEL/SOUND.AFTER LANDING IT WAS FOUND AT THE ENGINE NR 1 SIGNALS OF BIRD STRIKE, WITH BLOOD AND STRONG SMELL OF BIRD. AFTER INSPECTION OF BIRD STRIKE REFER AMM 05-51-18-212-001, REMOVSDR CALA2025112811534Filter · cloggedSTRONG ODOR IN DESCENT BELOW 200 IDLE THRUST CAPT STATED SMELL WAS NOT ELECTRICAL BURNING, OVEN BURNING, OIL OR FUEL FUMES. SMELL RESEMBLED DIRTY SOCKS, ACIDIC FOUL ODOR. CABIN CREW DID OBSERVE SMELL OF ANY SORT, STATING CABIN WAS FINE. ODOR CONFINED TO FLIGHTSDR CALA2025112811533Smoke Warning · false activationLAV SMOKE TWICE IN FLT WENT OUT FA SUSPECT OVEN NEXT TO AFT LAV PLEASE MEET CREW WITH SMOKE/ODOR FORMS AND SEND BACK TO TOMC. IN ADDITION, REF AMM TASK 05-51-58-910-801-C1 CONDITIONAL INSP UNLOCKING LOG PAGE REMOVED ITEMS AND CLEANED OVENS. OPS CHECK GOOD, NO SDR DALA2025112708704Power Supply · inoperativeEMERGENCY EXIT SIGNS INOPERATIVE / LOCATIONS:604. REPLACED EPSU AT 3R 16WL AND REINSTALLED EPSU FROM 16WL BACK TO 19WL PER A330 AMM 33-51. (LP 1318814)SDR 2025FA0000788Actuator · warning messageEICAS MESSAGE NOTING RIGHT HAND ELEVATOR HYDRAULIC ACTUATOR FAILURE.SDR SWAA2025112639148Tray · out of adjustPASSENGER SEAT TRAY TABLES DO NOT EXTEND FAR ENOUGH BACK FOR EXIT ROW SEATS AT 14A; 14B; 14C; 14D; 14E; 14F; 13A; 13B; 13C. FOUND TRAY TABLE STOPS IN INCORRECT POSITION FOR 14A; 14B; 14C; 14D; 14E; 14F; 13A; 13B; 13C, R & R TRAY TABLE STOPS TRAY TABLE NOW WSDR SWAA2025112639407Lens · brokenF/O EMERGENCY OVER-WING EXIT LENS BROKEN. R & R EMERGENCY OVER-WING EXIT LENS IAW MM 33-51-00.SDR SWAA2025112639205Handle · out of adjustFWD ENTRY DOOR INNER CLOSING ASSIST HANDLE HAS SHARP PROTRUSIONS. R & R FWD ENTRY DOOR ASSIST HANDLE NUTS IAW AMM 52-11-31.SDR VNAA2025112611102Unknown · odorFLIGHT ATTENDANTS ADVISED US OF A STRONG SMOKE ODOR IN THE CABIN AROUND ROWS 15 AND 16 PRIOR TO LANDING. C/W FIM 21-22-00-810-806-A01. COULD NOT DUPLICATE.SDR CWQA20251126001Oil System · overservicedON DEPARTURE, CREW SMELLED FUMES AND SMOKE WAS PRESENT IN CABIN. CREW DECLARED AN EMERGENCY AND STARTED IMMEDIATE RETURN TO AIRPORT. MAINTENANCE EVALUATION FOUND OIL TANK LEVEL HIGH AND COMPLIED WITH DRAINING OF THE LH AND RH ENGINE UPPER OIL TANK TO A MORE SDR DXTA2025112605823Cable · failedMAIN DOOR CABLE HAS SNAPPED. MAIN DOOR UNABLE TO BE CLOSED USING EITHER THE ELECTRIC MOTOR OR STANDBY PULL HANDLE AT TOP OF STAIRS. REMOVED BROKEN MAIN CABIN DOOR CABLE AND INSTALLED AS RECEIVED NEW MAIN CABIN DOOR CABLE. OPS CHECKS GOOD WITH NO OTHER DEFECTSDR DXTA2025112605836A/C Pack · malfunctionedAFTER LANDING WHILE TAXIING WE HEARD A LOUD GRINDING SOUND AND THE AIRCRAFT COCKPIT/CABIN TEMPERATURE BEGAN TO CLIMB. ALSO HAD A VERY STRONG BURNING SMELL. RECEIVED A "PACK TEMP HIGH" AMBER CAS MSG. REMOVED ACM AND INSTALLED AMM 2142-11 REF. ITEM 4.1 THE SDR DALA2025112608652Snubber · leakingSHIP 6813 NUMBER 4L DOOR SNUBBER LEAKING. CORRECTIVE ACTION: REPLACED L4 DOOR SNUBBER IAW B757 AMM 52-11-00. WILL BE INSTALLED ON JC 186950-0800-0054 STEP 6. JOB COMPLETE. (1321113)SDR DALA2025112608651Snubber · leakingNUMBER 4L DOOR SNUBBER LEAKING. REPLACED L4 DOOR SNUBBER IAW B757 AMM 52-11-00. WILL BE INSTALLED ON JC 186950-0800-0054 STEP 6. JOB COMPLETE. (1320168)SDR DALA2025112608648Handle · brokenWHILE OPENING L1 DOOR, HANDLE BROKE OFF. R & R L1 DOOR HANDLE IAW AMM 52-11. (8219403)SDR DALA2025112608647Floor Support · corrodedCORROSION ON FLOOR SUPPORTS BTW STA 1640 TO 1681, LBL 54 AND RBL 54 AT CABIN FLOOR STRUCTURE. CORROSION LEVEL 2, FLOOR SUPPORT BTW BS 1660 TO 1681 LBL 54 AND FLOOR SUPPORTS BTW BS 1640 TO 1681 RBL 54 AT CABIN FLOOR STRUCTURE WERE REPLACED IAW SRM 51-40 -02SDR DALA2025112608646Floor Support · corrodedCORROSION ON INTERCOSTALS BWT STA 1640 TO 1680 AND BL 0 AT CABIN FLOOR STRUCTURE. CORROSION LEVEL 2, INTERCOSTALS BWT STA 1640 TO 1680 AND BL 0 AT CABIN FLOOR STRUCTURE WERE REPLACED PER B757-200 SRM 51-40-02-0G. (1319409)SDR AALA202511268076Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR JAMMING. MAINTENANCE FOUND THE FLIGHT DECK DOOR CENTER LATCH TENSION ABOVE MAX ENGAGENENT AND ADJUSTED THE LATCH PER AMM 52-51-00. A SATISFACTORY OPERATIONAL CHECK WAS ACCOMPLISHED WITH NO ISSUES NOTED.SDR AALA202511261115Aoa · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CLIMB OUT, CAPTAIN'S PRIMARY FLIGHT DISPLAY ILLUMINATED ON AND OFF WITH SPEED LIMIT, THEN CA'S HORIZONTAL BAR ON FLIGHT DIRECTOR DISAPPEARED AND CAME BACK DURING THE FLIGHT. ALSO, THE MINIMUM SPEESDR AALA202511264002Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR SLIDES NEED LUBRICANT, HARD TO OPEN. LUBRICATED DOOR HINGES AND ROLLER AT LAVATORY-D DOOR.SDR AALA202511262185Door · stuckAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR STUCK CLOSED EVEN WITH THE LOCK IN THE UNLATCHED POSITION. REMOVED AND REPLACED LAVATOR-D DOOR WALL HINGE AND RESECURED HARDWARE. PER CMM 25-40-64.SDR AALA202511262713Light · dislodgedAIRCRAFT WAS NOT GROUNDED: SEAT 19C EMERGENCY LIGHT ASSEMBLY HANGING BY WIRES. SECURED AISLE EMERGENCY LIGHT AT 19C. PER CMM 25-23-67.SDR AALA202511260404Transducer · failedAIRCRAFT WAS GROUNDED: ANTI-SKID INOPERATIVE LIGHT AND AUTO BRAKE DISARM LIGHT ILLUMINATED WITH SWITCH IN THE RTO POSITION. THE ANTI-SKID LIGHT REMAINS ILLUMINATED WHEN SWITCHED TO OFF. REMOVE AND REPLACED NUMBER 2 MLG TRANSDUCER. PER AMM 32-42-11. OPERATIONASDR AALA202511265114Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS GETTING STUCK ON THE TRIM MAKING IT DIFFICULT TO OPEN. ACCOMPLISHED ADJUSTMENT AND CLEANING OF FORWARD LAVATORY DOOR TRACKS. PER AMM 52-50-00. OPERATIONAL CHECK GOOD.SDR AALA202511263222Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY-D INTERIOR LOCKING BOLT DIFFICULT TO OPERATE IN ORDER TO EXIT LAVATORY. LUBRICATED THE DOOR LOCKING MECHANISM ASSEMBLY OF LAVATORY-D. PER CMM 25-40-58.SDR AALA202511263681Thermostat · inoperativeAIRCRAFT WAS GROUNDED: AIR INTERRUPT BACK T MIA DUE TO ABNORMAL BLEED PRESSURE #2 ENGINE. FLIGHTL LANDED OVERWEIGHT WITHOUT INCIDENT, NO EMERGENCY DECLARED. MAINTENANCE REPLACED # 2 ENGINE PRV IAWAMM 36-11-52, PRESSURE TRANSDUCER 8HA IAW AMM 36-11-16, BLEED PRSDR AALA202511264473Bleed Valve · inoperativeAIRCRAFT WAS GROUNDED: AIR INTERRUPT BACK T MIA DUE TO ABNORMAL BL;EED PRESSURE #2 ENGINE. FLIGHTL LANDED OVERWEIGHT WITHOUT INCIDENT, NO EMERGENCY DECLARED. MAINTENANCE REPLACED # 2 ENGINE PRV IAWAMM 36-11-52, PRESSURE TRANSDUCER 8HA IAW AMM 36-11-16, BLEED PSDR AALA202511263637Regulator Valve · inoperativeAIRCRAFT WAS GROUNDED: AIR INTERRUPT BACK T MIA DUE TO ABNORMAL BLEED PRESSURE #2 ENGINE. FLIGHT LANDED OVERWEIGHT WITHOUT INCIDENT, NO EMERGENCY DECLARED. MAINTENANCE REPLACED # 2 ENGINE PRV IAWAMM 36-11-52, PRESSURE TRANSDUCER 8HA IAW AMM 36-11-16, BLEED PRESDR AALA202511260820Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R1 DOOR EMERGENCY SLIDE ACCUMULATOR PRESSURE LOW. MAINTENANCE SERVICED DOOR R1 DAMPER IAW AMM 52-10-00.SDR DXTA2025112605835Battery · inoperativeAFT EMERGENCY LIGHTS WILL NOT EXTINGUISH. EVEN WITH MAIN SHIP BATTERIES PULLED, AND FIVE G RESET SWITCH PRESSED. REMOVED AND REPLACED # 4 EMERGENCY LIGHT BATTERY PN: 6430028-1 SN: E25-11124 WITH NEW UNIT PN: 6430028-1 SN: J25-13986. PERFORMED SATISFACTORY OPSSDR FDEA202511242204Floor Panel · dentedMAIN CARGO COMP. STA 285 TO STA 412 & RBL33 TO RBL54.75 ABOVE FLOOR PANEL 222BFF SURFACE SKIN HAS INDENTATION MARKS. FABRICATED NEW FLOOR PANEL 222BFF, MPN: 141T5856-106, RBL 33- RBL 54.75, STA 285-412 IN REF. TO BOEING DWG 141T5856-106, AND SR67-53-009. SSDR FDEA202511242203Floor Panel · dentedMAIN CARGO COMP. BS 285 TO STA 412 & RBL11 TO RBL33 ABOVE FLOOR PANEL 222AFF SURFACE SKIN HAS INDENTATION MARKS. FABRICATED NEW FLOOR PANEL 222AFF, MPN: 141T5856-107, RBL 11- RBL 33, STA 285-412 IN REF. TO BOEING DWG 141T5856-107, AND SR67-53-009. SEE JPF FORSDR FDEA202511242202Floor Panel · dentedMAIN CARGO COMP. BS 285 TO STA 412 & LBL11 TO RBL11 ABOVE FLOOR PANEL 221CFF SURFACE SKIN HAS INDENTATION MARKS. FABRICATED NEW FLOOR PANEL 221CFF, MPN: 141T5856-105, LBL 11- RBL 11, STA 285-412 IN REF. TO BOEING DWG 141T5856-105, AND SR67-53-009. SEE JPF FOR