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 DALA2025111908469Slide · bulgedL-1 DOOR SLIDE NEEDS TO BE REPLACED BECAUSE OF A BULGE AND BUSTLE RIDDING CONDITIONS. INSP, REMOVED AND REINSTALLED SERVICEABLE L1 DOOR SLIDE IAW B757 AMM 25-66-01. (1308937)SDR DALA2025111908467Floor Support · corrodedFLOOR SUPPORT (LH LWR SILL DOOR AREA) BTW BS 700 TO BS 720 WAS ACCOMPLISHED, AREA IS OUT OF LIMITS. CORROSION LEVEL 2, FLOOR SUPPORT (LH LWR SILL DOOR AREA) BTW BS 700 TO BS 720 WAS REPLACED PER DWG 143N5410 REV.A, PER B757-200 SRM 51-00-05-0G, PER BAC5300-SDR SWAA2025111936767Seat Back · out of adjustSEAT 11C WILL NOT STAY UP. SECURED SEAT 11C IN UPRIGHT POSITION-OK TO CONTINUE PER MEL 25-6-02 SP 1B ATH 293483. INSPECTED SEAT RECLINE RESTRICTION FOR EMERGENCY EXIT SEAT 11C IAW AMM 25-22-00. SEAT DOES NOT RECLINE AS REQUIRED.SDR F3LA202511190325Apu · leakingFUME EVENT INITIALLY WAS SMELLED IN GALLEY, FUME REMOVAL APPLIED AND WENT AWAY RETURNED IN AFT GALLEY. EMERGENCY DECLARED. REF LP518093 ITEM 1 FOR APU DEFERAL REF TSM 05-50-00-810-831-A. PERFORMED APU INSPECTION TYPE 1 EVENT ON LEVEL A IAW AMM 49-00-00-200-8SDR YENA2025111901113Warning Message · illuminatedFLT#2137. JFK-STI. (AN EMERGENCY WAS DECLARED) "GREEN HYD SYS LOW INFLIGHT. L/G GRAVITY EXTENDED" (SUPPLEMENTAL INFORMATION TO FOLLOW)SDR WX0A2025111932638Battery · inoperative(AIRCRAFT NOT GROUNDED) F/A FLASHLIGHT AT L2 UNDER F/A JUMPSEAT TEST BAD. REPLACED AFT F/A FLASHLIGHT BATTERY AND REINSTALLED AFT F/A FLASHLIGHT.SDR DALA2025111908452Skin · corrodedWASTE WATER ACCESS PANEL FWD EDGE EXTERNAL SKIN HAS CORROSION. COMPLIED WITH PRI 629290-14 REV 0, 1, 2, AND SECTION I TIME-LIMITED REPAIR OF ERA 629290-14 REV 0. MAX MATERIAL REMOVED 0.059". ORIGINAL THICKNESS 0.125". REMAINING THICKNESS 0.066". (LP# 1308921SDR DALA2025111908451Skin · corrodedWASTE BOX- FWD DOUBLER R/H CORNER HAS CORROSION INTERNAL AND EXTERNAL COMPLIED WITH PRI 629290-14 REV 0, 1, 2, AND SECTION I TIME-LIMITED REPAIR OF ERA 629290-14 REV 0. MAX MATERIAL REMOVED 0.059". ORIGINAL THICKNESS 0.125". REMAINING THICKNESS 0.066". (LP# SDR DALA2025111908450Skin · corrodedWASTE BOX- AFT CUTOUT FLANGE SKIN HAS CORROSION. COMPLIED WITH PRI 629290-14 REV 0, 1, 2, AND SECTION I TIME-LIMITED REPAIR OF ERA 629290-14 REV 0. MAX MATERIAL REMOVED 0.059". ORIGINAL THICKNESS 0.125". REMAINING THICKNESS 0.066". (LP# 1308846)SDR DALA2025111908449Skin · corrodedWASTE BOX- INSIDE THE BOX FWD RT CORNER SKIN HAS CORROSION. COMPLIED WITH PRI 629290-14 REV 0, 1, 2, AND SECTION I TIME-LIMITED REPAIR OF ERA 629290-14 REV 0. MAX MATERIAL REMOVED 0.059". ORIGINAL THICKNESS 0.125". REMAINING THICKNESS 0.066". (LP# 1308845)SDR DALA2025111908448Skin · corrodedWASTE BOX CUT-OUT FWD RT CORNER SKIN HAS CORROSION. COMPLIED WITH PRI 629290-14 REV 0, 1, 2, AND SECTION I TIME-LIMITED REPAIR OF ERA 629290-14 REV 0. MAX MATERIAL REMOVED 0.059". ORIGINAL THICKNESS 0.125". REMAINING THICKNESS 0.066". (LP# 1308843)SDR DALA2025111908447Access Panel · corrodedWASTE WATER ACCESS PANEL FWD EDGE INTERNAL SKIN HAS CORROSION. COMPLIED WITH PRI 629290-14 REV 0, 1, 2, AND SECTION I TIME-LIMITED REPAIR OF ERA 629290-14 REV 0. MAX MATERIAL REMOVED 0.059". (LP# 1308838)SDR JJBA20251119104Tee Angle · corrodedAT FRAME 61 BETWEEN LT SILL & LT OMEGA BEAM, TEE PROFILE. TEE PROFILE WAS REPLACED.SDR CALA2025111911351Indicator · faultedSTBY ATTITUDE INDICATOR FAILED. R & R ISFD OPS CHECKED, TEST PASSED, AND ROLL POINTER VISUAL ALIGNMENT WITHIN TOLERANCE IAW AMM 34-24-02.SDR CALA2025111911350Autothrottle Sys · failedAUTOTHROTTLE FAIL ON TAKEOFF ROLL. ACCOMPLISHED FIM 22-32 TASK 806 A/T BITE HAS NO FAULTS. ACCOMPLISHED A/T SYS TEST IAW AMM 22-31-00-710-802, OPS CHECKS NORMAL. ACCOMPLISHED FIM 22-32 TASK 806 A/T BITE HAS NO FAULTS. ACCOMPLISHED A/T SYS TEST IAW AMM 22-3SDR CALA2025111911340Filter · odorSTRONG ODOR AFTER ENG START FROM ROW 8 AFT. PERSISTED FOR 25 MIN ON GROUND IAW AMM 05-51-56-201. REMOVED AND REPLACED LT AND RT RECIRCULATION FAN FILTERS WRT 21-25-02-904-063-004. CARRIED OUT AMM 05-51-56-940-801-C1 UP TO DETAILED INSPECTION AND OPS CHECKED,SDR CALA2025111911338Floor Support · crackedMAIN CABIN FLOOR SUPPORT STRUCTURE INTERCOSTAL BETWEEN FRAMES AT STA 277 AND 294.5 AT BL0 HAS 2EA CRACKS AT THE FLOORBOARD ATTACH FASTENER HOLES. REMOVED AND REPLACED FLOOR SUPPORT BETWEEN STA 277 AND STA 294.5 IAW DWG 141A5400 REV-, & SRM 51-40-05.SDR CALA2025111911336Floor Support · corrodedCORROSION UNDER THE NUTPLATE AT CABIN FLOOR STRUCTURE BS 353 RBL 24. REMOVED CORROSION AT CABIN FLOOR STRUCTURE STA 353 RBL 24 IAW B7 57-300 SRM 51-10-02-0G, CHECKED LIMITS MATERIAL LOSS 0.016" MAX ALLOWED IS 0.006 OF THICKNESS ORIGINAL 0.063" FOUND TO BE OUTSDR CALA2025111911334Frame · corrodedAFT CARGO, FLOOR AREA, BS 1440, BTWN S29 - 30L, FRAME HAS CORROSION. REMOVED AND REPLACED DOUBLER IAW SRM 53-60-07-1A-0, SRM 51-40- 02, & DWG 146N1013, REV B. RESTORED SURFACE PROTECTION IAW SRM 51-20-01 & AMM 51-21-15.SDR CALA2025111811330Handle · unsecureAFT ENTRY LIGHT CAME ON AT FL260 PILOT REPORTED FA FOUND AFT ENTRY DOOR HANDLE NOT FULLY SECURED. LIGHT EXTINGUISHED UPON SECURING HANDLE. PERFORMED ENTRY AND GALLEY SERVICE DOOR INDICATION SENSOR TEST. CHECKS GOOD AT THIS TIME. IAW AMM 52-71-11.SDR CALA2025111811329Cover · detachedL3 SLIDE COVER FELL OFF INSPECTED MOUNTING POINTS DOOR SIDE AND BUSTLE SIDE. NO DEFECTS FOUND. INSTALLED DOOR 3L SLIDE BUSTLE REF AMM 25-66-11-404-004.SDR CALA2025111811328Slide · out of positionR1 SLIDE MATERIAL DRAGGING ON FLOOR ADJUSTED EXCESS MATERIAL. OP CHECKED GOODSDR CALA2025111811327Girt Bar · misinstalledR1 GIRT BAR STUCK. GIRT BAR WAS INCORRECTLY STOWED BY PREVIOUS CREW, RESTOWED GIRT BAR PROPERLY DUE TO GIRT BAR REMOVED AND RE STOWED, VIEWED SAFETY DEMO VIDEO FOR SLIDE SAFETY OBSERVER.SDR N6WA2025111903Floorbeam · corrodedCORROSION ON LEFT CROSSBEAM AT FS280 FLOOR STRUCTURE. REMOVED AND REPLACED LEFT CROSSBEAM AT FS280 FLOOR STRUCTURE IAW GOJET EO-C550-53MA-106-O.SDR N6WA2025111902Floorbeam · corrodedCORROSION ON RH CROSSBEAM AT FS280 FLOOR STRUCTURE. REMOVED AND REPLACED RT CROSSBEAM AT FS280 FLOOR STRUCTURE IAW GOJET EO-C550-53MA-106-O.SDR N6WA2025111901Skin · damagedDAMAGE LOWER SKIN FWD OF FS977.00 AT STRINGER 27. COMPLETED REPAIR OF DAMAGED LOWER SKIN FWD OF FS 977.00 AT S27 IAW GOJET EO-C550-53MR-108-OSDR ASAA2025111761766Handle · fodL2 DOOR UNABLE TO OPEN OR CLOSE FROM OUTSIDE. GROUNDED - YES. CLEANED DEBRIS OF LS EXTERNAL HANDLE PER FIM 52-10-F1-X6A-421A AMM B787-A-52-11-00-63A-280A-A OPS CHECK GOOD. OKAY FOR SVC.SDR SWAA2025111836384Girt Bar · looseFWD ENTRY GRIT BAR LOOSE CLIP. REINSTALLED FWD ENTRY GIRT BAR CLIP PER AMM 25-66-00SDR SWAA2025111835893Battery Pack · inoperativeEMERGENCY EXIT LIGHT OVER L1 DOOR WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACK AT M01675 IAW AMM 33-51-06. NO FAULTS NOTED.SDR SWAA2025111835915Sign · unsecureEMERGENCY EXIT SIGN MID CABIN IS LOOSE. SECURED EMERGENCY EXIT SIGN MID CABIN IAW AMM 33-51-01.SDR SWAA2025111835890Lamp · inoperativeEMERGENCY LIGHT INOPERATIVE AT AFT CABIN ENTRANCE DOOR. REMOVED AND REPLACED THE LAMP IAW AMM 33-51-04-960-801-NG.SDR SWAA2025111836390Slide · partial deployFWD ENTRY DOOR EMERGENCY ESCAPE SLIDE PARTIALLY DEPLOYED BY BOTTLE NOT ACTIVATED. REPACKED L1 DOOR ESCAPE SLIDE IAW MT 725-61-06. ACFT OK FOR SERVICE.SDR SWAA2025111836026Battery · no testFLIGHT DECK FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED THE BATTERY IAW AMM 25-64-00-900-805-MAX.SDR SWAA2025111836405Fuel Sys · erraticFUEL FLOWS LT & RT BOTH FLUCTUATING ERRATICALLY AFFECTING BOTH ENGINE N1 EGT, N2 BETWEEN 14-19000 FT IN CLIMB. PER POWERPLANT ENGINEERING PERFORMED IDLE RUN ON NR 1 & 2 ENGINES IAW AMM 71-00-00 & EEC TESTS PER AMM 71-00-00. TESTS GOOD. NO FAULTS NOTED.SDR SWAA2025111836395Sign · unsecureCEILING EMERGENCY EXIT SIGN AT ROW 15 IS NOT SECURED TO THE CEILING. SECURED CEILING EMERGENCY EXIT SIGN IAW AMM 33-25-00.SDR SWAA2025111836412Panel · looseRIGHT OVER WING EXIT DOOR ASSIST PANEL LOOSE. PANEL SECURED - OK TO CONTINUE PER MEL 25-10-01 SP#1B. INSTALLED MISSING HARDWARE ON EXIT DOOR LINING REF AMM 52-22-51SDR 2DYA2025081300013Bulb · burned outEXTERIOR EMERGENCY LIGHTS INOPERATIVE AT DOORS 3L AND 4L ON PREFLIGHT INSPECTION. R & R THE BULBS AT DOORS 3L & 4L OPS CHECKED GOOD.SDR SWIA2025111800007Rib · damagedDAMAGE ON THE RH WING PLUG RIB LOCATED BETWEEN WS353.00 AND WS 389.00 WAS FOUND TO BE OUT OF LIMITS PER SRM 57-21-12 . DAMAGE IS OUT OF LIMITS AND THE REPLACEMENT OF THE STRUCTURALLY SIGNIFICANT ITEM IS CLISSIFIED AS A MAJOR REPAIR. OPENSDR DALA2025111808428Spar Cap · crackedDISCOVERED A CRACK COMMON TO THE RT WING LOWER REAR SPAR CAP. COMPLIED WITH ERA 620694-14AD (1308670).SDR DALA2025111808425Power Supply · faultedEXTERIOR OVERWING EMERGENCY LIGHT WON'T EXTINGUISH. T/S OVERWING EMERGENCY LIGHTS PER B717 FIM 33-50-00-810-801. R & R EMERGENCY LIGHT POWER SUPPLY AT LOC B5-125 PER AMM 33-51. OPS CKD GOOD. (7844834).SDR DALA2025111808420Skin · crackedFOUND ONE CRACK BELOW THE NR 7 FASTENER HOLE, COUNTING FROM FRONT TO THE BACK, BETWEEN FRAMES 1654 - 1678, STRINGER 13AL. REPAIED IAW SRM 53-80 -01-2R-7 (1308025).SDR DALA2025111808416Girt Bar · fodR2 DOOR MAKING LOUD LOW PITCHED NOISE. REMOVED FOD FROM DOOR GIRT BAR OK FOR SVC PER AMM 52-13. (7844653)SDR DALA2025111808415Gust Lock · inoperativeL2 DOOR GUST LOCK NOT LATCHING. R & R GUST LOCK IAW AMM 52-13-12. (8036542).SDR BAGA2025111800002Latch · odorBURNING ODOR IN CABIN DURING FLIGHT, CREW RAN FIRE/SMOKE/FUMES QRH. ODOR DISSIPATED AFTER THE QRH. PERFORMED FAULT ISOLATION PROCEDURE FOR FUES OR SMOKE EVENTS IN CABIN BY PERFOMING ENGINE RUNS AND PERFOMING A VISUAL INSPECTION OF THE ENGINES TO CHECK FOR ANSDR DALA2025111808438Stringer · mechanic errorSHIP 3418 STRINGER 1R AT FR 64 HAS DOUBLE DRILLED HOLE. REPAIRED IAW AMM 53-11. (1308932)SDR DALA2025111808437Frame · damagedFRAME 63 AFT SIDE UPPER FLANGE FLATTENED & BENT DOWN BETWEEN STRINGER 1L AND 2L AND ALSO 1R AND 2R. REPLACED IAW SRM 53-11. (1308919)SDR DALA2025111808436Frame · bentAFT SIDE OF FRAME 62 BETWEEN STRINGERS 2L & 3L IS BENT AT THE TOP EDGE. REPLACED IAW ERA 628197-14, REV ORIGINAL. (1308899)SDR DALA2025111808435Stringer · damagedFRAME 62, FWD SIDE AT STRINGER 1R TOOLING DAMAGE ON OTBD OF STRINGER. REPAIRED IAW AMM 53-11. (1308810)SDR DALA2025111808434Stringer · damagedFRAME 62, FWD SIDE AT STRINGER 1R ABOVE REINFORCEMENT ITEM 73 TOOLING DAMAGE ON STRINGER. REPAIRED PER A330 SRM 53-11. (1308807)SDR DALA2025111808433Frame · deformedAFT SIDE OF FRAME 61 IS DEFORMED AT THE CAPTURED RIVET. BETWEEN STRINGERS 3R & 4R UNDER THE L-BRACKET. REPLACED IAW ERA 628197-14, REV ORIGINAL. (1308744)