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 CALA2025101410072Channel · delaminatedL/H AILERON HAS COMPOSITE DAMAGE ON TOP T/E. REPAIRED DAMAGED COMPOSITE IAW A319 SRM 51-77-12-911-002 RMVD AND RPLD AILERON TRAILING EDGE CHANNEL IAW A319 SRM 51-42-11 CMM 57-61-21 SRM 51-72-11 CAT A.SDR CALA2025101410071Power Supply · inoperativeFOUND L2 EMERGENCY EXIT LIGHT S INOP. REMOVED AND REPLACED POWER SUPPLY (M1673) REF AMM 33-51-06. OPS CHECK GOOD. OK TO CONTINUE.SDR CALA2025101410070Battery Pack · inoperativeEMERGENCY LIGHTS ROW 22 THRU 27CBA INOP REMOVED AND REPLACED BATTERY PACK (M1670) REF AMM 33-51-06 OPS CHECK GOOD. OK TO CONTINUE. PARTS USED: 99-3351-3-0015,QTY :1SDR CALA2025101410051Light · detachedSEAT 5B EMERGENCY LIGHT HANGING DOWN REPLACED FLOOR PROXIMITY LIGHT AT 5B. OPS CHKS NORMAL. REF AMM 33-51-11-960-802.SDR 2025FA0000709B-Nut · looseDOWNLOAD THE FLIGHT INFORMATION FROM THE DATA CARD. UPON OPENING THE CABIN DOOR, WAS IMMEDIATELY MET WITH A STRONG ODOR OF FUEL. THE COCKPIT SEATS WERE REMOVED FOR INSPECTION. UPON OPENING AN INSPECTION PANEL ON THE RT WING SPAR PASSTHROUGH, NOTED THAT THE SDR F3LA202510130315Panel · missingTHIS AC WAS REMOVED FROM SERVICE FOR THIS EVENT. REFERENCE LP534349 ITEM # 2 ENG 2 FIRE BOTTLE INSPECTION PANEL MISSING. INSTALLED ACCESS PANEL 425CR SERVICEABLE REF AMM 54-51-21-400-002-A. GOOD FOR SERVICE.SDR F3LA202510130314Battery · faultedTHIS AC WAS ON SCHEDULED MAINTENANCE. REFERENCE LP549631 #2 EPSU BATTERY FAULT AT 16WL. REMOVED AND REPLACED EPSU BATTERY AT 16WL RE AMM 33-51-38-400-002-A. OPS TEST GOOD.SDR 2DYA202508130008Battery Pack · dischargedEMERGENCY LIGHTS INOP INTERIOR LIGHTS AT 1L AND 1R. REMOVED AND REPLACED EMERGENCY LIGHTS BATTERY PACK AT DOORS 1L AND 1R IAW B767 AMM 33-51-07-022-001 AND AMM 33-51-07-422-012. OPS CHECK GOOD..13-OCT-25 LP 60220SDR F3LA202510130313Battery · faultedTHIS AC WAS ON SCHEDULED MAINTENANCE. REFERENCE LP549631 ITEM #1, EPSU BATTERY FAULT AT 12WL. REMOVED AND REPLACED EPSU BATTERY AT 12WL REF AMM 33-51-38-400-002-A. OPS TEST GOOD.SDR F3LA202510130312Battery · faultedTHIS AC WAS ON SCHEDULED MAINTENANCE. REFERENCE LP549630 ITEM #3 EPSU BATTERY AT 11WL. REMOVED AND REPLACED EPSU BATTERY AT 11WL REF AMM33-51-38-400-002-A OPS TEST GOOD.SDR F3LA202510130311Battery · dischargedTHIS AC WAS ON SCHEDULED MX REFERENCE LP549630 #2, EPSU BATTERY FAULT AT 10WL. REMOVED AND REPLACED EPSU BATTERY AT 10WL REF AMM 33-51-38-400-002-A. OPS TEST GOOD.SDR WX0A2025101332596Seal · leaking(AIRCRAFT NOT GROUNDED) FA'S REPORT DIRTY SOCK SMELL DURING FINAL APPROACH FWD & AFT. FA'S REPORT EYES BURNING & WATERING AS A REACTION. / PERFORMED TC 21-000-002. FOUND OIL LEAK FROM GENERATOR SEAL PLATE. REMOVED AND REPLACED GENERATOR SEAL PLATE IAW AMM 24-2SDR DALA2025101307492Cids · faultedCABIN EMER LIGHTS STUCK ON AND FA PANEL LOCKED OUT/FROZEN. RESET CIDS AND PERFORMED OPC OF EMER LIGHTS FROM FAP.ALL CHECKS GOOD PER A319 AMM 33-51. (7183012).SDR IXXA20251013002Skin · crackedWING L/E HAS CRACK AT SLAT TRACK CUT OUT AFT OF #4 SLATSDR DALA2025101307453Inlet · contaminatedON THE GOURND, AFTER 5 MIN OF APU RUNNING, DIRTY SOCK ODOR/SMELL PRESENT AFTER SELECTING APU BLEED ON. SMELL SEEMS TO DISSAPATE AFTER SELECTING BLEED OFF. PERFORMED SMOKE AND FUME T/S IAW A320 AMDS WORKCARD # 0550-2002. FOUND SOURCE TO BE APU INLET DUCT CONTASDR FDEA202510131975Floorbeam · corrodedAFT CARGO COMPARTMENT FLOOR SUPPORT BEAM CORRODED AT FR58 Y-805 - Y-1470 REPAIRED THE AFT CARGO COMPARTMENT CORRODED FLOOR SUPPORT BEAM AT FR58 Y-805 - Y- 1470 PER A300-600 SRM53-10-15-201 FIGURE 207 AND EA: 6-5321-T0385357 P1. TITLE: FUSELAGE - CARGO COMPSDR IXXA20251013007Door Frame · crackedDAMAGE FOUND ON FORWARD LOWER CARGO DOOR CHORDSDR IXXA20251013001Skin Splice · corrodedTHE SEALANT IS BULGED WITH CORROSION IN THE BUTT SPLICE, ON THE UPPER EXTERIOR SURFACE OF THE LEFT-WING SKIN, 40 TO 50 INCHEC OUT FROM THE FUSELAGE.SDR 2025F00240Air Filter · cloggedON CBB/BYC ROUTE QRF TO CBB DUE TO DISPLAY COOL IT REMAINS ALL TIME WITHOUT BEING ABLE TO CONTROL WITH QRH. REPLACED AIR FILTER COCKPIT DISPLAY COOLING IAW 21-24-15-04, NORMAL OPERATION.SDR QMLA2025101320103Unknown · fumesELECTRICAL FUMES IN COCKPIT AND CABIN FROM UNKNOWN ORIGIN. COULD NOT DUPLICATE ISSUE. PERFORMED GVI BEHIND C/B PANEL STARTER GENERATOR WIRES AND AC BELT AND AFT TRAY. NO DEFECTS NOTED. PERFORMED SYSTEM ON WITH GROUND PROWER CART NO DEFECTS NOTED. PERFORMED GROSDR SWIA2025101275777Landing · crackedR/H TRU BAY DOOR LAND HAS POSSIBLE CRACK AT AFT LATCH CUTOUT. REMOVED AND RAPLACED TRU BAY DOOR LANDING R/H P/N CC670-33151-6 P.O. # CPT837 IAW SRM 51-42-06-001-001-A01 PG 7 PARA 6 (A) AND SRM 51-42-13-001-001-A01 PG 8 PARA 6 (A). NO WEIGHT CHANGES NOTED, RESDR SWIA2025101275775Skin · crackedRIGHT FUSELAGE ADG SKIN HAS POSSIBLE CRACK AT AFT LOWER CORNER OF TRU BAY DOOR OPENING (C-CHECK RO 04/17/2026)REMOVED AND REPLACED ADG SKIN AT RH FUSELAGE IN REF. TO CRJ-900 SRM 51-42-06-001-001-A01 PAR. 6.B, 51-42-13-001-001-A01 PAR. 6.B AND REO #690-53-11-SDR SWI2026F00042Floor Support · corrodedAFT CARGO FLOOR SUPPORT, RBL 9, BETWEEN BS 559+64 AND BS.559+80 HAS SPOTS OF CORROSION. BLENDED REPORTED CORROSION ON THE FLOOR SUPPORT INNER CAP FLANGE BETWEEN BS 559+64 AND BS 559+80 IAW SRM 51-21-06. BLENDED AREA WAS FOUND OUT OF LIMITED IAW SRM 53-31-43 ASDR SWI2026F00041Hinge Arm · chafedLEFT INBD FLAP OTBD HINGE ARM CHAFED ON FWD PIVOT FITTING 3EA. LOCATIONS. REPAIRED LH INBD FLAP OTBD HINGE ARM CHAFE IAW ALL STEPS OF REO REO 601R-57-54-379 REV -. SKYWEST TASK CARD 51-900-1002-SKY COMPLIED WITH.SDR SWIA2026010500012Hinge Arm · chafedLH INBD FLAP INBD HINGE ARM CHAFFED ON FWD PIVOT FITTING. COMPLIED WITH REPAIR AT LH IB FLAP HINGE ARM REF. CRJ-200 REO 601R-57-54-382 REV-. ALL STEPS COMPLIED WITH. COMPLIED WITH TASK CARD 51-900-1003-SKY.SDR HNAA2025112000770Drag Angle · crackedF077360 VERTICAL STABILIZER LH DRAG ANGLE HAS POSSIBLE CRACK AT FR 76. REMOVED CRACKED VERTICAL STABILIZER LH DRAG ANGLE AT FR 76 IAW EMB145 SRM 51-40-02 AND SRM 51-20-03 AND INSTALLED SERVICEABLE VERTICAL STABILIZER LH DRAG ANGLE AT FR 76. IAW EMB 145 SRM 53SDR IPXA2025111826351Floor Support · corrodedBULK CARGO RH FLOOR BRACKET HAS CORROSION. DOT 28-1180. INSTALLED NEW FLOOR BRACKET IAW SRM 51-40-21.SDR 2025FA0000760Solenoid · corrodedI MOVED THE GEAR LEVER INTO THE UP POSITION AFTER TAKEOFF IN VFR CONDITIONS. THE PANEL INDICATED A LOW VOLTAGE WARNING THEN THE GLASS PANEL (G500, GTN 750/650, EDM 900) WENT BLANK ALONG WITH OTHER ELECTRICAL DASH INDICATIONS INCLUDING THE GEAR LIGHTS. I CYCLESDR SWAA2025111223949Light · deterioratedDETERIORATED PHOTOLUMINESCENT STRIP (5EA) LH AND (5EA) RH SIDE AT PASSENGER CABIN. REPLACED THE PHOTOLUMINESCENT STRIP (5EA) LT AND (5EA) RT SIDE IN PAX CABIN IAW AMM 33-51-15-400-802.SDR SWAA2025111223948Handle · deterioratedDETERIORATED ENTRY DOORWAY LINING HANDLE NUTS AT FWD GALLEY AREA (4EA). REPLACED ENTRY DOORWAY LINING HANDLE NUTS AT FWD GALLEY AREA (4EA) IAW B737-700 AMM 52-11-31-400-802 STEP 3.G ITEM 2.SDR SWIA2025110700002Skin · damagedLIGHTNING STRIKE DAMAGE, LT UPPER AFT PORTION OF RUDDER ABOVE RIB 13 & HALFWAY BETWEEN RIB 13 AND RIB 12 RUDDER REAR SPAR HAS BURN DAMAGE 12 IN X 10 IN, LT UPPER FWD PORTION OF RUDDER, RUDDER FRONT SPAR HAS BURN DAMAGE.1 IN X1 IN (FLIGHT 4279) INSEPECTED DAMASDR SWAA2025110623931Cargo Track · corrodedCORROSION ON AFT CARGO BAY CARGO TRACK AT BS 942, LBL 7, WL 155. REMOVED AND REPLACED THE AFT CARGO TRACK IAW SRM 51-40-02-0G-0, DWG 147A7500, REV-, DWG 147A7501 REV:B, AND DWG 147A7500 REV:B.SDR SWAA2025110623933Sidewall Support · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDE WAL SUPPORT AT BS 727A - 787, LBL 22, WL 155. REMOVED AND REPLACED ON AFT CARGO BAY FLOOR TO SIDEWALL SUPPORT IAW SRM 51-40-02, AND DWG 146A7500.SDR SWAA2025110623929Sidewall Support · corrodedCORROSION ON AFT CARGO BAY FLOOR TO SIDE WAL SUPPORT AT BS 727A 827; RBL 22; WL 155. REMOVED AND REPLACED THE SIDEWALL SUPPORT IAW SRM 51-40-02, AND DWG 146A7500 REV B.SDR SWAA2025110623935Splice · corrodedCORROSION ON AFT CARGO BAY SPLICE AT BS 887; LBL 12; WL 155. REMOVED AND REPLACED ACB FLOOR SPLICE IAW SRM 51-40-02; DWG 146A7500 REV A AND DWG 149A8104 REV B.SDR SWAA2025110323750Glowstrip · damagedMULTIPLE PHOTOLUMINESCENT STRIPS FOUND DAMAGED. REPLACED AND INSTALLED NEW PHOTOLUMINESCENTS STRIPS KIT IAW DWG 33500007, REV 2.SDR IPXA2025103121028Floor Panel · damagedINSP MLG W/W PANEL 147BF DELAMINATED. VERIFIED FLOOR PANEL 147BF FABRICATED IAW SREO-16407-REQ002.SDR AALA202510309904Tab · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT ELEVATOR TAB CONTROL MECHANISM SPRING SUPPORT BUSHINGS SHOW SIGNS OF CORROSION. REMOVED AND INSTALLED NEW BUSHINGS ON THE RIGHT HAND ELEVATOR TAB CONTROL MECHANISMS. PER B737NG AMM 27-31-34 AND PERFORMED SATISFACTORYELEVATORSDR AALA202510307902Control Quadrant · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT ELEVATOR TAB CONTROL MECHANISM SPRING SUPPORT BUSHINGS SHOW SIGNS OF CORROSION. REMOVED AND REPLACED LEFT ELEVATOR TAB CONTROL MECHANISMS SPRING SUPPORT NEW BUSHINGS. PER B737NG AMM 27-31-34 AND PERFORMED SATISFACTORY ELEVATOSDR CALA2025102910694Structure · corrodedL1 DOOR INNER CHORD BS 312 IS CRACKED. REMOVED AND REPLACED INNER CHORD AT L1 DOOR IAW SRM 51-40-02 AND DWG 141A8110.SDR SWAA2025102723921Bracket · cracked90 DEGREE WIRING HARNESS STAND OFF ON L/E OF PANEL 651FB IS CRACKED. R&R BRACKET REF SRM 51-40-02. INSPECTED WORK ACCOMPLISHED R&R BRACKET REF SRM 51-40-02.SDR SWIA202510270012Frame Splice · crackedBS 654.50 FRAME SPLICE AT STGR 6L IS CRACKED/CORRODED. PERFORMED TEMPORARY REPAIR TO BS 654.5 FRAME SPLICE AT S6L IN REFERENCE TO REO 601R-53-61-8397. PERFORMED EDDY CURRENT IN REFERENCE TO NDTM 53-00-097, PART 6 AND FOUND AREA TO BE CRACK FREE. COMPLIED WITHSDR CALA2025102310429Fairing · crackedNUMBER 1 PYLON AFTER FAIRING CRACKED IN AFT AREA. REMOVED AND REPLACED NR 1 PYLON AFTER FAIRING ASSY END, LOCATED DRILLED AND COUNTERSUNK, APPLIED ALODINE, PRIMER, TOPCOAT PAINT IAW SRM 51-40-05-0G-0, SRM 51-40-05-0G-0, 51-40-02-0 G-0, SRM 51-40-08-0G-0, SRMSDR WX0A2025101332595Actuator · faulted(AIRCRAFT GROUNDED) (EMERGENCY DECLARED) ON ROTATION HAD A BRIEF MASTER CAUTION. SHORTLY AFTER, LOST ALL MAIN ELECTRIC STAB TRIM. AP WOULD NOT TRIM. WINDOWS WERE BOTH AMBER. INTERMITTENT SPEED TRIM FAIL LIGHT. PERFORMED SPEED TRIM IN FLT SYS TEST IAW IFIM 22SDR IPXA2025102120943Floor Support · crackedMAIN DECK FLOOR FITTING WAS DAMAGE AT BS 1109, BL 0. REMOVED DAMAGE FITTING IAW SRM 51-40-02-0G REV 93.2. INSTALLED NEW FITTING IAW SRM 51-40-02-0G REV 93, AND DWG 457T4000, SHEET 11, REV B.3.SDR IPXA2025102120558Angle · crackedFOUND CRACKED ANGLE, BULK CGO COMPT CEILING AREA, BS 1577, LBL 74, INBD SIDE. (REPLACE) INSPECTION COMPLETED FOR MAIN DECK CARGO INSPECTION OF FLOOR PANEL OK TO INSTALL CHECK AT STA 1540 ~ 1599 , LBL54 ~ 88 , PANEL NO.251CGF, DADO PANEL AT STA 1578 L/H (NO.251SDR IPXA2025102120546Angle · crackedFOUND CRACKED ANGLE, BULK CARGO CEILING AREA, BS 1577, RBL 74, INBD SIDE. INSPECTION COMPLETED, FLOOR PANEL OK TO INSTALL AT BS 1540 - 1599, RBL 54 - 88, PANEL NR 252YFF. REPLACED THE FLOOR PANEL IAW AMM 53-01-06-400-801, REV 146, INSTALLED MAIN DECK CARGO SDR IPXA2025102120275Angle · crackedFOUND CRACKED ANGLE, BULK CGO COMPT CEILING AREA, STA 1577 RBL 74 OUTBD SIDE. (REPLACE) INSPECTION COMPLETED FOR DADO PANEL OK TO CLOSE CHECK AT STA 1578 RH SIDE (NO.252QSF). IAW AMM 25-59-01-404-019 REV.146 INSTALLED MAIN DECK CARGO DADO PANEL AND CONDITIONSDR AALA202510217746Doubler · crackedAIRCRAFT IN BASE MAINTENANCE: PREVIOUS REPAIR COMPLETED (FINGER DOUBLER AND FILLER PLATE) ON OUTBOARD FLAP ACCESS DOOR CUTOUT AT TRACK NO 4 AT LEVEL RIB 15 RH WING, L=5.745IN X W=3.800. MAINTENANCE PERFORMED GENERAL VISUAL INSPECTION PRIOR TO FLIGHT AT O/B FLASDR HNAA2025101400701Frame · corrodedAREA OF CORROSION AT FR22, STR16R. REPAIRED IAW EO1-53-25-0364