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 AALA202512015369Light · inoperativeAIRCRAFT WAS GROUNDED: DURING EMERGENCY LIGHT TEST FOUND SEAT 3AB EMERGENCY LIGHTS INOPERATIVE. INSTALLED REAR (AALA202512015369) AND FORWARD (AALA202512012116) EMERGENCY LIGHT ASSEMBLY. PER AMM 33-51-11.SDR YENA2025120101132Unknown · odorFLT#85, BUF-MCO. "ONCE AT THE GATE INFLIGHT CREW REPORTED A SMOKEY/DIRTY SOCKS SMELL ON DESCENT; FOUND THE APU OVER SERVICED UPON INSPECTION, DRAINED THE OIL EXCESS TO THE CORRECT LEVEL IAW AMM 49-90-00 PERFORMED PACKS BURN REF AMM 21-00-00-615-802 NO ODOR EVESDR AALA202512011282Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540, RBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202512014818Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY PANEL LOCATED AT BS 540, LBL 2. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR DALA2025120108766Stop Fitting · out of adjustOUT OF ADJUSTMENT DOOR STOP 5 AND 6 FWD SIDE OF PASSENGER CREW DOOR 83 1 IN CLOSE POSITION AT PASSENGER CABIN. PERFORMED ADJUSTMENT OF DOOR STOP 5 AND 6 FWD SIDE OF PASSENGER CREW DOOR 831 IN CLOSE POSITION AT PASSENGER CABIN AS PER A320 FAM AMM 52-11-31. ANSDR DALA2025120108765Roller · deterioratedDETERIORATED ROLLER PASSENGER CREW DOOR 831 FROM UPPER AND LOWER POSIT ION AND FWD AND AFT SIDE OF THE DOOR. REPLACED ROLLER ON PASSENGER CREW DOOR 831 FROM UPPER AND LOWER POSITION AND FWD AND AFT SIDE OF THE DOOR. (4 EA) AS PER A320 FAM AMM 52-11-31. (1327SDR DALA2025120108764Stop Fitting · out of adjustOUT OF ADJUSTMENT CLEARANCE A ON DOOR STOP 4 IN AFT SIDE AND DOOR STO P 6 IN FWD SIDE OF PASSENGER CREW DOOR 832 IN CLOSE POSITION. PERFORMED ADJUSTMENT CLEARANCE A (J1) ON DOOR STOP 4 IN AFT SIDE AND DOOR STOP 6 IN FWD SIDE OF PASSENGER CREW DOOR 832 IN CLOSDR IPXA2025120197155Light · inoperativeFIRST OFFIER`S OVERHEAD/EMERGENCY LIGHT (DIM SETTING) INOPERATIVE. RE-LAPPED FO`S EMERGGENCY OVERHEAD DIM LIGHT IAW AMM 33-50-00 OPS CHECKED GOOD.SDR CALA2025113011589Light · faultedSEAT (15ABC) MOUNTED EMERGENCY (RED) LAMP NEEDS REPLACED DUE TO INTERMITTEN OPERATION. REMOVED AND REPLACED SEAT (15ABC) MOUNTED EMERGENCY (RED) LAMP, OPS CHECK GOOD, REF AMM 33-51-11. PARTS USED: 99-3350-3-0009, QTY :1SDR CALA2025113011588Wire Harness · faultedEMERGENCY PATH LIGHTING INOP AT SEAT 23C. REMOVED AND REPLACED EXIT PATH SEAT MOUNTED LIGHT HARNESS. REF AMM 33-51-19-000/400-002-A. OPS CHECKED GOOD AT THIS TIME.SDR CALA2025113011585Unknown · smokeSMOKE REPORTED FROM WHEEL WELL AREA BY AIRCRAFT BEHIND AND OPS INSPCT ALL LANDING GEARS AND CACS INLETS OUTLETS AND SURROUNDING AREA. NO SIGNS OF OVERHEAT OR FIRE. NO INDICATIONS OF OVERHEAT IN CABIN. NO FLUCUTATIONA OF PACKS APU OR ANY OTHER SYSTEMS. COULD NOSDR CALA2025113011584Apu · contaminatedSMOKE ODOR CONDITIONAL INSP REQUIRED PER AMM 05-51-XX DUE TO AN INCIDENT REPORTED BY THE CREW. SMOKE IN COCKPIT DUE DE-ICING WHILE AT THE GATE. SMOKE IN THE COCKPIT CAUSED BY DEICING FLUID INGESTION INTO APU. PILOTS SHUTDOWN PACKS AND ISO VALVE. RAN PACKS SMOKSDR SCNA20251201455Engine · vibrationENG 2 VIBRATIONS WERE AT 4.3 WHILE IN CRUISE. EMERGENCY DECLARED. R&R #2 ENG PER W/0 100261 T/C 710000000SDR DALA2025113008736Window · failedCA SIDE WINDOW BUBBLING AT THE BOTTOM AND EXTREMELY HOT - BURN YOUR HAND HOT. ALSO RECEIVED L WNDW HEAT CAUTION. REMOVED AND REPLACED CAPT SLIDING WINDOW PER A320 AMM 56-12. OPS CHECK GOOD, OK FOR SERVICE. (LP: 7966749)SDR IXXA20251129001Intercostal · corrodedINTERCOSTAL AT STA 588-610 RBL 36 HAS CORROSION UNDER NUT PLATESDR SWIA2025112876588Stringer · corrodedCORROSION ON STRINGER 19R BETWEEN BS 501 AND 517. REPAIRED THE STRINGER IAW REO 690-53-31-1096 REV -, AND SRM 53-00-03-201-001-A02. COMPLIED WITH ALL STEPS OF REO 690-53-31-1096, REV -. COMPLIED WITH TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD..SDR SWIA2025112876585Stringer · corrodedCORROSION ON S18R BETWEEN BS 581 AND BS 661+32. PERFORMED STRINGER SPLICE REPAIR 18R BETWEEN BS 477.40 - 661+90 IAW REO 690-53-31-1111 REV -. COMPLIED WITH ALL STEPS REO 690-53-31-1111 REV -. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECK GOOD.SDR SWIA2026070676504Stringer Splice · corrodedCORROSION ON GUSSETS ATTACHED TO STRINGER 19R BETWEEN BS 661+74 TO BS 677. INSTALLED NEW 3EA GUSSETS AND NEW STRINGER SPLICE AT STRINGER 19R, BS 677 IAW DWG SH690-39100, REV G, SRM 51-42-06-001-001-A01, AND SRM 51-42-21-001-001-A01. LEAK CHECK GOOD. COMPLIEDSDR SWIA2025112876478Frame Splice · fomREMOVE AND SPLICE FRAMES BS 485 AND 501, S16R TO S20R TO FOM. REMOVED AND SPLICED FRAMES BS 485 AND 501, S16R TO S20R IAW SRM 53-00-06-201-001-A03, SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, REO 690-53-31-1101, REV - AND DWG SH690-33101, REV M. COMPSDR SWIA2025112876473Stringer · corrodedCORROSION ON STRINGER 20R BETWEEN FS581.00 AND FS597. REMOVED AND INSTALLED NEW STR20R BETWEEN BS 581 AND 597 IAW REO 690-53-31-1095 REV --A, DWG SH690-33302, REV C, SRM 51-42-21-001-001-A01, SRM 53-00-03-201-001-A02, AND SRM 51-42-06-001-001-A01. COMPLIED WISDR SWIA2025112876455Stringer · corrodedSTRINGER 25L BTWN BS 319 - 333 CORRODED. INSTALLED NEW MAIN AVIONICS STRINGER IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG SH670-31630, REV K. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY, LEAK CHECKED GOOD.SDR REXA2026052700747Bracket · corrodedCORROSION ON CONNECTORS SUPPORT PLATES LH/RH (PX33, PX17, PX34, PX19) ON LH/RH MAIN WHEEL WELL CORROSION ON CONNECTORS SUPPORT PLATES LH/RH (PX33, PX17, PX34, PX19) ON LH/RH MAIN WHEEL WELL WAS REMOVED PER CRJ900 SRM 51-21-06-001-001-A01 AND EVALUATED OUT OFFSDR REXA2026052700746Diaphragm · crackedCRACK ON LH/RH DIAPHRAGM AT_ FWD AREA OF MLG W/W BTW FS= 797 TO FS= 807 LBL 35 AND RBL35. LH/RH DIAPHRAGMS AT_ FWD AREA OF MLG W/W BTW FS= 797 TO FS= 807 LBL 35 AND RBL35 WERE REPLACED PER CRJ-900 SRM 51-41-02-001-001-A01 AND PER CRJ-900 AMM 20-21-00-910-801-ASDR AALA202603172307Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: INTERIM REPAIR ON ASSOCIATED HOLES N5, B AND D LOCATED ON FRAME 16 RH DOUBLE JOGGLE AREA AT DOOR STOP FITTING N7 LVL ON UPPER FUSELAGE. MAINTENANCE ACCOMPLISHED TIME LIMITED REPAIR ON FR 16 RH DOUBLE JOGGLE AREA PARTIAL FRAME REPLSDR N6WA202602190801Skin · dentedAFT FUSELAGE SKIN DENT/GOUGE AT FS 977 STRINGER 27. REPAIRED IN ACCORDANCE WITH GOJET EO C550-53MR-108 O/ AWATS EO 25-CRJ5-53-220SDR SWIA2025112875277Hinge · damagedPAX DOOR FUSELAGE SIDE PIANO HINGE SEVERAL LUGS FAILED GO-NO-GO GAUGE. REMOVED AND INSTALLED NEW PAX DOOR HINGE TO FUSELAGE SIDE WITH DRIVE IN PLUGS AND LUBE FITTINGS PER SRM 53-21-23-201-007-A01 STEPS 4. J-T AND DWG SH670-31810 REV AE. ALL CHECKS GOOD. COMPLSDR SWIA2026020975230Floorbeam · crackedSUSPECTED CRACK ON LBL 12 COCKPIT FLOORBEAM (PREVIOUS REPAIR) AT BS 280. REPAIRED LBL 12 COCKPIT FLOORBEAM (PREVIOUS REPAIR) AT BS 280 IAW SRMS 53-11-43-201-003-A01, 51-25-21-001-001-A01, 51-21-00-001-001-A01, REV 38. COMPLETED TASK CARD 51-900-1002-SKY.SDR AALA202601164822Fitting · wornAIRCRAFT IN BASE MAINTENANCE: AFT AVIONIC COMPARTMENT RACK 80VU LEFT-HAND LOWER LATERAL FITTING WORN BETWEEN FR 23 AND FR 24 AT S32L. REPLACED LEFT-HAND LATERAL FITTING PER EA 370452.SDR AALA202601165156Fitting · noneAIRCRAFT IN BASE MAINTENANCE: DUE TO THE MAJOR REPAIR BEING ACCOMPLISHED ON THE AFT AVIONIC COMPARTMENT RACK 80VU LEFT-HAND LOWER LATERAL FITTING, THE RIGHT-HAND LOWER LATERAL FITTING BETWEEN FR 23 AND FR 24 AT S32R REQUIRES REPLACEMENT PER EA 70452. REPLACED SDR SWAA2026011340584Lens · deterioratedDETERIORATED LAVATORY A EMERGENCY LIGHT LENS IN THE FWD GALLEY. REPLACED THE LAVATORY A EMERGENCY LIGHT LENS IAW AMM 33-51-01-960-802, STEP 3.C, ITEM 5 D AND 10.SDR SWAA2026011340585Light · brokenBROKEN EMERGENCY LIGHT IN FWD GALLEY. REPLACED THE EMERGENCY LIGHT ASSY IAW AMM 33-51-01-960-802, STEP 3. C.SDR SWAA2026011347401Access Panel · crackedCRACK WING TO BODY FAIRING ACCESS PANEL 194BR. REPAIRED THE ACCESS PANEL IAW SRM 51-70-05-2R-10, REPAIR 10.SDR SWAA2026011340592Access Panel · damagedELONGATED HOLES ON TRAILING EDGE ACCESS PANEL 561CB ON LT WING. REPAIRED THE ACCESS PANEL 561CB IAW SRM 51-70-04-2R-9, REPAIR 9.SDR SWAA2026010940622Scuff Plate · crackedCRACKED SCUFF PLATE ON FWD CORNER OF AFT CARGO DOOR CUTOUT. REPAIRED SCUFF PLATE IAW SRM 53-60-15-2R-1, REPAIR 1.SDR SWAA2026010840487Access Panel · crackedCRACK WING TO BODY FAIRING ACCESS PANEL 194BR AT LOWER FUSELAGE. REPAIRED ACCESS PANEL 194BR IAW SRM 51-70-05-2R-10 REPAIR 10.SDR SWAA2025123140466Wedge · delaminatedLEFT WING MAIN FLAP, OTBD AFT WEDGE HAS A LARGE AREA OF DELAMINATION. REMOVED DELAMINATED FLAP WEDGE PER SRM 51-40-02. LOCATED AND MATCH DRILLED REPLACEMENT WEDGE IAW SRM 51-40-02. INSTALLED NUT PLATES IAW SRM 51-40-02.SDR SWAA2025123040480Tie Clip · crackedCRACKED TIE CLIP, FWD FACE BS 500I, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE TIE CLIP IAW SRM 51-40-02, AND DWG 143A1234, SHEET 14, REV A.SDR SWAA2025122946834Tie Clip · crackedCRACKED TIE CLIP, BS 500I, STRINGER 26L IN THE FWD CARGO BAY. REPLACED THE TIE CLIP IAW SRM 51-40-02, AND DWG 143A1234, SHEET 14, REV A.SDR SWAA2025121740601Support Angle · crackedCRACK SUPPORT ANGLE FLOOR STRUCTURE BS 695 AND RBL 1 IN PASSENGER CABIN. REPLACED SUPPORT ANGLE FLOOR STRUCTURE BS 695 AND RBL 1 AT PASSENGER CABIN IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 273A9110 SHEET 6 REV A.SDR SCNA20251217494Skin · crackedWO 95368 NR00018 IN REF TO CARD ENG-57SCA-11486 STEP 14, A CRACK WAS FOUND ON HOLE NR 7 AT SKIN (COUNTERSINK) AT 1 O'CLOCK POSITION (LOOKING TO AFT SIDE) ON RT WING. REPAIRED IAW ETI-737-25-206 REV 3 AND EA 57-0213.SDR DALA2025121609150Tail Cone · missingON WALK AROUND FOUND APU TAILCONE MISSING. PERFORMED SPLICE REPAIR ON WIRE 3348-7875 FROM 18LV IN THE FORWARD TAILCONE AREA. ALSO ROUTED HARNESS & SECURED GROUNDS, IAW ESPM 2347890-53-02-0201. REMOVED TAILCONE IAW AMM 53-58-11. REMOVED APU IAW AMM 49-11-11. SDR SIMA20251128001Floor Support · corrodedSSI 53-10-027 - FWD GALLEY RH FLOOR SILL CORRODED BETWEEN FR 12-14. (MAJOR REPAIR) (LEVEL 2 CORROSION) RAR FWD GALLEY RH FLOOR SILL BETWEEN FR 12-14 IAW ERJ 170 SRM 51-40-08SDR CALA2025121012000Frame · dentedONE DENT ON THE FWD CARGO BAY BS 760 SIDE FRAME, STRINGERS 23L & 24L. ACCOMPLISHED A REPAIR IAW EA 757-5330-13-A4207,SDR JJBA20251208016Floor Support · crackedCENTER FUSE II, LEFT OMEGA BEAM CRACKED AT FRAME 33. CF II, REPAIR DOUBLER ON LT OMEGA BEAM INBD VERT FLANGE AT FR 33.SDR F3LA20251201033Actuator · faultedACFT WAS GROUNDED AS A RESULT OF EVENT. 5 UNCOMMANDED RUDDER MOVEMENT DURING FLIGHT. 1ST 2 INITIALLY THOUGHT TO BE WX/WIND RELATED. LAST 3 HAPPENED DURING DESCENT & FINAL APPROACH WITH AP ON AND OFF. 4 WERE LEFT MOVEMENT, 1 WAS RIGHT MOVEMENT. FIRST ONE HAPPENSDR DALA2025120508885Floor Panel · overheatedDIVERTED INTO DFW DUE TO 4L FLOOR PANEL OVERHEATING CAUSING BURN MARK AND SMOKE. FLOOR PANEL PLACED ON MEL 25-27-01. LATER, REPLACED FLOOR PANEL HFP 39DS PER AMM 25-27-51 REV98. (LP 7945926)SDR JJBA20251204002Floor Support · crackedCENTER FUSELAGE II, LT OMEGA BEAM CRACKED AT FRAME 34. REPAIR DOUBLER ON LT OMEGA BEAM INBD VERT FLANGE AT FR 34.SDR DALA2025120308830Warning Light · illuminatedLEFT CENTER ENTR7 DOOR EICAS ILLUMINATED, JUST PRIOR TO V1 AND EXTINGUISHED JUST AFTER TAKE OFF, C/W DOOR WARNING TEST IAW AMM 52-71 TEST PASS NO 30DAY HIST. A/C OK TO CON IN SVC AT THIS TIME. (7788314)SDR SWAA2025120240418Screw · strippedFWD PORTABLE MEGAPHONE MULTIPLE ALLEN HEAD STRIPPED. REMOVED AND REPLACED FWD PORTABLE MEGAPHONE IAW AMM 25-64-00. OPS CHECKED GOOD.SDR SWAA2025120240419Screw · strippedAFT PORTABLE MEGAPHONE ALLEN HEADS STRIPPED. REMOVED AND REPLACED AFT PORTABLE MEGAPHONE IAW AMM 25-64-00. OPS CHECK GOOD.