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 SWIA2025091900001Trunnion · damagedWHILE REMOVING LH MLG ASSY DAMAGED OCCURRED ON THE LH MLG MOUNTING TRUNNION. (FILED CLOSED)COMPLIED WITH REO 601R-57-21-3971 DATED: 2025-09-11 PERMANENT DISPOSITION FOR BLENDED GOUGE DAMAGE TO MLG TRUNNION FITTING FWD AND AFT LUG FACES, LHS ALL NDT'S COMPLIEDSDR SWAA2025091713349Floor Panel · peelingCABIN FLOOR PANEL 241DF HAS FIBERS THAT PEELED UP ON UPPER SURFACE. INSTALLED CABIN FLOOR 241DF PER AMM 53-21-00.SDR IPXA2025091500975Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 INBOARD IN BULK CARGO COMPARTMENT LEFT AREA. I.A.W AMM 53-01-06-000-801 REV.146 REMOVE MAIN DECK CARGO FLOOR PANEL, SEALANT, AND DADO PANELS. G.V.I AND CONDITION CHECK NORMAL. REMOVED DAMAGE ANGLE I.A.W SRM 51-40-02-0SDR AALA202509176441Egt Indication · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO THE FLIGHT CREW REPORTING THAT ON TAKEOFF AT MAX WEIGHT 206K, 31 DEGREES OAT & TOGA TAKE OFF HAD NR 1 ENGINE EGT OVER TEMP. THE AIRCRAFT LANDED SAFELY AT MIA WITHPUT FURTHSDR CALA2025091708995Shear Tie · corrodedAFT CARGO FRAME SHEAR TIE AT FR 62 BETWEEN STRINGER 42L AND 43L HAS CORROSION. REMOVED AFT CARGO FRAME SHEAR TIE FR 62 STR 42L & 43L. FABRICATED AND INSTALLED NEW SHEAR TIE AS REQUIRED IAW SRM 51-72-11-911-00 1.SDR CALA2025091608981Light · detachedSEAT 30ABC EMERGENCY AISLE LIGHT DETACHED FROM FRAME REQUESTING MEL, ALL OTHER EMERGENCY LIGHTS ARE OPERATIVE TOMC APPROVED REMOVED EMERGENCY EXIT FLOOR AISLE LIGHT AND SECURED WIRES. COMPLIED WITH MAINTENANCE FUNCTION IAW MEL CARD 3319E. OK FOR SERVICE. INSSDR SWAA2025091613340Battery Pack · inoperativeFORWARD LEFT HAND OVERWING EXTERNAL LIGHT AND LEFT HAND ISLE LIGHTS AT SEAT ROWS 8, 12, AND 15 DO NOT TEST. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805-NGSDR AALA202509168752Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: VALENCE MOUNTED EMERGENCY LIGHT LOCATED BETWEEN SEAT ROW 27FED AND 28FED IS INOPERATIVE. CONNECTED CONNECTOR AND OPERATIONAL CHECKED GOOD. PER SWPM 20-60-06.SDR AALA202509169582Terminal Block · inoperativeAIRCRAFT IN BASE MAINTENANCE: VALENCE MOUNTED EMERGENCY LIGHT LOCATED AT SEAT ROW 12FED IS INOPERATIVE. INSTALLED NEW TERMINAL BLOCK PIN, OPERATIONAL CHECKED GOOD. PER SWPM 20-90-15SDR COEA2025091605856Oxygen Bottle · leakingAN EMERGENCY DESCENT WAS PERFORMED DUE TO OXYGEN DEPLETION AT FL210. AN EMERGENCY WAS DECLARED. THE AIRCRAFT LANDED IN HDN WITHOUT FURTHER ISSUES. O2 BOTTLE REPLACEMENT IAW C208 MM 35-01-00.SDR DALA2025091606817Fairing · damagedDAMAGE NOTED RUDDER FAIRING PANEL 370CR. ER/A 629084-14 CREATED TRACKING TEMPORARY REPAIR ACCOMPLISHMENT. (1191759)SDR DALA2025091606816Access Panel · damagedENGINEERING CREATES LOGPAGE TRACKING DAMAGE TO RUDDER ACCESS PANEL PER ER/A 628805-14. ER/A 628805-14 LOGPAGE CREATED TRACKING TEMPORARY REPAIR TO RUDDER ACCESS PANEL. (1191716)SDR DALA2025091606812Hinge Fitting · gougedGOUGE DAMAGE NOTED ON THE LT HORIZONTAL STAB INBD HINGE FITTING WHILE IN ATL FOR C CHECK. ER/A 628919-14 CREATED TO PROVIDE TEMPORARY DISPOSITION FOR NOTED DAMAGE. PERMANENT REPAIR TO BE ACCOMPLISHED WITHIN 24 CALENDAR MONTHS. (1192258)SDR REXA2025091600868Sensor · faultedDURING CLIMB OUT AT AROUND 8000+ BRAKE OVHT WARNING MSG DISPLAYED FOR THE IB L SIDE BRAKES. FOLLOWED THE QRH. MSG WENT AWAY MOC NOTIFIED DEFERD LH IB BRAKE TEMP. INDACATION. MEL 32-46-1D CAT C MX PROCEDURES C/W. MOC NOTIFIED. 7821 PLACARD. R & R BREAK TEMP SSDR SCNA2025091500375Seat Track · out of limitsCOPILOT AFT OUTBOARD SEAT TRACK OUT OF LIMITS. REMOVED AND REPLACED COPILOT AFT OUTBOARD SEAT TRACK IAW B737 AMM 25-11-11-400-801SDR AALA202509155425Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT - THE FLOOR PROXIMITY LIGHT ON THE SIDE OF THE 6H SEAT IS INOP. MAINTENANCE FOUND WIRE BROKEN AT CONNECTOR. INSTALLED NEW CONNECTOR IAW SWPM 20-30-15. OPS CHECKED GOODSDR IPXA2025091500931Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 RBL 80 INBOARD IN BULK CARGO COMPARTMENT RIGHT AREA. REMOVED DAMAGE ANGLE I.A.W SRM 51-40-02-0G REV.93. INSTALL NEW ANGLE I.A.W SRM 51-40-02-0G REV.93 AND B0EING DWG NO 146T5650 SHEET 5 REV C.SDR DALA2025091506765Battery Pack · inoperativeEMERGENCY PATH LIGHTS INOP AT RIGHT AISLE ROWS 41-49. R & R EMERGENCY BATTERY PACK (M6760) PER AMM 33-51. OPS GOOD. (7600524)SDR DALA2025091506763Valve · inoperativeDUE TO ANTISKID FAIL LIGHT ILLUMINATED ON APPROACH. CORRECTIVE ACTION: RECORDED AACU BITE FAULT BOX 1-4 INTERNAL FAULT. REPLACED AACU. FAULT CLEARED. OPS CHECK GOOD.SDR DALA2025091506754Plate · corrodedCORROSION ON SIDE PLATE LH BTW STA 500H-500I. SIDE PLATE LH BTW STA 500H-500I AT FWD CARGO COMPARTMENT WAS REPAIRED DUE CORROSION LEVEL 2 PER B737-800 SRM 53-00-53-2R PROCEDURE 6.SDR DALA2025091506753Seat Track · corrodedEXFOLIATING CORROSION INSIDE SEAT TRACK SCALLOPS STA 880TO STA 888 AT LBL 24. REPAIRED SEAT TRACK SCALLOPS DAMAGE AT STA880 TO STA 888 AT LBL 24 IAW B737-900 SRM 53-00-52-2R PROCEDURE 5.SDR DALA2025091506752Floor Support · corrodedCORROSION ON FLOOR SUPPORTS BTW STA 767 AND STA 787 RAIL-CHANNEL RBL 8.1; RBL 3 AND LBL 12.5. FLOOR SUPPORTS BTW STA 767 AND STA 787 RAIL-CHANNEL RBL 8.1; RBL 3 AND LBL 12.5 AT AFT CARGO WERE REPAIRED DUE CORROSION LEVEL 2 PER SRM 53-00-53-2R PROCEDURE 2 REPAISDR DXTA2025091504908Light · malfunctionedIN FLIGHT, NOTICED EMERGENCY LIGHTS CAME ON WITH SWITCH IN ARM POSITION. AFTER LANDING, TURNED SWITCH TO OFF AND BACK TO ARM AND LIGHTS STILL REMAINED ON. DURING TROUBLESHOOTING FOUND EMERGENCY LIGHT CIRCUIT BREAKER TRIPPED, AFTER RESET, SELECTED EMERGENCY LSDR DXTA2025091504913Handle · bindingEXTREMELY HARD TO ROTATE THE HANDLE TO OPEN THE MAIN ENTRY DOOR. INSPECTED MED DOOR LATCH MECHANISM RIGGING AND FOUND ROD 45 LENGTH, INNER HANDLE DETENT SPRING PRESSURE AND INNER HANDLE STOP BOLT OUT OF ADJUSTMENT. ADJUST ROD 45 LENGTH, INNER HANDLE DETENT SPRSDR DXTA2025091504915Switch · faultedON DECENT INTO VANCOUVER, PRESSED THE PAX SAFETY LIGHT SWITCH. BUTTON SAYS ON, BUT THE ONLY LIGHTS THAT COME ON ARE THE NO SMOKING LIGHTS. CHECKED THE EMERGENCY LIGHTS WITH ITS PRIMARY SWITCH AND THEY CHECK FINE. BUT THE EXIT LIGHTS DON'T TURN ON WITH THE PAX SDR DXTA2025091504916G Switch · faultedTHE FOLLOWING EMERGENCY LIGHT COMPONENTS REMAIN ILLUMINTED AFTER THE EMERGENCY SWITCH IS TURNED OFF- WHITE MAIN DOOR EXIT SIGN, SEAT 3 READING LIGHT AND FLOOR LIGHT, WING INSPECTION LIGHT. EMERGENCY LIGHTS REMAIN ON AFTER SHUTDOWN PROCEDURE DID NOT CLEAR THE SDR CALA2025091508898Skin · damagedFWD CARGO DOOR SKIN HAD EXCESSIVE DAMAGE, DENTS. REMOVED AND REPLACED FWD CARGO DOOR SKIN IAW SRM 52-30-01-2R-3.SDR CALA2025091508894Girt Bar · fodDOOR 4R SLIDE LIGHT INOPERATIVE. REMOVED DEBRIS FROM GIRT BAR AREA. SLIDE LIGHT OPS NORMALSDR CALA2025091508893Bracket · no discrepancySERVICE DOOR EMERG SLIDE BAR FLOOR BRACKET LOOSE. INSPECTED SERVICE DOORS SLIDES IAW AMM 25-66-01. NO DAMAGE OR LOOSE BRACKETS FOUND. NOTICED NEXT TO 2R DOOR FA SEAT CLIP DETACHED. ADJUSTED CLIP TO FA SEAT.SDR CALA2025091508892Slide · unraveledDOOR 1R SLIDE MATERIAL HANGING OUT OF SLIDE CASE TUCKED EXCESS GIRT MATERIALSDR VNAA2025091411101Safety Valve · faultedCABIN PRESSURIZATION FAILED IN DESCENT INTO BHM. APPROX 15000FT PRESSURIZATION BECAME ERRATIC AND CABIN ALT STARTED TO INCREASE. AT 8500FT AMBER CABIN ALT THEN RED CABIN ALT. RAN QRC/ARH FOR CABIN ALT. REMOVED AND REPLACED NR 2 SAFTEY VALVE IAW AMM 21-32-03-0SDR VNAA2025091411102Windshield · crackedCA WINDSHIELD OUTER LAYER MULTIPLE CRACKS DURING FLIGHT. PERFORMED INSTALLATION OF LH SIDE WINDOW IAW AMM 56-12-01-400-801-A01-PSA.SDR SPAA202509109003Battery Pack · inoperativeFOUND EMEERGENCY EXIT LIGHT AT OVERWING EXIT INOPERATIVE. R&R EMERGENCY BATTERY POACK AT M1669 IAW AMM 33-51-51 OPS CHECK SATIS.SDR SPAA202509109002Battery Pack · inoperativeAFT CABIN & GALLEY EMERGENCY EXIT LIGHT INOPERATIVE. R&R EMERGENCY LIGHT BATTERY PACKS AT M1672 & M1673 IAW AMM 33-51-51. OPS CHECKS SATISFACTORYSDR SPAA202509109001Battery Pack · inoperativeAFT CABIN & GALLEY EMERGECY EXIT LIGHTS INOP. R& R EMERGENCY EXIT LIGHT BATTERY PACKS AT M1672 & M1673 IAW AMM 33-51-51-. OPS CHECK SATIFACTORYSDR ASAA2025091060829Cover · detachedOVHD CABIN CENTER EMERGENCY EXIT SIGN COVER (FWD SIDE) CAME OFF. GROUNDED - YES. REINSTALLLED COVER ON CENTER OVHD EMERGENCY EXIT SIGN. OPS OK.SDR ASAA2025091060828Cover · missingNEAR AFT RIGHT FA JUMPSEAT, EXIT SIGN COVER MISSING. GROUNDED - YES. INSTALLED NEW EXIT SIGN COVER. REF AMM 33-51-01. OPS CHECKS GOOD.SDR N6WA2025091202Splice · crackedAFT BELLY FAIRING SPLICE JOINT BETWEEN 195DL/196DR IS CRACKED. REMOVED AND REPLACED AFT BELLY FAIRING SPLICE JOINT BETWEEN 195DL/196DR IAW CRJ SRM 51-42-13SDR SWAA2025091213265Lamp · inoperativeBOTH EMERGENCY LIGHTS BEHIND L2 AND R2 DOOR INOPERTAIVE. REPLACED THE LAMPS BOTH EMERGENCY LIGHTS BEHIND L2 AND R2 IAW AMM 33-51-04. OPS CHECK NORMAL.SDR SWAA2025091213174Battery Pack · no testBATTERY PACK M1672 FAILED CAPACITY TEST. R&R BATTERY PACK M1672 IAW AMM 33-51-06.SDR SWAA2025091213173Battery Pack · no testBATTERY PACK M1673 FAILED CAPACITY TEST. R&R BATTERY PACK M1673 IAW AMM 33-51-06.SDR SWAA2025091213774Light · failedFA REPORTS A STEADY RED LIGHT ON AFT ATTENDANT PANEL EMERGENCY EXIT LIGHTS. PERFORMED EMERGENCY LIGHTS OPERATIONAL CHECK REF AMM 33-51-00.SDR N6WA2025091201Splice · corrodedAFT FAIRING SPLICE FWD JOINT HAS CORROSION. REMOVED AND REPLACED AFT FAIRING SPLICE FWD JOINT IAW CRJ SRM 51-42-13SDR AALA202509126441Egt Indication · activatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO THE FLIGHT CREW REPORTING THAT ON TAKEOFF AT MAX WEIGHT 206K, 31 DEGREES OAT & TOGA TAKE OFF HAD #1ENGINE EGT OVER TEMP. THE AIRCRAFT LANDED SAFELY AT MIA WITHPUT FURTHER SDR AALA202509128811Sliding Window · crackedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO ELP DUE TO THE FLIGHT CREW REPORTING THAT AT FL320 AT THE LEFT SLIDING WINDOW THEY HEARD LOUD POP AND THEN THE WINDOW SPIDER WEBBED CRACKED. THE FLIGHT CREW RAN QRH PROCEDURE AND NOTSDR DALA2025091206740Engine · making metalDIVERSION TO THL DUE TO LEFT ENGINE FAIL. CREW FELT A SHUDDER FOLLOWED BY OIL TEMP RISE TO RED, AND OIL FILTER MESSAGE. FOLLOWED QRH AND SHUTDOWN ENGINE. FOUND METAL ON ALL CHIP DETECTORS, REMOVED AND REPLACED ENGINE.SDR DALA2025091206739Lanyard · unsecureDURING AIRCRAFT INSPECTION NOTICED THE 1R DOOR ESCAPE SLIDE LANYARD IS COMING OUT FROM THE BOTTOM OF THE DOOR AND IS ON THE GALLEY FLOOR. RESECURED MOORING LINE FOR 1R ESCAPE SLIDE IAW B757 AMM 25-66. (7549810)SDR DALA2025091206735Cover · detachedFOUND OVERWING EXIT LIGHT COVER FELL OFF. SECURED EXIT LIGHT COVER AS REQUIRED. (1191128)SDR SIMA20250910001Blade · damagedDURING APU SHUTDOWN THERE WAS A LOUD BANG, APU SHUT DOWN IMMEDIATELY, LARGE CLOUD OF SMOKE SHOT OUT OF THE EXHAUST AS WELL AS LARGE PIECES OF METAL. DURING INSPECTION OF APU FOUND APU TAILCONE INNER LINER TO BE DAMAGED FROM THE EXPLOSION. FOUND 4 HOLES AND THESDR CALA2025091208864Unknown · noiseCA WINDOW HISSING NOISE INFLIGHT SUSPECT OVERHEAD DRIP SHIELD DRAINS SOURCE OF NOISE, FLUSHED TUBES AND CHECKED FOR BELLY DRAIN VALVE OBSTRUCTIONS. ACCOMPLISHED AIRCRAFT PRESSURIZATION TO 4PSI DIFFERENTIAL. DRAIN TUBE EXIT AIR NOISE STOPPED AT 2.5 PSI. LEAK