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 DXTA2025071004161Detection Sys · no testON CABIN PREP SYSTEMS TEST THE RED BAGGAGE FIRE TEST FAILS. THE RES CAS MESSAGE STAYS ILLUMINATED AND RED BAGGAGE FIRE BUTTON STAYS ILLUMINATED. UNABLE TO REAT OR TEST. CORRECTIVE ACTION; POWERED ON AIRCRAFT, COMPLETED MULTIPLE BAGGAGE COMPARTMENT SMOKE DETECSDR N6WA2025071007Doubler · not reportedREMOVE STGR27 AT FS421-FS437.00 FOR ACCESS TO ANTENNA DOUBLER REPLACEMENT. PERFORMED REPAIR ON STGR27 AT FS421-FS437 IAW GOJET EO-C550-53MR-050SDR 6CBA2025070907001Sealant · tornDURING A FLIGHT FROM PHL TO FOK, THE CREW NOTED A PIECE OF THE COPILOT. WINDSHIELD SEALANT SEPARATED. THE CREW DECIDED TO DECLARE AN EMERGENCY AND DIVERT TO JFK. A TECHNICIAN REMOVED AND REPAIRED THE LIFTING COPILOT'S WINDSHIELD EDGE SEAL IAW PILATUS AMM 12-SDR 4DPA2025070700001Acm · damagedCREW REPORTED- SMOKE IN CABIN AND COCKPIT, BURNING SMELL. DECLARED EMERGENCY, DONNED OXYGEN MASKS AND PERFORMED EMERGENCY RETURN TO TAOS. CORR ACTION- MX TROUBLESHOT TO BAD ACM AND AFTER OPS TEST OF PACK SYSTEM AFTER MEL APPLIED VERIFIED NO SMOKE OR FUMES PRESSDR WX0A2025070932495Oil System · leaking(AIRCRAFT NOT GROUNDED) DURING DESCENT ALL CREWMEMBERS DETECTED DIRTY SOCK ODORS. REF LP 1967836. REPLACED FCU PER AMM 49-32-11-000/400-003-A. LEAK CHECK GOOD. NO LEAKS NOTED AT THIS TIME. PER TC 21-000-001 LEVEL 2 DUE. (RESOLVED ON W/O: 525871 TASKCARD: NR-0SDR WX0A2025070932494Fitting · fod(AIRCRAFT NOT GROUNDED) R2 SLIDE SHOWING NOT ARMED AT THE TOP OF CLIMB AND DURING REMAINING DURATION OF FLIGHT / PERFORMED FUNCTIONAL CHECK OF R2 REALEASE MECHANISM OF THE EMERGENCY ESCAPE SLIDE. FOUND & REMOVED DEBIS FROM GIRT BAR FLOOR FITTINGS. OPS CHECK ONSDR DALA2025070905184Pressure Switch · leakingSHIP 3169 - MISC - DECLARED EMERGENCY DUE TO LOSS OF YELLOW HYDRAULIC SYSTEM FLUID. CORRECTIVE ACTION: REPLACED LEAKING YELLOW HP MANIFOLD PRESSURE SWITCH AND ASSOCIATED SYSTEM FILTERS. (LP 7764502)SDR IXXA20250707027Access Panel · damagedCREW REPORTED, CATERING DAMAGED ACCESS DOOR TO SLIDE ON R4 DOOR. REINSTALLED R4 DOOR SLIDE IAW B757 AMM 25-66-03. OPERATIONAL CHECK OF SLIDE HOOK UP GOOD. NO OTHER FAULTS NOTED.SDR DALA2025070905179Repair · dentedSHIP 663 DTA MONITOR INSPECTION LOG REF ERA 627481-14 THE FUSELAGE FRAME AT BSTA 1300 WAS FOUND WITH EXISTING REPAIR DENTED BETWEEN S-25R AND S-27R. CORRECTIVE ACTION: REF ERA 627481-14AD. (1069703)SDR AALA202507098965Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: DURING BOARDING, ECAM DOOR LEFT OVERWING EXIT APPEARED. THE SLIDE ARMED LIGHT IS ACTUALLY ILLUMINATED ON THE DOOR. MAINTENANCE REPLACED SENSOR 33WN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITRRH NO FAULTS NOTED.SDR CALA2025070906388A/C Pack · malfunctionedLOSS OF PRESSURIZATION AT 14000. CABIN ALT 10K. EMERG DECLARED CREW REPORTED LOSS OF PRESSURIZATION AT 14500. NO MASKS DROPPED. POOR RT PACK CONTROL AND LT PACK ON MEL. DECLARED EMERGENCY CONFIRMED REPAIRS WITH MX. OPS CHECK NORMAL PER AMM 21-00-05-780-802. SDR CALA2025070906387Hydraulic Line · leakingAFTER GEAR EXTENSION, COMPLETE LOSS OF GREEN HYD SYS RESIVOR. FOUND HYDRAULIC HOSE AT THE RIGHT MLG DOOR ACTUATOR LEAKING. FOUND LANDING GEAR DOOR EXTENSION FLEX LINE FAILED REPLACED LINE REF AMM 29-23-11. ALL OPERATIONAL AND LEAK CHECKS OKAY .SDR CALA2025070906386Bleed Air Sys · leakingBLEED LOSS WING R EICAS ADVISORY BLEED AIR SUPPLY VALVES ARE LATCHED CLOSED OR THE RESPECTIVE SWI TCHES ARE OFF, SO THAT BLEED AIR IS NOT SUPPLIED TO THE R WAI, R PACK AND R HYDRAULIC RESERVOIR PRESSURIZATION. AHM SHOWS DUAL RIGHT BLEED LOOPS 1+2 MSG 'S26-37SDR CALA2025070906382Seat Track · corrodedFOUND CORROSION AT MAIN CABIN LT OTBD SEAT TRACK UPPER CROWN LBL 45.5, BS 767. REMOVED CORROSION AT SEAT TRACK. FABRICATED NEW SEAT TRACK & INSTALLED WITH REPAIR PARTS IAW SRM 51-40-02, SRM 53-00-52 & DWG # 146A5300.SDR CALA2025070906381Baffle · corrodedAFT CARGO BAFFLE UNDER RH Z-CHANNEL BETWEEN STA 747-767 AT RBL 21 FOUND CRACKED. REMOVED AND REPLACED BAFFLE UNDER RH Z-CHANNEL BETWEEN STA 747-767 AT RBL 21 PER SRM 51-40-02-0G-0 AND DWG 146A7505.SDR CALA2025070906380Frame · dentedAFT CARGO COMP, LT SIDE, LOWER FRAME STA 1 400, HAS DENT. ESFR COMPLETED. REPAIRED LOWER FRAME STA 1400 LH SIDE IAW B757-300 EA#757-5360-1 3-A3955 AND EC/RA# 5360-01985. MAJOR REPAIR.SDR CALA2025070906379Smoke Detector · false activationAFT CARGO FIRE WARNING ILLUMINATED 3 TIMES BOTTLE WAS DISCHARGE DPER CAPTAIN, DURING CLIMB OUT AGT CARGO PIT SMOKE DET LITE ILLUMINATED TWICE. HE BLEW THE BOTTLE AND THE LITE CAME ON AGAIN. CABIN CREW DID NOT SMELL SMOKE. REMOVED FIRE BOTTLE 1 REF AMM 26-23SDR CALA2025070906377Tee Fitting · crackedLEFT WING TO BODY FAIRING STRUCTURE FRAME AT BS 1180, BEHIND PANEL, CRACKED. REMOVED AND REPLACED T-FITTING AT LT WING TO BODY FAIRING STRUCTURE FRAME AT BS 1180 IAW SRM 51-40-02-0G-0 REF. DWG 49N7223-61. REF NR#129031 AND LOGPAGE#5459828,SDR CALA2025070906376Blanking Plate · missingPDA 2 CREW LOG PAGE# 5470969, LEFT MAIN LANDING GEAR PURPLE BLANKING PLUG MISSING. LEFT MLG MISSING BLANKING PLUG. PERFORMED INTERIM REPAIR PER PART 1 OF ECRA 3211-01346 TO LT MLG BLANKING PLUG. ISSUE DIP TO ACCOMPLISH DAILY INSP IAW PART 2 & PERMANENT REPAIRSDR CALA2025070906375Frame · dentedAFT CARGO COMP, LH SIDE, LOWER FRAME STA 1 520, HAS 2EA DENTS. PERFORMED REPAIR IAW EA#757-5360-13-A3956 AND EC/RA 5360-01983. MAJOR REPAIR.SDR AALA202507093117Battery · no testAIRCRAFT IN BASE MAINTENANCE: ON PTP PANEL 110RH EMERGENCY LIGHT SYSTEM TEST RETURNED: ATA 33-51-38 "EPSU BATTERY EXIT L" AND "EPSU ATTERY EXIT R" FAULT MESSAGE. REPLACED THE BATTERIES FOR EMERGENCY POWER SUPPLY UNIT 11WL (AALA202507082534) AND 12WL (AALA20250SDR AALA202507093535Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AAL2025F00005Bottle · low pressureAIRCRAFT WAS GROUNDED: 3R DOOR INDICATES LOW PRESSURE WHEN ARMING. MAINTENANCE SERVICED THE R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00 WHICH CLEARED THE CIDS CAUTION MESSAGE.SDR AALA202507094300Wire · brokenAIRCRAFT WAS NOT GROUNDED: RED SEAT MOUNTED EMERGENCY AISLE LIGHT AT SEAT ROW 10ABC IS INOPERATIVE. REPAIRED THE EMERGENCY LIGHT WIRE AT SEAT 10ABC AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER ESPM 20-43-11.SDR AALA202507093915Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507098966Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 832, DOOR DAMPER AND EMERGENCY OPERATION CYLINDER FAILS THE DAMPING FUNCTION TEST. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR AALA202507094865Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 831, DOOR DAMPER AND EMERGENCY OPERATION CYLINDER FAILS THE DAMPING FUNCTION TEST. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR AALA202507092534Battery · no testAIRCRAFT IN BASE MAINTENANCE: ON PTP PANEL 110RH EMERGENCY LIGHT SYSTEM TEST RETURNED: ATA 33-51-38 "EPSU BATTERY EXIT L" AND "EPSU ATTERY EXIT R" FAULT MESSAGE. REPLACED THE BATTERIES FOR EMERGENCY POWER SUPPLY UNIT 11WL (AALA202507082534) AND 12WL (AALA20250SDR YENA2025070900714Filter · cloggedFLT#594, STI-EWR. INTMT SMOKE LAVATORY SMOKE WARNING; REF TSM 26-17-00-810-804-A. FOUND LAV'S B AND F LAV EXTRACT FILTERS CLOGGED. REPLACED LAV'S A, B, AND F FILTERS. PERFORMED OPS CHECK WITH NO FAULTS. NO T/S DATA. NO FAULTS FOUND. NO HISTORY. A/C OK TO CONTISDR DXTA2025070904160Battery · no testEMERGENCY LIGHTS TEST FAILED DURING PREFLIGHT. TWO UNSUCCESSFUL SEPARATE 30' CHARGING CYCLES (60' CUMULATIVE) WERE PERFORMED PER QRH CHARGING PROCEDURE. NO LIGHTS ILUMINATE WITH SWITCH IN ARM POSITION. CORRECTIVE ACTION: REPLACED BATTERIES IAW CE-680A MM CHAP SDR HALA20250708209Exciter · out of limitsETOPS - #2 ENG IDG EXCITER FIELD CHECKS OUT OF LIMITS PER TSM 24-20-00-810-875-A PARA 4 (A) (1). IDG REMOVED UP TO AMM 24-21-51-000-804A STEP 4(A). CONTINUED REMOVAL OF #2 IDG AND REPLACED #2 IDG PER AMM 24-21-51 OPS AND DISCONNECT TEST CHECK GOOD OK FOR SVC.SDR HALA20250708208Oil System · leakingETOPS - LIGHT DIRTY SOCK SMELL ONLY ON DESCENT. PERFORMED TSM 71-00-81-810-805A PER STEP 2(E) PERFORMED BORESCOPE OF LP HP COMPRESSOR. RAN #1 ENGINE AND FOUND OIL WETNESS PRESENT. REQUIRES #1 ENGINE CHANGE PER TSM.023199 AIRCRAFT FERRYING TO LAX FOR ENGINE CHASDR DALA2025070805166Actuator · inoperativeSHIP 3123 RUDDER TRIM CAPTAINS SIDE WOBBLES AND MAKES LOUD CRACKING NOISE WHEN MOVED. FOUND CRACK ON THE TRIM. FOUND PEDAL ADJUSTMENT ACTUATOR INOP. CORRECTIVE ACTION: R/ R PEDAL ADJUSTMENT ACTUATOR AND COVER ASSY PER A319 AMM 27-21. (5864142).SDR DALA2025070805165Oxygen Mask · inoperativeSHIP 3162 O2 MASK INOP. CORRECTIVE ACTION: T/S IAW A319 TSM 35-10-00-810-805-A. (7730602).SDR DALA2025070805163Retainer · crackedSHIP 3122 DURING INSPECTION OF AFT GALLEY G5 FOUND IN COMPARTMENT 510F O/B TROLLEY RETAINER BLOCK HAS CRACK 3/8" LONG. CORRECTIVE ACTION: COMPLIED WITH ER/A 627623-4. (7732415).SDR DALA2025070805161Retainer · crackedSHIP 3122 DURING INSPECTION OF AFT GALLEY G5 DOUND IN COMPARTMENT 512F CRACK IN I/B TROLLEY RETAINER BLOCK 5 INCHES LONG AND O/B TROLLEY BLOCK CRACK 3/4" LONG. CORRECTIVE ACTION: COMPLIED WITH ER/A 627623-14. (7732413).SDR DALA2025070805160Retainer · crackedSHIP 3122 FOUND CRACK ON COMPARTMENT 510 O/B TROLLEY RETAINER BLOCK. CORRECTIVE ACTION: COMPLIED WITH ER/A 627623-4. (1069491).SDR DALA2025070805156Controller · faultySHIP 3420 1R DOOR SHOWING OPEN ON TAXI OUT WHEN IT WAS CLOSED. CORRECTIVE ACTION: R/R PSCU IAW A330 AMM 52-71 BITE TEST OK. (7283898)SDR DALA2025070805155Frame · damagedSHIP 3417 AFT SIDE OF FRAME 61 BRACKET BETWEEN STRINGER 2R AND 3R HAS 3 SPOTS OF TOOLING DAMAGE. CORRECTIVE ACTION: R/R BRACKET PER A330 SRM 51-42-11. (1069307)SDR DALA2025070805154Frame · damagedSHIP 3417 FRAME 61 FWD SIDE BETWEEN STRINGERS 1L AND 2L - BRACKET HAS TOOLING DAMAGE. CORRECTIVE ACTION: R/R BRACKET PER A330 SRM 51-42-11. (1068826)SDR DALA2025070805153Frame · damagedSHIP 3415 FRONT SIDE OF 6 AT STRINGER 1L TOOLING DAMAGE OF FRAME CHANNEL. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. ORIG. (1069236)SDR DALA2025070805152Stringer · damagedSHIP 3416 FRAME 63 ON STRINGER 2R TOOLING DAMAGE WHERE FASTENERS COME THROUGH STRINGER. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. ORIG. (1069322)SDR DALA2025070805151Bracket · crackedSHIP 3412 BHEC BRACKET FROM FR C61 STR 2R TO FRAME CRACK. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1068528)SDR DALA2025070805150Frame · damagedSHIP 3415 AFT SIDE OF FRAME 63 BETWEEN L1 AND R1 DAMAGE IS PAINTED OVER. CORRECTIVE ACTION: REPAIRED TOOLING DAMAGE PER ERA 627461-14 REV ORIG. (1069233)SDR DALA2025070805149Skin · damagedSHIP 3415 AIRCRAFT SKIN ABOUT 3" FWD OF FRAME 63 TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1069231)SDR DALA2025070805148Skin · damagedSHIP 3415 AIRCRAFT SKIN ABOUT 4" AFT OF FRAME 63 BETWEEN L1 AND R1 RIDGE IN PAINT TOOLING DAMAGE. REPAIRED PER ERA 627461-14 REV ORIG. (1069223)SDR DALA2025070805147Shear Tie · damagedSHIP 3417 FRAME 61 FWD SIDE STRINGER 1L - BRACKET HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV B. (1068403)SDR DALA2025070805128Shear Tie · damagedSHIP 3417 AFT SIDE OF FRAME 61 BRACKET BELOW STRINGER 1R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV B. (1068337)SDR DALA2025070805127Shear Tie · damagedSHIP 3417 FWD SIDE OF FRAME 61 SHEAR TIE AT STRINGER 2R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-42-11. (1067913)SDR DALA2025070805126Channel · damagedSHIP 3417 FWD SIDE OF FRAME 61 R/H U-CHANNEL BRACKET BETWEEN STRINGER 1R AND 2R HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV. B. (1067857)