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 SWIA2025112176580Floor Support · corrodedRBL 9 BETWEEN BS 1000.00 TO 1060.00 CORRODED ON TOP SURFACE OF SUPPORT. REMOVED AND INSTALLED NEW FLOOR SUPPORT SECTION AT RBL 9 FROM BS 977 TO 1075 IAW SRM 53-00-41-201-001-A03 AND REO 690-53-61-1707, REV-. STEP 1, 2, 3, 4, 5. COMPLIED WITH TASK CARD 51-900-SDR SWIA2025112176573Floor Support · corrodedLBL9.00 BETWEEN BS 977.00 TO 1088.20 HAD CORROSION ON TOP SURFACE OF BEAM. REMOVED AND INSTALLED NEW LBL 9 FLOORBEAM SECTION FROM BS 977 TO 1081.5 IAW SRM 53-00-41-201-001-A03 AND REO 690-53-61-1707 REV.- STEPS 1, 2, 3, 4 AND 5. COMPLIED WITH TASK CARD 51-9SDR SWIA2025112176570Door Sill · corrodedLEFT SILL BETWEEN BS 1000 - 1047 HAS CORROSION. INSTALLED NEW AFT CARGO DOOR LOWER SILL, IAW SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG MM670-35085, REV. L. LEAK CHECKED GOOD. COMPLIED WITH SKYWEST TASK CARD 51-900-1SDR SWIA2025112176543Vent · corrodedLEFT CABIN FLOOR VENT HAS CORROSION BETWEEN FS1088.20 - FS1098.20. LT CABIN FLOOR VENT BRACKETS CORROSION HAS BEEN REPAIRED BY PERFORMING ALL STEPS OF REO 690-53-61-1712 REV-- .COMPLIED WITH TASK CARD 51-900-1002-SKYSDR SWIA2025112176527Vent · corrodedRIGHT CABIN FLOOR VENT HAS CORROSION, BETWEEN BS 1088.20 - BS 1098.20. RIGHT CABIN FLOOR VENT BRACKET CORROSION HAS BEEN REPAIRED IAW ALL STEPS REO 690-53-61-1712 REV-. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2025112176518Floor Support · corrodedLBL 27 BETWEEN BS 977 TO 1088.20 HAS CORROSION ON TOP SURFACE OF BEAM. REMOVED AND INSTALLED INSTALLED NEW FLOOR BEAM SECTON AT LBL 27 FROM BS 977 TO 1055 IAW SRM 53-00-41-201-001-A03 AND COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWIA2020706076506Stringer Splice · corrodedSTRINGER SPLICE 26L AT BS 333 HAS CORROSION. REMOVED AND INSTALLED A NEW MAIN AVIONICS STRINGER SPLICE IAW SRM 51-42-06-001-001-A01 AND DWG SH670-32420 REV E. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. PERFORMED PRESSURE LEAK CHECK IAW SRM 51-23-03-001-SDR SWIA2025112176463Support · corrodedLT SILL BETWEEN BS 985 - 1000 HAS CORROSION. REMOVED CORROSION ON LT SILL BS 985 - 1000. IAW SRM 51-21-06-001-001-A01. EVALUATED OUT OF LIMITS IAW SRM 53-61-23-101-001-A01. PERFORMED ALL STEPS OF REO 690-53-61-1717 REV -. COMPLIED WITH TASK CARD 51-900-1002-SDR SWIA2025112176452Bracket · bentBRACKET ATTACHED TO INTERCOSTAL BETWEEN BS 1031 TO 1047 ABOVE STR 27 BENT. REMOVED THE DAMAGE BRACKET IAW SRM 51-42-06-001-001-A01. INSTALLED A NEW BRACKET IAW SRM 51-42-06-001-001-A01, AND DWG MM670-36084, REV D.SDR REXA2026052600656Web · crackedCRACK ON ELECTRICAL BAY FLOOR WEB LEFT SIDE (BELOW BRAKES GAUGES) FS193.00. CRACK ON ELECTRICAL BAY FLOOR WEB LEFT SIDE (BELOW BRAKES GAUGES) FS193.00 WAS REPAIRED PER CRJ-900 SRM 53-11-43-201-001-A01SDR REXA2026052600654Striker · crackedCRACK AT RH FWD & LH AFT OVERWING EMERGENCY DOOR TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER). RH FWD & LH AFT OVERWING EMERGENCY DOOR TOP SECTION (AROUND BASE OF DOOR PROXIMITY SENSOR STRIKER) WERE REPAIRED PER REO 670-52-21-103 REV.--.SDR REXA2026052600653Channel · crackedCRACK AT AFT BAGGGAGE-BAY CARGO DOOR TRACK CHANNEL, AFT LOWER SECTION. CHANNEL WAS REMOVED AND NEW CHANNEL WAS DRILLED AND INSTALLED ON AFT BAGGGAGE-BAY CARGO DOOR TRACK CHANNEL, AFT LOWER SECTION PER SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND SRSDR REXA2026052600645Door Sill · crackedCRACK ON AFT RH DOOR LANDING AT FS 188.00 (LATCH CUT OUT OF ACCESS DOOR 212AR) CRACK ON AFT RT DOOR LANDING AT FS 188.00 (LATCH CUT OUT OF ACCESS DOOR 212AR) WAS REPAIRED PER EA CRJ953-20971 REV. IR AND REPLACED PER SRM 51-42-06-001-001-A01 AND PER SRM 51-42-SDR REXA2026052600642Retainer · crackedCRACK ON LOWER SEAL RETAINER AT PASSENGER DOOR AND BEND CONDUIT SUPPORT. LOWER SEAL RETAINER WAS REPLACED PER SRM 51-42-10-001-001-A01 AND PASSENGER DOOR HARNESS ASSEMBLY MUST BE REPLACED UNDER NRC 00227SDR IXXA03092026CC01Beam · wornRIGHT MLG STRUT DOOR SUPPORT BEAM IS HEAVILY WORN ALONG THE EDGE JUST FWD OF DRAG STRUT.SDR SWIA2026022574317Skin · dentedFOUND DENT ON FUSALAGE SKIN NEXT TO BS 565, STRINGER 21R. DENT IS 1 INCH IN LENGTH, .25 INCH WIDE, & .018 INCH DEEP. COMPIED WITH REO 670-53-31-1123 REV-. REPAIR TO RT FUSELAGE SKIN PANEL, LOWER, FWD BARREL AT BS 565, S21R - 22R. COMPLIED WITH TASK CARD 5SDR SWIA2026021375275Plate · corrodedFOUND FWD CARGO DOOR SURROUND STRUCTURE JOINT PLATE AT BS 533 TO HAVE MULTIPLE SPOTS OF CORROSION. REPAIRED FWD CARGO DOOR SURROUND STRUCTURE JOINT PLATE IAW REO 670-53-31-1141, REV -. COMPLIED WITH ALL APPLICABLE STEPS SEE CONTINUE FOR WORK PERFORMED. COMPLSDR SWIA2026021375274Plate · corrodedFOUND FWD CARGO DOOR SURROUND STRUCTURE JOINT PLATE AT BS 581 TO HAVE MULTIPLE SPOTS OF CORROSION. REPAIRED FWD CARGO DOOR SURROUND STRUCTURE JOINT PLATE IAW REO 670-53-31-1141, REV-. NO DEFECTS NOTED, ALL STEPS COMPLIED WITH. COMPLIED WITH TASK CARD 51-900-SDR SWIA2026020975234Bearing · damagedTHE RIGHT SLAT TRACK 2-2 AFT OUTBOARD, FWD INBOARD AND FWD OUTBOARD SIDE ROLLERS HAVE FLAT SPOT WIDTH GREATER THAN 0.060 IN. REMOVED AND REPLACED RT SLAT TRACK 2-2 AFT OTBD, FWD INBD AND FWD OTBD ROLLERS IAW AMM 27-81-44-000/400-802-A01.SDR HNAA2026012100037Skin · dentedRIGHT WING LEADING EDGE NR 2 HAS A DENT APPROX. 13" FROM OTBD EDGE. REPAIRED RH WING LEADING EDGE #2 DENT APPROX. 13" FROM OTBD EDGE IAW PIEDMONT EO1-57-25-0461, ETD2025-145-934265 AND EMB 145 SRM 57-40-00RE.SDR VNAA202601180016Plate · corrodedCORROSION AROUND FASTENER HOLE ON AFT CORNER OF THE LOWER PLATE OF CENTER BAGGAGE-BAY DOOR SEAL. LOWER PLATE OF CENTER BAGGAGE-BAY DOOR SEAL WAS EVALUATE FOUND EXCESSIVE DAMAGE PER CRJ-900 SRM 51-10-06-001-001-A01 AND REPLACE PER CRJ-900 SRM 51-41-02-001-001-SDR KY72026F00001Coalescer Bag · odorSMOKE IN COCKPIT FROM BLEEDS. TEMP CONTROLLER WAS IN AUTO AND MOSTLY TOWARDS HOT. CLEANED L & R WATERSOCKS GRD RUN'S OPS CHECK GOOD NO SMOKE IN CABIN IAW MM 21-40-00 RTS.SDR SWAA2025123038436Shield · corrodedCORRODED SHIELD WEB BTW BS 767 - 794.3, RBL 22, WL 156.1 IN THE AFT CARGO BAY. REPLACED THE SHIELD WEB IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, PARAGRAPH 9, AND DWG 146A0081, SHEET 49, REV A.SDR SWAA2025123038582Support Angle · crackedCRACK ON CARGO LINER SUPPORT ANGLE, BS 727I, LBL 51, WL 202 IN THE AFT CARGO BAY. REPAIRED THE SUPPORT ANGLE IAW SRM 51-70-11-2R-0, AND DWG 149A9490, SHEET 24, REV -.SDR SWAA2025123038586Support Angle · crackedCRACKED CARGO LINER SUPPORT ANGLE, BS 727B, LBL 51 IN THE AFT CARGO BAY. REPAIRED THE SUPPORT ANGLE IAW SRM 51-70-11-2R-0, AND DWG 149A9490, SHEET 24, REV -.SDR SWAA2025123038431Web · corrodedCORROSION ON SHIELD WEB, BS 847 - 867, RBL 19, WL 156.1 IN THE AFT CARGO BAY. REPLACED SHIELD WEB IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 146A0081, SHEET 49, REV A.SDR SWAA2025123038608Strap · corrodedCORROSION ON STRAP AT BS 1016 LBL 3 WL 208. REMOVED, FABRICATED, AND REPLACED THE STRAP AT BS 1016, LBL 3, WL 208 IAW SRM 51-40-05-0G-0, SRM 51-40-02-0G-0, PL 147A5620, REV C, AND DWG 147A5600 REV C.SDR SWAA2025123038614Floor Support · crackedCRACKED FLOOR SUPPORT AT BS 277-294 RBL 1 WL 208. REMOVED DAMAGE FLOOR SUPPORT AND REPLACED WITH NEW IAW SRM 51-40-02-0G-0, AND DWG 141A5400, SHEET 20, REV -.SDR SWAA2025123038435Support Angle · corrodedCORRODED SUPPORT ANGLE BTW BS 767 TO 787, RBL 21 AND WL156 IN AFT CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, PARAGRAPH 9, AND DWG 146A0081, SHEET 49, REV A, AND DWG 146A8123, SHEET 16, REV-.SDR SWAA2025123038609Floorbeam · corrodedCORROSION AT FLOORBEAM BS 986, RBL 42, WL 208. REMOVED, FABRICATED, LOCATED, DRILLED, APPLIED PROTECTIVE TREATMENT, AND INSTALLED NEW FILLER ON EXISTENT REPAIR AT FLOORBEAM BS 986, RBL 42, WL 208.SDR SWAA2025123038616Floor Support · crackedCRACKED FLOOR SUPPORT AT BS 312-328, RBL 31, WL 208. REMOVED AND REPLACED FLOOR SUPPORT BS312 - 328, RBL 31, WL208 IAW SRM 51-40-02-0G-0 AND DWG 141A5400 REV -.SDR SWAA2025123038453Seat Track · corrodedCORROSION ON TOP AND IN WELL OF PAX CABIN SEAT TRACK BS 540 TO BS 727B RBL 25 WL 208. REMOVED CORROSION ON CROWN OF PAX CABIN SEAT TRACK BS 649 RBL 25 WL 208 L=4'; W= 0.5'; D= 0.014' IAW SRM 53-00-52-1A, PARAGRAPH 4. A. (A) FIGURE 103 DETAIL A. REMOVED FASTSDR SWAA2025123038455Seat Track · corrodedCORROSION ON TOP AND IN WELL OF PAX CABIN SEAT TRACK BS 480 TO BS 520, LBL 45, WL 208. REMOVED AND REPLACED PASSENGER CABIN SEAT TRACK IAW SRM 51-40-02, DWG 143A5300 REV -, AND EA 25-153-03311.SDR SWAA2025123047381Seat Track · corrodedCORROSION ON TOP OF PAX CABIN SEAT TRACK BS 480 TO BS 520 LBL 25 WL 208. RECEIVED NEW FABRICATED SEAT TRACK, LOCATED AND DRILLED NEW FABRICATED SEAT TRACK IAW SRM 51-40-05-0G-0, DWG 143A5310, SHEET 110, REV -, AND DWG 143A5300, SHEET 67, REV -, AND EA 25-153SDR SWAA2025122946809Support Angle · crackedCRACK ON CARGO LINER SUPPORT ANGLE LOCATED BS 727I LBL 51 WL 202 AT AFT CARGO COMPARTMENT. REPAIRED CARGO LINER SUPPORT ANGLE LOCATED BS 727I LBL 51 WL 202 AT AFT CARGO COMPARTMENT IAW SRM 51-70-11-2R-0 AND DWG 149A9490 SHEET 24 REV. -.SDR SWAA2025122946810Support Angle · crackedCRACK CARGO LINER SUPPORT ANGLE LOCATED BS727B LBL51 AT AFT CARGO COMPARTMENT. REPAIRED CARGO LINER SUPPORT ANGLE LOCATED BS727B LBL51 AT AFT CARGO COMPARTMENT IAW SRM 51-70-11-2R-0 AND DWG 149A9490 SHEET 24 REV. -.SDR SWAA2025122946805Shield · corrodedCORROSION ON SHIELD WEB LOCATED TW BS 847 TO BS 867 RBL 19 WL 156.1 AT AFT CARGO COMPARTMENT. REPLACED SHIELD WEB LOCATED BTW BS 847 TO BS 867 RBL 19 WL 156.1 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG: 146A0081; SHEET: 4SDR SWAA2025122946807Shield · corrodedCORROSION ON SHIELD WEB LOCATED BTW BS 767 TO BS 794.3 RBL 22 WL 156.1 AT AFT CARGO COMPARTMENT 2025-714110<[01] REPLACED SHIELD WEB LOCATED BTW BS 767 TO BS 794.3 RBL 22 WL 156.1 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-40-02-0G-0; SRM 51-10-02-0G-0 PARAGSDR SWAA2025122938432Support Angle · crackedCRACKED SUPPORT ANGLE AT BULKHEAD BS 663.75, RBL 36. REPLACED THE SUPPORT ANGLE IAW SRM 51-10-02-0G-0, ITEM 9, DWG 111A1000, SHEET 330, SHEET 331, AND SHEET 329, REV A.SDR SWAA2025122946806Support Angle · corrodedCORRODED SUPPORT ANGLE, BS 767 - 787, RBL 21, WL 156 IN THE AFT CARGO BAY. REPLACED THE SUPPORT ANGLE IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, PARAGRAPH 9, DWG 146A0081, SHEET 49, REV A, AND DWG 146A8123, SHEET 16, REV-.SDR SWAA2025122938434Fitting · crackedCRACKED FITTING, BS 947.5, STRINGER 26L THE AFT CARGO BAY. REPLACED THE FITTING IAW SRM 51-40-02, AND DRAWING 149A8103, SHEET 8, REV-.SDR SWAA2025122938588Scuff Plate · crackedCRACKED CENTER SCUFF PLATE OF THE FWD SERVICE DOORWAY. REPAIRED THE CENTER SCUFF PLATE AT FWD SERVICE DOOR IAW SRM 53-10-15-2R-2, REPAIR 2.SDR SWAA2025122941132Former · wornRIGHT LOWER FAIRING FORMER AT BS 663 - 673, RBL 20, WL 142 WORN ON LOWER SIDE OF FORMER. REMOVED AND REPLACED THE RT LOWER FAIRING FORMER IAW SRM 51-40-02-0G0, AND DWG 149A7216, REV A.SDR SWAA2025122941131Former · wornLEFT LOWER FAIRING FORMER, BS 663 - 673, LBL 20, WL 142 WORN ON LOWER SIDE. REMOVED AND REPLACED THE LT LOWER FAIRING FORMER IAW SRM 51-40-02, DWG 149A7216, REV:A.SDR SWAA2025122938591Floorbeam · corrodedCORROSION ON FLOORBEAM, BS 328, RBL 24.75, WL 208.1 IN FWD GALLEY AREA. PERFORMED A REPAIR ON THE FLOORBEAM IAW SRM 53-10-51-2R, REPAIR 7.SDR SWAA2025122938592Web · crackedCRACKED WEB, BTW BS 312 - 328, RBL 32, WL 208.1 IN FWD GALLEY AREA. REPLACED THE WEB IAW SRM 51-40-02, AND DWG 141A5410, SHEET 12, REV A.SDR SWAA2025122938433Support Bracket · crackedCRACKED SUPPORT BRACKET ON PNEUMATIC DUCT BS 540 AND LBL 6 AT AIR CONDITIONING BAY. REPLACED THE SUPPORT BRACKET ON PNEUMATIC DUCT BS 540 AND LBL 6 AT AIR CONDITIONING BAY IAW SRM 51-40-02-0G-0, AND SRM 51-10-02-0G-0, ITEM 9.SDR SWAA2025122938456Seat Track · corrodedCORROSION ON TOP OF PAX CABIN SEAT TRACK BS 480 TO BS 520 LBL 25 WL 208. REMOVED CORROSION ON SEAT TRACK IAW SRM 51-10-02. MAXIMUM MATERIAL REMOVED WAS 0.25'X 5' X 1' AT BS 520, LBL 25, WL 208. MAXIMUM MAETRIAL ALLOWED TO BE REMOVED IS .020'. FOUND TO BE OSDR SWAA2025122238619Stringer · corrodedCORROSION ON STRINGER 27R BTW BS 360 TO BS 380 WL 156.1 IN E/E BAY. PERFORMED PERMANENT REPAIR(CATEGORY A) ON STRINGER 27R LOCATED BTW BS 360 TO BS 400 WL 156.1 AT ELECTRICAL AND ELECTRONIC COMPARTMENT IAW B737-700 SRM 53-00-03-2R-1 REPAIR 1 PARAGRAPH 4.SDR R61A2025121800541Support · corrodedDURING HEAVY CHECK MAINTENANCE FOUND CABIN FWD WET AREA FLOOR STRUCTURE FR16, RBL 28 FLOOR SUPPORT CORRODED. CABIN FWD WET AREA FLOOR STRUCTURE FR16, RBL 28 FLOOR SUPPORT REMOVED AND REPLACED IAW SRM 51-41-01.