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 SWIA2025080475157Slat Track · wornRH 1-3 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)PERFORMED REPAIR ON R/H SLAT TRACK 1-3 PER REO 690-57-42-1305 REV -- 2025-08-26 SEE CONTINUATION FOR DETAILS COMPLIED WITH TASK CARD 51-900-1002SDR SWIA2025080475141Slat Track · wornRH 3-2 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON R/H SLAT TRACK 3-2 IAW CRJ 900 SRM 51-12-00-001-001-A01FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE LIMITS IN CRJ900 SRMREPAIRED IAW REO 690-57-4SDR SWIA2025080475140Slat Track · wornRH 3-1 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON R/H SLAT TRACK 3-1 IAW CRJ 900 SRM 51-12-00-001-001-A01 COMPLIED WITH ALL STEPS OF REO 690-57-42-1301 REV -- DATED 2025-08-26.. RIGGING GOOD. OPS SDR SWIA2025080475139Slat Track · wornRH 2-3 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON R/H SLAT TRACK 2-3 IAW CRJ 900 SRM 51-12-00-001-001-A01FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE LIMITS IN CRJ900 SRMREPAIRED IAW REO 690-57-4SDR SWIA2025080475138Slat Track · damagedRH 1-2 SLAT TRACK HAS PITTING IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON R/H SLAT TRACK 1-2 IAW CRJ 900 SRM 51-12-00-001-001-A01FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE LIMITS IN CRJ900 SRMREPAIRED IAW REO 690-57-42-1SDR SWIA2025080475137Slat Track · wornRH 1-1 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON RH SLAT TRACK 1-1 IAW CRJ 900 SRM 51-12-00-001-001-A01BLENDS FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE DAMAGE REMOVAL LIMITS IN CRJ900 SRMPERFSDR SWIA2025080475123Slat Track · wornRH 2-1 SLAT TRACK HAS WEAR MARKS IN MULTIPLE LOCATIONS. (MARKED) (C-CHECK RO 02/01/2026)REMOVED WEAR MARKING ON R/H SLAT TRACK 2-1 IAW CRJ 900 SRM 51-12-00-001-001-A01ALL BLENDS FOUND TO BE OUT OF LIMITS DUE TO NO ALLOWABLE LIMITS IN CRJ900 SRMREPAIRED IAW RESDR SWIA2025080475120Slat Track · chafedRH SLAT TRACK 1-1 HAS CHAFE DAMAGE ON FWD OTBD SIDE. (MARKED) (C-CHECK RO 02/01/2026) PERFORMED REPAIR AT R/H SLAT TRACK 1-1 PER REO 690-57-42-1291 REV-- 2025-08-26 ALL STEPS COMPLIED WITH COMPLIED WITH SKYWEST TASK CARDS 51-900-1002-SKY AND 27-900-1009-SKYSDR SWI2025F01680Stand Off · crackedLEFT LWR TRANSCOWL INBD A BRACKET STANDOFF IS CRACKED. REMOVED AND REPLACED THE STANDOFF BRACKET IAW REO 670-54-21-971, REV B, COMPLIED WITH SKY CARD 51-900-1002-SKY.SDR SWI2025F01679Stand Off · crackedRT LOWER TRANSCOWL OTBD A- BRACKET STANDOFF CRACKED. REMOVED AND REPLACED THE STANDOFF IAW GREO #670-54-21-971, REV -B, STEPS 1-3. COMPLIED WITH SKY CARD #51-900-1002-SKY.SDR SWIA2025120200804Stand Off · crackedRIGHT UPPER TRANSCOWL INBD A BRACKET STANDOFF IS CRACKED. REMOVED THE CRACKED INBD A BRACKET STANDOFF FROM RT UPPER TRANSCOWL AND INSTALLED 1 EA NEW INBD A BRACKET STANDOFF IAW GREO 670-54-21-971 REV B, STEPS 1-3. COMPLIED WITH SKY CARD 51-900-1002-SKY.SDR AALA202510082347Door Frame · no discrepancyAIRCRAFT IN BASE MAINTENANCE: MODIFICATION OF OVERWING EMERGENCY EXIT 843 FRAME, BETWEEN FR 38 AND FR 39, BETWEEN BEAM 2 AND BEAM 3, REQUIRED DUE TO POTENTIAL CRACK PER EO 5210Y228. MODIFICATION OF FRAME ACCOMPLISHED PER EO 5210Y228.SDR AALA202510080186Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN OVERWING EXIT 843 RIGHT HAND LOAD TRANSMITTING PROFILE BETWEEN FR 38 AND FR 39, BETWEEN BEAM 2 AND BEAM 3. REPLACED SEGMENT PER EO 5210Y228.SDR AALA202510080481Door Frame · no discrepancyAIRCRAFT IN BASE MAINTENANCE: MODIFICATION OF OVERWING EMERGENCY EXIT 843 FRAME, BETWEEN FR 38 AND FR 39, BETWEEN BEAM 2 AND BEAM 3, REQUIRED DUE TO POTENTIAL CRACK PER EO 5210Y228. MODIFICATION OF FRAME ACCOMPLISHED PER EO 5210Y228.SDR AALA202510087242Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN OVERWING EXIT 844 RIGHT HAND LOAD TRANSMITTING PROFILE BETWEEN FR 40 AND FR 41, BETWEEN BEAM 2 AND BEAM 3. REPLACED SEGMENT PER EO 5210Y228.SDR AALA202510089637Door Frame · no discrepancyAIRCRAFT IN BASE MAINTENANCE: MODIFICATION OF OVERWING EMERGENCY EXIT 844 FRAME, BETWEEN FR 40 AND FR 41, BETWEEN BEAM 2 AND BEAM 3, REQUIRED DUE TO POTENTIAL CRACK PER EO 5210Y228. MODIFICATION OF FRAME ACCOMPLISHED PER EO 5210Y228.SDR AALA202510088979Door Frame · no discrepancyAIRCRAFT IN BASE MAINTENANCE: MODIFICATION OF OVERWING EMERGENCY EXIT 844 FRAME, BETWEEN FR 40 AND FR 41, BETWEEN BEAM 2 AND BEAM 3, REQUIRED DUE TO POTENTIAL CRACK PER EO 5210Y228. MODIFICATION OF FRAME ACCOMPLISHED PER EO 5210Y228.SDR VNAA202509250035Floorbeam · corrodedCORROSION AND WRONG INSTALLED FASTENERS (4EAS) ON FLOOR PANEL SUPPORT ANGLE AT FS280. FLOOR PANEL SUPPORT ANGLE AT FS280.00 WAS REPLACED PER CRJ-700 SRM 51-42-06-001-001-A01. AND SRM
51-42-21-001-001-A01.SDR AALA202509255373Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 58 AND FR 59 AT S41R. REPAIRED STRINGER PER EA 367820.SDR VNAA202509250007Floor Support · corrodedCORROSION ON FLOOR SUPPORTS (2EAS), PLATE (1EA), BRACKET MACHINED (2EAS) BTW FS 533 TO FS 581 STGR 26LH TO STGR 21LH AT FWD CARGO COMPARTMENT. CORROSION ON FLOOR SUPPORTS (2EAS), PLATE (1EA), MACHINED BRACKET (2EAS) BTW FS 533 TO FS 581 STGR 26LH TO STGR 21LHSDR VNAA202509250006Web · gougedGOUGES ON WEB FROM THE FWD EDGE AND LOWER EDGE AT DOOR SURROUND STRUCTURE AT FWD BAGGAGE BAY. GOUGES ON WEB FROM THE FWD EDGE AND LOWER EDGE AT DOOR SURROUND STRUCTURE AT FWD BAGGAGE BAY WERE BLENDED OUT PER CRJ-700 SRM 51-12-00-001-001-A01 AND EVALUATED WITHSDR VNAA202509250005Web · mechanic errorMISDRILL ON LOWER SURROUND STRUCTURE OF FWD COMPARTENT DOOR. REPAIRED PER REO 670-53-31-1078 REV --SDR VNAA202509250004Skin · wornWEAR ON LOWER SKIN OF AFT FUSELAGE ON FS970.00 TO FS 977.00 AND STG 27. LOWER SKIN OF AFT FUSELAGE ON FS970.00 TO FS 977.00 AND STG 27 WAS REPAIRED PER REO 670-53-00-789 REV.--SDR AALA202509189511Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 56 AND FR 57 AT S43L. REPAIRED STRINGER PER EA 367440.SDR SWAA2025091198401Strap · corrodedCORRODED STRAP LOCATED BTW BS794.3 TO BS807 RBL22 WL156 AT AFT CARGO COMPARTMENT. REPLACED STRAP AND FASTENERS LOCATED BTW BS767 TO BS867 RBL22 WL156 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 146A8120 SHEET 40 REV A AND SDR SWAA2025091198400Strap · corrodedCORROSION STRAP LOCATED BS794.3 RBL22 WL156 AT AFT CARGO COMPARTMENT. REPLACED STRAP LOCATED BS794.3 RBL22 WL156 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-40-02 AND DWG 146A8340 SHEET 28 REV-.SDR SWAA2025091198397Support · crackedCRACK ANGLE - SUPPORT LOCATED BS947.5 LBL11 AT AFT CARGO COMPARTMENT . INSTALLED NEW ANGLE - SUPPORT LOCATED STA947.5 AND LBL11 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG # 149A8103 SHEET 8 REV: -.SDR SWAA2025091098395Web · crackedCRACK WEB - INTERCOSTAL LOCATED BTW BS927 TO BS947.5 RBL22 AT AT AFT CARGO COMPARTMENT. REPLACED WEB - INTERCOSTAL LOCATED BTW BS927 TO BS947.5 RBL22 AT AT AFT CARGO COMPARTMENT IAW SRM 51-40-02; SRM 51-10-02 AND DWG 147A7500 SHEET 37 REV -.SDR SWAA2025091098393Shield · corrodedCORROSION SHIELD WEB LOCATED BTW BS767 TO BS787 RBL22 WL156 AT AFT CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS LOCATED BTW BS767 TO BS787 RBL22 WL156 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG: 146A0081 SHEET 49 RESDR SWAA2025090998396Support · corrodedCORROSION SUPPORT ZEE LOCATED BTW BS727D TO BS767 RBL22 WL156 AT AFT CARGO COMPARTMENT. REPLACED SUPPORT ZEE LOCATED BTW BS727 TO BS767 RBL22 WL156 AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-40-02 AND DWG 146A7500 SHEET: 223 REV .SDR SWAA2025090998392Support · corrodedCORRODED SUPPORT ZEE LOCATED BETWEEN BS 727C & 807, LBL 22, WL 156 IN AFT CARGO BAY. PERFORMED CATEGORY A REPAIR ON SUPPORT ZEE IAW SRM 53-00-53-2R-6, REPAIR 6, AND DWG 146A7500, SHEET 233, REV -, DWG 146A7502, SHEET 31, REV -, & DWG 149A8102, SHEET 20, REV-.SDR SWAA2025090998394Keelbeam · crackedCRACK KEELBEAM LOCATED BTW BS 727 & 727A, STRINGER 27R IN AFT CARGO BAY. PERFORMED PERMANENT REPAIR CATEGORY -A- IAW SRM 51-40-02, SRM 53-60-12-2R-1, REPAIR 1, AND EA 25-153-02200-WIP2.SDR AALA202509033975Sill Drain · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 ENTRY LOWER SILL INNER CHORD (CREASE ANGLE) LOCATED FROM BS 967 TO BS 986, AT RBL 47. REPLACED CHORD PER AARD 51-00-05-1.SDR AALA202509029143Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L2 DOOR CUTOUT LOWER SILL PLATE BETWEEN FR 66 AND FR 68 AT S22L. REPLACED SILL PLATE PER SRM 51-72-11.SDR AALA202509020759Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT STRINGER BETWEEN FR 57 AND FR 58 AT S40R. REPLACED STRINGER PER SRM 51-72-11.SDR AALA202509021909Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND AFT PASSENGER / CREW DOOR CUTOUT LOWER SILL PLATE AT FR 68 AND S23L. REPLACED SILL PLATE PER SRM 51-72-11.SDR SWIA2025082500004Seat Track · corrodedLEFT INBOARD LONGITUDINAL SEAT TRACK SEGMENT FROM FR 21-34 IS CORRODED AT FR 33-34. PERFORMED SEAT TRACK SPLICE REPAIR ON LH INBOARD LONGITUDINAL SEAT TRACK SEGMENT BETWEEN FR 32-34. REF ETD2022-170-022163 REV C. REPAIR PARTS DID NOT WEIGH MORE THAN 2.5LBS, NOSDR SWAA2025082298259Lens · crackedBULL NOSE TRIM ABOVE 28-29 ABC OVERHEAD BIN EMERGENCY LIGHT LENS COVER CRACKED.<[01] R/R LENS PER AMM 33-51-03;[02] 02 - INSPECTED PER [AMM 33-51-03-960-803-NG (EMERGENCY AISLE LIGHT (EAL) - LENS REPLACEMENT - PERMANENT)]SDR JJBA20250822052Skin · dentedCF4 ON L/H FUSE ON FR59 BTW STR 2L-3L DENT FOUND AT FLANGE NEW FRAME SECTION AND SPLICE FABRICATED. FRAME REPAIRED WITH A SPLICE.SDR AALA202508226150Fitting · wornAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND PYLON OUTBOARD AFT ATTACHMENT FITTING FOR THE THRUST REVERSER, BEARING HAS MIGRATED. REPLACED FITTING PER AMM 54-57-17.SDR FDEA202508041520Skin · contaminated1EA WATER TRAPPED AREA(80MM*100MM) WERE FOUND AT L/H ELEVATOR TOP SKIN PANEL T/E NO.22 FASTENER. *COUNTING FASTENER FROM I/B TO O/B* ACCOMPLISHED THE COMPOSITE REPAIR AT L/H ELEVATOR TOP SKIN PANEL T/E NO.22 FASTENER POSITION. I.A.W A300-600F SRM 55-21-12-SDR FDEA202508041519Skin · contaminated1EA WATER TRAPPED AREA(110MM*100MM) WERE FOUND AT L/H ELEVATOR TOP SKIN PANEL T/E NO.30 FASTENER. *COUNTING FASTENER FROM I/B TO O/B* ACCOMPLISHED THE COMPOSITE REPAIR AT L/H ELEVATOR TOP SKIN PANEL T/E NO.30 FASTENER POSITION. I.A.W A300-600F SRM 55-21-12SDR FDEA202508041518Skin · contaminated1EA WATER TRAPPED AREA(95MM*70MM) WERE FOUND AT L/H ELEVATOR TOP SKIN PANEL T/E NO.20 FASTENER. *COUNTING FASTENER FROM I/B TO O/B* ACCOMPLISHED THE COMPOSITE REPAIR AT L/H ELEVATOR TOP SKIN PANEL T/E NO.20 FASTENER POSITION. I.A.W A300-600F SRM 55-21-12-2SDR FDEA202508041517Skin · contaminated1EA WATER TRAPPED AREA(70MM*70MM) WERE FOUND AT L/H ELEVATOR TOP SKIN PANEL T/E NO.5 FASTENER. *COUNTING FASTENER FROM I/B TO O/B* ACCOMPLISHED THE COMPOSITE REPAIR AT L/H ELEVATOR TOP SKIN PANEL T/E NO.5 FASTENER POSITION. I.A.W A300-600F SRM 55-21-12-201SDR 3EJA202508200002Pickup · unknownTESTED THE ANTI ICE SYSTEMS DURING CLIMB. ACTIVATED ANTI-ICE SYSTEMS PRIOR TO ENTERING AND EXPERIENCED MODERATE ICING CONDITIONS. TURNED SYSTEMS OFF WHEN VMC BETWEEN LAYERS. ACTIVATED SYSTEMS AGAIN JUST PRIOR TO ENTERING IMC AND GOT A T2 HEATER FAIL L. SWAPSDR SWAA2025081998165Plate · crackedLEFT WING T/E INBD WAFFLE PLATE FOR PANEL 551EB CRACKED. REMOVED & REPLACED LT WING T/E INBD WAFFLE PLATE FOR PANEL 551EB IAW SRM 51-40-05-0G-0 & DWG115A2001 & DWG 115A2713.SDR SWAA2025081598171Scuff Plate · crackedAFT CARGO FWD CORNER SCUFF PLATE CRACKED. WILL BE REPLACED ON CARD TTG8Q006MC7E.SDR AALA202508158795Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE AT FR 69 AND S23R. REPLACED SHEAR PLATE PER SRM 51-42-11.SDR AALA202508158154Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT RIGHT PASSENGER / CREW DOOR CUTOUT LOWER SILL CENTER SHAPE FITTING BETWEEN FR 66 AND FR 68 AT S23R. REPLACED CENTER SHAPE FITTING PER SRM 51-44-11.SDR AALA202508144346Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #5 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.