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 DALA2025102107682Bottle · low pressureR2 DOOR ASSIST BOTTLE LOW. SERVICED DOOR ASSIST BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7199227)SDR DALA2025102107679Bottle · low pressureDOORS 1R,2R,3R,4R,3L, AND 4L DOOR ASSIST BOTTLES LOW. SERVICED DOOR ASSIST BOTTLES PER A330 AMM 52-15. (7868458)SDR QMLA2025102120106Potentiometer · unserviceableA FADEC DEGRADE CAUTION LIGHT ILLUMINATED IN-FLT ENROUTE BACK TO HOMEBASE. AFTER NOTIFYING THE CREW OF THE EMERGENCY EVENT THAT OCCURRED, EXECUTED EMERGENCY PROCEDURE IAW BH407HP RFM, WHICH WAS TO ENSURE ACFT STABILIZED & MINIMIZING CONTROL INPUTS, FADEC RESSDR CALA2025102110367Track · fodDOOR 4L WONT ARM FOUND DEBRIS IN GIRT BAR TRACK. CLEANED DEBRIS, DOOR ARMS NORMALLY.SDR CALA2025102110363Battery Pack · inoperativeEMERGENCY EXIT LIGHTS STAY ON IN ARMED POSITION. REMOVED & REPLACED RIGHT EMERGENCY EXIT EMERGENCY LIGHT BATTERY. OPS CHECKS GOOD REF AMM 33-51-06.SDR CALA2025102110349Light · inoperative29C EMERGENCY EXIT PATHLIGHT INOP SEAT EXIT PATH LIGHT INOPERATIVE. REMOVED AND REPLACED LIGHT ASSY AT SEAT 29C REF CMM 25-26-13. OP CHECK GOOD.SDR CALA2025102110348Floor Support · corrodedCABIN FLOOR SUPPORT Y-1732 CORRODED FR 66 FWD LOWER CORNER R-2 DOOR. REMOVED AND REPLACED FLOOR SUPPORT Y-1732 R/H FR66 IAW SRM 51-42-11/001.SDR CALA2025102110347Floor Support · corrodedFLOOR SUPPORT Y-765 FR 64-70 HAS 2EA OUT OF LIMITS CORROSION SPOTS AT FR 66 AND 67. REMOVED AND REPLACED DISCREPANT Y-765 FR64-70 FLOOR SUPPORTIAW SRM 51-42-11-001.SDR CALA2025102110346Warning Light · false activationOIL FILTER BYPASS 3 OCCASIONS ABLE TO GET LIGHT TO EXTINGUISHDURING CLIMB TO 15K OIL DIFFERENTIAL LIGHT ILLUMINATED PROMPTING LEVEL OFF OUR SECOND CLIENT FOR 25,000 FT. THE LIGHT CAME ON AGAIN DURING THE SET TO 8000 FT. IT ILLUMINATED THE THIRD TIME RUSTLE PSDR CALA2025102010322None · noneINSTALLED PIN ON 4L DOOR ESCAPE SLIDE REMOVED PIN FROM 4L DOOR ESCAPE SLIDE C/W RII REQUIREMENTSSDR CALA2025102010321Sensor · dirtyMAINT OVERHEAD LIGHT ON LANDING PICTURE UPDATE MAINTENANCE LIGHT OUT UPON ENTRY INTO COCKPIT. NON ACTIVE MAIN. MESSAGE 52-7111. CLEANED SENSORS ON FORWARD ENTRY DOOR. CYCLED DOOR TWICE WITH COCKPIT VERIFICATION OF DOOR CLOSED AND OPEN. NO PREVIOUS HISTORY.SDR CALA2025102010320Girt Bar · unsecureEXCESS MATTERIAL BETWEEN GIRT BAR AND SLIDE ON DOOR 1R. RESECURED DOOR GIRT EXCESS MATERIAL REF AMM 25-66-01.SDR CALA2025102010319None · noneDEACTIVATED RH OVERWING SLIDE, CB PULLED AND DISABLE HANDLE MOVED TO DISARMED POSITION REF TASK 25-65-00-002-001 REACTIVATED RH OVERWING SLIDE; CLOSED CB, MOVED DISABLE HANDLE TO ARMED POSITION, VERIFIED EMER DOORS WARNING LIGHT IS OFF, AND VERIFIED THERE ARE SDR CALA2025102010318None · noneINSTALLED SAFETY PIN ON OFF-WING ESCAPE SLIDE PRESSURE BOTTLE AND INSTALLED SHORTING CAP ON SQUIB UNINSTALLED SAFETY PIN ON RIGHT SIDE OFF-WING ESCAPE SLIDE AND REINSTALLED SQUIB CONNECTOR ON PRESSURE BOTTLE. REF AMM 25-65-00-402-018 VERIFIED PIN REMOVAL ON OFSDR CALA2025102010317Lever · unknownDOOR 4R ARMING LEVER IS HAVING ISSUES NO ISSUES FOUND ON DOOR 4R ARMING LEVER, OPERATES NORMALLY, OK FOR SERVICE.SDR CALA2025102010316Holder · tornFWD CABIN CURTAIN HOLDBACK DEVICE TORN. REMOVED AND REPLACED FWD CURTAIN TIE BACK. OPS CK NORMAL.SDR CALA2025102010315Bracket · looseR1 DOOR GIRT BAR BRACKETS LOOSE SEC. GIRT BAR BRACKETS. OPS NORMAL.SDR CALA2025102010314Slide · no discrepancyDEACTIVATED LH OVERWING SLIDE REF AMM TASK 25-65-00-002-001 REACTIVATED LH OVERWING SLIDE; REF. AMM TASK 25-65-00-402-018.SDR CALA2025102010313Cover · loose2L SLIDE COVER FALLING OFF CORRECTION, WRITE UP IS FOOR DOOR 2R. DOOR 2R HAD A DECORATIVE COVER COME LOOSE. RESECURED COVER. NO DEFECTS NOTED. REF AMM 03-25-20 AND AMM 25-62-44.SDR CALA2025102010312Cover · out of adjust2L DOOR SLIDE COVER NEEDS ADJUSTED. 2L SLIDE BUSTLE SECURE, OK FOR SERVICE REF AMM 25-66-01-206-041SDR CALA2025102010311Slide · not reportedREMOVED RT OVERWING ESCAPE SLIDE IAW AMM TASK 25-65-01-004-001, DUE TO SCHEDULED R & R REF TASKCARD 19-2565-9-0006. REINSTALLED ORIGINAL CONFIGURATION RT OVERWING ESCAPE SLIDE IAW AMM TASK 25-65-01-404-002. VERIFIED REINSTALLATION OF RT OVERWING SLIDE. RE-ASDR CALA2025102010310Slide Raft · no discrepancyL3 DOOR RAFT PRESSURE GAUGE SHOWS IN RED PSI FOR 3L RAFT STILL DISPLAYS IN THE GREEN REF AMM 52-12-00. OK TO CONT.SDR CALA2025102010309Fitting · fodDOOR 1R DOES NOT ARM. REMOVED DEBRIS FROM FLOOR FITTING, DOOR ARMS NORMALLY.SDR CALA2025102010308Bottle · low pressureDOOR 2L PRESSURE IS LOW. PRESSURE IS 1650. DOOR PRESSURE IS SERVICABLE PER AMM 52-13-14-200-001-A.SDR CALA2025102010307Cover · cracked2L SLIDE COVER CRACKED. C/W ECRA M PROC.SDR CALA2025102010306Slide · not reportedCOMPLETED REMOVAL OF L2 DOOR SLIDE AND INSTALLED NEW L2 DOOR SLIDE REF 25-62-44-400-006-A. OPS CHECK GOOD AT THIS TIME ACCOMPLISHED INSTALLATION INSPECTION OF L2 DOOR SLIDE REF 25-62-44-400-006-A. OPS CHECK GOOD AT THIS TIMESDR CALA2025102010305Light · malfunctionedCABIN ENTRY LIGHT NEAR DOOR 1R FLASHES RED INTERMITTENTLY RESET LIGHTS FOR FWD ENTRY DOOR, PROFORMED OPS CHECK REF AMM 33-21-00-710-001-A, NO FAULTS NOTED, OK TO CONTINUE.SDR CALA2025102010304Warning Light · malfunctionedAFT CARGO DOOR LIGHT CAME ON DURING TAXI AFT CARGO DOOR INDICATION LIGH INOP. .CARGO DOOR IS CLOSED , PUT IN MEL 5271E MEL 5271B APPROVED MEL 5271B , WE JUST COMPLIED WITH MEL , CARGO DOOR IS CLOSED AND CHECKED FROM OUT SIDE AND INSIDE . COMPLIED WITH MEL INTESDR CALA2025102010303Lanyard · out of positionDOOR 2L HAS A PIECE OF THE SLIDE RAFT HANGING OUT AT BOTTOM OF DOOR DOOR 2L HAS LANYARD DROOPING FROM BOTTOM , RE TUCK LANYARD .SDR CALA2025102010302None · noneWATCHED AND VERIFIED ALL TECHNICISNS WORKING ON SLIDE CHANGE HAS WATCHED "AIRBUS DOOR SLIDE - REMOVAL, PREPARATION, INSTALLATION" AND "AIRBUS DOOR SLIDE R&R CRITICAL STEPS" VERIFIED ALL TECHNICIANS AND OBSERVER HAS WATCHED THE NECESSARY VIDEOS PRIOR TO HANDLINSDR CALA2025102010301Seal · damagedOVR HEAD SLIDE TAMPER INDICATOR DAMAGED AT SEAT ROW 25. REPLACED OVR HEAD SLIDE TAMPER INDICATOR AT SEAT ROW 25.SDR CALA2025102010300Slide · unknownREF LOG #6564107 REMOVE AND REPLACE L2 DOOR SLIDE PRECAUTIUONARY . REMOVED DOOR 2L SLIDE PER AMM 25-62-44-000-002-A , UP TO AND INCLUDING STEP 4.B.6... NEED TO CONTINUE FROM 4.B.7 ADD EMP:U092776 COMPLETED REMOVAL OF L2 DOOR SLIDE AND INSTALLED NEW L2 DOOR SLSDR CALA2025102010299Arm Rest · unsecureCA ARM REST NOT SECURED RIGHT SIDE. RESECURED ARM REST COVER, NO FURTHER DEFECTS NOTED AT THIS TIME, OK TO CONTINUE.SDR CALA2025102010298Slide · faultedCHRONIC HIST OF DOOR 4-L DIFFICULT TO DISARM PER CABIN CREW. HIS T SHOW MULTIPLE DEFECTS FOUND & RECTIFIED, BUT ISSUE CONTINUES S EE ATA 52. TECHSUP REQUEST TO REMOVED DR SLIDE COVER & VERIFY ES CAPE SLIDE ASSY IS IN PROPER POSITION ON DR. USING FIM 52-11 FT 8SDR CALA2025102010297None · no discrepancyDOOR 2L ARMING HANDLE IS IN THE DISARM POSITION AND SAFETY PIN INSTALLED FOR SLIDE IAW AMM 25-62-44-000-002-A REMOVED DOOR ARMING PIN P/N 98D52103500000 FROM DOOR IN REF AMM TASK 25-62-44-400-006-A VERIFIED REMOVAL OF DOOR ARMING PIN P/N 98D52103500000 FROM DOSDR CALA2025102010296Cartridge · expiredOVERWING ESCAPE LEFT MASTER CONTROL VALVE SQUIB CATRIDGE EXPIRES BEFORE 41 MONTHS. EXP. JUNE 2026SDR CALA2025102010295Bottle · looseO2 BOTTLE COMPARTMENT, 118 BOTTLE PANEL FALLS OFF UPPER SLIDE WHEN PULLED OUT. REPLACED UPPER SLIDER RAIL REF IPD 35-31-00, OP CHECKED NORMALSDR CALA2025102010294Cartridge · expiredOVERWING ESCAPE RIGHT MASTER CONTROL VALVE SQUIB CATRIDGE EXPIRES BEFORE 41 MONTHS. EXP MARCH 2027 REQUESTING A DIP TO REPLACE THE OVERWING ESCAPE RIGHT MASTER CONTROL VALVE CARTRIDGE ON OR BEFORE MARCH 31 2027 DIP APPROVED FOR OVERWING ESCAPE RIGHT MASTER COSDR CALA2025102010293Light · inoperativeEMER EXIT LIGHTS COME ON WHEN THE SWITCH IS IN THE OFF POSITION. CYCLED SWITCH AT REAR FA PANEL EMERGENCY LIGHTS HAVE EXTINGUISHED. AC OK FOR SERVICE.SDR CALA2025102010292Light · no testEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK {B737-33-3-0235} - RED EMERGENCY LIGHT SEAT NUMBER 20C INOP RELAMPED EXISTING RED EMERGENCY LIGHT SEAT NUMBER 20C . OPS CHECK GOODSDR CALA2025102010291Light · no testREQUIRES TO PERFORM CABIN EMERGENCY LIGHT CHECK PER TASK CARD 18-3351-1-0003 ON SC. PERFORMED CABIN EMERGENCY LIGHT CHECK PER TASK CARD 18-3351-1-0003 ON SC.SDR CALA2025102010290Light · loose29C EMERGENCY FLOOR PACK LIGHTING PANEL IS BROKEN. TIGHTENED LOOSE FASTENERSSDR CALA2025102010289Lamp · inoperativeOUTSIDE EMERGENCY LIGHT R/H SIDE BY R1 DOOR NEEDS RELAMPING RELAMPED OPS CK GOODSDR CALA2025102010288Battery Pack · no testPOWER SUPPLY - BATTERY PACK CAPACITY CHECK PROCEDURE - EMERGENCY PATH LIGHTS INOP IN SEAT 18G, 28G, AND 30D DUPLICATE WRITE UP. WORK PERFORMED ON LOG PAGE #6651473 DUPLICATE LOG PAGE. WORK PERFORMED ON LOG PAGE #6651473SDR CALA2025102010287Light · no discrepancyEMERG. EXIT LIGHT IS ON AT ROW 20/21 SEATS DEF CHECKED THE EMERGENCY LIGHTS AROUND ROWS 20 AND 21 REF AMM 33-51-00, ALL OPS CHECKS NORMALSDR CALA2025102010286None · noneBATTERY, WIFI EMER LIGHTING WELS($)*DONOT LOAN*PMA POS: 4 (FOUR) MFG PN: AD100-2602-01 MFG SN: ADS2503108 PLEASE DOCUMENT IN THE LOG PAGE THE FULL MFG P/N AND S/N WITH IMAGES. CARRIED BY ELB TAKE THE PHOTO OF EMERGENCY LIGHT BATTERY UNIT AT POSITION 4 AS PER SDR CALA2025102010285Module · inoperativePOWER SUPPLY - BATTERY PACK CAPACITY CHECK PROCEDURE - EMERGENCY PATH LIGHTS INOP IN SEAT 18G, 28G, AND 30D REPLACED FLOOR PROXIMITY LIGHT ASSEMBLY ON SEAT 18G, 28G, AND 30D REFER AMM 33-51-05. OPS CHECK GOOD.SDR CALA2025102010284None · noneFA EMERGENCY MANUAL NEEDS REPLACEMENT NOTIFIED SCRUBS, NO MAINTENANCE REQUIRED.SDR CALA2025102010283Switch · out of positionCABIN EMERGENCY LIGHTS ARE ON WITH SWITCH IN ARMED POSITION FOUND AFT FLIGHT ATTENDANCE HAS SWITCH IN ON POSITION CYCLE TO OFF . OPERATION NORMAL.SDR CALA2025102010282Light · intermittentEMERGENCY LIGHT ABOVE DOOR 2L FLICKERED AND WENT OUT OPS CHECKED EMERGENCY LIGHTING OPS CHECK NORMAL. OPS CHECKED MANUALLY AT DOOR OPS CHECK NORMAL NO FLICKER.