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 CALA2025102710583Battery Pack · no testEMERGENCY BATTERY L DISPLAYED DURING EMERGENCY LIGHTING BITE TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPS CHECK GOOD.SDR CALA2025102710567Wire Harness · brokenECONOMY PASSENGER SEAT EMERGENCY PATH LIGHTING (EPL) INSPECTION. SEATS 32 ABC EMERGENCY PATH LIGHT INOP REQUST TO DEFER SEAT 32ABC REF MEL 3319E. ALL SPEC NOTES FOR EMERG LIGHT ARE OPERABLE. INSTALLED PLACARD, REPLACED EPL SEAT HARNESS IAW IFM 25-22-55, OPS SDR IXXA20251026005Rib · corrodedCORROSION ON THE FWD END OF THE RIB IN THE RIGHT WING L/E AT THE O/B SIDE OF #10 SLAT I/B AUX TRACKSDR IXXA20251026004Structure · crackedINNER CHORD STA 859.5 RBL 89 WL 200 CRACKEDSDR IXXA20251026003Beam · crackedINNER CHORD AT STA 903.5 RBL89 CRACKEDSDR IXXA20251026002Beam · crackedSTUB BEAM REQUIRES REPAIR AT INNER CORD STA 883.5, RBL89, WL200SDR IXXA20251026001Beam · corrodedALC DOOR BEAM FROM BOTTOM INSPECTION HOLES HAVE CORROSIONSDR SWIA2026022375304Frame · crackedBS 280 FRAME CRACKED AT STRINGER 3L REPAIRED THE FRAME IAW REO 601R-53-11-4041 REV --. ANALYSIS TO DETERMINE ADDITIONAL REQUIREMENTS WILL BE COMPLETED WITHIN 12 MONTHS OF THE ISSUE DATE OF THIS REPAIR. THE AIRCRAFT MUST NOT BE OPERATED BEYOND 12 MONTHS FROMSDR SWIA2026022375303Stringer · crackedSTRINGER 3L CRACKED AT FS379 (C-CHECK RO 02/20/2026)REPAIRED STGR 3L AT FS 379.00 IAW CRJ200 SRM 53-00-03SDR AALA202601154238Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER TEE FITTING AT BS 986.5, RBL 43. REPAIRED UPPER TEE FITTING IAW SRM 53-70-51-2R-4.SDR AALA202601149757Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO SEAL SUPPORT INTERCOSTAL ON AFT PRESSURE BULKHEAD AT BS 1016, FROM LBL 8 TO LBL 30. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR 3EJA202601130001Shutoff Valve · failedINCREASED POWER TO TAKEOFF THRUST AND STARTED OUR TAKEOFF. WITHIN 2 SECONDS WE HEARD A RHYTHMIC TICKING. R & R EMERGENCY SHUTOFF VALVE.SDR AALA202601052229Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST UPPER TENSION BOLT POSITION LH, CRACK LENGTH 0.127 INCH APPROX AND CRACK DIRECTION 1 C LOCK LOOKING INBOARD. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR LOCATED ON CENTER WINDSHIESDR AALA202601059245Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER POST UPPER TENSION BOLT POSITION LH, CRACK LENGTH 0.127 INCH APPROX AND CRACK DIRECTION 1 C LOCK LOOKING INBOARD. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR LOCATED ON CENTER WINDSHIESDR 3EJA202512230002Pressure Switch · out of positionCABIN ALT LIGHT CAME ON PASSING THRU 2600, CABIN ALT REACHED 14000 SAME. T/S FOUND ENG SELECT PRESS SOURCE SWITCH IN COCKPIT TO BE CLOCKED WRONG, WAS IN OFF POSITION BUT SHOWING THAT IT WAS IN NORM, ADJUSTED KNOB OPS CK GOOD AT THIS TIME, VERIFIED CLIMB DIVSDR SWIA202512121025Post · corrodedAVIONICS BAY LEFT FLOOR POST AT LBL12 AND FS280.00 THERE IS SIGNS OF CORROSION WHERE THE POST CONNECTS TO FRAME 280. PERFORMED REPAIR AT LT FLOOR POST AT LBL 12 AND FS280.00 IAW SRM 53-00-00, 53-11-43, 51-42-06, 51-42-21, 51-42-10, 51-24-21, 51-40-11, 51-21-1SDR REXA2025121201006Seat Track · corrodedINITIAL INSPECTION: SEVERAL CORROSION POINTS ON RH SIDE SEAT RAIL BTW FS785.15 AND FS847. SEVERAL CORROSION POINTS ON RH SIDE SEAT RAIL BTW FS785.15 AND FS847 WAS EVALUATED DUE TO EXCESSIVE DAMAGE THEREFORE WAS REPLACED PER CRJ-900 SRM 53-41-49-101-001-A02 ANSDR REXA2025121201005Seat Track · corrodedINITIAL INSPECTION: SEVERAL CORROSION POINTS ON LH SIDE SEAT RAILS BTW FS785.15 AND FS847. SEVERAL CORROSION POINTS ON LH SIDE SEAT RAILS BTW FS785.15 AND FS847 WERE FOUND DUE TO EXCESIVE DAMAGE THEREFORE WERE REPLACED PER CRJ-900 SRM 53-41-49-101-001-A02 AND SDR SWAA2025120428470Glowstrip · crackedCRACKED PHOTOLUMINESCENT STRIP ALONG PAX CABIN (12 EA). REPLACED THE PHOTOLUMINESCENT STRIP IAW AMM 33-51-15-400-802.SDR SWAA2025120428475Bear Strap · crackedCRACK INDICATION ON THE BEAR STRAP IN THE FWD GALLEY DOOR BETWEEN BS 291 - 294.5, S8 & 9R . CRACK LENGTH 0.125 INCH. RII REJECTED STEP 17 DUE TO IAW 5313-I-17254-NG, FWD R1 DOOR BEAR STRAP; - GROUP 2. ENGINEERING WAS CONTACTED FOR REPAIR INSTRUCTIONS TSR-20SDR SWAA2025120428474Stub Frame · crackedCRACK STUB FRAME, BS 296.5, BTW STRINGERS 8 - 9R UPPER POSITION IN THE FWD GALLEY. REPLACED STUB FRAME & FASTENERS IAW SRM 51-40-02-OG-0, SRM 51-10-02, AND DWG 141A8370, SHEET 9, REV D.SDR SWAA2025120428478Access Panel · damagedELONGATED HOLES OF ACCESS PANEL 195BL BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 195BL IAW SRM 51-70-05-2R-10, REPAIR 10.SDR SWAA2025120428479Access Panel · elongatedELOGANTED HOLES OF ACCESS PANEL 195AR BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 195AR BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-10, REPAIR 10.SDR SWAA2025120128469Girt Bar · looseAFT ENTRY DOOR SLIDE GIRT BAR BRACKET LOOSE. REMOVED AND REPLACED FASTENER AFT ENTRY DOOR SLIDE GIRT BAR BRACKET IAW SRM 51-40-02-0G-0.SDR SWAA2025120128162Pressure Deck · crackedCRACK INDICATION ON THE HORIZONTAL PRESSURE DECK WEB, LBL 40, BS 663. PERFORMED A PERMANENT REPAIR ON HORIZONTAL PRESSURE DECK WEB IAW SRM 53-40-51-2R-2, REPAIR 2.SDR SWAA2025120128551Rib · crackedCRACKED INSPAR RIB, HSS 120.30 AND 17 INCHES FROM FRONT SPAR IN THE RT HORIZONTAL STAB. PERFORMED A PERMANENT REPAIR ON INSPAR RIB IAW SRM 55-10-09-2R-4, REPAIR 4.SDR SWAA2025120128163Stub Frame · crackedONE CRACK INDICATION ON STUB FRAME, BS 294.5 BETWEEN S8 --9, CRACK LENGTH 1.4 INCH. REPLACED STUB FRAME IAW SRM 51-40-02, DWG 141A8370, SHEET 9, REV D, SHEET 10, REV-.SDR SWAA2025120128621Skin · crackedRIGHT WING NR 8 SLAT NOSE SKIN AT ACTUATOR RIB HAS POSSIBLE CRACK. CLEANED RIGHT WING NR 8 SLAT NOSE SKIN AT ACTUATOR IAW SOPM 20-30-03. REPAIRED SLAT IAW SRM 57-42-01-2R-8, REPAIR 8, ALTERNATIVE 1, FIG 202.SDR SWIA202511281025Floor Support · damagedDAMAGE HOLE TP RBL9.00 FLOOR SUPPORT LOWER FLANGE BTWN FS 677.00 & FS692.00. DAMAGE HOLE TP RBL9.00 FLOOR SUPPORT LOWER FLANGE BTWN FS 677.00 & FS692.00 COMPLIED ALL STEPS IAW REO670-53-31-1109 REV.--SDR SWAA2025112828448Bracket · crackedCRACK ON BRACKET TRAILING EDGE LOCATED ORSS273 AT RT WING. REPLACED THE BRACKET TRAILING EDGE LOCATED ORSS273 AT RT WING IAW SRM 51-10-02-0G; SRM 51-40-02-0G-0 AND DWG 115A6200 SHEET 17 REV A TOOK MEASURE OF CRACK IS: 1.754 INCHES.SDR SWAA2025112628445Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500E TO BS 500I LBL 22 WL 156.1AT FWD CARGO COMPARTMENT, 12 POINTS. FAULT RESOLVED ON FAULT TTG8Q016272L.SDR SWAA2025112628455Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 500 TO BS 500E LBL 22 WL 156.1, AT FWD CARGO COMPARTMENT,12 POINTS. THE DAMAGE WAS REPAIRED IAW SRM 53-00-53-2R-5 AND EA M-22-153 -01550.SDR SWAA2025112028595Paint · degradedTHE LEFT WING UPPER INBD SURFACE EMERGENCY ESCAPE PATHWAY HAS HEAVILY DEGRADED PAINT. RESTORED FINISH PER AMM 51-21-97-370-802.;[02] INSPECTION C/WSDR SWAA2025112028452Web · corrodedCORROSION ON SHIELD WEB, BTW BS 492.4 - 500A, RBL 23, WL 208.1. REPLACED SHIELD WEB IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A0080, SHEET 39, REV-.SDR SWAA2025112028454Support · corrodedCORROSION ON SUPPORT ZEE, BTW BS 500E - 500I, RBL 22, WL 156.1. FWD CARGO COMPARTMENT. FAULT RESOLVED ON FAULT TTG8Q0161PAR.SDR SWAA2025112028446Support · corrodedCORROSION ON SUPPORT ZEE, BTW BS 500A - 500E, RBL 22, WL 156.1. THE DAMAGE WAS REPAIRED PER SRM 53-00-53-2R-5 (REPAIR5) AND EA M-22-153 -01550.SDR SWAA2025112028453Tie Clip · crackedCRACK ON TIE CLIP, BS 500I, STRINGER 26R, WL 156.1. REPLACED THE TIE CLIP IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A1234, SHEET 13, REV A.SDR SWAA2025112028579Support Angle · crackedCRACK ON SUPPORT ANGLE BTW BS 380 TO BS 400, BL 0, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 138, REV -. MEASUREMENT OF THE CRACK IS 1.298SDR SWAA2025112028578Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 40 WL 208.1. REPLACED SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 142, REV-. MEASUREMENT OF THE CRACK IS: 1.250 INCH.SDR SWAA2025112028576Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 49 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A5400, SHEET 38, REV-. MEASUREMENT OF THE CRACK IS: 0.292 INCH.SDR SWAA2025112028577Support Angle · crackedCRACKED SUPPORT ANGLE BTW BS 380 - 400, LBL 13, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 143A5400, SHEET 154, REV -, MEASUREMENT OF THE CRAK IS 0.667 INCH.SDR SWAA2025112028573Support Bracket · crackedCRACKED SUPPORT BRACKET, BS 867, BTW STR 2R TO STR 3R. REPLACED SUPPORT BRACKET LOCATED BS 867 BTW STR 2R TO STR 3R IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 146A7901, SHEET 66, REV A.SDR SWAA2025112028574Frame · crackedCRACK ON FRAME LOCATED BS 312 BTW STR 5L TO STR 6L AT FWD GALLEY AREA. PERFORMED PERMANENT REPAIR FRAME IAW EA M-22-153-01244.SDR JJBA20251120085Seat Track · damagedMID SEAT TRACK AT FR 38 HAS DAMAGE. REMOVED AND REPLACED SEAT TRACK FR 38SDR JJBA20251120075Floor Support · corrodedMID FLOOR BEAM GUSSET FROM FR 20 TO FR 21, STR 1R, HAS CORROSION. REMOVED AND REPLACED MID FLOOR BEAM GUSSET AT FR20-FR21.SDR SWAA2025111828605Paint · degradedTHE RIGHT WING UPPER INBD SURFACE EMERGENCY ESCAPE PATHWAY HAS DEGRADED PAINT. RESTORED OVERWING EMERGENCY WALKWAY COATING AS REQUIRED PER AMM 51-21-97.SDR SWAA2025111728485Pressure Deck · crackedSUSPECTED OF CRACK AT HORIZONTAL PRESSURE DECK WEB BS 663, LBL 31, REMOVED AND REPAIRED HORIZONTAL PRESSURE DECK BS 663 - 675, LBL 25 - LBL 60 IAW SRM 53-40-51-2R-2, REPAIR 2.SDR SWAA2025111728307Floor Panel · delaminatedFLOOR PANEL 231XF IS DELAMINATED. FLOOR PANEL 231XF; WITH DELAMINATION; WAS REPLACED WITH A NEWLY FABRICATED FLOOR PANEL IAW SRM 53-00-50-2R-0.SDR SWIA2025111700025Slide · crackedFWD PAX DOOR SLIDE BACKBOARD IS CRACKED AT TOP. REMOVED AND REPLACED FWD PAX DOOR SLIDE. IAW AMM 25-65-01.SDR IPXA2025111745555Handle · dirtyCREW ENTRY DOOR, EXTERIOR DOOR HANDLE, LIFT HANDLE OUT, STUD CORRODED/WORN, MARKED, 107-009. CLEANED CREW ENTRY DOOR, ENTERIOR DOOR HANDLE, LIFT HANDLE OUT, STUD IAW AMM 12-25-01-100-801. PERFORMED DVI ONTO CREW ENTRY DOOR EXTERIOR DOOR HANDLE, LIFT HANDLE OU