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 AALA202507089730Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL LOWER SURFACE AT RIB 11 AND 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364989.SDR AALA202507085372Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL LOWER SURFACE BETWEEN RIBS 10 AND RIB 11 AT 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364980SDR AALA202507088115Hinge Fitting · wornAIRCRAFT WAS GROUNDED: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE FITTING WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507086095Hinge Fitting · wornAIRCRAFT WAS GROUNDED: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE FITTING WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507081044Hinge Fitting · wornAIRCRAFT WAS GROUNDED: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE FITTING WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507080959Hinge Fitting · wornAIRCRAFT WAS GROUNDED: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE FITTING WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507089333Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL LOWER SURFACE AT RIB 19 AND 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364980.SDR AALA202507081427Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL LOWER SURFACE BETWEEN RIB 15 AND RIB 16 AT 1 INCH FROM THE REAR SPAR. REPAIRED SKIN PANEL PER EA 364980.SDR AALA202507088347Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202507087822Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202507083012Hinge Fitting · wornAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #6 HINGE FITTING WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR AALA202507085364Hinge Fitting · wornAIRCRAFT WAS GROUNDED: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE FITTING WORN. REPLACED HINGE FITTING PER AMM 55-16-42.SDR YENA2025070800710Warning Message · illuminatedFLT 353, BOS-DUB/ (ETOPS) "SMOKE CLASS 2 MAINT MSG ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 2, FAULTS INDICATED BY SMOKE; RESOLVED ON W/O: 1423668 TASKCARD: NR-00001, PERFORMED BITE TEST OF SDF. BITE TEST OKAY. RSDR AALA202507085676Warning Light · illuminatedAIRCRAFT WAS NOT GROUNDED: FILTER BYPASS LIGHT FOR FUEL ON ENGINE NUMBER 2 CAME ON FOR ACOUPLE MINUTES, THEN EXTINGUISHED WHEN CENTER PUMPS TURNED ON. CENTER PUMPS WERE OFF FOR TAKEOFF DUE TO LOW QUANTITY 1000 LBS. LIGHT REMAINED OFF AFTER CENTER PUMPS TURNED SDR AALA202507086448Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STICKS AND IS DIFFICULT TO OPEN. LUBED AND ADJUSTED DOOR FRAME BOTTOM PLATE. OPERATIONAL CHECK GOOD. PER AMM 25-40-00.SDR AALA202507085254Door · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT REPORTS THAT THE FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED VERTICAL SIDE TRIM ON FORWARD LAVATORY DOOR JAM. PER CMM 25 45-46.SDR AALA202507086910Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTENDANT EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED AFT FLIGHT ATTENDANT FLASHLIGHT. PER AMM 25-64-00.SDR SCNA20250708248Lens · brokenCENTER EMERGENCY EXIT LENS BROKEN - R & R CENTER EMERGENCY EXIT ROW LENS IAW AMM 33-51-01SDR CALA2025070806340Rib · crackedLT HORIZ STAB LE 331B WITH CRACKED RIB (2ND FROM IB). REMOVED AND REPLACED RIB AT LT HORIZ STAB LE 331B (2ND FROM IB) PER REF B737-SRM 51-40-02-0G-0 AND DWG NO. 186A1001.SDR CALA2025070806339Rib · cracked{B737-06-3-0074} LT HORIZ STAB LE 331B WITH CRACKED RIB (22ND FROM IB). REMOVED AND REPLACED RIB AT LT HORIZ STAB LE 331B (22ND FROM IB) PER REF B737-SRM 51-40-02-0G-0 AND DWG NO. 186A1001.SDR CALA2025070806338Cooling Fan · failedEQUIP COOLING FWD FAN 2 FWD EE COOLING SUPPLY FAN 2 FAILURE. OR FWD EE COOLING SUPPLY FAN 2 FAILURE. SUSPECT #2 FWD E&E SUPPLY FAN AT FAULT. REMOVED #2 FWD E&E COOLING SUPPLY FAN IAW DMC-B787-A-21-27-12-00A-520A-A AND FOUND FAN SPINNING FREELY BUT MAKING A SLSDR CALA2025070806337Rib · wornWEAR FOUND AT RIB FIXED LEADING EDGE (FRONT VERTICAL STABILIZER RIB MATTING SURFACE TO THE VERTICAL FIN, 321A, AFT SEAL). REMOVED AND REPLACED FRONT VERTICAL STABILIZER RIB FIXED LEADING EDGE IN REF TO B737 SRM 51-40-02-0G-0 AND 176A3001.SDR CALA2025070806336Skin · crackedCRACK FOUND AT RIGHT HORIZONTAL STABILIZER LOWER SKIN AT STAB STA 101.90,10IN FROM REAR SPAR, I/B ROW. CRACK LENGTH : 0.468IN. ACCOMPLISHED REPAIR AT RIGHT HORIZONTAL STABILIZER LOWER SKIN AT STAB STA 101.90,10" FROM REAR SPAR, I/B IN REFERENCE TO B737 SRM 55SDR CALA2025070806335Floor Support · crackedCABIN FLOOR STRUCTURE INTERCOSTAL LBL 13 STA380-400 WITH CRACKED UPPER ANGLE. REMOVED AND REPLACED AT CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 380 TO STA 400 LBL 13 IAW SRM 51-40-02-0G-0 ,DWG # 143A5410 SH 16.SDR CALA2025070806334Floor Support · crackedCABIN FLOOR STRUCTURE INTERCOSTAL BL 0 STA380-400 WITH CRACKED UPPER ANGLE. REMOVED AND REPLACED ANGLE AT CABIN FLOOR STRUCTURE BL 0 AS PER B 737-800 REF SRM 51-40-02-0G-0.SDR CALA2025070806333Floorbeam · corrodedFWD WET AREA FLOOR BEAM STA 344 LBL 56 UPPER FLANGE HAS CORROSION. REMOVED CORROSION AT MAIN CABIN FWD WET AREA FLOOR BEAM STA 344 LBL 56 UPPER FLANGE, MEASURED AREA, ORIGINAL MATERIAL 0.175", MATERIAL LOSS 0.063", FOUND OUT OF LIMITS, , CUTOUT DAMAGE AREA BSDR CALA2025070806317Light · false activationDURING T/O THE CABIN EMERGENCY LIGHTING ILLUMINATED PERFORM EMERGENCY LIGHTS - OPERATIONAL TEST PER AMM 33-51-00-710-801, OPS TEST GOOD, COULD NOT DUPLICATE WRITE UPSDR CALA2025070806314Unknown · odorSHORT DURATION RATTLE FOLLOWED BY BURNED RUBBER SMELL NEAR FO SD WNDOW. FIRST OFFICER WINDOW NOISE. DEBRIEFED PILOTS ON ARRIVAL AND SAID ODOR OBSERVED ONLY FOR SEVERAL SECONDS. PILOT TURNED OFF FOOT HEATER. SMELL DISSIPATED. OPERATED FOOT HEATER IAW AMM DMSDR CALA2025070806313Fuel Sys · leakingTOXIC FUMES IN CABIN. APU FUEL LEAK. RAN BOTH PACKS, INSPECTED THE CABIN AND PERFORMED INSPECTION IAW AMM 05-54-56. NO SIGN OF ODOR FUMES THROUGHOUT THE CABIN.SDR CALA2025070806312Filter · cloggedDUE TO #1 ENG WASH LAST NIGHT IN SFO. PERFORMED ODOR IN THE CABIN CONDITIONAL INSPECTION PER AMM 05-51-26-800-801-C1. ENG RUNS AND PACK BURNOUT NO ODOR PRESENT. REMOVED & REPLACED LEFT & RIGHT RECIRCULATION AIR FILTERS.SDR BJNA202507060001Girt Bar · improper stowMAINTENANCE CONTROL REQUESTS RE INSPECTION OF THE L1 DOOR GIRT BAR INSTALLATION. PLEASE CHECK FOR PROPER L1 DOOR GIRT BAR INSTALLATION PER AMM 25-66-01 STEP E, STEP E AND F. MAKE SURE THE GIRT BAR DOES NOT MAKE CONTACT WITH THE DOOR FRAME WHEN OPENING THE DOORSDR SWAA2025070788698Slide · out of limitsAFTER SERVICE. DOOR SLIDE IS INDICATING IN RED. REMOVED AND REPLACED SLIDE ASSY PER M/M 25-66-01 AND MT 725-61-06.SDR DALA2025070705025Warning Message · illuminatedSHIP 3134 ECAM DOOR PAGE INDICATIONS - FWD CARGO DOOR. CORRECTIVE ACTION: T/S PER A319 TSM 52-31-00-810-801-A. (6373725).SDR DALA2025070705065Controller · faultedSHIP 3119 - ATO - DUE TO AFT CARGO HEAT MESSAGE AT THROTTLE UP. DEFERRED AFT CARGO HEAT PER MEL AND CONTINUE. REPLACED AFT CARGO HEAT CONTROLLER 10HV.SDR DALA2025070705022Retainer · corrodedSHIP 3130 CORROSION ON TROLLEY RETAINER BLOCK COMPARTMENTS 110, 111 AND 112 OF G ALLEY 1 AT FWD GALLEY AREA. CORRECTIVE ACTION: COMPLIED WITH ER/A 626879-14. (1067145).SDR HALA20250707207Warning Light · false activationETOPS - ECAM: ENG 2 OIL CHIP DETECTED. PERFORMED TSM 79-20-00 UP TP STEP 4B MAGNETIC CHIP DETECTOR SYSTEM TEST FAULTS OIL SYSTEM DEBRIS PERFORMED DETAILED INSPECTION NO DEFECTS NOTED REMOVED AND REPLACED ENG#2 SCAVENGE OIL FILTER IAW AMM 79-22-45 RAN ENG #2 IASDR SWIA202507070006Detector · faultedFLAP FAIL, AT 20. (FLIGHT 5420 - FILED CLOSED)TROUBLESHOT FLAP FAIL AT 20 DEG IN REFERENCE WITH CRJ200 FIM 27-50-00. INTERROGATED FECU FAULT LOG IN REFERENCE WITH AMM 27-51-05. FOUND LATEST CODES CORRELATING TO LOSS OF A/C POWER 1 AND LOSS OF A/C POWER 2. DETSDR DALA2025070705040Frame · damagedSHIP 3417 FR 61, BETWEEN STR 1L-1R, AFT SIDE OF FRAME, FOUND TOOLING DAMAGE ON FRAME. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1067345)SDR DALA2025070705039Bracket · damagedSHIP 3417 FRAME 61 AFT SIDE STRINGER 2L - BRACKET HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1067202)SDR DALA2025070705028Frame · damagedSHIP 3417 FRAME 61 FWD SIDE BETWEEN STRINGERS 1L AND 2L - FASTENER HEAD HAS TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-11. (1067339)SDR DALA2025070705027Fastener · misinstalledSHIP 3417 FWD SIDE OF FRAME 61 I/B SIDE OF STRINGER 1R HAS IMPROPERLY INSTALLED FASTENER AND TOOLING DAMAGE ON THE STRINGER. CORRECTIVE ACTION: REPAIRED PER ERA 627279-14 REVS 0, 1, 2, 3. (1067390)SDR CALA2025070706278Bulb · burned outL-2 DOOR EMERGENCY LIGHTS INOP L-2 DOOR LIGHT INOP.SDR CALA2025070706277Elec Connector · unsecureOVERHEAD BINS 7 DEF , 34 DEF, 1 FE EMERGENCY LIGHTS INOP STE N/R 129622. TIGHTEN CONNECTION AND OPS CHECKS WERE GOOD PER 33-51-07-862-004SDR CALA2025070706276Elec Connector · unsecureR-2 DOOR EMERGENCY LIGHTS INOP CONNECTION WAS SECURED AND OPS CHECKS OF LIGHTS WERE GOOD PER 33-57-07-862-034. R-2 DOOR EMERGENCY LIGHTS INOP CONNECTION WAS SECURED AND OPS CHECKS OF LIGHTS WERE GOOD PER 33-57-07-862-034 REF STE N/R 129621.SDR CALA2025070706275Bulb · burned outAISLE PATH LIGHTS FROM SEAT 31 AFT ARE INOP. REPLACED BULB PER 33-51-03-002-001 OPS CHECKS GOOD.SDR CALA2025070706274Bulb · burned outEMERGENCY LIGHT AT SEAT 3 AB END CAP IS INOP SDR REPORTING REPLACED LIGHT AT SEAT 3AB PER 33-51-11-403-036 , OP CHECKS GOOD.SDR CALA2025070706273Fitting · crackedWINDSHIELD LOWER NODE AREA, LEFT CONTINUITY FITTING CRACKED AT HORIZONTAL FLANGE, AFT EDGE. REMOVED/REPLACED LH AND RH CONTINUITY FITTINGS AS DIRECTED BY EA 5310-07675 AND IAW A319 SRM 51-42-14/001 AND AIRBUS REPAIR DRAW INGS R5311-2919 AND R 53113426.SDR YENA2025070700685Generator · warning messageFLT#2104, BOS-LGW. CLASS II MAINTENANCE AS GEN ON STATUS PAGE AFTER ENG SHUT DOWN ( CLASS II MX MSG - GPCU OR AC GEN); PERFORMED BITE TEST OF THE EGPS IAW AMM 24-41-00 BITE TEST GOOD MDDR CLEARED PLACRD REMOVED.SDR WX0A2025070732490Cover · detached(AIRCRAFT NOT GROUNDED) EXIT COVER FELL OFF L2 DOOR. / INSTALLED NEW EXIT COVER AT L2 DOOR REF AMM 33-51-13-000-001-A/33-51-13-400-001-A."SDR WX0A2025070732488Cids · faulted(AIRCRAFT NOT GROUNDED) EXIT SIGNS OF L1, R1 AND FWD GALLEY AREA ARE FLASHING ON AND OFF DURING FLIGHT. THE REST OF THE EXIT SIGNS IN THE CABIN WERE ON. EMGR EXIT LT SWITCHES IN THE ARM POSITION. / PERFORMED CIDS RESET IAW AMM 23-73-00-740-003-A. A/C OK FOR S