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 CALA2025092409199Battery Pack · no testEPSU UNIT EMERGENCY LIGHT L AND R TEST FAILED. REMOVED AND REPLACED LEFT AND RIGHT EPSU BATTERY UNITS. REF AMM 33-51-38. EMERGENCY POWER SUPPLY UNIT BITE CHECK NORMAL. REF AMM 33-51-00-710-001-A; CIDS BITE TEST NORMAL. REF AMM 23-73-00-740-005-A.SDR CALA2025092409198Wire · brokenSEAT 3B EMERGENCY LIGHT INOP. SEAT 3B EMERGENCY LIGHT WIRE BROKEN. REQUEST TO APPLY MEL 3319E. SEAT 3B BROKEN WIRE SECURED PER GMM 5-30-40. MEL 3319E REJECT SPEC NOTE B ALL LIGHTS WITHIN TWO SEAT ROWS OF A MONUMENT (INCLUDING A CLASS DIVIDER) MUST BE OPERATIVESDR CALA2025092409193Unknown · odorODD SMELL IN FLIGHT DECK. SIMILAS TO WET SOCK SMELL. REQUESTI NG MW TO CONFIRM/VERIFY CREW REPORTS WET ODOR. CREW SHEET ATTACHED. REF. AMM TASK 05-51-10-200-801-C-1 VERIFIED NO ELECTRICAL SMELL IN THE E&E BAY FLIGHT DECK OR CABIN.SDR CALA2025092409192Unknown · odorON TAKEOFF AND DESCENT BAD ODOR SUSPECTED FROM PACKS PERFORMED IDLE CHECK BOTH PACKS RUNNING AUTO AND HIGH FIVE MINUTES NO SMELLS. RAN BOTH ENGINES FIRST RUN AND ONE AT 75% AND TWO AT 90% FOR FIVE MINUTES., POWER UP TO N1 84% AND N2 93% FIVE MINUTES NO SMELLSSDR F3LA202509230300Battery · failedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING TEST FOUND EPSU BATTERIES 13WL FAIL, REPLACEMENT IS REQUIRED IAW AMM 33-51-38-000-002-A REV 103. REPLACED EPSU BATTERY 13WL IAW AMM 33-51-38-400-002-A REV 103.SDR F3LA202509230299Battery · failedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING TEST FOUND EPSU BATTERIES 12WL FAIL, REPLACEMENT IS REQUIRED IAW AMM 33-51-38-000-002-A REV 103. REPLACED EPSU BATTERY 12WL IAW AMM 33-51-38-400-002-A REV 103.SDR F3LA202509230298Battery · failedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING TEST FOUND EPSU BATTERIES 11WL FAIL, REPLACEMENT IS REQUIRED IAW AMM 33-51-38-000-002-A REV 103. REPLACED EPSU BATTERY 11WL IAW AMM 33-51-38-400-002-A REV 103.SDR F3LA202509230297Battery · failedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING TEST FOUND EPSU BATTERIES 10WL FAIL. REPLACEMENT IS REQUIRED IAW AMM 33-51-38-000-002-A REV 103. REPLACED EPSU BATTERY 10WL IAW AMM 33-51-38-400-002-A REV 103.SDR F3LA202509230296Floor Support · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION FOUND CABIN FLOOR SUPPORT Y-254 AT FR.20 CORRODED. PERMANENT REPAIR WAS PERFORMED IN FLOOR SUPPORT Y-254 AT FR.20 AS PER EA N2-53R-39779 REV ORIG.SDR F3LA202509230295Floor Support · corrodedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION FOUND CABIN FLOOR SUPPORT Y254 AT FR.16-18 CORRODED. REQUIRES REPLACEMENT AS PER SRM 51-72-11 REV 45.
CORRECTION ACTION: FLOOR SUPPORT Y254 AT FR.16-18 REPLACED AS PER SRM 51-72-11 SDR DALA2025092306946Wire Harness · shortedANTI ICE L WINDOW SHORT CICUITED 3 TIMES CONSECUTIVELY REACHING CRUISE CB X14 PULLED PER MCC. R/R L SLIDING WINDOW HARNESS PER A320 AMM 56-12. OPS TEST OK PER A320 AMM 30-42. (LP: 6564526)SDR DALA2025092306945Bottle · low pressureLEFT FWD DOOR EOC/ ACCUMULATOR LOW PRESSURE. SERVICED L FWD DOOR EOC/ ACCUMULATOR PER A320 AMM 52-10. LEAK CHECK OK. OK FOR SVC. (LP: 7095647)SDR F3LA202509230294Shear Plate · crackedAIRCRAFT WAS NOT GROUNDED AND IS IN CHECK FOR SCHEDULED MX. DURING INSPECTION OF THE AFT CABIN FLOOR STRUCTURE A CRACK WAS FOUND ON LH SHEAR PLATE BETWEEN FR69 TO FR 70. REPLACEMENT IS REQUIRED. PERFORMED REPLACEMENT OF LH SHEAR PLATE I.A.W. SRM-51-72-11 REVSDR DALA2025092306943Seat Track · corrodedCORROSION OUT LIMIT ON OUTBD SEAT TRACK RH BTW STA 418 TO STA 510 , AT CABIN PAX. OUTBD SEAT TRACK RH BTW STA 440 TO STA 530 WAS REPAIR PER B757-300 SRM 53-00-52-2R PROCEDURE 1, REPAIR 1, FIG. 201 OPTION 1. /// CORROSION LEVEL 2. (1213014)SDR AALA202509234639Power Supply · faultyAIRCRAFT IN BASE MAINTENANCE: WHILE DOING EMERGENCY LIGHT TEST ON THE PTP PANEL GETTING ERROR MESSAGE "EPSU BATTERY FWD L". MAINTENANCE REPLACED "EPSU BATTERY FWD L" IAW AMM 33-51-38.SDR AALA202509234715Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: LOWER EMERGENCY EXIT LIGHT NEAR LEFT HAND FORWARD EMERGENCY DOOR DOES NOT WORK. RECONNECT CONNECTORS FOR EMERGENCY LIGHT, OPERATIONAL CHECK GOOD. PER AMM 33-51-01.SDR FDEA202509231774Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 252HFF. MDC FLOOR PANEL 252HFF MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202509231773Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 251PFF. MDC AREA FLOOR PANEL 251PFF MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202509231772Floor Panel · crackedPUNCTURE ON FLOOR PANEL 251KFF. MDC AREA FLOOR PANEL 251KFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15/2025SDR FDEA202509231771Floorboard · dentedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 231AFF HAS NUMEROUS DENTS. REPAIRED FLOORBOARD 231AFF, MPN 143T5876-5, RBL 11 - RBL 11, AT STA 412, IN REF TO B767 SRM 53-00-50-2R REPAIR 4. B. THIS A MAJOR REPAIR, SEE JPF FOR ALL STEPS. FLOORBOARD WILL BE INSTALLESDR FDEA202509231770Indicator · inoperativeDURING POST FLIGHT FOUND R1 DOOR SLIDE PRESSURE PRESS TO TEST LIGHT INOP. RELAMPED PER M.M. 52-11-00-0, OPS CHECK NORMAL, OK FOR SERVICESDR FDEA202509231769Floor Panel · delaminatedLEFT FLOOR PANEL 271GF AT BS 1437, X=47.5 TO X=75.25 MAIN LANDING GEAR VIEW WINDOW ACCESS CUT OUT FOUND DELAMINATED. CABIN-LEFT HAND DELAMINATED FLOOR PANEL 271GF AT STATION 1437, X=47.5 TO X=75.25 MAIN LANDING GEAR VIEW WINDOW ACCESS CUTOUT, REMOVED AND RSDR FDEA202509231768Floor Panel · delaminatedRIGHT FLOOR PANEL 272GF AT STATION 1437, X= -47.5 TO X= -75.25 MAIN LANDING GEAR VIEW WINDOW ACCESS CUT OUT FOUND DELAMINATED. CABIN-RIGHT HAND DELAMINATED FLOOR PANEL NUMBER 272GF AT STATION 1437, X=-47.5 TO X= -75.25 MAIN LANDING GEAR VIEW WINDOW ACCESS SDR FDEA202509231767Lamp · failedR1 SLIDE LIGHT WILL NOT ILLUMINATE. IAW AMM 52-10-00-5 RELAMPED. CKD OK.SDR FDEA202509231766Skin · dentedLH WING, OUTBD TRAILING EDGE FLAP, DENT ON LEADING EDGE APPROX 9" TO 10" FROM INBD END. MK11 REPAIRED LH WING, OB TE FLAP, DENTED ON LE AREA; MPN;113T3110-4016, PANEL# 566AT, AT WING STATION:538.2-544 IN REF TO B767 SRM 57-53-01-2R FIG 201 SHEET 5 REPAIR 1SDR DALA2025092306940Light · inoperativeEMERGENCY LIGHT INOP AT ROW 32. R & R EMER. LIGHT AT ROW 32 ER MM 33-51. OPS CHECKED GOOD.SDR DALA2025092306939Button · brokenEMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE. REPLACED MISSING PATHWAY LIGHTING. REF AMM 33-52. R/R FWD EMERGENCY BATTERY POWER SUPPLY P/N D717-02-030 BROKEN TEST BUTTON. REF B737 AMM 33-51, OPS CK GOOD.SDR DALA2025092306938Frame · damagedREPAIR OF RIGHT-HAND STATION, 727 FRAME INNER CHORD. FABRICATED AND INSTALLED SHIM BETWEEN STA 727 FRAME INNER CHORD AND S-18A WEB, REPAIRED IN ACCORDANCE WITH CC#5311-01251-02B.SDR DALA2025092306937Frame · damagedREPAIR OF LEFT-HAND STATION, 727 FRAME INNER CHORD. FABRICATED AND INSTALLED SHIM BETWEEN STA 727 FRAME INNER CHORD AND S-18A WEB, REPAIRED IN ACCORDANCE WITH CC# 5311-01251-02A.SDR JR2R20250923798Rib · mechanic errorRH WING LEADING EDGE RIB 42 HAS DRILL START NEXT TO NUT PLATE. REPAIR.SDR REXA2026052600631Support Fitting · wornWEAR AT FWD / AFT HANDRAIL SUPPORT FITTING AT FWD & AFT SIDE PANEL OF PASSENGER DOOR, ALSO MISSING BUMPERS. MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE LH WAS FABRICATED AND INSTALLED AND BIN SUPPORT RH WAS REPLACED PER EA CRJ953-20434 REV. A CRJSDR REXA2026052600630Support Fitting · wornINITIAL INSPECTION': WEAR AT FWD / AFT HANDRAIL SUPPORT FITTING AT FWD & AFT SIDE PANEL OF PASSENGER DOOR, ALSO MISSING BUMPERS. MAIN LANDING GEAR BINS SUPPORT STRUCTURE RETAINER ANGLE LH WAS FABRICATED AND INSTALLED AND BIN SUPPORT RH WAS REPLACED PER EA CRSDR REXA2026052600629Cover · crackedOUT OF SCOPE: CRACK ON AFT TRACK COVER OF THE AFT BAGGAGE BAY DOOR. AFT TRACK COVER ( ROLLER GUIDE) OF THE AFT BAGGAGE BAY DOOR WAS FABRICATED PER EA CRJ953-20421 REV IR AND REPLACED PER SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01SDR REXA2026052600628Beam · wornOUT OF SCOPE: WEAR ON AFT BEAM AT AFT BAGGAGE-BAY CARGO DOOR STRUCTURE (INTERFERENCE WITH AFT BALANCE SPRING CABLE). WEAR ON AFT BEAM AT AFT BAGGAGE-BAY CARGO DOOR STRUCTURE (INTERFERENCE WITH AFT BALANCE SPRING CABLE) WAS REPAIRED PER EA CRJ953-20392 REV IR.SDR REXA2026052600627Panel · crackedCRACK ON FWD SIDE PANEL (STEPS) AT L1 DOOR. CRACKED ON FWD SIDE PANEL (STEPS) AT L1 DOOR. WAS REPAIRED IAW SRM 52-11-04-201-004-A01.SDR REXA2026052600626Panel · crackedCRACK ON AFT SIDE PANEL (STEPS) AT L1 DOOR. CRACKED ON AFT SIDE PANEL (STEPS) AT L1 DOOR WAS REPAIRED IAW SRM 52-11-04-201-004-A01.SDR REXA2026052600624Door · crackedCRACK ON FWD MEMBRANE OF INBD DOOR AT LH MLG INBD DOOR AT LH MLG WAS REPLACED IAW CRJ-900 AMM 32-12-01-400-802-A04SDR REXA2026052600623Plate · worn"INITIAL INSPECTION': WEAR ON FLAP FITTING AND PLATE SUPPORT OF FLAP STUB FAIRING 171DL AND 172DR AT RH/LH WING TRAILING EDGE (ROOT WING). WEAR ON FLAP FITTING AND PLATE SUPPORT OF FLAP STUB FAIRING 171DL AND 172DR AT RH/LH WING TRAILING EDGE (ROOT WING) WERESDR REXA2026052600622Fitting · wornWEAR ON FLAP FITTING AND PLATE SUPPORT OF FLAP STUB FAIRING 171DL AND 172DR AT RH/LH WING TRAILING EDGE (ROOT WING). WEAR ON FLAP FITTING AND PLATE SUPPORT OF FLAP STUB FAIRING 171DL AND 172DR AT RH/LH WING TRAILING EDGE (ROOT WING) WERE FOUND OUT LIMITS THERSDR REXA2026052600621Support Fitting · wornWEAR AT FWD / AFT HANDRAIL SUPPORT FITTING AT FWD & AFT SIDE PANEL OF PASSENGER DOOR, ALSO MISSING BUMPERS. WEAR AT FWD / AFT HANDRAIL SUPPORT FITTING AT FWD & AFT SIDE PANEL OF PASSENGER DOOR WERE FOUND OUT LIMITS THEREFORE WERE REPLACED AND BUMPERS WERE INSSDR SWIA202602275358Skin · chafedRH INBOARD FLAP LOWER SKIN HAS CHAFE DAMAGE AT INBOARD INTERFACE OF FAIRING. (C-CHECK RO 02/25/2026)REPAIRED RH INBOARD FLAP LOWER SKIN WITH REFERENCE TO SRM 57-52-01 AND REO 670-57-52-628 REV "--" DATED 2025-10-15. REPLACED RH INBOARD FLAP LOWER SKIN WITH SDR SWIA202512020922Seal · damagedDURING REMOVAL OF RT SLAT 1 FIXED LEADING EDGE SEAL FOUND 3 PRE-EXISTING ELONGATED HOLES. REPAIRED ELONGATED HOLES IAW REO 690-57-41-584, REV-.SDR SIMA20250922001Glowstrip · damagedRH EMERGENCY PHOTOLUMINESCENT LIGHT STRIP NUMBER 2 IS UNSERVICEABLE. COMPLETE:RAR RH EMERGENCY LIGHT STRIP NUMBERS 2, IAW AMM 33-50-21.SDR SWI2025F01675Floorbeam · corrodedCOCKPIT FLOOR SUPPORT ANGLE ON THE FORWARD SIDE OF THE FS280 BEAM BL9L - BL9R IS CORRODED. (C-CHECK RO 11/30/2025)REMOVED AND REPLACED COCKPIT FLOOR SUPPORT ANGLE REF CRJ 700 SRM 51-42-06-001-001-A01, CRJ 700 SRM 51-42-21-001-001-A01, CRJ 700 SRM 51-42-13-00SDR SWI2025F01674Intercostal · corrodedINTERCOSTAL AT STGR 21LH BETWEEN FS333.00 AND FS349.00 HAS CORROSION ON UPPER WEB. (MARKED) (C-CHECK RO 11/30/2025)REPLACED INTERCOSTAL AT STGR 21 LH BETWEEN FS333.00 AND FS349.00 REF. DWG# SH670-31810 REV AE AND CRJ700 SRM 51-42-06-001-001-A01. C/W 51-900-SDR SWI2025F01673Stringer · corrodedSTRINGER STGR 23RH HAS CORROSION ON ATTACH FLANGE BETWEEN FS333.00 AND FS349.00. (MARKED) (C-CHECK RO 11/30/2025)REPLACED STGR 23RH BETWEEN FS333.00 AND FS349.00 REF DWG# SH670-31350 REV-A AND CRJ 700 SRM 51-42-06-001-001-A01. COMPLIED WITH TASK CARD 51-900-SDR SWIA202512010922Stringer · corrodedSTRINGER STGR 22LH HAS CORROSION IN MULTIPLE SPOTS ON UPPER ATTACH FLANGE BETWEEN FS333.00 AND FS364.00. (MARKED) (C-CHECK RO 11/30/2025)REPAIRED STRINGER STGR 22LH FROM FS333.00 AND FS394.00. REF CRJ700 SRM 53-00-03-201-001-A01. COMPLIED WITH ALL STEPS OF 5SDR VNAA202511270010Stringer Splice · corrodedCORROSION ON STRINGER SPLICE 24RH BTW STA. FS= 319.00 AND FS= 333.00 AT MAIN AVIONICS COMPARTMENT. CORROSION ON STRINGER SPLICE 24RH WAS EVALUATED EXCESSIVE DAMAGE PER CRJ700 SRM 53-00-00-101-001-A01 AND REPLACED IAW SRM 51-42-06-001-001-A01.SDR VNAA202511260007Stringer · corrodedCORROSION ON STRINGER 24R BTW FS485 AND FS501 AT FWD BAGGAGE BAY COMPARTMENT. CORROSION ON STRINGER 24R BTW FS485 AND FS501 AT FWD BAGGAGE BAY COMPARTMENT WAS REPAIRED PER REO 670-53-31-1111 REV-.SDR VNA2025F00041Stringer Splice · corrodedCORROSION ON STRINGER SPLICE 21RH IN STA. FS= 333.00 TO FS= 337 AT MAIN AVIONICS COMPARTMENT. CORROSION ON STRINGER SPLICE 21RH IN STA. FS= 333.00 TO FS= 337 AT MAIN AVIONICS COMPARTMENT WAS EVALUATED FOR EXCESSIVE DAMAGE PER CRJ-700 SRM 53-00-00-101-001-A01