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 AALA202507185241Wire Harness · damagedAIRCRAFT WAS GROUNDED: 22C WHITE SEAT MOUNTED EMERGENCY AISLE LIGHT INOP. MAINTENANCE REPLACED HARNESS 5409VB AT SEAT 22C IAW AWM 33-51-08.SDR CALA2025071806737Access Panel · missingNUMBER 2 ENGINE INBD PYLON MISSING ACCESS PANEL 443 CL. INSPECTED INSIDE PYLON, NO DAMAGE NOTED. ALL DUCTS SECURE. ONE STRUT PRESSURE RELIEF DOOR MISSING.SDR CALA2025071806711Lamp · inoperativeAFT RIGHT EMERGENCY LIGHT INOPERATIVE ON OVERHEAD BIN. RELAMPED IAW AMM 33-51-05-002-001. OPS TEST GOOD.SDR CALA2025071806710A/C Pack · inoperativeLT FWD EMERGENCY LIGHT BULB INOPERATIVE. REPLACED BULB.SDR CALA2025071806703Skin · dentedREMOVE AND REPLACE AFT CARGO DOOR EXTERNAL SKIN. REMOVED AND REPLACED AFT CARGO EXTERAL DOOR SKIN IAW SRM 52-30-01-2R-3 AND 51-40-02-0G-0.SDR CALA2025071806702Strap · corrodedMAIN CABIN FWD WET AREA CORROSION AT RT INNER CHORD BETWEEN STA 294.5 - 328. INSTALLED NEW INNER CHORD AT R/H R-1 DOOR LOWER SILL IAW SRM 51-40-02-0G-0, DWG: 141A8310.SDR CALA2025071806701Strap · crackedMAIN CABIN FWD WET AREA CRACK AT LH INNER CHORD STA 309. REMOVED AND REPLACED L-1 INNER CHORD REF SRM 51-40-02 DWG 141A8110.SDR CALA2025071806700Strap · corrodedMAIN CABIN FWD WET AREA CRACKED AT RT INNER CHORD STRAP BS 294.5+3. REMOVED AND REPLACED MAIN CABIN FWD WET AREA RH INNER CHORD STRAP AT STA 294.5+3". REF: SRM 51-40-02-0G-0. DWG# 141A310 R-1.SDR CALA2025071806699Floor Support · crackedMAIN CABIN FWD WET AREA CRACKED AT FLOOR SUPPORT LBL 47, BS 344-328. REMOVED AND REPLACED THE FLOOR SUPPORT IAW SRM 51-40-02-0G-0 & DWG #141A5400.SDR DALA2025071705411Stringer · damagedSHIP 3412 FOUND MULTIPLE HOLES IN STRINGERS L1, L2, R1, R2 AT FR C64 UNINSPECTABLE. COMPLIED WITH E/RA 627660-14. (1086960).SDR DALA2025071705406Stringer · damagedSHIP 3412 VIASAT OVERSIZED HOLE REPAIR OF STR 1L NEAR FR 64 WITH REINFORCEMENT STRAP. COMPLIED WITH ER/A 627660-14. (1085946).SDR SWAA2025071792185Bustle · out of positionAFT ENTRY DOOR SLIDE LOOSE IN BUSTLE REPACKED AFT ENTRY DOOR SLIDE PER MT 725-61-06<[01] REPOSITIONED AFT ENTRY DOOR SLIDE PER MT 725-61-06.SDR SWAA2025071791574Battery · failedTHE OUTBOARD FLASHLIGHT INSTALLED AT THE RIGHT; AFT FLIGHT ATTENDANTS SEAT FAILED ITS CHECK. THE OUTBOARD FLASHLIGHT INSTALLED AT THE RIGHT AFT FLIGHT ATTENDANTS SEAT FAILED ITS CHECK.<[01] REMOVED AND REPLACED THE BATTERY IN THE OUTBOARD FLASHLIGHT INSTALLED SDR SWAA2025071791668Isolation Mount · brokenAFT ENTRY DOOR FORWARD SLIDE ATTACH BRACKET HAS TWO BROKEN MOUNT ISOLATORS. R & R IAW SRM 51-40-02.SDR SWAA2025071792021Battery Pack · inoperativeEMERGENCY LIGHTS ON ROW 6 - 14 OVERHEAD BINS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK M1676 AND PERFORMED GOOD OPS CHECK IAW AMM 33-51-06. REMOVED AND REPLACED BATTERY PACK M1676 AND PERFORMED GOOD OPS CHECK IAW AMM 33-51-06.SDR SWAA2025071792156Battery Pack · inoperativeLEFT & RIGHT OVERWING FWD DOOR EMERGENCY EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED IAW AMM 33-51-06-960-805-NG (POWER SUPPLY - BATTERY PACK REPLACEMENT - PERMANENT).SDR SWAA2025071792025Battery Pack · inoperativeL1 DOOR EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED 1 EA L1 DOOR EMERGENCY LIGHTS BATTERY PACK AND OPS CHECK GOOD IAW SWA AMM 33-51-06-960-805.SDR SWAA2025071791642Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. SECURED FWD ENTRY DOOR UPPER ASSIST HANDLE IAW AMM 20-50-11.SDR SWAA2025071792178Bracket · looseENTRY GIRT BAR ATTACHMENT LOOSE. ADJUSTED GIRT BAR ATTACH BRACKET PER SIP; OPS CK GOOD.SDR SWAA2025071791627Handle · looseFWD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. SECURED FWD ENTRY DOOR L1 UPPER ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791643Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791626Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791628Handle · looseAFT GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED AFT GALLEY SERVICE DOOR R2 ASSIST HANDLE REF AMM 20-50-11.SDR SWAA2025071791658Skin · delaminatedON POST DOCK WALK AROUND FOUND LOWER SURFACE OF RIGHT WING OUTBOARD AFT FLAP HAS EVIDENCE OF DELAMINATION MEASURING 10 BY 16 AT INBOARD AFT CORNER. REMOVED RH WING; OTBD FLAP IAW AMM 27-51-22. REMOVED AND REPLACED RIGHT WING OUTBOARD AFT FLAP IAW AMM 27-51-2SDR SWAA2025071791919Fairing · missingNR 6 FLAP CANOE AFT FARING HAS MULTIPLE MISSING ;LOOSE AND PULLED FASTENERS. REMOVED AND REPLACED #6 CANOE AFT FAIRING PER AMM 27-51-18 AND REPLACED DAMAGED FASTENERS AS REQUIRED PER SOPM 20-50-02.SDR DALA2025071705396Unknown · odorSHIP 3128 ODOR IN COCKPIT ON DESCENT. T/S AND C/W A319 WORKCARD 0550-2002. (7281732).SDR DALA2025071705395Flap Track · corrodedSHIP 3130 CORROSION FITTING SUPPORT FLAP ON SPHERICAL BEARING TRACK 3 O/B FLAP RT WING. COMPLIED WITH ER/A 627155-14. (1086470).SDR DALA2025071705394Stop Pad · brokenSHIP 3155 BROKEN DOOR STOP PASSENGER CREW DOOR 831 LOCATED AT LEVEL BEAM 1 AND FWD POSITION AT FWD GALLEY AREA. CORRECTIVE ACTION: REPLACED DOOR STOP 1 FWD SIDE ON PASSENGER CREW DOOR 831 AS PER A320 FAM AMM 52-11-31-000-002-A AND AS PER A320 FAM AMM 52-11- 31SDR DALA2025071705393Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND ON FRAME 16 LH DOUBLE JOGGLE AREA HOLE C DOOR STOP FITTING 7. CORRECTIVE ACTION: COMPLIED WITH ER/A 626760-14AD. (1085935).SDR DALA2025071705392Door Frame · crackedSHIP 3130 CRACK INDICATION ON FRAME 16 AT FWD GALLEY AREA (LH DOUBLE JOGGLE ARE A HOLE 6 DOOR STOP FITTING 7. COMPLIED WITH ER/A 626760-14AD. (1085926).SDR DALA2025071705390Skin · dentedSHIP 3130 DENT EXTERNAL SKIN LOCATED AT FR 66 BTW STR 41R TO STR 42R AT LOWER FUSELAGE. CORRECTIVE ACTION: COMPLIED ER/A 627650-14AD. (1087796).SDR DALA2025071705389Receptacle · corrodedSHIP 3146 PYLON NUMBER 2 PYLON SPIGOT RECEPTACLE FITTING BORE WITH CORROSION. REPLACED SPIGOT FITTING AT PYLON NUMBER 2 IAW A319 SRM TASK 54-51-12-300-001. (1086556).SDR DALA2025071705388Ball Joint · scratchedSHIP 3146 ENGINE PYLON #1 UPPER SURFACE SPIGOT BALL JOINT WITH SCRATCH AND LOWER SPIGOT FITTING WITH CORROSION. REPLACED SPIGOT FITTING AT PYLON NUMBER 1 IAW A319 SRM TASK 54-51-12-300-001. (1086356).SDR AALA202507179007Carriage · crackedAIRCRAFT WAS GROUNDED: F/O SLIDING WINDOW CARRIAGE IS CRACKED AND REQUIRES REPLACEMENT. MAINTENANCE REMOVED AND REPLACED F/O SLIDING CARRIAGE IAW CMM 56-11-17SDR AALA202507170042Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY LIGHTS PS CHECK FOUND ROWS 37 HGED-40 HGED EMERGENCY LIGHTS INOP. MAINTENANCE FOUND EMERGENCY LIGHT J1 CONNECTOR DISCONNECTED UNDER SEAT 37 HGED. RE-CONNECTED IAW WDM 33-51-58.SDR AALA202507174356Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 5 RH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #5 RH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507176566Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 6 RH ON HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM #6 RH ON HORIZONTAL STABILIZER IAW AMM 55-16-42-000-001-A AND AMM 55-16-42-400-001-A.SDR AALA202507170746Battery · dischargedAIRCRAFT WAS NOT GROUNDED: FWD EMERGENCY BULLHORN INOP. BATTERY DEAD. MAINTENANCE REPLACED FWD BULLHORN AS REQUIRED IAW 25-00.SDR GTIA2025071738993Vent · inoperativeVENT AVNCS SYS FAULT-ACCOMPLISHED FAULT ISOLATION IAW TSM 21-26-00-810-853-A DO TO HISTORY AND PRIOR CORRECTIVE ACTION R&R AEVC 10HQ IAW AMM 21-26-34 PB401 OPERATIONAL TEST SATISFACTORY NO FAULTS NOTEDSDR AALA202507177880Relay · inoperativeAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THAT MULTIPLE CABIN AND EMERGENCY EXITLIGHTS ARE NOT WORKING. ACCOMPLISHED TROUBLESHOOTING, PER WDM 33-21-11. REMOVED AND REPLACED RELAY R120, PER AMM 20-10-07-201. ACCOMPLISHED OPERATIONAL TEST, PER AMM 33-21-00SDR AALA202507177401Unknown · odorAIRCRAFT WAS GROUNDED: STRONG FISH LIKE ODOR AROUND THE MIDDLE OF CABIN. ALSO PREVALENT AS WHEN YOU APPROACH AIRCRAFT FROM JETBRIDGE. (OPEN).SDR AALA202507177323Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR DIFFICULT TO OPEN, THE LAVATORY-D DOOR HINGE IS BINDING. LUBED DOOR HINGES, OPERATIONAL CHECK NORMAL. PER AMM 25-40-14.SDR AALA202507174387Slide · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORT THAT R1 DOOR SLIDE IS SHOWING PART OF THE SLIDE OUT OF THE SLIDE COVER AROUND THE BOTTOM PART. SECURED R1 DOOR SLIDE. PER AMM 25-66-01.SDR AALA202507170353Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS ADVISED LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. READJUSTED AFT LAVATORY-D TOP DOOR RAIL SCREW IN POSITION. OPERATIONAL CHECKED GOOD. PER CMM 26-40-64.SDR AALA202507175806Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR GIRT BAR STOWED BRACKETS ARE REPORTED TO TIGHT TO DETACH GIRT BAR. LUBED GIRT BAR. PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA202507177332Sill Drain · odorAIRCRAFT WAS GROUNDED: AFTER LANDING FLIGHT ATTENDANTS IN THE AFT CABIN REPORTED A STINKY DIRTY DIAPER OR SULPHUR LIKE SMELL UPON LANDING AND SAID NOTICED IT SLIGHTLY DURING TAKEOFF AS WELL. SWITCHED AIRFLOW FROM ENGINE BLEEDS TO APU BLEED AND REMAINED UNTIL SDR AALA202507170509Warning Light · illuminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER RAISING THE GEAR HANDLE, RIGHT MAIN GEAR LIGHT STAYED RED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. (OPEN).SDR HALA20250717219Pdu · inoperativeETOPS - FOUND PDUS 21R, 22R, + 32R IN MCD INOP. REMOVED & REPLACED PDUS 21R,22R & 32K IAW A330 AMM 25-56-62. OPS CHECK OF 21R, 22R, 32K. GOOD.SDR HALA20250717218Liner · tornETOPS - AFT BULK CARGO LINER TORN TYPE A WITH SCREEN. REMOVED & REPLACED AFT CARGO LINER IAW A330 25-53-00 + 25-54-00.SDR HALA20250717217Bmc · faultedETOPS - BTB DUE TO BLEED AIR RIGHT WING LEAK. REMOVED AND REPLACED THE BMC 2 PER AMM 36-11-34. SYS TEST OK. A/C OK FOR SVC.