Service difficulty reports
1,771,154 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 DALA2026062903832Indicator · out of adjust3L DOOR NOT ARMING PROPERLY. ADJUSTED KNUCKLE KNOCKER ON L3 DOOR. DOOR ARMS NORMAL. (880476) AIRCRAFT WAS GROUNDED.SDR UIEA2026062800550Wire · damagedFIRE APU WARNING MSG. DISCHARGED BOTTLE. REF WDM 26-15-11-1 INSPECTED AND FOUND W720-452-18R AND W720-451-18R SHORTED TO EACH OTHER UNDER CLAMP. REPAIRED WIRES PER SWPM 20-30-12. FIRE SYSTEM TEST PASSED FOR APU LOOPS A ND B PER AMM 26-15-00-735-009. </P>)SDR IPXA2026062990060Indicator · stuckEMERGENCY DECLARED, FLAP INDICATOR DISAGREE ,RAN QRH CHECKLIST.RT TE PLAP INDICATOR EVENTUALLY UNSTUCK REMOVED AND REPLACED FLAP INDICATOR AS PER AMM 27-58-02, OPS TEST OKSDR IPXA2026062984329Seal · brokenAERODYNAMIC SEAL BROKEN, FWD LH ENTRY DOOR (REPLACE) 1. I.A.W AMM 52-12-01-004-001 REV. 148 REMOVE CREW ENTRY DOOR.SDR IPXA202606290225Skin · crackedNR 1 ENG INLET COWL LIP CRACKED BETWEEN 11 AND 1 O'CLOCK POSITIONS REMOVED #1 ENGINE INLET IAW AMM 71-11-01SDR IPXA2026062992800Light · inoperativeSMALL LIGHT IN LAV INOP.SDR IPXA2026062986856Seal · damagedFOUND NO.1 ENTRY DOOR LOWER SEAL DAMAGEDSDR IPXA2026062992527Lamp · inoperativeSMALL EMERGENCY EXIT LIGHT IN LAV INOP IN THE ALWAYS ON LOW POSITION. SMALL RECTANGLE LIGHT. RELAMPED LAV AUX/MIRROR LIGHT PER 33-51-21. OPS CHECK GOODSDR IPXA2026062989347Life Vest · missingRIGHT SIDE BEHIND FIRST OFFICER, OBSERVER LIFE VEST MISSING. RIGHT FO CONSOL LIFE VEST INSTALLED REF AMM 25-64-00SDR UIEA2026053000372Stringer · crackedM/D - 1EA CRACK FOUND AT FWD OF BS 2360 STR 1R(<P>M/D - 1EA CRACK AT FWD OF BS 2360 STR 1R AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000373Stringer · crackedEO 4853A158 1-4 M/D - 1EA CRACK FOUND AT FWD OF BS 2360 STR 2L(<P>BS2360 FWD STR 2L CRACK ON STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8</P>)SDR UIEA2026053000374Stringer · crackedM/D - 1EA CRACK FOUND AT FWD OF BS 2360 STR 2R(<P>M/D - 1EA CRACK AT FWD OF BS 2360 STR 2R AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000375Stringer · crackedM/D - 1EA CRACK FOUND AT FWD OF BS 2360 STR 6R(<P>M/D - 1EA CRACK AT FWD OF BS 2360 STR 6R AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000376Stringer · crackedM/D - 1EA CRACK FOUND AT FWD OF BS 2360 STR 7R(<P>M/D - 1EA CRACK AT FWD OF BS 2360 STR 7R AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000377Stringer · crackedM/D - 1EA CRCK FOUND AT FWD OF BS 2360 STR 8(<P>M/D - 1EA CRACK AT FWD OF BS 2360 STR 8 AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000378Stringer · crackedBS2360 FWD STR 7L FOUND 2EA CRACKS ON STRINGER BETWEEN FASTENER HOLE(<P>BS2360 FWD STR 7L 2EA CRACKS ON STRINGER BETWEEN FASTENER HOLE CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000379Stringer · crackedBS2360 FWD STR 11L FOUND 1EA CRACK STARTING FROM STRINGER AFT EDGE(<P>BS2360 FWD STR 11L 1EA CRACK STARTING FROM STRINGER AFT EDGE AREA REPAIRED I.A.W RI-53-61-18312 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000380Stringer · crackedM/D - STA 2360 FWD S21L STRINGER FND SUSPECTED CRACK(<P>M/D - STA 2360 FWD S21L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE:20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000381Stringer · crackedM/D - STA 2360 FWD S20R STRINGER FND SUSPECTED CRACK(<P>M/D - STA 2360 FWD S20R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000382Stringer · crackedM/D - STA 2360 FWD S21R STRINGER FND SUSPECTED CRACK. M/D - STA 2360 FWD S21R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-8 REPAIR 8 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000383Stringer · crackedFX - STA 2360 AFT FACE STRINGER S20L SUSPECT CRACK.(<P>FX - STA 2360 AFT FACE STRINGER S20L CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000384Stringer · crackedFX - STA 2360 AFT FACE STRINGER S21L SUSPECT CRACK.(<P>FX - STA 2360 AFT FACE STRINGER S21L CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000385Stringer · crackedFX - STA 2360 AFT FACE STRINGER S15R SUSPECT CRACK(<P>FX - STA 2360 AFT FACE STRINGER S15R CRACK AREA REPAIRED I.A.W RI-53-81-18313 REV.B. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000386Stringer · crackedFX - STA 2360 AFT FACE STRINGER S22R SUSPECT CRACK(<P>FX - STA 2360 AFT FACE STRINGER S22R CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000387Stringer · crackedSTA 2360 AFT FACE STRINGER S20R SUSPECT CRACK. STA 2360 AFT FACE STRINGER S20R CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026 TR:53-165. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000388Stringer · crackedBS STA 2360 AFT OF PRESSURE BULKHEAD STR 3L FOUND CRACKED(<P>BS STA 2360 AFT OF PRESSURE BULKHEAD STR 3L CRACKED AREA REPAIRED I.A.W RI-53-81-18317 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000389Stringer · crackedBS STA 2360 AFT OF PRESSURE BULKHEAD STR 1R FOUND CRACKS AS MARKED(<P>BS STA 2360 AFT OF PRESSURE BULKHEAD STR 1R AREA REPAIRED I.A.W RI-53-81-18300 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000390Stringer · crackedSTA 2360 AFT FACE S4L STRINGER SUSPECT CRACK. STA 2360 AFT FACE S4L STRINGER CRACK AREA REPAIRED I.A.W RI-53-81-18309 REV.B. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000391Stringer · crackedFX - STA 2360 AFT FACE S5L STRINGER SUSPECT CRACK(<P>FX - STA 2360 AFT FACE S5L STRINGER CRACK AREA REPAIRED I.A.W RI-53-81-18331 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000392Stringer · crackedSTA 2360 AFT FACE S6L STRINGER SUSPECT CRACK. STA 2360 AFT FACE S6L STRINGER CRACK AREA REPAIRED I.A.W RI-53-81-18353 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000393Stringer · crackedFX - STA 2360 AFT FACE S7L STRINGER SUSPECT CRACK(<P>FX - STA 2360 AFT FACE S7L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000394Stringer · crackedFX - STA 2360 AFT FACE S8L STRINGER SUSPECT CRACK(<P>FX - STA 2360 AFT FACE S8L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000395Stringer · crackedFX - STA 2360 AFT FACE S6R STRINGER SUSPECT CRACK(<P>FX - STA 2360 AFT FACE S6R STRINGER CRACK AREA REPAIRED I.A.W RI-53-81-18354 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000396Stringer · crackedFX - STA 2360 AFT FACE S7R STRINGER SUSPECT CRACK(<P>FX - STA 2360 AFT FACE S7R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000397Stringer · crackedFX - STA 2360 AFT FACE S5R STRINGER SUSPECT CRACK(<P>FX - STA 2360 AFT FACE S5R STRINGER CRACK AREA REPAIRED I.A.W RI-53-81-18330 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000398Stringer · crackedFX - STA 2360 AFT FACE STRINGER S24R SUSPECT CRACK(<P>FX - STA 2360 AFT FACE STRINGER S24R CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026 TR:53-165. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000399Stringer · crackedFX - STA 2360 AFT FACE STRINGER S25R SUSPECT CRACK(<P>FX - STA 2360 AFT FACE STRINGER S25R CRACK AREA REPAIRED I.A.W SRM 53-80-03-2R-3 REPAIR 3 REV.48 DATE: 20 FEB 2026 TR:53-165. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000400Stringer · crackedM/D - STA 1960 FWD AND AFT S10L STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 FWD AND AFT S10L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-4 REPAIR 4. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000401Stringer · crackedM/D - STA 1960 FWD AND AFT S12L STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 FWD AND AFT S12L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-4 REPAIR 4. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000402Stringer · crackedM/D - STA 1960 FWD AND AFT S11R STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 FWD AND AFT S11R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-4 REPAIR 4. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000403Stringer · crackedM/D - STA 1960 FWD AND AFT S12R STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 FWD AND AFT S-12R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-4 REPAIR 4. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000404Stringer · crackedM/D - STA 2180 FWD AND AFT S10R STRINGER FND SUSPECTED CRACK(<P>M/D - STA 2180 FWD AND AFT S10R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-3 REPAIR 3 ALTERNATIVE 4 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000405Stringer · crackedM/D - STA 2180 FWD AND AFT S12R STRINGER FND SUSPECTED CRACK(<P>M/D - STA 2180 FWD AND AFT S12R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-3 REPAIR 3 ALTERNATIVE 4 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000406Stringer · crackedM/D - STA 2180 FWD AND AFT S12L STRINGER FND SUSPECTED CRACK(<P>M/D - STA 2180 FWD AND AFT S12L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-3 REPAIR 3 ALTERNATIVE 4 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000407Stringer · crackedM/D - STA 2180 FWD AND AFT S10L STRINGER FND SUSPEPCTED CRACK(<P>M/D - STA 2180 FWD AND AFT S10L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-3 REPAIR 3 ALTERNATIVE 4 REV.48 DATE 20 FEB 2026. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000408Stringer · crackedM/D - STA 1960 FWD AND AFT S9R STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 FWD AND AFT S9R STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-4 REPAIR 4. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000409Stringer · crackedM/D - STA 1960 AFT S11L STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 AFT S11L STRINGER CRACK AREA REPAIRED I.A.W SRM 53-60-03-2R-4 REPAIR 4. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000410Stringer · crackedSTA 1960 FWD AND AFT S13L STRINGER FND SUSPECTED CRACK(<P>M/D - STA 1960 FWD AND AFT S13L STRINGER CRACK AREA REPAIRED I.A.W RI-53-61-18321 REV.C. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000411Stringer · crackedSTA 2598 AFT FACE STRINGER S-42R FOUND CRACK(<P>FX - STA 2598 AFT FACE STRINGER S-42R CRACK AREA REPAIRED I.A.W RI-53-81-18339 REV.A. NO FURTHER DEFECTS NOTED.</P>)SDR UIEA2026053000412Stringer · crackedSTA 2598 AFT FACE STRINGER S42L SUSPECT CRACK(<P>FX - STA 2598 AFT FACE STRINGER S42L CRACK AREA REPAIRED I.A.W RI-53-81-18351 REV.A. NO FURTHER DEFECTS NOTED.</P>)