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 CALA2025072206842Indication Sys · faultedRTO.DUE.TO.L1.DOOR.LIGHT ILLUMINATE PRESENT LEG FAULTS SHOWS MX MESSAGE 52-71111. PERFORMED FIM 52-20 TASK 801 STEP C., OMF SHOWS NOT ACTIVE FOR THE FAULT AFTER THE TEST, THERE WAS AN INTERMITTENT FAULT.SDR CALA2025072206831Floor Support · crackedMAIN CABIN FWD WET AREA CRACKED AT INTERCOSTAL LBL 46" BETWEEN STA 312-328 REF AAR N/R 97524622 REMOVED AND REPLACED MAIN CABIN FWD WET AREA INTERCOSTAL LBL 46" BETWEEN STA 312-328 IAW SRM 51-40-02-0G-0, DWG: 141A5400. REMOVED AND REPLACED MAIN CABIN FWD WET SDR CALA2025072206830Door · missingPDA 1 WATER SERVICE DOOR DEPARTED AIRCRAFT REF LP 5617677. REQUEST CDL 52E FOR MISSING WATER SERVICE DOOR. CDL 52E REJECTED. INSTALLED SERVICIBLE WATER SERVICE PANEL IN REFERENCE TO AMM 52-49-09. DOOR OPENS AND CLOSES NORMALLY.SDR CALA2025072206829Stringer · corrodedAFT PIT STR 31R CORRODED AT FR 65. RMVD AND RPLD STRINGER 31R FROM FR 64-67 IAW A319 SRM 51-72-11- 911-001.SDR AALA202507219724Tire · blew outAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 3 TIRE BLEW DURING TAKEOFF. AIRCRAFT EMERGENCY LANDED SAFELY AT BNA. INSPECTION CONFIRMED MATERIAL MISSING FROM NUMBER 3 MLG TIRE. REMOVE AND REPLACED NUMBER 3 MLG WHEEL AND TIRE ASSEMBLY. PER AMMSDR AALA202507216991Lavatory · abnormalAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT POTABLE WATER SMELLS FUNKY. CONFIRMED POTABLE WATER SMELLS. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202507210217Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR HARD TO OPEN FROM THE CABIN SIDE. LUBRICANT COCKPIT DOOR LATCH AND OPERATED DOOR SEVERAL TIMES. PER MM 52-51-00. OPERATIONAL CHECK GOOD.SDR AALA202507216476Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DIFFICULT TO OPEN AND CLOSE. LUBRICATED FORWARD LAVATORY DOOR SCUFF PLATE. PER AMM 25-40-00 OPERATIONAL CHECK GOOD AT THIS TIME.SDR AALA202507211368Light · detachedAIRCRAFT WAS NOT GROUNDED: AISLE EMERGENCY LIGHT AT SEAT 29C IS DANGLING BY ITS OWN WIRE. RESECURED EMERGENCY LIGHT AT SEAT 29C. PER AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA202507215944Sign · detachedAIRCRAFT WAS NOT GROUNDED: REPEAT ITEM SEAT 21C EMERGENCY EXIT LIGHT IS DETACHED FROM BOTTOM OF SEAT. REMOVE AND REPLACED SEAT 21C EMERGENCY EXIT LIGHT. PER CMM 25-23-67. OPERATIONAL CHECK GOOD.SDR AALA202507216291Sign · detachedAIRCRAFT WAS NOT GROUNDED: SEAT 20C EMERGENCY EXIT LIGHT HANGING DOWN BY THE WIRES. RESECURED EMERGENCY LIGHT AT 20C. PER AMM 33-50-00.SDR AALA202507213808Sign · detachedAIRCRAFT WAS NOT GROUNDED: 1L DOOR EXIT SIGN BROKEN AND DETACHED. SECURED LIGHT PER FIM 33-50-00 810- 801. EMERGENCY LIGHTS CHECK.SDR DALA2025072105485Sensor · out of adjustSHIP 3420 ON OTBD TAXI 1R DOOR INDICATED OPEN. ADJST. SENSOR 10MJ IAW AMM 52-71-11-820 -811.SDR DALA2025072105481Light · inoperativeSHIP 3326 31AB AND 37H SEAT MOUNTED EMERG LIGHTS INOP. R/R EMERG LIGHTS IAW AWM 33-51-2 AND IPC 33-51-09-80-LIGHTS.SDR DALA2025072105478Stringer · damagedSHIP 3416 FUSELAGE STRINGER 2L AT FR 6 DAMAGED HOLES AND TOOLING DAMAGE. REPAIRED PER ER/A 627929-14.SDR AALA202507211272Valve · faultedAIRCRAFT WAS GROUNDED: 96F IN COCKPIT - NO CHANGE AFTER 40 MINUTES FLIGHT TIME REQUIRING RETURN TO DFW, EMERGENCY DECLARED AIRCRAFT LANDED OVERWEIGHT WITHOUT INCIDENT. MAINTENANCE REPLACED LOW LIMIT VALVE IAW AMM 21-52-30.SDR DALA2025072105475Hose · damagedSHIP 3162 - DIV - TO RDU DUE TO LOSS OF THE GREEN SYSTEM HYDRAULICS AFTER TAKE-OFF. LANDING GEAR WOULD NOT RETRACT. FOUND LH MLG LOCKSTAY ACTUATOR SWIVEL HOSE DAMAGED. REPLACED HOSE, FILTERS AND LH EDP.SDR DALA2025072105474Warning Light · false activationSHIP 3159 DOOR L FWD CABIN ON ECAM AND DOOR 1L WAS SHOWING OPEN ON DOOR PAGE. COULD NOT DUPLICATE ON THE GROUND 1L DOOR INDICATES NORMALLY OPEN/ CLOSED ON EICAS.SDR SWAA2025072193099Sign · brokenOVERWING EXIT OVERHEAD EMERGENCY LT HOUSING BROKEN. R+R EMERGENCY EXIT SIGN PER AMM 33-51-01.SDR SWAA2025072193039Battery · inoperativeAFT GALLEY R/H OTBD FLASHLIGHT INOP. R/R AFT GALLEY R/H OTBD FLASHLIGHT BATTERY PER AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025072193586Receptacle · fireGROUND POWER RECEPTACLE ARCED AND CAUGHT FIRE. PERFORMED POWER RECEPTACLE INSPECTION. NO DEFECTS NOTED IAW AMM 24-41-11 OPS CHECK GOOD IAW AMM 24-22-00SDR SWAA2025072193256Battery · inoperativePILOT REPORTS R AFT EMERGENCY LIGHT INOP & CIRCUIT BREAKER POPPED. RESET CB AND AFT LEFT AND CENTER EMERGENCY LIGHT INOP AND AFT RIGHT WORKS AS ADVERTISED. REMOVED AND REPLACED RH MID EMG BATTERY IAW AMA 33-51-06 OPS CHECK GOOD.SDR SWAA2025072193261Flashlight · inoperativeFORWARD FA FLASHLIGHT INOP. ] R/R FWD INBD FLASHLIGHT REF AMM 25-64-00.SDR SWAA2025072193041Flashlight · no testFLIGHT DECK FLASHLIGHT WILL NOT TEST. REMOVED AND REPLACED FLIGHT DECK EMERGENCY FLASHLIGHT AS PER REF AMM 25-64-00 OPS CHECK GOOD.SDR SWAA2025072193251Cover · missingMID CABIN OVERHEAD EXIT SIGN MISSING COVER. REPLACED EMERGENCY EXIT SIGN IAW AMM 33-51-01.SDR SWAA2025072193095Lens · missing12 DEF EXIT/SALIDA COVER MISSING. INSTALLED NEW EMERG EXIT LENS PER AMM 33-51-01.SDR SWAA2025072193038Lens · detachedFORWARD ENTRY LOWER EMRGENCY EXIT LIGHT LENS FELL OFF. REINSTALLED FWD ENTRY LOWER EMERGENCY EXIT LIGHT LENS IAW AMM 33-51-01. A/C OKAY TO CONTINUE IN SERVICE.SDR 4USA2025072100510Generator · failedDURING CRUISE, CREW REPORTED “GEN FAIL R”. APPROXIMATELY 5-10 MINUTES LATER, IT WAS FOLLOWED BY “OIL LEVEL LOW R”. ABOUT 5 MINUTES LATER, THE CAPTAIN NOTICED THE OIL PRESSURE AND ITT START TO MOVE SO HE IMMEDIATELY SHUT THE ENGINE DOWN IN FLIGHT TO PREVENT FURSDR IPXA202507214120Cam · gougedCREW DOOR LOWER LATACH CAM HAS A GOUGE ON OUTER SIDE.SDR IPXA2025072113981Cam · gougedCREW DOOR UPPER LATACH CAM HAS A GOUGE ON OUTER SIDE. ACCOMPLISHMENT OF SREO-14721-REQ001.SDR IPXA2025072008272Floor Panel · damagedFOUND MAIN DECK FLOOR DAMAGE, P/N : 145T5876-85 PANEL NO : 241FFF. I.A.W AMM 25-57-05-004-001, AMM 25-58-01-004-001 AND AMM 25-58-03-004-001 REV.145 REMOVED MAIN DECK CARGO HANDLING AND G.V.I CONDITION CHECK NORMAL. .FABRICATE A NEW FLOOR PANEL I.A.W. SREO-969SDR IPXA2025071911037Door · handler errorL-1 DOOR WAS ACTIVATED TO THE EMERGENCY POSITION BY GROUND LOAD CREW SERVICED DOOR ASSIST BOTTLE FOR L-1 DOOR IAW AMM 12-25-04-600-801. OK FOR SERVICE PLACARD REMOVED THIS CLOSES T3F18E0072JY8SDR GTIA2025072139000Battery · inoperativeDURING SERVICE CHECK FOUND EPSU BATTERY 11WL INOP-R&R EPSU BATTERY 11 WL IAW AMM 33-51-38, OPS TEST GOODSDR YENA2025072100737Oil Filter · faultedFLT#1926, LGW-BOS. (ETOPS) SECOND TIME WRITE UP APU AUTO SHUTDOWN AFTER COMING ONLINE FOR 30 SECONDS ( APU SYSTEM A321NEO ETOPS ); REPLACED SCAVENGE & LUBE FILTER IAW AMM 49-91-41. OPS CHECK NORMAL. NO LEAK. PERFORMED MULTIPLE CYCLES OF APU, NO FAULTS NOTED.SDR HALA20250721221Hydraulic System · faultedATB - SHORTLY AFTER TAKEOFF HYD PUMP C1. PER FIM 24-00-F9-DRA-421A, FOUND EVIDENCE OF DAMAGE ON LEFT-1 ATRU. REPLACED LEFT-1 ATRU PER AMM B787-A-24-35-00-00A. AND REPLACED SOFT START RESISTOR PER AMM B787-A-24-15-09-00A. ALL TEST GOOD, A/C OK FOR SVC.SDR AALA202507218311Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 1L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507211480Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT STTENDANT STATES DOOR 3L SLIDE ARMING HANDLE IS LOOSE. MAINTENANCE TIGHTENED ARMING HANDLE AT DOOR 3L AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-22-00.SDR AALA202507217378Flashlight Assy · no testAIRCRAFT WAS NOT GROUNDED: R2 FLIGHT ATTENDANT STATION FLASHLIGHT NOT WORKING. MAINTENANCE REPLACED FLASHLIGHT PER AMM 25-60-00.SDR AALA202507219066Fitting · stickingAIRCRAFT WAS NOT GROUNDED: L4 DOOR SLIDE ARMING MECHANISM WILL NOT STAY ARMED. MAINTENANCE PERFORMED VISUAL INSPECTION OF THE L4 DOOR GIRT BAR LOCKING MECHANISM AND FOUND A PIECE OF MOP STRANDS WRAPPED AROUND THE GIRT BAR FITTINGS PREVENTING FULL ENGAGEMENT OFSDR AALA202507211227Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14.SDR AALA202507211574Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 4L DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14.SDR AALA202507210450Battery · no testAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT JUMPSEAT 2R INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR ABXA20250719163Hydraulic System · lowAFTER ENG START RIGHT HYD QTY DROPPED TO 0.73 WITH RF.AC THEN RETURNED TO THE GATE (BTB) AND MAINTENANCE GROUNDED AC . MTX THEN SERVICED R HYD SYS TO 1.00 IAW AMM 12-12-01. PERFORMED ENGINE RUN ON RIGHT ENGINE RUN ON RIGHT ENGINE IAW AMM 71-00-00. OPS CHECK GOSDR K11A2025071900327Fire Warning · false activationAPU FIRE INDICATION IN FLIGHT, FOLLOWED QRH PROCEDURE BLEW FIRE BOTTLE, FIRE LIGHT EXTINGUISHED PER QRH CHECK LIGHT CONTINUED TO AIRPORT. PERFORMED APU COMPARTMENT COMPONENT AND STRUCTURE INSPECTION IAW B737-300 AMM 05-41-07, NO DAMAGE, NO FIRE INDICATION NOTSDR AALA202507211563Bottle · low pressureAIRCRAFT WAS GROUNDED: LH FWD PASSENGER DOOR ACCUMULATOR AT 0 PSI. MAINTENANCE CHARGED LH FWD PASSENGER DOOR DAMPER IAW AMM 52-10-00.SDR AALA202507215093Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY SEAT ROW LIGHT IS INOP AT ROW 8ABC. (OPEN)SDR AALA202507217750Power Supply · faultedAIRCRAFT WAS NOT GROUNDED: WHILE PERFORMING OPERATIONAL TEST OF EMERGENCY LIGHTS ON P/S CHECK, EMERGENCY LIGHT SYSTEM TEST FAILED. RECEIVED FAULT CODE: EMER SYSTEM / ATA 33-51-38 / EPSU INT LOAD AFT L.SDR AALA202507216434Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING THE EMERGENCY LIGHT TEST ROWS 3,7,15,20,24 AND 26 DID NOTILLUMINATE. TS IAW TSM 33-51-00-810-812-A. FOUND FAULTY EPSU 11WL. MAINTENANCE REPLACED EPSU 11WL IAW AMM 33-51-38.SDR AALA202507216782Bottle · low pressureAIRCRAFT WAS GROUNDED: R2 DOOR DAMPER REQ NITROGEN SERVICE AND RELEASE LEVER ENGAGED. MAINTENANCE SERVICED AND SAFTIED R2 DOOR DAMPER ENGAGED RELEASE LEVER IAW AMM 52-10-00.SDR AALA202507214417Diaphragm · failedAIRCRAFT WAS GROUNDED: R2 DOOR DAMPER REQ REPLACEMENT OF DIAPHRAGM. MAINTENANCE REPLACED R2 DOOR DAMPER DIAPHRAGM PER AMM 52-10-00.