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 DALA2025112808731Sign · detachedTHE EXIT SIGN FELL OFF THE CEILING. SECURED EXIT SIGN COVER. (LP 1325253)SDR DALA2025112808729Sign · faultedEXIT SIGN AT 3R IS PERMINATELY ILLUMINATED. BRIGHT FOR PAX. AND SHOULDNT BE ON DURING FLIGHT. ALL EMERGENCY LIGHTS OPS GOOD AFTER A/C POWER RESET. (LP 1325181)SDR DALA2025112808727Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y450 BETWEEN FR 72 AND FR 74. SEAT TRACK REPLACED AS PER A330 SRM 51-42-11 REV127.03-NOV-16-2025. (LP 1325565)SDR DALA2025112808726Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-450 BETWEEN FR 72 AND FR 75. SEAT TRACK REPLACED AS PER A330 SRM 51-42-11 REV 127.03-NOV-16-2025. (LP 1325546)SDR DALA2025112808725Floor Support · corrodedCABIN FLOOR SUPPORT FOUND CORROSION AT FR 73 TO FR 74 BETWEEN YB AND YC1. REPLACED THE FLOOR SUPPORT AT FR 73 TO FR 74 BETWEEN YB AND YC1 AS PER A330 SRM51-72-11 REV127.03-NOV-16-2025. (LP 1325532)SDR DALA2025112808724Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74, -YA. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, -YA AS PER A330 SRM 51-72-11-911-001 REV127.02-OCT-09-2025. (LP 1325526)SDR DALA2025112808723Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74, YB. THE CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, YB AS PER A330 SRM 51-72-11-911-001 REV127.02-OCT-09-2025. (LP 1325516)SDR DALA2025112808722Floor Support · corrodedAIRCRAFT 3321, CABIN FLOOR SUPPORT FOUND CORROSION AT FR 73 TO FR 74 BETWEEN YA AND YB1. REPLACED THE FLOOR SUPPORT AT FR 73 TO FR 74 BETWEEN YA AND YB1 AS PER A330 SRM 51-72-11 REV127.03-NOV-16-2025. (LP 1325455)SDR DALA2025112808721Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74 -YC. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, -YC AS PER A330 SRM 51-72-11-911-001 REV127.02-OCT-09-2025. (LP 1325453)SDR DALA2025112808720Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74 YB1. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, YB1 AS PER A330 SRM 51-72-11-911-001 REV127.03-NOV-16-2025. (LP 1325449)SDR DALA2025112808719Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74 -YB1. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, -YB1 AS PER A330 SRM 51-72-11-911-001 REV127.02-OCT-09-2025. (LP 1325440)SDR DALA2025112808718Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74 YC. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, YC AS PER A330 SRM 51-72-11-911-001 REV127.03-NOV-16-2025. (LP 1325435)SDR DALA2025112808717Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74, YA. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, YA AS PER A330 SRM 51-72-11-911-001 REV127.03-NOV-16-2025. (LP 1325424)SDR DALA2025112808716Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT FR 76 STGR 26 LH. REPLACED THE SEAT TRACK AT FR 76 STGR 26 LH SRM 51-72-11 REV127.03-NOV-16-2025. (LP 1325418)SDR DALA2025112808715Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR33 TO FR34, Y1552. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR31 AND FR34, Y1552 AS PER A330 SRM 51-72-11-911-001 REV127.03-NOV-16-2025. (LP 1325410)SDR DALA2025112808714Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y-1959 BETWEEN FR 33 AND FR 37. SEAT TRACK REPLACED AS PER A330 SRM 51-72-11 REV127.03-NOV-16-2025. (LP 1325369)SDR DALA2025112808713Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR33 TO FR34, -Y1552. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR31 AND FR34, -Y1552 AS PER A330 SRM 51-72-11-911-001 REV127.03-NOV-16-2025. (LP 1325327)SDR DALA2025112808712Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR73 TO FR74, -YB. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR72 AND FR74, -YB AS PER A330 SRM 51-72-11-911-001 REV127.02-OCT-09-2025. (LP 1325323)SDR DALA2025112808711Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FR33, -Y1959. CORRODED SEAT TRACK REMOVED AND REPLACED BETWEEN FR31 AND FR37.1, -Y1959 AS PER A330 SRM 51-72-11-911-001 REV127.03-NOV-16-2025. (LP 1325318)SDR DALA2025112808710Seat Track · corrodedCABIN SEAT TRACK FOUND CORROSION AT Y1959 BETWEEN FR 53.5 AND FR 53.9. SEAT TRACK REPAIRED AS PER A330 SRM53-31-15-300-001 REV 127.03-NOV-16-2025. (LP 1325259)SDR EE4Y2025112823552Skin · corrodedDURING THE ACCOMPLISHMENT OF THE WORK CARD AS PER ALLEGIANT WORK CARD # A32X-572042-01-2-002 GENERAL VISUAL INSPECTION RELATED TO AD 2022-15-05, IT WAS FOUND ON RH WING, BOTTOM SKIN, REINFORCEMENT PLATE AT RIB 8 WITH CORROSION. REPAIRED RH WING, BOTTOM SKIN, RSDR CALA2025112811536Clamp · wornSTRONG ODOR AFTER START OF ENG 2. PASSENGERS REPORT DIFFICUTY T O BREATH AND SORE THROAT FOUND BOTH WATER EXTRACTOR FLEX HOSES LEAKING AND ONE CLAMP WORN AND LOOSE. REMOVED AND REPLACED BOTH HOSES AND ASSOCIATED CLAMPS IAW AMM 21-51-14. INITIAL RUN SMELL WAS DSDR REXA2026052700768Door Sill · crackedCRACK ON AFT RH DOOR LANDING AT FS 188.00 (LATCH CUT OUT OF ACCESS DOOR 212AR). RH DOOR LANDING AT FS 188.00 (LATCH CUT OUT OF ACCESS DOOR 212AR WAS REPLACED PER EA NO. CRJ953-21058 REV . IR, CRJ 900 SRM 51-42-06-001-001-A01 AND SRM 51-42-13-001-001-A01SDR REXA2026052700745Bracket · crackedCORROSION AT LIGHT, CLIP & SUPPORT STRUCTURE OF PRESS-TO-TEST INDICATOR LIGHT OF AFT WASTE TANK (BTW STGR 24RH AND STGR 23RH, FS 959.00). CORROSION AT LIGHT, CLIP & SUPPORT STRUCTURE OF PRESS-TO-TEST INDICATOR LIGHT OF AFT WASTE TANK (BTW STGR 24RH AND STGR 23SDR REXA2026052700744Angle · crackedCRACKED INTERNAL ANGLE OF EXTERNAL POWER RECEPTACLE SUPPORT STRUCTURE. CRACKED ANGLE OF EXTERNAL POWER RECEPTACLE SUPPORT STRUCTURE WAS REPLACED PER CRJ900 SRM SRM 51-42-06-001-001-A01, SRM 51-42-13-001-001-A01, SRM 51-42-10-001-001-A01 AND SRM 51-42-21-001-00SDR REXA2026052700737Hinge · corrodedCORROSION ON HINGES (2EA) AND HINGE FITTINGS (2EA) AT ACCESS FAIRING PANEL 196DR CORROSION ON HINGES (2EA) AND HINGE FITTINGS (2EA) AT ACCESS FAIRING PANEL 196DR WAS EVALUATED OUT OFF LIMITS PER CRJ900 SRM 51-10-06-001-001-A01 AND HINGES AND FITTINGS WERE REPSDR REXA2026052700736Hinge · corrodedCORROSION ON HINGES (2EA) AND HINGE FITTINGS (2EA) AT ACCESS FAIRING PANEL 196DR CORROSION ON HINGES (2EA) AND HINGE FITTINGS (2EA) AT ACCESS FAIRING PANEL 196DR WAS EVALUATED OUT OFF LIMITS PER CRJ900 SRM 51-10-06-001-001-A01 AND HINGES AND FITTINGS WERE REPSDR REXA2026052700735Hinge · corrodedCORROSION ON HINGES (2EA) AND HINGE FITTINGS (2EA) AT ACCESS FAIRING PANEL 196DR CORROSION ON HINGES (2EA) AND HINGE FITTINGS (2EA) AT ACCESS FAIRING PANEL 196DR WAS EVALUATED OUT OFF LIMITS PER SRM 51-10-06-001-001-A01 AND HINGES AND FITTINGS WERE REPLACED PSDR SWIA2026022575336Floorbeam · corrodedFOUND SURFACE CORROSION ON THE LH FLOOR BEAM UPPER FLANGE/SEAT TRACK MOUNTING SURFACE FS 571.50 - FS 584.00 & LBL 9.00. (C-CHECK RO 02/22/2026)PERFORMED FLOOR BEAM SPLICE REPAIR OF LH BEAM FS 571.50 - FS584.00 & LBL 9.00 WITH REFERENCE TO SRM 53-00-41 AND CSDR SWIA2026020975226Floorbeam · crackedSUSPECTED CRACK AT BS 280, COCKPIT FLOORBEAM AT RBL 9 AT FLOORPOST ATTACHMENT POINT. REPAIRED THE FLOORBEAM IAW SRM 53-11-43-201-003-A01, 51-42-13-001-001-A01, REV 38. COMPLETED TASK CARD 51-900-1002-SKY.SDR VNAA202601180019Skin · damagedIN REFERENCE TO: TASKCARD TRFKE00FCUS8, 8000FH PERM-REPAIR FUSELAGE SKIN LIGHTNING STRIKE DAMAGE ON SKIN ONLY (NO FASTENER AT DAMAGE LOCATION) WITHIN 8000FH, ACCOMPLISH PERMANENT REPAIR OF TEMP REPAIR PER 670-53-00-045 SECTION 1 PARAGRAPH B3. SEE ATTACHMENTS FSDR VNAA202601180018Skin · corrodedIN REFERENCE TO: TASKCARD TRFKE00FCUS8, 8000FH PERM-REPAIR FUSELAGE SKIN LIGHTNING STRIKE DAMAGE ON SKIN ONLY (NO FASTENER AT DAMAGE LOCATION) WITHIN 8000FH, ACCOMPLISH PERMANENT REPAIR OF TEMP REPAIR PER 670-53-00-045 SECTION 1 PARAGRAPH B3. SEE ATTACHMENTS FSDR YENA2025112801128Idg · failedFLT 133, BOS-SFO. (ETOPS), ELEC GEN1 FAULT ILLUMINATED IN FLIGHT RESETS WERE NOT SUCCESSFUL ( ENGINE DRIVEN GENERATOR CHANNEL (IDG, GCU, LINE CONTACTOR) IDG NOT DISCONNECTED ); PERFORMED OPS CHECK OF ENG 1 IDG IAW AMM 24-21-51. OPS CHECK GOOD , MDDR CLEARED, SDR SWAA2025123040382Tie Clip · crackedCRACKED TIE CLIP FWD FACE BS 500I, STR 26R AT FWD CARGO BAY. REPLACED THE TIE CLIP AND FASTENERS IAW SRM 51-40-02, AND DWG 143A1234, SHEET 14, REV A.SDR SWAA2025123040385Angle · crackedCRACKED ANGLE AFT FACE BS 500H, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02-OG-0, PARAGRAPH 9, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025123040175Angle · crackedNR 1 ENGINE INBD FAN COWL VERTICAL ANGLE AFT OF OIL SERVICE DOOR CRACKED UPPER END. NR 1 ENGINE INBD FAN COWL TO BE REMOVED, REPLACED AND INSTALLED ON 7111-E-17063-NG.SDR SWAA2025122940347Shield · corrodedCORROSION ON SHIELD WEB LOCATED BTW BS 492.4 TO BS 500A RBL 23 WL 156.1 AT FWD CARGO COMPARTMENT. REPLACED SHIELD WEB AND FASTENERS LOCATED AT FORWARD CARGO COMPARTMENT BETWEEN BS 492.4 TO BS 500A; RBL 23 AND WL 156.1 IAW B737-800 SRM 51-10-02-0G-0 PARAGRAPH SDR SWAA2025122946832Tie Clip · crackedCRACK ON TIE CLIP LOCATED FWD FACE BS 500I AT LEVEL STR 26R AT FWD CARGO COMPARTMENT. REPLACED TIE CLIP AND FASTENERS LOCATED FWD FACE BS 500I AT LEVEL STR 26R AT FWD CARGO COMPARTMENT IAW SRM 51-40-02 AND DWG 143A1234 SHEET 14 REV. A.SDR SWAA2025122940344Angle · crackedCRACKED ANGLE, BS 500I, STRINGER 28L IN THE FWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, AND DWG 143A7902, SHEET 320, REV-.SDR SWAA2025122940384Angle · crackedCRACKED ANGLE, BS 500H, STRINGER 26R IN THE FWD CARGO BAY. REPLACED THE ANGLE AND FASTENERS IAW SRM 51-40-02, SRM 51-10-02, PARAGRAPH 9, AND DWG 143A7505, SHEET 138, REV -.SDR SWAA2025122940386Angle · crackedCRACKED ANGLE, BS 500G, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-40-02-0G-0, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025122946833Angle · crackedCRACKED ANGLE, BS 500H, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE ANGLE IAW SRM 51-10-02-OG-0, PARAGRAPH 9, AND DWG 143A7505, SHEET 137, REV -.SDR SWAA2025122940346Support Angle · corrodedCORROSION ON SUPPORT ANGLE LOCATED BS 500I, STRINGERS 26L - 26R, WL 156.1. REPLACED SUPPORT ANGLE & FASTENERS IAW SRM 51-10-02-0G-0, PARAGRAPH 9, SRM 51-40-02-0G-0, AND DRAWING 143A9481, SHEET 17, REV-.SDR SWAA2025121940241Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB, LBL 30, BS 663. CRACK LENGTH: 0.437 INCH. REPAIRED PAX CABIN PRESSURE DECK, BTW BS 663.75 & 675, LBL 20 & 60 IAW EA 25-153-03322-WIP1, & EA 25-153-03322.SDR SWAA2025121840404Access Panel · elongatedELONGATED HOLES ON LT WING ACCESS PANEL 561AB. REPAIRED ACCESS PANEL 561AB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2025121840354Skin · crackedCRACKED LOWER SURFACE OF LEADING EDGE SLAT 3 NOSE SKIN AT ACTUATOR LOCATION, AROUND THE FASTENER ON THE LT WING. PERFORMED A REPAIR ON LOWER SURFACE OF THE L/E SKIN OF SLAT 3 IAW SRM 57-42-01-2R-8.SDR SWAA2025121748007Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB RBL 41, BS 663 IN THE PASSENGER CABIN. PERFORMED PERMANENT REPAIR ON HORIZONTAL PRESSURE DECK WEB RBL 41 STA 663 AT PASSENGER CABIN IAW SRM 53-40-51-2R-2 REPAIR 2.SDR SWAA2025121740240Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB RBL 41, BS 663 IN PASSENGER CABIN. PERFORMED A PERMANENT REPAIR ON THE HORIZONTAL PRESSURE DECK WEB IAW SRM 53-40-51-2R-2, REPAIR 2.SDR SWAA2025121640226Light · brokenBROKEN FLOOR LIGHTING PHOTOLUMINESCENT STRIP IN THE PAX CABIN (10 EA). REPLACED LIGHTS IAW MT 733-50-01, TTG8Q00FRFML.SDR DALA2025120808963Pan · corrodedAFT CARGO: C-2 DOOR THRESHOLD PAN CORRODED. REPLACED REPAIR AFT CARGO DOOR LOWER JAMB PAN IAW SRM 53-20-15-2R, PROCEDURE 7, REPAIR 7. AFT CARGO DOOR LOWER JAMB PAN CORROSION SPLICE REPAIR. (1325090)