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 AALA202512230138Coffeemaker · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO THE FLIGHT CREW REPORTING THAT WHILE CLIMBING OUT OF FL220, THE FLIGHT ATTENDANTS IN AFT GALLEY REPORT AN ELECTRICAL BURNING SMELL. FLIGHT CREW TURNED OFF THE COMMERCIAL SDR AALA202512234111Coffeemaker · odorAIRCRAFT WAS GROUNDED: REAR OF AIRCRAFT PAST ROW 25 HAS OFFENSIVE ODOR. MAINTENANCE ISOLATED THE SOURCE OF THE ODOR TO THE AFT GALLEY COFFEE MAKERS AND REPLACED THEM PER AMM 25-35-15.SDR DALA2025122309353Unknown · odorSMKE - AFTER APU START AND PACKS ON, AN ACRID SMELL AND FA REPORTED SMOKE FILLED THE CABIN. TURNED OFF THE APU AND THE SMOKE/FUMES STOPPED. INSPECTED THE APU INTAKE AND RAN APU WITH SNIFFER TOOL AND FOUND NO CONTAMINATION OR SMELL. NO TROUBLE FOUND. REPLACEDSDR YENA2025122301258Support · corrodedDURING HEAVY MAINTENANCE: (CPCP FINDING ) CORROSION LOWER SILL LH SIDE AT LEVEL OF FRAME 68 AT AFT GALLEY AREA; REF AEROMAN WO 2025-466/1, NR 2025 - 750550, REMOVED AND REPLACED LOWER SILL LH SIDE AT LEVEL OF FRAME 68 AT AFT GALLEY AREA IAW SRM 51-42-11, DWG DSDR DXTA2025122306212Wire · brokenCABIN FLOOR LEVEL EMERGENCY EXIT LIGHT AT SEAT 9 FAILS TO ILLUMINATE. REMOVERD CABIN FLOOR LEVEL EMERGENCY EXIT LIGHT AT SEAT 9 AND FOUND LIGHT ASSEMBLY TO HAVE BROKEN WIRE AND NEEDING REPLACED. REMOVED FLOOR PATH MARKER AT SEAT 9 DUE TO BROKEN WIRE INTERNALSDR DALA2025122309340Strap · crackedCRACKED ANGLE STRAP BTW CANTED BS 1178, L2R AT ROOT OF VERTICAL STABILIZER. REPAIRED IAW SRM 53-30-01-2R -1. (1358667)SDR CALA2025122312379Fuel Cap · missingFUEL CAP MISSING UPON ARRIVAL. VERIFIED NO FUEL LEAKING FROM COUPLING AND INSTALLED INOP STICKER. REPLACED THE FUEL CAP IAW IPC 28-25-05-42B, AND AMM 28-25-41-400-005-A.SDR CALA2025122312352Battery · no testEMERGENCY LIGHTS TEST FAILED. EPSU BATTERY FWD LT, REPLACED EPSU BATTERY AT 10WL. RESET BREAKERS & PERFORMED AN OPS CHECK FROM PTP PANEL BUT THE TEST WAS ABORTED WITH A COMMUNICATION FAULT. NEED FURTHER T/S IAW AMM 33-51-38-000-002-A, & 33-51-38-400-002-A. SDR CALA2025122312350Receptacle · damagedAPU COMP AFT WALL DAMAGED BELOW LT AND RT LATCH PIN RECEPTACLE . REMOVED AND REPLACED APU COMP. AFT WALL LT & RT LATCH RECEPTACLES IAW SRM 51-42-11-001.SDR CALA2025122312348Battery Pack · no testEMERGENCY LIGHT BATTERY M1676 FAILED A CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK FROM EMERGENCY POWER SUPPLY M1676 IAW AMM 33-51-06-960-805, OPS TESTED GOOD.SDR CALA2025122312346Floor Support · corrodedBULK CARGO, FLOOR AREA, CLOSE TO BS 1500, BETWEEN S29 - 30, FLOOR SUPPORT SPLICE HAS CORROSION. REMOVED AND REPLACED TWO FLOOR SUPPORT SPLICES IN THE AFT CARGO BAY. BETWEEN BS 1500 - 1520 IAW SRM 51-40-02-0G-0.SDR CALA2025122312344Drag Fitting · crackedNDT ROTO INSPECTION ON NR 1 ENG PYLON DRAG FITTING. NOTED A CRACK IN HOLE NR 8 AT TOP OF SKIN AT THE 3 O'CLOCK. ACCOMPLISHED A REPAIR IAW EA 757-5720-13-A4226, AND EC/RA 57 20-03596, PART 1 STEP 1.SDR CALA2025122312342Battery Pack · no testEMERGENCY LIGHT BATTERY M1675 FAILED A CAPACITY CHECK. REMOVED AND REPLACED EMERGENCY BATTERY PACK M1675 IAW AMM 33-51-06-960-805. OPS TESTED GOOD.SDR CALA2025122312340Battery Pack · no testEMERGENCY LIGHT BATTERY M1671 FAILED A CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK M1671 IAW AMM 33-51-06-960-805. OPS TESTED GOOD.SDR CALA2025122312338Battery Pack · no testEMERGENCY LIGHT BATTERY M1670 FAILS CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK M1670 IAW AMM 33-51-06-960-805. OPS TESTED GOOD.SDR CALA2025122312336Web · corrodedCORROSION AT AFT WET AREA BS 986+6, LBL 45 UPPER WEB PLATE REMOVED AND REPLACED THE WEB IAW SRM 51-40-02-0G-0, AND DWG 147A5700.SDR CALA2025122312334Battery Pack · no testEMERGENCY LIGHT BATTERY M1694 FAILED A CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805. TESTED GOOD.SDR CALA2025122312332Battery Pack · inoperativeRIGHT FWD OVERWING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE RT FWD OVERWING EMERGENCY LIGHT LAMP & BATTERY PACK IAW AMM 33-51-04-960-801, AND AMM 33-51-06-960-805. TESTED GOOD.SDR CALA2025122312330Web · corrodedFOUND TWO DENTS IN AFT CABIN WET AREA GALLEY SUPPORT FLOOR WEB, LBL 7 & 12, BS 1016. REMOVED AND REPLACED THE WEB BS 1016 & LBL 3.59 - 27.95 IAW SRM 51-40-02-0G-0 & DWG 147A5700.SDR CALA2025122312328Support Angle · corrodedCORROSION ON AFT WET AREA BS 1016+2, RBL2 BETWEEN RBL 2 - 20, SUPPORT ANGLE INSTALLED A NEW SUPPORT ANGLE IAW SRM 51-40-02-0G-0 & DWG 147A5700.SDR CALA2025122312325Fuse · blownDURING EMERGENCY LIGHTS OPS CHECK, BUSINESS CLASS FLOOR PROXIMITY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY FUSES AT M2816 IAW AMM 33-51-06, OPS CHECKED NORMAL ACFT OK TO CONTINUESDR CALA2025122312323Beam · crackedAFT CARGO DOOR FWD LOWER SIDE OF MIDDLE BEAM HAS A CRACK OF APPROX 1". PERFORMED PER ECRA 5232-00184.SDR CALA2025122312313Elec Connector · damagedSEAT 35C EMERGENCY EXIT LIGHT INOPERATIVE. FOUND CONECTOR ON ACFT SIDE BROKEN. CAPPED WIRES WITH TAPE RECRIMPED TERMINALS AND CONNECTOR SEAT 35C EMERGENCY LIGHT, R&R EMERGENCY LIGHT BATTERY PACK FUSE. SWPM 20-61-11, WDM 33-51-22. OPS CK GOOD.SDR ASAA2025121962453Battery · inoperativeOVERWING EMERGENCY LIGHT INOPERATIVE. GROUNDED - YES. REMOVED AND REPLACED OVERWING EMERGENCY BATTERY IAW AMM 33-51-06. OPS CHECK GOOD. OK FOR SERVICE.SDR ASAA2025121962452Seal · lack of lubeMAIN CABIN DOOR STICKS WHEN CLOSING. GROUNDED - YES. CLOSED MAIN CABIN DOOR FROM THE OUTSIDE AND INSDIE. FOUND NO FAULTS. APPLIED VASOLINE TO MAIN CABIN DOOR SEAL. OK FOR SERVICE.SDR DALA2025122209336Battery Pack · inoperativeOVER HEAD EMERGENCY LIGHT AT ROW 30ABC INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51. (LP 8007010)SDR SWAA2025122253820Handle · looseFWD GALLEY RIGHT HAND SIDE DOOR ASSIST GRAB HANDLE LOOSE<[01] SECURED FWD GALLEY R/H SIDE ASSIST HANDLE REF AMM 25-21-35SDR SWAA2025122254052Battery · inoperativeFWD GALLEY NR 2 FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FWD GALLEY NR 2 FLASHLIGHT BATTERY PER AMM 25-64-00.SDR SWAA2025122254069Flashlight · no testFO SIDE AFT GALLEY FLASHLIGHT WONT SELF TEST. R&R FLASHLIGHT PER AMM 25-64-00 OPS CHECK GOODSDR SWAA2025122254048Battery · inoperative3 CABIN EMERGENCY FLASHLIGHTS INOPERATIVE. R & R 3 EA FLASHLIGHT BATTERIES REF AMM 25-64-00 OPS CHECK GOODSDR SWAA2025122254060Slide · dislodgedR 2 DOOR EVAC. SLIDE FELL OUT OF HOLDER.<[01] REINSTALLED R2 ESCAPE SLIDE PER MT 725-61-06. OK FOR SERVICE.SDR SWAA2025122254275Girt Bar · fodAFT ENTRY ESCAPE SLIDE GIRT BAR WOULD NOT ENGAGE IN SLIDE BRACKET. DEBRIS WAS BLOCKING BRACKET FROM ENGAGING THE BAR. REMOVED DEBRI AND PERFORMED INSTALL TEST AMM 25-66-02. GIRT BAR PROPERLY ENGAGESSDR SWAA2025122253871Clamp · out of adjustFWD SERVICE DOOR HAS A LOOSE RETENTION GIRT BAR CLAMP. ADJUSTED FWD SERVICE DOOR GIRT BAR CLAMPS PER SIP.SDR SWAA2025122254268Slide · partial deployL1 DOOR EMERGENCY SLIDE PARTIALLY DEPLOYED. SLIDE DID NOT DEPLOY. SECURED L1 SLIDE IN TH CASE REF MT 725-61-06. NO DEFECTSSDR SWAA2025122254054Cover · looseFWD SERVICE DOOR EXIT COVER (LOWER) CAME OFF. SECURED FWD SERVICE DOOR EXIT COVER IAW MM 33-51-01SDR SWAA2025122253810Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE IS LOOSE. SECURED FWD ENTRY DOOR UPPER ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025122254056Slide · low pressureAFT SERVICE DOOR SLIDE LOW PRESSURE<[01] R&R AFT SERVICE ESCAPE SLIDE PER AMM 25-66-01; MT 725-61-06 REM/INSTLSDR GTIA2025122239218Unknown · odorPILOTS NOTED A DIRTY SOCKS ODOR DURING FLT . A DEAD HEADING FLT ATTENDENT REPORTED THE ODOR WHILE SITTING IN EMERGENCY EXIT SEAT. WORKING FLT ATTENDANTS DID NOT NOTICE THE ODOR INDIANAPOLIS HARD HEAVY RAIN. DESCRIPTION OF ODOR/FUMES: TEMPORARY, DIRTY SOCKS ODSDR DALA2025122209311Frame · damagedFWD FUSELAGE, FR 23 S5R TO S6R DAMAGED. REPAIRED PER ERA 630770-14 REV ORIG. (1359701)SDR DALA2025122209302Frame Splice · damagedFUSELAGE FR42, S4R TO 5R, TOOLING DAMAGE ON FRAME SPLICE REPAIR. COMPLIED WITH ERA 630752-14. (1359681)SDR AALA202512224962Battery · no testAIRCRAFT WAS GROUNDED: FAULT LIGHT FOR EMERGENCY POWER SUPPLY UNIT 13WL BATTERY ILLUMINATED DURING SYSTEM TEST. MAINTENANCE REPLACED BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202512225665Girt Bar · damagedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR SLIDE GRIT BAR WAS DAMAGED. REPLACED SLIDE ASSEMBLY PER AMM 25-66-01 AND TASK CARD 08L22125001.SDR AALA202512229024Pouch · tornAIRCRAFT WAS NOT GROUNDED: CREW REPORTS LIFE VEST POUCH AT SEAT 25A IS TORN. REPLACED SEAT 25A LIFE VEST POUCH PER AFMM 25-22-00-34.SDR AALA202512229285Deu · fault messageAIRCRAFT WAS NOT GROUNDED: CIDS CAUTION LIGHT AND EVACUATION LIGHTS ON CIDS PANEL ARE ILLUMINATED. MAINTENANCE FOUND FAULTED DEU-B 300RH01, REPLACED DEU-B 300RH01 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 23-73-47.SDR AALA202512228878Battery · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT BELOW FLIGHT ATTENDANT SEAT LOCATED NEXT TO THE R3 DOOR INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISACTORY OPERATIONAL CHECK PER TASK CARD 26C00025003.SDR AALA202512221287Slide · unwanted deployAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE INADVERTENTLY PARTIALLY DEPLOYED DURING REOPENING OF DOOR. MAINTENANCE REPLACED SLIDE PER TASK CARD 09L20025004.SDR AALA202512225570Placard · damagedAIRCRAFT WAS NOT GROUNDED: DOOR 2R GIRT BAR RED DECAL / PLACARD DAMAGED. REPLACED DAMAGED GIRT BAR DECAL / PLACARD WITH NEW ONE.SDR DALA2025122209329Proximity Sensor · faultedFLT CREW REPORTED ON LANDING, LEFT CTR DOOR (L2) EICAS MSG. R & R L2 CABIN DOOR PROX SENSOR IAW AMM 52-71. OPS NORMAL. GOOD INDICATIONS MSG DOES NOT SHOW WHEN DOOR IS CLOSED. (6582997)SDR DALA2025122209320Strap · crackedCRACK ON STABILIZATION STRAP STA 377.7 LBL 28 AT ZONE 117. STABILIZATION STRAP STA 377.7 LBL 28 AT ZONE 117.WAS REPAIRED PER SRM 53-00-51-2R REPAIR 12. (1359914)SDR DXTA2025122206199Proximity Switch · out of limitsAFTER DEICING & A NORMAL TAKEOFF, ACFT DID NOT PRESSURIZE. MFD INDICATED CABIN WAS CLIMBING WITH ACFT. FOLLOWED BY AN AMBER CAS CHK DOORS & CABIN DOOR OPEN. ICE PROTECTION WORKED NORMAL ON TAKEOFF & APPROACH TO LANDING. DURING APPROACH CABIN PRESS CONTINUE