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 VNAA20260304005Seat Track · corrodedCORROSION ON SIDE SEAT RAIL LH (4EAS) RH (4EAS) BTW FS379.00 AND FS669 AT STGR15L AND AT STGR15R ON CABIN PAX. SIDE SEAT RAIL LH (4EAS) RH (4EAS) BTW FS379.00 AND FS669 AT STGR15L AND AT STGR15R ON CABIN PAX WERE REPLACED PER AMM 53-00-49-400-801-A12SDR VNAA20260304004Seat Track · corrodedCORROSION ON SIDE SEAT RAIL LH( 6EAS) RH (6EAS) BTW FS669.40 AND FS977 AT STGR15L AND AT STGR15R ON CABIN PAX. SIDE SEAT RAIL LH (1 EA) AND RH (1 EA) BTW FS847+6 TO FS847+20 AT STGR15L AND AT STGR15R ON CABIN PAX WERE CLEANED PER CRJ900 SRM 51-26-00-001-001-ASDR HNAA2026030200162Spar · crackedLH WING SPAR I LOWER FLANGE CRACKED AT RIB #9. PERFORMED REPAIR TO LH WING SPAR I LOWER FLANGE CRACK IAW EMB145 SRM 57-20-05RE ITEM 3, ETD2026-145-002135 AND EO1-57-26-0082.SDR SWAA2026022464636Floor Support · crackedCRACKED FLOOR SUPPORT, BS 380-400, LBL 1, WL 208. REMOVED, LOCATED, DRILLED, AND INSTALLED A NEW FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 143A5400, REV A.SDR SWAA2026022464523Seat Track · corrodedFOUND CORROSION ON TOP & IN WELL OF PASSENGER CABIN SEAT TRACK LBL 45, BS 727C+13 - 787+6, BS 807+6, BS 847+7, BS 847+8, WL 208. REMOVED THE DAMAGED SEAT TRACK AND REPLACED WITH NEW IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, & DWG 146A5300, REV-.SDR SWAA2026022464628Skin · crackedPOSSIBLE CRACK ON NR 4 SLAT NOSE SKIN AT ACTUATOR ATTACH FITTING. REPAIRED THE NR 4 SLAT NOSE SKIN IAW SRM 57-42-01-2R-8.SDR SWAA2026022364644Floorbeam · corrodedCORROSION AROUND FASTENER HOLE AT BS 986, LBL 47, WL 208. REMOVED AND REPAIRED THE DAMAGE OF THE FLOORBEAM IAW SRM 53-70-51-2R-6, REPAIR 6, ALTERNATIVE 4.SDR SWAA2026022364679Support · corrodedCORROSION AROUND FASTENER HOLE, BS 986, RBL 47, WL 208. OPEN HOLE EXIST C/T INTERCOSTAL AND FLOOR PANEL SUPPORT AT BS 986 - 1006, WL 208 - WL 202 RBL38. REMOVE DAMAGED REPLACEMENT TEE ANGLE AND INSTALLED NEW REPLACEMENT -1 REPAIR IAW SRM 51-40-02-0G-0, SRM SDR SWAA2026022364635Floor Support · crackedCRACKED FLOOR SUPPORT BS 380 - 400, RBL 39, WL 208. REMOVED, LOCATED, DRILLED, AND INSTALLED A NEW FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 143A5400, REV A.SDR SWAA2026022364666Floor Support · crackedCRACKED FLOOR SUPPORT BS 380 - 400, RBL 8, WL 208. REMOVED, LOCATED, DRILLED AND INSTALLED NEW FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 143A5400, REV A.SDR SWAA2026022364677Shield · corrodedCORROSION AFT CARGO BAY SHIELD FWD OF CARGO DOOR AROUND MULTIPLE NUT PLATE HOLES BS 767+3 - 794, RBL 22, WL 156. REMOVED AND REPLACED AFT CARGO BAY FWD SHIELD BETWEEN BS 767 - 794, RBL 22, WL 156 IAW SRM 51-40-02, & DWG 146A0081, REV-.SDR SWAA2026022364642Support · corrodedCORROSION AFT CARGO BAY LT FLOOR TO SIDEWALL SUPPORT PLATE MULTIPLE AREAS AROUND NUT PLATE HOLES BS 727B - 767, LBL 22, WL156. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT BETWEEN BS 727+4 - 847, LBL 22, WL 156 IAW SRM 51-40-02, & DWG 146A7500, REV-.SDR SWAA2026022364643Support · corrodedCORROSION AFT CARGO BAY RT FLOOR TO SIDEWALL SUPPORT PLATE HAS MULTIPLE AREAS AROUND NUT PLATE HOLES BS 727B - 767, RBL 22, WL 156. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT AT ACB BETWEEN BS 727+4 - 767, RBL 22, WL156 IAW SRM 51-40-02, DWG 146A7500, REVSDR SWAA2026022364634Floor Support · crackedCRACKED FLOOR SUPPORT BS 277 - 294, BL 0, WL 208. REMOVED, LOCATED, DRILLED, AND INSTALLED A NEW FLOOR SUPPORT IAW SRM 51-40-02, AND DWG 141A5400, REV -.SDR 2026FA0000135Control Cable · shearedUPON TAKEOFF ROLL ON RUNWAY 33 AT X04, PILOTS WENT TO APPLY BACK PRESSURE ON THE YOKE TO BEGIN ROTATION AT 80KIAS AND REPORTED LACK OF AUTHORITY / CONTROL OF THE HORIZONTAL STABILATOR AND ABORTED TAKEOFF. PILOTS TAXI'D BACK TO TAXIWAY A4 AND SQUAWKED / GROUNDESDR SCNA20260219094Rib · crackedRIGHT HORIZONTAL STAB INSPAR RIB AT HSS 92.70, FOUND INSPAR RIB STIFFENER NR 2 CRACKED. ACCOMPLISHED REPAIR AT RT HORIZONTAL STAB INSPAR RIB HSS 92.70 STIFFENER NR 2 IAW SRM 55-10-09-2R-4, FIG 202.SDR SWAA2026021764716Window Frame · crackedCRACK ON UPPER CORNER R1 WINDOW FRAME. PERFORMED A REPAIR ON THE R1 WINDOW FRAME IAW EA 26-153-00290, WIP1 - WIP5.SDR SWAA2026021364707Access Panel · damagedELONGATED HOLES ON ACCESS PANEL 561BB TRAILING EDGE, LT WING. REPAIRED THE ACCESS PANEL 561BB IAW SRM 51-70-04-2R-10, REPAIR 10.SDR SWAA2026021364708Access Panel · elongatedELONGATED HOLES ON ACCESS PANEL 661BB, RT WING. REPAIRED THE ACCESS PANEL 661BB IAW SRM 51-70-04-2R-9, REPAIR 9.SDR AALA202602092203Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 328, RBL 31. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202602097723Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN BS 328 AND BS 340 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR J7SA2026020600473Fce · faultedP TRIM NML FAIL CAS DISPLAYED. REPLACED FCE NR 2 IAW AMM 27-03-01. OPS CHECKS GOOD. NO FAULTS NOTED AT THIS TIME.SDR SWAA2026020564528Support Bracket · crackedAFT CARGO BAY FWD BULDHEAD SUPPORT BRACKET AT BS 731, BL 0, WL 160, CRACKED. REMOVED AND REPLACED BULKHEAD SUPPORT BRACKET IAW SRM 51-40-02-0G-0, AND DWG 144A9401, REV C.SDR AALA202602053471Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500F AND BS 500G AT LBL 30. REPLACED BAFFLE PER AARD 51-00-05-1.SDR AALA202602052798Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE BETWEEN BS 500G AND BS 500H AT LBL 30. REPLACED BAFFLE PER AARD 51-00-05.SDR CALA2026020413581Access Door · dentedRIGHT AFT FUSELAGE, OTBD SIDE OF THE APU FIRE BOTTLE ACCESS DOOR HAS ONE DENT. ACCOMPLISHED REPAIR IAW ECRA 5380-01438 AND EA 757-5380-13-A4248 WITHOUT DEVIATION. THIS IS A PERMANENT REPAIR WITHOUT LIMITATIONS.SDR CALA2026020213481Fuel Cap · missingBEFORE FURTHER FLIGHT AN SDR REPORT MUST BE FILED FOR MISSIN FUEL CAP SDR FILE REFER LP 7725293SDR DALA2026013000732Battery Pack · inoperativeFOUR WALL MOUNTED EMERGENCY LIGHTS INOPERATIVE AT EXIT DOORS. R & R BOTH EPSU BATTERIES IAW AMM 33-51. NO HELP. R & R EPSU AT 12WL NO HELP ALL 4 LIGHT ASSY'S INOP. R & R AT 16 FED OPS CHECK GOOD IAW AMM 3351. R&R LIGHTS AT 16A, 15A & 15F. LIGHTS OPS CHECKED SDR DALA2026013000728Fitting · out of limitsTIME LIMITED REPAIR ERA 596680-14AD REV A. CONTINUITY FITTING REPLACEMENT IS LIMITED TO 53,909 TFC. ACCOMPLISH ERA 596680-14AD SECTION III PRIOR TO 53,909 TFC. CONTACT LIAISON ENGINEERING FOR THE PERMANENT REPAIR. ASSOCIATED AA 5311-01226 ADDED FOR AC 3268 ASSDR JJBA20260130079Skin · corrodedON LT WINGLET FOUND CORRODED. ON LT WINGLET BLENDED AND FOUND OUT OF LIMIT. LT WINGLET REPAIRED.SDR DALA2026012800684Skin · crackedOPEN HOLE HFEC INSPECTION CARRIED OUT ON THE ALL FASTENER HOLES (5EA) AT THE FORWARD SERVICE DOOR CUTOUT AFT LOWER CORNER. FOUND ONE CRACK FROM THE NR 4 FASTENER HOLE. DAMAGED AREA REPAIRED IAW SRM 53-10-01. (1419957)SDR DXTA2026013006682Flap System · faultedAFTER DEPARTURE CLIMBING THROUGH 400' FLAPS REMAINED IN FLAPS 1 POSITION FOLLOWED BY FLAPS FAIL CAS MESSAGE RAN THE QRH FOLLOWED BY THE QRC. COMPLIED WITH TASK T2PL6D00DM7NZ, AFTER DEPARTURE, CLIMBING THROUGH 400' FLAPS REMAINED IN FLAPS 1 FOLLOWED BY FLAPS FSDR DXTA2026013006692Antenna · defectiveWHILE DESCENDING FROM 9000 TO 8000 THE GEAR WARNING HORN AND THE RED CAS LANDING GEAR AND RED MASTER WARNING FLASHED AND THE GEAR INDICATIONS WERE RED. THIS CONTINUED UNTIL WE WERE LEVEL AT 8000 AT WHICH POINT IT SAID "10".. FURTHER DESCENT TO 6000 IT STARTED SDR DXTA2026013006686Uplock Switch · defectiveAFTER GEAR RETRACTION THE GEAR DISAGREE R CAS MESSAGE CAME ON ALONG WITH A YELLOW X OVER THE RIGHT GEAR INDICATOR. RAN QRH AND ENDED UP BLOWING GEAR DOWN. SENT ARES DOWNLOAD FOR REVIEW. THE RESULTS SHOWED A FAILED SWITCH. WIRE HARNESS INSPECTION & WIRE CHECSDR SWAA2026012964546Lens · missingLENS MISSING FROM CEILING LIGHT AT ROW 2 EMERGENCY LIGHT. INSTALLED THE MISSING LENS COVER IAW SIP.SDR SWAA2026012964893Light · detachedLAST EMERGENCY LIGHTING STRIP ON LEFT SIDE REMOVED. APPROX 3 FEET LONG. REINSTALLED PHOTOLUMINSCENT STRIP IAW MM33-51-15SDR GTIA2026012939262Inlet · contaminatedSUSPECTED FUME EVENT 2000 FT DURING APPROACH-PERFORMED TSM 05-50-00-810-831-A. FOUND SOURCE OF ODOR TO BE TYPE 8 FOR DE-ICING FLUID. PERFORMED INSPECTION OF APU PER AMM 49-16-00-210-802. FOUND DEICING FLUID AT AFT FUSE UNDER BELLY AND APU INLET. CLEANED AREA TSDR GTIA2026012939260Flashlight Assy · inoperativeFA C FLASHLIGHT INOP ( FLASHLIGHT AND HOLDERS (FLIGHT DECK OR CABIN) )-R & R FA C FLASH LIGHT ASSY IAW AMM 33-51-00. OPS CK GOOD. THIS CLEARS DMI 6028887-1, PLACARD REMOVED. MOC NOTIFIEDSDR VNAA2026012911501Warning Message · false activationNLG STEERING INOPERATIVE IN FLIGHT ILLUMINATED. PERFORMED OPS CHECK IAW AMM 32-51-00-710-801-A01. OPS CHECKED GOOD.SDR VGCA20260126001Floor Panel · crackedCRACK IN FORWARD ELECTRONICS BAY FLOOR PANEL AT STA 193.00 LH SIDE.SDR DXTA2026012806680Gps · malfunctionedON DEPARTURE FROM DTW DURING THE INITIAL CLIMB WE EXPERIENCED GPS LOI AND GPS LOSS OF POSITION. SHORTLY THEREAFTER WE ENTERED IMC AND RECEIVED AHRS 1 AND 2 FAULT. EMERGENCY WAS DECLARED AND WE RETURNED TO DTW FOR A NORMAL LANDING. WHILE BEING VECTORED FOR THE SDR CALA2026012913429Indicator · faultedLE FLAPS TRANSIT AMBER LIGHT. SPLIT AND DISAGREE TRAILING EDGE FLAPS. ALTERNATE FLAPS EXT USED FO REPORTS THAT ON APPROACH THEY SELECTED FLAPS 1 SETTING. BEFORE GETTING TO FLAP 1, THE INDICATION SHOWED A SPLIT BETWEEN 0 & 1 (ONE NEEDLE AT 1 THE OTHER BETWEEN SDR CALA2026012913428Seal · damagedSOUNDED LIKE ELECTRICAL ARCING & STATIC SIZZLING. SPOKE WITH FLT CREW. FLIGHT CREW CONFIRMED THE INITIAL POPPING SOUND FOLLOWED SIZZLING SOUND THROUGHOUT THE ENTIRE FLIGHT AS RECORDED BY CAPTAIN. UPON INSPECTION OF CAPTAINS SIDE, FIXED WINDOW, ON EXTERIOR, FOUSDR DALA2026012900699Window Frame · damagedAD 2020-17-03 / A.A. WORKCARD 5311-01226-01. REQUESTING REPAIR DISPOSITION. REPAIR MUST BE ACCOMPLISHED PRIOR TO FURTHER FLIGHT. FLIGHT DECK, RT WINDSHIELD FRAMING LOWER CENTER POST, & RT CONTINUITY FITTING CRACKED. PERFORMED WING FRAMING MIRROR REPAIR & CONTSDR QXEA2026012800020Arming Lever · bindingFLIGHT 9740. FA REPORTS L2 DOOR ARMING MECHANISM STIFF. REMOVED FROM SERVICE. FERRIED FOR REPAIRS. PERFORMED AND CLEANING AND LUBRICATION OF THE SLIDE ARM DISARM ADJUSTMENT ROD AND VISUAL INDICATED ARMING MECHANISM CHECKS GOOD. RETURNED TO SERVICE. NO PARTS RESDR QXEA2026012800018Unknown · faultedAT FL 330, RIGHT BEFORE DESCENT, STRONG THUMPING FELT IN FLOOR. IT FELT LIKE IT WAS NEAR THE FLIGHT DECK. THIS LASTED APPROX 10 MIN. AFTER THAT THE REST OF THE DESCENT WAS NORMAL UNTIL PASSING 10,000 FT. THUMPING IN FLOOR RESTARTED FOR SEVERAL MIN. BOTH F/A'S SDR QXEA2026012800017Lock Nut · looseFA REPORTS L2 DOOR IS DIFFICULT TO DISARM. REMOVED FROM SERVICE. REMOVED AFT PASSENGER DOOR MAIN LINING IAW EMBRAER 175 MM TASK# 25-23-05-000-801-A PARAGRAPHS 6F THRU 6I. INSPECTED AND FOUND LOWER LOCK NUT OF SLIDE INDICATOR ADJUST SCREW LOOSE & ROD END MISASDR SWAA2026012864555Actuator · out of adjustSEAT 13D RECLINES INTO EXIT ROW. ADJUSTED THE ACTUATOR IAW MM S.I.P.SDR SWAA2026012864498Megaphone · no testFWD MEGAPHONE DOES NOT TEST. R & R IAW AMM 25-64-00-201.SDR SWAA2026012864552Battery · no testFORWARD GALLEY FLASHLIGHT WILL NOT TEST. R & R THE FWD GALLEY FLASHLIGHT BATTERY IAW AMM 25-64-00. OPS CHECKED GOOD.