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 WX0A2025070732483Power Supply · inoperative(AIRCRAFT NOT GROUNDED) AFT GALLEY EMERGENCY LIGHTS INOP / TS PER TSM 33-51-00-810-836-A, REMOVED AND REPLACE EPSU 13WL PER AMM 33-51-38-000-001-A,33-51-38-400-001-A. OPS AND BITE CHECK GOOD. A/C OK FOR SERVICE"SDR DALA2025070705009Panel · missingSHIP 3940 -UFC- AIRCRAFT ARRIVED IN RDU WITH THE LEFT-WING OUTBOARD AFT TRAILING EDGE FLAP ASSEMBLY MISSING. MISSING FLAP PANEL CAUSED SLIGHT UNCOMMANDED ROLL. CORRECTIVE ACTION: MAINTENANCE REPLACED OUTBOARD AFT FLAP PER B737 AMM 21-51-22.SDR AALA202507072030Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 12WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTYORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507073923Battery · no testAIRCRAFT WAS NOT GROUNDED: BATTERY FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 14WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTYORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507072582Battery · no testAIRCRAFT WAS NOT GROUNDED: FAULT MESSAGE FOR EMERGENCY POWER SUPPLY UNIT 13WL DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY AND ACCOMPLISHED A SATISFACTYORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202507079135Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507076343Battery · no testAIRCRAFT WAS NOT GROUNDED: AFT LEFT INBOARD FLIGHT ATTENDANT SEAT FLASHLIGHT TESTED RED. REPLACED FLASHLIGHT BATTERY PER AFMM 20-25-70.SDR AALA202507076914Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR MASA2025070600055Flashlight · inoperativeFA 1 FLASHLIGHT INOP. REMOVED AND REPLACED FA1 FLASHLIGHT. OPS CK GOOD.SDR AALA202507076684Transmitter · bindingAIRCRAFT WAS NOT GROUNDED: CAPTAINS NOSE WHEEL STEERING TILLER IS VERY STICKY. WHEN MANIPULATING TURNS. TILLER SOMETIMES STICKS IN RANDOM POSITIONS INSTEADOF SMOOTHLY RESETTING TO 0. MAINTENANCE REPLACED CAPTAINS TRANSMITTER UNIT - NOSE-WHEEL STEERING HANDWHEESDR AALA202507077989Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: DOOR 1R EXIT NEED RELAMP. MAINTENANCE REPLACED DOOR 1R EXIT LIGHT IAW AMM 33-51-16-000-001-A STEP 4.AAND IAW AMM 33-51-16-400-001-A STEP 4.B THRU E. PERFORMED OPERATIONAL TESTIS OK.SDR SCNA20250707242Nut · missingFOUR OVER WING EMERGENCY EXIT DOOR, STOPS ARE MISSING DOOR STOP NUTS (16 EA).SDR FDEA202507061125Skin · delaminatedLH WING OB FLAP LWR SURFACE FROM IB TO OB 20 INCH CROSS TE TO LE 5 INCH FOUND DELAMINATION.SDR FDEA202507061124Seat Track · no discrepancyEXISTING REPAIR ON MAIN DECK SEAT TRACK AT Y1456 BETWEEN FR18 AND FR27 REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON MAIN DECK SEAT TRACK AT Y1456 BETWEEN FR18 AND FR27 WAS EVALUATED AND FOUND IN CONFORMITY WITH DWG: A53781931(ISSUE. H). EO: 6SDR FDEA202507061123Repair · no discrepancyEXISTING REPAIR ON MAIN DECK CROSSBEAM AT FR60 BETWEEN Y450 AND Y953 REQUIRES EVALUATION FOR CONFORMITY. THE EXISTING REPAIR ON MAIN DECK CROSSBEAM AT FR60 BETWEEN Y450 AND Y953 WAS EVALUATED AND FOUND IN CONFORMITY WITH A300-600F SRM53-10-15-201 FIG211. ESDR SCNA20250707241Bracket · loose1R GIRT BAR RIGHT SIDE HOLDER ON DOOR LOOSE. TIGHTENED R/H GIRT BAR HOLDER AT 1-R PER AMM 25-66-01SDR SCNA20250707240Bracket · looseDEFECT 801679: 1L DOOR GIRT BAR BRACKET IS LOOSE RESOLUTION: ADJUSTED GIRT BAR BRACKET REF AMM 25-66-00SDR DXTA2025070704147Battery · no testNONE OF THE EMER LTS ILLUMINATE WITH SWITCH IN ARM POSITION. RAN QRH RECHARGE PROCEDURE, STILL FAILED AFTER ALLOTTED CHARGING TIME. CORRECTIVE ACTION: REMOVED AND REPLACED POSITION 1, 2, 3, AND 4 EMERGENCY LIGHTING BATTERY PACKS AND INSTALLED NEW BATTERY PACKSSDR F3LA202507060265Slide · no testUPON INSTALLATION OF L1 SLIDER DOOR ON LP334753/3 EPSU TEST FAULT SHOWING ESCAPE SLIDE LT. AFT (L2). REMOVED AND REPLACED L2 DOOR SLIDE PACK-ASSY AS PER AMM 25-62-44-000-012-A/25-62-44-400-007-A. OPS CHECK GOOD T/W: F9TAB14011C.DD06/26/ /END/.SDR EE4Y2025070622637Skin · canningDURING THE STRUCTURE INSPECTION WAS REPORTED IN THE CENTER FUSELAGE III, AT FR 82+357MM, STR-23R+100MM AN EXISTING REPAIR WITH OIL CAN IN THE EXTERNAL SKIN. SINCE THAT THE DAMAGE REPORTED IS WITHIN GRAY ZONE AREA IAW ERJ190 PART II SRM 53-23-01, REPAIR 61, FIGSDR EE4Y20250706226Rib · crackedDURING THE ACCOMPLISHMENT OF SB 190-57-0056, WAS FOUND AT RH WING, LOWER SKIN ASSY – WING BOX, RIB #8, LOWER FLANGE WITH CRACK. DUE TO IT CONDITION WAS REPOARTED TO EMB ASKING FOR REPAIR INSTRUCTIONS. THE CRACKED WAS REPAIRED BY ETD2025-190-923702 AND DOCUMENTSDR EE4Y2025070622643Skin · wornDURING THE STRUCTURE INSPECTION WAS FOUND ONE GOUGE WITH PUNCTURE ON THRUST REVERSER OUTER FIXED STRUCTURE EXTERNAL COWL SKIN. THE DAMAGE MEASURES 1.125" (L) X 0.250" (W) LOCATED AT 1.5" FROM THE AFT EDGE AND 0.500" AWAY FROM THE CHEM-MILLED STEP. DUE TO IT, WSDR JR2R20250706943Shear Tie · corrodedSHEAR TIE AT FRAME 89 BETWEEN STRINGER 27R TO 28R IS CORRODED. OUT OF LIMTS. REPLACEDSDR EE4Y2025070622642Skin · dentedDURING THE STRUCTURE INSPECTION, DENTS WERE FOUND CONTROLLED AS PER PREVIOUS OPERATOR RECORDS UNDER ETD2015-190-078115 GUIDELINES, HOWEVER, FOLLOWING INSPECTION INSTRUCTIONS REQUIRED OIL CAN EFFECT WAS FOUND LOCATED BTWN FR25/26, BTWN STR-28L/28R. THIS CONDITISDR EE4Y2025070622641Skin · crackedDURING THE ACCOMPLISHMENT OF SB190-57-0056, TWO CRACKS WERE DISCOVER COMING FROM THE PREVIOUS REPAIR TRIM OUTS, AND ONE ADDITIONAL CRACK WAS FOUND CLOSE TO RIB 11. CRACKED AREAS WERE REMOVED BY SKIN TRIM OUTS. THIS SITUATION WAS REPORTED TO EMB ASKING FOR REPASDR EE4Y2025070622639Skin · no discrepancyDURING THE STRUCTURE INSPECTION, AN EXISTING REPAIR WAS FOUND INSTALLED AS PER PREVIOUS OPERATOR RECORDS UNDER IC2007-190/04024A DTD JUN 20 2007 GUIDELINES, HOWEVER, THE RECORDS DOES NOT SHOWN MATERIAL TRACEABILITY. THE DAMAGE WAS EVALUATED AND FOUND ON GREY ZSDR EE4Y2025070622636Skin · crackedDURING THE STRUCTURE INSPECTION, WAS FOUND THE RH WING LEADING EDGE BETWEEN RIBS 19 AND 20 THE SKIN WITH CRACK. THE CRACKED AREA WAS TRIMMED OUT FOLLOWING SRM 57-49-01 REP 51 GUIDELINES, HOWEVER, THE FINAL MEASURE AFTER REWORK EXCEEDS THE MINIMUM ALLOWED. THISSDR EE4Y2025070622635Skin · crackedDURING THE STRUCTURE INSPECTION, WAS FOUND THE LH WING LEADING EDGE BETWEEN RIBS 19 AND 20 THE SKIN WITH CRACK, THE CRACKED AREA WAS TRIMMED OUT FOLLOWING SRM 57-49-01 REP 51 GUIDELINES, HOWEVER, THE FINAL MEASURE AFTER REWORK EXCEEDS THE MINIMUM ALLOWED. THISSDR EE4Y2025070622634Repair · misinstalledDURING THE STRUCTURE INSPECTION, AN EXISTING REPAIR WAS FOUND INSTALLED AS PER PREVIOUS OPERATOR RECORDS UNDER ETD2010-190-10955 GUIDELINES, HOWEVER, THE RECORDS DOES NOT SHOWN MATERIAL TRACEABILITY. DUE TO THIS FACT, THE REPAIR WAS REMOVED, AND A NEW PROPOSALSDR REXA2026072901297Fitting · corrodedSECONDARY NRC: AFTER BEARING AND BUSHINGS REMOVAL ON RT AILERON, CORROSION WAS FOUND ON LUGS BORES R1, R3, R5 AT RH AILERON CENTER FITTING IN REF. TO TASK CARD 900-27-900-912. LUGS BORES R1 & R5 AT RT AILERON CENTER FITTING WERE REPAIRED PER REO 670-57-61-237 SDR REXA2026072901296Floorbeam · corrodedCORROSION ON FLOORBEAM BS 294, RBL 29 AND BS 333, LBL 18, APROX AT FWD PAX CABIN FLOORBEAM ON BS 333, LBL 18 APROX AT FWD PAX CABIN WAS REPAIRED IAW EA CRJ953-19732, REV IR, AND FLOORBEAM ON BS 294, RBL 29 WAS CLEANED IAW SRM 51-26-00-001-001-A01 AND RE-INSPECSDR AALA202512022292Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FRAME FASTENER HOLE 4 IN THE DOUBLE JOGGLE AREA AT FR 16 RIGHT AND THE #7 DOOR STOP FITTING. REPAIRED FRAME PER EA 367854.SDR AALA202511282108Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION ON FRAME 16 LH SIDE, IN HOLE 4, AT LEVEL DOOR STOP 7, AT FWD GALLEY AREA. (REPLACED PARTIAL FRAME REQUIRED BY EA 367853). MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR (PARTIAL FRAME 16 REPLACEMENT) LOC. ON FR16 LHSDR SWIA202511260705Frame · corrodedUPON REMOVAL FRAME SECTION AT FS969 BETWEEN STGR19R AND STRG24R FOUND MULTIPLES SPOTS OF CORROSION ON FRAME. (C-CHECK) COMPLIED WITH REPAIR FOR CORROSION DAMAGE ON LOWER FRAME FS969.00 BETWEEN STR20R-STR25R. REF REO 690-53-51-487 REV -- DATED: 2025-07-28. COSDR IPXA2025081278063Floor Panel · damagedFWD CARGO CMPT, FLOOR PANEL 132MG; FR 27-32 RH IS DAMAGED. FABRICATED FLOOR PANEL 132MG IAW SREO-16407-REQ003 STEPS 1 - 19 .SDR IPXA2025081278133Floor Panel · damagedFWD CARGO CMPT, FLOOR PANEL 131MG; FR 27-32 LH IS DAMAGED. INSTALLED FABRICATED REPLACEMENT FLOOR PANEL FOR FWD PIT IAW SREO-16407-REQ002 ((APPX C)) JOB COMPLETE. REVIEWEDSDR SWAA2025081188407Guard · brokenBROKEN EMERGENCY EXIT LIGHT SWITCH GUARD ON LAVATORY B AFT GALLEY AREA. REPLACED EMERGENCY EXIT LIGHT SWITCH GUARD ON LAVATORY B AFT GALLEY AREA I.A.W CMM BAE SYSTEM 33-11-05 REV.16 FIG.2 ITEM (15) PAGE 10028.SDR SWAA2025081188475Support Bracket · crackedCRACK SUPPORT BRACKET ON BODY STATION 540 LOCATED RBL5 AT AIR CONDITIONING BAY REPLACED SUPPORT BRACKET ON BODY STATION 540 LOCATED RBL5 AT AIR CONDITIONING BAY IAW B737-700 SRM 51-10-02 ITEM 9 AND SRM 51-40-02.SDR SWAA2025081188575Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661AB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661AB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025081188576Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 661BB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661BB TRAILING EDGE AT RT WING IAW B737-700 SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025081188577Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661CB TRAILING EDGE AT RT WING. REPAIRED ACCESS PANEL 661CB TRAILING EDGE AT RT WING IAW SRM 51-70-04-2R-9 REPAIR 9. SSDR SWAA2025081188578Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561BB TRAILING EDGE AT LT WING. REPAIRED ACCESS PANEL 561BB TRAILING EDGE AT LT WING IAW B737-700 SRM 51-70-04-2R-9 REPAIR 9.SDR SWAA2025081188468Panel · delaminatedLEFT ING L/E PANEL 521KB DELAMINATED AT CORNERS OF CUTOUT. LEFT WING L/E PANEL 521KB WITH DELAMINATIONS AT CORNERS OF CUTOUTS WAS REPAIRED PER SRM 51-70-05-2R-6.SDR SWAA2025081188467Panel · delaminatedLEFT WING L/E PANEL 521DB DELAMINATED AT CUTOUT CORNERS. REPAIRED PER SRM 51-70-05-2R-6-A00737 REPAIR 6 - REPAIR OF DAMAGE TO THE EDGEBAND OF A HONEYCOMB PANEL.SDR SWAA2025081188470Panel · delaminatedRIGHT WING L/E PANEL 621JB DELAMINATED AT CUTOUT FWD CORNERS. RIGHT WING L/E PANEL 621JB DELAMINATED AT CUTOUT FWD CORNERS; WAS REPAIRED IAW SRM 51-70-05-2R-6.SDR SWAA2025081188472Panel · delaminatedRIGHT WING L/E PANEL 621QB DELAMINATED AT FWD I/B CORNER. RIGHT WING L/E PANEL 621QB DELAMINATED AT FWD I/B CORNER; WAS REPAIRED IAW SRM 51-70-05-2R-6.SDR IPXA2025072480095Support Bracket · crackedFWD CARGO CMPT FR 38.2; UPPER FLOORBEAM, LOWER CHANNEL SUPPORT BRACKETS (3EA) ARE CRACKED.REMOVED SUPPORT BRACKETS (3EA) AT FRAME 38.2 UPPER FLOOR BEAM IAW A300/600 SRM 51-40-21.FABRICATED NEW BRACKETS (3EA) ON FWD CARGO CMPT FROM MAT. 2024-T3.032C BTCH#:00043SDR IPXA2025080177856Tee Angle · corroded*** SUPPLEMENTAL SDR *** FAULT- Z100- STR: RH WTB T-CHORD BETWEEN STA 1037 - STA 1060 RBL 65 HAS EXFOLIATION ON UPPER SURFACE. INSTALLED T-CHORD P/N UP-149N7553-28, BETWEEN STA 1037 - STA 1060 RBL 65IAW B757-200PF, SRM 51-40-02SDR NACA2025070500002Stiffener · crackedDURING PERFORM MFEC INSPECTION OF RH SIDE NOSE WHEEL WELL BULKHEAD STIFFENER , ONE CRACK WAS FOUND AT BS287 BETWEEN WL 159 TO WL 185 AS MARKED, IT IS ABOUT 0.8 INCH LONG. CARRIED OUT THE STIFFENER REPAIR AT LEFT SIDE NOSE WW BULKHEAD STA 287 LBL 25 AS PER DRAFSDR NACA2025070500001Stiffener · crackedDURING PERFORM MFEC INSPECTION OF LT SIDE NOSE WHEEL WELL BULKHEAD STIFFENER , ONE CRACK WAS FOUND AT BS 287 BETWEEN WL 159 TO WL 185 AS MARKED, IT IS ABOUT 1 INCH LONG. CARRIED OUT THE STIFFENER REPAIR AT LT SIDE NOSE WW BULKHEAD STA 287 LBL25 AS PER DRAFT EO