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 SWAA2025090999825Seat Track · corrodedCORROSION ON SEAT TRACK RBL 25 AT BS663+19, BS685+7, BS706+8, & BS727A+15. REMOVED AND REPLACED NEW SEAT TRACK FROM BS540 TO BS727B RBL25 IAW SRM 51-40-02-OG-0 AND DWG 144A5300 ID:0001 REV: E.SDR SWAA2025090899801Stub Frame · crackedFSD LOWER STUB FRAME WAS CRACKED AT BS 294.5, RBL 54, WL 208.2. REPAIRED THE STUB FRAME IAW SRM 53-10-15-2R-7, REPAIR 7.SDR SWAA2025090899802Intercostal · crackedFED INTERCOSTAL BETWEEN BS 294.5 - 303.9, STRINGER 16L, WL 216 WAS CRACKED. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-40-05 AND DWG 141A8180 0027 REV C.SDR SWAA2025090899531Floor Panel · pulledFWD FLOOR PANEL 222AF UPPER SKIN HAD AREAS OF PULLED STRANDS. THE FWD FLOOR PANEL 222AF WAS REPAIRED IAW SRM 53-00-50-2R-1-A00939 REPAIR 1.SDR SWAA2025090899532Floor Panel · pulledFLOOR PANEL 241UF UPPER SKIN HAS AREAS OF PULLED STRANDS. THE FLOOR PANEL WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0, AND DWG 146A5810 0054 DUE TO AMOUNT OF ALL DAMAGE.SDR AALA202509057901Plate · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT WING TRAILING EDGE OUTBOARD FLAP UPPER SURFACE PLATE WORN BETWEEN FLAP RIBS 1 AND 2. REPLACED PLATE PER SRM 57-53-11-300-008.SDR SCNA20250903351Frame · cracked87619 NR133: INITIAL INSPECTION: CRACK ON FRAME STA 312 & S-6L AT PASSENGER CABIN EMP 10001944 - SUMMARY: FRAME STA 312 & S-6L AT PASSENGER CABIN WAS REPAIRED PER B737-800 SRM 53-10-07-2R-1 REPAIR 1SDR ASAA2025080860442Stop Fitting · out of limitsL2 DOOR FWD UPPER STOP PIN HOUSING HAS GOUGED. GROUNDED - YES. FOUND STOP FITTING GOUGED OUT OF LIMITS IAW SRM 52-10-90-1A-1. REMOVED STOP FITTING IAW SRM 51-40-02-0G-0. LOCATED & INSTALLED IAW DWG 147A6116 REV B.SDR IPXA2025090273786Bracket · corrodedFORWARD CARGO COMPARTMENT, CENTER CEILING SUPPORT AT FRAME 26 HAS CORROSION. INSTALLED CENTER CEILING SUPPORT AT FRAME 26 FASTENERS P/N: MS20426AD5 (30EA) BATCH: 0004233090, P/N: MS20426AD 3 (36EA) BATCH: 0004410248, P/N: ABS0330-01A (18EA) BATCH: 004416794 I.SDR 2025FA0000618Spring Strut · shearedAIRCRAFT LH MAIN SPRING STRUT SHEARED AT THE FUSELAGE ATTACH POINT. THE SERIAL NUMBER OF THE FAILED STRUT IS 6L85, RETURNED TO SERVICE IN 2017. VISUAL INSPECTION OF THE SPRING STRUT SHOWS THAT THE CRACK HAD BEEN THERE FOR A LONG TIME, EVIDENCED BY IRON OXIDE ASDR SIMA20250808001Fitting · chafedFWD PAX DOOR CUTOUT HAS A CHAFE ON THE UPPER SECTION. (MAJOR REPAIR). UPON FURTHER INVESTIGATION. DAMAGE FOUND TO BE EXTENSIVE AND BEYONDALLOWABLE LIMITS. REMOVED FWD PAX DOOR CUTOUT UPPER SECTION IAW ERJ 175 SRM 51-40-08. DRILLED NEW SERVICEABLE FWD PAX DOOR SDR SIMA20250808002Seal · gougedFWD PAX DOOR SILL AT LWR MIDDLE SECTION HAS MULTIPLE GOUGES (4EA MARKED) (MAJOR REPAIR). RAR FWD PAX DOOR SILL AFT LWR MIDDLE SECTION IAW ERJ 175 SRM 51-40-02.SDR IPXA2025082673697Support · corrodedFORWARD CARGO COMPARTMENT, LEFT CEILING SUPPORT AT FRAME 26 HAS CORROSION. INSTALLED NEW PART CEILING SUPPORT FROM FORWARD CARGO COMPARTMENT, LEFT CEILING SUPPORT AT FRAME 26 IAW A300-600 SRM 51-40-21.SDR JJBA20250827061Bracket · crackedAFTER GUSSET REMOVAL, ANGLE BRACKET FOUND CRACKED BTW FR 20-21 ON CENTER BEAM HAT SECTION AT FR 20-21 ANGLE REMOVED FOR REPLACEMENT. ANGLE BRACKET REPLACED WITH MADE REPAIR PART INLAY FABRICATED. INSTALLED. FLUORESCENT PENETRANT INSPECTION CARRIED OUT ON LOCALSDR JJBA20250827060Gusset · corrodedCENTER GUSSET BTW FR18-24 FOUND CORRODED. CF1 CENTER GUSSET BTW FR18-24 BLENDED AND FOUND OUT OF LIMITS. CF1, CENTER GUSSET BTW FR18-24 REMOVED. CENTER GUSSET BTW FR18-24 REPLACED.SDR JJBA20250827059Angle · corrodedRIGHT INBD FLAP INBD TIP, ONE ANGLE IS CORRODED. RT INBD FLAP INBD TIP, ONE ANGLE BLENDED OUT OF LIMITS. RH INBD FLAP INBD TIPO, ANGLE REMOVED AND REPLACED.SDR JJBA20250827056Shear Tie · crackedSHEAR CLIP ON FR16 BTW STR15R-16R FOUND CRACKED. REMOVED AND REPLACED CF1 SHEAR CLIP ON FR16 BTW STR15R-16R.SDR SWIA2025082500008Seat Track · corrodedAFT END OF R/H ISLE SEAT TRACK CORRODED FR84-85 (C-CHECK RO 08/26/2025)PERFORMED FORK DOUBLER REPAIR FOR AFT END OF R/H ISLE SEAT TRACK FR 84-85 REF ETD2025-170-926515.REPAIR PARTS WEIGH 120 GRAMS THIS DOES NOT EFFECT WEIGHT AND BALANCESDR 3EJA20250825001Controller · faultedCLIMBING THROUGH 4000 FT. OUT OF MYNN AMBER CABIN ALTITUDE MESSAGE ILLUMINATED. AT 10,000 FEET RED CABIN ALTITUDE ILLUMINATED. LITTLE NEEDLE ON PRESSURIZATION NEVER MOVED STAYED AT ZERO. THRU TROUBLE SHOOTING THE SYS REF THE TEXTRON 750 AMM FOUND THE CABIN PRESDR CALA2025082007984Skin · ground damageRAMP REPORTS CONTACT WITH BELT LOADER TO AFT SIDE OF AFR CARGO DOOR CUTOUTUPDATE TO ADD PHOTOS ESC/TOMC REQUEST: PLEASE PROVIDE DAMAGE LENGTH AND WIDTH, VERIFY NO PULLED FASTENERS, PROVIDE A PICTURE OF THE INTERNAL SKIN SHOWING ANY DAMAGE OR VERIFYING NO DAMAGSDR AALA202508191043Elec Connector · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT CONNECTORS UNDER SEAT 3AB IN P1 AND P2 POSITIONS ARE BOTH CRACKED. REMOVE AND REPLACED EMERGENCY LIGHT CONNECTORS IN P1 (AALA202508199567) AND P2 (AALA202508191043) POSITION UNDER SEATS 3AB. PER SWPM 20-61-28.SDR AALA202508199567Elec Connector · crackedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHT CONNECTORS UNDER SEAT 3AB IN P1 AND P2 POSITIONS ARE BOTH CRACKED. REMOVE AND REPLACED EMERGENCY LIGHT CONNECTORS IN P1 (AALA202508199567) AND P2 (AALA202508191043) POSITION UNDER SEATS 3AB. PER SWPM 20-61-28.SDR AALA202508180623Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508183034Stop Fitting · gougedAIRCRAFT IN BASE MAINTENANCE: L1 DOOR STOP FITTING AT BS 344, S7L GOUGED. REPLACED STOP FITTING PER AMM 52-11-01.SDR JJBA20250815037Skin · chafedSKIN FOUND DAMAGE BY CHAFING AT RH PYLON JUNCTION, NEAR ACCESS PANEL 424DB. REPAIR DOUBLER ON RH REAR FUSE I SKIN, BTW FR 67-68 AND BTW STR 7R-9RSDR JJBA20250815036Skin · dentedDENT ON LH FWD FUSE I SKIN, BTW FR 6-7 AND BTW STR 13L-15L UNDER GPU ACCESS DOOR. REPAIR DOUBLER ON LH FWD FUSE II SKIN, BTW FR 6-7 AND AT STR 15L UNDER ACCESS DOOR.SDR SWAA2025081303935Cover · missingCABIN CEILING LIGHT COVER MISSING, OK TO CONTINUE PER MEL 25-10-01. LIGHT OPS CHK GOOD; COVER/LENSE MISSING. INSTALLED CABIN EMERGENCY LIGHT COVER PER AMM 33-51-03.SDR AALA202508137035Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508131134Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508139557Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508134776Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR SWAA2025081299736Unknown · odorRETURN TO GATE FOR RANCID SMELL IN COCKPIT. RAN ENGINES WITH CREW TO 65% N1- ODOR DISSIPATED AND ALL ENGINE INDICATIONS WERE NORMAL IAW AMM 71-00-00 AND AMM 05-51-56.SDR SWAA2025081299944Drain · odorFLIGHT ATT. REPORTS SEWAGE SMELL COMING FROM AFT GALLEY. CLEANED AFT GALLEY DOOR DRAINS IAW AMM38-31-00.SDR SWAA2025081299737Flashlight · no testFWD FLASHLIGHT WILL NOT TEST. R&R FLASHLIGHT BATTERY REF AMM 25-64-00 OPS CHECK GOODSDR SWAA2025081299609Flashlight · no testCREW REPORTS F/A FLASHLIGHT AFT LT SIDE OUTBOARD WILL NOT TEST. R & R AFT F/A FLASHLIGHT BATTERY PACK PER MM 25-64-00 OPS CK OK.SDR SWAA2025081299974Flashlight · no testFLASHLIGHT UNDER FWD F/A SEAT WILL NOT TEST. REPLACED FWD L/H FA FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS TEST GOOD.SDR SWAA2025081299599Girt Bar · damagedFWD ENTRY DOOR GURT BAR HOOK HAS MISSING RIVET. INSTALLED NEW RIVET IN FWD ENTRY GURT BAR HOOK REF SIPSDR SWAA2025081299559Lens · missingEMERGENCY LIGHT COVER MISSING AT SEAT 22 DEF. INSTALLED MISSING EMERGENCY LIGHT LENS PER AMM 33-51-03.SDR SWAA2025081299732Circuit Breaker · trippedPASSENGER CABIN LIGHTING EMERGENCY CHARGER FWD C.B. P18-3 A-11 POPPED. RE-SET PAX CABIN LIGHTING EMERGENCY CHARGER FWD C.B. PER AMM 20-60-01. NO DEFECTS NOTED.SDR SWAA2025081299948Control Unit · faultedLEFT WING TO BODY OVERHEAT LIGHT ILLUMINATED TWICE ON TAXI OUT. R & R COMPARTMENT OVERHEAT DETECTION CONTROL UNIT IN REF TO AMM 26-18-01. NO CURRENT FAULTSSDR DALA2025081206020Oxygen Mask · unwanted deploySHIP 3416 4 MASKS DEPLOYED IN FLIGHT ATTENDANTS CREW REST. CORRECTIVE ACTION: RE-SECURED PER A330 AMM 35-21-44. OK FOR SERVICE. (6181443)SDR DALA2025081206017Frame · damagedSHIP 3415 FRAME C26.1 RH @ P 5.-TOOLING DAMAGE. CORRECTIVE ACTION: REPAIRED PER ERA 628357-14 REV ORIGINAL. (1132899)SDR DALA2025081206016Frame · unsecureSHIP 3415 FRAME C31 THERE IS TOOLING DAMAGE ON THE UNDERSIDE. CORRECTIVE ACTION: REPAIRED PER ERA 628357-14 REV ORIGINAL. (1132893)SDR DALA2025081206014Shear Tie · damagedSHIP 3415 FRAME C31 RH BRACKET LOCATED BETWEEN P5 DAMAGED. CORRECTIVE ACTION: REPLACED BRACKET PER A330 SRM 53-11. (1132897)SDR DALA2025081206012Actuator · usedSHIP 3318 DURING AMDS WC 2561-9403 BLEW ACTUATOR ON DOOR ASSIST ON 1L. R/R DOOR ASSIST ACTUATOR AND SERVICED PER A330 AMM 52-11. OK FOR SERVICE. (7071197)SDR AALA202508122688Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CENTER WING SECTION REAR SPAR MIDSPAN DIAGONAL SUPPORT ANGLE CRACKED AT BS 663. REPLACED DIAGONAL SUPPORT ANGLE PER SRM 57-10-10-01-3.SDR AALA202508123761Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME AT FR 68 AND S8R. REPAIRED FRAME PER EA 365278.SDR CALA2025081207646Fuel Cap · missingFUEL CAP MISSING ON ARRIVAL TOMC HAS BEEN NOTIFIED REFFER LP 5846636 FOR CDL.SDR COEA2025081101819Skin · damagedFLT # 7739, BIL-GTF. HAIL DAMAGE ON LEFT SIDE FLAP CORRECTIVE ACTION: FERRIED TO COE FOR FURTHER EVALUATION. UPON FURTHER REVIEW, THE DAMAGE DISCOVERED ON THE L/H SIDE WING DID NOT WARRANT REPORTING DUE TO BEING SECONDARY STRUCTURE.SDR DALA2025081106002Frame · crackedCRACK INDICATION ON HOLE AT LOWER FRAME AREA FH 43RH. COMPLIED WITH ER/A 627580-14AD.