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 CALA2025082608159Switch · out of positionTAKEOFF REJECTED AT 75 KNOTS PERFORMED HIGH ENERGY STOP/HEAT DAMAGE CONDITIONAL INSPECTION IAW AMM 05-51-07. NO FINDING. CREW REPORTED T/O WAS TO BLEEDS OFF T/O. A/C ENGINE BLEEDS OUT OF CONFIGURATION FOR BLEEDS OFF TAKE OFF. REJECTED TAKE OFF DUE TO ENGINE BSDR CALA2025082608138A/C Pack · failedPACK R ADVISORY PACK IS FAILED OR MANUALLY SHUT DOWN. FIM TASK REF : 21-50-F2-E0A-421A-A CMC MSG# 2165174 FLIGHT STATUS: L INTERMITTENCE CODE: M PH: CRUISE NARRATIVE: RIGHT PACK CONTROL UNIT CHANNEL 1 R/H PACK BAY OPENED, FOUND MISSING CLAMP AND DUCT JOINT OSDR CALA2025082608133Girt Bar · stuckGIRT BAR DOOR 1R STUCK FOUND GIRT BAR NOT SEATED PROPERLY. RESEATED GRIT BAR. OPS NORMALSDR CALA2025082608131Fuse · blownIN SEAT EMERGENCY LIGHTS FROM ROWS 27 TO 15 INOPERATIVE. T/S PER FIM 33-50 TASK 801. REMOVED AND REPLACED FUSES ON LH MID EMERGENCY BATTERY CHARGER IAW AMM 33-51-06. OPS CHECK GOODSDR CALA2025082608130Light · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. ROW 15CBA EMERGENCY LIGHT INOPERATIVE. R & R ROW 15CBA EMERGENCY LIGHT IAW AMM 33-51-11. OPS CHECKED GOOD.SDR CALA2025082608128Bulb · inoperativeLH FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED BULB IAW AMM 33-51-04.SDR CALA2025082608120Bracket · damagedMAIN E&E COMP BRACKET BETWEEN BS 294.5 - 312, S22L FASTENER HOLES ELONGATED. LOCATED, DRILLED, DEBURRED, TREATED, PRIMED AND INSTALLED NEW BRACKET AT MAIN E&E COMP BRACKET BETWEEN BS 294.5-312, S22L IAW SRM 51-40-05-0G-0, AMM 51-21-72-370-804, AMM 51-21-SDR DALA2025082606325Fitting · leakingFUEL LEAK THROUGH FLAP HINGE BRACE FITTING ATTACHING FASTENERS AT LEFT WING STA XRS=164. LH WING AFT LOWER SKIN DOUBLER AT STA XRS= 164 WAS REPAIRED PER PRI 624486-14 (1157598)SDR HALA20250825260Pressure Switch · faultedETOPS - AFTER ENG 1 START ECAM A ICE L(R) WSHLD HEAT A ICE CAPT FO STBY PITOT HEAT. REMOVED & REPLACED LOW OIL PRESSURE SWITCH IAW AMM 79-34-15. NO DEFECTS NOTED. OK FOR SVC.SDR HALA20250825259Igniter · wornETOPS - DURING IGNITER SEGMENT INSPECTION, FOUND BOTTOM IGNITER PLUG WORN BEYOND LIMITS ON ENGINE #2. REMOVED AND REPLACED BOTTOM IGNITER PLUG PER AMM 74-21-01 ON ENGINE #2. OPS CHECK GOOD. OK TO CONTINUESDR ASAA2025082260347Lens · detachedFORWARD EXIT LIGHT PLACARD FELL OFF. GROUNDED - YES. REMOVED AND REPLACED FWD EXIT LIGHT ASSEMBLY BY L1 DOOR. AS REQ'D, OPS CHECK NORMAL. REF AMM 33-51-01.SDR SWI2025F01119Panel · dentedDUE TO BIRDSTRIKE TO LHS HYD BAY FUSELAGE PANEL, FOUND FORWARD DENTED AREA (NO. 1) MEASURES 5.375" L X 3.875" W X 0.375" MAX. DEPTH AND IS LOCATED BETWEEN THE ELECTRICAL BAY DOOR AND HYDRAULIC BAY ACCESS DOOR, JUST FORWARD OF FS193.00.REF. REO-53-11-2169 FOR DSDR SWI2025F01118Skin · crackedUPON DRESS BACK OF AFT DENTED AREA (NO. 2), OPERATOR REPORTS THAT THE SKIN PANEL WAS CRACKED OVER A LENGTH OF APPROX. 1.25" LONG. ADDITIONALLY, OPERATOR REPORTS THE INTERNAL UPPER STRAP(DWG: CC670-34124, 0.050" NOMINAL THK, REF) TO HAVE BEEN DEFORMED.REF. REO-SDR SWIA2025082500022Panel · dentedDUE TO BIRDSTRIKE TO LHS HYD BAY FUSELAGE PANEL, THE AFT DENTED AREA (NO. 2) MEASURES 11.00" L X 6.00" W X 1.75" MAX. DEPTH AND IS LOCATED BETWEEN FS193.00 - FS202.75 & BETWEEN STR16L - STR21L.REF. REO-53-11-2169 FOR DAMAGE REPORT. (FLIGHT 1300 - FILED OPESDR R61A2025082200378Mau · failedAVNX MAU 1A FAIL. EMERGENCY DECLARED, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED MAU 1 NIC PROC 1.SDR AALA202508253900Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANTS INBD FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202508258274Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT BY FORWARD JUMP SEAT INOPERATIVE. REMOVED AND REPLACED EMERGENCY FLASHLIGHT CHECK GOOD.SDR YENA2025082500876Apu · odorFLT 101, FLL-FLL. APU BLEED ON, SMELLED BURNING. ACCOMPLISHED INFO NOTICE 2017-T015L PERFORMED LVL A ECS DECON. AIR QUALITY CHK GOOD. INSP FUSELAGE & APU NO ACTIVE LEAKS NOTED. APU WILL BE PLACED ON MEL. FOUND IN DIRTY CONDITION. REFER TO L/P 4291003-2..ACCOMSDR IPXA2025082506213Window · inoperativeLEFT FWD WINDOW HEAT INOPERATIVE. R & R L1 WINDOW IAW M/M 56-11-02.SDR DALA2025082506306Frame · damagedSHIP 3406 FRAME 49 AT STR7R FASTENERS 2EA HAVE TOOLING MARKS ON FWD SIDE OF FRAME. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV ORIGINAL. (1157962)SDR DALA2025082506305Frame · damagedSHIP 3406 FRAME 49 AT STR7R BRACKET HAS TOOLING DAMAGE ON AFT SIDE. CORRECTIVE ACTION: REPLACED BRACKET PER DRAWING F539122180000 AND A330 SRM 53-11. (1157958)SDR DALA2025082506304Frame · damagedSHIP 3406 FRAME 49 AT STR7R FRAME HAS TOOLING DAMAGE ON FWD SIDE OF FRAME. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV. ORIGINAL. (1157954)SDR DALA2025082506303Frame · damagedSHIP 3406 TOOLING DAMAGE FRAME 41 FWD SIDE @ SUPPORT CLIP FASTENER LOCATIONS 4EA LOCATED BETWEEN STR 3R AND STR 4R. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV ORIG. (1157944)SDR DALA2025082506302Frame · damagedSHIP 3406 TOOLING DAMAGE FRAME 41 FWD SIDE @ SUPPORT CLIP FASTENER. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV ORIG. (1157938)SDR DALA2025082506301Frame · damagedSHIP 3406 TOOLING DAMAGE FRAME 40.3 AFT SIDE @ SUPPORT CLIP FASTENER. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV ORIG. (1157751)SDR DALA2025082506300Frame · damagedSHIP 3406 TOOLING DAMAGE FRAME 40.3 AFT SIDE @ SUPPORT CLIP FASTENER. CORRECTIVE ACTION: REPAIRED PER ERA 628607-14 REV ORIG. (1157749)SDR AALA202508259781Latch · wornAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ORD DUE TO THE FLIGHT CREW REPORTING THAT WHILE CLIMBING THRU FL250 THEY FELT AIRFRAME VIBRATION THAT LASTED ABOUT 20-30 SECONDS THAT COULD BE FELT ON THE RUDDER PEDALS. VIBRATION OCSDR AALA202508253380Door · bentAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ORD DUE TO THE FLIGHT CREW REPORTING THAT WHILE CLIMBING THRU FL250 THEY FELT AIRFRAME VIBRATION THAT LASTED ABOUT 20-30 SECONDS THAT COULD BE FELT ON THE RUDDER PEDALS. VIBRATION OCSDR AALA202508253317Power Supply · no testAIRCRAFT WAS GROUNDED: FAULT LIGHT ILLUMINATED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED EMERGENCY POWER SUPPLY UNIT 15WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR DALA2025082506295Control Unit · failedSHIP 688 AFTER ENGINE START, AFT GALLEY HAD ELECTRICAL ODOR. ODOR CONTINUED 3 ROWS UP FROM AFT GALLEY. CORRECTIVE ACTION: C/W NO GO ODI PREVENTION PROGRAM STEPS 1 THROUGH 5. PERFORMED OPS CHECK OF OVERHEAD LIGHTS, PASSSENGER READING LIGHTS, PSU LIGHTS, IFE EQUSDR DALA2025082506294Snubber · out of toleranceSHIP 649 L1 DOOR SNUBBER BELOW LIMITS AFTER REMOVED. CORRECTIVE ACTION: REMOVED AND REPLACED L1 DOOR ROTARY SNUBBER IAW B757 AMM 52-11- 10, SNUBBER WAS REPLACED ON NON-ROUTINE CARD 184563-0800.0023. (1158340)SDR DALA2025082506289Transition Panel · corrodedAFT CARGO COMP-L/H LONGITUDINAL TRANSITION BEAM PANEL SUPPORT-FROM STA727E TO STA787 - HAS DAMAGE/CORROSION. REPAIRED/REPLACED STA 727I-747 TRANSITION PNL SECTION IAW B737-900 SRM 53-00-53-2R-6.SDR FDEA202508221528Channel · corrodedCOURIER AREA FLOOR STRUCTURE AFT LH CORNER "Z" CHANNEL AT AFT DRAIN FOR L1 DOOR CORRODED. INSTALLED FABRICATED CHANNEL AT COURIER AREA FLOOR STRUCTURE AFT LOWER CORNER L1 DOOR IAW SRM 51-40-02.SDR FDEA202508221527Crease Beam · corrodedMAIN DECK CABIN RBL 64.20 SUPPORT FLOOR FROM STA 1540 TO 1620 HAS CORROSION. REPAIRED FLOOR SUPPORT CREASE BEAM AT MAIN CABIN STA 1540 TO 1620 RBL 64.20 IAW SRM 53-00-13-2R.SDR AALA202508250860Pump · inoperativeAIRCRAFT WAS GROUNDED: DUE TO EXCESSIVE FUEL IMBALANCE DIVERTED TO KCLT. EMERGENCY DECLARED AIRCRAFT LANDED OVERWEIGHT AND WITHOUT INCIDENT. MAINTENANCE TROUBLESHOT IAW TSM 28-21-00-810-813-A. REPLACED CENTER TANK PUMP 1 FUEL PUMP PRESSURE SWITCH (39QA) IAW AMSDR AALA202508257255Light · no testAIRCRAFT WAS GROUNDED: ROW 17 ABC AISLE EMERGENCY LIGHT INOP. MAINTENANCE REPAIRED WIRING IAW ESPM 20-48-14 OPS CHECK NORMAL IAW 33-51-11.SDR AALA202508254549Sign · inoperativeAIRCRAFT WAS GROUNDED: EMERGENCY EXIT LIGHT BURNED OUT AIRCRAFT RIGHT SIDE AT THE OVERWING EXIT. MAINTENANCE REPLACE RH EMER DOOR EXIT SIGN IAW AMM 33-51-15.SDR AALA202508256743Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT SIGN DOOR 2L AFT INOP. MAINTENANCE REPLACED EMERGENCY EXIT SIGN AT DOOR 2L IAW AMM 33-51-00.SDR ABXA20250822197Pressure Switch · failedAFTER PUSHBACK, STAB TRIM EICAS MSG APPEARED. AIRCRAFT RETURNED TO BLOCKS. (BTB). MAINTENANCE REMOVED AND REPLACED RH STCM BRAKE PRESS SWITCH IAW AMM 27-41-07 OPS AND LEAK CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR HNAA2025082500581Battery · inoperativeL/H SIDE CENTER FAIRING EMERGENCY LIGHT INOP. FOUND EMERGENCY BATTERY 2 TO BE READING 1.94VDC RR'D BATTERY IAW AMM 33-50-04 OPS CHECK GOOD.SDR CALA2025082508097Warning Message · false activationR ENG OVHT AT FL360. WENT AWAY AFTER R EPR REDUCED BY .02. R OVH T DET STATUS ALSO. PER CREW ALSO GOT STRUT OVERHEAT EICAS MOMENTARILY ACP FIM 26-11 TASK 802 ENGINE FIRE/OVERHEAT DETECTION SYSTEM BITE . STEPS 1-6 COMPONENTS AND INTERFACE WIRING ARE CHECKING OKSDR CALA2025082508096Transformer · faultedLE SLAT ASYMSLAT/FLAPS INDICATION STUCK POSITION 1. FLAPS RETRACTED AND LEVER FULLY RETRACTED. ACCOMPISHED PSEU BITE PROCEDURE 32-09 FAULT TREE 803 ( BLOCK 3). CODES: 301, 423. CONTINUE FROM BLOCK 3. PICTURE UPDATE LABOR HOURS UPDATED PERFORMED PSEU BITE FIM 3SDR CALA2025082508095Autothrottle Sys · malfunctionedAUTOTHROTTLE WONT ENGAGE ON TAKEOFF FOUND NO MCDP LAST FLIGHT, FAULTS, CYCLED TMC, FCC'S AND MCP CB'S AS PRECAUTIONARY. PERFORMED MCDP "TMC TEST 02, A/T SERVO TEST 10, A/T DISC SW TEST 12 & FCC TEST 01", AMM REF 22-00-02, ALL TESTS GOOD.SDR CALA2025082508093Light · looseEMERGENCY EXIT LIGHTS LOOSE AT 47D RESECURED EMERGENCY LIGHT AT SEAT 47D REF AMM 33-51-01.SDR CALA2025082508083Plate · corrodedINTERNAL FUSELAGE UNDER FLOOR STRUCTURE FR68 14DU DRAIN MAST "F" HAS CORROSION AROUND SURROUNDING STRUCTURE GEN BY V798788 ON HA ECO LCQ NR 9296689/20689 ESFR INFORMATION UPDATE REMOVED AND REPLACED ANGLE SUPPORT AT INTERNAL FUSELAGE UNDER FL OOR STRUCTURE FR6SDR CALA2025082508082Display · faultedEICAS UPPER DISPLAY BLANK AFTER TAKEOFF. NO AUTO. INTERMITTENT ON/OFF UPON ARIVAL FOUND UPPER EICAS DISPLAY FULLY OPS. PERFORMED EICAS OPS TEST REF 31-41-00-715-001 TEST PASS AS PRECAUTION. R & R UPPER DISPLAY CRT EFIS REF AMM 31-41-01/401. THE EICAS COMPSDR CALA2025082508081Power Supply · no testEMERGENCY LIGHTING TESTS SHOWS THE FOLLOWING FAULTS: EPSU COMM FWD L, EPSU COMM AFT L, EPSU ARMED/ON EMER R, EPSU ARMED/ON L. T/S & FOUND FAULTY FWD ESPU 10WL IAW TSM 33-51-00-810-806A. REMOVED & REPLACED ESPU 10WL IAW AMM 3-51-38-000-001A & 33-51-3 4-400-00SDR CALA2025082508080Light · inoperativeEMERGENCY AISLE LIGHT INOPERATIVE AT ROW 31. R & R EMERGENCY LIGHT ASSY AT ROW 31 IAW AMM 33-51-20. OK FOR SERVICE.SDR CALA2025082508079Flashlight · inoperativeF/A CREW BUNK EMERG. FLASHLIGHT INOP REPLACED EMER LIGHT ASSY .CHK OK. REF.DMC-B787-A-25-64-00-00B-921A-A AND TEST OK REF PER DMC-B787-A-25-64-00-04B-320A-A.SDR HNAA2025082500578Sign · inoperativeRH OVERWING EMERGENCY EXIT LIGHT INOP. R&R EMERGENCY EXIT SIGN IRT AMM 33-50-14 PN ON EXIT SIGN 7444-36 PN OFF EXIT SIGN 7444-36