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 UIEA2026052000342Fairing · cracked#1 PYLON LH T/E FAIRING DOOR FWD INNER SKIN FOUND CRACK(<P>PERFORMED REPAIR AT CRACK AREA AS PER HX RI-54-56-18252 REV.A. NO FURTHER DEFECTS NOTED</P>)SDR UIEA2026052000343Fairing · cracked#4 PYLON RH T/E FAIRING DOOR FWD INNER SKIN FOUND CRACK(<P>PERFORMED REPAIR AT CRACK AREA AS PER HX RI-54-56-18250 REV.A. NO FURTHER DEFECTS NOTED</P>)SDR UIEA2026052000344Fairing · cracked#4 PYLON LH T/E FAIRING DOOR FWD INNER SKIN FOUND CRACK(<P>PERFORMED REPAIR AT CRACK AREA AS PER HX RI-54-56-18251 REV.A. NO FURTHER DEFECTS NOTED</P>)SDR DALA2026052703187Battery · overheatedAT CRUISE, FA HAD USE THE LITHUIUM CONTAINMENT BAG FOR AN OVERHEATING EXTERNAL BATTERY. FWD TO MCC PER NEF 25-32-13. ALL REMARK C/W SEE L//P 8936275. (LP: 8936274) AIRCRAFT WAS GROUNDEDSDR AALA202605278279A/C Pack · contaminatedAIRCRAFT WAS GROUNDED: DURING APPROACH, MUSTY SOCK SMELL WAS COMING OUT OF THE VENTS ONTHE FLIGHT DECK AND IN THE CABIN. TURNED OFF CABIN FANS, TURN OFF BOTH PACKS AND OPEN THE AIR AND SMELL WENT AWAY. REF MIC 7354430. MAINTENANCE ACCOMPLISHED J/C 26L00021002,SDR R61A2026052300144Hydraulic Line · leakingHYD 2 LOW QTY MSG. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED #2 HYD PRESSURE LINE.SDR R61A2026052300143Sensor · faultedANTI-ICE WING 1 LEAK EICAS MSG. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REMOVED AND REPLACED LH WING SLAT #2 WING ANTI-ICE BACKWALL TEMP SENSOR AND W511 HARNESS.SDR SWIA2026052376033Wire Harness · kinkedNOSE WHEEL STEERING INOP CAUTION APPEARED UPON GEAR RETRACTION FOLLOWED BY GEAR DISAGREE WARNING. RAN QRH AND RETURNED TO ORD (FLIGHT 5225) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 32313779. SEE CP 32314120 AND CP 32315261 FOR TROUBLESHOOTING AND MAINSDR SWAA2026052606114Battery · inoperativeFLIGHT ATTENDANT MEGAPHONE INOPERATIVE. REPLACED MEGAPHONE BATTERIES IAW AMM 25-64-00.SDR DALA2026052603176Sign · brokenEXIT SIGN IN SECOND EXIT ROW LEFT SIDE BROKEN. REINSTALLED EXIT SIGN REF AMM 33-51. (8607116) AIRCRAFT WAS GROUNDEDSDR AALA202605261519Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 14WL BATTERY FAULT DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 14WL PER AMM 33-51-38 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO FAULTS NOTED.SDR AALA202605260844Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: AT ALTITUDE DURING CRUISE PORTION OF FLIGHT, FLIGHT DECK DOOR HANDLE DIFFICULT TO TURN, TO OPEN DOOR. MAINTENANCE ADJUSTED THE MIDDLE DOOR LATCH ON THE FLIGHT DECK DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER CMM 25-20-SDR AALA202605267312Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY POWER SUPPLY UNIT 10WL BATTERY FAULT DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 10WL PER AMM 33-51-38 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO FAULTS NOTED.SDR AALA202605261959Battery · no testAIRCRAFT WAS GROUNDED: MID RIGHT EMERGENCY POWER SUPPLY UNIT BATTERY AND EXIT SIGNS FAULTS DISPLAYED DURING SYSTEM TEST. REPLACED BATTERY FOR THE MID RIGHT EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38 AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK WITH NO FSDR AALA202605264601Hinge Arm · stickingAIRCRAFT WAS NOT GROUNDED: L4 DOOR DIFFICULT TO CLOSE. MAINTENANCE LUBRICATED THE L4 DOOR HINGE ARM SUPPORT BEARINGS PER AMM 12-22-52.SDR AALA202605269170Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202605267072Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202605263702Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FLASHLIGHT LOCATED AT DOOR 4R IS INOPERATIVE. MAINTENANCE REPLACED THE FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER JOB CARD 26C00025003.SDR IPXA2026052326635Compensator · faultedLEFT GEAR BRAKE TEMPS SHOW ZERO REQS FURTHER TS REF BARCODE T3F18E008VZQZ. REMOVED AND REPLACED BAD COMPENSATION UNIT PER A300 AMM 32-47-13/401. OPS CHECK GOOD AT THIS TIME.SDR IPXA2026052424821Stiffener · crackedCRACKED STIFFENER, FLOOR SUPPORT STRUCTURE STA 785.9 RBL 11. ACCOMPLISH THE REPAIR I.A.W SRM 57-10-10-2R-2 REV. 95 AND EGAT WORK SHEET NO: 60431 AND EO-58151-REQ001 REV1.SDR IPXA2026052425094Stiffener · crackedCRACKED STIFFENER, FLOOR SUPPORT STRUCTURE STA 785.9 LBL 55. ACCOMPLISH THE REPAIR I.A.W SRM 57-10-10-2R-2 REV. 95 AND EGAT WORK SHEET NO: 60432 AND EO-58151-REQ001 REV1.SDR IPXA2026052425098Stiffener · crackedCRACKED STIFFENER, FLOOR SUPPORT STRUCTURE STA 785.9 RBL 55. ACCOMPLISH THE REPAIR I.A.W SRM 57-10-10-2R-2 REV. 95 AND EGAT WORK SHEET NO: 60430 AND EO-58151-REQ001 REV1.SDR DALA2026052603168Oxygen Mask · unwanted deployO2 MASK DROPPED DURING TAKEOFF AFT LEFT LAV. RE-PACKED MASKS PER A330 AMM 35-21. (9072013) AIRCRAFT WAS GROUNDED.SDR DALA2026052603166Diaphragm · leakingL4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER CAN'T HOLD THE PRESSURE. CORRECTIVE ACTION: REPLACED DIAPRAGM AND SERVICED PER A330 AMM 52-15. (8648370) AIRCRAFT WAS GROUNDED.SDR AALA202605263209Sign · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTS OVER WING CEILING EXIT SIGN IS MISSING. INSTALLED OVER WING CEILING EXIT SIGN. PER GPM 17-11-4.SDR UIEA2026052300346Actuator · faultedNOSE "GEAR DOOR" EICAS MSG AFTER GEAR RETRACTION. RAN QRH, NO HELP. DURING INSPECTION, FOUND NLG DOOR ACTUATOR DAMAGED. REMOVED AND REPLACED NOSE GEAR DOOR ACTUATOR AND CHECKED NML PER AMM 32-34-14 AND IPC 32-34-14-10. OPS CHK OKSDR UIEA2026052600351Skin · damagedLIGHTING STRIKE - SKIN, NOSE CARGO EXTERNAL SKIN NEAR STA 200, S-36R ~ S-39R. ACCOMPLISHED WORK SHEET NO 60306 (SRM 53-00-01-2R-9 REV 48) AND EI NO T2026A52M-969 REV 0 AND REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600352Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 2180 S-10L FWD AND AFT SIDE. PERFORMED REPAIR IAW W/S 60308 (SRM 53-60-03-2R-3 REV 48). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600353Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 2180 S-11L FWD AND AFT SIDE. PERFORMED REPAIR IAW W/S 60309 (SRM 53-60-03-2R-3 REV 48). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600354Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR BS 2360 S-7R FWD SIDE. PERFORMED REPAIR IAW W/S 60302 (SRM 53-60-03-2R-8 REV 48). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600355Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 1960 S-12R FWD AND AFT SIDE. REPAIRED DAMAGE AREA IAW W/S #60310 (SRM 53-60-03-2R-4 REV 48). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600356Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR BS 2180 S-10R AFT SIDE. REPAIRED DAMAGE AREA IAW W/S #60294 (SRM 53-60-03-2R-3 REV 48). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600357Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR BS 2180 S-12R FWD AND AFT SIDE. REPAIRED DAMAGE AREA IAW W/S #60307 (SRM 53-60-03-2R-3 REV 48). JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600358Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 940 AND STA 960, S-9R. REPAIRED DAMAGE AREA IAW W/S 60297 AND SRM 53-20-03-2R-1 ALTERNATIVE 2 REV 48. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600359Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 980 +160 ~ 1000 S-11L. REPAIRED DAMAGE AREA IAW W/S 60298 AND SRM 53-20-03-2R-1 ALTERNATIVE 1 REV 48 AND EI #T2026A53M-972 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600360Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 920 S-11R. REPAIRED DAMAGE AREA IAW W/S #60299 AND SRM 53-20-03-2R-1 ALTERNATIVE 2 REV 48 AND EI #T2026A53M-973 REV 2. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600361Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 980+160 ~ 1000 S-11R. REPAIRED DAMAGE AREA IAW W/S 60301 AND SRM 53-20-03-2R-1 ALTERNATIVE 2 REV 48 AND EI T2026A53M-973 REV 2. EI ATTACHED TO W/O 12388193 (064). 3. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600362Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 850 S-10L. REPAIRED DAMAGE AREA IAW W/S 60359 (SRM 53-20-03-2R-1 REV 48) AND EI T2026A53M-968 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR UIEA2026052600363Stringer · crackedCRACK DAMAGED ON THE STRINGER NEAR STA 870 S-8L REPAIRED DAMAGE AREA IAW W/S 60356 (SRM 53-20-03-2R-1 REV 48) AND EI T2026A53M-971 REV 1. JOB COMPLETED AND CONDITION CHECK NORMAL.SDR 2PIA20260526001Engine · faultedNO ABNORMALITIES WERE NOTED DURING PREFLIGHT INSPECTION. DEPARTED CRQ AND WERE CLEARED TO CLIMB TO 3,000 FEET. UPON LEVELING AT 3,000 FEET AND ACCELERATING, SHORTLY AFTER CROSSING THE COASTLINE WESTBOUND, WE FELT A NOTICEABLE THUD ACCOMPANIED BY A “RIGHT ENGINSDR SWAA2026052605816Oil System · leakingOIL QTY LO ON THE #2 ENGINE CAME ON AT FL360. OIL QUANTITY ON THE NR 2 ENGINE DECREASED TO ZERO DURING OUR DECENT INTO KRIC. OIL TEMP REMAINED BETWEEN 115 DEGREES + 122 DEGREES. OIL PRESSURE ON THE #2 %. REMOVED AND REPLACED #2 ENGINE PER MT771-00-01SDR WX0A2026052532822Unknown · odor(AIRCRAFT NOT GROUNDED) DIRTY SOCK ODOR OBSERVED THROUGHOUT CABIN DURING DESENT AND APPROACH BEGINNING AT 18,000 FEET. AIR SMS REPORT SUBMITTED. / PERFORMED RE INSPECTION OF WORK PERFORMED FROM TASK CARD A32X-21-000-001 IAW ALLEGIANT PROCEDURES. NO DISCREPANCISDR DALA2026052603153Structure · damagedDIV- FLIGHT EXPERIENCED BIRD STRIKES ON CLIMB OUT OF CPH AND DIVERTED INTO CDG AFTER WEATHER RADAR FAIL. CDG CONDUCTED BIRD STRIKE INSPECTIONS. MULTIPLE DAMAGE REPAIRS. (8361259) (AIRCRAFT GROUNDED)SDR REXA2026052600612Drag Angle · crackedLH FWD DRAG ANGLE IS CRACKED. COMPLIED WITH CRJ900 SRM REPAIR 55-31-00-201-001-A01 ON L/H FWD DRAG ANGLE.SDR AALA202605268065Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: F/A STATION 4R HAVE EMERGENCY FLASHLIGHT THAT WON'T PRESS-TO-TEST. REPLACED BATTERY PACS AT F/A STATION 4R IAW AMM 25-64-00. OPS NORMAL.SDR AALA202605265758Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: F/A STATIONS AT L3 HAVE EMERGENCY FLASHLIGHT THAT WON'T PRESS-TO-TEST. REPLACED BATTERY PACS AT F/A STATIONS 3L IAW AMM 25-64-00. OPS NORMAL.SDR HNAA2026052600435Indicator · malfunctionedFO AIRSPEED REMAINS AT ZERO DURING TAKEOFF ROLL. ON TAKEOFF ROLL SPS ADV MESSAGE ON EICAS. ABORTED TAKEOFF TWICE. PERFORMED ADC 1 AND ADC 2 LEAK CHECK IAW AMM 34-13-00-790-802-A MULTIPLE TIMES. NO DEFECTS NOTED. AIRSPEED AND ALT INDICATIONS CHECKED GOOD ON SDR HNAA2026052600434Bleed Valve · failedE1 HSV FAIL ON EICAS FACT 23MAY26 17:19 GSO. R & R NR 1 HSV IAW AMM 36-11-02. OPS AND LEAK CHECK GOOD.SDR HNAA2026052600433Aoa · abnormalSPS ADVANCED DURING TAKE-OFF ROLL AT 80KTS ON CA AIRSPEED INDICATOR, FO AIRSPEED INDICATOR SHOWED 60KTS. CHECK EICAS MESSAGE WOULD POP UP INTERMITTENTLY ON TAXI OUT. R & R #100 AOA VANE IRW AMM 27-36-01. OPS CHECK GOOD, ACFT OK FOR SERVICE.SDR HNAA2026052600432Unknown · odorBURNING ODOR/FUMES IN COCKPIT, FWD AIRCRAFT AFTER LIGHT TO MODERATE TURBULENCE. PERFORMED INSPECTION OF AIRCRAFT FOR BURNING SMELL AND FUMES IN COCKPIT/CABIN, GROUND RAN PACKS NR 1 AND NR 2 FOR POSSIBLE ODOR WITH GASPER VENTS AND RECIRC FANS NO ODOR DETECTED.