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 AALA202507027102Battery · no testAIRCRAFT WAS GROUNDED: FORWARD LEFT SLIDE IS FAILING THE EMERGENCY POWER SUPPLY UNIT SYSTEM TEST. MAINTENANCE REPLACED THE L1 DOOR SLIDE ASSEMBLY PER TASK CARD 26L00025010 (AALA202507025869). IN ADDITION MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (ASDR AALA202507020810Power Supply · no testAIRCRAFT WAS GROUNDED: FORWARD LEFT SLIDE IS FAILING THE EMERGENCY POWER SUPPLY UNIT SYSTEM TEST. MAINTENANCE REPLACED THE L1 DOOR SLIDE ASSEMBLY PER TASK CARD 26L00025010 (AALA202507025869). IN ADDITION MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (ASDR AALA202507025869Slide · no testAIRCRAFT WAS GROUNDED: FORWARD LEFT SLIDE IS FAILING THE EMERGENCY POWER SUPPLY UNIT SYSTEM TEST. MAINTENANCE REPLACED THE L1 DOOR SLIDE ASSEMBLY PER TASK CARD 26L00025010 (AALA202507025869). IN ADDITION MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT 10WL (ASDR EE4Y2025070222617Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-E5316-0003, UPPER FUSELAGE PASSENGER CABIN FR 16 LHS AT DOOR STOP FITTING # 1 LOWER INBOARD OPEN HOLE WITH CRACK INDICATION. PÉRFORMED FREEZE PLUG FASTENER HOLE REPAIR FR16 LHS STOP FITTING # 1 LOWER INBD HOLE ASDR N6WA2025070201Bulkhead Web · corrodedLH LOWER WEB AT FS280 IS CORRODED. REMOVED AND REPLACED THE LH LOWER WEB AT FS280 IAW CRJ SRM51-42-06.SDR EE4Y2025070222616Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-53-260-003, UPPER FUSELAGE FR68 RHS AT DOOR STOP FITTING # 1 LOWER OUTBOARD FASTENER HOLE WITH CRACK INDICATION. PERFORMED FREEZE PLUG FASTENER HOLE REPAIR AND OVERSIZE BOLT INSTALLATION AT FR68 STOP FITTING # 1SDR FDEA202507021098Floor Panel · crackedMAIN DECK CARGO FLOOR PANEL P/N:152W8302-33 CRACKED AT STA1010 LBL85 DAMAGE SIZE:L=3.5" DAMAGE OUT OF ALLOWABLE LIMIT AS PER B777 SRM 53-00-50-1A ALLOWABLE DAMAGE 1 FIGURE 101-106 REV 47.6 AND REPAIRED AS PER B777 SRM 53-00-50-2R REPAIR 1 FIGURE 201-20SDR FDEA202507021097Frame · crackedCENTER WING BOX - INSPECTION OF REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 LH SIDE, FASTENER "F" HOLE FOUND CRACK SIGNAL COMPLIED WITH EA: 6-5710-T0383930 P1. TITLE: WINGS - BASIC WING STRUCTURE - FR47LH REAR SPAR HOLE C AND F CRACK REPAIR -SDR FDEA202507021096Frame · crackedMAIN DECK - FUSELAGE FRAME AT FR22 BETWEEN STGR9RH AND STGR10RH DEFORMED REPLACED THE DEFORMED FRAME AND COUPLING AT MAIN DECK FUSELAGE FRAME AT FR22 BETWEEN STGR9RH AND STGR12RH WITH FABRICATED PARTS PER A300-600F SRM51-40-21 AND DWG: A53771694 (ISSUE.B) ANSDR FDEA202507021095Frame · crackedCENTER WING BOX - INSPECTION OF REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 RH SIDE, FASTENER "C" HOLE FOUND CRACK SIGNAL COMPLIED WITH EA: 6-5710-T0383894 P1. TITLE: WINGS - BASIC WING STRUCTURE - FR47RH REAR SPAR HOLE C CRACK REPAIR - SB A3SDR FDEA202507021094Frame · crackedCENTER WING BOX - INSPECTION OF REAR SPAR AND BOTTOM PANEL AT JUNCTION WITH FUSELAGE FR47 LH SIDE, FASTENER "C" HOLE FOUND CRACK SIGNAL COMPLIED WITH EA: 6-5710-T0383930 P1. TITLE: WINGS - BASIC WING STRUCTURE - FR47LH REAR SPAR HOLE C AND F CRACK REPAIR -SDR FDEA202507021093Door · crackedMAIN DECK CARGO DOOR UPR EDGE AT PT1 BETWEEN FR23 AND FR24 FOUND CRACK SIGNAL ON 3EA FASTENER HOLES COMPLIED WITH EA: 6-5230-T0384017 P1. TITLE: DOORS - CARGO DOOR/HYD SYS - CRACKED HOLES ON MAIN DECK CARGO DOOR UPPER LONGERON. REPAIRED THE MAIN DECK CARGOSDR YENA2025070200670Outflow Valve · faultedFLT#2251, BOS-RDU. "CAB ALT AND RATE FLUCTUATED CONSTANLY DURING ALL PHASES OF FLIGHT CAB ALT +/- 600FT WITH RATE +/- 1800 FT P/MIN AT FL 360 UPON LANDING CAB ALT BECAME -2000 FT AND THE OUTFLOW VALVE NEVER OPENED HAD TO MANUALLY DEPRESS THE CABIN AT GATE BEFOSDR EE4Y2025070222615Frame · crackedDURING ACCOMPLISHMENT OF THE ALLEGIANT TASK A32X-E5311-0018, UPPER FUSELAGE FR16 RHS DOUBLE JOGGLE UPPER AREA HOLES POSITIONS # 7, #A, #B AND #C WITH CRACK INDICATION WERE FOUND. PERFORMED TEMPORARY FASTENER HOLES # 7, #A, #B AND #C BUSHES REPAIR AT FR 16 RHSSDR 2DYA202507020157Panel · missingR/H PYLON PANEL; # 433FR MISSING ON POST FLIGHT INSPECTION.SDR JR2R20250702065Screw · stuckL/H WING O/B AFT FLAP LOWER SKIN HAS A STUCK SCREW.SDR IXXA20250702002Skin · gouged#1 SLAT I/B SURFACE GOUGEDSDR KCSA202507021108Bulkhead Web · crackedL/H BODY LANDING GEAR WHEEL WELL BULKHEAD HAS A CRACK IN WEB AT STA 1480 WL 100 APPROXSDR 2025FA0000444Bellcrank · corrodedFOUND CORROSION ON FRONT SIDE OF BELLCRANK WELDMENT WHERE TWO TUBES INTERSECT, THIS END BUTTED UP TO WING SPAR. BELLCRANK THAT CONNECTS TO GEAR ACTUATOR AND REACTOIN LINK SIDE BRACE THAT LOCKS GEAR DOWN WHEN OVER CENTERED. NOT VISIBLE FROM AFT EXPOSED END OF BSDR SWI2025F01476Slat Track · corrodedLEFT WING SLAT TRACK 3-3 HAS CORROSION AS MARKED (C-CHECK RO 11/01/2025)COMPLIED WITH REO 690-57-42-1253 REV-- DATED: 2025-07-16 STEP 1-7 NO ADJUSTMENT NECESSARY AND ENSURED SLAT RIGGING REQUIREMENT ARE MET. REF CRJ900 AMM 27-81-43-820-802-A01 ,REF CRJ900 AMMSDR SWI2025F01475Slat Track · gougedLEFT WING SLAT TRACK 1-1 GOUGED AS MARKED (C-CHECK RO 11/01/2025)REMOVED DAMAGED LEFT WING SLAT TRACK 1-1 REF. CRJ 900 SRM 51-12-00-001-001-A01, COMPLIED WITH WITH REO 690-57-42-1252 REV-- DATED: 2025-07-16 STEPS 1 TO 7, OPS TEST OF FLAPS/SLATS GOOD. COMPLY SDR SWI2025F01474Slat Track · gougedRIGHT WING SLAT TRACK 3-3 GOUGED AS MARKED (C-CHECK RO 11/01/2025) REMOVED GOUGES FROM RH WING SLAT TRACK 3-3 REF. CRJ 900 SRM 51-12-00-001-001-A01. AND PERFORMED REPAIR PER REO 690-57-42-1255 REV-- DATED: 2025-07-16. ALL CHECKS GOOD. COMPLIED WITH TASK CARDSDR SWI2025F01473Rod · dentedRH INBOARD FLAP, INBOARD VANE ACTUATOR ROD HAS INDENT. (C-CHECK RO 11/01/2025)REMOVED DAMAGE ON RH IB FLAP -IB VANE ACTUATOR ROD TO SMOOTH CONTOUR PER REO 670-57-52-257 REV B DATED 2024-10-17 AND DWG CC670-14303 REV B. ALL STEPS OF REO COMPLIED WITH. ALL CHSDR SWI2025F01472Rod · dentedRH INBOARD FLAP, SECOND TO INBOARD VANE ACTUATOR ROD HAS INDENT. (C-CHECK RO 11/01/2025)REMOVED DAMAGE FROM RH INBOARD FLAP, SECOND TO INBOARD VANE ACTUATOR ROD, REF, CRJ-900, SRM 51-12-00-001-001-A01, AND PERFORMED REPAIRS PER REO 670-57-52-257 REV -B DATED SDR SWI2025F01499Rod · dentedRH INBOARD FLAP, OUTBOARD VANE ACTUATOR ROD HAS INDENT. (C-CHECK RO 11/01/2025) REMOVED INDENT ON RH INBOARD FLAP, OUTBOARD VANE ACTUATOR ROD IAW CRJ900 SRM 51-12-00-001-001-A01 AND PERFORMED REPAIR PER REO 670-57-52-257 REV B DATED 2024-10-17. ALL CHECKS GOSDR SWI2025F01498Slat Track · damagedLEFT WING SLAT TRACK 1-2 PITTED ON CONTACT SURFACE AS MARKED (C-CHECK RO 11/01/2025)REMOVED DAMAGE ON LEFT WING SLAT TRACK 1-2 ON CONTACT SURFACE REF CRJ900 SRM 51-21-06-001-001-A01, COMPLIED WITH REO 690-57-42-1265 REV -- DATED 2025-07-22 STEPS 1-7.OPS TESTSDR SWIA202511030701Bracket · corrodedRIGHT MAIN LANDING GEAR WHEEL WELL, TIRE BURST COVER MOUNTING "L" BRACKET IS CORRODED. HN00250973 (C-CHECK RO 11/01/2025)MLG ELECTRICAL/HYDRAULIC PROTECTIVE COVER ANGLE P/N CC670-10338-1 ON THE R/H WING'S REAR SPAR HAS MULTIPLE AREAS OF PITTING ACROSS THSDR AALA202509020866Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION INTERNAL STRUCTURE ANGLE FR71 AT DOOR CUT OUT IN THS COMPARMENT CORRODED AREA IS L=2.917 IN W=0.828 IN D= 0.015 IN. REPLACED ANGLE LOC FR71 AT DOOR CUT OUT IN THS COMPARMENT IAW A319 SRM 51-42-11-801, A319 SRM 51-72-11-SDR AALA202508291665Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON OPEN HOLE ON CENTER WING BOX FR36 FRONT SPAR VERTICAL STRINGER ZONE 2, CRACK DIRECTION AT 12 O CLOCK, D= 0.110 INCH. MAINTENANCE REPLACED STIFFENER LOCATED ON FR1 (Z-169) FWD FACE FWD PRESSURE BULKHEAD IASDR AALA202508299397Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS INDICATION FOUND ON OPEN HOLE ON CENTER WING BOX FR36 FRONT SPAR VERTICAL STRINGER 2 ZONE 1,CRACKS DIRECTION AT 11 O CLOCK, 3 O CLOCK AND 5 O CLOCK , D= 0.105 INCH. MAINTENANCE ACCOMPLISHED PERMANENT REPAIR (PARTIAL REPLACESDR AALA202508266025Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS INDICATION FOUND ON OPEN HOLE ON CENTER WING BOX FR36 FRONT SPAR VERTICAL STRINGER 3 ZONE 1 ,D= 0.115 INCH. MAINTENANCE ACCOMPLISHED PERMANENT REPAIR (PARTIAL REPLACEMENT) ON FLOOR BEAM Y254 LOC. AT LEVEL FR36 FLOOR STRUCTSDR AALA202508269578Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKS INDICATION FOUND ON OPEN HOLE ON CENTER WING BOX FR36 FRONT SPAR VERTICAL STRINGER 4 ZONE 1, CRACKS DIRECTION AT 12 O CLOCK, 5 O CLOC K AND 3 O CLOCK , D= 0.112 INCH. MAINTENANCE ACCOMPLISHED PERMANENT REPAIR (PARTIAL REPLASDR IPXA2025080816542Skin · damagedLH WING-ZONE500: LH WINGTIP LWR AFT CORNER DAMAGED. VERIFIED REPAIR ACCOMPLISHED IAW EO-94606-REQ1 AND VT-MAE EA 300-5730-27-A4061, REV.-.SDR SWAA2025081187179Keelbeam · crackedCRACK KEEL BEAM LOCATED BS 727 TO 727A AND S-28R AT AFT CARGO COMPARTMENT 2025-417115<[01] TOOL USED ON ITEM 5 AND 6: EDDY CURRENT FLAW DETECTOR; P/N: NORTEC 600D; S/N: 210136503; DUE DATE: 24-JUL-25;[02] TOOL USED RADIOMETER/PHOTOMETER KIT P/N: XRP -3000 ; S/SDR SWAA2025081187419Light · burnedBURNED EXIT LIGHT ASSY AT G4 (1EA) AFT GALLEY AREA. REPLACED EXIT LIGHT ASSY AT G4 (1EA) AFT GALLEY ARE IAW AMM 33-51-01-960-801 STEP 2.C.(1)(3) AND (4) FOR OPERATIONAL TEST SEE TTG8Q00CWKNC STEP 60 AND TTG8Q013GD1U.SDR SWAA2025081187412Intercostal · crackedCRACK WEB INTERCOSTAL LOCATED BETWEEN STA294.5 TO STA303.9 AND STR16L AT FWD GALLEY AREA. REPLACED WEB-INTERCOSTAL LOCATED BETWEEN STA294.5 TO STA303.9 AND STR16L AT FWD GALLEY AREA IAW SRM 51-40-02; SRM 51-10-02 AND DWG 141A8180 SHEET 27 AND 28 REV C.SDR SWAA2025081187415Web · crackedCRACK ON WEB LOCATED AT LEVEL ORSS 268 DEFLECTION CONTROL RIB AREA AT LT WING. REPLACED WEB LOCATED AT LEVEL ORSS 268 DEFLECTION CONTROL RIB AREA AT LT WING IAW SRM- 51-40-02-0G-0 AND DWG # 115A2512 SHEET 14 REV A.SDR SWAA2025081187416Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT LEVEL ORSS 265 DEFLECTION CONTROL RIB AREA AT LT WING. REPLACED SUPPORT ANGLE LOCATED AT LEVEL ORSS 265 DEFLECTION CONTROL RIB AREA AT LT WING IAW SRM-51-40-02 AND DWG 115A2930 SHEET 7 REV-.SDR SWAA2025081187414Tie Clip · crackedCRACK TIE CLIP LOCATED BS 277 AND S10R PASSENGER CABIN. REPLACED TIE CLIP LOCATED STA277 AND STR10R PASSENGER CABIN IAW SRM 51-40-02 AND DWG 141A1110 SHEET 18 REV-.SDR SWAA2025081187413Rib · crackedCRACK ACCESS PANEL 341B RIB 151.75 AT RT HORIZONTAL STABILIZER. REPLACED ACCESS PANEL 341B RIB 151.75 AT RT HORIZONTAL STABILIZER IAW SRM 51-40-02; SRM 51-10-05 ITEM 9 AND DWG 186A1001; SHEET 19; REV -.SDR SWAA2025081187405Access Panel · debondedDEBONDED SEAL LOCATED ACCESS PANELS 632KB 632JB AT RT WING. INSTALLED SEAL LOCATED ACCESS PANELS 632KB 632JB AT RT WING IAW B737-700 AMM 28-11-11-900-801.SDR SWAA2025081187420Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED AT LEVEL ORSS 264 DEFLECTION CONTROL RIB AREA AT RT WING. REPLACED SUPPORT ANGLE LOCATED AT LEVEL ORSS 264 DEFLECTION CONTROL RIB AREA AT RT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 115A2930 SHEET 8 REV -.SDR SIMA20250701003Shear Tie · corrodedSHEAR CLIP AT FR 88 STGR 28R-29R CORRODED. R & R SHEAR CLIP AT FR 88 BTW STGR 28R-29R IAW ERJ 175 SRM 51-40-08.SDR SWAA2025073087176Angle · crackedCRACK ON ANGLE TRAILING EDGE LOCATED AREA DEFLECTION CONTROL RIB ORSS278 RT WING. REPLACED ANGLE AND FASTENERS TRAILING EDGE LOCATED AREA DEFLECTION CONTROL RIB ORSS278 RT WING IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 115A6200; SHEET 11; REV B.SDR SWAA2025072987350Seat Track · corrodedCORROSION FOUND ON PASSENGER SEAT TRACK AT LBL 25 BS 360+10 ON CROWN AND WELL, BS 400 ON CROWN, BS 480+13 ON CROWN AND WELL, BS 500A+6 ON WELL; BS 500B+11 ON CROWN AND WELL AT WL 208 ACCOMPLISHED ON CUSTOMER CARDS TTG8Q013JXQP AND TTG8Q013JWGG.SDR SWAA2025072987175Plate · crackedCRACK ON CORRUGATED PLATE TRAILING EDGE LOCATED ORSS327 AT RT WING. REPLACED CORRUGATED PLATE AND FASTENERS TRAILING EDGE LOCATED ORSS327 AT RT WING IAW SRM 51-40-02; SRM 51-10-02 ITEM 9, AND DWG 115A3700 SHEET: 41 REV -.SDR AALA202507280422Bushing · migratedAIRCRAFT IN BASE MAINTENANCE: MIGRATED PLAIN BUSHING HINGE FITTING 1 O/B ON LH ELEVATOR. MAINTENANCE REPAIRED O/B LUG OF HINGE FITTING #1 AT LH ELEVATOR AND REPLACED BUSHING IAW A319 SRM 55-26-41-300-010.SDR SWAA2025072487030Panel · delaminatedLEFT WING LEADING EDGE PANEL 521DB; CORNER DELAMINATED AT ANTI-ICE DUCT CUTTOUT. REPAIRED CORNER DAMAGE TO PANEL 521DB IAW SRM 57-41-01-1A-1; SRM 51-70-08-0G-0 AND SRM 51-70-14-2R-3.SDR SWAA2025072487032Panel · delaminatedLEFT WING LEADING EDGE PANEL 521KB; 2 EACH CORNERS DELAMINATED ON FORWARD EDGE. REPAIRED LEFT WING LEADING EDGE PANEL 521KB 2EA CORNERS DELAMINATED IAW SRM 51-70-04-2R-13.SDR 2025FA0000518Actuator · failedTHE FLAP DRIVE ACTUATOR FAILED DURING THE RIGGING PROCESS.