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 DALA2026011200255Skin · abnormalDTE, DURING M2 WHILE INSPECTING IAW JIC 5330-3013, TWO EXISTING REWORKS WERE FOUND IN EXTERNAL LOWER SKIN AT FR66 BETWEEN S42R AND S42L. PER SECTION DTE OF 627650-14 THE REPAIR OF SECTION I IS LIMITED TO 6 MONTHS (180 DAYS) FROM SECTION I (15JUL25). ADDITIOSDR SWI2025F01856Door · gougedFORWARD, UPPER CORNER OF SERVICE DOOR SURROUND FOUND TO BE DAMGED. BLENDED GOUGE AREA AT UPPER FWD CORNER OF THE FUSE SERVICE DOOR APERTURE MEASURING 0.75" L X 0.187"W X 0.045" MAX D, DAMAGE LOCATED AT FS319.70, S9R-S10R. COMPLIED WITH REO601R-53-21-3606, REVSDR SWI2025F01855Door · damagedFORWARD, UPPER CORNER OF SERVICE DOOR FOUND TO BE DAMAGED. DAMAGE DEFORMED AREA ON OUTER DOUBLER LOCATED BETWEEN FS320.680-FS328.100 AT UPPER FORWARD CORNER OF SERVICE DOOR, AFTER DRESS BACK OUTER DOUBLER HAS A 0.035" MAX DEFLECTION REMAINING WITH MATING OUTERSDR SWIA202512220715Skin · dentedRUDDER HAS A DENT LOCATED AT APPROXIMATELY RS69.00 .25" FROM RIB 4. COMPLIED WITH TEMP REPAIR PER REO 601R-55-41-290 DATED 2024-06-05. TEMORARY DISPOSITION FOR DENT TO RH SKIN OF RUDDER BETWEEN RS66.758 AND RS 72.788 DUE TO HAIL. IS VALID FOR 3275 FLIGHT HOURSDR REXA2025120200997Stringer · corrodedCORROSION FOUND ON STGR 23L BETWEEN FS 1015-1031. CUT AWAY AND REMOVED SHARP EDGES OF STRINGER 23L AT FS1000+9 AND FS1051+6 FOR REMOVAL IAW CRJ700 SRM 53-00-03-201-001-A01 STEPS 5A(1-2), REPAIR S6232. FABRICATED, LOCATED, AND DRILLED: STRINGER SECTION FS1000+9SDR AALA202512015435Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE SUPPORT ANGLE LOCATED AT BS 1006 PLUS 5 INCHES, LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR SWI2025F01534Slat Track · damagedLH SLAT TRACK 1-2 HAS AREAS WITH SIGNS OF PITTING ON UPPER AND LOWER SURFACES (C-CHECK RO 11/07/2025)REPAIRED DAMAGE TO LH SLAT TRACK 1-2 UPPER AND LOWER SURFACE IAW CRJ900 SRM 51-12-00, MHIRJ REO 690-57-42-1270, REV-P1, DATE 2025-07-29, REV-- DATE 2025-10-0SDR SWI2025F01533Slat Track · damagedRH SLAT TRACK 1-2 HAS AREAS WITH SIGNS OF PITTING ON UPPER AND LOWER SURFACES (C-CHECK RO 11/07/2025)REPAIRED DAMAGED RH SLAT TRACK 1-2 UPPER AND LOWER SURFACE IAW CRJ900 SRM 51-12-00 AND REO 690-57-42-1269 REV-- DATE 2025-07-28. NDT PERFORMED.SDR SWIA20251110715Slat Track · damagedLH SLAT TRACK 2-2 HAS SIGNS OF PITTING ON LOWER SURFACE (C-CHECK RO 11/07/2025)PERFORMED REPAIR LWR SURFACE AT L:H SLAT TRACK 2-2, MATERIAL LOSS .004", FOUND WITHIN LIMITS IAW REO 690-57-42-1276 REV-- DATE: 2025-08-11, CRJ900 SRM 51-12-00, AMM 57-42-26, NDT SDR SWI2025F01485Hinge · nickedLH AILERON AFT SPAR HINGES FOUND TO BE NICKED. HINGE #2, 4, & 5 #30488376 (C-CHECK RO 11/01/2025)BLENDED DAMAGE ON LH AILERON AFT SPAR HINGES #2, 4, & 5 AND FOUND OUT OF LIMITS. REPAIRED PER MHIRJ REO 690-57-51-454 REV -- DATE 2025-07-28. COMPLIED WITH ALL SSDR SWIA202511030715Hinge · nickedRH AILERON AFT SPAR HINGES FOUND TO BE NICKED. HINGE #4, 6, & 8 #30488383 (C-CHECK RO 11/01/2025)REMOVED DAMAGE FROM RH AILERON AFT SPAR HINGES #4, 6, AND 8. COMPLIED WITH REO 690-57-51-453, REV --. DATE: 2025-07-28. COMPLIED WITH 51-900-1002-SKY (CL600-2D24SDR AALA202510150832Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE (AFT LOWER POSITION) LOCATED ON FRAME 35 AT LEVEL OF STRINGER 30 LH SIDE, LOWER FUSELAGE, L= 0.260 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR LOCATED ON FRAME 35 AT LEVEL OF STRINGER 30SDR VNA2025F00028Drag Angle · crackedCRACK ON VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE LH/RH , BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRACE AT BL0.00). VERTICAL STABILIZER TO FUSELAGE ATTACHMENT AFT DRAG ANGLE LH/RH , BTW 55.625% STGR DATUM TO 67.5% REAR SPAR DATUM (TRASDR VNA2025F00027Hinge Fitting · corrodedCORROSION ON HINGE FITTINGS (2 EAS) OF AFT LAVATORY SERVICE DOOR. HINGE FITTINGS (EAS) AT AFT LAVATORY SERVICE DOOR WERE REPLACED PER CRJ900 SRM 51-41-02-001-001-A01 PAR. 7.A.(1) AND CRJ900 AMM 52-45-01-400-801-A0SDR AALA202510033570Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 986, LBL 3. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-4.SDR SWIA2025F01330Housing · gougedEXTERNAL SERVICE DOOR HANDLE HOUSING HAS GOUGES, HN00252768 (C-CHECK RO 09/24/2025)BLENDED OUT DAMAGE TO SERVICE DOOR EXTERNAL HANDLE HOUSING AND COMPLIED WITH ALL STEPS OF REO 601R-52-41-533, REV --, 2025-07-25 AND ALL STEPS OF GREO 601R52-41-235, REV. -ASDR SWIA202509250715Housing · gougedEXTERNAL CARGO DOOR HANDLE HOUSING HAS GOUGES, HN00252765 (C-CHECK RO 09/24/2025)REMOVED AFT CARGO DOOR HANDLE HOUSING. REF. CRJ200 SRM 51-42-21 AND INSTALLED NEW AFT CARGO DOOR HANDLE HOUSING. REF. CRJ200 SRM 51-42-21 AND DWG# CC670-38702 REV. F SHEET 1 SDR AALA202509165435Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE SUPPORT ANGLE LOCATED AT BS 1006 PLUS 5 INCHES, LBL 32. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202509116923Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON OPEN FASTENER HOLE LOC. ON FR16 RH DOOR STOP FITTING 7 UPPER I/B HOLE CRACK DEPTH IS 0.157 INCH APPROX. MAINTENANCE REPLACED INTERCOSTAL FITTING AT LEVEL DOOR STOP #7 ON FRAME 16 RH IAW A319 SRM 51-42-11SDR AALA202509098001Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT (Z ANGLE) LOCATED AT BS STA 986 PLUS 6 INCHES, FROM RBL 35 TO RBL 41. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202509085124Light · burned outAIRCRAFT IN BASE MAINTENANCE: BURN EMERGENCY LIGHT ASSY ON WALL OF LAVATORY D. MAINTENANCE REPLACED EMERGENCY LIGHT ASSY ON WALL OF LAVATORY D IAW AMM 33-51-18-000-001-A STEP 4.B.(1) AND AMM 33-51-18-400-001-ASTEP 4.C.(1) AND STEP F.SDR REXA2025090300846Intercostal · corrodedINTERCOSTAL AT 20R IS CORRODED BETWEEN FS 310.00 AND 319.70. INSTALLED NEW INTERCOSTAL P/N: SH670-32047-1 FROM STR20R BETWEEN FS310.00 TO FS319.70 IAW CRJ700 SRM 51-42-21-001-001-A01 AND 51-42-06-001-001-A01.SDR AALA202508296151Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO AFT PASSENGER CABIN FLOOR STRUCTURE DRAIN ANGLE SUPPORT INTERCOSTAL LOCATED FROM BS 945 TO 947 AT RBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR IPXA2025080742464Rib · crackedMAJOR REPAIR, LEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE, ONE CRACK INDICATION NOTED AT RIB 13. VERIFIED ACCOMPLISHMENT OF REPAIR IAW EO-94705-REQ1 AND VT-MAE EA 300-5750-27-A4050, REV -.SDR AALA202508257160Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE BEAM INNER CHORD LOCATED AT BS 638, LBL 64. REPAIRED CHORD PER SRM 53-40-13-2R-1SDR AALA202508256363Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 324 TO BS 330 AT RBL 60. REPLACED CHORD PER AARD 51-00-05-1.SDR SWAA2025082291684Power Supply · inoperativeINOP EMERGENCY POWER SUPPLY AND BATTERY M1668 POSITION AT PASSENGER CABIN 2025-448068<[01] REPLACED EMERGENCY EXIT LIGHT POWER SUPPLY-POWER SUPPLY AND EMERGENCY EXIT LIGHT POWER SUPPLY-BATTERY PACK M1668 AT MID CABIN LT SIDE I.A.W 33-51-06-960-806-NG AND 33-51SDR SWAA2025082206943Battery Pack · inoperativeINOP EMERGENCY POWER SUPPLY AND BATTERY M1668 POSITION AT PASSENGER CABIN 2025-448068<[01] REPLACED EMERGENCY EXIT LIGHT POWER SUPPLY-POWER SUPPLY AND EMERGENCY EXIT LIGHT POWER SUPPLY-BATTERY PACK M1668 AT MID CABIN LT SIDE I.A.W 33-51-06-960-806-NG AND 33-51SDR SWAA2025082291682Light · brokenBROKEN EMERGENCY EXIT LIGHT HOUSING ASSY ON BULLNOSE 3LH AT PASSENGER CABIN 2025-448074<[01] REPLACED EMERGENCY EXIT LIGHT HOUSING ASSY ON BULLNOSE 3LH AT PASSENGER CABIN IAW B737-700 AMM 33-51-03-960-802.<BR>TEST IS OK.;[02] CERTIFIED CORRECTIVE ACTION STEP 1SDR SWAA2025082291686Gusset · crackedCRACK GUSSET BS500D AND STR 19R FWD CARGO COMPARTMENT 2025-448085<[01] REPLACED GUSSET LOCATED BS500D AND STR 19R FWD CARGO COMPARTMENT IAW B737-700 SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG :143A7902; SHEET: 174; REV: - ; SEE INDIVIDUAL SIGN OFF BELOW.;[SDR SWAA2025082291687Gusset · crackedCRACK GUSSET BS 500D AND STR 19L FWD CARGO COMPARTMENT 2025-448087<[01] REPLACED GUSSET AND FASTENERS LOCATED BS 500D AND STR 19L FWD CARGO COMPARTMENT IAW B737-700 SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 143A7902 SHEET 174 REV-.;[02] CORRECTED STEP 1 <BR>REPSDR IPXA2025080741618Rib · crackedMAJOR REPAIR, LEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE, THREE CRACK INDICATIONS NOTED AT RIB 27. VERIFIED ACCOMPLISHMENT OF REPAIR IAW EO-94705-REQ1 AND VT-MAE EA 300-5750-27-A4050, REV -.SDR IPXA2025080742215Rib · crackedMAJOR REPAIR, LEFT WING, CENTER FLAP, TOP SKIN RIB FLANGE, THREE CRACK INDICATIONS NOTED AT RIB 26. VERIFIED ACCOMPLISHMENT OF REPAIR IAW EO-94705-REQ1 AND VT-MAE EA 300-5750-27-A4050, REV -.SDR AALA202508227569Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR ENTRY WAY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 947 TO BS 986 AT RBL 52. REPLACED CHORD PER AARD 51-00-05-1.SDR IPXA2025081342587Rib · crackedMAJOR REPAIR, RH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK INDICATION NOTED AT RIB 17. CIRCLED IN RED. ACCOMPLISHED PERMANENT REPAIR IN ACCORDANCE WITH EO-94721-REQ1 AND VT-MAE EA 300-5750-27-A4041, REV. -.SDR IPXA2025081342552Rib · crackedMAJOR REPAIR. RT WING, CENTER FLAP, TOP SKIN RIB FLANGE, 3 CRACK INDICATION NOTED AT RIB 26. CIRCLED IN RED. ACCOMPLISHED PERMANENT REPAIR IN ACCORDANCE WITH EO-94721-REQ1 AND VT-MAE EA 300-5750-27-A4041, REV. -.SDR IPXA2025081342596Rib · crackedMAJOR REPAIR. RH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 CRACK INDICATION NOTED AT RIB 25. CIRCLED IN RED. ACCOMPLISHED PERMANENT REPAIR IN ACCORDANCE WITH EO-94721-REQ1 AND VT-MAE EA 300-5750-27-A4041, REV. -.SDR AALA202508202397Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FORWARD OF AFT LAVATORY INBOARD MOUNT AT BS 947, RBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR JJBA20250818043Support Angle · crackedUPLOCK NLG STRUCTURE, LH AND RH SUPPORT ANGLE FOUND CRACKED. UPLOCK NLG STRUCTURE LH AND RH SUPPORT ANGLE REMOVED AND REPLACEDSDR SWAA2025081891425Skin · delaminatedRIGHT INBD MAIN FLAP T/E WEDGE LOWER SKIN T/E IS DELAMINATED 10' FROM O/B EDGE. REMOVED AND REPLACED RT INBD MAIN FLAP T/E WEDGE IAW AMM 20-50-11-910-801; SRM 51-40-05 AND DWG 113A2550 REV -; AIPC 27-51-11-01B AND SRM 51-40-02.SDR AALA202508186193Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 312 TO BS 344 AT LBL 59. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202508185132Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 986 PLUS 8 INCHES, FROM LBL 40 TO LBL 46. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202508183570Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) LOCATED AT BS 786, LBL 3. REPAIRED UPPER CHORD PER SRM 53-70-51-2R-4.SDR SWAA2025081591783Stub Frame · crackedCRACK FOUND ON R1 STUB FRAME AT BS 291.5+7.5; .15' ABOVE SEAL DEPRESSOR; .6' LENGTH (MARKED)<[01] TASK CARD COMPLETED; SUMMARY STATEMENT; NO ALLOWABLE LIMITS FOUND ON SRM THEREFORE PART TO BE REMOVE AND REPLACE I.A.W SRM 51-10-02-0G-0 PAR.9.C REMOVED FSD UPPERSDR SWAA2025081591789Angle · crackedCRACKED ANGLE BS 294.5 RBL 60 WL 208 COMMON TO I/B CHORD UPPER SIDE OF CREASE BEAM WEB.<[01] REMOVED AND REPLACED ANGLE AT BS 294.5 RBL 60; WL 208 COMMON TO I/B CHORD UPPER SIDE OF CREASE BEAM WEB IAW SRM 51-40-02-0G-0 AND DWG 141A8310 ; REV:D;[02] VERIFIED COSDR SWAA2025081591782Bear Strap · crackedCRACK FOUND ON R1 BEAR STRAP AT BS 291.5+4; WL 265.6; .6' IN LENGTH (MARKED)<[01] REPAIRED BY 737 SRM 53-10-01-2R-6 AND EA M-25-153-01539 CCN TTG8Q013R942;[02] ALL STEPS COMPLETED.;[03] ALL STEPS COMPLETED.SDR AALA202508156965Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM 6 ON LH HORIZONTAL STABILIZER. MAINTENANCE REPLACED ELEVATOR HINGE ARM 6 ON LH HORIZONTAL STABILIZER IAW AMM-AMM-55-16-42-000-001-A AND AMM-AMM-55-16-42-400-001-A.SDR 3EJA202508150004Squat Switch · failedUPON REACHING 5,000’ BOTH, MY EARS AND CAPTAIN’S EARS STARTING POPPING AND WITHOUT HESITATION WE LOOKED AT THE PRESSURIZATION SCREEN TO SEE THAT THE BIG NEEDLE WAS CLIMBING AND LITTLE NEEDLE NOT PRESSURIZING. REMOVED AND REPLACED LH MLG SQUAT SWITCH.SDR SWAA2025081491720Angle · crackedCRACK ANGLE TRAILING EDGE ORSS 271 RT WING. REPLACED ANGLE TRAILING EDGE ORSS 271, RT WING IAW SRM 51-10-02-0G-0 ITEM 9, SRM 51-40-02-0G-0, AND DWG 115A2930, SHEET 8, REV -.SDR SWAA2025081491722Support Bracket · crackedCRACK SUPPORT BRACKET TRAILING EDGE ORSS 271 AT LT WING. REPLACED SUPPORT BRACKET TRAILING EDGE ORSS 271 AT LT WING IAW SRM 51-10-02 PARAGRAPH 9; SRM 51-40-02 AND DWG 115A2930, SHEET 6 REV -. MEASUREMENT OF CRACK IS L: 0.225.