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 AALA202507099096Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN SDR AALA202507099743Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN SDR AALA202507098423Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN SDR AALA202507097894Coupling · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN SDR AALA202507095557Wire Harness · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO PHX DUE TO THE FLIGHT CREW REPORTING THAT ENGINE 2 EGT OVER LIMIT ON TAKEOFF. THE FLIGHT CREW SHUT DOWN THE ENGINE AND LANDED SAFELY AT PHX WHERE IT TAXIED TO THE GATE UNDER ITS OWN SDR AALA202507094558Engine · stalledAIRCRAFT WAS GROUNDED: AN EMERGENCY DECLARED & ACFT RETURNED TO LAS DUE TO FLT CREW REPORTING ON TAKEOFF BOTH ENGS ENCOUNTERED AN EGT EXCEEDANCE. A COMPRESSOR STALL ON NR 2 ENGINE ALONG WITH REPORTS OF SMOKE COMING FROM NR 2. FLT CREW SHUTDOWN NR 2 & LANDED SASDR IPXA2025070315311Skin · gougedGOUGE FWD OF LOWER FWD CARGO DOOR EO-94202-REQ1 C/W.REMOVED GOUGE COMMON TO LWR FWD CARGO DOOR BY BLENDING IAW SRM 51-10-02.CUT OUT DAMAGE TO FUSELAGE SKIN AT STR 25R BETWEEN FS473 AND FS465.LOCATED DRILL AND FABRICATED -1 REPAIR DOUBLER USING 2024T3 .160" PO SDR 2DYA2025070700160Battery Pack · dischargedBATTERY PACK FOR EMERGENCY LIGHTS L290,L291,L292 & L293 FAILED CAP. CHECK.SDR AALA202507047345Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON CENTER WING BOX FR36 FRONT SPAR VERTICAL STRINGER N5 ZONE 1, CRACK DIRECTION AT 12 O CLOCK D= 0.091 IN. MAINTENANCE PERFORMED PERMANENT REPAIR ON CENTER WING BOX FR36 FRONT SPAR VERTICAL STRINGER 5 (BEAM SDR SWIA20250625Skin · damagedFWD FUSELAGE FR 10 HAS ELECTRICAL ARCING DAMAGE BETWEEN STGR 12L -13L. REPAIRED FR 10 BETWEEN STGR 12L-13L. REF ETD 2025-170-923684 REV. A.SDR AALA202507024576Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: FLOOR STABILIZER FITTING ON G4B GALLEY AT STA 575 IS BULGING AND HAS CORROSION. REPLACED FLOOR STABILIZER FITTING ON G4B GALLEY WITH A NEW SERVICEABLE ONE. PER AMM TASK 25-31-41-400-801-005.SDR DALA2025070204957Engine · odorDIRTY SOCK SMELL IN AFT GALLEY DURING DESCENT. T/S PER AMDS W/C 0550-2001. FOUND OIL ODOR COMING FROM LT ENG DURING HIGH POWER OP (+80% N1). C/W AMDS W/C 0550-6001. C/W MEL 36-12-00A, REF LOG # 7382643. ERA 613840-14TR SEC. II (WATER WASH) REQ WITHIN 5 CALENDASDR SWAA2025070185040Seal · crackedTAIL LH HORIZONTAL UPPER FRONT SPAR SLIDING SEAL IS CRACKED. R&R LH HORIZONTAL STABILIZER UPPER FRONT SLIDING SEAL REF. AMM 53-31-31.SDR SWAA2025070185041Seal · crackedTAIL RH HORIZONTAL UPPER FRONT SPAR SLIDING SEAL IS CRACKED. REMOVED RH HORIZONTAL UPPER FRONT SPAR SLIDING SEAL. IAW AMM 53-31-31. NEW SLIDING SEAL NEEDS TO BE INSTALLED. REMOVED AND REPLACED TAIL RH HORIZONTAL UPPER FRONT SPAR SLIDING SEAL IAW AMM 53-31-SDR DALA2025070104891Seat Track · corrodedCORROSION ON SEAT TRACK @ FR22, LBL43, WL151.5. REMOVED AND REPLACED SEAT TRACK AT FR 19+10" 30+9" LBL 43, WL 151.5 PER A220 ASRP BD500-A-J51-42-20-00AA-078A-A AND BOMBARDIER DWG C02312600 REV: -E. GRAMMAR CORRECTION: REMOVED AND REPLACED SEAT TRACK AT FR 19+1SDR DALA2025070104890Threshold · corroded2R DOOR THRESHOLD PANEL FWD AND AFT INBD CORNERS HAVE CORROSION. -M-. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0583:5300-2016/001 00353 REMOVED AND REPLACED AFT SERVICE DOOR THRESHOLD PANEL REF A220 AMP 53-00-47. (LP# 1044440)SDR SWAA2025063085224Floor Panel · splitFWD CARGO FLOOR PANEL SPLIT 4'' NEAR FWD EDGE. <[01] REMOVED AND REPLACED FWD CARGO FLOOR PANEL IAW B737 AMM 25-52-10.SDR SWAA2025063085264Battery Pack · inoperativeONE OVERWING ESCAPE GROUND ILLUMINATION AND TWO AISLE EMERGENCY LIGHTS ON L/H SIDE INOP <[01]. REMOVED AND REPLACED E-LIGHT BATTERY PACK (M1670) PER AMM 33-51-06. ALL E-LIGHTS OPS CHECK GOOD.SDR SWAA2025063085335Light · inoperativeCABIN EMERGENCY LIGHT INOP AT OVERHEAD BIN ROW 9ABC AND 13DEF. <[01] RELAMPED AND OPS CHECKED GOOD IAW MM 33-51-03.SDR SWAA2025063085714Cover · looseEMERGENCY EXIT COVER FELL OFF ON THE CENTER AISLE SIGN <[01]. RESECURED EMERGENCY EXIT LIGHT COVER AT CENTER AISLE PER SIP.SDR SWAA2025063085342Battery Pack · inoperativeLT FUSELAGE; FWD EMERGENCY EXIT LIGHT INOP. <[01] REPLACED EMERGENCY BATTERY PACK M1671; PERFORMED GOOD TEST OF LT FUSELAGE; FWD EMERGENCY EXIT LIGHTPER AMM 33-51-06-960-802.; [02] VERIFIED.SDR SWAA2025063085343Battery Pack · inoperativeRT FUSELAGE; AFT EMERGENCY EXIT LIGHT INOP. <[01] REPLACED BATTERY PACK ON CARD ID TTG8Q013CXAL; AND PERFORMED GOOD TEST OF RT FUSELAGE; AFT EMERGENCY EXIT LIGHT PER AMM 33-51-06-960-802; [02] VERIFIED.SDR SWAA2025063085344Battery Pack · inoperativeRT FUSELAGE; EMERGENCY LIGHT AFT OF RT WING INOP. <[01] REPLACED BATTERY PACK M2335; AND PRFORMED GOOD TEST PER AMM 33-51-06-960-802; [02] VERIFIED.SDR SWAA2025063085470Battery Pack · inoperativeALL EMEREGENCY LIGHT ASSOCIATED WITH BATTERY PACK (M1695; M1694) FOR LEFT AND RIGHT OVERWING EXIT ARE INOP. ALL EMEREGENCY LIGHT ASSOCIATED WITH BATTERY PACK (M1695 M1694) FOR LEFT AND RIGHT OVERWING EXIT ARE INOP. <[01] REMOVED EMERGENCY EXIT LIGHT BATTERY PSDR SWAA2025063085459Cover · detachedOVERWING EMERGENCY EXIT LIGHT COVER FELL OFF (CEILING). SECURED OVERWING EXIT CEILING LIGHT COVER REF AMM 33-51-01.SDR DALA2025063004860Floorbeam · corrodedSHIP 6807 CORRIOSION FOUND AT STA 1020 L/H SIDE UNDER FLOOR BEAM. CORRECTIVE ACTION: REPAIRED CORROSION FOUND ON CTR TANK UPPER SIN AT STA 1020 L/H UNDER FLOOR BEAM PER PRI ER/A 626574-14. (1045541)SDR DALA2025063004859Attach Fitting · corrodedSHIP 6807 WHILE WORKING NON-ROUTINE 182505-0300-0019 MORE CORROSION WAS FOUND ON THE UPPER SIDE OF THE APU DOOR ATTACH FITTING. AREA MARKED WITH A RED STREAMER. CORRECTIVE ACTION: REMOVED CORROSION AND REPAIRED INNER STRAP PN# 148N3138-2 PER ER /A 627167-14 RESDR DALA2025063004858Stub Frame · damagedSHIP 6807 DURING HOLE SCANS OF STATION 1000 LEFT SIDE UNDER STUB BEAM 1 FORWARD OUTBOARD HOLE COMMON TO THE SKIN AND STRINGER, DEFECT NOTED, HOLE FOUND TO BE ELONGATED IN STRINGER ONLY. CORRECTIVE ACTION: REPAIRED STATION 1000 FWD HOLE PER ER/A 626574-14 PRI RSDR DALA2025063004857Stub Frame · damagedSHIP 6807 DURING HOLE SCANS NOTED DEFECT AT STATION 1000 L/H OUTBOARD AFT HOLE UNDER STUB BEAM COMMON TO THE SKIN AND STRINGER. CORRECTIVE ACTION: REPAIRED STATION 1000 AFT HOLE PER ER/A 626574-14 PRI REV 04. (1045508)SDR DALA2025063004856Stub Frame · damagedSHIP 6714 DURING HOLE SCANS NOTED DEFECT AT STATION 1000 L/H OUTBOARD AFT HOLE UNDER STUB BEAM COMMON TO THE SKIN AND STRINGER. CORRECTIVE ACTION: REPAIRED STATION 1000 AFT HOLE PER ER/A 626574-14 PRI REV 04. (1045502)SDR DALA2025063004854Stringer Splice · no discrepancySHIP 9574 SPLICE STRINGERS 13L AND 14L AT STA 1022 FOR ACCESS REF NR 1585. CORRECTIVE ACTION: COMPLETED AND MATCH FINAL - E/RA 624873-14 (1045986)SDR DALA2025063004850Fuel Sys · leakingSHIP 9584 PER ERA 621136-14AD WORKING CARD 5720-01103-01B. FUEL LEAK FOUND DURING INSPECTION OF RH WING AFT LOWER SKIN DOUBLER AT XRS=164. CORRECTIVE ACTION: COMPLIED WITH PRI 621136-14AD REV A REV 0 (7125286)SDR DALA2025063004841Floor Support · corroded(LOG 1046016) CORROSION ON FLOOR SUPPORTS BTW STA 951 TO STA 985 LBL 16 ALSO STA 951 BTW RBL 18 TO RBL 47 AT PASSENGER CABIN. FLOOR SUPPORTS BTW STA 951 TO STA 985 LBL 16 ALSO STA 951 BTW RBL 18 TO RBL 47 AT PASSENGER CABIN WERE REPLACED AND INSTALLED PER B737SDR DALA2025063004840Frame · not reported(LOG 1045877) ACCOMPLISH RIGHT HAND STA 727 FRAME INNER CHORD 737 REPAIR SECTION 02. ACCOMPLISHED RIGHT HAND STA 727 FRAME INNER CHORD REPAIR SECTION 02 PER WORK CARD 5311-01251-02B.SDR DALA2025063004839Support · corroded(LOG 1045714) CORROSION ON LOWER SILL UPPER AND LOWER AREAS FROM STA 950 TO STA 996 AND FROM 55 TO 45 LBL AT W2. LOWER SILL STA 892 TO STA 1016 FROM 55 TO 45 LBL AT W2 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025063004838Floorbeam · corroded(LOG 1045539) CORROSION ON FLOOR BEAM UPPER AND LOWER AREAS STA 986.5 AT W2. PREVIOUS REPAIR ON FLOOR BEAM STA 986.5 AT W2 WAS REPLACED PER ERA 583800-14 REV. ORIGINAL, SECTION I: PERMANENT REPAIR.SDR DALA2025063004837Retainer · cracked(LOG 1044456) IN REF. AA 2740-01077, WORK CARD 2740-01077-0101: CRACK ON RETAINER ABOVE BALLSCREW GEAR BOX. HORIZONTAL STABILIZER TRIM BALLSCREW REPLACEMENT ACCOMPLISH UNDER AMDS 2740-01077-0301 AND 37-2741-9-0005 ASSOCIATED AA 2740-01077 ADDED FOR AC 3757.SDR DALA2025063004836Floorbeam · corroded(LOG 1044655) CORROSION ON FLOOR SUPPORT UPPER AND LOWER AREAS STA 948.5 FROM 54 RBL TO 50 RBL AT W2. FLOOR SUPPORT STA 948.5 FROM 54 RBL TO 50 RBL AT W2 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025063004835Support · corroded(LOG 1044581) AA 5352-01035" CORROSION ON PREVIOUS REPAIR ON PANEL SUPPORT STRUCTURE STA.727+2.7. AA 5352-01035" PANEL SUPPORT STRUCTURE STA.727+2.7 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR AALA202506303361Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FR36 FRONT SPAR VERTICAL STRINGER 3 ZONE 1 CRACK DIRECTION AT 12 O CLOCK D=0.089 IN. MAINTENANCE PERFORMED PERMANENT REPAIR ON FR36 FRONT SPAR VERTICAL STRINGER 3 (BEAM Y254) IAW EA 364522.SDR DALA2025063004824Sign · inoperativeDOOR 2L OVERHEAD GREEN EXIT LIGHT DOES NOT ILLUMINATE. R/R 2L DOOR OVERHEAD EMER EXIT SIGN LT PER A350 AMM 25-23. (LP# 7467451)SDR DXTA2025063004097Warning Message · false activationUPON APPROACH WE RECEIVED AMBER FLAPS FAIL CAS. RAN APPROPRIATE CHECKLIST AND LANDED. LANDING WAS UNEVENTFUL. PERFORMED MULTIPLE SUCCESSFUL OPS CHECKS OF THE FLAPS AS REQUIRED. COULD NOT DUPLICATE FAULT AT THIS TIME. WORK DONE IN REFERENCE TO AMM 27-53-04.SDR CALA2025063006075Control Cable · out of rigON ROLL OUT FOR TAKE OFF CREW REPORTS AC PULLING TO THE RIGHT WITH FULL LH RUDDER PEDAL INOUT ON ROLL OUT FOR TAKE OFF CREW REPORTS AC PULLING TO THE RIGHT WITH FULL LH RUDDER PEDAL INPUT CHECKED RIG OF AFFECTED SYSTEM AND FOUND CABLES NWSA AND NWSB TO BE MISRSDR CALA2025063006056Seat Track · corrodedY-765 SEAT TRACK FR 36-42 FOUND OUT OF LIMITS AND REQUIRES REPLA CEMENT. R & R CABIN SEAT TRACK Y-765 FR 36-42 IAW A319 SRM 51-42 -11/001.SDR CALA2025063006041Warning Message · false activationON LANDING FWD CARGO DOOR UNLOCK WITH ECAM MOMENTARY. SELF CANCELLED IN REF TSM 52-31-00-810-801-A PERFORMED OPS TEST, TEST GOOD. CLEANED PROX SENSORS. NO FAULTS NOTED. OK FOR CONTINUE SERVICE.SDR CALA2025063006037Sign · detachedCAPT REPORTS EMERGENCY EXIT SIGN BY THE OVER WING EXITS WAS HANGING BY THE WIRES. REINSTALLED EMERGENCY EXIT SIGN REF AMM 33-51-0-960-802. OPS CHECK GOOD. OK FOR SERVICE.SDR CALA2025063006036Battery · no testAHM DETECTED WELS MMSG {33-12114} CLASS 14 - REMOTE WELS CONTROL UNIT CONFIGURATION DOES NOT AGREE WITH OTHER WIRELESS EMERG LIGHTING SYS CONTROL UNITS REF FIM DMC-B787-A-33-50-F1-V7A-421A-A TO CONFIRM FAULT. CON'T FAULT ISOLATION AS REQ'D. REF CONFIG DWG 252SDR CALA2025063006031Insulation · contaminatedSMOKE AGAIN IN MAIN WHEEL WELL. OPERATED FLIGHT CONTROLS, FLAPS, BOTH ENGINE THRUST REVERSERS, AND PARKING BRAKE WHILE BOTH HYDRAULIC EMDPS WERE RUNNING MULTIPLE TIMES, FOUND NO ACTIVE HYDRAULIC LEAK IN THE WHEEL WELLS AT THIS TIME. CORRECTED HYDRAULIC LSDR 2025F00149Windshield · crackedWHILE AT CRUISE AT FL 450 THE CREW HEARD A LOUD BANG AND REALIZED LEFT WINDSHIELD HAD CRACKED. CREW FOLLOWED ALL CHECKLISTS AND PROCEDURES AND WAS ABLE TO LAND AT DESTINATION DUE TO HOW CLOSE WE WERE.SDR HALA20250627201Transceiver · faultedETOPS - ECAM: "NAV PRED W/S DET FAULT" DISPLAYED WHEN WXR/PWS SWITCH IS SELECTED TO 1. REMOVED AND REPLACED #1 RTU PER 34-41-00. BITE TEST PASSED. NO FAULT NOTED. OK FOR SERVICE.