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 FDEA202512142251Skin · dentedLEFT WING NR 5 SLAT HAS A DENT IN UPPER TRAILING WEDGE SKIN 34 INCHES FROM INBD EDGE. REPAIRED LT WING NR 5 SLAT UPPER T/E WEDGE SKIN IAW SRM 57-43-02-0I, PG 1-2, DETAIL 1 & 2, SRM 51-70-10-2R, AND AMM 51-21-10-7. MAJOR REPAIR. SEE JPF FOR OTHER WORK ACCOMPLSDR FDEA202512142250Skin · dentedLEFT WING NR 1 SLAT HAS DENT IN UPPER TRAILING WEDGE SKIN 16" FROM I/B EDGE. REPAIRED LEFT WING NR 1 SLAT UPPER T/E WEDGE SKIN SURFACE 16" FROM I/B EDGE IAW SRM 57-43-02-0I, PG 1-2 DETAIL 1 & 2, B767 SRM 51-70-10-2R, AND AMM 51-21-10-7. MAJOR REPAIR. SEE JPFSDR YENA2025121501202Filter · odorFLT#1437, BDL-MCO. FUME EVENT FROM 10000FT TO AFTER LANDING AND TO GATE. PACK 1 ONLY THE BACK OF CABIN WAS FINE VERY STRONG AT 3000FT AND RIGHT AFTER LANDING; C/W WITH INFO NOTICE 2017-T015L TROUBLESHOOT APU ODOR R/R RECIRCULATION FILTERS IAW AMM 21-21-41 PERSDR REXA2025121501038Bulb · inoperativeLEFT AFT EXTERIOR EMERGENCY LIGHT OUT. R & R LEFT AFT EXTERIOR EMERGENCY LIGHT BULB IAW CMM 33-52-07.SDR YENA2025121501201Control Panel · odorFLT#1007, BOS-BNA. AT FL 360 A STRONG ELECTRICAL ODOR WAS IDENTIFIED. ABOUT 5 MIN LATER SMOKE WAS COMING OUT OF GLARE SHEILD BEHIND THE VERTICAL SPEED DN + UP CONTROL WHEEL. SMOKE APPEARED 3 TO 4 TIMES DURING DECENT; INSPECTED WIRING AND COMPONENTS BEHIND AND SDR YENA2025121501200A/C Pack · odorFLT#927, EWR-MCO. ENVIRONMENTAL SYSTEM EMITTED FUMES IN COCKPIT SHORTLY AFTER TAKEOFF AND DURING CLIMB. FUMES ISOLATION GUIDES APPLIED. FUMES DISSIPATED WITH PACK 1 OFF. PACK 2 ON AND CROSS BLEED SHUT . APU BLEED AIR SUPPLY SYSTEM. OPENSDR SCNA20251215486Bulb · inoperative14ABC AND 15ABC EMERGENCY WINDOW FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT BULB ON 14ABC AND 15ABC EMERGENCY WINDOW FWD EMERGENCY LIGHT REF AMM 33-51-00. OPS CHECK GOOD.SDR SCNA20251215485Brake · contaminatedBOTH BRAKE SMOKING ON LANDING UP TO GATE. INSP NR 1 & 2 BRAKES IAW AMM 32-41-41. NO LEAKS NOTED, SUSPECT DEICING FLUID.SDR ABXA20251214334Warning Message · false activationLE SLAT DISAGREE CAUTION MESSAGE ON SHORT FINAL , AFTER LANDING MTX .PERFOMED L.E.S OPERATIONAL CHECK WITH HYDS. AND ELECTRCAL POWER IAW AMM 27-81-00. ALL FOUND NORMAL AT THIS TIME. MTX RETURNED AC TO SERVICESDR CALA2026090119139Skin · corrodedEXTERNAL FUSELAGE AT LAV EXHAUST CUTOUT SKIN WAS CORRODED. REPAIR ACCOMPLISHED IAW SRM 53-70-01-2R-3, REPAIR 3, TABLE 202, FIG 203.SDR SWIA2026070676558Stringer · corrodedMAIN AVIONICS STR 24R HAS CORROSION BETWEEN FS349 - FS364. INSTALLED NEW MAIN AVIONICS STRINGER 24R BETWEEN FS333.00 TO FS477.40. IAW. SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG SH690-31350 REV. M. LEAK CHECK GOOD, COMPLIED WITH SKYWEST TRACK CSDR REXA2026052700738Strut · corrodedPITTING WAS FOUND ON MLG SHOCK STRUT LH SIDE BELOW IDENTIFICATION PLACARD. MLG SHOCK STRUT WILL BE REPLACED BY CARD 900-32-730-705SDR JJBA20260211020Floorbeam · corrodedCORROSION FOUND ON FLOOR BEAM CROSS SUPPORT STRUCTURE AT FR 24, BETWEEN CENTER OMEGA BEAMS. REMOVED AND REPLACED THE FLOOR BEAM CROSS SUPPORT STRUCTURE AT FR24 BETWEEN CENTER OMEGA BEAMSSDR KCSA2026020201380Door · no discrepancyL1 DOOR WILL NOT OPEN A/T: TRANSFERRED TO DMI 100281653 IAW MEL B 25-10 AND 52-11-01-01B CAT C DUE 12-23-25 PLACARD INSTALLED (M) PROCEDURES C/W 100281674: REF DMI 100281653 LH DOOR WILL NOT OPEN A/T: PERFORMED OPS TEST OF DOOR IAW B777-300 AMM 52-12-00. DOORSDR JJBA20260130048Skin · corrodedTOILET WASTE VALVE SURROUND STRUCTURE HAS CORROSION. INSTALLED NEW DOUBLER ON TOILET WASTE VALVE SURROUND STRUCTURESDR VNAA20260125018Hinge Fitting · wornFREE PLAY ON BEARING OF RUDDER HINGE FITTING NR 3 AT REAR SPAR OF HORIZONTAL STABILIZER. RUDDER HINGE FITTING NR 3 AT REAR SPAR OF HORIZONTAL STABILIZER WAS REPLACED IAW RIL 2103, REV B.SDR VNAA20260125017Bracket · crackedCRACKED SLAT TRACK, 1-3 CANNISTER WELDED BRACKET AT THE LT WING FUEL TANK. THE CRACKED CANNISTER WELDED BRACKET AT THE LT WING FUEL TANK WAS REPAIR IAW REO 670-57-42-577 REV -.SDR HNAA2026012200060Threshold · corrodedPAX DOOR THRESHOLD ATTACHMENT HAS CORROSION AROUND THE NUTPLATE HOLES. R & R THE PAX DOOR AFT AND FWD THRESHOLD ATTACHMENTS IAW SRM 51-40-02.SDR AALA202601145814Stringer Clip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO STRINGER CLIP AT BS 947, S24L. REPLACED STRINGER CLIP PER SRM 51-10-02.SDR SWI2026F00044Spring · brokenFWD PAX DOOR AFT SLIDE FITTING HAS BROKEN SPRING. REMOVED AND REPLACED AFT PAX DOR AFT FITTING SPRING AND FLAP SLIDE PER ERJ 175 AMM 53-10-21SDR SWIA2026010500213Seat Track · corrodedCORROSION FLOOR LEVEL , AFT EDGE RH CTR SEAT TRACK FR84+2" , Y+12". REPAIRED AFT WET AREA SEAT TRACK AT FR 84 Y+10.5" REF EMB 175 SRM 53-23-10 REPAIR 04P AND ETD 2025-170-934391 REV:/.SDR SWAA2025123051936Wire · pulledWIRES PULLED OUT OF CONNECTORS ON FILLER PANEL 231LW EMERGENCY EXIT LIGHT. TERMINATED CONNECTOR D15242 PER SWPM 20-30-12 AND WDM 33-51-13. FUNCTIONAL TEST OF EMERGENCY EXIT SIGN L1070 TO BE PERFORMED ON CCN TTG8Q019B7Q1.SDR CALA2025122912457Rib · crackedLEFT WING, UPPER OUTBOARD TRAILING EDGE FIXED PANEL WITH CRACK ON THE INBOARD WALL. CRACK LENGTH: 8 IN APPROX.(REF AAR NR 1000063266) ESFR GENERATED. ESFR #2598 SUBMITTED AND UPLOADED TO AAR NR 1000063266. REMOVED AND REPLACED RIB ON LH WING O/B FIXED T/E BTWSDR CALA2025122912455Skin · crackedCRACK FOUND AT LT HORIZONTAL STAB LOWER SKIN AT STAB STA 147.90 , INBD ROW, 15.5" FROM FRONT SPAR. CRACK LENGTH 0.75". REF AAR N/R 99987207 ESFR INFORMATION ENTERED REMOVED DAMAGE AT LEFT HORIZONTAL STABALIZER LOWER SKIN AT STA 147.90" FABRICATED REPAIR PARTS SDR CALA2025122212309Engine · failedLEFT ENGINE FAILURE ON TAKEOFF. NR 1 ENGINE REMOVED AND REPLACED IAW TASK CARDS 25-0571-8-0052 AND 23-7100-1-4817. LEAK CHECKED. AIRCRAFT OK FOR SERVICE.SDR CALA2025122212292Fitting · crackedL2 DOOR CUTOUT, FWD FRAME, MECHANISM, SUPPORT STRUCTURE IS CRACKED. REMOVED AND REPLACED FITTING ON L2 DOOR FWD CUTOUT FRAME BS 684 -692.38. IAW SRM 51-40-02-0G, DWG 143N8375.SDR DALA2025122209276Bottle · no testDID NOT PASS TEST DOOR DAMPER OF PASSENGER CREW DOOR 831. REMOVED PASSENGER CREW DOOR DAMPER 831 ON UNSERVICEABLE CONDITION IAW FAM AMM 52-11-14- 000-001-A, STEP 3.B THRU 4.A. REPLACED THE DOOR DAMPER IAW FAM AMM 52-11-14-000-001-A, AND FAM AMM 52-11-14-400SDR SWAA2025121952015Tab · crackedWHILE ACCESSING FWD L/H OWE UPPER LINER FOR MODIFICATION; FOUND TWO PLASTIC TABS COMMON TO EXIT SIGN LIGHT ASSY CRACKED. REMOVED AND REPLACED LT OWE EXIST SIGN LIGHT ASSY IAW DWG Q841A3370-22.SDR DALA2025121909248Access Panel · delaminatedFOUND RT WING OTBD FLAP UPPER ACCESS PANEL 666MT, OTBD AREA DELAMINATED. DAMAGED AREA REPAIRED IAW SRM 57-53-01-2R-1, SRM 51-70-10-2R-4, FIG 201, & SRM 51-70-10. (1349215)SDR DALA2025121909247Access Panel · delaminatedFOUND RT WING OTBD FLAP UPPER ACCESS PANEL 666KT INBD AREA DELAMINATED. DAMAGED AREA REPAIRED IAW SRM 57-53-01-2R-1, SRM 51-70-10-2R-4 FIG201, & SRM 51-70-10 (1349207)SDR DALA2025121909246Skin · delaminatedFOUND RT WING NR 12 SLAT UPPER SURFACE INBD AREA DELAMINATED. DAMAGED AREA REPAIRED IAW SRM 57-43-02-2R-1, SRM 51-70-10-2R-4, FIG 201, & SRM 51-70-10. (1349204)SDR SWAA2025121852158Battery Pack · inoperativeALL EMERGENCY LIGHTS RELATED WITH BATTERY PACK M1670 INOPERATIVE. R & R THE BATTERY PACK M1670 IAW AMM 33-51-06-960-805, PERFORMED A GOOD OPS CHECK. OPS TESTED GOOD.SDR SWAA2025121852159Battery Pack · inoperativeALL EMERGENCY LIGHTS RELATED WITH BATERY PACK M1676 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AND PERFORMED GOOD OPS TEST IAW AMM 33-51-06-960-805.SDR AALA202512181003Flashlight · no testAIRCRAFT WAS NOT GROUNDED: AFT LH F/A EMERGENCY FLASH LIGHT BATTERY NEEDS REPLACEMENT. REPLACED F/A AFT LH FLASH LIGHT BATTERY IAW AMM 25-64-00.SDR DALA2025121809225Elec Connector · disconnectedDURING SVC CHECK FOUND SEAT MOUNTED EMERGENCY PATH LIGHT INOP. 5D EMERGENCY LIGHT INOPERATIVE, SLAVED IN NEW LAMP - NO HELP, REF AMM 33-51. LOCATED CONNECTOR NEAREST TO LIGHT - FOUND DISCONNECTED. RECONNECTED & OPERATIONAL CHECKS GOOD. (LP# 7894003)SDR AALA202512183799Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR 3N0A2025121800284Windshield · delaminatedTHE RIGHT WINDSHIELD SHOWED SIGNS OF DELAMINATION SHORTLY AFTER DEPARTING PWN. AFTER LANDING AT BNA A PICTURE WAS SENT TO DIR. OF MAINTENANCE AND TRIP SUPPORT, AND WE WERE ADVISED TO CONTINUE THE FLIGHT BACK TO BASE, AT FL 360 WE HEARD A LOUD CRACKING NOISE, SDR ASAA2025121363119Floor Panel · damagedAFT WET AREA CABIN FLOOR PANEL P/N 147A5810-23 REQUIRES REPAIRED 4 EACH HOLES NEED TO PLUGGED . GROUNDED - YES. ACCOMPLSIHED PERMANENT REPAIR TO AFT WET AREA CABIN FLOOR PANEL P/N 147A5810-23 IAW ASA B737-800 SRM 53-70-50-2R-0, 53-00-50-2R-6, & 53-00-50-2R-0.SDR ASAA2025121363118Floor Panel · damagedAFT WET AREA CABIN FLOOR PANEL P/N 147A5810-28 (STA 986 SIDE) REQUIRES REPAIRED (PLUG OF DELETE HOLES) MARKED WITH TAPE. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR TO AFT WET AREA CABIN FLOOR PANEL P/N 147A5810-28 IAW ASA B737-800 SRM 53-70-50-2R-0, 53-00-5SDR ASAA2025121363024Power Supply · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH M2335 POWER SUPPLY ARE INOP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY LIGHT POWER SUPPLY M2335 PER B737-800 AMM 33-51-06-960-806,INSTALLATION TEST GOOD.SDR UIEA2025121301343Structure · no discrepancyNR 1 ENG STRUCK GSE ON TOW IN. MX IN WORK WHILE IN AOGD FOR NR 1 ENG COWL DAMAGE. CONDITIONAL INSPECTIONS C/W PER AMM 05-51-06-212 REV 115, NO DEFECTS NOTED. R & R ENG 1 LH FAN COWL ASSY PER AMM 71-11-04-014 REV 115 & IPC 71-11-04-01 FIG 1 ITEM 60 REV 33. LESDR WX0A2025121732674Battery Pack · no test(AIRCRAFT NOT GROUNDED) FAIL THE BATTERY CAPACITY CHECK. REMOVED AND REPLACED EPSU REF WO533018"SDR DALA2025121709194Sensor · out of adjustESCAPE SLIDE GIRT BAR ENGAGEMENT LIGHT/S/ L1 DOOR SLIDE ARMED LIGHT INTERMITTANT. ADJUSTED L1 GIRT BAR LIGHT SENSOR IAW B757 AMM 25-66. OPS CHK NML. (1350130)SDR CALA2025121712179Door Frame · corrodedL2 CUTOUT STRUCTURE INNER CHORD STA 947.5-967.5 UPPER SURFACE WITH SEVERAL CORROSION AREAS. FOUND CORROSION OUT OF LIMITS, INNER CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02-0G-0 AND DWG 147A8501. REMOVED AND REPLACED L2 DOOR INNER CHORD REF. SRM 51-40-02-SDR DALA2025121709177Elec Connector · shortedPERFORMING OPS CHECK OF MANUAL MASK RELEASE FOUND MULTIPLE MASKS FAIL DROP. WHEN INITIATING DROP TEST OF MASKS FOUND BREAKER HA06 ON THE OVERHEAD C/B PANEL POPPED WHEN PUSHING THE MAN MASK BUTTON. SUSPECT WIRES SHORTING. CHECKED WIRES END TO END, AND END TOSDR SWAA2025121652317Seat Back · out of adjustSEAT 11D RECLINES INTO EXIT ROW. SECURED SEAT RECLINE ACTUATOR CABLE AT 11D IAW SIP, OPS CHECKED NORMAL.SDR SWAA2025121652148Flashlight · inoperativeFLASHLIGHT AFT GALLEY F/O SIDE INOPERATIVE. OPS TESTED THE FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOOD. COULD NOT DUPLICATE.SDR SWAA2025121652036Girt Bar · out of adjustFWD SERVICE DOOR GIRT HANGING LOW. SECURED THE GIRT BAR IAW AMM 25-66-01.SDR SWAA2025121652315Slide · unraveledCREW REPORTS FWD ENTRY ESCAPE SLIDE CAME OUT. REINSTALLED FWD ENTRY ESCAPE SLIDE IAW AMM 25-66-01.SDR SWAA2025121652128Girt Bar · no discrepancyFWD SERVICE DOOR GIRT BAR CAUGHT UPON OPENING. INSPECTED FWD SERVICE DOOR GIRT BAR IAW AMM 25-66-01, NO DEFECTS FOUND.