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 DALA2025120508907Seat Track · corrodedFOUND SEAT TRACK CORROSION AT STA 1241-1263 RBL 88 REFER TO CPPCP TASK 53-646-00. DAMAGED AREA REPAIRED PER ER/A630569-14 (1331639)SDR DALA2025120508906Seat Track · corrodedFOUND SEAT TRACK CORROSION AT STA 1263-1329 RBL 88 REFER TO CPCP TASK 53-646-00. DAMAGED AREA REPAIRED PER ER/A630569-14 (1331610)SDR DXTA2025120505941Test Switch · faultedL ENG FIRE LIGHT. A SMALL LIGHT IN THE LOWER LEFT CORNER OF THE L ENG FIRE LIGHT APPEARED IN CRUISE FLIGHT. IT STAYED ILLUMINATED FOR ABOUT 1/2 HOUR BEFORE FADING OUT. WE RAN THE ENGINE FIRE TEST. NO CHANGES. NO SIGNS OF FIRE OR ENGINE ISSUES WERE NOTED DURINGSDR DXTA2025120505944Pressure Switch · faultedPASSING FL215 "FUEL 1 FEED FAULT" WHITE CAS DISPLAYED. ON FUEL SYNOPTIC PAGE, DISPLAYED AMBER X OVER EJECTOR PUMP 1. REMOVED AND REPLACED LEFT FAULTY PRESSURE SWITCH & REPLACED WITH NEW UNIT. REMOVED AND REPLACED RT FAULTY PRESSURE SWITCH & REPLACED WITH NEWSDR ABXA2025122315Warning Message · false activationON DESCENT INTO BOG NEAR, BUT PRIOR TO FL250 CABIN ALT MASTER WARNING SIREN, LIGHT AND EICAS MESSAGE. EMERGENCY DECLARED. DONNED 02. AIRCRAFT. EICAS MESSAGE CLEARED NEAR TOUCHDOWN. LANDED WITHOUT FUTHER INCIDENT. BITE TEST PERFORMED ON CABIN CONTROLLERS,SDR SWAA2025120441781Flashlight · no testFA REPORTED FLASHLIGHT AT FWD FA JUMPSEAT WON`T TEST. RESEATED THE FLASHLIGHT & RESEALED, OPS CHECKED GOOD IAW AMM 25-64-00.SDR SWAA2025120442204Battery · no testCREW REPORTS AFT RT OTBD FLASHLIGHT WILL NOT TEST CORRECTLY. OK TO CONTINUE PER MEL 25-64-02A. REMOVED AND REPLACED THE AFT RT OTBD FLASHLIGHT BATTERY IAW AMM 25-64-00, OPS CHECKED GOOD.SDR SWAA2025120441784Megaphone · no testAFT MEGAPHONE DOES NOT TEST. R & R AFT MEGAPHONE IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025120441850Rivet · brokenGIRT BAR HOOK ON L1 DOOR HAS BROKEN RIVET. PERFORMED TEMPORARY REPAIR TO REPLACE MISSING FASTENER ON L1 DOOR GIRT BAR CLIP IAW EA M-23-125-01839.SDR SWAA2025120441775Belt · out of adjustFWD ENTRY SLIDE HAS A BELT STICKING OUT. RESECURED FWD SLIDE GIRT BAR IAW AMM 25-66-01.SDR SWAA2025120441472Battery · no testAFT RIGHT EMERGENCY LIGHTING BATTERY PACK FAILED A CAPACITY CHECK. REMOVED & REPLACED THE BATTERY IAW MM 33-51-06.SDR SWAA2025120441702Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM 33-51-06, OPS CHECK GOOD.SDR SWAA2025120441567Battery Pack · no testBATTERY AT SEAT 17ABC NOT LASTING 15 MINUTES. R & R CABIN CABIN EMERGENCY BATTERY PACK M1670 AT SEAT 17ABC IAW AMM 33-51-06.SDR SWAA2025120441479Nut · crackedFWD ENTRY DOOR UPPER ASSIST HANDLE NUT CRACKED. R & R FWD ENTRY DOOR UPPER ASSIST HANDLE NUT IAW AMM 52-11-31.SDR SWAA2025120441749Handle · brokenFWD SERVICE DOOR HANDLE BROKEN. R & R THE FWD SERVICE DOOR HANDLE IAW AMM 52-41-31.SDR SWAA2025120441560Tail Cone · delaminatedTAIL CONE RT SIDE HAS SKIN DELAMINATION JUST FORWARD AND BELOW THE TAIL CONE ACCESS DOOR NEAR BS 1190. COMPLIED WITH 25-153-03292 (COMPONENT - REPAIR - FUSELAGE SECTION 48 DISBONDING COMMON TO TAIL CONE.SDR DALA2025120408876Unknown · smokeATB- RETURNED TO ORD DUE TO SMOKE IN COCKPIT AND DECLARED AN EMERGENCY. MTC IN PROGRESSSDR GTIA2025120439194Fan · failedAMBER FAN INDICATION ON COND PAGE SMELLED SMOKE IN FLT DECK AND CABIN.SDR GTIA2025120439193Megaphone · inoperativeL1 DOOR MEGAPHONE INOP. REPLACED MEGAPHONE IAW AMM 25-65-51.SDR JR2R20251204444Skin · dentedDENT LH WINGLET LOWER SKIN.SDR DALA2025120408861Light · inoperativeSEAT 27 FLOOR PROXIMITY EMERGENCY LIGHT INOPERATIVE. REMOVED & REPLACED LIGHT ASSY AT 27R CHECKS GOOD IAW AMM 33-51-11.SDR AALA202512044988Eec · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO THE FLIGHT CREW REPORTING THAT DURING FLIGHT AT FL310 AN ENGINE 2 FADEC SYSTEM FAULT. THE AIRCRAFT LANDED SAFELY AT MIA AND TAXIED TO THE GATE UNDER ITS OWN POWER. MAINTENSDR AALA202512043918Diaphragm · leakingAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 841 DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER DIAPHRAGM PER AMM 52-10-00.SDR AALA202512048053Lanyard · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW REPORTED A LANYARD HANGING OUT OF L4 DOOR, CATERING UNABLE TO OPEN. MAINTENANCE OPENED L4 DOOR AND SECURED NYLON LANYARD STRAP PER AMM 52-13-00.SDR AALA202512043187Plunger · stickingAIRCRAFT WAS NOT GROUNDED: GUST LOCK DOOR 1R IS NOT ENGAGING. MAINTENANCE LUBRICATED THE R1 DOOR GUST LOCK PLUNGER AND AACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202512048648Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT 1 JUMPSEAT EMERGENCY FLASHLIGHT INOPERATIVE. MAINTENANCE REPLACED FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202512041591Bulb · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATHWAY LIGHT AT FORWARD GALLEY LEFT COAT CLOSET IS INOPERATIVE. REPLACED EMERGENCY PATHWAY LIGHT BULB AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR AALA202512041530Wire · brokenAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS WIRING IS EXPOSED AND BROKEN AT SEAT ROW 15ABC POWER PORT BOX. MAINTENANCE REPAIRED DAMAGED WIRE ON SEAT ROW 15 ABC FOR EMERGENCY SEAT LIGHTING AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-SDR DXTA2025120405949Light · inoperativeEMERGENCY FLOOR LIGHT BELOW LAV SEAT INOPERATIVE. REMOVED AND REPLACED LAV SEAT TOEKICK LIGHT ASSEMBLY IAW SPM 20-30-0A PERFORMED OPS CHECK OF THE EMERGENCY LIGHTS YAW IAW AMM 33-50-00, OPS CHECKED GOOD.SDR DALA2025120408851Spinner · leakingAIRCRAFT 5049, ON DESCENT BELOW - 5000', MODERATE VINEGAR SMELL. CONTINUED ON TAXI IN. NR 2 ENG SPINNER HAD OIL AT FAN SHAFT SEAL, LEAKING OUT OF SPINNER WEEP HOLE. REPLACED NR 2 ENGINE FAN SHAFT SEAL PER AMM 72-15, C/W LEVEL B ECS CONTAMINATION PER AMM 21-0SDR DALA2025120408849Unknown · odorWHEN WE GOT TO THE JET, THERE WAS A STRONG SMELL SIMILAR RO AN AUTO BURNING CLUTCH SMELL THROUGHOUT THE COCKPIT AND CABIN, THE BATTERIES WERE OFF, APU OFF, EXTERNAL AIR AND PWR ON. STARTED APU AND APU BLEED ON AND IT DISSIPATED. INFO NOTED AND RECORDED. (LP: SDR DALA2025120408847Computer · inoperativeAIRCRAFT ROLLED UP TO 15 DEGREES RT UNCOMMANDED, AWAY FROM FLIGHT DIRECTOR WHEN SPEEDBRAKES DEPLOYED AT FLAPS 1, 210 KNOTS , ACFT ROLLED ABOUT 15 DEGREES LT WHEN SPEEDBRAKES DEPLOYED AT 180 KNOT, FLAPS 2. LAST LEG ECAM REPORT SHOWS NO FAULTS. AFS/LAST LEG REPSDR JJBA20251204004Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BPS NR 3. OPS CHECK SAT.SDR CALA2025120411772Slide · no discrepancyEXCESS SLIDE APRON TOUCHING FLOOR ON RIGHT SIDE. RESECURED APRON ON R1 DOOR IAW AMM 25-66-00-710-801, NO DEFECTS NOTED, OK TO CONTINUE. VERIFIED R1 SLIDE DOOR REINSTALLATION IAW AMM 25-66-00-710-801.SDR CALA2025120411768Frame · dentedAFT CARGO COMPARTMENT BS 1560, S25R - S26R FRAME HAS A DENT. REPAIRED IAW ECRA 5360-02065, PART 1. WC 138283.SDR CALA2025120411765Attach Angle · crackedSTATION 663 VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT APPROXIMATELY LBL 9.0. REPAIRED BS 663 VAPOR BARRIER UPPER ATTACH ANGLE IAW SRM 57-10-10-2R-5.SDR CALA2025120411756Attach Angle · crackedBS 663 VAPOR BARRIER UPPER ATTACH ANGLE IS CRACKED AT APPROX RBL 9.0. REPAIRED BS 663 VAPOR BARRIER UPPER ATTACH ANGLE IAW SRM 57-10-10-2R-5.SDR CALA2025120411754Fitting · crackedSHEAR FITTING AT BS 540, RBL 15.04 CRACKED. REMOVED AND REPLACED THE SHEAR FITTING IAW SRM 51-40-02, & DWG 111A2000 REV ORIGINAL.SDR CALA2025120411752Fitting · crackedSHEAR FITTING AT BS 540, LBL 15.04 CRACKED. REMOVED AND REPLACED THE SHEAR FITTING IAW SRM 51-40-02, & DWG 111A2000, REV ORIGINAL.SDR CALA2025120411749Fitting · crackedSHEAR FITTING AT BS 540, LBL 40.87 CRACKED. REMOVED AND REPLACED THE SHEAR FITTING IAW SRM 51-40-02, & DWG 111A2000, REV ORIGINAL.SDR CALA2025120411747Fitting · corrodedSHEAR FITTING AT BS 540, LBL 32.40 CRACKED. REMOVED AND REPLACED THE SHEAR FITTING IAW SRM 51-40-02, & DWG 111A2000, REV ORIGINAL.SDR CALA2025120411745Fitting · crackedSHEAR FITTING AT BS 540, LBL 6.14 CRACKED. REMOVED AND REPLACED THE SHEAR FITTING IAW SRM 51-40-02, AND DWG 111A2000, REV ORIGINALSDR DALA2025120308841Wire · brokenFOUND EEPMS ROW 51H-56H, NO EMER LIGHTS ILLUMINATING DURING TEST. FOUND SEAT TO WALL CONNECTIONS WIRE BROKEN AT 56HJ AND 54HJ. REPAIRED WIRING IAW WDM 33-51-23 AND ESPM 20-43. (LP 7933899)SDR SWI2025F01711Warning Message · illuminatedFLAPS FAIL CAUTION MESSAGE ON APPROACH WHEN SELECTING FLAPS 20 TO 30. RAN QRH AND FLAPS STAYED IN THE FLAPS 20 DETENT AFTER RESELECTING FLAPS 20 FROM THE FLAPS 30 DETENT PER PROCEDURE. (FLIGHT 4808)SDR SWIA2025120300002Windshield · crackedCAPTAIN`S WINDSHIELD SHATTERED ON TAXI IN. (FLIGHT 4807)SDR AALA202512031645Door Seal · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FORWARD ENTRY DOOR SEAL LEAKING IN FLIGHT, CONFIRMED DOOR SEAL BLOWN/TORN OUT AT 6 O'CLOCK. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. (OPEN).SDR K11A2025120200361Control Panel · faultedMODE CONTROL PANEL FROZE IN FLIGHT, WITHOUT THE ABILITY TO CHANGE ANY MODE (COURSE) ALT, HLD, SPEED, N1, HDG SEL, LNAV, VNAV, FD MASTER SIDE. AUTO THROTTLE CONTINUED TO WORK. AUTO PILOT A OR B WOULD NOT ENGAGE. AWAITING TROUBLESHOOTING. OPENSDR AALA202512032835Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: OFAR EXIT SIGN IN THE COMMON MODULE AND EXIT SIGN BETWEEN BUNK NUMBER 4 AND BUNK NUMBER 6 LIGHT INOPERATIVE. REMOVED AND REPLACED RIGHT HAND OFAR BACKUP POWER SUPPLY. PER AMM 32-27-12. OPS CK GOOD, REF JC 72T20033001SDR DALA2025120308840Cable · out of adjustIAW AMDS 2040-0191-1L STEP 18, ACTUATION CABLE TRAVEL OF 1L DOOR IT IS OUT LIMITS. ADJUSTMENT OF ACTUATION CABLE TRAVEL OF 1L DOOR WAS PERFORMED IAW AMM 52-11-32, ACTUATION CABLE TRAVEL IS WITHIN LIMITS. (1332560)SDR DALA2025120308839Angle · corrodedCORROSION ON LOWER SILL ANGLE BTW BS 1380 - 1440, S27R IN AFT CARGO COMPARMENT. CORROSON LEVEL 2, LOWER SILL ANGLE BTW BS 1380-1440, S27R WAS REPLACED IAW SRM 51-40-02-0G. (1332312)