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 AALA202601019638Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: L2 PASSENGER DOOR EMERGENCY CYLINDER/ACCUMULATOR REQUIRES SERVICING DUE TO LOW NITROGEN PRESSURE. MAINTENANCE SERVICE L2 DOOR EMERGENCY CYLINDER/ACCUMULATOR WITH NITROGEN IAWAMM 52-10-00.SDR DALA2026010100002Light · damagedEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE, EMERGENCY DOWN LIGHT AT 2L MISSING ITS COVER / INTERIOR. REPLACED LENS AFT/LEFT. (LP 1379266)SDR FDEA202512312299Skin · dentedLEFT WING, INBOARD MAIN FLAP, LOWER SURFACE, 89" FROM OUTBOARD EDGE, 10" DOWN FROM LEADING EDGE, LOWER SKIN IS DENTED AS MARKED. BONDED REPAIR ON L/H WING, I/B MAIN FLAP, LOWER SURFACE, 89" FROM O/B EDGE, 10" DOWN FROM L/E, LOWER SKIN (WS 341). SEE JPF FORSDR WX0A2025123132689Unknown · odor(AIRCRAFT NOT GROUNDED) DIRTY SOCK ODOR EVENT. FWD FA'S DETECTED IT DURING FINAL DESCENT. PILOTS DETECTED IT AFTER LANDING DURING TAXI TO PARKING. PERFORMED TC 21-000-002, PER STEP 4.D.4. APU MEL CAN BE CLEARED IF NO ODOR IS REPRODUCED. NO ODOR REPRODUCED AT SDR 2025FA0000838Housing · wrong partRH4 CABIN SEAT ROLLER HOUSING IS WRONG MANUFACTURING SPEC. COMPLIED WITH B/E AEROSPACE NTO-431193-001 REV A. CHANGE THE IDENTIFIED CORNERS OF FLOOR FITTING P/N 431193-15. COLLINS DRAWING 431193-15 REV D.SDR DALA2025123109545Unknown · odorDIV/DE/FUMES- DIVERTED TO ATL DUE TO ACRID CHEMICAL SMELL IN CABIN ROW 19 AFT. RAN ENGINE/APU BLEEDS, LEFT-RIGHT PACKS. INSPECTED LEFT-RIGHT EMERGENCY DOOR EXIT HEATER BLANKETS, PSUS, COFFEE MAKERS, OVENS, ELECTRICAL OUTLETS AND IFE. NO TROUBLE FOUND. UNABLESDR DALA2025123109543Actuator · trippedFCNT/DE- DUE TO LEADING EDGE DISAGREE ON APPROACH. CORRECTIVE ACTION: #6 INBOARD AND OUTBOARD SLAT ROTARY ACTUATOR FOUND TRIPPED. R/R #6 INBD AND OTBD SLAT ROTARY ACTUATORS.SDR DALA2025123109542Girt Bar · out of adjustR2 DOOR SLIDE LIGHT INOP DURING GIRT BAR LUBE. PERFORMED ADJUSTMENT OF THE GIRT BAR MECHANISM PER B757 AMM 52- 11-25. OPS CHECKS GOOD. ALL RIIS COMPLETE. (7684770)SDR DALA2025123109530Door Frame · gougedGOUGE BETWEEN FASTENERS C & D OF FR 20R DOUBLE JOGGLE AFT OF R1 DOOR. REPAIRED PER ERA 631197-14. (1378104)SDR DALA2025123109529Frame · crackedCRACK INDICATION FOUND ON FRAME 20RH DOUBLE JOGGLE AREA HOLE 5. REPAIRED PER ER/A 630623-14AD. (1377940)SDR DALA2025123109527Skin · nickedNICK EXTERNAL SKIN LOCATED BTW FR 67 TO FR 68 AND BTW STR 26L TO STR 27L LOWER FUSELAGE. REPAIRED PER ERA 631213-14. (1377959)SDR DALA2025123109525Support · corrodedCORROSION LOWER SILL LOCATED BETWEEN FR68 AND STR23R AFT GALLEY AREA. REPLACED LOWER SILL (1E/A), LOWER CORNER (2E/A), BRACKETS (11E/A ), DRAIN (2E/A), CENTER FITTING (1E/A), SPLICE (4E/A) GIRT BARFITTINGS (2EA). AND FASTENERS LOCATED BETWEEN FR66 TO FR68 ANSDR AALA202512316409Circuit Breaker · trippedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT LIGHT BATTERY PACK M1695 AT STA 565 WL213 RBL 68. IS INOP. MAINTENANCE FOUND CIRCUIT BREAKER 18-3 B10 OUT. RESET CIRCUIT BREAKER AND ACCOMPLISHED SATISFACTORY EMERGENCY LIGHT OPERATIONAL CHECK PER AMM 33-51-00.SDR K11A2025123100365Seat · faultedREJECTED TAKEOFF AT 115 KNOTS. THE CAPTAINS SEAT UNLOCKED AND SLAMMED TO THE AFT. ADJUSTED CAPTAINS SEAT IAW B737 AMM 25-11-11, OPS CHECK GOOD NO DEFECTS NOTED. PERFORMED CONDITIONAL INSPECTION FOR HIGH SPEED STOPPAGE ONCE BRAKES COOLED TO TOUCH IAW B737 AMMSDR REXA2026073101382Support Fitting · corrodedCORROSION ON CARGO NET SUPPORT FITTINGS BS 515, 565, 629, & 661+16, LBL 2 IN THE FWD BAGGAGE BAY. DUE TO EXCESSIVE DAMAGE ON CARGO NET SUPPORT FITTINGS BS 515, 565, 629, & 661+16, LBL 2, THE PARTS WILL BE REPLACED IAW SRM 51-10-06-001-001-A01, REMOVED & INSDR REXA2026073101381Support Fitting · corrodedCORROSION ON CARGO NET SUPPORT FITTINGS BS 515, 565.00, 629, & 661+16, LBL 2 IN THE FWD BAGGAGE BAY. DUE TO EXCESSIVE DAMAGE ON CARGO NET SUPPORT FITTINGS BS 515, 565, 629, & 661+16, LBL 2 AT FWD BAGGAGE-BAY, THE PARTS WILL BE REPLACED IAW SRM 51-10-06-001-00SDR REXA2026052600666Stringer · corrodedSECONDARY NRC FROM NRC 358: AFTER REMOVAL OF FRAME ANGLE, CORROSION AT STGR 19RH BTW FS 661.00 + 74.00 AND FS 661.00 + 90.00. STGR 19RH BTW FS 661.00 + 74.00 AND FS 661.00 + 90.00 WAS EVALUATED OUT LIMITS PER CRJ-900 SRM 53-31-03-101-004-A05 AND SRM 53-00-00-1SDR DALA2026042902701Cover · missingRIGHT SIDE RUDDER MID HOIST POINT COVER MISSING. FWD TO NEF 25-73-06. C/W REMARKS. INSTALLED RUDDER HOIST POINT COVERS PER A319 IPC 11-25. OK FOR SVC. (LP: 1377181). AIRCRAFT WS GROUNDEDSDR SWIA2025123075875Angle · crackedBS 484 LBL 27 CLIP HAS CRACK AT UPPER RADIUS. REMOVED AND INSTALLED NEW CLIP AT BS 484 LBL27 REF SRM 51-42-21 AND REO 601R-53-41-059 REV. -C DATE: 2020-03-11. COMPLIED WITH ALL STEPS OF REO 601R-53-41-059 REV. -C DATE: 2020-03-11. COMPLIED WITH TASK CARD 51-9SDR SWIA2025123075849Door Frame · crackedFS 605 ( FRAME) AFT CARGO JUST ABOVE DOOR OPENING FRAME FLANGE JUST ABOVE STR 9.0 AND BELOW FLANGE IS CRACKED AT RIVET LOCATIONS. MARKED. REPAIRED FS 605 ( FRAME) AFT CARGO JUST ABOVE DOOR OPENING FRAME FLANGE JUST ABOVE STR 9.0 AND BELOW, FLANGE IS CRACKEDSDR SWIA2025123075843Casting · crackedFS 460 AT RBL 9.0 CASTING HAS CRACK AT CASTING UPPER RADIUS. INSTALLED NEW CASTING FITTING AT FS460, RBL9 REF. SRM 51-42-06. SRM 51-42-21, DWG 601R31118 REV. -L AND DWG 601R31146 REV. -J.COMPLIED WITH SKYWEST TASK CARD 51-900-1003.SDR SWIA2025123075806Frame · corrodedCORROSION FS589.00 FRAME FWD & AFT WEB LOWER FLANGE STGR20L -23L. REMOVED AND INSTALLED NEW FRAME FS589 REF. DWG 601R36025 REV-P AND CRJ200 SRM 51-42-06. COMPLIED WITH SKYWEST TASK CARD 51-900-1003-SKY AND FORM M-337. SEE CONTINUE CARD FOR DETAILS.SDR SWIA2025123075800Frame · corrodedCORROSION FS605.00 FRAME FWD & AFT WEB LOWER FLANGE STGR20L -22L. REPLACED FRAME FS605.00 BETWEEN STGR20R AND STGR20L REF. DWG 601R36026 REV-AF, DWG 601R35005 REV-AG AND CRJ200 SRM 51-42-06. REPAIRED FRAME FS605.00 BETWEEN STGR20L AND STGR18L PER REO 601R-53-SDR SWIA2026040375652Roller · chafedRIGHT HAND OUTBOARD FLAP VANE ROLLER GUIDES, CHAFED, MULTIPLE LOCATIONS. REPAIRED RIGHT HAND OUTBOARD FLAP VANE ROLLER GUIDES IAW REO 670-57-53-452 REV -.SDR SWIA2026040375644Former · corrodedWHILE ACCESSING PAX DOOR WED FOUND FWD PAX DOOR FORMER TO BE CORRODED REQUIRES REPLACEMENT. REMOVED AND REPLACED PAX DOOR FWD FORMER IAW SRM 51-42-06-001-00-A01 REV 38D, AND SRM 51-42-21-001-001-A01 REV 38D, SRM 51-40-11-001-001-A01, REV 38D.SDR SWIA2026031875539Angle · corrodedCORROSION FOUND ON FRAME REINFORCING ANGLE AT BS 589 BETWEEN S20R - 20L. EVALUATED CORROSION ON REINFORCING ANGLE AS OUT-OF-LIMITS. REMOVED CORRODED REINFORCING ANGLE AND INSTALLED A NEW REINFORCING ANGLE IAW SRM 51-42-06, AND DWG 601R36025, REV P, SHEET 1.SDR AALA202603114465Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD FRAME LH, POCKET INTERNAL AREA A T 2 O CLOCK OF UPPER BOLT, CRACK LENGTH IS 0.080 IN. MAINTENANCE PERFORMED TIME LIMITED REPAIR (MIRROR FITTING REPAIR) LOCATED ON WINDSHIELD FRAME CENTER POST LSDR AALA202603111871Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON CONTINUITY FITTING RH, CRACK IS IN VERTICAL DIRECTION, CRACK LENGTH IS 0.120 IN. MAINTENANCE REPLACED CONTINUITY FITTING RH BETWEEN FR1 TO FR4 AND Y0 IAW EA # 371162, DWG # R53112919 ISSUE L AND DWG R531SDR AALA202603119832Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON CONTINUITY FITTING LH, CRACK IS IN VERTICAL DIRECTION, CRACK LENGTH IS 0.135 IN. MAINTENANCE REPLACED CONTINUITY FITTING LH BETWEEN FR1 TO FR4 AND Y0 IAW EA # 371162, DWG # R53112919 ISSUE L AND DWG R531SDR REXA2026030900171Fitting · crackedCRACK ON BOTTOM ANGLE POST (2 EAS) LT & RT ON INTERNAL STRUCTURE BTWN WINDSHIELD AND SIDE WINDOWS. BOTTOM ANGLE POST (2 EAS) LH/RH ON INTERNAL STRUCTURE BTWN WINDSHIELD AND SIDE WINDOWS. WERE REPLACED PER CRJ900 SRM 51-42-21-001-001-A01.SDR REXA2026030900170Fitting · crackedCRACK ON BOTTOM ANGLE POST (2 EAS) LH/RH ON INTERNAL STRUCTURE BTWN WINDSHIELD AND SIDE WINDOWS. BOTTOM ANGLE POST (2 EAS) LH/RH ON INTERNAL STRUCTURE BTWN WINDSHIELD AND SIDE WINDOWS. WERE REPLACED PER SRM 51-42-21-001-001-A01SDR AALA202603058124Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD FRAME RH, POCKET INTERNAL AREA AT 10 O' CLOCK OF UPPER BOLT,CRACK LENGTH IS 0.072 IN. MAINTENANCE PERFORMED TIME LIMITED REPAIR (MIRROR FITTING REPAIR) LOCATED ON WINDSHIELD FRAME CENTER POST LSDR SWAA2026020356928Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 193CL BODY FAIRING AT FUSELAGE EXTERIOR. REPAIRED ACCESS PANEL 193CL BODY FAIRING AT FUSELAGE EXTERIOR IAW SRM 51-70-05-2R-9, REPAIR 9.SDR SWAA2026020356929Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 193CR BODY FAIRING, FUSELAGE EXTERIOR. REPAIRED THE ACCESS PANEL IAW SRM 51-70-05-2R-8, REPAIR 8.SDR SWAA2026020356927Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561BB AT THE RT WING T/E. REPAIRED THE ACCESS PANEL IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026020356939Skin · crackedCRACK AROUND THE FASTENER AT NR 2 SLAT, LOWER SURFACE OF THE L/E SLAT NOSE SKIN AT ACTUATOR RIBS. REPAIRED THE NR 2 SLAT LOWER SURFACE NOSE SKIN IAW SRM 57-42-01-2R-8.SDR SWAA2026012956608Skin Panel · crackedCRACK INDICATION FOUND ON THE LT HORIZONTAL STAB LOWER SKIN PANEL HSS 193.9 RIB & 16 INCHES FROM FRONT SPAR, INBD SIDE OF RIB. CRACK LENGTH: 0.900 INCH. REPAIRED HORIZONTAL STAB LOWER SKIN IAW SRM 51-40-02, SRM 55-10-01-2R-11, REPAIR 11.SDR SWAA2026012756761Support · corrodedCORRODED SUPPORT ZEE BTWN BS 500A - 500C, RBL 22, WL156 IN THE FWD CARGO BAY. REPLACED THE SUPPORT ZEE IAW SRM 51-10-02, ITEM 9, SRM 51-40-02, AND DWG 143A7500, SHEET 71, REV-.SDR AALA202601273185Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 953, LBL 53. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202601279990Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 960, LBL 54. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR ASAA2025123063955Web · gougedAFT CARGO BAY SILL WEB HAD A GOUGE AND SPOTS OF CORROSION. GROUNDED - YES. R & R THE AFT CARGO SILL WEB IAW SRM 51-40-02-0G-0.SDR ASAA2025123063954Plate · corrodedFWD CARGO RT SIDE PLATE HAD CORROSION AT MULTIPLE SPOTS, BS 500A - 500D. GROUNDED - YES. R & R THE FWD CARGO RT SIDE PLATE IAW SRM 51-40-02-OG-OW.SDR AALA202601274466Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN ALONG RIB LINE AT STABILIZER STA 92.70, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202601237626Window · frayedAIRCRAFT IN BASE MAINTENANCE: LEFT FORWARD OVER THE WING EMERGENCY HATCH WINDOW FRAYED. OLD UNSERVICEABLE WINDOW WAS REMOVED AND A NEW WINDOW WAS INSTALLED. PER AMM 56-21-00.SDR ASAA2025123063892Web · corrodedFWD CARGO BAY SILL WEB HAS CORROSION ON MULTIPLE SPOTS. GROUNDED - YES. REMOVED AND REPLACED THE FWD CARGO BAY SILL WEB IAW SRM 51-40-02-OG-O.SDR AALA202601220719Spring · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND ELEVATOR TAB CONTROL MECHANISM SPRINGS FORWARD ATTACHMENT SLEEVES SHOW SIGNS OF CORROSION. REMOVED AND REPLACED RIGHT HAND ELEVATOR TAB CONTROL MECHANISM SPRING FORWARD ATTACHMENT SLEEVES, PER B737NG AMM 27-31-34. ACCOMSDR AALA202601220594Spring · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND ELEVATOR TAB CONTROL MECHANISM SPRINGS FORWARD ATTACHMENT SLEEVES SHOW SIGNS OF CORROSION. REMOVED AND REPLACED LEFT HAND ELEVATOR TAB CONTROL MECHANISM SPRING FORWARD ATTACHMENT SLEEVES. PER B737NG AMM 27-31-34. ACCOMPLSDR CALA2026012213138Stub Beam · gougedR1 DOOR HANDLE BOX CUTOUT, UPPER TORQUE TUBE BUSHING STUB BEAM GOUGED. REMOVED WORN STUB BEAM IAW SRM 51-40-02-0G-0. A NEW STUB BEAM FABRICATED AND INSTALLED IAW SRM 51-40-02 & DWG 141A6516, REV F. RESTORED LEVELING COMPOUND IAW AMM 51-41-11-350-801.SDR SWAA2026011956751Support Angle · crackedBAFFLE SUPPORTING ANGLE AFT SIDE BS 500B RBL 25 IS CRACKED. REMOVED AND REPLACED FCB BAFFLE ANGLE FROM BS 500B FRAME RBL 25R AFT SIDE IAW SRM 51-40-02-0G-0 AND DWG 143A7505 REV -.SDR AALA202601155948Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE ASSEMBLY BETWEEN BS 500F AND BS 500G AT RBL 26. REPLACED BAFFLE ASSEMBLY PER SRM 53-30-53-2R-1.