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 SWAA2025093007399Floor Panel · pulledFLOOR PANEL 242QF UPPER SKIN HAS AREAS OF PULLED STRANDS. FLOOR PANEL 242QF WAS REPLACED WITH A SERVICEABLE FLOOR PANEL PER SRM 51-10-02-0G-0 PARA 9.A.1 DUE TO AMOUNT OF ALL DAMAGE.SDR SWAA2025093007665Floor Panel · pulledFLOOR PANEL 241DF UPPER SKIN HAS PULLED STRANDS. FABRICATED NEW FLOOR PANEL IAW SRM 53-00-50-2R-0 PARA 1. A.SDR SWAA2025092907652Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL RBL 6 AT AIR CONDITIONING BAY IAW SRM 51-10-02 ITEM 9 AND DWG 212A1101 SHEET:9 REV:-.SDR SWAA2025092907653Support Bracket · crackedCRACK SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 AT LEVEL LBL 6 AT AIR CONDITIONING BAY IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG: 212A1101 SHEET: 9 REV -.SDR VNAA202509260014Frame Angle · corrodedAFTER ANGLE REINFORCING REMOVAL IN REF NRC 00238, CORROSION ON ANGLE REINFORCING OF FRAME FS879 WAS FOUND. CORROSION WAS REMOVED ON ANGLE REINFORCING OF FRAME FS879 PER CRJ-700 SRM 51-21-06-001-001-A01, EVALUATED OUT LIMTS PER CRJ-700 SRM 53-51-06-101-003-A01SDR SWAA2025092607654Beam · crackedCRACK ON BEAM HANDLE BOX AREA OF FWD GALLEY SERVICE DOOR AT PASSENGER CABIN. REPLACED BEAM AND FASTENERS LOCATED HANDLE BOX AREA OF FWD GALLEY SERVICE DOOR AT PASSENGER CABIN IAW B737-800 SRM 51-10-02; SRM 51-40-02 AND DWG 141A6535 SHEET 13 REV- AND DWG 141A6SDR SWAA2025092607655Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 450 AT LT WING. REPLACED CORRUGATED PLATE TRAILING EDGE LOCATED ORSS 450 AT LT WING IAW B737-800 SRM 51-40-02 AND SRM 51-10-02 ITEM 9. CRACK LENGTH IS .450 INCH.SDR SWAA2025092307645Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE, IRSS 181, RT WING. REPLACED THE CORRUGATED PLATE AND FASTENERS IAW SRM 51-10-02 ITEM 9, AND SRM 51-40-02.SDR DALA2025091706844Frame · dentedFUSELAGE FRAME AT L.F.S 1300, S-25L TO S-26L IS DENTED IN ALONG THE TOP. NO DENTS ALLOWED PER SRM. FABRICATED AND INSTALLED REPAIR ON FFS 1300 S-25L TO S26L IAW B757 SRM 53-00-07-2R FIG 201. (LP 1202024)SDR SWAA2025091507363Intercostal · corrodedCORROSION ON FCB INTERCOSTAL BS 500 TO BS 500A, LBL 25, WL161. REMOVED AND REPLACED INTERCOSTAL FROM BS 500 TO BS 500A, LBL 25 IAW SRM 51-40-02, AND DWG 143A7505 REV -.SDR HNAA2025091100621Doubler · corrodedGALLEY AFT DIAMOND GUSSET AT FR22 CORRODED. R & R GALLEY AFT DIAMOND GUSSET AT FR22 IAW EMB 145 SRM 51-40-02.SDR HNAA2025091100619Floorbeam · corrodedGALLEY FLOOR CROSSBEAM AT FR18 BETWEEN LH FLOOR SILL #1 AND LH OMEGA BEAM HAS CORROSION. R&R GALLEY FLOOR CROSSBEAM AT FR18 BETWEEN LH FLOOR SILL #1 AND LH OMEGA BEAM IAW EMB 145 SRM51-40-02.SDR HNAA2025091100616Seat Track · corrodedRH CENTER SEAT TRACK #2 HAS GOUGES AND CORROSION IN NUMEROUS AREAS ALONG ENTIRE LENGTH. R&R R/H CENTER SEAT TRACK #2 IAW EMB 145 AMM 53-01-06.SDR HNAA20250911615Seat Track · corrodedRH CENTER SEAT TRACK #2 HAS GOUGES AND CORROSION IN NUMEROUS AREAS ALONG ENTIRE LENGHT. R&R RH CENTER SEAT TRACK #2 IAW EMB 145 AMM 53-01-06.SDR HNAA2025091100605Skin · crackedLH REAR FUSELAGE 2 UPPER SKIN RIVET ON FR77, STGR 6L HAS A POSSIBLE CRACK. INSTALLED REPAIR BUSHING ON LH REAR FUSELAGE 2 UPPER SKIN AT FR77, STGR 6L IAW EMB 145 SRM 53-32-01 REF STEP 9 AND PIEDMONT EO1-53-25-0286.SDR HNAA2025091000599Bushing · corrodedHORIZONTAL STAB RH HINGE FITTING OUTBD BUSHING HOUSING #4 CORRODED.REPAIRD CORROSION IAW EMB 145 SRM 55-10-02 SEE NRTC # F061480 FOR #4 BUSHING INSTALLATION.SDR HNAA2025090900590Frame · gougedFRAME 65 HAS GOUGESAROUND MULTIPLE NUT PLATE HOLES, LOCATED BETWEEN STGR 2R AND 8R.C/W PERMANAENT REPAIR ON FRM65 BETWEEN STGR 2R AND 8R PER ETD2025-145-925993.SDR SWAA2025090807558Handle · looseCR RR L1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR ASSIST HANDLE IAW AMM SUBTASK 52-11-31-020-011.SDR SWAA2025090407553Handle · unsecureL2 DOOR ASSIST HANDLE NEEDS SECURED CR RR L2 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L2 DOOR ASSIST HANDLE IAW B737-800 AMM SUBTASK 52-13-31-020-008.SDR SWAA2025090407559Handle · unsecureR1 DOOR ASSIST HANDLE NEEDS SECURED CR RR R1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR ASAA2025082360439Seat Track · damagedPILOTS SEAT TRACK INBOARD AFT HAS ELONGATED HOLE. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED SEAT TRACK INBORD AFT ON PILOTSEAT IAW B737 AMM 25-11-11-400-801. SRXR430X.SDR ASAA2025082360438Seat Track · damagedCOPILOTS SEAT TRACK INBOARD AFT HAS ELONGATED HOLE. SRXR430X. GROUNDED - YES. REMOVED AND REPLACED SEAT TRACK INBOARD AFT ON COPILOTS SEAT AREA IAW B737 AMM 25-11-11-400-801. SRXR430X.SDR SWAA2025090307346Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1694 ARE INOPERATIVE. REPLACED AND PERFORMED GOOD FUNCTIONAL TEST OF EMERGENCY LIGHTS BATTERY PACK M1694 PER AMM 33-51-06-960-805.SDR SWAA2025090307347Battery Pack · inoperativeEMERGENCY EXIT LIGHTS ASSOCIATED WITH BATTERY PACK M1695 ARE INOPERATIVE. REPLACED AND PERFORMED GOOD FUNCTIONAL TEST OF EMERGENCY LIGHTS BATTERY PACK M1695 PER AMM 33-51-06-960-805.SDR DALA2025090206513Sign · inoperativeRIGHT OVERWING AFT EMERGENCY EXIT ESCAPE LIGHT INOPERATIVE. R & R THE AFT RT OVERWING EXIT SIGN LIGHT ASSY IAW AMM 33-51. OPS CHECKED GOOD. MEL CLEARED. (7070197)SDR IPXA202509025671Hinge Fitting · crackedPIANO HINGE FITTING OF MDC DOOR HAS CRACK/DAMAGE IN HOLE [19F] BOTTOM LAYERS, 5`CLOCK POSITION. FASTENER IS INSTALLED IAW TASK CARD MXP-531355-02-1-233-JIC (SDI - PIANO HINGE FITTINGS OF MDC DOOR ON FUSELAGE AND DOOR INCLUDING SURROUNDING STRUCTURE) REVIEWEDSDR IPXA2025082925599Hinge · crackedPIANO HINGE FITTING OF MDC DOOR HAS CRACK IN HOLE [10D] BOTTOM LAYER. FASTENER IS INSTALLED IAW TASK CARD MXP-531355-02-1-233-JIC. SDI - PIANO HINGE FITTINGS OF MDC DOOR ON FUSELAGE AND DOOR INCLUDING SURROUNDING STRUCTURE.SDR CALA2025090108321Post · wornFWD CARGO, FWD BULKHEAD VERTICAL POSTS WORN AT UPPER ATTACH POINT. ACCOMPLISHED SPLICE RPR ON Y254 VERT MEMBER AT FWD CARGO BULK HEAD FR24 IAW SRM 53-21-29-300-003. REQUIRES INSP AT 15000 FC/30 000 FH/ 72 MONTHS.SDR AALA202508290091Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT WING TOP SKIN PANEL UPPER SURFACE BETWEEN RIBS 1 AND 2 AT THE REAR SPAR. REPAIRED SKIN PANEL PER EA 367034.SDR DALA2025082806385Module · disconnectedSEAT 4A EMERGENCY FLOOR PATH MARKING LIGHT IS OUT. WHILE PERFORMING VISUAL INSPECTION OF EMERGENCY LIGHT MODULE NOTICED CABLE POLARITY WAS REVERSED. RECONNECTED LED MODULE REF. CMM 33-52-20. OPS NORMAL. NO FURTHER ISSUES NOTED. (LP# 7295066)SDR FDEA202508231555Repair · misrepairedEXISTING REPAIR ON FWD CARGO DOOR INNER SKIN LOWER EDGE BETWEEN FR21A AND FR22A REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON FWD CARGO DOOR INNER SKIN LOWER EDGE BETWEEN FR21A AND FR22A WAS EVALUATED AND FOUND NOT IN CONFORMITY WITH A300-600F SDR CALA2025082808230Tee Fitting · corrodedDURING BODY FAIRING REMOVAL FOUND EXFOLIATED T-CHORD AT BS 900, LOWER AREA. R & R TEE FITTING BS 900 BETWEEN LBL65 IAW SRM 51-40-02-0G-0, AND SRM 51-70-12-0G-0, STEP C, TABLE II.SDR IPXA2025082327433Manifold · brokenEMERGENCY DECLARED, DIVERSION, LVL 2 HYD 3 FAIL. STARTED HYD 3 ELEV OFF THEN HYD 3 OFF. REMOVED & REPLACED #3 ENGINE UPPER (LEFT) EDP PER AMM TASK 29-11-20-400-802 UP TO STEP (H). BLEED, LEAK & OPS CHECK REQUIRED. SERVICED #3 HYD SYSTEM IAW AMM 12-13-02/301.PESDR CALA2025082708198Fuel Cap · missingPDA 2 FUELER FOUND FUEL CAP MISSING SEE LOG PAGE 6024804 FOR CDLSDR CALA2025082708181None · no discrepancyDOOR 2L SLIDE PRESSURE GAUGE APPEARS TO BE IN THE RED VERIFIED DOOR 2L DOOR SLIDE PRESSURE GAUGE IS WITHIN LIMITS PER AMM 25-66-01. OK TO CONTINUE.SDR CALA2025082708180Slide · noneDEACTIVATED L1 SLIDE IN REF WITH AMM 25-66-03 FOR GIRT BAR CARRIER REMOVAL. REACTIVATED DOOR 1L SLIDE REF AMM 25-66-03-404-098. REMOVED AND STOWED SAFETY PIN FROM INFLATION CYLINDER. FLAGGING FOR INSPECTION INSPECTED REACTIVATION OF DOOR SLIDE AS REQUIRED PER SDR CALA2025082708179Pin · installedINSTALLED GROUND LOCK PIN ON L1 DOOR FOR GIRT BAR CARRIER REMOVAL. REMOVED GROUND LOCK PIN ON L1 DOOR AFTER GIRT BAR CARRIER INSTALLATION REF AMM 52-11-13SDR CALA2025082708178Warning Light · false activationFWD CARGO DOOR ECAM ON LANDING ROLLOUT PLACING BACK ON MEL BECAUSE OF EXTENSIVE HISTORY. REQUESTING MEL 5270J NOC MEL 5270J APPROVED PLA APPLIED. DDP C/W. *DM* AWM 31-54-46 INSPECT WIRES TO PROX SWITCH FOR CONDITION. CHECK WIRES WITHIN HARNESS 4613VB. ALSO SEESDR CALA2025082708177Door · no discrepancy20A EXIT DOOR PASSENGER LEAVING AIRCRAFT REPORTED DOOR LEAKING. PERFORMED GVI OF 20A DOOR AREA, NO DEFECTS NOTED. DOOR IS PROPERLY CLOSED. OK FOR SERVICE. REF AMM 52-22-00. PERFORMED GVI OF 20A DOOR AREA, NO DEFECTS NOTED. DOOR IS PROPERLY CLOSED. OK FOR SESDR CALA2025082708176Light · false activationAFTER T/O FWD ENTRY LT ON BUT EXTINGUISHED SHORTLY AFTERWARDS INSPECT THE FWD ENTRY DOOR SENSOR. OPS CHECK GOOD. AS PER AMM 52-71-11SDR CALA2025082708175Bottle · no discrepancyINFLIGHT, REQUEST DOOR 4L PRESSURE CHECK. APPEARS TO BE JUST OUT OF GREEN BAND. PRESSURE CHECK GOOD REF AMM 25-66-01. MAKE SURE THAT THE PRESSURE INDICATOR NEEDLE IS IN THE GO BAND (GREEN) OR NOT MORE THAN ONE NEEDLE WIDTH TO THE RIGHT OF THE GO BAND (GREEN).SDR CALA2025082708174Strap · brokenMOST AFT OVHD LIFE RAFT TAMPER INDICATOR BROKEN. INSPECTED OVHD LIFE RAFT AND INSTALLED TAMPER INDICATOR.SDR CALA2025082708173Warning Message · false activationDOOR ENTRY IND 4R EICAS STATUS #4 RIGHT ENTRY DOOR INDICATION SYSTEM FAULT DETECTED. FIM TASK REF : 52-98 TASK 802 PSEU 2 (R2) REF FIM TASK 32-08 TASK 18 MAINT MSG32-12220.MSG ARE NOT ACTIVE IN MAT, PSEU 1 AND 2 TEST C/O TEST PASSED.NO FURTHER EICAS OR STATSDR CALA2025082708172Warning Message · false activationDOOR AFT CARGO IND EICAS STATUS OPTIONAL LARGE AFT CARGO DOOR INDICATION SYSTEM FAULT DETECTED. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 3212220 PSEU 2 (R2) REF FIM TASK 32-08 TASK 18 MAINT MSG32-12220.MSG ARE NOT ACTIVE IN MAT, PSEU 1 AND 2 TESTSDR CALA2025082708164Elec Connector · disconnectedROW 38 ABC ON SEAT EMERGENCY LIGHT INOP FOUND CONNECTOR ON SEAT DISCONNECTED, RECONNECTED & PERFORM EMERGENCY LIGHTING TEST PER AMM 33-51-00-710-804-A, OPS TEST GOODSDR SWIA202508260023Engine · leakingSMOKE/EXHAUST OBSERVED COMING FROM #1 ENGINE TAIL PIPE BY GROUND CREW BEFORE PUSH BACK. FLUID IS NOW LEAKING FROM BOTTOM OF THE ENGINE COWLING. (FLIGHT 4888 - FILED CLOSED)REMOVED AND REPLACED LH ENGINE FUEL METERING UNIT AND GASKET IN REFERENCE TO ERJ 175 AMSDR SWI2025F01120Windshield · crackedON FINAL APPROACH TO SLC, RIGHT FRONT WINDOW SHATTERED. (FLIGHT 3331 - FILED CLOSED) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30719913 WITH THE FOLLOWING CORRECTIVE ACTION: "REMOVED AND REPLACED COPILOT WINDSHIELD IN REFERENCE TO AMM 56-11-00. OPS CHECKSDR SWAA2025082607422Panel · crackedLEFT WING UPPER O/B FIXED LEADING EDGE PANEL HAS CRACK/ PUNCTURE AT WS 279 L/H WING UPPER O/B FIXED LEADING EDGE PANEL HAS CRACK/ PUNCTURE AT WS 279. LENGTH 2.6 IN. X .100 IN. ACCOMPLISHED PERMANENT REPAIR PER SRM 57-41-01-2R-1 AND SRM 51-70-05.SDR SWAA2025082607769Flashlight · inoperativeAFT LEFT FLASHLIGHT INOPERATIVE. PERFORMED FLASHLIGHT CHECK PER AMM 25-64-00. PROPERLY INSTALLED FLASHLIGHT IN HOLDER. OPS CK NORMAL.SDR SWAA2025082607505Flashlight · inoperativeFLIGHT DECK FLASHLIGHT BRACKET GREEN LIGHT INOP. R & R FLIGHT DECK FLASHLIGHT ASSY PER SIP. CHECK OK PER 25-64-00.