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 CALA2025082708196Seat Track · corrodedCABIN FLOOR STRUCTURE L/H SEAT TRACK Y254 CORRODED AT FRS 21, 22 , 23. REMOVED AND REPLACED SEAT TRACK Y254 FR 12-24 LH IAW A320 SRM 51 -72-11-911-001 AND SRM 51-42-11 ACMP BY MECH V937285 INSP BY V89 2429SDR CALA2025082708195Seat Track · corrodedSEAT TRACK AT FR58 Y765 UPPER FLANGE CROWN GOUGED. REMOVED SEAT TRACK FR58-FR64 Y765 IAW A320 SRM 53-41-15-300-003 REV 154 REPLACED SEAT TRACK FR58-FR64 Y765 IAW A320 SRM 53-41-15 -300-003 REV 154.SDR CALA2025082708194Lens · brokenISLE 36 EMERGENCY PATH LIGHTING LENS BROKEN. REPLACED LENS. PRECAUTIONARY OPS CHECK GOOD. REF. AMM 33-51-11-960-801 FILLED SDR FOR WORK PERFORMED ON EMERGENCY ISLE LIGHTING ON ISLE 36.SDR CALA2025082708193Transducer · faultedELECTRONIC ENGINE CONTROL (EEC) RECENT FAULTS BITE TEST {B737-73-3-0068} - FOUND LONG TIME MAINTENANCE MESSAGE 78-11491 THE RT REVERSER SLEEVE IS OUT OF RANGE ON ENGINE NR 1, MX WORKED EEC FAULT ON L/P 5753712 IN WHICH FAULT WAS 78-31491 DUAL CHANNEL FAULT FORSDR CALA2025082708171Switch · out of positionEMERGENCY EXIT LIGHTS ONUNABLE TO TURN OFF LIGHT SWITCH WAS IN THE WRONG POSITION. EMERGENCY LIGHTS WORKING NORMALLY OK TO CONT.SDR CALA2025082708163Oven · odorCOCKPIT DOOR DIFFICULT OPEN AND CLOSE. CREW REPORTS NO SMOKE OR SPARKS, BUT A STRONG ODOR FROM OVEN WHILE RUNNING. REQUESTING TO PLACE FWD GALLEY OVEN #204 ON NEF 2511110AU. C/B PULLED AND COLLARD, DDP C/W. NEF 2510AU MX TO SIGN OFF FWD GALLY OVEN#204 NEF REQUSDR CALA2025082708162Unknown · odorSEVERAL FAS REPRORTED FEELING LIGHT HEADED DURING FLT & AGAIN DURING DESCENT. IT WAS REPORTED THAT DURING CREW DISEMBARKMENT, NONE OF THE MEMBERS EXPRESSED CONCERN FOR THE SYMPTOMS. FOUND NO EVIDENCE OF ODORS, FLUIDS OR MAINTENANCE MESSAGES IAW AMM DMC-B78SDR HALA20250826263Gcu · no testDIV - ECAM: GEN 1 FAIL. EPGS SYSTEM TEST: GCU 1 TEST FAILED. FAULT MESSAGE IDG1(E1-400XU)SERVO VLV/GCU1 (1XU1). PERFORMED TSM 24-20-00-810-914-A. FOUND CABLE E1-400XU CONTAMINATED AND SLIGHTLY LOOSE. CLEANED AND SECURED AS REQUIRED. RESISTANCE & WIRE CHECKS ALSDR 2025F00204Elec Connector · burnedFLIGHT CREW REPORTED "SMOKE IN THE CABIN". FURTHER INVESTIGATION REVELED AN IMPROPER SOLDER CONNECTING FOR THE MEDICAL BED INSTALLATION UNDER SPECTRUM AEROMED STC SA02488CH. POWER THROUGH THE POOR SOLDER CONNECTION GENERATED EXCESSIVE HEAT THAT EFFECTED THE ADSDR DALA2025082606341Skin · dentedDENT AT THE LT FUSELAGE SKIN PANEL AFT OF FR70 AND BETWEEN STGR 16LH AND 17LH. COMPLIED WITH ER/A 628804-14. (1164780).SDR 2025FA0000580Door · openEPU DOOR OPENED IN FLIGHT. ADVISORY CAUTION WAS NOTED. MADE PRECAUTIONARY LANDING AND CLOSED THE DOOR NO FURTHER ACTIONS NEEDED.SDR BAGA2025082600009Battery · failedELPU TEST FAILED, LIGHT WAS INOP. REPLACED ELPU. DURING TROUBLESHOOTING DISCOVERED AFT EMERGENCY LIGHTS WERE INOP. REPLACED #6 EMERGENCY LIGHT POWER UNIT BATTERY #6.SDR F3LA202508260287Power Supply · no testAIRCRAFT WAS UNDERGOING HEAVY SERVICE CHECK DURING RON MAINTENANCE, ITEM #3 BATT/EPSU (11WL) EMER L FAULT. R&R EPSU BATTERY 11WL REF AMM 33-51-38-400-001-A/AMM 33-51-38-400-001 TEST OK.SDR IPXA2025082654686Battery · no testEMER LT BAT 1 LO DURING EMERGENCY LIGHT TEST EMERGENCY POWER SUPPLY BATTERY R&R IAW AMM 33-51-01/401. EMERGENCY LIGHT CHECKS SERVICEABLE.SDR ABXA20250826199Fuse · defectiveDURING TAXI, R HYD SYSTEM QUANITY LOW. AIRCRAFT RETURNED TO BLOCKS. (BTB). MAINTENANCE REMOVED AND REPLACED HYDRAULIC FUSE ON RH ANTISKID MODULE OUT "D" POSITION. OPERATIONAL AND LEAK CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR IKBR2025082600579Elec Connector · intermittentENGINE OIL PRESSURE INDICATION ERRATIC. REMOVED AND REPLACED ENGINE OIL PRESSURE TRANSDUCER WIRING CONNECTOR WITH NEW P/N S2800-277 REFERENCING CESSNA 172S WDG CH.77-40-01 (REV. A1). ENGINE RUN, OIL PRESSURE OPERATIONAL CHECK SATISFACTORY.SDR 2025FA0000578Elec Connector · failedFUEL PRESSURE INDICATIONS ERRATIC. REPLACE FUEL PRESSURE TRANSDUCER CONNECTOR (JN001) PN: S2800-277 REFERENCING TEXTRON MODEL 172 (SERIES 1996 AND ON) WIRING DIAGRAM MANUAL REV A1 SECTION 77-20-01, FIGURE 02 (REV A0).SDR AALA202508265824Wire · brokenAIRCRAFT WAS GROUNDED: SEAT 4C END BAY EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE AT THE 4C IN-SEAT WIRE HARNESS, REPAIRED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00-710-007-A WITH NO DEFECTS NOTED.SDR AALA202508264177Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508264649Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR FDEA202508261540Lamp · inoperativeR EXTERIOR EMERGENCY SLIDE LIGHT INOP AMM: 33-51-06-2-1 RELAMPED R EXTERIOR SLIDE EMERGENCY LIGHT, OP'S CHECKS GOOD. LAMP P/N 767, NO SERIAL NUMBERSDR FDEA202508261539Seat Track · wornMAIN DECK SEAT TRACK AT FR63 -Y2462 WORN REPAIRED THE MAIN DECK WORN SEAT TRACK AT FR63 -Y2462 PER A300-600F SRM53-10-16-201 FIG.201. THIS IS CATEGORY Ï¿½AÏ¿½ REPAIR. MAJOR REPAIR IAW FEDEX GMM6-2-100.SDR FDEA202508261538Web · crackedMAIN DECK UNDERFLOOR WEB CRACKED AT FR47 BETWEEN Y0 AND -Y450 REPAIRED THE CRACKED WEB IN MAIN DECK UNDERFLOOR AT FR47 BETWEEN Y0 AND -Y450 PER A300-600F SRM53-15-15-201-C2. THIS IS CATEGORY "B" REPAIR AND MUST BE INSPECTED AT DEFINED INTERVALS PER A300-60SDR 2025FA0000577Elec Connector · intermittentENGINE OIL PRESSURE ERRATIC.REMOVED AND REPLACED ENGINE OIL PRESSURE TRANSDUCER ELECTRICAL CONNECTOR (JN004) WITH NEW P/N S2800-277 REFERENCING CESSNA 172S WDG CH.79-30-01 (REV.A1). ENGINE RUN, OIL PRESSURE SYSTEM OPERATIONAL CHECK SATISFACTORY.SDR IKBR2025082600576Elec Connector · failedENGINE OIL PRESSURE ERRATIC. REMOVED AND REPLACED ENGINE OIL PRESSURE TRANSDUCER ELECTRICAL CONNECTOR (JN004) WITH NEW P/N S2800-277 REFERENCING CESSNA 172S WDG CH.79-30-01 (REV.A1). ENGINE RUN, OIL PRESSURE SYSTEM OPERATIONAL CHECK SATISFACTORY.SDR 2025FA0000575Elec Connector · intermittentENGINE OIL PRESSURE ERRATIC. REMOVED AND REPLACED ENGINE OIL PRESSURE TRANSDUCER ELECTRICAL CONNECTOR (JN004) WITH NEW P/N S2800-277 REFERENCING CESSNA 172S WDG CH.79-30-01 (REV.A1). ENGINE RUN, OIL PRESSURE SYSTEM OPERATIONAL CHECK SATISFACTORY.SDR 2025FA0000574Elec Connector · intermittentENGINE OIL PRESSURE FLUCTUATES. REMOVED AND REPLACED THE OIL PRESSURE TRANSDUCER CONNECTOR JN004 PN: S2800-277 REFERENCING CESSNA/TEXTRON MODEL 172 (SERIES 1996 AND ON) WIRING DIAGRAM MANUAL REV A1, 77-40-01, FIGURE 03: SHEET 02 “ENGINE AND AIRFRAME MONITOR”.SDR QR9R2025082600002Gcu · failedGEN DISCON ON #1 SIDE APPROXIMATELY 10 MINUTES INTO FLIGHT. REMOVED AND REPLACED #1 ENG GCU IAW AMM 24-30-00, 4-1.SDR QR9R2025082600001Hinge · brokenAT HOVER, PILOT SIDE CABIN DOOR HINGE FITTING BROKE WITH DOOR UNABLE TO BE SECURED. REPLACED FITTING IAW AMM 52-11-00, 4-1.SDR IXXA20250826001Bracket · corrodedCORROSION FOUND ON FRAME AT STA 1896.20 RIGHT SIDE O/B OF APU SUPPORT ROD BRACKET.SDR 2025F00201Skin · corrodedMECHANICALLY BLENDED 7 AREAS OF CORROSION LOCATED BELOW AFT BAGGAGE FLOOR BETWEEN FS534.70 AND FS548.50 IAW SRM 51-70-02. FOUND CORROSION BLEND TO BE BEYOND LIMITS IAW SRM 51-70-02 EXCEEDING 0.002" OF MATERIAL REMOVED FROM NOMINAL THICKNESS. REPAIRED CORROSISDR 2025F00200Skin · corrodedMECHANICALLY BLENDED 12 AREAS OF CORROSION LOCATED BELOW AFT BAGGAGE FLOOR BETWEEN FS519.37 AND FS534.70 IAW SRM 51-70-02. FOUND 10 AREAS OF CORROSION BLENDING TO BE WITHIN LIMITS IAW SRM 51-70-02. PROTECTED BARE METAL IAW C680 SRM 51-20-01. THIS IS A PSE ARESDR 2025F00199Skin · corrodedMECHANICALLY BLENDED 17 AREAS OF CORROSION LOCATED BELOW AFT BAGGAGE FLOOR BETWEEN FS468.05 AND FS484.65 IAW SRM 51-70-02. FOUND CORROSION BLEND TO BE BEYOND LIMITS IAW SRM 51-70-02 EXCEEDING 0.002" OF MATERIAL REMOVED FROM NOMINAL THICKNESS. REPAIRED CORROSIOSDR 2025F00198Structure · corrodedMECHANICALLY BLENDED 7 AREAS OF CORROSION LOCATED BELOW AFT BAGGAGE FLOOR BETWEEN FS501.25 AND FS519.37 IAW SRM 51-70-02. FOUND 5 AREAS OF CORROSION BLENDING TO BE WITHIN LIMITS IAW SRM 51-70-02. PROTECTED BARE METAL IAW C680 SRM 51-20-01. THIS IS A PSE AREA ISDR SWIA202512120825Rib · crackedRIGHT WING LEADING EDGE RIB AT WS 58.41 CRACKED NEAR THE TOP. PERFORMED REPAIR LEADING EDGE RIB WS 58.41 AT RT WING IAW REO 670-57-41-644 REV-, SRM 57-41-12, NDT PERFORMED.SDR SWIA2025120200825Floor Support · crackedFLOOR SUPPORT, LBL12 BETWEEN BS 250 - 280 CRACKED TRANS 30724720. REMOVED AND REPLACED FLOOR SUPPORT IAW SRM 51-42-06-001-001-A01, AND DWG CC670-33052, REV G.SDR SWI2025F01569Slat Track · wornRH WING SLAT TRACK 3-3 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2203 REV-- DATED 2025-09-12 PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OK AT THIS MOMENTCOMSDR SWI2025F01568Slat Track · corrodedRH WING SLAT TRACK 3-2 HAS CORROSION IN MULTIPLE SPOTS, INCLUDING O/B SIDE. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2199 REV-- DATED 2025-06-12PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OKSDR SWI2025F01567Slat Track · wornRH WING SLAT TRACK 3-1 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025) COMPLIED WITH REO 670-57-42-2200 REV-- DATED 2025-09-12 PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OK AT THIS MOMENT SDR SWI2025F01566Slat Track · wornLH WING SLAT TRACK 2-2 HAS WEAR MARKS AND PITTING IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2210 REV-- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 51-9SDR SWI2025F01565Slat Track · wornLH WING SLAT TRACK 3-1 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2208 REV -- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 27-900-1009-SKSDR SWI2025F01579Slat Track · damagedRH WING SLAT TRACK 2-2 HAS PITTING IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2202 REV -- DATED 2025-09-12. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWI2025F01578Slat Track · wornRH WING SLAT TRACK 1-1 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2197 REV-- DATED 2025-09-12 PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OK AT THIS MOMENTCOSDR SWI2025F01577Slat Track · corrodedLH WING SLAT TRACK 1-1 HAS PITTING AND CORROSION, INCLUDING I/B AND O/B SIDES. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2206 REV -- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASSDR SWI2025F01576Slat Track · wornLH WING SLAT TRACK 1-2 HAS WEAR MARKS AND PITTING IN MULTIPLE SPOTS, INCLUDING I/B AND O/B SIDES. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2207 REV-- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLISDR SWI2025F01575Slat Track · corrodedLH WING SLAT TRACK 2-3 HAS CORROSION ON THE INBOARD SIDE. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2212 REV -- DATED 2025-09-16. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 27-900-1009-SKSDR SWI2025F01574Slat Track · wornLH WING SLAT TRACK 1-1 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2206 REV -- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 27-900-1009-SKYSDR SWI2025F01573Slat Track · wornLH WING SLAT TRACK 2-1 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2209 REV-- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 27-900-1009-SKY SDR SWI2025F01572Slat Track · wornLH WING SLAT TRACK 3-2 HAS WEAR MARKS AND PITTING. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2205 REV -- DATED 2025-09-15. OPS TEST GOOD AT THIS TIME PER CRJ700 AMM 27-50-00-710-801-A02. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWI2025F01571Slat Track · wornRH WING SLAT TRACK 2-3 HAS WEAR MARKS IN MULTIPLE SPOTS. (MARKED) (C-CHECK RO 11/22/2025)COMPLIED WITH REO 670-57-42-2201 REV -- DATED 2025-09-12PERFORMED OPERATIONAL TEST OF THE FLAPS AND SLAT SYSTEM CRJ700 AMM 27-50-00-710-801-A02 TEST OK AT THIS MOMENTCO