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 FDEA202510141983Seat Track · wornSEAT TRACK AT STATION 1169 X= -8.5 FOUND CROWN WORN. SEAT TRACK CROWN WAS EVALUATED AND FOUND EXCEEDED LIMITS IAW SRM 53-00-52-1A, FIGURE 101, ALLOWABLE DAMAGE 1. THE SEAT TRACK WAS REPAIRED BY SECTIONAL REPLACEMENT IAW SRM 53-00-52-2R FIGURE 201, REPAIR 1. SDR FDEA202510141982Seat Track · wornSEAT TRACK AT STATION 1169 X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 1169 X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL REPLACEMENT SDR FDEA202510141981Door Frame · crackedLEFT 3 AFT DOOR JAME LOWER WEB AT STATION 1310 FOUND CRACKED. CANIN-LEFT 3 AFT DOOR JAME LOWER WEB AT STATION 1310 CRACKED REPAIR CARRIED OUT AS PER MD-11 SRM 53-40-15-2R FIGURE 201 REPAIR 3. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100.SDR FDEA202510141980Hinge Arm · delaminatedRH WING - #4 SPOILER INBD HINGE ARM INBD SIDE AND OTBD HIINGE ARM OUTBD SIDE DELAMINATED. 1.80MM*40MM*1.55MM 2.90MM*40MM*1.45MM. COMPLIED WITH EA 6-5750-T0319441 P2. TITLE: WINGS - FLIGHT SURFACES - RH #4 SPOILER LOWER SKIN REPAIR - OUTSIDE CENTER HINGE ASDR FDEA202510141979Hinge Arm · delaminatedRH WING - #3 SPOILER INBD HINGE ARM INBD SIDE AND OUTBD HINGE ARM OUTBD SIDE DELAMINATED .1.80MM*15MM*0.92MM 2.30MM*25MM*1.09MM 3.25MM*18MM*0.96MMSDR FDEA202510141978Hinge Arm · delaminatedLH WING - NR 3 SPOILER OUTBD HINGE ARM OUTBD SIDE AND INBD HINGE ARM INBD SIDE DELAMINATED. 1.65MM, 820MM, 81.38MM, 2.100, MM, 20MM, 1.73MM. COMPLIED WITH EA 6-5750-T0385295 P1. REPAIRED THE LH WING #3 SPOILER OTBD HINGE ARM OTBD SIDE & INBD HINGE ARM OTBD SDR FDEA202510141977Hinge Arm · delaminatedLEFT WNG - #5 SPOILER OUTBD HINGE ARM OUTBD SIDE DELAMINATED. 80MM*20MM*1.62MM COMPLIED WITH EA 6-5750-T0385306 P1. TITLE: WINGS - FLIGHT SURFACES - LH #5 SPOILER CENTER HINGE ARM OUTSIDE SURFACE DELAMINATION. REPAIRED THE LH WING #5 SPOILER OUTBD HINGE ASDR VNAA20251014010Seat Track · corrodedLBL 9 SEAT RAIL IS CORRODED BETWEEN FS 485 AND FS 581. CORRECTIVE ACTION: REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A01.SDR VNAA20251014009Seat Track · corrodedLBL 9 SEAT RAIL IS CORRODED BETWEEN FS 581 AND FS 677. REMOVED AND REPLACED CORRODED LBL9 SEAT RAIL BETWEEN FS 581.00 & FS 677.00 WITH NEW SERVICEABLE SEAT RAIL (PN SH670-33425-3) IAW CRJ700 AMM 53-00-49-400-801-A01.SDR ABXA20251014268Beam · corrodedTHIS AIRCRAFT IS CURRENTLY UNDERGOING AN A-CHK IN CVG, AND MAINTENANCE FOUND THE RIGHT WING FIXED L/E NOSE BEAM AT OSS 500 TO BE BADLY CORRODED. THE CORROSION WAS REMOVED BY BLENDING, AND THE BLEND WAS BEYOND THE ALLOWABLE LIMIT GIVEN IN REF /A/. THERE IS NO RSDR VNAA20251014008Seat Track · corrodedLBL 9 SEAT RAIL IS CORRODED BETWEEN FS 677 AND FS 708. INSTALLED NEW SERVICEABLE SEAT TRACK (P/N SH670-33400-961) AT FS677.00 TO FS708.00 IAW CRJ-700 AMM 53-00-49-400-801-A01SDR VNAA20251014007Seat Track · corrodedDISCREPANCY: RBL 9 SEAT RAIL IS CORRODED BETWEEN FS 581 AND FS 677. CORRECTIVE ACTION: REMOVED CORRODED SEAT RAIL. INSTALLED NEW SEAT TRACK (P/N:SH670-33425-951) AT RBL9 FS 581-FS 677 IAW CRJ700 AMM TASK 53-00-49-400-801-A01SDR VNAA20251014006Seat Track · corrodedRBL 9 SEAT RAIL IS CORRODED BETWEEN FS 485 AND FS 581. REMOVED AND REPLACED SEAT RAIL IAW CRJ-700 AMM 53-00-49-400-801-A01.SDR DALA2025101407514Support · corrodedCORROSION ON SIDE PANEL SUPPORT STA 1460 FROM STR 27/23 LH AT AFT CARGO COMPARTMENT. CORRECTIVE ACTION: SUMMARY OF NRC 00387, CORROSION LEVEL 2, SIDE PANEL SUPPORT STA 1460 FROM STR 27/23 LH AT AFT CARGO COMPARTMENT WAS REPLACED PER B757-200 SRM 51-40-02-0G PASDR VNAA2025F00022Retainer · dentedRT SIDE SEAT RAIL TRIM RETAINER IS DENTED BETWEEN FS 923 AND FS 939. REPAIRED TRIM RETAINER IAW MHIRJ REO 670-53-51-352 REV-- DATED 2025-07-01.SDR VNAA20251014004Seat Track · corrodedSIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 785.15 AND FS 838. REMOVED AND REPLACED L/H SIDE SEAT RAIL BETWEEN FS 785.15 AND FS 838.00 IAW CRJ 700 AMM 53-00-49-400-801 (CONFIG A01)SDR KCSA202510141196Floor Support · corrodedMAIN DECK CARGO FLOOR SUPPORT FITTING @ BS 1410 LBL 6.5 HAS EVIDENCE OF DAMAGE.SDR KCSA202510141195Floor Support · corrodedMAIN DECK FLOOR SUPPORT FITTING @ STA 1390 LBL 6.5 HAS EVIDENCE OF DAMAGESDR KCSA202510141194Floor Support · corrodedMAIN DECK FLOOR SUPPORT FITTING @ STA 1370 LBL 6.5 HAS EVIDENCE OF DAMAGE.SDR DALA2025101407512Battery Pack · inoperativeEMERGENCY EXIT LIGHTS INOP ABOVE SEAT ROWS 3AB,11ABC,15ABC. REPLACED BATTERY PACK REF.B737 AMM 33-51. LIGHTS OP NML.SDR 2025FA0000712Bracket · brokenFUEL FLOW TRANSDUCER BRACKET HAS DEVELOPED MAJOR CRACK ON THE BOTTOM SIDE OF THE BRACKET.SDR 2025FA0000711Attach Bracket · brokenFUEL FLOW TRANSDUCER BRACKET HAS DEVELOPED MAJOR CRACK ON THE BOTTOM SIDE OF THE BRACKET.SDR VNAA20251014003Seat Track · corrodedSIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 677 AND FS 708. REMOVED AND INSTALLED NEW SERVICEABLE LT SIDE SEAT RAIL AT STGR 15L FS 677-708 IAW AMM 53-00-49-400-801SDR VNAA20251014002Seat Track · corrodedSIDE SEAT RAIL AT STGR 15L IS CORRODED BETWEEN FS 572 AND FS 661. REMOVED AND REPLACED SERVICEABLE LH SIDE SEAT RAIL P/N SH670-33558-3, REMOVED IAW AMM 53-00-49-000-801, INSTALLED IAW AMM 53-00-49-400-801-A01SDR KCSA202510141193Floor Support · corrodedFLOOR SUPPORT FITTING @ STA 1601 APPROX RBL 92 HAS EVIDENCE OF CORROSIONSDR DALA2025101407501Wire · damagedSHIP 3412 AISLE EMERGENCY LIGHTS INOP AT 41AB AND 34AB. REPAIRED WIRING PER A330 AMM 33-51. (7832308)SDR DALA2025101407500Bracket · damagedTOOLING DAMAGE ON BRACKET AT FASTENERS FWD SIDE OF FRAME 26 @ P'6. CORRECTIVE ACTION: REPAIRED PER ERA 628177-14 REV. ORIG. (1251281)SDR DALA2025101407502Skin · gougedSHIP 3314 FUSELAGE SKIN FOUND GOUGE ON FR 35A STGR 23 RH TO STGR 24 RH. CORRECTIVE ACTION: REPAIRED PER A330 SRM 53-21-11-283-005. OK FOR SERVICE. (1251305)SDR DALA2025101407499Flap · damagedSHIP 3129 BIRD STRIKE ON LEADING EDGE OF RT FLAP. HOLE IN LEADING EDGE OF FLAP. CORRECTIVE ACTION: REPAIRED PER ERA 629909-14. (8151036)SDR DALA2025101407496Arming Lever · bindingSHIP 3128 ARMING LEVER ON DOOR 1R IS VERY HARD TO MOVE. TOOK 2 TRIES TO GET SLIDE TO ARM. CORRECTIVE ACTION: INSPECTED AND OPERATED HANDLE PER A319 AMM 52-11 NO DEFECTS FOUND A/C OK TO CONT. (8016982)SDR KCSA202510141192Floor Support · corrodedFLOOR SUPPORT FITTING @ STA 1748 APPROX RBL 92 HAS EVIDENCE OF CORROSIONSDR 2025F00241Blade · failed inspGE LAFAYETTE MRO PART 145 IS REPORTING QUALITY ESCAPE ON ESN 603796. PER CHECK INSPECTION PROCEDURE: IF THE PARTS OR SUB SYSTEMS ARE TRANSFERRED TO ANOTHER ENGINE, THEY MUST BE INSPECTED PER ESM CONSISTENT TO THE LEVEL OF DISASSEMBLY REACHED DURING THE MAINTENSDR KCSA202510141191Floor Support · corrodedFLOOR SUPPORT FITTING @ STA 1727 APPROX RBL 92 HAS EVIDENCE OF CORROSIONSDR KCSA202510141190Floor Support · corrodedFLOOR SUPPORT FITTING @ STA 1643 APPROX RBL 92 HAS EVIDENCE OF CORROSIONSDR SWIA2025101375776Skin · corrodedCORROSION FOUND ON SKIN @ R1 DOOR SKIN CUTOUT 2 INCHES BELOW LWR EDGE (C-CHECK RO 04/17/2026)BLENDED OUT CORROSION IN DICREPANT AREA. AREA WAS BLESSED WITHIN LIMITS AS PER MHIRJ REO 690-53-21-2046 REV. -- DATED: 2025-11-04. COMPLIED WITH ALL STEPS OF REO. SEESDR SPAA2025021013001Battery · inoperativeEMERGENCY FLASHLIGHT IN FORWARD GALLEY LED NOT FLASHINGSDR KCSA202601211002Sign · damagedFOUND L1 EMERGENCY EXIT SIGN DAMAGEDSDR SWI2026F00026Vane · chafedCHAFING ON RT INBD FLAP OTBD FLAP VANE ACTUATOR BODY. REPAIRED RH INBD FLAP OTBD FLAP VANE ACTUATOR BODY IAW REO 601R-57-52-2533 REV.-.SDR SWIA20260105013Vane · chafedLEFT INBD FLAP VANE LEADING EDGE IS CHAFED IN MULTIPLE LOCATIONS. LT INBOARD FLAP VANE LEADING EDGE 2 EA. AREAS BLENDED AND REPAIRED TO BE WITHIN LIMITS. REF REO 601R-57-52-004, REV -D, 2012-12-19. 1 EA. BLEND ON SKIN PANEL 601R14303-51 FOUND TO BE OUT OF LIMISDR 3EJA20251223001Transducer · failedIMMEDIATELY RECEIVED THE AMBER MESSAGE “WING BLEED LEAK R” FOLLOWED BY A CYAN MESSAGE “INBD WING A/I COLD R”. R & R INBD RIGHT WING TEMP. TRANSDUCER. OPS CHECK GOOD.SDR SWI2025F01677Crossbeam · damagedCROSSBEAM UPPER FLANGE EXFOLIATED AROUND FLOORBOARD ANCHOR NUT. FS333 APPROX. RBL 18 (C-CHECK RO 11/30/2025)REPAIRED CROSSBEAM UPPER FLANGE FS333.00 APPROX RBL18 REF. REO 670-53-21-2729, REV: --, DATED 2025-11-07. COMPLIED WITH ALL THE STEPS OF TASK CARD 51SDR SWIA202512010013Bulkhead · corrodedEXFOLIATED CORROSION FOUND AROUND FASTENER ON 202 BULKHEAD, FS235, AFT FACE LH SIDE. (C-CHECK RO 11/30/2025)REPAIRED 202 BULKHEAD AT FS235 AFT FACE LH SIDE REF-CRJ-700 REO 670-53-11-2196 REV -- DATE 2025-10-17 AND REO 670-53-11-2197 REV -- DATE 2025-10-15, LESDR VNAA202511270008Hinge · corrodedAFTER HINGE FITTINGS REMOVAL IN REF NRC 0034 CORROSION IN UPPER HINGE WAS FOUND. UPPER HINGE OF TOILET SERVICE DOOR 196ER WAS REPLACED PER CRJ-700 SRM 51-41-02-001-001-A01SDR SWAA2025111224126Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 561CB TRAILING EDGE HOLES AT LT WING. REPAIRED ACCESS PANEL 561CB IAW B737-700 SRM 51-70-04-<BR>2R-10 REPAIR 10.SDR SWAA2025111224127Access Panel · damagedELONGATED HOLE ON ACCESS PANEL 561BB TRAILING EDGE HOLES AT LT WING . REPAIRED ACCESS PANEL 561BB TRAILING EDGE HOLES AT LT WING IAW B737-700 SRM 51-70-04-2R-10 REPAIR 10.SDR SWAA2025111124040Web · corrodedCORROSION ON AFT CARGO DOOR LOWER SILL WEB AT BS 794 - 798, RBL 22.SDR CALA2025111011071Web · corrodedKEEL BEAM TRUSS WEB WAS FOUND WITH SPOTS OF CORROSION AFTER CLEANING AT APPROX BS 548, 551, 555,557.5, AND 560.6. REPAIRED KEEL BEAM TRUSS WEB PER SRM 53-40-12-2R-1.SDR SWAA2025110724039Rib · crackedLEFT HORIZONTAL STAB L/E HAS CRACKED RIB AT HSS 105.26. REMOVED AND REPLACED THE RIB IAW SRM 51-40-02, & DWG 186A1001, REV A.SDR SWI2025F01515Beam · corrodedAFT WET AREA FLOOR STRUCTURE LT INBOARD BEAM AT FR 87 HAS CORROSION. REMOVED AND REPLACED LT INBOARD BEAM AT FR 87. IAW SRM 51-40-08.SDR SWIA20251107003Seat Track · gougedRT INBOARD SEAT TRACK FR 74-84 HAS GOUGES IN 11 LOCATIONS. REMOVED AND REPLACED RT INBD SEAT TRACK IAW SRM 51-40-08.