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 AALA202507065656Battery · misinstalledAIRCRAFT WAS NOT GROUNDED: FA FLASHLIGHT OUT AT JUMP SEAT 3H IS INOP. FOUND FLASHLIGHT BATTERY INSTALLED UPSIDE DOWN AT 3L. MAINTENANCE INSTALLED FLASHLIGHT BATTERY IN CORRECT POSITION, OPS CHECK GOOD.SDR AALA202507043323Slide Raft · low pressureAIRCRAFT WAS GROUNDED: SLIDE DEPLOYMENT BOTTLE AT DOOR 2R APPEARS IN THE RED. MAINTENANCE REPLACED AFT RIGHT (842) ESCAPE SLIDE/RAFT PER J/C #26L00025011.SDR CALA2025070406222Heater · malfunctionedCREW REPORTS LT ENG EGT EXCEEDED DURI NG CLIMB. AHM SHOW ENG L EGT RED MM MSG 77-62121, EGT PEAK 626.5 DEG "TOL" TIME OVER LIMIT 05SEC. REF AMM 31-61-00-800-804 (20 1), NOTE DOWN EGT PEAK & DURATION FROM LEFT ENG EXCD. LT ENGINE EXCEEDANCE TIME OVER LIMIT OSDR CALA2025070406221Warning Message · false activationCREW REPORTS RT ENG EGT EXCEEDED DURI NG CLIMB. AHM SHOW ENG R EGT RED MM MSG 77-62122, AHM DID NOT TR IGGER EGT EXCEEDANCE REPORT FOR RT ENG IAW AMM 31-61-00-8 00-804 (201), NOTE DOWN EGT PEAK & DURATION FROM RT ENG EXCD. EXCEEDANCE OF 20.4 SECONDS AT 629.5 CSDR DALA2025070304991Skin · damagedSHIP 3416 AFTER PAINT REMOVAL FROM C60-C64 IN VIASAT MOD AREA FOUND MULTIPLE AREAS WITH TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIGINAL. (1057514)SDR DALA2025070304988Intercostal · damagedSHIP 3412 INTERCOSTAL AT FUSELAGE FRAME #64 AT STRINGER 1RT HAS A TOOLING MARK/ GOUGE BETWEEN FASTENERS. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV ORIG. (1057119)SDR DALA2025070304987Bracket · damagedSHIP 3412 TOOLING MARKS ON CLIPS AND BRACKETS REMOVED FROM FR. 60 STR. 2L AND STR. 2R. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. ORIG. (1057599)SDR DALA2025070304986Shear Tie · damagedSHIP 3412 SHEAR TIE ON FR 60 STR. 2L - 2R HAS TOOLING MARKS AND ELONGATED HOLES. CORRECTIVE ACTION: REPAIRED PER ERA 627461-14 REV. ORIG. (1057591)SDR DALA2025070304982Frame · damagedSHIP 3406 FWD SIDE OF FR61 BETWEEN STR 2R&3R. 1EA HI-LOK COLLAR NOTED WITH TOOLING DAMAGE 3RD RIVET INBD OF STR 3R COMMON TO AIRCRAFT SKIN. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-42-11. (1057952)SDR GTIA2025070338978Bottle · low pressureL1 DOOR ASSIST BOTTLE LOW PRESSURE-SERVICED L1 DOOR ASSIST BOTTLE IAW AMM 52-10-00SDR SWAA2025070387084Sign · missingL1 DOOR MISSING EMERGENCY EXIT/SALIDA SIGN. REMOVED AND REPLACED PER AMM 33-51-03-960-803-NG (EMERGENCY AISLE LIGHT (EAL) - LENS REPLACEMENT - PERMANENT)SDR SWAA2025070386904Handle · out of adjustFWD SERVICE DOOR INTERNAL HANDLE CAM ASSEMBLY RUBBING ON DOOR SKIN FASTENERS; INSUFFICIENT CLEARANCE<[01] INSTALLED WASHERS AND ADJUSTED PER AMM REF. 52-41-00. OPS CK GOOD.SDR SWAA2025070386866Seat Back · out of adjustCABIN PASSENGER SEAT RECLINES AT EXIT ROW 11B AND 12E.<[01] RE SECURED SEAT RECLINE ACTUATORS 11B AND 12E TO UPRIGHT LOCK POSITION REF CMM 25-21-45SDR SWAA2025070387514Winglet · corrodedFOUND EXFOLIATION CORROSION ON THE LEFT WINGLET PART OF THE AFT POSITION LIGHT ASSY. REMOVED LEFT WINGLET PER AMM 57-21-21. R/R LH WINGLET ASSY; OPS CK GOOD PER AMM 57-21-21.SDR CALA2025070306205Elbow · leakingSYS A QUANTITY 18 PERCEN T AT CRUISE. PRESS 3000 RAN QRH. MANUAL GEAR EXTENTION, NORMAL LANDING. HYD ANNUNCIATOR ON SIX PACK FLASHED BRIEFLY AND FLIGH CONTROL LIGHT ILLUMINATED. TECH FOUND SYSTEM A RESERVOIR EMPTY. LEFT WHEEL WELL IS SOAKED WITH HYD FLUID. TSDR CALA2025070306204Warning Message · false activationBLDS OFF TAKEOFF. WHEN TRNSFR BACK TO ENG BLD PER CHKLST NO ENG BLD PRSSR.APU/PACKS NORMAL. PER T/S IAW FIM 36-00 / 836 AND 837. IASC IS KNOWN TO TRIGGER THIS MAINT MSG AS A NUISANCE FAULT DUE TO A MOMENTARY FALSE HIGH TEMPERATURE MEASUREMENT. PERFORM INIT SDR CALA2025070306190Structure · corrodedFWD WET AREA L/H SIDE INNER CHORD HAS CORROSION FROM STA 328 TO STA 344. COMPLETED INSTALLATION AT FWD WET AREA OF L1 DOOR INNER CHORD IAW SRM 51-40-02-0G-0 DWG # 141A8110.SDR CALA2025070306189Floor Support · corrodedSTA 967+5/LBL 15... ELONGATED HOLES AND CORROSION. REMOVED AND REPLACED FLOOR SUPPORT BETWEEN STA 967 AND 986.35LBL 15 INCHES PER SRM 51-40-02-0G-0 AND DWG 140A9870 WORK ACCOMPLISHED BY V935074 AND INS 223SDR CALA2025070306185Slide · faultySLIDE PACK AT DOOR 2L HAS LOW PRESSURE. PERFORMED VISUAL OF DOOR MOUNTED ESCAPE SLIDE 2L TO BE IN THE MIDDLE OF THE RED BAND IN REF MM 25-66-01-02B-300C. REMOVED AND REPLACED DOOR L2 SLIDE ASSY REF AMM 25-66-01. ACCOMPLISHED RII INSP REQUIREMENTS FOR DOOSDR CALA2025070306184Slide · low pressureDOOR 4L SLIDE PRESSURE GAUGE OUT OF GREEN BAND. REMOVED AND REPLACED DOOR 4L ESCAPE SLIDE IAW AMM REF TASK 25-66-01-000-801 & TASK 25-66-01-400-801.SDR CALA2025070306183Girt Bar · no discrepancyDOOR 1R SLIDE IS SHOWING EXCESS MATERIAL REF AMM 25-66-01-400-804. GRIT MATERIAL IS IN LIMITS AND Z FOLD IS WHERE IT GOES GOOD TO CONTINUESDR CALA2025070306182Door · no discrepancyBEFORE EACH DEPARTURE, VERIFY AFFECTED DOOR(S) IS CLOSED, LATCHED AND LOCKED PER MEL CARD 52010 MAINTENANCE PROCEDURE STEP A. - FWD CARGO DOOR HAS BEEN OPENED DUE TO LOADING EXTRA BAGS VERIFIED PER MEL CARD 52010 MAINTENANCE PROCEDURE STEP A.SDR CALA2025070306181Slide · no discrepancyDOOR 4R SLIDE PACK REMOVED FOR ACCESS IAW DMC-B787-A-25-66-01-01B-520A-A. RENDER SAFE CHECKLIST FOR DAY ONE 1ST JULY 2025. DOOR 4R SLIDE PACK INSTALLED IAW DMC-B787-A-25-66-01-01B-720A-A. EVACUATION SLIDE RII COMPLETED REF GMM 09-25-05. INSPECTION VISUAL CHECSDR CALA2025070306180Pin · unsecureDOOR 1R EMERGENCY SLIDE PIN HAS COME LOOSE FROM SLIDE. REMOVED DOOR 1R EMERGENCY ESCAPE SLIDE IAW AMM 25-66-01-000-801. STOWED PIN AS REQUIRED AND REINSTALLED SLIDE IAW AMM 25-66-01-400-804. VERIFIED SECURITY AND INSTALLATION OF DOOR 1R ESCAPE SLIDE. REF. GMSDR CALA2025070306172Light · inoperative30 ABC EMER AISLE LIGHT INOPERATIVE. EMERGENCY AISLE LIGHT 30 ABC SECURED INTO PLACE, LENS NOT BROKEN AND LIGHT IS INOPERATIVE. REMOVED AND REPLACED SEAT 30ABC EMERGENCY LIGHT HOUSING IAW IFM 25-22-59. OPS CHECK GOOD.SDR CALA2025070306171Bulb · inoperativeSEAT 28 ABC BIN EMERGENCY LIGHT INOP R&R SEAT 28 ABC. EMERGENCY BULB PER B737 AMM 33-51, OPS CHECK GOOD.SDR HALA20250702204Actuator · faultedETOPS - A/C WONT TAKE FUEL. BITE TEST OF FCMC + FUEL VALVES TEST FAULTS LH FUEL JETTISON VALVE ACTUATOR. REMOVED OF LH FUEL JETTISON VALVE ACTUATOR PER AMM 28-31-51-000-801-A. INSTALLED ACTUATOR PER AMM 28-31-51 OPS CHECK GOOD. OK FOR SERVICE.SDR SWI2025F00813Windshield · crackedUPON ENTERING THE RUNWAY FOR DEPARTURE BOTH FRONT WINDSCREENS CRACKED. (FLIGHT 3825) OPENSDR SWIA20250702001Skin · damagedDURING LIGHTING STRIKE INSPECTION FOUND DAMAGE TO RH ELEVATOR TRAILING EDGE LOWER SKIN COMPLIED WITH REO 601R-55-21-609 REV"A" DATED: 2025-07-01 TEMPORARY DISPOSITION FOR BLENDED/TRIMMED LIGHTNING STRIKE DAMAGE TO RHS ELEVATOR TRAILING EDGE LOWER SKIN AT RIBSDR WX0A2025070232481Light · no test(AIRCRAFT NOT GROUNDED) TC 335100-03-1-001 CABIN EMERGENCY LIGHTING TEST FAILED. REMOVED AND REPLACED EPSU REF WO524847.SDR WX0A2025070232479Megaphone · damaged(AIRCRAFT NOT GROUNDED) ON WAKE UP FOUND FA MEGAPHONE DAMAGED. PIN FOR WAILING TONE BROKEN OFF IN THE RECEPTICLE. REPLACED MEGAPHONE IAW LOPA A2256500I01. OP CHECK GOOD IAW AMM 25-65-51-710-002-A.SDR AALA202507028480Fitting · wornAIRCRAFT IN BASE MAINTENANCE: GIRT BAR APRON WORN ON R1 DOOR SLIDE. REPAIRED GIRT BAR APRON ON R1 DOOR SLIDE. PER AARD 25-66-00-2SDR AALA202507024304Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF, FLIGHT ATTENDANTS CALLED AND SAID THERE WAS A VERY STRONG SMELL IN THE CABIN. CONTINUED TO CLIMB AND LEVEL AT FL260, THE SMELL NEVER WENT AWAY. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SDR AALA202507023269Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS HANDLE OF THE DOOR ON AFT RIGHT LAV IS DIFFICULT TO OPEN. CONFIRMED RIGHT AFT DOOR INTERMITTENT HARD TO OPEN, SEEMS HINGE MAY BE WORN. (OPEN).SDR AALA202507026786Light · detachedAIRCRAFT WAS NOT GROUNDED: THE EMERGENCY LIGHT UNDER SEAT 25C HAS FALLEN TO THE FLOOR. RESECURED EMERGENCY LIGHTS IN 25C. PER AMM 33-50-00.SDR AALA202507021406Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: L1 PASSENGER DOOR GERT BAR MOUNTS HARD TO RELEASE BAR. LUBED L1 DOOR SLIDE CLIPS AND FLOOR BRACKETS, OPERATIONAL CHECK GOOD. PER AMM 25-66-02.SDR AALA202507026496Slide · dislodgedAIRCRAFT WAS GROUNDED: WHEN THE FLIGHT ATTANDENT WENT TO OPEN THE ENTRY DOOR, THE GIRT BAR CAME OUT OF THE BRACKET AND APPEARED THAT THE SLIDE PARTIALLY CAME OUT. REMOVE AND REPLACE L1 DOOR SLIDE. PER J/C 09L20025004. OPERATIONAL CHECK GOOD.SDR IPXA2025070212307Adc · faultedATB, DURING CRUISE @FL300 NAV ADC-PRED W/S DET FAULT. ALSA WEATHER FAIL. TRIED TO RESET IW SYSTEM RESET TABLE\ AOM NO EFFECT. ATB R&R TRANSMITTER RECEIVER UNIT (8SQ) IAW AMM 34-41-51/401. PERFORMED WEATHER RADAR SYSTEM TEST IAW 34-41-00/501 AND PASSED. NO DEFSDR DALA2025070204965Lanyard · out of positionSHIP 699 DOOR 3L WONT ARM. CORRECTIVE ACTION: FOUND LANYARD HOOK CAUGHT IN GIRT BAR STOWED SAME DOOR ARMS NML (7474792)SDR DALA2025070204963Proximity Switch · fodSHIP 6808 4L SLIDE LIGHT IS ILLUMINATED. CORRECTIVE ACTION: REMOVED FOD FROM 4L GIRT BAR PROX SWITCH IAW B757 AMM 25-66. (7306251)SDR DALA2025070204961Plate · corrodedSHIP 652 THE LOWER CONDUCTIVE PLATE IS CORRODED AROUND THE O/B STATIC WICK BASE, ON THE RIGHT AILERON. WORK WITH N.R.600-11. CORRECTIVE ACTION: REMOVED AND INSTALLED NEW AILERON DUE TO CORROSION IAW B757 AMM 27-1121 ACCOMPLISHED AMDS CARD 2700-4133-01. (105729SDR YENA2025070200671A/C Pack · odorFLT#1037, BDL-MCO. "HAD FUMES WHILE ON PACK 1, BOTH WHILE ON ENG AND APU SWITCHING PODEL OFF DISSIPATED FUMES; PERFORMED INFO NOTICE 2017-T015BSECTION B2 DECONTAMINATION LEVEL 2 IAW TSM 05-50-00-810-831-A FOUND APU TO BE THE SOURCE OF ODOR EVENT OIL FOUND ON LSDR SIMA20250701001Light · missingYELLOW EMERGENCY FLOOR LIGHTING STRIP AT 4A IS MISSING. RAR EMERGENCY PHOTOLUMINESCENT FLOOR SRTIP AT 4A IAW ERJ 175 AMM 33-50-21. NO FURTHER DEFECTS NOTED. M PROCEDURES RESTORED. MEL RESTORED.SDR DALA2025070204959Crossbeam · crackedSHIP 3130 CRACK INDICATION FOUND IN HOLE H2 AT CROSSBEAM SPLICING FR16 LH. CORRECTIVE ACTION: COMPLIED WITH ER/A 626864-14AD. (1058074).SDR DALA2025070204958Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND ON HOLE 1 OF THE DOOR STOP FITTING 7 AT FRAME 16 RH SIDE. CORRECTIVE ACTION: REPLACED INTERCOSTAL FITTING LOC. AT LEVEL DOOR STOP #7 ON FR16 RH IN FWD GALLEY AREA. (1057385).SDR FDEA202507011092Floor Panel · crackedMDC FLOOR PANEL 252JFF WITH PUNTURES MDC FLOOR PANEL 252JFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202507011091Floor Panel · crackedMDC FLOOR PANEL 251AFF WITH PUNCTURES MDC FLOOR PANEL 251AFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202507011090Floor Panel · crackedMDC FLOOR PANEL 252SFF WITH PUNCTURES MDC FLOOR PANEL 252SFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025SDR FDEA202507011089Floor Panel · crackedMDC FLOOR PANEL 252HFF WITH PUNCTURES MDC FLOOR PANEL 252HFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15, 2025SDR FDEA202507011088Floor Panel · crackedMDC FLOOR PANEL 251KFF WITH PUNCTURES MDC FLOOR PANEL 251KFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15,2025