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 DALA2025121809210Relay · faulted(LOG 1356741) CREW REPORTED BURNING ELECTRICAL ODOR OCCURRED TWICE AROUND ROWS 12-13. R/R L RECIRC FAN RELAY AND BOTH RECIRC FILTERS. REF B737 AMM 21-25. OPS CKS GOOD WITH NO SMELL PRESENT.SDR DALA2025121809213Battery Pack · no testDURING SVC CHECK WALK AROUND FOUND BOTH LEFT WING EMERGENCY EXIT DOOR EMER LIGHTS INOP, LEFT WING AFT WING ROOT EMER LIGHT INOPERATIVE. R & R BATTERY PACKS AT ROWS 11ABC AND 25ABC REF B737 AMM 33-51. ALL DISCREPENT LIGHTS NOW OPERABLE.SDR AALA202512185611Bulb · no testAIRCRAFT WAS NOT GROUNDED: CABIN CEILING EMERGENCY LIGHT AT ROW 18 INOP. MAINTENANCE RE-LAMPED CABIN CEILING EMERGENCY LIGHT AT ROW 18 IAW AMM 33-51-11.SDR K11A2025121800364Handle · out of positionFWD ENTRY DOOR WARNING LIGHT ILLUMINATED JUST AFTER TAKEOFF. FOUND DOOR HANDLE IN CLOSED POSITION BUT LOOSE. OPENED AND CLOSED DOOR MULTIPLE TIMES WITH NO DEFECTS NOTED. WORK PERFORMED IAW AMM 52-11-00SDR SWIA2026070606541Stringer Splice · corrodedSTRINGER SPLICE AT STR20R AND FS477 IS CORRODED. REMOVED AND INSTALLED NEW STRINGER SPLICE ON STR20R AT FS477 IAW SRM 51-42-21-001-001-A01, SRM 51-42-06-001-001-A01 AND DWG SH690-30006 REV C. PERFORMED LEAK CHECK IAW SRM 51-23-03-001-001-A01. LEAK CHECK GOODSDR SWIA2025121776533Seat Track · corrodedUPON REMOVAL OF SEAT RAIL AT RBL9 BETWEEN FS838.00 TO FS852.00 FLOORBEAM FOUND TO BE CORRODED. REMOVED AND INSTALLED NEW FLOOR BEAM SECTION AT RBL 9 F/S 847 TO F/S 847+56 UNDER SEAT RAIL AT RBL9 BETWEEN FS838.00 TO FS852.00 IAW SRM 53-00-41-201-001-A03. CSDR SWIA2025121776360Rib · crackedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA93275-601R-57-51-1052 REV -. COMPLY WITH PERMANENT REPAIR ON RA ID: 93275THE LHS WING TE RIB AT WS130.10 HAS BEEN REPAIRED DUE TO BEND AND CRACK DAMAGE PER REO 601R-57-51-1052 REV -- DATED 2024-08-29. PERMANENT REPAIRSDR SWIA2025121776359Cover · openCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA104215-REO 601R-53-61-8367 COMPLIED WITH PERMANENT REPAIR FOUND DAMAGE FROM LOW PRESSURE AIR CAP MISSING. SUSPECTED GROUND AIR COVER LEFT OPEN. REFERENCE AML 1675134COMPLIED WITH REO 601R-53-61-8367 STEPS 1 AND 2 PESDR SWIA2025121776358Frame · corrodedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA94505-601R-53-61-8235 MXCODEID105229-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 94505CW TEMPORARY DISPOSITION: FOR BLENDED CORROSION DAMAGE TO FRAME ASSY. FS589.00 ASSY. BETWEEN STR 21R - STR 22R. PERMANENT REPAIR: SDR VNAA20260511021Angle · corrodedAFT FUSELAGE FAIRING SUPPORT WEB IS CORRODED ON THE FWD FACE AT FS 939. INSTALLED NEW SERVICEABLE CENTER ANGLE PN: SH670-39189-1 ON AFT FUSELAGE FAIRING SUPPORT WEB AFT FACE AT FS 939 IAW CRJ700 SRM 51-42-06-001-001-A01 AND SRM 51-42-15-001-001-A01.SDR VNAA20260511006Bracket · corrodedBRACKET IS CORRODED AT STRINGER 22R AND F.S.285. INSTALLED BRACKET P/N SH670-96034-5 AT STRINGER 22R FS 285 IAW SRM 51-42-001-001-A01.SDR VNAA20260511005Frame · corrodedFRAME SECTOR AT F.S.319 IS CORRODED AT STRINGER 21L. INSTALLED NEW FRAME AT FS 319, P/N SH670-31891-3, IAW SRM 51-42-06-001-001-A01.SDR VNAA20260511004Floorbeam · corrodedAVI FLOORBOARD SUPPORT ANGLE ON THE F.S.280 FRAME IS CORRODED. REMOVED AND REPLACED AVI FLOORBOARD ANGLE ON FS280 FRAME IAW SRM 51-42-21-001-001-A01, SRM 51-42-13-001-001-A01, AND SRM 51-42-06-001-001-A01.SDR SWIA2025121775805Skin · gougedEXTERIOR LOWER SKIN PANEL HAS NUMEROUS DEEP GOUGES ABOVE AND AFT OF PNL 172 BR, GROUND AIR CONDITIONING CONNECTION. REMOVED 14EA GOUGE DAMAGE ON EXTERIOR LOWER SKIN AREA FROM FS589 TO FS605 AND STGR 26R TO STGR 20R APROX. REF. SRM 51-12-00 AND REPAIRED DENTS SDR SWIA2025121775491Floorbeam · fomREMOVE FLOORBEAM SECTION AT FS280 LBL12 FOR ACCESS (C-CHECK RO 03/08/2026)PERFORMED REPAIR TO CENTER COCKPIT FLOOR BEAM AT LBL12 IAW CRJ700 AMM 20-70-00, SRM 51-42-06, 51-42-21, 51-21-11, 51-25-06, 51-25-16, BOMBARDIER REO 670-53-11-896, REV --.SDR 2026FA0000090Nozzle · fodDURING ENGINES DISASSEMBLY AT VILLAROCHE SHOP (FRANCE), DICOVERY OF FOD MATERIAL INTO INTERNAL CAVITIES OF HPT NOZZLE, . INCORRECT ASSY OR INSTALLATION OF COMPONENTS OF THE ACFT, FOUND DURING AN INSPECTION OR TEST PROCEDURE NOT INTENDED FOR THAT SPECIFIC PURPOSDR NACA2025121700002Actuator · faultedLEFT ENGINE FUEL SHUT OFF SPAR VALVE STUCK DURING OPS CHECK.. R & R SHUTOFF VALVE ACTUATOR IAW AMM 28-22-11-404-008, STEP 3 G.14. NO DEFECTS NOTED ON OPS CK.SDR 4GIA2026012700000Bracket · crackedLEFT & RIGHT AFT MOUNT BRACKETS ON STRAKES CRACKED/BROKEN. LH PN: 553-26-12-375 RH PN: 553-26-12-376.SDR SWAA2026012653447Web · corrodedCORROSION ON SHIELD WEB, BTWN BS 500 - 500A, RBL22, WL 156.1 IN THE FWD CARGO BAY. REPLACED SHIELD WEB AND FASTENERS IAW SRM 51-10-02, ITEM 9, AND DWG 143A0080, SHEET 39, REV-.SDR SWAA2026012653439Frame · crackedCRACKED FRAME, BS 312, BTW S5 - 6L IN THE FWD GALLEY AREA. PERFORMED A REPAIR ON THE FRAME IAW EA M-22-153-01244. LENGTH OF CRACK: 0.840.SDR SWAA2026012653446Angle · crackedCRACKED ANGLE, FWD FACE, BS 500H, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, DWG 143A7505, SHEET 139, REV -.SDR SWAA2026012353441Support Beam · crackedCRACK SUPPORT BEAM NR 4 ON THE FWD GALLEY DOOR. REPLACED THE SUPPORT BEAM IAW SRM 51-40-02, SRM 51-10-02, AND DWG 141A6516, SHEET 142, REV -.SDR HNAA2026012300079Support Bracket · crackedSTALL WARNING COMPUTER SUPPORT BRACKETS CRACKED. R & R SUPPORT BRACKETS IAW SRM 51-40-02SDR SWAA2026012253440Tie Clip · crackedCRACKED TIE CLIP, BS 277, STR 10R IN THE FWD GALLEY. REPLACED THE TIE CLIP AND FASTENERS IAW SRM 51-40-02, AND DWG 141A1110, SHEET 55, REV -.SDR SWAA2026012253323Support Angle · crackedCRACK ON SUPPORT ANGLE BTW BS 380 - 400, LBL 52, WL 208.1. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02, SRM 51-40-02, AND DWG 143A5400, SHEET 183, REV-.SDR SWAA2026012253445Angle · crackedCRACKED ANGLE LOCATED AFT FACE, BS 500H, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, & DWG 143A7505, SHEET 139, REV-.SDR SIMA202601197001Skin · gougedSSI # 53-10-016 FOUND TWO GOUGES ON EXTERIOR SIDE OF SKIN LOCATED BETWEEN FR17 AND FR18 AT STGR 27R. (MAJOR REPAIR). PERFORMED PERMANENT REPAIR TO 2 GOUGES ON EXTERIOR SIDE OF SKIN LOCATED BETWEEN FR17 AND FR18 AT STGR 27R IAW ERS-EJ-53MR-SDR NACA2025121700001Shutoff Valve · stuckAPU ECU SELF TEST SHOWS FAULT - IGV ACT. PERFORMED APU ECU BITE TEST IAW AMM 49-61-05-742-045. NO FAULTS FOUND. BITE TEST PASSED. FOUND APU SHUTOFF VALVE STUCK IN CLOSED POSITION. RELEASED THE VALVE, SYSTEM CHECKED OK IAW AMM 49-11-00-802-002.SDR SWAA2026011253532Battery Pack · no testFUNCTIONAL CHECK ALL EMERGENCY LIGHTS, ALL EMERGENCY LIGHTS TEST GOOD LESS LIGHTS COMMON TO M1695 BATTERY PACK. IAW AMM 33-51-00-710-801.SDR SWAA2026010753312Battery Pack · inoperativeRT OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. INSPECTED IAW AMM 33-51-06-960-805-NG. POWER SUPPLY - BATTERY PACK REPLACEMENT.SDR CALA2026010712733Floorbeam · corrodedMAIN CABIN BS 986, RBL 38 - 41 HAS CORROSION ON UPPER SURFACE. REPAIRED CORRODED T-FITTING WITH ANGLES STRAPS AND NEW T-FITTING FROM RBL 50 TO LBL 50 IAW SRM 53-70-51-2R REPAIR 4.SDR J7SA2026010600465Fce · faultedDURING CRUISE, CREW RECEIVED SWPS FAULT, FLAP FAIL, PTRIM BKP FAIL AND SPOILER FAULT. THE FLAPS WERE RETRACTED AT THE 0 POSITION. CAS MESSAGES REMAINED ON FROM CRUISE, LANDING AND SHUTDOWN. REPLACED FCE #1 AND OPS/RIGGED TESTED WITH NO FURTHER DEFECTS IAW PHENSDR AALA202601068011Latch · damagedAIRCRAFT IN BASE MAINTENANCE: CABIN OFAR AFT ESCAPE DOOR LATCHES DAMAGED (1EA) HARD TO OPEN. MAINTENANCE REPLACED CABIN OFAR AFT ESCAPE DOOR LATCHES (1EA) IAW GPM SECTION 17.11, BOEING AMM DMC-B787-A-20-11-00-00A-030A-A TW ID DUE 03/25/2026 ID 25-128.SDR AALA202601066382Latch · damagedAIRCRAFT IN BASE MAINTENANCE: CABIN OFAR FWD ESCAPE DOOR LATCHES DAMAGED (2EA). MAINTENANCE REPLACED CABIN OFAR FWD ESCAPE DOOR LATCHES (2EA) IAW GPM SECTION 17.11, BOEING AMM DMC-B787-A-20-11-00-00A-030A-A TW ID DUE 03/25/2026 ID 25-128.SDR AALA202601067217Latch · damagedAIRCRAFT IN BASE MAINTENANCE: CABIN OFAR FWD ESCAPE DOOR LATCHES DAMAGED (2EA). MAINTENANCE REPLACED CABIN OFAR FWD ESCAPE DOOR LATCHES (2EA) IAW GPM SECTION 17.11, BOEING AMM DMC-B787-A-20-11-00-00A-030A-A TW ID DUE 03/25/2026 ID 25-128.SDR SWAA2025123053370Battery Pack · inoperativeRIGHT OVERWING EMERGENCY EXITS SIGNS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06-960-805-NG.SDR CALA2025123012519Floorbeam · corrodedFOUND CORROSION FWD WET AREA FLOORBEAM UNDER SEAT TRACK END, BS 344, LBL 57. ACCOMPLISHED REPAIR, INSTALLED 100% OF FASTENERS ON FLOORBEAM REPAIR, BS 344, LBL 15 - 66 IAW SRM 53-10-51-2R-10, STEP 4.SDR SWAA2025122953304Power Supply · inoperativeLEFT EMERGENCY EXIT LIGHT INOP IN CABIN AT BS639. R&R BATTERY PACK FOR POWER SUPPLY M1670 IAW AMM 33-51-06. OPS CHECK GOOD.SDR CALA2025122912507Skin · crackedONE CRACK SIGNAL NOTED L=0.450 INCH AT STAB RH SIDE STA129.50 LOC ATED TO 10.375INCH FWD FROM REAR SPAR. PERFORMED PERMANENT REPAIR AT RT HORIZONTAL STAB AT STAB STA 129.50 AND 10.375 IAW SRM 55-10-01-2R-11SDR CALA2025122912459Bulkhead Web · crackedLH VAPOR BARRIER WEB FOUND CRACKED REQUIERES FABRICATION. FABRICATED, LOCATED, AND DRILLED NEW DOUBLER APPLIED ALODINE AND PRIMER IAW SRM 51-40-05-0G-0, DWG 111A1511 REV: B, DWG: 111A1001 REV -, AMM 51-21-41-370-802 51-21-72-370-804.SDR SWIA20251223017Engine · failedRIGHT ENGINE OIL PRESSURE WARNING MESSAGE IN FLIGHT. LEAD TO LOSS OF ENGINE INFLIGHT HAD TO RETURN TO TUS SINGLE ENGINE LANDING. (FLIGHT 6088) REPLACED RT ENGINE WITH SERVICABLE ENGINE IAW AMM 71-00-00-400-801-A02. OPS CHECKED GOOD. LEAK CHECKED GOOD. COMPLSDR DALA2025122309355Shutoff Valve · faultedMISC - DECLARED EMERGENCY DUE TO "R BLEED FAIL" AND "ALPHA LIMIT" MESSAGES WHILE IN ICING. REPLACED THE HIGH PRESSURE SHUT OFF VALVE. (LP# 7694666)SDR DALA2025122309354Seal · leakingSHIP 8117 RETURNED TO SAT DUE TO ODOR IN CABIN. FOUND OIL IN #2 SPINNER. REPLACED SEAL REF PW1000G-A-72-00-11. WHILE PERFORMING P-TRAK PROCEDURE PER WORK CARD 0550-2001, FOUND PARTICULATE MATTER READINGS INCONCLUSIVE TO DEFINITE SOURCE. DUE TO HISTORY ON #1 SDR DALA2025122309345Pan · corrodedSHIP 9569 AFT CARGO DOOR AND FRAME: CORROSION AT DOOR PAN AREA AROUND FASTENERS. CORRECTIVE ACTION: REPAIRED PER B717-200 SRM 53-20- 15-2R (1355626)SDR DALA2025122309343Slide · dislodgedOPS REPORTS R1 DOOR SLIDE DISLODGED. DOOR SLIDE IAW AMM 25-61. ACFT OK FOR SERVICE. (8406508)SDR DALA2025122309339Servo Motor · faultedATO- APPROX. 5 KNOTS DUE TO LEFT THROTTLE DID NOT ADVANCE WHEN TOGA SELECTED. FORWARD TO MEL VIA FLIGHT CREW PLACARD. RECORDED FAULT CODE 22-31687 (ASM-1 RATE MON). NEED ASM-1 REPLACED. CONTINUE ON MEL. 22DEC25 REPLACED LEFT AUTO THROTTLE SERVO MOTOR PER B73SDR AALA202512239756Control Rod · out of adjustAIRCRAFT IN BASE MAINTENANCE: L1 ENTRY DOOR REQUIRES EXCESSIVE FORCE TO OPEN DOOR AND CLOSE FROM OUTSIDE. ADJUSTED THE HORIZONTAL CONTROL ROD PER AMM 52-11-00.SDR SWAA2025122253197Rib · cracked#1 ENG OUTER LINER HAS ONE CRACK THAT GOES ACROSS 3 AND A HALF PANELS AT S10 (RIGHT IGNITOR). COLD SIDE INSPECTION SHOWS RIBS 4;5 AND 6 ARE CRACKED. OKAY TO CONTINUE; CIS FOR 25 CYCLES FOR ENGINE REPLACEMENT PER AMM 72-00-00-200-805-F00. REF TSR-20250010142.SDR SWAA2025122253199Attach Bracket · damagedAPON INSPECTION FOUND PANEL 651GB ATTACHING BRACKET AND OR BUSHING ELONGATED<[01] REMOVED AND REPLACED BRACKET ON PANEL 651GB SURROUND AREA PER SRM 51-40-02.SDR SWAA2025122253383Hook And Loop · missingPAX CABIN LT AFT DOOR SLIDE LOWER COVER IS CHAFING AGAINST WITH THE DOOR SCUFF PLATE WHEN THE DOOR MOVED TO CLOSE POSITION. PERFORMED VISUAL INSPECTION AND FOUND MISSING HOOK AND LOOP STRIP. INSTALLED THE HOOK AND LOOP ON PAX DOOR SLIDE LOWER COVER IAW SOPM