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 IPXA2025072157852Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD SIDE OF BS 2180 S20L. PERFORM EO-94470-REQ1 REV.1 AND EI F2025A53M-1517, REV 1 2.SDR IPXA2025072157832Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 2180, S21R, ACCOMPLISHED REPAIR IAW EO-94465-REQ 1, REV 1, AND EGAT EI F2025A53M-1527 REV 1.SDR SCNA20250722270Skin · damagedFUSELAGE SKIN, STA 420 TO 480 BETWEEN S-26R AND S-27L - REPAIR - C/W BY FAS 4686SDR SCNA20250722269Skin · damagedWO95798, ENG-53SCA-11679, N835SY: FUSELAGE SKIN, STA 370 TO 385 BETWEEN S-22R AND S-25R - REPAIR - RESOLUTION: C/W BY FAS 4686SDR SIMA20250622002Seal Rest · corrodedSSI 53-21-009: FWD CARGO DOOR FUSELAGE CUTOUT LOWER EDGE IS CORRODED AT 2 HOLES. (MAJOR REPAIR) (LEVEL 2 CORROSION). RAR FWD CARGO DOOR FUSELAGE CUTOUT LOWER EDGE (SEAL REST) IAW ERJ 175 SRM 51-40-08.SDR FDEA202506221281Landing Gear · malfunctionedON TEST FLIGHT 9045 AFTER HMV 1/ 2 OUT OF INDIANAPOLIS TEST FLIGHT CREW PERFORMED ALT GEAR EXTENSION CHECK, FIRST ATTEMPT FAILED. CREW DEBRIEFED THAT THEY PERFORMED A NORMAL GEAR EXTENSION-RETRACTION SUCCESSFULLY, TRIED ALT GEAR EXTENSION A SECOND TIME ASDR CALA2025072206838Pressure Web · crackedCENTER WING BOX REAR SPAR VERTICAL PRESSURE WEB HAS CRCK INDICATION BETWEEN RBL 31.83 AND RBL 40 (LENGTH 2") RBL 40- RBL 45. 64 (LENGTH 2" ) (REF AAR NR 1000038 596)REPAIRED DAMAGE CRACK AT THE CENTER WING REAR SPAR VERTICAL PRESSURE WEB BETWEEN RBL 31.83 ANSDR SWAA2025072184493Floor Panel · crackedCRACK FLOOR PANEL 140CF AT AFT CARGO COMPARTMENT. REPLACED FLOOR PANEL 140CF AT AFT CARGO COMPARTMENT IAW AMM 25-52-01-201-801; SRM 51-10-02-0G-0 PARAGRAPH 9 AND DWG 453A2610 SHEET: 9 REV: E; FOR INSTALATION OF PANEL 140CF SEE TTG8Q013EWJC.SDR REXA2025072100746Frame · corrodedFS 549 FRAME CORRODED BETWEEN STR 17L AND STR 18L. REPAIRED IAW ENDEAVOR AIR EA CRJ753-19587 REV IR DATED 06-24-2025.SDR IPXA2025071858007Stringer · crackedSTRINGER CRACK, FWD AND AFT SIDE OF STA 2180 S-13L, LEVEL 1. (REPAIR) RII COMPLETED FOR EGAT EI NO.F2025A53M-1299 SEQUENCE A STEP 34.SDR IPXA2025071857968Stringer · crackedSTRINGER CRACK, FWD SIDE OF STA 2180 S-14L, LEVEL 1. (REPAIR) RII COMPLETED FOR EGAT EI NO.F2025A53M-131.SDR AALA202507179413Attach Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY BEARING ATTACH FITTING INTERCONNECTING STRUT LOWER POSITION LH WING. MAINTENANCE REPLACED ATTACH FITTING INTERCONNECTING STRUT LOCATED LOWER POSITION LH WING IAW A319 SRM 51-42-11-801 AND DWG D57570280.SDR IPXA2025071757827Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, AFT SIDE OF BS 1660 S10R. PERFORM EO-94451-REQ1 REV.1 AND EI NO.F2025A53M-1459 REV.1. 2.SDR IPXA2025071757848Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD AND AFT SIDE OF BS 1960, S14R. PERFORMED EO-94439-REQ1, REV 1 & EI F2025A53M-1298, REV 2.SDR IPXA2025071757864Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 2180, S16R. PERFORMED EO-94475-REQ1, REV 1 & EI F2025A53M-1315, REV 2.SDR IPXA2025071757879Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 1960 S24L. ACCOMPLISHED REPAIR I.A.W UPS EO-94495-REQ1 AND GEAT EI NO. F2025A53M-1491 REV.1 2.SDR IPXA2025071758826Stringer · crackedMAJOR REPAIR. STRINGER CRACK, AFT SIDE OF STA 2180 S-24L. REPAIR DAMAGE STRINGER I.A.W UPS EO-94478-REQ1 REV 1.SDR ASAA2025062259465Transition Panel · corrodedFWD PIT RH TRANSITION HAS MULTIPLE AREAS OF CORROSION BETWEEN STA 500A +10 AND STA 500-I. GROUNDED - YES. REMOVED AND REPLACE FWD PIT RH TRANSITION PANEL STA 500A+10 AND 500-I IAW B737-800 SRM 51-40-02-0G-0W: 1" O: .040" R: /032" L: 5" D: .008".SDR ASAA2025062259461Shield · corrodedAFT PIT, SHIELD AFT OF THE CARGO DOOR HAS AREAS OF CORROSION. GROUNDED - YES. REMOVED AND REPLACED AFT PIT SHIED FWD OF THE CARGO DOOR. IAW B737-800 SRM 51-40-02-0G-0W 1/2 INCH O .050 R .041 L 1" D .009.SDR ASAA2025062259460Transition Panel · corrodedAFT PIT, RH TRANSITION HAS CORROSION BETWEEN STA 767 AND STA 727B. FOUND CRACKS IN TRANSITION AT STA 727H, 727F, AND 727E. GROUNDED - YES. REMOVED AND REPLACED AFT PIT, RH TRANSITION BETWEEN STA 767 TO 727 IAW B737-800 SRM 53-00-53-2R-5W: 1" O: .040" R: 0" L" SDR ASAA2025062259459Transition Panel · corrodedAFT PIT, LH TRANSITION PANEL HAS AREAS OF CORROSION FROM STA 727 TO STA 847. GROUNDED - YES. REMOVED AND REPLACED AFT PIT, LH TRANSITION PANEL FROM STA 727 TO STA 847 IAW B737-800 SRM 51-40-02-0G-0W= 3" O= .040 R= 0 L= 3" D= .040.SDR ASAA2025062259458Transition Panel · corrodedFWD PIT LH TRANSITION PANEL HAS AREAS OF CORROSION FROM STA500C -8 TO STA 500 I. GROUNDED - YES. REMOVED AND REPLACE FWD PIT LH TRANSITION PANEL STA 500C-8 TO STA 500I IAW B737-800 SRM 51-40-02-0G-0W 1" O .040 R .034 L 1" D .006.SDR ASAA2025062259413Attach Bracket · crackedFWD CARGO COMPT, LT TRANSITION BAFFLE ATTACH BRACKET CRACKED STA 500H. GROUNDED - YES. EVALUATED CLIP & FOUND TO BE OUT OF LIMITS DUE TO NO LIMITS GIVEN. REMOVED DAMAGED CLIPS, LOCATED & DRILLED NEW CLIPS P/N:143A7502-155 P.O.1126868.2 & P/N:143A7502-159 P.O.1SDR SWIA202507150622Skin · chafedCHAFING FOUND ON LOWER FUSELAGE SKIN BETWEEN FS977.00 AND FS985.00 STGR 27 DUE TO CONTACT ON AFT FAIRING PANEL C-CHANNEL. REMOVED CHAFING FOUND ON LOWER FUSELAGE SKIN BETWEEN FS977.00 AND FS985.00 STGR 27 REF CRJ700 SRM 51-12-00-001-001-A01. FOUND AREA TO BESDR SWAA2025071584305Crease Beam · corrodedCORROSION CREASE BEAM AT LEVEL STA 639 RBL 64 AND WL 208.1 AT PASSENGER CABIN. REPLACED CREASE BEAM (INNER CHORD) AND FASTENERS AT LEVEL BTW STA 613 TO BS 664 RBL 64 AND WL 208.1 AT PASSENGER CABIN IAW SRM 51-40-02; SRM 51-10-02 Ï¿½TEM 9 AND DWG 144A5901 SHEESDR SWAA2025071584306Floorbeam · crackedCRACK BREAK PANEL ON FLOOR STRUCTURE LOCATED STA 540 BTW BL 0 TO RBL 24.75 AT PASSENGER CABIN. REPLACED BREAK PANEL LOCATED ON FLOOR STRUCTURE LOCATED ON STA 540 BTW BL 0 TO RBL 24.75 AT PASSENGER CABIN IAW SRM 51-40-02 AND DWG 143A5240; SHEET: 13 AND REV: -.SDR SWAA2025071584304Floorbeam · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED STA 695 AND LBL 24.75 AT PASSENGER CABIN. REPLACED SUPPORT BRACKET AND NEW FASTENERS ON FLOOR STRUCTURE LOCATED STA 695 AND LBL 24.75 AT PASSENGER CABIN IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 273A9110 SHEET 6 REV: A.SDR IPXA2025071557946Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD AND AFT SIDE OF BS 2180 S14R, LEVEL 1. PERFORM EO-94473-REQ1 REV.1 AND EI NO.F2025A53M-1313 REV.1 2.SDR ASAA2025062259367Stringer · corrodedFORWARD CARGO COMPARTMENT BILGE, STRINGER CORRODED. STA 500E + 19.5. GROUNDED - YES. EVALUATED AND REMOVED DAMAGE FROM STRINGER @ STA 500E + 19.5; ORIGINAL: .090, REMOVED .021, REMAINING .069 AND WAS FOUND TO BE OUT OF LIMITS IAW B737-800 SRM 53-00-03-1A-1. RESDR ASAA2025062259366Stringer · corrodedFWD CARGO COMPT BILGE, STRINGER HAS 2 SPOTS OF CORROSION STA 500E +5.5 AND +8, 15LBL. GROUNDED - YES. EVALUATED AND REMOVED DAMAGE FROM STRINGER @ STA 500 E+5.5 & +8; ORIGINAL: .056, REMOVED: .012, REMAINING .044 AND WAS FOUND TO BE OUT OF LIMITS IAW B737-800 SDR ASAA2025062259365Stringer · corrodedFWD CARGO COMPT BILGE, STRINGER HAS 2 SPOTS OF CORROSION. STA 500D AND 500D + 8, LBL1.5. GROUNDED - YES. EVALUATED AND REMOVED DAMAGE FROM STRINGER @ STA 500D AND 500D+8, ORIGINAL: .056, REMOVED: .012, REMAINING: .044 AND FOUND TO BE OUT OF LIMITS IAW B737-800SDR ASAA2025062259362Stringer Clip · corrodedFORWARD CARGO COMPARTMENT BILGE, FRAME TO STRINGER ATTACH ANGLE CORRODED. STA500F 6 OCLOCK. GROUNDED - YES. REMOVED DAMAGE ORIGINAL: .050, REMOVED: .008, REMAINING: .042, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE SHEAR TIE, LOCATED AND DRILLED NEW SHEAR TIE P/SDR IPXA2025071457915Stringer · crackedSTRINGER CRACKED, AFT SIDE OF STA 1960 S-12R, LEVEL 1. RII COMPLETED FOR EGAT WORK SHEET NO.50432 STEP 42.SDR IPXA2025071457964Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, FWD SIDE OF BS 2180, S15L. PERFORMERED EO-94457-REQ 1, REV 1, AND EI F2025A53M-1457, REV 1.SDR IPXA2025071457869Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, FWD AND AFT SIDE OF BS 2180, S15R. PERFORMED EO-94497-REQ 1, REV 1 AND EI F2025A53M-1323, REV 2.SDR REXA2025070900712Stringer · corrodedSTRINGER 26R IS CORRODED BETWEEN FS 280.00 AND 319.70. REMOVED CORROSION ON STR 26R BETWEEN FS 280 AND FS 310 IAW CRJ700 SRM 51-21--06-001-001-A01. STR 26R FOUND TO BE OUT OF LIMITS DUE TO 100% MATERIAL LOSS BETWEEN FS 280 AND FS 310 IN MULTIPLE AREAS IAW CRSDR REXA2025070900711Stringer · corrodedSTRINGER 25R IS CORRODED BETWEEN FS 295.00 AND 310.00 REMOVED CORROSION FROM STR 25R BETWEEN 295 & FS 310 IAW CRJ700 SRM 51-- 21-06-001-001-A01. FOUND DAMAGE TO BE OUT OF LIMITS IAW SRM TASK 53-21-- 03-101-002-A01. FOUND DAMAGE TO BE OUT OF LIMITS. R & R STRSDR AALA202507086130Switchpack · faultyAIRCRAFT WAS NOT GROUNDED: REPEAT ITEM: AUTO BRAKE DISARM ILLUMINATED REPATED 3 TIMES NOW. REMOVED AND REPLACED LEFT HAND (AALA202506236130) AND RIGHT HAND (AALA202507087237) (ATSP)-AUTOTHROTTLE SWTCHPACK ASSEMBLY. PER MCM# 08L11276002 AND MCM# 08L11276001.SDR AALA202507087237Switchpack · faultedAIRCRAFT WAS NOT GROUNDED: REPEAT ITEM: AUTO BRAKE DISARM ILLUMINATED REPATED 3 TIMES NOW. REMOVED AND REPLACED LEFT HAND (AALA202506236130) AND RIGHT HAND (AALA202507087237) (ATSP)-AUTOTHROTTLE SWTCHPACK ASSEMBLY. PER MCM# 08L11276002 AND MCM# 08L11276001.SDR CALA2025070806328Angle · corrodedFWD WET AREA R-1 CENTER THRESHOLD SUPPORT HAS CORROSION AROUND FASTENER HOLE STA 312+ 11" RBL58 .DOT251-007 REF AAR N/R 9987991 REMOVED AND REPLACED THRESHOLD SUPPORT AT FWD WET AREA FLOOR STRUCTURE R1 DOOR RBL 58 IAW SRM 51-40-021-0G-0 ,DWG # 141A8310 , NSDR SWI2025F00853Windshield · crackedL WINDSHIELD INSIDE CRACKED (FLIGHT 6516 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30361298 WITH THE FOLLOWING CORRECTIVE ACTION: "COMPLIED WITH CRJ700 TASK CARD 56-220-1000-SKY (COCKPIT WINDSHIELD INSTALLATION). PRESSURIZATION CHECK GOOD."SDR SWIA2025070300622Warning Message · illuminatedD:GEAR DISAGREE ON FINAL APPROACH INTO IAD, QRH CLEARED MESSAGEC: MEL 32-30-1CAT A DUE WITHIN 1 FLIGHT DAY FROM 06/22/2025CAT II DOWNGRADEGEAR DISAGREE ON FINAL APPROACH INTO IAD, QRH CLEARED MESSAGE (FLIGHT 5062 - FILED CLOSED)JUN 22, 2025 STATION: IAD--DEFSDR IPXA2025070357957Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 2180, S18L. ACCOMPLISHED REPAIR IAW EO-94463-REQ 1, REV 1, EGAT EI F2025A53M-1518, REV 1, SRM 53-60-03-2R-3, REV 46, AND EGAT WORK SHEET 50459.SDR IPXA2025070357905Stringer · crackedMAJOR REPAIR. STRINGER CRACKED, AFT SIDE OF BS 2180 S12R. PERFORM EO-94450-REQ1 REV.1 AND EI F2025A53M-1391, REV 1 AND EGAT WORK SHEET 50457.SDR IPXA2025070357998Stringer · crackedMAJOR REPAIR, STRINGER CRACKED, AFT SIDE OF BS 2180, S10R. PERFORM EO-94292-REQ 1, REV 1, EI F2025A53M-1393, REV 0, AND EGAT WORK SHEET 50458.SDR DALA2025070304968Seat Track · corrodedCORROSION ALONG PAX CABIN SEAT TRACKS AT WL-252.0, RBL- 23.5, FROM FR-30+7 TO FR-38+3. WL NEEDS TO BE WL-151. REMOVED DAMAGED SEAT TRACK AND REPLACED NEW SEAT TRACK FROM FR 30 + 7 TO FR 38, RBL 23.5 P/N C01335693-005S LOT. 5179492 IAW A220 ASRP BD500-J51-42-21SDR AALA202507031647Proximity Sensor · out of adjustAIRCRAFT WAS NOT GROUNDED: AT THE GATE, THE ECAM MESSAGE DOOR LEFT OVERWING EXIT REPEATEDLY APPEARS. MAINTENANCE ADJUSTED LEFT OVERWING EXIT DETECTOR PROXIMITY SWITCH 31WN AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-71-00.SDR AALA202507026676Shim · migratedAIRCRAFT IN BASE MAINTENANCE: VERTICAL STABILIZER, RIGHT HAND REAR SPAR TERMINAL FITTING SHIM WASHER MIGRATING OUT FROM THE AFT SIDE OF THE OUTBOARD LUG. INSTALLED A NEW SHIM AND REINSTALLED THE BOLT AND NUT. PER AMM 55-30-00-400-801.SDR SWAA2025070184318Handle · looseL1 DOOR ASSIST HANDLE VERY LOOSE<[01] SECURED L1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-11-31;[02] SECURED L1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-11-31.SDR SWAA2025070184319Handle · looseR1 DOOR ASSIST HANDLE ON G1 IS LOOSE. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.