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 UIEA2025080401081Trunnion · damagedRH BODY GEAR WHEEL WELL INBD TRUNNION OTBD AND AFT MOUNTING BOLT HOLE INNER BORES HAVE SCORING(<P>REMOVED SCORING DAMAGE 2 EA INNER BORES PER EA 747 5340-28-B05301R & SRM 53-40-90 REPAIR 1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025080401082Trunnion · damagedRH BODY GEAR WHEEL WELL INBD TRUNNION OTBD AND AFT MOUNTING HOLE INNER BORES HAS SCORING(<P>REMOVED SCORING DAMAGE 2 EA INNER BORES PER EA 747 5340-28-B0538 1R & SRM 53-40-90 REPAIR 1. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2025080401083Trunnion · damagedLH BODY GEAR TRUNNION FITTING FWD MOUNTING HOLE INNER BORE HAS SCORING(<P>REMOVED SCORING PER EA 747 5340-28-B0438 REV 1 & SRM 53-40-90. NO FURTHER DEFECTS NOTED.</P>)SDR CALA2025080407252Autopilot Sys · out of adjustRIGHT TURN BIAS IN FLT. NO MORE THAN 315KIAS. AUTOPLT MADE LONG LFT TURN. RIGHT TURNS NORM. TRIMED OUT TO 4 UNITS WHILE MANUAL FLYING AND STATED STILL ROLLING RIGHT AND MAKING LONG LEFT TURNS. AT 315 KNTS THEY HAD 2 UNITS OF RUDDER TRIM, ALSO STATED DIDNT TSDR CALA2025080407248Light · missingWAS FOUND PROXIMITY LIGHT MISSING AT FURNITURE FROM SEATS POSITION 3D AND 7D. INSTALLED NEW PROXIMITY LIGHTS AT FURNITURE FROM SEATS POSITION 3D AND 7D IAW AMM DMC-B787-A-33-51-06-00A-720A-A. GOOD FOR SERVICE.SDR CALA2025080407247Lens · missingSEAT 15C RED EMERGENCY FLOOR LIGHT LENS MISSING. REPLACED SEAT 15C RED EMERGENCY FLOOR LIGHT LENS REF CMM 25-22-59. LIGHT OPS CHECK GOOD.SDR CALA2025080407246Lens · crackedEMERGENCY FLOOR PROX LIGHT LENS CRACKED AT SEAT 32C. REMOVED AND REPLACED SEAT 32C EMERGENCY FLOOR PROX LIGHT LENS. OPS CHK NORMAL IAW AMM 33-51-11.SDR QMLA2025080420082Latch · wornBATTERY COMPARTMENT LATCH CAME APART FROM DOOR DUE TO EXCESSIVE WEAR ON THE PIN HOLE WEAR AND PIN FALLING OUT. R+R AIRCRAFT BATTERY DOOR. OPS CHECKED GOOD. ALL MAINTENANCE COMPLETED. AIRCRAFT RELEASED TO REVENUE SERVICE. #MEC-013205SDR DALA2025080405805Oxygen Panel · openL, DOOR OXYGEN PANEL OPENED BUT MASKS DID NOT FALL OUT. CLOSED 2L DOOR O2 MASK PANEL.SDR DALA2025080405804Oxygen Mask · unwanted deployOXYGEN PANEL MASK DEPLOYED, DOOR OPENED BUT MASKS DID NOT FALL OUT . 2L DOOR. MASK DID NOT DEPLOY. COVER AT 2L F/A SEAT O2 FELL OPEN. REINSTALLED COVER. A/C OK FOR SERVICE.SDR DALA2025080405802Light · no testEMERGENCY TEST FAILS ON SERVICE CHECK. TEST FAILS EPSU EXT LOAD AFT L 33-51-38. INSPECTED AFT LT SLIDE FOUND LIGHT CONNECTORON INBOARD SIDE OF SLIDE SMASHED / DAMAGED. REMOVED SLIDE PER AMDS CARD 2561-4001-LA. OK TO INSTALL QC5430. INSTALLED SLIDE PER W/C. 25SDR AALA202508037323Window · delaminatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO LAS DUE TO THE FLIGHT CREW REPORTING THAT THE FLIGHT DECK LEFT HAND SIDE NUMBER 3 WINDOW DELAMINATED IN FLIGHT AT 330. THE FLIGHT CREW HEARD A LOUD POP AND BUBBLES APPEARED IN WINDOWSDR 7C7A1900010000021Light · brokenDURING INSTALLING AFT 4 R/H DOOR LINERS FOUND SLIDE LIGHT INDICATOR SWITCH CONNECTOR BROKENSDR 7C7A1900010000020Battery · dischargedEMERGENCY MARKER AT R3 DOOR INOPERATIVE.SDR 7C7A1900010000019Fuse · failedAFT GALLEY R/H SIDE EMERGENCY EXIT MAKER INOPSDR IXXA20250802001Window · inoperativeR2 FLIGHT DECK WINDOW WOULD NOT OPEN DURING THE OPERATIONAL CHECK OF THE EXTERNAL OPENING LATCH.SDR DALA2025111708377Nut Plate · damagedER/A 628114-14; A220-100, RT EMERGENCY EXIT DOOR CUTOUT SURROUND STRUCTURE, FRAME 42. SUBJECT REPAIR REQUIRES FOLLOW-ON ACTION. ACCOMPLISH ER/A 628114-14, SECTION II WITHIN 1,000 FLIGHT HOURS FROM 16,139 TOTAL FLIGHT HOURS. ASSOCIATED ER/A 14-628114. SECTIONSDR JJBA20251111060Retainer · corrodedDURING INSPECTION FOR OK TO INSTALL, FOUND CORROSION ON R/H DV WINDOW RETAINER RING FRAME. REMOVED CORROSION FROM RH DV WINDOW RETAINER RING FRAME. REPLACED DV WINDOWSDR JJBA20251024076Window · crackedRH DV WINDOW CRACKED AT FIRST FASTENER FWD OF LATCH HANDLE. REMOVED AND REPLACED RH DV WINDOW.SDR SWIA2025102000801Skin · corrodedCORROSION AROUND WING PLANK OF ACCESS 510AB. CORRECT LOCATION OF CORROSION IS AROUND ACCESS PANEL 610AB. REMOVED CORROSION AROUND WING PLANK ACCESS PANEL 610AB IAW BOMBARDIER REO 601R-57-21-030. COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORMSDR VNAA20251016001Support Bracket · corrodedCORROSION ON TWO BRACKET SUPPORT OF THE LEFT MLG WHEEL BIN. CORROSION ON BRACKET SUPPORT OF THE LEFT (1EA) (LBL 45) MLG WHEEL BIN WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN LIMITS PER CRJ-900 SRM 53-00-01-101-001-A01 // BRACKET SUPSDR VNAA20251015020Nut Plate · corrodedCORROSION ON NUT CHANNEL IN THE LH/RH MLG WHEEL WELL STRUCTURE, NEXT TO THE MLG UPLOCK. CORROSION ON NUT CHANNEL IN THE LH/RH MLG WHEEL WELL STRUCTURE, NEXT TO THE MLG UPLOCK WAS EVALUATED EXCESIVE DAMAGE PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER SDR VNAA20251015012Channel · corrodedCORROSION ON GANG CHANNEL AT LH/RH WINGS. CORROSION ON GANG CHANNEL AT LH/RH WINGS WAS EVALUATED DUE TO EXCESIVE DAMAGE PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER CRJ900 SRM 51-41-02-001-001-A01SDR VNA2025F00038Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB LH SIDE FS193 AT FWD EQUIPMENT COMPARTMENT. CRACK ON ELECTRICAL BAY FLOOR WEB LH SIDE FS193 AT FWD EQUIPMENT COMPARTMENT WAS REPAIRED PER CRJ-900 SRM 53-11-43-201-001-A01SDR VNAA202509260009Seal Rest · corrodedCORROSION ON SEAL REST WAS FOUND. SEALS REST WERE CLEANED PER CRJ-700 SRM 51-26-00-001-001-A01 AND FWD CORNER SEAL RETAINER BAGG DR NO CORROSION WAS FOUND ALSO RETAINER SEAL MID SECTION AND RETAINER SEAL AFT CORNER WERE REPLACED PER CRJ- 700 SRM 51-42-06-00SDR SWIA2025F01366Doubler · crackedPASSENGER DOOR AFT PULL CAM DOUBLER POSSIBLE CRACK. (C-CHECK RO 09/24/2025)REPLACED PASSENGER DOOR NEW AFT PULL CAM DOUBLER, REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. AND COMPLIED WITH TASK CARD 51-900-1003-SKYSDR SWIA2025F01365Cleat · corrodedPASSENGER DOOR 2EA CLEATS BETWEEN FS329.41 FORMER AND FS335.763 FORMER IS CORRODED. (C-CHECK RO 09/24/2025)REPLACED WITH NEW PAX DOOR 2EA CLEATS BETWEEN FS329.41 FORMER AND FS335.763 FORMER REF. DRWG 601R31702 REV. N AND CRJ 200 SRM 51-42-06 AND COMPLIED WITHSDR SWIA2025F01364Former · corrodedPASSENGER DOOR FS 329.76 FORMER IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR FS 329.76 FORMER REF. DRWG 601R31702 REV. N AND CRJ 200 SRM 51-42-06. COMPLIED WITH SYKWEST TASK CARD 51-900-1003-SKY. PERFORMED PRESSURIZATION/LESDR SWIA2025F01363Intercostal · corrodedPASSENGER DOOR AFT DD7 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR AFT DD7 INTERCOSTAL, REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39: MAR 10/2021. COMPLIED WITH SYKWEST TASK CARD 51-900-SDR SWIA2025F01335Intercostal · corrodedPASSENGER DOOR AFT DD4 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025) REMOVED AND REPLACED BY NEW PASSENGER DOOR AFT INTERCOSTAL DD4, AND CLEAT REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. . COMPLIED WITH SYKWEST TASK SDR SWIA2025F01334Intercostal · corrodedPASSENGER DOOR AFT DD3 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BYE NEW INSTALLED PASSENGER DOOR AFT INTERCOSTAL DD3 AND BRACKET, REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. COMPLIED WITH SYKWSDR SWIA2025F01333Intercostal · corrodedPASSENGER DOOR AFT DD2 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR AFT INTERCOSTAL DD2 , REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. COMPLIED WITH SYKWEST TASK CARD 51-900-SDR SWIA2025F01332Intercostal · corrodedPASSENGER DOOR MID DD3 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025) REMOVED AND REPLACED BY NEW PAX DOOR INTERCOSTAL DD3 MID REF. DRWG 601R31702 REV. N AND CRJ 200 SRM 51-42-06. PERFORMED PRESSURIZATION OF THE AIRCRAFT NO LEAKS NOTED ON PASSENGER DOORSDR SWIA2025F01331Attach Fitting · gougedL/H WING AFT ATTACHMENT FITTING AT WS220.0 HAS GOUGING ON THE I/B OF THE TWO CENTER LUGS. (MARKED) (S/N#00605) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGES TO SMOOTH CONTOUR ON L/H WING AFT ATTACHMENT FITTING FOR HINGE BOX WS220.0 AT I/B CENTER LUG REF. CRJ2SDR SWIA2025F01362Attach Fitting · gougedL/H WING AFT ATTACHMENT FITTING AT WS178.0 HAS GOUGING ON THE CENTER TWO LUGS. (MARKED) (S/N#00604) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGES TO SMOOTH CONTOUR ON L/H WING AFT ATTACHMENT FITTING FOR HINGE BOX WS178.0 AT I/B AND O/B CENTER LUGS REF. CRJ200 SRSDR SWIA2025F01361Attach Fitting · gougedL/H WING AFT ATTACHMENT FITTING AT WS264.0 HAS GOUGING ON THE CENTER TWO LUGS. (MARKED) (S/N#00603) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGES TO SMOOTH CONTOUR ON L/H WING AFT ATTACHMENT FITTING FOR HINGE BOX WS264.0 AT I/B AND O/B CENTER LUGS. REF. CRJ200 SSDR SWIA2025F01360Attach Fitting · gougedR/H WING AFT ATTACHMENT FITTING AT WS220.0 HAS GOUGING ON THE CENTER TWO LUGS. (MARKED) (S/N#00601) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGES TO SMOOTH CONTOUR ON R/H WING AFT ATTACHMENT FITTING FOR HINGE BOX WS220.0 AT I/B AND O/B CENTER LUGS REF. CRJ200 SRSDR SWIA2025F01359Attach Fitting · gougedR/H WING AFT ATTACHMENT FITTING AT WS178.0 HAS GOUGING ON THE CENTER TWO LUGS. (MARKED) (S/N#) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGES TO SMOOTH CONTOUR ON R/H WING AFT ATTACHMENT FITTING FOR HINGE BOX WS178.0 AT I/B AND O/B CENTER LUGS REF. CRJ200 SRM 51-SDR SWIA2025F01358Doubler · crackedPASSENGER DOOR FWD PULL CAM DOUBLER POSSIBLE CRACK. (C-CHECK RO 09/24/2025)REPLACED WITH NEW PASSENGER DOOR NEW FWD PULL CAM DOUBLER, REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. AND COMPLIED WITH TASK CARD 51-900-1003-SKYSDR SWIA2025F01357Intercostal · corrodedPASSENGER DOOR AFT DD5 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR AFT INTERCOSTAL DD5, REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. COMPLIED WITH SYKWEST TASK CARD 51-900-1SDR SWIA2025F01356Intercostal · corrodedPASSENGER DOOR AFT DD1A INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR AFT INTERCOSTAL DD1A, REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021. COMPLIED WITH SYKWEST TASK CARD 51-900-SDR SWIA2025F01355Intercostal · corrodedPASSENGER DOOR FWD DD6 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR FWD INTERCOSTAL DD6 AND BRACKET REF. REF. DWG 601R31702, REV. N, REF. CRJ-200, SRM 51-42-06, REVISION 39, MAR 10/2021, COMPLIED WITH SYKWEST TSDR SWIA2025F01354Intercostal · corrodedPASSENGER DOOR FWD DD5 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR FWD DD5 INTERCOSTAL AND BRACKET, REF. DWG 601R31702, REV. N, CRJ-200 SRM 51-42-06 AND CRJ200 SRM 51-42-21 REVISION 39, MAR 10/2021. PERFORMED SDR SWIA2025F01353Intercostal · corrodedPASSENGER DOOR MID DD2 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025) EVALUATED PASSENGER DOOR MID DD2 INTERCOSTAL ORIGINAL MATERIAL THICKNESS IS 0.050" REF. CRJ-200, SRM 52-10-14, CORROSION FOUND ON MULTIPLE ELEMENTS, ALLOWABLE DAMAGE IS PERMITTED IN ONLSDR SWIA2025F01352Attach Fitting · gougedR/H WING AFT ATTACHMENT FITTING AT WS264.0 HAS GOUGING ON THE CENTER TWO LUGS. (MARKED) (S/N#00602) (C-CHECK RO 09/24/2025)BLENDED-OUT DAMAGES TO SMOOTH CONTOUR ON R/H WING AFT ATTACHMENT FITTING FOR HINGE BOX WS264.0 AT I/B AND O/B CENTER LUGS. REF. CRJ200 SSDR SWIA2025F01351Intercostal · corrodedPASSENGER DOOR MID DD1 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PAX DOOR INTERCOSTAL DD1 MID REF. DRWG 601R31702 REV. N, CRJ 200 SRM 51-42-06 AND CRJ 200 SRM 51-42-21. PERFORMED PRESSURIZATION/LEAK CHECK OF PASSENGER DOOR SDR SWIA2025F01350Intercostal · corrodedPASSENGER DOOR MID DD1A INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025) EVALUATED PASSENGER DOOR MID DD1A INTERCOSTAL ORIGINAL MATERIAL THICKNESS IS 0.050" REF. CRJ-200, SRM 52-10-14, CORROSION FOUND ON MULTIPLE ELEMENTS, ALLOWABLE DAMAGE IS PERMITTED IN ONLSDR SWIA2025F01349Intercostal · corrodedPASSENGER DOOR MID DD6 INTERCOSTAL IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PAX DOOR INTERCOSTAL DD6 MID. REF. DRWG 601R31702 REV. N, CRJ 200 SRM 51-42-06 AND CRJ 200 SRM 51-42-21. COMPLIED WITH SYKWEST TASK CARD 51-900-1003-SKY. PESDR SWIA202509250801Former · corrodedPASSENGER DOOR FS 329.41 FORMER IS CORRODED. (C-CHECK RO 09/24/2025)REMOVED AND REPLACED BY NEW PASSENGER DOOR INTERCOSTAL FS 329.41 FORMER REF. REF. DWG 601R31702, REV. N, CRJ-200, SRM 51-42-06 AND CRJ-200, SRM 51-42-21. PERFORMED PRESSURIZATION/LEAK CHECK OSDR VNAA202509250023Seat Track · corrodedCORROSION ON SEAT RAIL AT RBL9 (03) SEGMENTS: (01) FS375 - FS485. (02) FS485 - FS581. (03) FS581 - FS677. OF THE PAX CABIN.. SEAT RAILS AT RBL9 (03) SEGMENTS: (01) FS375 - FS485. (02) FS485 - FS581. (03) FS581 - FS677. OF THE PAX CABIN. WERE EVALUATE OUT LI