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 ASAA2025092661153Lamp · abnormalWHILE ACCOMPLISHING TC 78233008 FOUND L2 DOOR RH OVERWING EMER EXIT DOOR AND R2 DOOR SLIDE EMERGENCY LIGHTS INOP. GROUNDED - YES. RELAMPED L2 DOOR, RH OWING EXIT LTS REF AMM 33-51-04. OPS CK R2 DOOR SLIDE LT OPS NORMAL.SDR HALA20250929293Line · leakingETOPS - ON WALK AROUND FOUND OIL LEAKING FROM FAN COWLS ON #1 ENG. FOUND #1 ENG OIL PRESSURE TRANSDUCER LINE LEAKING (AFT LINE) REMOVED AND REPLACED BOTH OIL PRESSURE TRANSDUCER LINES PER TASK CARD 330-79-HIW-03. LEAK CHK OK. OK FOR SVC.SDR HALA20250929292Coupling · faultedETOPS - FUEL LEAKING FROM HOSE NOZZLE WHEN CONNECTED TO REFUEL/DEFUEL COUPLING. AIRCRAFT WONT TAKE FUEL. REMOVED AND REPLACED REFUEL/DEFUEL COUPLING ELEMENT ASSY PER AMM 28-25-41, OPS CHECK AND LEAK CHECK GOOD. A/C OK FOR SERVICE.SDR DALA2025092907079Window Frame · crackedCRACKS FOUND IN LT AND RT FRONT WINDSHIELD FRAMES AT LWR CENTER NOD. COMPLIED WITH ER/A 628585-14AD. (1219746).SDR DALA2025092907066Hook · deterioratedDETERIORATED HOOK INNER CONTROL HANDLE ON PASSENGER CREW DOOR 832. REPLACED HOOK INNER CONTROL HANDLE PASSENGER CREW DOOR 832 AS PER CMM AIRBUS 52-13-15 SUB TASK 52-13-15-000-033-A01 AND SUB TASK 52-13-15-400-034-A01 AND AS PER A320 FAM AMM 52-13-21-400- 001SDR DALA2025092907065Hook · deactivatedDETERIORATED HOOK INNER CONTROL HANDLE OF PASSENGER CREW DOOR 842. REPLACED HOOK INNER CONTROL HANDLE OF PASSENGER CREW DOOR 842 AS PER AIRBUS CMM 52-13-15 SUBTASK 52-13-15-000-033-A01. (1220073).SDR DALA2025092907064Roller · deterioratedDETERIORATED ROLLER FROM UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF PASSENGER CREW DOOR 832 (4EA). REPLACED ROLLER FROM FWD AND AFT SIDE AND UPPER AND LOWER POSITION OF PASSENGER CREW DOOR 832 (4E/A) AS PER A320 FAM AMM 52-13-31-000-002-A AND AS PER A3SDR DALA2025092907063Roller · deterioratedDETERIORATED ROLLER FROM FWD AND AFT SIDE AND UPPER AND LOWER POSITION OF PASSENGER CREW DOOR 842. REPLACED ROLLER FROM FWD AND AFT SIDE AND UPPER AND LOWER POSITION OF PASSENGER CREW DOOR 842 (4E/A) AS PER A320 FAM AMM 52-13-31-000-002-A AND AS PER A320 FAMSDR DALA2025092907062Skin · delaminatedDELAMINATED LOWER SKIN COMPARTMENT 510, 511, 512 ON GALLEY 5 AT AFT GALLEY AREA. COMPLIED WITH A.A WORK CARD 2530-01591-02D. (1220081).SDR GTIA2025092939103Adr · malfunctionedADR 1 FAULT INCRUISE, PREFORMED OPS TEST IAW AMM 34-13-00 OPS CHECK GOOD NO FAULT MSGS MOC 69661SDR GTIA2025092939102Actuator · faultedUNCOMMANDED RUDDER MOVEMENTS BACK AND FORTH. SMALL MOVEMENTS OF PEDALS AND BLUE RUDDER TRIM INDICATOR. NO FAILURE MESSAGES. STARTED AT ABOUT 4000FT DURING CLIMB OUT-REF TSM 22-62-00-810-809-A. FOUND RUDDER TRIM ACTUATOR AT FAULT. R&R RUDDER TRIM ACTUATOR IAW ASDR GTIA2025092939105Unknown · odorON TAKEOFF NOTICED A DIRTY SOCK SMELL AFTER RUNNING ELIMINATION OF ODOR FUMES QRH DETERMINED THAT PACK 1 WAS THE SOURCEOF ODOR. DESCRIPTION OF ODOR/FUMES: PERSISTENT, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: UNKNOWN. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDSDR GTIA2025092939104Ecs · contaminatedSTINK MUSTY SUCK SMELL ON TAKEOFF PACK 1 OFF REMOVE SMELL. DESCRIPTION OF ODOR/FUMES: CONTINUOUS AND DISCOMFORTABLE, DIRTY SOCKS/MUSTY DRY SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-SDR SWIA2025092900026Pitot Tube · damagedHIT BIRD ON TAKE OFF (FLIGHT 5761 - FILED CLOSED)CLEANED BIRD REMAINS AND PERFORMED BIRD STRIKE INSPECTION PER ERJ175 AMM 05-50-02.FOUND DAMAGE TO INTEGRATED PITOT/STATIC SENSOR 4. PLEASE REFERENCE EAML 1713879 FOR WORK PERFORMED ON PITOT/STATIC SENSOR 4.NO FSDR SWAA2025092918436Girt Bar · out of positionR1 FWD SERVICE DOOR GIRT BAR HANGS LOW. REPACKED CABIN R1 FWD SERVICE DOOR GIRT BAR IAW AMM 25-66-01.SDR SWAA2025092918437Girt Bar · out of positionCABIN - L1 FWD ENTRY DOOR GIRT BAR HANGS LOW. REPACKED L-1 DOOR SLIDE GIRT BAR IAW AMM 25-66-01-000-804-NG.SDR SWAA2025092918571Slide · dislodgedFWD PAX DOOR DISLODGED AIR SLIDE FROM GIRT BAR, DID NOT INFLATE. RE-INSTALLED SLIDE PER MT 725-61-06SDR SWAA2025092918712Bracket · looseTHE LEFT SIDE STOWAGE BRACKET FOR THE FWD ENTRY DOOR GIRT BAR IS LOOSE. SECURED GRIT BAR BRACKET REF SRM 51-40-02.SDR SWAA2025092918412Rib · crackedRIGHT WING DEFLECTION CONTROL RIB CLIP CRACKED. REMOVED & REPLACED THE RIGHT WING DEFLECTION CONTROL RIB CLIP IAW SRM 51-40-02.SDR SWAA2025092918717Light · unsecureFRONT LEFT FLOOR PATH LIGHTING STRIP NEEDS TO BE SECURED. SECURED FRONT LEFT PHOTOLUMINESCENT STRIP IAW AMM 33-51-15.SDR SWAA2025092918567Cover · unsecureROW 12F EMERGENCY EXIT LIGHT COVER WILL NOT STAY ATTACHED TO LIGHT. INSTALLED NEW LIGHT COVER PER AMM 33-51-01.SDR SWAA2025092918272Lamp · inoperativeEMERGENCY EXIT LIGHT ON AFT LAV HAS AN INOPERATIVE SEGMENT. REPLACED THE LAMPS EMERGENCY EXIT LIGHT ON AFT LAV AND PERFORMED GOOD TEST IAW AMM 33-51-01-960-801.SDR SWAA2025092918599Battery Pack · inoperativeAFT SERVICE DOOR EMERGENCY EXITS LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805-NG. OPS CHECKED GOOD.SDR SWAA2025092918600Light · no discrepancyCABIN EMERGENCY LIGHT AT ROW 25 FED INOPERATIVE. OPS CHECK EMERGENCY LIGHT AT ROW 25 FED GOOD IAW AMM 33-51-06-960-805.SDR SWAA2025092918601Battery Pack · inoperativeRIGHT OVERWING EMERGENCY LIGHTS INOPERATIVE, TWO UPPER LIGHTS & ONE LOWER AFT LIGHT. REMOVED AND REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-805-NG, OPS CHECKED GOOD.SDR SWAA2025092918602Light · no discrepancyLEFT AFT OVERWING EXIT LOWER EMERGENCY LIGHT INOPERATIVE. OPS CHECKED THE LEFT AFT OVERWING EXIT LOWER EMERGENCY LIGHT, GOOD IAW AMM 33-51-06-960-805.SDR SWAA2025092918603Light · inoperativeEXTERNAL AFT SERVICE DOOR EMERGENCY EXIT LIGHT INOPERATIVE. OPS CHECKED EXTERNAL AFT SERVICE DOOR EMERGENCY EXIT LIGHT IAW AMM 33-51-06-960-805.SDR SWAA2025092918411Support Angle · crackedRIGHT WING OTBD SUPPORT ANGLE, IMMEDIATELY INBD OF THE DEFLECTION CONTROL RIB FOUND CRACKED ON UPPER OTBD FLANGE. R & R THE RT WING OTBD SUPPORT ANGLE IAW SRM 51-40-02.SDR SWAA2025092918498Skin · delaminatedNUMBER 2 ENGINE, RT FAN COWL, TRAILING EDGE HAS DELAMINATION DAMAGE. COMPLIED WITH EA-25-171-02621. INITIATES TLD, REINSPECT EVERY 16 DAYS & PERMANENT REPAIR WITHIN 180 DAYS.SDR SWAA2025092918541Battery Pack · inoperativeLEFT OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED 1 EA LT OVERWING EXIT, EMERGENCY BATTERY PACK AND OPS CHECK GOOD IAW AMM 33-51-06-960-805.SDR DALA2025092907061Cover · missingLEFT WING HAS ONE LOWER SLAT TRACK COVER MISSING. FWD TO CDL 57-47-03. PLAC. INSTALLED. (7709014)SDR DALA2025092907059Coalescer Bag · odorSMOKE AND ODOR IN CABIN AT GATE WITH PASSENGERS ON BOARD AT DEPARTURE TIME. F/A SAYS SHE SMELLS OIL IN THE CABIN. DECONTAMINATED AFT BULKHEAD AND INSTALLED NEW INSULATION PER B717 AMM 25-85. R & R COALESCER BAG ASSEMBLY PER AMM 21-54. (1219929)SDR WX0A2025092932583Battery · inoperative(AIRCRAFT NOT GROUNDED) FWD INBOARD FLIGHT ATTENDENT FLASHLIGHT INOP. REMOVED AND REPLACED FLIGHT ATTENTANT FLASHLIGHT BATTERY IAW CMM 25-60-02 OPS CHECK GOOD A/C OK FOR SERVICE.SDR WX0A2025092932582Battery · failed(AIRCRAFT NOT GROUNDED) EPSU TEST SHOWS BATTERY AT 10WL BAD / REMOVED AND REPLACED EPSU BATTERY AT FIN 10WL IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A. OPS CHECK GOOD."SDR AALA202509290999Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: LOW PRESSURE INFLATION RESERVOIR EMERGENCY EXIT RH DOOR 844. MAINTENANCE REPLACED INFLATION RESERVOIR EMERGENCY EXIT RH DOOR 844 IAW AMM 25-62-46-000-001-A AND AMM 25-62-46-400-001-A.SDR AALA202509295710Slide · contaminatedAIRCRAFT IN BASE MAINTENANCE: REPLACE OFF WING ESCAPE SLIDE RH SIDE DUE TO WATER ACCUMULATION MAINTENANCE REPLACED OFF WING ESCAPE SLIDE RH SIDE IAW JOB CARD 26C19053012.SDR AALA202509299360Bottle · low pressureAIRCRAFT WAS GROUNDED: #2 LH EMERGENCY EXIT DOOR PRESSURE REQUIRES SERVICING. MAINTENANCE SERVICED #2 LH EMERGENCY EXIT DOOR IAW AMM 52-22-00.SDR AALA202509292668Bottle · leakingAIRCRAFT WAS NOT GROUNDED: LEFT AFT PAX/CREW DOOR ASSIST BOTTLE WILL NOT HOLD PRESS. MAINTENANCE REPLACED DOOR DAMPER CYLINDER ON LEFT AFT ENTRY DOOR PER AMM 52-11-14.SDR IPXA2025092908881Latch · gougedCREW ENTRY DOOR LOWER CAM LATCH HAS A GOUGE APPROVED.SDR IPXA2055092908712Latch · gougedCREW ENTRY DOOR UPPER CAM LATCH HAS A GOUGE APPROVED.SDR DALA2025092907054Socket · looseSLIDE INDICATOR LIGHT INOP OR DAMAGED / LOCATIONS:602. TIGHTENED LOOSE LIGHT SOCKET. SLIDE LIGHT OPS NML. (1218899)SDR DALA2025092907053Power Supply · faultedSEATS 24,25,26 WHITE EISLE EMERGENCY LIGHTS OUT. FOUND SUPPLY M11487 TO BE FAULTING. REMOVED AND REPLACED SUPPLY AND BATTERY PER B757 AMM 33-51. OPS NORMAL. (7860910)SDR SIMA20250926001Power Supply · inoperativeOVERHEAD EMERGENCY LIGHT BY ROW 16 INOP "TRANSFERRED TO NRWC 745-ORD-01355" REF. NRWC# 745-ORD-01355. REPLACED UPPER AFT EMERGENCY LIGHT POWER UNIT IAW EMB-170 M/M 33-50-01, OPS CHECK GOOD.SDR IXXA20250926056Battery Pack · dischargedEXTERIOR EMERGENCY LIGHT DOES NOT HAVE POWER. REMOVED AND REPLACED BATTERY IN ACCORDANCE WITH B767 AIRCRAFT MAINTENANCE MANUAL 33-51-07. OPERATIONAL CHECK GOOD.SDR JJBA20250929042Battery Pack · inoperativeRH FWD EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED RH FWD EMERGENCY LIGHT ASSEMBLY. OPS CHECK FAILED. REMOVED AND REPLACED BATTERY SUPPLY #2. OPS CHECK SAT.SDR DALA2025092907047Skin · crackedFWD PAX DOOR CUTOUT AFTER LOWER CORNER HOLE NO. 4 IS CRACKED. REPAIRED FWD PAX DOOR CUTOUT AFTER LOWER CORNER IAW B767 SRM 53- 10-01-2R REPAIR 1. (1219987)SDR DALA2025092907046Skin · crackedSHIP 1703 FWD SERVICE DOOR CUTOUT AFT LOWER CORNER HOLE NO. 4 IS CRACKED. CRACK WAS FOUND DURING NDI INSPECTION. REPAIR IS REQUIRED PRIOR TO FURTHER FLIGHT. AMOC TO AD 24-05-03 MAY BE REQUIRED. REFER TO AA 5331-01288. CORRECTIVE ACTION: REPAIRED FWD SERVICE DOSDR DALA2025092907044Spring · inoperativeSHIP 194 GAS SPRING DOESN'T WORK ON 831 FWD LEFT PASSENGER DOOR. CORRECTIVE ACTION: REMOVED AND INSTALLED NEW GAS SPRING ON 831 FWD L/H PASSENGER DOOR IAW B767 AMM 25-66-03-004-053 AND IAW B767 AMM 25-66-03 (1219857)SDR FDEA202509261839Actuator · failedON TAKE OFF OUT OF MEM, LANDING GEAR WOULD NOT RETRACT. RAN QRH, LANDING GEAR RETRACTED WITH LOCK OVERRIDE. LANDING GEAR EXTENDED NORMALLY ON APPROACH INTO FSD. A/C SHOWED LT TRUCK TILT SENSED IT WAS STILL ON THE GROUND. DISCONNECTED AFT END OF TRUCK TILSDR FDEA202509261838Packing · failedTAKEOFF ROTATION ON DEPARTURE IN MEM DID NOT FEEL NORMAL. IT FELT LIKE THE GEAR TRUCKS DID NOT TILT. AMM: 32-32-15-4 ON INSPECTION OF LEFT TRUCK TILT ACTUATOR, FOUND THE BLEED PLUG LEAKING FLUID ALLOWING ACTUATOR PISTON TO MOVE FREELY. THE PLUG WAS LOOS