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 N6WA2025082803Angle · corrodedCORROSION ON ANGLE AND STRAP RH FS879 OF WING TO FUSELAGE BODY FAIRING STRUCTURE. REMOVED AND REPLACED ANGLE AND STRAP ON RH FS879 OF WING TO FUSELAGE BODY FAIRING STRUCTURE IAW CRJ SRM 51-42-06SDR N6WA2025082802Angle · corrodedCORROSION ON ANGLE AND STRAP LH FS879 OF WING TO FUSELAGE BODY FAIRING STRUCTURE. REMOVED AND REPLACED ANGLE AND STRAP AT LH FS879 OF WING TO FUSELAGE BODY FAIRING IAW CRJ SRM 51-42-06SDR N6WA2025082801Angle · corrodedCORROSION ON ANGLE AND STRAP BETWEEN FS879-FS909 RBR17.63 OF WING TO FUSELAGE BODY FAIRING STRUCTURE. REMOVED AND REPLACED ANGLE AND STRAP BETWEEN FS879-FS909 RBL17.63 OF WING TO FUSELAGE BODY FAIRING STRUCTURE IAW CRJ SRM 51-42-06SDR DALA2025082806383Bottle · low pressureDOOR 4L ASSIST LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. (7600748)SDR DALA2025082806382Light · brokenEMER LIGHT ESCAPE PATH MARKER AT SEAT 32B BROKEN. CORRECTIE ACTION: REPLACED ESCAPE PATH MARKER BRACKET PER A330 AMM 33-52. OK FOR SVC. (7072781)SDR DALA2025082806380Skin · mechanic error(C53.6 TO C53.9) S-3R / QTY 01 MISDRILLED HOLE. REPAIRED PER ERA 620877-14 REV A. (1165474)SDR YENA2025082800895Tube · brokenFLT#2104, BOS-BOS. "FOUND ANTI-ICE TUBE ON RH ACM BROKEN; REMOVED AND REPLACED RH ACM ANTI-ICE TUBE PER AMM 21-52-21, LEAK CHECK OK. "SDR FDEA202508261556Seat Track · damagedEXISTING REPAIR ON MAIN DECK SEAT TRACK AT Y0 BETWEEN FR58 AND FR62 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MAIN DECK SEAT TRACK AT Y0 BETWEEN FR58 AND FR62 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM53-10-16-201 FIG.201. BUTSDR YENA2025082800891Apu · odorFLT#2101, JFK-CHS. "WHILE CRUISING AT FL 340 FLIGHT CREW EXPERIENCED AN ODOR SIMILAR TO A MAGIC MARKER IN THE COCKPIT THAT DEVELOPED INTO BURNING EYES AND THROAT. FA#1 INFORMED THE CA PAX WERE FEELING SICK WITH BURNING THROAT AND ONE VOMITING,. PHYSICAL SYMPTOSDR BAGA2025082800010Seat · odorCHEMICAL SMELL IN THE AFT GALLEY, INTERMITTENTLY IN THE CABIN WHILE IN FLIGHT FROM LAS-CAK. RAN THE REAR GALLEY FAN, NO OUT OF ORDANARY SMELL NOTED. AFTER MOVING THE REAR LEFT FA SEAT, NOTED SMELL CAME BACK. AFTER INSPECTING AREA, FOUND KROIL WAS RECENTLY USEDSDR DALA2025082806375Proximity Sensor · out of adjustRIGHT AFT ENT DOOR ANNUNCIATOR ILLUMINATED AFTER LANDING. ADJUSTED 4R DOOR PROX SENSOR PER B757 AMM 52-71. OP CK GOOD. (7322038)SDR DXTA2025082804736Flap System · faultedAT FL430 GOT AMBER CAS FLSPS FAIL MSG B3-276369, REPEAT WRITE UP, POWERED ACFT & NOTED A "FLAPS FAIL" CAS MESSAGE. COMPLIED WITH FLAPS RESET PROCEDURE. LOWERED FLAPS FOR INSPECTION. INSPECTED RH FLAP POSITION SENSOR AND CONNECTORS WITH NO DEFECTS NOTED. INSPSDR UIEA2025082601142Pump · faultedHYD OVHT SYS 4 EICAS MESSAGE. R & R TEMP TRANSMITTER IAW AMM 29-32-02. OPS/LK CHK OK. R & R EDP IAW AMM 29-11-05. OPS CHECKED OK PER AMM 29-11-05. IDLE RUN CHKS OK PER AMM 71-00-00-705-152-J00. REF IPC 29-11-05-048.SDR CALA2025082808240Anti-Ice Valve · faultedENGINE INLET THERMAL ANTI-ICING EICAS MESSAGE (01=L,02=R) ENG AN TI-ICE DISPLAYED AND ENG ANTI-ICE VALVE LIGHT REMAINED ON WITH S WITCH ON 01 L ENG ANTI-ICE EICAS MESSAGE WITH L ENG ANTI ICE SWITCH ON. CONDUCTED FIM 30-21 FAULT TREE 803. REMOVED AND REPLACED ESDR CALA2025082808239Door · no discrepancyGROUND POWER DOOR LEFT OPEN HEARD AND FELT VIBRATION IN FLOOR NO DAMAGE DOOR OPERATES PROPERLY FOUND GROUND CORD POWER DOOR LEFT OPEN INSECTED DOOR AND CLOSED DOOR NO DAMAGE NOTICE. OK TO CONTINUESDR CALA2025082808231Support · corrodedFORWARD CARGO COMPARTMENT CORROSION OUT OF LIMITS, SIDEWALL SUPPORT BETWEEN STR 23L-25 BS 500D.SDR CALA2025082808228Unknown · unknownAN OPERATIONAL CONFIRMATION FLIGHT (GROUP 1 NRFO) IS REQUESTED BY TOMC AS PER GMM 11-30-30 TO CONFIRM A POSITIVE FIX FOR MID CABIN SMOKE / FUMES REPORTED REF L/P 6007819. OPERATIONAL CONFIRMATION FLIGHT NO LONGER REQUIRED AS ACFT IS BEING POSITION FERRIED TO SDR CALA2025082808218Gauge · out of positionDOOR 2L SLIDE PRESS GAUGE OSCURED AND HARD 2 READ. UNSURE OF PR ESS DOOR 2L SLIDE PRESS GAUGE CLEARLY VISIBLE AND WITHIN RANGE REF AMM TASK 25-62-00-210-001-ASDR CALA2025082808217Girt Bar · out of limitsFWD SERVICE DOOR HAS EXCESS SLIDE BAR MATERIAL RESTOWED FLIGHT GIRT BAR SLIDE AS REQUIRED REF 25-66 -00.SDR DALA2025082806372Light · inoperativeAIRCRAFT 3852, EXTERIOR SLIDE ILLUMINATION EMERGENCY LIGHT INOP AT R2 DOOR. CORRECTIVE ACTION: RELAMPED EXTERIOR SLIDE ILLUMINATION EMERGENCY LIGHT AT R2 DOOR PER B737 AMM 33-51. OPS CHECK GOOD. (LP 7064455)SDR DALA2025082806371Light · inoperativeAIRCRAFT 3852, EXTERIOR EMERGENCY LIGHT INOP AT LT FWD OVER WING EXIT. CORRECTIVE ACTION: RELAMPED EMERGENCY LIGHT AT LT FWD OVER WING EXIT PER B737 AMM 33-51. OPS CHECK GOOD. (LP 7064454)SDR DALA2025082806368Seat Track · corrodedAIRCRAFT 3769, CORROSION OUT OF LIMITS ON SEAT TRACK LBL 24 BTW STA 500H+10 TO 520. CORRECTIVE ACTION: CORROSION LEVEL 2: SEAT TRACK LBL24 BTW STA 500H+10 TO 520 WAS REPLACED PER B737-800 SRM 51-40-02-0G. (LP 1165607)SDR DALA2025082806367Seat Track · corrodedAIRCRAFT 3767, CORROSION LEVEL 2- SEAT TRACK SECTION LBL 24.75 BTW STA 500H TO 520 AT PAX CABIN FLOOR STRUCTURE. CORRECVTIVE ACTION: REPLACED SEAT TRACK SECTION LBL 24.75 BTW STA 500H TO 520 PER B737-800 SRM 51-40-02-0G PAR. 7. (LP 1165303)SDR DALA2025082806366Transition Panel · puncturedAIRCRAFT 3870, FWD CARGO R/H TRANSITION ANGLE STA 490 TO 500A HAS PUNCTURE. REMOVED AND REPLACED SHIELD IAW B737-900 SRM 51-40-02-0G AND B737-900 SRM 51-40-05-0G. (LP 1165134)SDR DALA2025082806365Seat Track · corrodedAIRCRAFT 3769, CORROSION OUT OF LIMITS ON SEAT TRACK LBL 45 BTW STA 500H+10 TO 520. CORRECTIVE ACTION: CORROSION LEVEL 2. SEAT TRACK LBL 45 BTW STA 500H+10 TO 520 WAS FABRICATED PER BAC 1520-2789 REV. (B) AND B737-800 SRM 53-00-52-2R PROCEDURE 4, REPAIR 4 AND SDR DALA2025082806364Seat Track · corrodedAIRCRAFT 3769, CORROSION OUT OF LIMITS ON SEAT TRACK RBL 45 BTW STA 500H+10 TO 520. CORRECTIVE ACTION: CORROSION LEVEL 2 - SEAT TRACK RBL 45 BTW STA 500H+10 TO 520 WAS FABRICATED PER BAC1520-2789 REV. (B) AND B737-800 SRM 53-00-52-2R PROCEDURE 4, REPAIR 4, ANDSDR SWIA2025082700006Channel · crackedAFT BAGGAGE BAY DOOR CUTOUT SURROUND STRUCTURE FS1047.00 LOWER CHANNEL CRACKED (SRM 53-61-58 ITEM 16). (FILED OPEN)SDR DALA2025082706352Skin · damagedSHIP 3169 CATTERING HAD GALLEY CART ROLL INTO SIDE OF LH AFT FUSELAGE BEHIND 2L DOOR. CORRECTIVE ACTION: COMPLIED WITH ER/A 628804-14. (7223438).SDR DALA2025082706350Landing Gear · malfunctionedSHIP 3123 WHEN PUTTING THE GEAR UP THE ENTIRE LANDING GEAR ASSY CAME OUT AT LEAST ONE INCH FROM THE PANEL. CORRECTIVE ACTION: LIGHT CREW REPORTS ALL LANDING GEAR FUNCTION NORMAL DURING FLIGHT. NO FAULTS OR WARNINGS. TIGHTENED SCREWS FOR LANDING GEAR NORMAL CONSDR DALA2025082706347Structure · corrodedSHIP 3155 CORROSION UNDER WORK DECK GALLEY 1 AT PASSENGER CABIN. CORRECTIVE ACTION: COMPLIED WITH ER/A 627958-14. (1166080).SDR DALA2025082706346Insert · corrodedSHIP 3155 CORROSION FLOOR PANEL INSERT 261DF AT AFT GALLEY AREA. CORRECTIVE ACTION: COMPLIED WITH ER/A 627819-14. (1166054).SDR SWAA2025082708742Tailpipe · fireFIRE REPORTED COMING OUT OF THE TAILPIPE BY ANOTHER SWA ACFT WHEN THE ACFT WAS ON THE TAXI SHORT OF THE RUNWAY. PERFORMED ENGINE VENTS AND DRAIN INSPECTIONS IAW AMM 71-71-00. NO LEAKS NOTED. PERFORMED ENGINE RUN IAW AMM 71-00-00. ENGINE OPERATES NORMAL.SDR SWAA2025082708744Brake · smokeNUMBER 3 BRAKE SMOKING. R & R NR 3 MLG BRAKE ASSY PER AMM 32-41-41. OPS CHECK LEAK CHECK GOOD.SDR N6WA2025082707Angle · corrodedCORROSION ON ANGLE AND STRAP AT FS879-FS909 LBL17.63 OF WING TO FUSELAGE BODY FAIRING STRUCTURE. REMOVED AND REPLACED ANGLES AND STRAP AT FS879-FS909 LBL17.63 IAW CRJ SRM 51-42-06.SDR AALA202508274209Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: INTERNAL CRACK IN FUSELAGE SKIN AT BOTTOM OF ELECTRICAL GROUND POWER RECEPTACLE SURROUND DOUBLER LOCATED AT BS 231 AND S22R. REPAIRED DOUBLER PER SRM 53-10-15-2R-4.SDR FDEA202508261543Battery · inoperativeDURING MX PRE-FLIGHT FOUND OVERHEAD EMERGENCY LIGHTS AT CENTER, AND R1 DOOR AND R1 EXTERIOR LIGHT INOP. ATTEMPTED TO CHARGE BATTERY FOR OVER AN HOUR, NO FIX. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY (M730) AS PER ABOVE REF. ALL LIGHTS NOW WORKING.SDR FDEA202508261542Lamp · no testON ARRIVAL FOUND DOOR 1L INTERIOR FWD EMERGENCY LIGHT NO FULLY ILLUMINATED DURING GROUND TEST. AMM 33-51-01-2 RELAMPED DOOR 1L INTERIOR FWD EMERGENCY EXIT SIGN PER ABOVE REFERENCE. 2X LAMPS MPN 925007-1 REPLACED.SDR FDEA202508261541Floor Panel · dentedMAIN CARGO COMP. AT STA APROX STA 390 & 33RBL TO 54.75RBL, FLOORBOARD PANEL 222BFF ABOVE SURFACE SKIN HAS INDENTATION (MARKED) CORRECTION: CARGO. FABRIACTED NEW FLOOR PANEL# 222BFF MPN# 141T4856-106 STA 285-412 RBL 33- RBL 54.75 IN REF TO BOEING DWG 141T58SDR AALA202508275446Door · bindingAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS HARD TO OPEN AND CLOSE. RESECURED UPPER TRIM ON LAVATORY-D FRAME. PER CMM 25-40-64. OPERATIONAL CHECK GOOD.SDR AALA202508271649Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS CLAIMS LAVATORY-D DOOR LOCK IS VERY DIFFICULT TO LOCK AND UNLOCK. LUBRICATED AREA. PER CMM 25-40-64. OPERATIONAL CHECK NORMAL.SDR AALA202508273919Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT SEAT 21ABC INOPERATIVE. REMOVED BROKEN LIGHT AND INSTALLED NEW LED LIGHT, VIA SPLICINGING INTO EXISTING WIRES. PER SWPM 20-30-12. OPERATIONAL CHECK GOOD.SDR 6BMA202508270001Unknown · odorENTIRE CREW NOTICED FUEL SMELL IN CABIN AND COCKPIT DURING TAKEOFF CLIMB PASSING THROUGH 500' AGL FROM PLYMOUTH AIRPORT -- COULD NOT DUPLICATE.SDR DXTA2025082704732Warning Message · false activationMED WAS CLOSED WITH THE KEYLOCK IN THE LOCKED POSITION. THE CABIN DOOR CAS MESSAGE ILLUMINATED. COULD NOT DUPLICATE. MAINTENANCE PERFORMED IAW 52-10-00 AND 52-20-00.SDR SCNA20250827340Sight Glass · detachedL1 DOOR MOUNTED ESCAPE SYSTEM SIGHT GLASS WINDOW DETACHED. SECURED L1 DOOR ESCAPED SLIDE SIGHT GLASS COVER REF AMM 20-30-11SDR SCNA20250827339Battery Pack · no testROWS 12-22 DEF FAILED EMERGENCY BATTERY PACK FUNCTIONAL CHECK. REMOVED AND REPLACED BATTERY PACK IAW MM 33-51-06. OPS CHECKS GOOD. OK FOR SERVICE.SDR SCNA20250827338Insert · looseL1 DOOR ENTRY GALLEY MAT THRESHOLD PLATE HAS LOOSE INSERTS IN FLOORBOARD BETWEEN GIRT BAR FLOOR MOUNTS. INSTALLED NEW INSERTS AND SECURED THRESHOLD PLATE.SDR SCNA20250827337Battery Pack · no testEMERGENCY LIGHTS AT ROW 16-21 ABC FAILED EMERGENCY LIGHT BATTERY FUNCTION CHECK REMOVED AND REPLACED BATTERY PACK (M1694) AT ROW 13 ABC REF: AMM 33-51-06, REQUIRES OPERATIONAL CHECK. NOTE: EMERGENCY BATTERIES ON CHARGE UNTILL 1630 HRS. OPS CHECKED IAW MM 33-SDR SCNA20250827336Battery Pack · no testEMERGENCY LIGHTING FAILS 15 MINUTE MINIMUM ILLUMINATION CHECK ROWS 13-23 R/H CABIN. REMOVED AND REPLACED BATTERY PACK IAW MM 33-51-06. OPS CHECKS GOOD. OK FOR SERVICESDR SCNA20250827335Battery Pack · no testEMERGENCY LIGHTING FAILS 15 MINUTE MINIMUM ILLUMINATION CHECK ROWS 16-23 L/H CABIN. REMOVED AND REPLACED BATTERY PACK (M1694) AT ROW 13 ABC REF: AMM 33-51-06, REQUIRES OPERATIONAL CHECK. EMERGENCY BATTERIES ON CHARGE UNTILL 1630 HRS. OPS CHECKED IAW MM 33-51SDR SCNA20250827334Battery Pack · no testEMERGENCY LIGHTING FAILS 15 MINUTE MIMIMUM ILLUMINATION CHECK AT DOOR 1L. REMOVED AND REPLACED BATTERY PACK IAW MM 33-51-06. OPS CHECKS GOOD. OK FOR SERVICE.