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 FDEA202506251046Floorboard · damagedNR# 0297: MAIN CARGO COMPARTMENT, FLOOR PANEL 242SFF HAS DAMAGE FABRICATED NEW FLOOR PANEL 242SFF, MPN:145T5876-104, RBL 33- RBL 11, STATION 984.95 - 1114.82 IN REF TO BOEING DWG 145T5876-104. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJOR REPAIR. INSDR FDEA202506251045Fitting · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA1434 RBL6.5. MAIN DECK CARGO FLOOR FITTING CORROSION REMOVED AND EVALUATED : MEASURED THE REWORKED AREA BELONG TO ZONE C,THE MAX ALLOWABLE BLEND OUT IS 0.002, THE MAX CLEAN UP DEPTH IS X=0.058Ï¿½>0.002Ï¿½SDR FDEA202506251044Fitting · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA1434 LBL6.5. MAIN DECK CARGO FLOOR FITTING CORROSION REMOVED AND EVALUATED : MEASURED THE REWORKED AREA BELONG TO ZONE C, THE MAX ALLOWABLE BLEND OUT IS 0.002, THE MAX CLEAN UP DEPTH IS X=0.022Ï¿½>0.002ÏSDR FDEA202506251043Fitting · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA1413 LBL6.5. MAIN DECK CARGO FLOOR FITTING CORROSION REMOVED AND EVALUATED : MEASURED THE REWORKED AREA BELONG TO ZONE C,THE MAX ALLOWABLE BLEND OUT IS 0.002. THE MAX CLEAN UP DEPTH IS X=0.022 - 0.002 AND FSDR FDEA202506251042Fitting · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA 1193 RBL79. MAIN DECK CARGO FLOOR FITTING CORROSION REMOVED AND EVALUATED : MEASURED THE REWORKED AREA BELONG TO ZONE B,THE MAX ALLOWABLE BLEND OUT IS 0.030Ï¿½, THE MAX CLEAN UP DEPTH IS X=0.045Ï¿½>0.0SDR FDEA202506251041Fitting · corrodedMAIN DECK CARGO FLOOR FITTING FOUND CORROSION AT STA 1232 RBL79. MAIN DECK CARGO FLOOR FITTING CORROSION REMOVED AND EVALUATED : MEASURED THE REWORKED AREA BELONG TO ZONE Ï¿½BÏ¿½,THE MAX ALLOWABLE BLEND OUT IS 0.030Ï¿½, THE MAX CLEAN UP DEPTH IS X=0.041ÏSDR AALA202506259842Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR SEAT TRACK AT FR 47.5 AND LBL 30. REPAIRED SEAT TRACK PER SRM SRM 53-41-15-300-003.SDR AALA202506251103Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING AT SEAT ROW 28 ABC IS INOPERATIVE. RE-CONNECTED SEAT MOUNTED EMERGENCY LIGHT CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR AALA202506252928Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING AT SEAT ROW 27 ABC IS INOPERATIVE. RE-CONNECTED SEAT MOUNTED EMERGENCY LIGHT CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR AALA202506259689Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202506250770Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: EMERGENCY PATH LIGHTING AT SEAT ROW 23 ABC IS INOPERATIVE. RE-CONNECTED SEAT MOUNTED EMERGENCY LIGHT CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-19.SDR YENA2025062500650Gcu · failedFLT#2261, BOS-MAD. (ETOPS) "AC GEN CLASS II. REPLACED 4155KS ENG1 GEN HARNESS. TEST OF GEN 1 OK. ER GROUND VERIFICATION PASSED MX-4 UPDATED PLACARD REMOVED.SDR YENA2025062500649Transceiver · failedFLT#72, JFK-EDI. (ETOPS) WX RT W/NAV PRED W/S FAULT WHEN #2 SELECTED. ( WEATHER RADAR SYSTEMS ); (RESOLVED ON W/O: 1422140 TASKCARD: NR-00001) REMOVED AND REPLACED WX TRANCEIVER REF AMM 34-41-33-000-004-A OPS TEST WEATHER RADR SYSTEM GOOD REF AMM 34-41-00-736SDR KCSA202506251101Tension Tie · crackedCRACK FOUND IN TENSION TIE AFT CHANNEL AT STA 1180 AT LH SIDE END FASTENER DURING SURFACE HFEC NDT INSPECTIONSDR DALA2025062504741Skin · damagedSIX INCHES AFT OF FRAME 61 BETWEEN STRINGER 2R AND 3R SUPPORT HAS TOOLING MARKS. CORRECTIVE ACTION: REPAIRED PER ERA 626805-14 REV. B. SECTION III.SDR 2025FA0000423Psu · leakingDURING OXYGEN PASSENGER OXYGEN SYSTEM (MANUAL / AUTO MODE) - FUNCTIONAL CHECK IAW GVII-G600 AMM 35-20-01, AFTER MANUALLY DEPLOYING MASKS A SOUND OF ESCAPING OXYGEN WAS HEARD. UPON PSU LOWERING IN THE AFT LH CABIN, THE OXYGEN WAS FOUND TO BE LEAKING FROM THE PSSDR KCSA202506251100Frame · cracked1 EA. CRACK INDICATION IN FRAME AT L/H SIDE STA 1140 COMMON WITH TENSION TIESDR JR2R20250625690Floor Support · corrodedFLOORBOARD SUPPORT BRACKET JUST FWD OF THE LH SHEAR PANEL AT FR87 LBL24 IS CORRODED. REPLACED.SDR KCSA202506251099Plate · crackedR1 MAIN ENTRY DOOR HAS CRACKED FRAME STIFFENER ON FWD SIDE APPROX 18 INCHES UP FROM LWR EDGESDR JR2R20250625698Plate · corrodedGUSSET PLATE AT FR89 LBL10 IS CORRODED. REPLACED.SDR JR2R20250625871Attach Fitting · corrodedAFTER REMOVAL OF LH AFT MOP SILL, FOUND LAV ATTACH FITTING CORRODED AT FR0 LBL32 CORRODED. REPLACED.SDR JR2R20250625699Plate · corrodedGUSSET PLATE AT FR90 BL0 IS CORRODED. REPLACED.SDR SCNA20250625231Slide · not reportedR1 DOOR SLIDE UNUSABLE . R&R R1 SIDE IAW AMM 25-66-01 OK FOR SERVICE.SDR JGVR20250625002Skin · corrodedMECHANICALLY REMOVED 3 AREAS OF CORROSION FROM LH WING LOWER SKIN, INBOARD OF THE INBOARD FLAP, PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. REPAIRED CORROSION BLENDS NETJETS REQUEST FOR TECHNICAL SERVICES BY CLEANING, TREATING AND PRIMING REPAIR AREA.SDR KCSA202506251098Tension Tie · crackedFOUR FASTENER HOLES HAVE CRACK INDICATIONS IN L/H SIDE TENSION TIE FWD CHANNEL AT STA 1180SDR JGVR20250625001Angle · corrodedMECHANICALLY REMOVED 1 AREA OF CORROSION LOCATED IN THE RH MLG WHEEL WELL, ON THE AFT SPAR LOWER CLIP INSIDE BAY 720DR, INBOARD AREA PERFORMED NDT AND REPORTED FOR REPAIR DISPOSITION. REPAIRED CORROSION BLEND PER NETJETS ENGINEERING REQUEST FOR TECHNICAL SERVISDR KCSA202506251097Bear Strap · crackedFOUND CRACK INDICATION DURING HFEC OPEN HOLE INSPECTION AT STA 2231 STR 25R LWR FWD HOLESDR JR2R20250625694Sill Drain · corrodedRH MOP SILL BETWEEN FR88 TO FR 90, RBL 36, CORRODED. OUT OF LIMITS. REPLACEDSDR JR2R20250625695Sill Drain · corrodedLH MOP SILL BETWEEN FR88 TO FR 90, LBL 36, CORRODED. OUT OF LIMITS. REPLACEDSDR 2026FA0000481Door Latch · unlatchedDOOR SEALS/RIGGING IS A LITTLE OFF FROM NORMAL. COCKPIT IS 5 DB LOUDER THAN TAILS 003 & 005. MEASURED IN FRONT COCKPIT , 30 0#, LEVEL FLIGHT, 105DB IN THIS TAIL, 100DB IN THE REST (INCLUDES BLOCK 0 TAILS TOO) COMMENTS: AWAITING FURTHER DOWNTIME. DOES NOT AFSDR 2026FA0000105Bracket · crackedFLAP HANDLE FORWARD SUPPORT BRACKET FOUND CRACKED. NOTED AREA OF STRESS/CRACK A LACK OF RADIUS. REPLACED WITH FACTORY NEW BRACKET.SDR SWIA2026020475176Roller · out of limitsRIGHT TRACK ROLLER SLAT 2-2. COMPLY WITH TASK CARD 27-630-809. RT TRACK ROLLER SEALED, TRACK 2-2, TOP FORWARD - SLAT 2 (PN CC670-12272-1). REMOVED AND REPLACED RT FWD SLAT ROLLER AT POSITION 2-2 WITH NEW FROM STOCK IAW AMM 27-81-43-000-801-A01 AND 27-81-4SDR SWIA2025062475175Roller · out of limitsLEFT TRACK ROLLER SLAT 2-2. COMPLY WITH TASK CARD 27-530-809. LT TRACK ROLLER SEALED, TRACK 2-2, TOP FORWARD - SLAT 2 (PN CC670-12272-1). REMOVED AND REPLACED LT FWD SLAT ROLLER AT POSITION 2-2 WITH NEW FROM STOCK IAW AMM 27-81-43-000-801-A01 AND 27-81-43SDR SWIA2025062475174Roller · out of limitsTRACK ROLLER SLAT 1-3. COMPLY WITH TASK CARD 27-630-809. RT TRACK ROLLER SEALED, TRACK 1-3, TOP FORWARD - SLAT 1 (PN CC670-12272-1). REMOVED AND REPLACED RT FWD SLAT ROLLER AT POSITION 1-3 WITH NEW FROM STOCK IAW AMM 27-81-43-000-801-A01, AND 27-81-43-400-SDR SWIA2025062475173Roller · out of limitsLEFT TRACK ROLLER SLAT 1-3. COMPLY WITH TASK CARD 27-530-809. LT TRACK ROLLER SEALED, TRACK 1-3, TOP FORWARD - SLAT 1 (PN CC670-12272-1). REMOVED AND REPLACED LH FWD SLAT ROLLER AT POSITION 1-3 WITH NEW FROM STOCK IAW AMM 27-81-43-000-801-A01 AND 27-81-43-4SDR SWIA2025062475172Roller · out of limitsRIGHT TRACK ROLLER SLAT 1-2, COMPLY WITH TASK CARD 27-630-809. RT TRACK ROLLER SEALED, TRACK 1-2, TOP FORWARD - SLAT 1 (PN CC670-12272-1) INSTALLED TOP FORWARD SLAT-TRACK-ROLLER AT RT 1-2 IAW AMM 27-81-43-400-801-A01. OPS TEST GOOD.SDR SWIA2025062475171Roller · out of limitsLEFT TRACK ROLLER SLAT 1-2, LT TRACK ROLLER SEALED, TRACK 1-2, TOP FORWARD - SLAT 1 (PN CC670-12272-1) (MRB 27-81-43-717), INSTALLED TOP FORWARD SLAT-TRACK-ROLLER AT LT 1-2 IAW AMM 27-81-43-400-801-A01. OPS TESTED GOOD.SDR SWIA2025062475170Roller · out of limitsRIGHT SIDE ROLLER SLAT TRACK 3-2. RT SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12459-4 DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-630-816. INSTALLED NEW 4EA SLAT TRACK ROLLERS ON THE RT 3-2 SLAT TRACK IAW AMM 27-81-44-40SDR SWIA2025062475169Roller · out of limitsSIDE ROLLER SLAT TRACK 3-2. LT SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12459-3 DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-530-816. INSTALLED NEW FROM STOCK SLAT TRACK ROLLERS (4EA) ON LT 3-2 SLAT TRACK REF AMM 27-81-44-SDR SWIA2025062475168Roller · out of limitsSIDE ROLLER SLAT TRACK 2-2 900 RH - RH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-630-815. RESDR SWIA2025062475167Roller · out of limitsSIDE ROLLER SLAT TRACK 2-2 900 LH - LH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK PN CC670-12027-3 (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-530-815 (MRSDR SWIA2025062475166Roller · out of limitsSIDE ROLLER SLAT TRACK 1-2 900 RH - RH SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IAW 27-620-804 (MRB 27-81-43-702, 27-81-43-707). ISDR SWIA2025062475165Roller · out of limitsCOMPLY WITH SCHEDULED MAINTENANCE CODE: SIDE ROLLER SLAT TRACK 1-2, LT SIDE ROLLER ASSY 0.750 DIA. SLAT TRACK (QTY 2) AND SIDE ROLLER ASSY 0.875 DIA. SLAT TRACK PN CC670-12048-3 (QTY 2) ARE DUE LIFE LIMIT. REMOVE AND DISCARD. REPLACE WITH SERVICEABLE PARTS IASDR COEA2026012108816Spar · corrodedLEFT WING FWD SPAR UPPER STRIP SLAT LOWER SURFACE HAS LEVEL 2 CORROSION, RIB 0-4L. REPAIRED IAW SRAS DO/TS-4637/05. 03375 ISSUE C.SDR COEA2026012107816Mount · bentAFT CARGO DOOR FWD SHOCK STRUT MOUNT BENDING AT ATTACH POINT. REPAIRED PER ATR72 SRM 51-25-01 REV. 120.SDR COEA2026012106816Access Panel · corrodedRIGHT WING LANDING ACCESS DOOR PANEL 622CT HAS LEVEL 2 CORROSION. CORRECTIVE ACTION: REPAIRED PER SRAS DO/TS-3018/09...05261 ISSUE H, DATED 10/22/2025.SDR COEA2026012105816Spar · corrodedRIGHT WING FWD SPAR UPPER STRIP SLAT BOTTOM SURFACE HAS LEVEL 2 CORROSION BETWEEN RIBS 0-5R. REPAIRED PER SRAS S571K0138. 26447 ISSUE B, DATED 11/18/2025.SDR COEA2026012104816Access Panel · corrodedLEFT WING ACCESS DOOR PANEL LANDING 521DT HAS LEVEL 2 CORROSION. REPAIRED PER SRAS DO/TS-3018/09...05261 ISSUE H, DATED 10/22/2025.SDR COEA2026012103816Access Panel · corrodedLEFT WING ACCESS DOOR PANEL LANDING 522CT HAS LEVEL 2 CORROSION. REPAIRED IAW SRAS DO/TS-3018/09...05261 ISSUE H, DATED 10/22/2025.SDR SWI2025F01507Slat Track · wornRH SLAT TRACK 2-2 AFT IB, AFT OB AND FWD OB ROLLERS WORN OUT OF LIMITS. REMOVED AND REPLACED RH SLAT TRACK 2-2 AFT IB, AFT OB, AND FWD OB ROLLERS IAW AMM 27-81-44-000-802/27-81-44-400-802. PERFORMED OPS CHECK OF FLAP AND SLAT SYSTEMS IAW CRJ 900 AMM 27-50-00