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 CALA2025080107203Wedge · delaminatedRIGHT INBD MAIN FLAP OTBD AFT WEDGE WITH EVIDENCE OF DISBONDED. REMOVED AND REPLACED RT INBD MAIN FLAP T/E WEDGE IAW SRM 51-40-02-0G-0, AND DWG 113A2100.SDR CALA2025080107202Wedge · corrodedLEFT INBD FLAP OTBD AFT WEDGE WITH EVIDENCE OF A DISBONDED AREA AT TE. REMOVED AND REPLACED LT INBD MAIN FLAP T/E WEDGE IAW SRM 51-40-02-0G-0, AND DWG 113A2100.SDR CALA2025080107201Stringer · corrodedCORROSION FOUND AT STRINGER 27L, BS 540. REPAIRED STRINGER 27L BETWEEN BS 500I & 540 IAW AAR-MIA ESR-WI 2023573-12-12400, REV IR, AND EC/RA 5330-07571, REV. ORIGINAL.SDR VNAA2025073111103Elevator System · no discrepancyELEVATOR SPLIT CAUTION MSG IN CRUISE FLIGHT AT FL360. VERIFIED ELEVATOR CABLE TENSIONS THROUGHOUT FUSELAGE PER AMM 27-31-00-750-801 CABLE TENSIONS WITHIN LIMS. VISUALLY INSPECTED ELEVATOR CONTROL COMPONENTS PER FIM 27-31-00-810-803. PER AMM 27-31-00-70-80SDR SWAA2025073195565Flashlight · no discrepancyAFT RT OTBD FLIGHT ATTENDANTS FLASHLIGHT BASE INOPERATIVE. OK TO CONTINUE PER MEL 25-64-02A SP1B. PERFORMED OPS TEST ON AFT RT OTBD FA FLASHLIGHT IAW AMM 25-64-00. OPS CHECKED GOODSDR SWAA2025073195676Light · inoperativeFUSELAGE LT AFT WING EMERGENCY LIGHT INOPERATIVE. RELAMPED AFT LT WING EMERGENCY EXIT LIGHT IAW AMM 33-51-04. OPS CK PASSED.SDR SWAA2025073195666Rib · crackedRIB AT LE STAB STA 151.75 CRACKED ON RT HORIZONTAL STAB REMOVABLE LEADING EDGE. REMOVED RIB AT LE STAB STA 151.75 PER SRM 51-40-02.SDR AALA202507310264Skin · corrodedAIRCRAFT WAS GROUNDED: WASTE OVERBOARD VENT SHOWS SIGNS OF CORROSION. (OPEN)SDR AALA202507316684Hose · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF WITH GEAR RETRACTION, MASTER CAUTION HYDRAULIC ILLUMINATED. SYSTEM-A ENGINE 1 LOW PRESSURE ILLUMINATED. SYSTEM-A ELECTRIC NUMBER 2 LOW PRESSURE ILLUMINATED. AIRCRAFT AIR INTERRUPTED BACK TO ANSDR AALA202507313384Hose · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF WITH GEAR RETRACTION, MASTER CAUTION HYDRAULIC ILLUMINATED. SYSTEM-A ENGINE 1 LOW PRESSURE ILLUMINATED. SYSTEM-A ELECTRIC NUMBER 2 LOW PRESSURE ILLUMINATED. AIRCRAFT AIR INTERRUPTED BACK TO ANSDR AALA202507310712Hose · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF WITH GEAR RETRACTION, MASTER CAUTION HYDRAULIC ILLUMINATED. SYSTEM-A ENGINE 1 LOW PRESSURE ILLUMINATED. SYSTEM-A ELECTRIC NUMBER 2 LOW PRESSURE ILLUMINATED. AIRCRAFT AIR INTERRUPTED BACK TO ANSDR AALA202507316372Hose · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF WITH GEAR RETRACTION, MASTER CAUTION HYDRAULIC ILLUMINATED. SYSTEM-A ENGINE 1 LOW PRESSURE ILLUMINATED. SYSTEM-A ELECTRIC NUMBER 2 LOW PRESSURE ILLUMINATED. AIRCRAFT AIR INTERRUPTED BACK TO ANSDR CALA2025073107128Check Valve · faultedSTARTING ENGINE NR 2 WAS 2 1/2 MINS TO STARTER CUTOUT WITH STRONG EXHAUST ODOR IN CABIN. NR 2 ENGINE OPERATED IAW AMM 71-00-00-712-021-N00. DURING ENGINE OPS, INSPECTION OF CABIN CARRIED OUT IAW AMM 05-51-56-940-801-C1 TO IDENTIFY ODOR. NO UNUSUAL ODORS PRESSDR CALA2025073107127Rib · crackedRIGHT MAIN LANDING GEAR SUPPORT RIB 5 FORWARD LUG INSPECTION FOUND CRACK ON RT MLG SUPPORT RIB 5 FORWARD LUG. AFT SIDE REF AVO14715, ACP STEPS 1,2 AND 3. CRACKED AS INDICATED. NO DAMAGE FOUND WITH 10X ON SURROUNDING AREAS AT RADII AND SURFACES. C/W FPI IAW NTSDR CALA2025073107126Support Bracket · crackedL2 DOOR HINGE COVER LWR SUPPORT BROKEN. REPLACED WITH NEW P/N 143N6165-9 R & R SUPPORT ON L2 DOOR LWR HINGE IAW B757-20 0 SRM 51-40-02-OG-0 .SDR SWAA2025073095898Battery · inoperativeCREW REPORTS, FWD MEGAPHONE INOPERATIVE. R & R MEGAPHONE BATTERIES IAW AMM 25-64-00.SDR WX0A2025073032520Lever · out of rig(AIRCRAFT NOT GROUNDED) DOOR L2 ARMED LEVER OUT OF RIG. FA'S REPORT LOW CONFIDENCE IN SLIDE DEPLOYMENT DURING EVAC. PERFORMED INSTALLATION INSPECTION OF THE R2 DOOR IAW AMM 25-62-44-400-803-A AND DVI OF DOOR STOP ASSEMBLY IAW AMM 52-13-00-200-001-A. NO ABNORMSDR YENA2025073000788Warning Message · illuminatedFLT#2230, MKE-BOS. (AIRCRAFT WAS DIVERTED TO ORD) CLIMBING THROUGH FL270 AFTER ENCOUNTERING ICE "WING A/ICE FAIL" CAUTION APPEARED ON EICAS. R WAIV SHOWED FAILED OPEN ON AIR SYNOPTIC PAGE; ACCOMPLISHED EFIM FAULT CODE 3012F0015 - RESET FAULT. ACCOMPLISHED FUNSDR CALA2025073007092Tire · odorBURNT RUBBER SMELL AT TOUCHDOWN AT 1L AND 1R FROM FLT ATTENDANT. AREA AROUND DOORS 1L AND 1R INSPECTED, NO VISIBLE SIGNS OF DAMAGE, LEAKAGE OR OVEHEATING. WHEELS AND BRAKES INSPECTED WITH NO FAULTS FOUND, SMELL LIKELY DUE TO NORMAL TIRE/BRAKE HEATING ON LANDINSDR CALA2025073007091Cargo · odorSTRONG SMELL OF ROTTING FISH ON AIRCRAFT SOURCE OF FISH SMELL IS COMING FROM FWD PIT FLOOR AND BEING CIRCULATUED INTO THE CABIN BY THE RECIRCULATION FILTERS IN THE FWD PIT. SUSPECT THE SOURCE WAS A PASSENGER, CHECKED BOX OR COOLER WITH THEIR PRIZED CATCH FROSDR CALA2025073007084Warning Message · false activationDURING CLIMBOUT 2 INTERMITTENT ECAM DOOR RT FWD CABIN. CABIN PRESSURE NORMAL. FAULT WAS NOT ACTIVE AND THERE IS NO HISTORY OF THIS FAULT IN 90 DAYS. REF TSM 52-11-00-810-803-A. FWD RIGHT CREW/PASS DOOR INDICATIONS OP CHECK GOOD. OK FOR SERVICE.SDR CALA2025073007083Access Panel · unsecureRIGHT WING FWD EMERGENCY EXIT DOOR LOWER ACCESS PANEL DETATCHED AND FALLING OFF. RESECURED FASTENER AND INSTALLED LIFT STRAP COVER REF AMM ASK 52-22-00-580-803. OK FOR SERVICE.SDR CALA2025073007082Bottle · faultedOPERATIONAL TEST OF THE OFF-WING ESCAPE SLIDE PROCEDURE - REMOVED THE RIGHT INFLATION BOTTLE OF RIGHT OFF WING SLIDE SYSTEM DUE TO OPERATIONAL TEST REF AMM TASK 25-65-02-004-002. REPLACED RIGHT BOTTLE , ESCAPE SLIDE, WING REF AMM 25-65-02-404-009. COMPLIED WISDR CALA2025073007081Slide · out of adjustESCAPE SLIDE PACK BUSTLE LOOSE 1R. DOOR 1R SLIDE Z-FOLD REINSTALLED IAW AMM 25-66-01-400-801. OK TO CONTINUESDR CALA2025073007080Retainer · out of adjustGIRT BAR PARTIALLY ATTACHED WHEN CREW ARRIVED. DOOR 1L ADJUSTED GIRT BAR DOOR RETAINERS TO ALLOW GIRT BAR TO BE FULLY SEATED IN THE GRIT BAR DOOR RETAINERS.SDR CALA2025073007079Warning Message · false activationDOOR FLIGHT LOCK 2L EICAS STATUS #2 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 5211300. PSEU 2 (R2) PER INBD MAINT. MSG 52-11300 FIM 52-11 TASK 805. ACCOMPLISHED "FLT LSDR CALA2025073007078Warning Light · false activationDESCEND THRU 16000 AFT SERVICE DOOR LIGHT CAME ON. HANDLE NOT SE ATED PER FA. INSPECTED DOOR AREA AND FOUND NO OBVIOUS DAMAGE OR FOD. OPERATED DOOR FORM INSIDE PER AMM 52-41-00-860-803 AND FOUND DOOR WARNING INDICATION TO OPERATE NORMAL. DOOR R2 HAS NO RECENSDR CALA2025073007077Slide · looseDOOR 2L SLIDE PACK IS SUSPECTED TO HAVE BECOME LOOSE THUS MOVING THE BUSTLE COVER LOWER DOOR 2L SLIDE BUSTLE LOWER FWD LATCH BECAME DISENGAGED, BUSTLE REMOVED SLIDE PACK CHECKED IAW AMM 25-66-98-206-001, NO DEFECTS NOTED. SLIDE BUSTLE RE-FITTED, ARM/DISARM LEVSDR SIMA20250727001Battery · inoperativeR2 TOP AND BOTTOM EMERGENCY LIGHT INOP. R & R AFT RH EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPC GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA20250727002Battery · inoperativeMID CABIN CEILING PANEL EMERGENCY LIGHT INOP RAR AFT RH EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPC GOOD. NO FURTHER DEFECTS NOTED. REFER TO NRWC 792-LIT-01610 FOR PARTS ON/OFF TRANSACTION.SDR AALA202507302685Tire · flatAIRCRAFT WAS GROUNDED: TIRE PRESS CAUTION ON EICAS GEAR PAGE SHOWS TIRE #12 AT 1 PSI. AS A PRECAUTION EMERGENCY DECLARED AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED #12 MLG TIRE IAW AMM 32-45-01.SDR DALA2025073005711Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. LOCATIONS:41F. R & R 41F AISLE LIGHT SHROUD ASSY AS PER CMM 25-28-89.SDR AALA202507295761Fan · failedAIRCRAFT WAS GROUNDED: STRONG RUBBER BURNING SMELL THROUGHOUT CABIN AND FLIGHT DECK. FOUND RIGHT HAND CABIN RECIRCULATION FAN BEARING BURNT UP. REMOVE AND REPLACED RIGHT HAND CABIN RECIRCULATION FAN (AALA202507295761) AND RECIRCULATION FILTER (AALA202507293610SDR AALA202507293610Air Filter · dirtyAIRCRAFT WAS GROUNDED: STRONG RUBBER BURNING SMELL THROUGHOUT CABIN AND FLIGHT DECK. FOUND RIGHT HAND CABIN RECIRCULATION FAN BEARING BURNT UP. REMOVE AND REPLACED RIGHT HAND CABIN RECIRCULATION FAN (AALA202507295761) AND RECIRCULATION FILTER (AALA202507293610SDR AALA202507292725Cids · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO DFW DUE TO THE FLIGHT CREW REPORTING SMOKE DETECTOR FAULTS FOR THE FORWARD AND AFT CARGO COMPARTMENTS. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACSDR AALA202507299539Wire · brokenAIRCRAFT WAS NOT GROUNDED: FLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING LIGHT (SEAT-MOUNTED EMERGENCY LIGHT) IS INOPERATIVE ON SEAT ROW 36ABC. MAINTENANCE FOUND CANNON PLUG CONNECTOR 7260VC15 WIRE BROKEN, REPINNED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIOSDR DALA2025072905702Light · inoperativeCABIN CHIME 3 TIMES REPEATED WITH EMER LIGHTS FAULT - LH OWEED DOOR MSG ON CMS PANEL. FOUND FWD LT EXTERIOR OWEED LIGHT INOP. R/R FWD LT EXTERIOR OWEED LIGHT PER A220 AMP 33-55. OPS TEST GOOD. (LP# 6359832)SDR 2025FA0000530Seal · wornON 7/27/2025, N276BG DEPARTING KELP FOR A PASSENGER PICKUP IN KLRU, THE RH ENGINE BLEED LIGHT CAME ON INDICATING A LEAK IN THE PYLON AREA. THE CAPTAIN DECIDED TO RETURN TO ELP. THE RH PYLON PANEL WAS REMOVED AND ENGINE RUN COMPLETED, A SMALL BLEED AIR LEAK WASSDR DALA2025072905682Floorbeam · corroded(LOG 1106450) AFTER REMOVED FLOOR SUPPORT ON STA 992 BTW RBL 35 TO RBL 44 CORROSION WAS FOUND IN COMPONENT. FLOOR SUPPORT ON STA 992 BTW RBL 35 TO RBL 44 WAS FABRICATED AND REPLACED PER BOEING DWG 147A5710 REV. C.SDR DALA2025072905681Skin · cracked(LOG 1109326) CRACK_ON LOWER SKIN_HORIZONTAL STAB STA 140 TO 160 BTW FRONT SPAR AND REAR SPAR RH SIDE. LOWER SKIN HORIZONTAL STAB STA 140 TO 160 BTW FRONT SPAR AND REAR SPAR RH SIDE WAS REPAIRED PER B737-800 SRM 55-10-01-2R REPAIR 11.SDR CALA2025072907049Light · faultedEMERGENCY EXIT LIGHT ON ROW 20A ROW 20A SIDEWALL WALL REMAINS ON WHEN CABIN LIGHTS ARE SWITCHED OFF OR ANY OTHER MODE THAN BRIGHT/ BOARDING REQUEST DEFERRAL TOMC APPROVED DDP FOLLOWED AND STICKER APPLIED. TO ROW 20A SIDEWALL LIGHT *DM* SEE M/L FOR SIDEWALL LIGSDR CALA2025072907048Wire Splice · shortedFOUND FIRST CLASS SEATS 1AB TO 5AB EMERGENCY EXIT LIGHTS INOP WHILE ACCOMPLISHING LIGHT TEST. CHECKED BY SWAPPING NEW POWER SUPPLY TWICE ON BOTH POWER SUPPIES LOCATED AT M1674 & M1675 MOUNTED ON CEILING PANEL FWD ENTRY LIGHT, NO HELP. REPLACED SEAT LIGHTS, NO SDR CALA2025072907041Trim System · faultedELETRIC STAB TRIM INOP REF FIM 27-41 TASK 804, ACCOMPLISHED RESET PER ITEM C. (1) AND STAB TRIM NOW WORKS UP AND DOWN. NO RESET HISTORY FOUND FOR LAST 30 DAYS REF ITEM F. (1) (B).SDR CALA2025072907040Web · corrodedMAIN CABIN AFT WET AREA CORROSION/GOUGE AT FLOOR WEB STA 986.5 LBL 39". REMOVED AND INSTALLED WEB BS 986.5 LBL 39 IAW SRM 51-40-02. REMOVED AND INSTALLED WEB STA 986.5 LBL 39" IAW SRM 51-40-02-0G-0 AND SRM 51-40-05-0G-0 AND DWG 147A5700.SDR CALA2025072907039Angle · crackedWHEEL WELL VAPOR BARRIER UPPER ANGLE CRACK AT RBL 5. ACCOMPLISHED REPAIR OF RT VAPOR BARRIER UPPER ANGLE BS 663 RBL 3 TO RBL 20 IAW SRM 57-10-10-2R-5, APPLIED FILLET SEAL AS REQUIRED AT REPAIR AREA IAW AMM 51-31-00-390-802 AND APPLIED CIC AS REQUIRED IAW AMMSDR CALA2025072907038Angle · crackedLEFT WHEEL WELL VAPOR BARRIER UPPER ANGLE CRACKED AT LBL 5. ACCOMPLISHED REPAIR OF LT VAPOR BARRIER UPPER ANGLE BS 663 LBL 3 TO LBL 20 IAW SRM 57-10-10-2R-5. APPLIED FILLET SEAL AS REQUIRED AT REPAIR AREA IAW AMM 51-31-00-390-802 AND APPLIED CIC AS REQUIRED ISDR CALA2025072907037Skin · crackedC-SCAN INSPECTION REVEALED CRACK AT BOTTOM SKIN R/H HORIZ.STAB. RIB STA. 157.10 APPROX. 8" FWD OF AFT SPAR. RT HORIZONTAL STAB LOWER SKIN REPAIR AT RIB STATION 157.10. NEED REPEAT INSPECTION IRW SRM 55-10-01-2R-11 REPAIR #11 CATEGORY B REPAIR.SDR CALA2025072907036Skin · crackedC-SCAN INSPECTION REVEALED CRACK AT BOTTOM SKIN LT HORIZ.STAB RIB HSS 157.1 APPROX. 10 INCH FWD OF AFT SPAR. REFER TO LP 5716501 FOR DIP AND DIP REQUIREMENTS. VERIFY THE REFERENCE L/P 5716501 FOR CORRECTIVE ACTIONS.SDR FDEA202507271327Floor Panel · damagedMAIN CARGO COMP. AT APROX STA. 350 & 221CFF, LBL11 TO RBL11 FLOORBOARD PANEL SURFACE SKIN HAS INDENTATIONS (MARKED) FABRICATED NEW FLOOR PANEL 221CFF, MPN:141T5856-105, RBL 11 LBL 11, STATION 285-412 IN REF TO BOEING DWG Ï¿½141T5856-105. SEE JPF FOR ALL WSDR SCNA20250729285Flashlight · inoperativeFA FWD RIGHT EMERGENCY FLASHLIGHT INOPERATIVE. R&R FWD FA INBD FLASHLIGHT REF AMM 25-64-00 OPS CHECK GOOD THIS CLEARS MEL MDDR 132997