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 JJBA20251111055Frame · dentedFRAME 71 BETWEEN STRINGER 15R AND 16R IS DENTED. RECONTOURED FRAME 71 BETWEEN STRINGER 15R AND 16RSDR JJBA20251111050Retainer · crackedZONE 100 RACK - 123BL DRAIN DIAPHRAGM RETAINER CRACKED. DOOR 123BL INSTALLED NEW FROM STOCK DRAIN DIAPHRAGM AND RETAINER.SDR SWI2025F01510Stringer · corrodedDUCT CLAMP BRACKET ON STR22R NEER FS280 HAS CORROSION. INSTALLED NEW STGR 22R & BRACKET @ FWD BETWEEN FS. 280 TO FS. 333.0 IAW CRJ900 SRM 51-42-06-001-001-A01 NO WEIGHT CHANGE, ITEMS REMOVED, REPLACED WITH NEW SAME ITEMS.STRUCTRAL REPAIR TASK CARD 51-900-1002SDR SWIA2025110600723Skin · corrodedMULTIPLE SPOTS OF COROSION ON INTERNAL SKIN BETWEEN FS280 AND FS295 FROM STR24R TO 25L. REPAIRED CORRODED AREAS ON INTERNAL SKIN BTW BS 280 AND BS 295 FROM STRINGERS 24R TO 25L IAW REO 690-53-21-2000, REV--, AND REO 690-53-21-2001, REV--.SDR VNAA20251015007Hinge Fitting · excess playFREE PLAY ON SELF-ALIGN SELF-LUB BEARING PLAIN ON HINGE FITTING NO. 3 AT VERTICAL STABILIZER REAR SPAR MIDDLE SECTION. HINGE FITTING NO. 3 AT VERTICAL STABILIZER REAR SPAR MIDDLE SECTION WAS REPLACED PER RIL #2103 REV.BSDR VNAA20251015006Fitting · corrodedAFTER BUSHINGS REMOVAL, FOUND CORROSION ON CENTER FITTING BORE LUG R1, R2 AND R5 AT RH AILERON. CORROSION ON CENTER FITTING BORE LUG R1, R2 AND R5 AT RH AILERON WAS REAMED WITH INNER DIAMETER R1 0.9688", R2 0.7812 AND R5 0. 8125" PER REO 670-57-61-237REV -,SDR VNAA20251015004Rib · crackedCRACK ON OUTB MACHINED RIB OF WS163.00 TRAILING EDGE AT RH WING. CRACK ON OUTB MACHINED RIB OF WS163.00 TRAILING EDGE AT RH WING WAS REPAIRED PER REO 690-57-51-457 REV - -.SDR AALA202510137180Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU RIGHT LATERAL FITTING WORN BETWEEN FR 23 AND FR 24 AT -Y1292. REPLACED HAND LATERAL FITTING PER EA 366661.SDR AALA202510137275Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU LEFT LATERAL FITTING WORN BETWEEN FR 23 AND FR 24 AT +Y1292. REPLACED LEFT LATERAL FITTING PER EA 366661.SDR AALA202509294348Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOOR BEAM 3 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR 36 CRACK L=0.410 INCHSDR AALA202509295988Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOOR BEAM 2 BACKSIDE O F THE SPAR VERTICAL STRINGER AT FR 36. CRACK L= 0.235 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON HORIZONTAL BEAM Y765 (NUMBER 2) LOC CENTER BOX FR36 FRONTSDR AALA202509299460Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOORBEAM 5 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR 36 CRACK L=0.280 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON HORIZONTAL BEAM -Y765 (BEAM 5) LOC CENTER BOX FR36 FRONT SPARSDR AALA202509295457Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON RADIUS OF HORIZONTAL FLOOR BEAM 4 BACKSIDE OF THE SPAR VERTICAL STRINGER AT FR 36. CRACK L= 0.470 INCH. MAINTENANCE PERFORMED PERMANENT REPAIR ON HORIZONTAL BEAM -Y254 (NUMBER 4) LOC CENTER WING BOX FR36 SDR SWIA202509250723Frame · corrodedCORROSION NOTED ON FRAME 349 BETWEEN STGR 26L TO STGR 26R. (S/N#000358) (C-CHECK RO 09/24/2025)REMOVED AND REPLACED FRAME SECTION AT FS349 BETWEEN STGR 23L AND 23R REF. CRJ-200 SRM 51-42-06, SRM 51-42-21, AND BOMBARDIER DWG# 601R32005 REV. AP AND COMPLIED WITSDR HNAA2025091100620Door Frame · corrodedFUSELAGE SERVICE DOOR CUT-OUT AT FR-22 AND BETWEEN STGR 15R/16R HAS CORROSION. REPAIRED FUSELAGE SERVICE DOOR CUT-OUT AT FR-22 BETWEEN STGR 15R/16R IAW EMB 145 SRM 53-00-04 REF ITEM 16, FIG 208.SDR AALA202509058698Fork · wornAIRCRAFT IN BASE MAINTENANCE: FOUND RACK 80VU LATERAL FITTING IN CONTACT WITH STRUCTUR RH SIDE IN AFT AVIONIC COMPARTMENT. DAMAGED AREA: 0.080 IN. MAINTENANCE PERFORMED INTERIM REPAIR AT LOWER LATERAL SUPPORT RH OF 80VU RACK LOC BTW FR23 TO FR24 AT LEVEL STR 3SDR AALA202509050259Fork · wornAIRCRAFT IN BASE MAINTENANCE: FOUND RACK 80VU FITTING IN CONTACT WITH STRUCTURE LH SIDE IN AFT AVIONIC COMPARTMENT. DAMAGED AREA L: 0.063 IN. MAINTENANCE PERFORMED INTERIM REPAIR AT LOWER LATERAL SUPPORT LH OF 80VU RACK LOC BTW FR23 TO FR24 AT LEVEL STR 32LH ISDR SWAA2025090394317Glowstrip · brokenBROKEN FLOOR PROXIMITY LIGHTING PHOTOLUMINESCENT STRIP AT PASSENGER CABIN (10 EA). REPLACED FLOOR PROXIMITY LIGHTING PHOTOLUMINESCENT STRIP AT PASSENGER CABIN (10 EA) IAW B737-700 AMM 33-51-15-400-802.SDR SWAA2025090394842Intercostal · crackedCRACK WEB - INTERCOSTAL LOCATED BS847 TO BS867 AT LEVEL LBL22 AT AFT CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL AND FASTENERS LOCATED BS847 TO BS867 AT LEVEL LBL22 AT AFT CARGO COMPARTMENT IAW SRM 51-40-02; SRM 51-10-02 Ï¿½TEM 9 AND DWG: 149A8100 SHEET: 1 SDR SWAA2025090394305Scuff Plate · crackedCRACK AFT CORNER SCUFF PLATE LOC. AFT CARGO COMPARTMENT. REPAIRED AFT CORNER SCUFF PLATE LOC. AFT CARGO COMPARTMENT IAW BOEING SRM 53-60-15-2R-1 REPAIR 1 AND BAC5975.SDR SWAA2025090394528Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED ON BS 694 AT LEVEL BL 0 AT PASSENGER CABIN. REPLACED ANGLE FLOOR STRUCTURE LOCATED ON BS 694 AT LEVEL BL 0 AT PASSENGER CABIN IAW SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 273A9110 SHEET: 6 REV: A.SDR SWAA2025090394302Skin Panel · crackedCRACK INDICATION FOUND ON RT HORIZONTAL STABILIZER LOWER SKIN PANEL. LOCATED AT STAB STA 184.70 RIB AND 9 INCH. FROM REAR SPAR. INBOARD SIDE OF RIB. CRACK LENGTH = 0.350 INCH. PERFORMED REPAIR ON RT HORIZONTAL STABILIZER LOWER SKIN PANEL BTW SSTA 203.10 & SSSDR SWAA2025090394527Angle · crackedCRACK ANGLE FLOOR STRUCTURE LOCATED ON BS 694 AT LEVEL RBL 25 AT PASSENGER CABIN. REPLACED ANGLE FLOOR STRUCTURE LOCATED ON BS 694 AT LEVEL RBL 25 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG 273A9111 SHEET 10, REV -.SDR ASAA2025072360414Rib · crackedRIGHT HORZONTAL STABILIZER INTERNAL LOWER AREA OF RIB HAS 1 CRACK AT STAB STA.129.50. GROUNDED - YES. CUT OUT DAMAGE AREA IAW B737-800 SRM 55-10-09-2R-4. FABRICATED LOCATED & DRILLED REPAIR PARTS IAW B737-800 SRM 51-40-05 AND SRM 55-10-09-2R-4. ALODINED CUT OUSDR ASAA2025072360396Rib · crackedRIGHT HORIZONTAL STABILIZER INTERNAL LOWER AREA OF RIB HAS 1 CRACK AT STAB STA.147.90. GROUNDED - YES. REMOVED DAMAGE AT RIB IAW SRM 55-10-09-2R-4. FABRICATED & INSTALLED INTERNAL DOUBLER & ANGLE IAW B737-800 SRM 55-10-09-2R-4. CUT OUT LOWER SKIN TO ACCESS REPSDR SWAA2025082794816Access Door · crackedCRACK ANGLE ACCESS PANEL 333AB AT LT HORIZONTAL STAB REPLACED BLADE ASSY ON ACCESS PANEL 333AB AT LT HORIZONTAL STABILIZER IAW B737-800 SRM 51-10-02-0G-0 ITEM 9 AND SRM 51-40-02-0G-0.SDR SWAA2025082794519Plate · crackedCRACK PLATE INBOARD FAN COWL ON ENGINE 1. REPLACED PLATE AND FASTENERS INBOARD FAN COWL ON ENGINE 1 IAW CMM 71-13-30 DETAIL P FIGURE 3; SHEET 5; IAW SRM 51-40-02-0G-0 & SRM 51-10-02-0G-0, PARAGRAPH 9.SDR SWAA2025082794508Support Bracket · crackedCRACK SUPPORT BRACKET ON PNEUMATIC DUCT BS 540 AND RBL 6 AIR CONDITIONING BAY. REPLACED THE SUPPORT BRACKET ON PNEUMATIC DUCT IAW SRM 51-40-02-0G-0 AND SRM 51-10-02-0G-0 ITEM 9.SDR SWAA2025082794507Support Bracket · crackedCRACK SUPPORT BRACKET ON PNEUMATIC DUCT BS 540, LBL 6 AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET ON PNEUMATIC DUCT IAW SRM 51-40-02-0G-0 AND SRM 51-10-02-0G-0 ITEM 9.SDR SWAA2025082794817Support · corrodedCORROSION ON SUPPORT ZEE LOCATED BTW BS 767 TO BS 806 LBL 22 WL 156.1 AT AFT CARGO COMPARTMENT. REPAIRED SUPPORT ZEE LOCATED BTW BS 727J TO BS 847 LBL 22 WL 156.1 AT AFT CARGO COMPARTMENT IAW SRM 53-00-53-2R-6 REPAIR 6 IAW SRM 51-40-02-0G-0, SRM 51-10-02, PARSDR SWAA2025082794815Web · corrodedCORROSION ON SHIELD WEB LOCATED BTW BS 767 TO BS 787 RBL 22 WL 156.1 AT AFT CARGO COMPARTMENT. REPLACED SHIELD WEB IAW SRM 51-10-02-0G-0, ITEM 9, SRM 51-40-02-0G-0, AND DWG 146A0081, SHEET 49, REV A.SDR SWAA2025082794506Support Angle · crackedCRACK SUPPORT ANGLE BS 663.75 AND RBL 10 WL 170 AT CENTER SECTION. FABRICATED AND REPLACED SUPPORT ANGLE LOC BS 663.75 FROM RBL6 TO RBL 75 WL 170 AT CENTER SECTION RT SIDE IAW SRM 51-10-02-0G-0 STEP 9, SRM 51-40-02-0G, DWG 111A1000, SHEET 257, 329, AND SHEET SDR SWAA2025082794819Seal · crackedCRACK SEAL - PLATE ACCESS PANEL 333AB AT LT HORIZONTAL STABILIZER. REPLACED SEAL - PLATE ACCESS PANEL 333AB AT LT HORIZONTAL STABILIZER IAW SRM 51-40-02 ; SRM 51-10-02 ITEM 9 AND DWG 186A3101 SHEET 25 REV -. MEASURE OF CRACK ON SEAL - PLATE: L:1.049.SDR AALA202508258910Lock · bindingAIRCRAFT IN BASE MAINTENANCE: **REPEAT ISSUE** LAVATORY-D DOOR LOCK DIFFICULT TO LOCK AND UNLOCK. LAVATORY-D ASSEMBLY REMOVED AND SENT FOR REPAIR TO TULE SHOP 2705, ON BOW 0518217, NR 85 SHOP ORDER VT90, OPERATIONAL CHECK OF LOCK GOOD.SDR SWAA2025082294441Attach Angle · crackedBS 663 VAPOR BARRIER ATTACH ANGLE CRACKED ON OUTBD SIDE OF FLEX JOINT @ LBL 34' HFEC VERIFIED.<[01] DAMAGE AT LBL 34 IS VERIFIED USING HFEC PER NDT PART 6; 51-00-00 PROCEDURE 23.;[02] REPLACED ATTACH ANGLE PER SRM 51-40-02 & DRW 111A1000;[03] VERIFIED C/A 2 COSDR SWAA2025082294129Fitting · crackedR/H WING INBD TRAILING EDGE; UPPER SHELF PANEL INTERCOSTAL INBD OF DEFLECTION FITTING IS CRACKED<[01] REMOVED INTERCOSTAL WEB INBD OF R/H WING DEFLECTION CONTROL RIB PER SRM 51-40-02.;[02] INSPECTION C/W.;[03] LOCATED; DRILLED AND DEBURRED REPLACEMENT INTERCOSSDR SWAA2025082194119Floor Panel · delaminatedPASSENGER CABIN FLOOR PANEL 242CF DELAMINATED WITH NUMEROUS DENTS. INSTALLED FLOOR PANEL 242CF PER AMM 53-21-00.SDR SWAA2025082194493Fitting · corrodedFWD GALLEY G-1 O/B AFT TIE-DOWN FITTING HAS CORROSION. R & R FWD GALLEY G-1 O/B AFT TIE-DOWN FITTING PER CMM 25-31-71 AND SRM 51-40-02.SDR SWAA2025081994462Fitting · crackedA71-40 LEFT WING TRAILING EDGE CAVITY. FIXED TRAILING EDGE SUPPORT BRACKET 10' I/B OF DEFLECTION CONTROL RIB; HAS A CRACK AT BULB SEAL ATTACH BRACKET. REMOVED LT WING T/E SUPPORT BRACKET IAW SRM 51-40-02-0G-0. DRILLED FASTENERS HOLES IAW SRM 51-40-02-0G-0 ASDR ASAA2025072360109Rib · crackedLEFT HORZONTAL STABILZER INTERNAL RIB HAS CRACK AT HSS 129.50. GROUNDED - YES. ACCOMPLISHED REPAIR OF CRACK IAW SRM 55-10-09-2R-4.SDR AALA202508184247Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO STRINGER S23L LOCATED FROM BS 312 TO BS 320. REPAIRED STRINGER PER EA 366700.SDR AALA202508189019Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT CHANNEL LOCATED FROM BS 500C TO BS 500I AT LBL 18. REPLACED CHANNEL PER AARD 51-00-05-1.SDR SWAA2025081594505Web · corrodedCORROSION IN AFT CARGO DOOR CUTOUT LOWER MAIN SILL WEB BS 794+4, WL 156, RBL 18. LOWER MAIN SILL WEB BS 794 TO BS 847, RBL 18 WAS REPLACED ON CARD TTG8Q0146N47.SDR SWAA2025081594679Seat Track · wornMAIN CABIN LT SEAT TRACK LBL 45 AT BS 520 UPPER SIDE OF CROWN HAS EVIDENCE OF WEAR. REMOVED DAMAGE; MATERIAL LOSS OF 0.026' IS OUT OF LIMITS IAW SRM 53-00-52-1A-1. REMOVED DAMAGED SECTION OF SEAT TRACK BETWEEN STA 500C + 10' AND BS 520 LBL 45. LOCATED AND DSDR SWAA2025081594686Seat Track · corrodedMAIN CABIN L/H SEAT TRACK LBL45 AT STA 685+12' TO 727+13' LOWER SIDE OF CROWN HAS EVIDENCE OF CORROSION. REPAIRED IAW SRM 53-00-52-1A-1-A00026.SDR SWAA2025081494218Seat Back · out of adjustEMERGENCY EXIT ROW SEAT RECLINES AT 11D. ADJUSTED HYDRAULIC LOCK TO PREVENT RECLINE AT SEAT 11D IAW CMM 25-21-45, REPAIR STEPS 3.G.SDR SWAA2025081494452Floor Panel · deformedFWD CARGO FLOOR PANEL 120BF IS WAVY BETWEEN FLOORBEAMS. COMPLETED FABRICATION OF A NEW FLOOR PANEL 120BF IAW AMM 25-52-01-201-801.SDR IPXA2025080673155Support Angle · corrodedUPON REMOVING APU INLET ASSY, FOUND FWD LWR ANGLE AT STA. 1745, UPR MID AND LWR MID ANGLES BETWEEN BS 1825 AND 1745, TO BE CORRODED. REMOVED 4 EA ANGLES, FWD LWR AND FWD UPR ANGLES AT BS 1784, UPR MID AND LWR MID ANGLES P/N 148N3152-2, P/N 148N3152-1 BETWEENSDR CALA2025081407752Skin · damagedFUSELAGE OUTER SURFACE AT BS 867, S19L EXISTING REPAIR EXTERNAL DOUBLER WITH TOOLING DAMAGE. ACCOMPLISHED REPAIR ON FUSELAGE SKIN AT STA 867 & STR 19L IN REF TO EC/RA # 5331-03175. INTERIM REPAIR.SDR CALA2025081407751Spar · corrodedCORROSION AT LT HORIZONTAL STAB REAR SPAR LOWER CHORD BOTTOM SURFACE STA 122.5 APROX. ACCOMPLISHED REPAIR AT LEFT LEFT HORIZONTAL STAB REAR SPAR LOWER CHORD SSTA 126 IN REFERENCE TO EC/RA # 5510-03299, CAT B REPAIR.