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 DALA2025122309338Control Unit · faultedDECLARED EMERGENCY DUE TO ANTI-SKID LIGHT ILLUMINATED AFTER TAKEOFF. PERFORMED AACU BITE TEST. FAILS AACU REPLACED SAME. OPS CHECKED GOOD. (LP 8158330)SDR DALA2025122309337Aoa · faultedRTO- APPROX. 85 KNOTS DUE TO AIRSPEED SPLIT. PRESSURIZED CAPTAIN'S AND FIRST OFFICER'S PITOT SYSTEM. FOUND 1 KNOT DISAGREEMENT. REPLACED LEFT AND RIGHT AOA SENSORS. AIRSPEEDS AGREE. AIRCRAFT RETURNED TO SERVICE. (LP 7933092)SDR CALA2025122312317Light · shortedFWD R1 DOOR EMERGENCY LIGHT INOPERATIVE. R1 DOOR EXIT SIGN CONNECTOR FOUND LEFT CLOSET FLOOR LIGHT ASSY SHORTED, REPLACED LIGHT ASSY AND BLOWN FUSE IN BATTERY CHARGER, EMERGENCY LIGHTS OPS CHKD GOOD, OK TO CONTINUE.SDR CALA2025122312316Light · inoperativeEMERGENCY PATH LIGHT SEAT D INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT IAW STEPS IN IFM25-25-89. OPS CHECKED GOOD.SDR HNAA2025122300864Proximity Switch · faultedEICAS SPOILER FAIL WITH SPOILER INDICATING OPEN IN CRUISE. APPLIED QRH, CLEARED AFTER 40 MINUTES. FOUND ONE OCCURANCE OF SPOILER IB FAIL ON CMC, T/S PER FIM 27-63-00-810-806-A. SUSPECT INTERMITTENT FAIL OF INBD PROXIMITY SWITCH. R & R THE LT & RT INBD PROSDR GTIA2025122239221Flashlight · inoperativeCAPT FLASHLIGHT INOPERATIVE. R & R THE FLASHLIGHT IAW AMM 25-65-00. OPS GOOD, NO FURTHER DEF NOTED.SDR 2025F00289Water Separator · leakingRIGHT WATER SEPARATOR HAS EXCESSIVE WATER LEAKING FROM IT.SDR JR2R20251222666Fairing · damagedLIGHTNING STRIKE DAMAGE TO LH #3 FLAP FAIRING. REPAIREDSDR IXXA20251222001Skin · corroded.CORROSION OF THE UPPER EXTERIOR SURFACE OFTHE RIGHT WING UPPER SKIN FWD OF THE AILERONSDR DALA2025122209280Oil System · leakingAIRCRAFT 5014, TRASIENT FUMES NOTED ON DESCENT BETWEEN FL300 AND 12000 FLEET. DESCRIBED AS BURNING RUBBER SMELL IN AFT GALLEY AREA. CORRECTIVE ACTION: ENGINE #1 OIL FOUND INSIDE NOSE INLET CONE. REPLACED ENG #1 FAN SHAFT COVER SEAL PER A321 AMM 72-15. (LP 7909SDR DALA2025122209279Control Unit · failedAIRCRAFT 3055, LEAVING ATL CRUISING AT FL300, FLIGHT ATTENDANTS REPORTED VERY STRONG "BURNING RUBBER" SMELL FROM DOOR 3 AFT TO AFT GALLEY. AFTER APPROX. 10 MINS AT FL300, ODOR DISSIPATED. UPON DESCENT DURING ARRIVAL AT FL300, SAME ODOR RETURNED. DEFFERRED 3LSDR YENA2025122201240Pump · failedFLT # 700 LAX- FLL (ETOPS) " ENG 1 HEAT SYS DEGRADED ECAM MESSAGE AFTER LANDING CLEARED ON ENGINE SHUTDOWN (HEAT SYS DEGRAD CAUTIONS ON ECAM EWD ).; IDLE RAN L ENG PER AMM 71-00-00. OPS CK'D SATIS & ITEM OK FOR SVC. MX-4 UPDATED & PLCD REMOVED. (IFPC WAS REMSDR FDEA202512222283Crease Beam · corrodedMCC FLOOR BTWN STA 440 - 460 (RH CREASE BEAM) RBL 64.5 APROX WAS FOUND ON LOCATION WITH CORROSION. CORROSION OUT OF LIMITS AT MAIN CARGO COMPARTMENT, CREASE BEAM INBOARD CHORD BTW STA 440-460 RBL 64.40 WAS REPAIRED IAW B-757 SRM 53-00-13-2RSDR FDEA202512222282Crease Beam · corrodedMAIN CARGO BAY, FLOOR INBOARD CHORD HAS SURFACE CORROSION AROUND NUTS PLATE BETWEEN BS 860 AND 879 CORROSION OUT OF LIMITS AT MAIN CARGO BAY CREASE BEAM INBOARD CHORD BTW STA 860 - 879 RBL 64 WAS REPAIRED IAW SRM 53-00-13-2R.SDR FDEA202512222281Floor Panel · damagedMAIN DECK - THE TOP OF FLOOR PANEL 222CFF IS DAMAGED. FABRICATED NEW FLOOR PANEL 222CFF, MPN: 141T5856-116, RBL 54.75- RBL 77.50, STA 285-412 IN REF. TO BOEING DWG 141T5856-116. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLATION OF TSDR FDEA202512222280Floor Panel · damagedMAIN DECK - THE TOP OF FLOOR PANEL 222BFF IS DAMAGED (DOT#15). FABRICATED NEW FLOOR PANEL 222BFF, MPN: 141T5856-106, RBL 33- RBL 54.75, STA 285-412 IN REF. TO BOEING DWG 141T5856-106, AND SR67-53-009. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPSDR FDEA202512222279Floor Panel · damagedMAIN DECK - THE TOP OF FLOOR PANEL 221CFF IS DAMAGED. FABRICATED NEW FLOOR PANEL 221CFF, MPN: 141T5856-105, LBL 11- RBL 11, STA 282-412 IN REF. TO BOEING DWG 141T5856-105, AND SR67-53-009. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLASDR DALA2025122209277Fan · failedATB DUE TO ELECTRICAL SMELL IN COCKPIT. REPLACED BLOWER FAN. (LP 8123408)SDR DALA2026082104776Frame · corrodedCORROSION ON FORMER AT FRAME 946 BETWEEN STRINGER 30 AND 29L, REPAIRED FORMER PER B717-200SRM 53-00-06-2R. (1362231) (AIRCRAFT GROUNDED).SDR DALA2026082104775Frame · corrodedCORROSION ON FORMER AT STATION 954, ON BOTH SIDES OF LONGERON 29L, CORRECTIVE ACTION: REPAIRED FORMER PER B717-200SRM 53-00-06-2R. (1362237) (AIRCRAFT GROUNDED).SDR SWIA2025122175887Skin · corrodedFUSELAGE BELLY HAS CORROSION ALONG STGR 27, BETWEEN FS 559.80+80 AND FS 574.00 UPON FURTHER INSPECTION - FOUND CORROSION ON FUSELAGE BELLY ALONG STR 27 TO BE BETWEEN FS559.00+80 AND FS 559.00+112 ONLY. COMPLIED WITH REO 601R-53-51-727 DATED: 2026-01-05 REV: SDR AALA202602163021Fork · burredAIRCRAFT IN BASE MAINTENANCE: BURRED MATERIAL ON LOWER LATERAL FITTING LH SIDE IN AFT AVIONIC COMPARTMENT ON RACK 80VU (1EA) MEASURE OF DIAMETER OF HOLE IS: 0.476 INCH. MAINTENANCE ACCOMPLISHED INTERIM REPAIR ON 80VU AREA LH LOWER LATERAL FITTING IAW EA 370983SDR AALA202602160634Fork · wornAIRCRAFT IN BASE MAINTENANCE: BURRED MATERIAL ON LOWER LATERAL FITTING RH SIDE IN AFT AVIONIC COMPARTMENT ON RACK 80VU MEASURE DIAMETER AFFECTED HOLE IS: 0.477 INCH. MAINTENANCE ACCOMPLISHED INTERIM REPAIR ON 80VU AREA RH LOWER LATERAL FITTING IAW EA 370983.SDR AALA202602052990Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500G AT RBL 26. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR VNAA20260201011Drip Tray · corrodedCORROSION ON DRIP TRAY RH/LH OF FS280.00 AT CABIN FLOOR STRUCTURE. CORROSION ON DRIP TRAY LH OF FS280.00 AT CABIN FLOOR STRUCTURE WAS EVALUATED DUE TO EXCESSIVE CORROSION PER CRJ-900 SRM 53-00-00-101-001-A01 AND REPLACED PER SRM 51-42-13-001-001-A01 AND CORROSDR SWAA2026012754671Stiffener · crackedCRACKED VERTICAL STIFFENER, BS 540, LBL 24.97 BULKHEAD AREA IN THE FWD CARGO BAY. REPLACED THE VERTICAL STIFFENER IAW SRM 51-40-02, SRM 51-10-02, ITEM 9, & DRAWING 111A2001, REV-, SHEET 77.SDR AALA202601278023Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON TOP FACE OF PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL, UNDER LAVATORY MOUNT, AT BS 946, RBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND EA 371448.SDR SWAA2026012654554Bracket · crackedCRACKED SUPPORT BRACKET ON PNEUMATIC DUCT BS 540, LBL 6, AIR CONDITIONING BAY. REPLACED THE SUPPORT BRACKET IAW SOPM 20-50-01, REV 40.SDR SWAA2026012654555Support Bracket · crackedCRACKED SUPPORT BRACKET, IRSS182 T/E RT WING. REPLACED THE SUPPORT BRACKET IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 115A2510, SHEET 12, REV -. MEASUREMENT OF CRACK: L: 0.511 INCHES.SDR SWAA2026012254553Support Angle · crackedCRACK ON ANGLE SUPPORT LOCATED TRAILING EDGE ORSS 273 RT WING . REMOVED AND REPLACED THE SUPPORT ANGLE AND FASTENERS LOCATED AT FIXED TRAILING EDGE IAW SRM 51-10-02, PARAGRAPH 9, AND SRM 51-40-02.SDR HNAA2026012100036Inlet · corrodedRIGHT ENGINE INLET HAS CORROSION ON THE INTERNAL LWR SIDE WHERE THE GENERATOR INLETS ARE LOCATED. RAR RH ENGINE INLET IAW EMB 145 AMM 71-60-01,SDR SWAA2026011954389Pressure Deck · crackedCRACK INDICATION ON HORIZONTAL PRESSURE DECK WEB, RBL 41, BS 663. CRACK LENGTH 0.375 INCH. PERFORMED REPAIR ON HORIZONTAL PRESSURE DECK WEB LOCATED BTW RBL 30 TO RBL 60 BTW BS 663.75 TO BS 675 AT PASSENGER CABIN IAW SRM 53-40-51-2R-2, REPAIR 2.SDR SWAA2026011954657Access Panel · crackedCRACKED BLADE ACCESS PANEL 343AT AT RT HORIZONTAL STAB. REPLACED BLADE ON ACCESS PANEL 343AT AT RT HORIZONTAL STAB IAW SRM 51-40-02-0G-0, AND DWG 186A3101, SHEET 13, REV C.SDR SWAA2026011654559Support Angle · crackedCRACKED SUPPORT ANGLE, FLOOR STRUCTURE, BS 695, BL 0 IN PAX CABIN. REPLACED THE SUPPORT ANGLE AND FASTENERS IAW SRM 51-40-02, AND DWG 273A9110, SHEET 6, REV A.SDR SWAA2026011554557Crossbeam · crackedCRACK BRAKE PANEL FLOOR STRUCTURE BS540 AND BTW LBL24.82 TO BL0 AT PASSENGER CABIN. REPLACED BRAKE PANEL FLOOR STRUCTURE BS540 AND BTW LBL24.82 TO BL0 AT PASSENGER CABIN IAW SRM 51-40-02-0G-0 AND DWG 143A0060 SHEET 36 REV.ASDR SWAA2026011554556Crossbeam · crackedCRACKED BRAKE PANEL FLOOR STRUCTURE BS540 AND BTW RBL24.82 TO BL0 AT PASSENGER CABIN. REPLACED BRAKE PANEL FLOOR STRUCTURE BS540 AND BTW RBL24.82 TO BL0 AT PASSENGER CABIN IAW B737-700 SRM 51-40-02; SRM 51-10-02 STEP 9 AND DWG 143A0060 SHEET 36 REV.A MEASURE SDR AALA202601156746Track · chafedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR FUSELAGE CUTOUT STRUCTURE FORWARD FRAME MOUNTED UPPER LATCH TRACK FITTING HAS A CHAFE. REMOVED AND REPLACED FORWARD FRAME MOUNTED UPPER LATCH TRACK FITTING AFT ENTRY DOOR. PER SRM 51-40-02-0G. PERFORMED SATISFACTORYSDR AALA202601154406Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 948, LBL 52. REPLACED INTERCOSTAL IAW AARD 51-00-05-01.SDR SPAA202601154001Battery · inoperativeDURING ACCOMPLISHMENT OF C4 CHECK MAINTENANCE, TASK CARD 25-070-01-01, OPERATIONAL TEST OF CABIN EMERGENCY FLASHLIGHTS, ONE FLASHLIGHT BATTERY WAS FOUND TO BE DEPLETED.SDR CALA2026011312916Floorbeam · corrodedCABIN FLOORBEAM STA 380 RBL 5 WITH CORROSION AREA. REMOVED CORROSION ON FLOORBEAM BS 380, LBL2 AND RBL 5 & INSTALLED REPAIR IAW EC/RA #5330-07672, REV. ORIGINAL.SDR SWAA2026010754608Battery Pack · inoperativeEMERGENCY EXIT LIGHTS OVER RT EMERGENCY EXITS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. EMERGENCY LIGHTS OVER R/H EMERGENCY EXITS OPS CHKD GOOD IAW MM.33-51-06.SDR CALA2026010712735Skin · crackedRIGHT STAB LOWER SKIN NR 2, CRACK INDICATION FOUND, HSS 184.70 INBD OF INBD ROW OF FASTENERS, AFT OF FWD SPAR. REMOVED THE DAMAGE & ACCOMPLISHED A REPAIR OF THE DAMAGE AT THE RT STAB LOWER SKIN NR 2 HAS CRACKED AT BS 184.70 INBD OF INBD ROW OF FASTENERS AFT OSDR CALA2026010612695Intercostal · corrodedINTERCOSTAL BETWEEN FR 860 AND FR 900 R/H SIDE OF CENTER HAS EVIDENCE OF CORROSION. REMOVED AND REPLACED INTERCOSTAL BETWEEN FR860 AND FR900 RH SIDE IAW SRM 51-40-02-OG-0.SDR SWIA202601050221Skin · dentedDURING INSPECTION OF PANELS FOUND DENT IN RT AILERON UPPER SKIN, NEAR THE INBD EDGE. REPAIRED RH AILERON UPPER SKIN NEAR THE INBD EDGE IAW REO 601R-57-61-887 REV -, AND COMPLIED WITH TASK CARD 51-900-1003-SKY.SDR JJBA20260102040Battery · inoperativeEMERGENCY LIGHT BATTERY (FWD R)/WRG FAULT. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY AT FWD R POSITION. OPS CHECK SAT.SDR AALA202601018306Hinge Fitting · damagedAIRCRAFT IN BASE MAINTENANCE: LT MLG DOOR FWD ATTACH FITTING BEARING DAMAGED. MAINTENANCE REPLACED FITTING (HINGE ASSY) LT MLG DOOR IAW A321 SRM 51-72-11-911-001.SDR SWAA2025122954617Battery Pack · no testG1 EXIT LIGHT INOPERATIVE. PERFORMED EMERGENCY LIGHTS OPERATIONAL TEST IAW AMM 33-51-00-710-801 AND TEST FAILED. UPON INVESTIGATION FOUND ALL EMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1674 DO NOT TURN ON PER WDM 33-51-12 AND 33-51-21. BATTERY PACK M167SDR SWAA2025122954619Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1674 DID NOT TURN ON. REPLACED THE POWER SUPPLY BATTERY PACK M1674 IAW AMM 33-51-06-960-805, AND PERFORMED GOOD EMERGENCY LIGHTS - OPS TEST IAW AMM 33-51-00-710-801.SDR SWAA2025122954618Battery Pack · inoperativeEMERGENCY LIGHTS ASSOCIATED WITH BATTERY PACK M1670 DID NOT TURN ON. REPLACED THE POWER SUPPLY BATTERY PACK M1670 IAW AMM 33-51-06-960-805, AND PERFORMED GOOD EMERGENCY LIGHTS - OPS TEST IAW AMM 33-51-00-710-801.SDR DALA2025122909459Release Mech · out of adjustFOUND TAIL CONE RELEASE MECHANISM CAM CLOCKED WRONG. TAILCONE RELEASE MECHANISM CAM REF B717 AMM 53-52-03 (1362721)