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 DALA2025111708375Battery Pack · inoperativeON S/C FOUND OVERHEAD EMERGENCY LIGHTS OUT ABOVE SEAT ROW 11-15. R & R THE BATTERY PACK IAW AMM 33-51. CHKD GOOD.SDR DALA2025111708372Battery Pack · no testON SVC CHECK, FWD ENTRY DOOR EMERGENCY LIGHTS INOPERATIVE. R & R THE EMERGENCY LIGHT BATTERY PACK IAW AMM 33-51.SDR DALA2025111708371Slide · low pressureDURING SVC CHECK, FOUND R2 DOOR SLIDE PRESSURE OUT OF LIMITS. R & R R2 DOOR SLIDE PER AMDS WORK CARD 2560-4428 AND AMM 25.SDR SWIA2025111676591Intercostal · corrodedPAX DOOR DD7A INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR DD7A INTERCOSTAL IAW SRM 51-42-06-001-001-A01, REV 38, AND DWG 601R31702, REV N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025111676589Intercostal · corrodedPAX DOOR MID DD4 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED A NEW MID DD4 INTERCOSTAL IAW SRM 51-42-06-001-001-A01, AND SRM 51-42-21-001-001-A01, REV 38 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025111676578Intercostal · corrodedPAX DOOR FWD DD3 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR FWD DD3 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2026070676565Former · corrodedPAX DOOR FORMER F/S 320.163 IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR FORMER F/S 320.163 AND NEW CLIP IAW SRM 51-42-21-001-001-A01 AND SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD ATSDR SWIA2026070676557Former · corrodedPAX DOOR AFT FORMER IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR AFT FORMER IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 REV. 38 AND DWG 601R31702 REV. N. COMPILED WITH SKYCARD 51-900-1002-SKY.SDR SWIA2025111676553Intercostal · corrodedPAX DOOR AFT DD5 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW AFT DD5 INTERCOSTAL INTERCOSTAL IAW SRM 51-42-06-001-001-A01 REV. 38 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2026070676552Cleat · corrodedPAX DOOR QTY 2 CLEATS COMMON OF FWD DD4 INTERCOSTAL ARE CORRODED. REMOVED AND INSTALLED QTY 2 NEW CLEATS COMMON TO FWD DD4 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N AND COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025111676546Skin · scratchedPAX DOOR OUTER SKIN AT UPPER END HAS MULTIPLE SCRATCHES. REPAIRED PAX DOOR OUTER SKIN AT UPPER END IAW REO 690-52-11-1116 REV. - STEPS 1, 2, 3, 4 AND COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2026070676537Intercostal · corrodedPAX DOOR AFT DD3 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW INTERCOSTAL AFT DD3 IAW SRM 51-42-06-001-001-A01 REV. 38, AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025111676523Intercostal · corrodedPAX DOOR AFT DD4 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR INTERCOSTAL AFT DD4 IAW SRM 51-42-06-001-001-A01 REV.38 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA2026070676512Intercostal · corrodedPAX DOOR FWD DD2 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW FWD DD2 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702, REV N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD AT THIS TIME.SDR SWIA2025111676496Intercostal · corrodedPAX DOOR MID DD6 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW MID DD6 INTERCOSTAL AND QTY 2 CLEATS IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, REV. 38. AND DWG 601R31702, REV N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOSDR SWIA2025111676459Intercostal · corrodedPAX DOOR FWD DD5 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW PAX DOOR FWD DD5 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N. COMPLIED WITH SKY TRACK TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025111676449Intercostal · corrodedPAX DOOR MID DD2 INTERCOSTAL IS CORRODED. REMOVED AND INSTALLED NEW MID DD2 INTERCOSTAL IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 REV. 38 AND DWG 601R31702 REV. N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2025111676447Intercostal · corrodedPAX DOOR AFT DD2 INTERCOSTAL IS CORRODED. REMOVED CORRODED INTERCOSTAL AND INSTALLED NEW INTERCOSTAL AFT DD2 IAW CRJ 900 SRM 51-42-06-001-001-A01 AND DWG 601R31702 REV. N, COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOODSDR VNAA20260511003Stringer · corrodedSTGR 20L IS CORRODED BETWEEN F.S. 349 TO F.S. 364. REMOVED CORROSION AT STGR 20L BETWEEN FS349 TO FS364 FOUND TO BE OUT OF LIMITS NO DAMAGE ALLOWED AT STRINGER 20L IAW CRJ 700 SRM 53-21-03-101-001-A01. PERFORMED STGR 20L SPLICE REPAIR IAW REO 670-53-21-2774 RSDR SWIA2026030275403Stringer · corrodedAVIONICS BAY STR 24R HAS SIGNS OF CORROSION BETWEEN F.S333-F.S409. PERFORMED REPAIR ON STGR 24 RH BETWEEN F.S 333.00 TO F.S 437.00 IAW SRM 53-21-03, SRM 53-00-03, SRM51-42-06, SRM 51-42-13, SRM, SRM 51-42-21, SRM 51-21-11, SRM 51-21-06, SRM 51-25-06, SRM 51-2SDR SWIA2025111675267Lintel · crackedPAX DOOR LINTEL HAS POSSIBLE CRACK AT THE FS.280.00 BULKHEAD. REPAIRED THE PAX DOOR LINTEL, APPROX BS 280 BULKHEAD IAW REO 670-53-21-493, REV D. AND SB 670BA-53-040, PART B, REV C. COMPLIED WITH ALL STEPS OF REO 670-53-21-493, REV D. COMPLIED WITH SKYWESTSDR ASAA2025111663912Frame · crackedRIGHT FRAME, BS 500C IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A004. GROUNDED - YES. REPAIRED RT FRAME ON BS 500C IAW EA AD20241807-700F-25-202 REV A.SDR ASAA2025111663911Frame · crackedLEFT FRAME, BS 867 IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A009. GROUNDED - YES. REPAIRED FRAME IAW EA AD2024 1807-700F-101.SDR ASAA2025111663910Frame · crackedRIGHT FRAME, BS 400 IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A001. GROUNDED - YES. REPAIRED FRAME IAW EA AD20241807-700F-25-101.SDR ASAA2025111663909Frame · crackedLEFT FRAME, BS 747 CRACKED AT INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A008. GROUNDED - YES. REPARIED FRAME IAW EA AD20241807-700F-25-101.SDR ASAA2025012663908Frame · crackedRIGHT FRAME, BS 440 IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A002. GROUNDED - YES. REPAIRED THE FRAME IAW EA AD 20241807-700F-25-202, REV-.SDR ASAA2025111663907Frame · crackedRIGHT FRAME BS 500A IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A003. GROUNDED - YES. REPAIRED RT FRMAE ON BS 500A IAW EA AD20241807-700F-25-102, REV-.SDR ASAA2025111663906Frame · crackedLEFT FRAME BS 727D IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A007. GROUNDED - YES. REPAIRED FRAME IAW EA AD20241807-700F-25-101.SDR ASAA2025111663905Frame · crackedRIGHT FRAME BS 827 IS CRACKED AT THE INBD FASTENER HOLE FOR REMOVED ACFT RAIL BRACKET.262A005. GROUNDED - YES. REPARED THE FRAME IAW EA AD20241807-700F-25-101.SDR KY72026F00002Bushing · wornRIGHT MAIN GEAR INNER DOOR OPENS ON EVERY LANDING. # 3 MLG DOOR HINGE BUSHINGS FOUND TO BE WORN. R&R ALL ASSOCIATED BUSHING AND ADJUSTED #3 MLG DOOR IAW SA227 66 MM 52-80-10 RTS GOOD.SDR SWAA2025121835677Skin · delaminatedDELAMINATION ON UPPER & LOWER SKIN INBD EDGE OF LT WING OTBD AFT FLAP. REPAIRED UPPER AND LOWER SKIN INBD EDGE OF LT WING OTBD AFT FLAP IAW EA 25-157-03324.SDR SWAA2025121735664Sidewall Support · crackedFWD CARGO BAY FLOOR TO SIDEWALL SUPPORT CRACKED, BS 500B -1, RBL 24. REMOVED AND REPLACED THE SUPPORT BS 500A - 500B, RBL 24, WL 156 IAW SRM 51-40-02, AND DWG 143A7505 REV D.SDR SWAA2025121735665Sidewall Support · deformedFWD CARGO BAY FLOOR TO SIDEWALL SUPPORT HAS OVERSIZE DEFORMED HOLES AT BS 500B +7, RBL 24. REMOVED AND REPLACED THE SUPPORT IAW SRM 51-40-02, AND DWG 143A7505 REV D.SDR SWAA2025121735666Attach Angle · corrodedAFT CARGO DOOR SURROUND STRUCTURE, FWD SHIELD TO FRAME ATTACH ANGLE HAD CORROSION, BS 767, RBL 23. R & R THE FWD SHIELD ANGLE IAW SRM 51-40-02, & DWG 1146A0081, REV A.SDR IPXA2025121295448Skin · damagedFOUND SCRATCH 3FT AFT OF LH AOA PROVIDING CORRECTED SRM REF UPDATE FOR ASSOCIATED MAINTENIX BARCODE [T3F18E007SYGS] BLENDED GOUGE AT LOCATION 328 BS BETWEEN S22 AND S23 BLENDED DAMAGED AREA PER SRM 51-10-02-0G-0. EVALUATION FOUND HORIZONTAL SCRATCH THAT IS APPSDR AALA202512102122Strip · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RUDDER LOWER TRAILING EDGE APEX STRIP. REPAIRED APEX STRIP PER SRM 55-41-19-300-04.SDR AALA202512082614Light · no testAIRCRAFT IN BASE MAINTENANCE: CABIN LAV. WALL EMERGENCY LIGHT IS BROKEN AT 3F-1RC, 3F-1LC (FWD) 3F-1LC (AFT). MAINTENANCE REPLACED EMERGENCY LIGHT AT CABIN LAV WALL 3F-1RC AND 3F-1LC(FWD, AFT) IAW DMC-B787-A-33-51-06-00A-520A-A/720A-A.SDR AALA202512057411Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON KEEL BEAM LATERAL WEB ON BOTTOM SURFACE AROUND FASTENERS AND CENTER DRAIN HOLE AT BS 868 LBL-4 TO RBL-4. RG-001. PERFORMED PERMANENT REPAIR ON KEEL BEAM LATERAL WEB BOTTOM SURFACE AROUND FASTENERS AND CENTER DRAIN HOLSDR CALA2025120511791Transition Panel · corrodedFWD CARGO BAY LT TRANSITION PANEL FROM BS 500B - 500I CORRODED. REMOVED CORROSION ON FWD CARGO LT TRANSITION PANEL ORIGINAL THICKNESS .040, REMAINING THICKNESS .027, MATERIAL LOSS .013. FOUND TO BE ON OUT OF LIMITS IAW SRM 53-00-53-1A-2. REMOVED TRANSITION SDR CALA2025120511789Transition Panel · corrodedFWD CARGO COMPARTMENT RT TRANSITION PANEL FROM BS 500A - 500G+10 CORRODED. REMOVED AND INSTALLED A NEW TRANSITION PANEL IAW SRM 51-40-02 & SRM 53-00-53-2R-5, REPAIR 5.SDR AALA202512022587Axle · failedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NUMBER 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILST PARKED AFTER 15 MINS ANTI-SKID INOPERATIVE LIGHT CAME ON. SDR AALA202512023881Transducer · failedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NUMBER 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILST PARKED AFTER 15 MINS ANTI-SKID INOPERATIVE LIGHT CAME ON. SDR AALA202512025545Brake Assy · failedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NUMBER 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILST PARKED AFTER 15 MINS ANTI-SKID INOPERATIVE LIGHT CAME ON. SDR AALA202512029170Brake Assy · failedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NUMBER 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILST PARKED AFTER 15 MINS ANTI-SKID INOPERATIVE LIGHT CAME ON. SDR AALA202512028486Wheel · failedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NUMBER 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILST PARKED AFTER 15 MINS ANTI-SKID INOPERATIVE LIGHT CAME ON. SDR AALA202512022205Tire · failedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NUMBER 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILST PARKED AFTER 15 MINS ANTI-SKID INOPERATIVE LIGHT CAME ON. RSDR ASAA2025111662588Floor Panel · puncturedCABIN FLOOR PANEL PN 143A5810-148 PUNCTURED NEAR 4TH INSERT. GROUNDED - YES. FABRICATED NEW PANEL 143A5810-148. IAW ASA B737-800ER SRM 53-00-50-2R-0, DWG 143A5810 REV-, GPM 9.59.SDR AALA202511261538Angle · wornAIRCRAFT IN BASE MAINTENANCE: WEAR TO AFT CARGO COMPARTMENT ZEE ASSEBMLY LOCATED AT BS 727C, S25R. REPLACED ZEE ASSEMBLY PER SRM 53-00-53.SDR S2KA251116412SWAhrs · faultyAHS 1 & 2 FAILURE. HAPPENED IN CRUISE, AHS 1 & 2 ANNUNCIATORS. CAME BACK TO LIFE AFTER WE WERE ALREADY HEADING BACK TO BASE. WHILE TROUBLESHOOTING THIS ISSUE #2 SYMBOL GENERATOR FAILED PN 066-04021-1111 OFF SN 4932, ON SN 2635. BOMBARDIER TECHNICAL SUPPORT RECSDR WX0A2025112432641Packing · leaking(AIRCRAFT GROUNDED) FA REPORTS DIRTY SOCK ODOR IN GALLEYS, ON APPROACH. PERFORMED LEVEL 1 DECONTAM IAW TC A32X-21-000-001 WITH ENGS ONLY. PERFORMED LEVEL A DECONTAM OF ECS IAW AMM 21-00-00-615-802-A. NO ODORS NOTED. WORK PERFORMED IAW AMM 49-00-00-811-200-A