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 CALA2025082708187Frame Angle · corrodedMAIN E & E COMP LT CORROSION AT FRAME LOWER ANGLE STR 22L STA 328+7" REF AAR N/R 97525318 INSTALLED NEW CHORD P/N : 141A8240U16 AT STA 328+7 STR 22L REF SRM 51-40-02-0G-0 AND DWG # 141A8240 INSTALLED NEW CHORD P/N : 141A8240-16 AT STA 328+7 STR 22L -23L REF SSDR R61A2025082500374Retainer · corrodedDURING HEAVY CHECK FOUND CORROSION REAR FUSELAGE FR 100 INTERNAL LOWER CENTER SEAL RETAINER CORRODED. REMOVED AND REPLACED SEAL RETAINER IAW SRM 51-41-01SDR SWAA2025082200203Handle · looseCR RR R2 DOOR ASSIST HANDLE NEEDS SECURED<[01] SECURED R2 DOOR ASSIST HANDLE IAW B737-800 AMM 52-13-31;[02] SECURED R2 DOOR ASSIST HANDLE IAW B737-800 AMM 52-13-31SDR SWAA2025082100192Handle · looseL2 DOOR ASSIST HANDLE NEEDS SECURING. SECURED L2 DOOR ASSIST HANDLE IAW AMM 52-13-31.SDR SWAA2025082100198Handle · looseR1 DOOR ASSIST HANDLE NEEDS SECURING. SECURED R1 DOOR ASSIST HANDLE IAW 52-41-31-400-802, SUBTASK 52-41-31-020-008. VERIFIED SECURED R1 DOOR ASSIST HANDLE IAW 52-41-31-400-802, SUBTASK 52-41-31-020-008.SDR DALA2025081806162Steering Sys · no discrepancyCAPTAIN`S PEDAL DISCONNECT BUTTON ON NWS INOPERATIVE. T/S PER TSM 32-51-00-810-805-A. BITE TEST OF BSCU 1+2 SHOWS NO FAULTS. PERFORMED FUNCTIONAL TEST OF NWS PER AMM 32-51-00- 720-007-A. NO FAULTS FOUND. (1136541)SDR IXXA20250810041Proximity Sensor · out of limitsLEFT FORWARD EMERGENCY DOOR EICAS AND RIGHT EMERGENCY DOOR LIGHT ILLUMINATED IN CRUISE. INDICATION WHEN AWAY LATER IN FLIGHT. SYSTEM TRANSFERRED TO DEFERRAL MAINTENANCE ITEM 65130 CATEGORY C. CORRECTIVE ACTION DUE ON 20 AUGUST 2025. REMOVED AND REPLACED S193 SDR AALA202508151690Floorboard · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOORBOARD SUPPORT AT BS 540 AND RBL 2 HAS A 2 INCH CRACKED. INSTALLED NEW FLOORBOARDS. PER AARD 51-00-05.SDR AALA202508155127Floorboard · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN, FLOORBOARD SUPPORT AT BS 540 AND LBL 2 HAS A 2 INCH CRACKED. INSTALLED NEW FLOORBOARDS. PER AARD 51-00-05.SDR DALA2025081606132Wire Harness · unsecureFLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING SYSTEM LIGHT INOPERATIVE AT ROW 18 D/E/F. 18 D/E/F ESCAPE PATH MARKING LIGHT INOPERATIVE. DEFERRED PER MEL 33-50- 03A. INSPECTED AND FOUND LIGHT HARNESS UNSECURE. SECURED. HARNESS IAW AMM 33-51. OPS CHECKED GOOD.SDR NACA2025081000002Iru · failedNUMBER 1 IRU FAULT ILLUMINATED, IRU FAILED. REMOVED AND REPLACED NR 1 IRU IAW AMM 34-28-31, OPS CHECK GOOD.SDR SWAA2025081400110Skin · delaminatedLEFT TRAILING EDGE OTBD AFT FLAP HAS DELAMINATION AND DAMAGE ON I/B AFT EDGE. THE DELAMINATION AREA OF THE LOWER SKIN IS APPROX. 11.5' BY 14'. INCLUDING 5 FASTENER HOLES COMPLETELY PULLED THROUGH. THE MISSING MATERIAL TO THE LOWER SKIN IS ROUGHLY 5.5' X 2.0'. SDR SWAA2025081400262Lens · damagedAFT LAV B EMERGENCY EXIT LIGHT LENS DAMAGED. REPLACED EMERGENY EXIT LIGHT LENS PER AMM 33-51-01-960-801.SDR SWAA2025081499997Bulb · inoperativeEMERGENCY EXIT PROXIMITY LIGHT ASSEMBLIES AT LEFT AFT OVERWING ; AFT ENTRY; AND AFT SERVICE DOORS HAVE INOPERATIVE BULBS. EMERGENCY EXIT PROXIMITY LIGHT ASSEMBLIES AT LEFT AFT OVERWING AFT ENTRY AND AFT SERVICE DOORS HAVE INOPERATIVE BULBS. RELAMPED AND TESTSDR DALA2025081406100Battery Pack · inoperative(LOG 7576324) LT OVERWING EXIT EMERGENCY LIGHTS INOP. REMOVED AND REPLACED BATTERY PACK AT M1695 PER AMM 33-51. OPS CHECK GOOD.SDR DALA2025081406097Pump · odor(LOG 1136431) ELEC HYD PUMP 1 OVERHEAT WITH A BURNING ELEC ODOR IN COCKPIT. REMOVED & REPLACED #1 ELECTRIC HYD PUMP CANNON PLUG D02666 REF B737 WDM 29-34 PLUG REPLACED PER B737 SWPM CHAP 20. STEP 10. C/W 0550-9001-B737. RESEALED BONDING JUMPER ON ELECTRICAL PUSDR CALA2025081407743Duct · disconnectedUNABLE TO COOL, FLT DECK TEMP 80 TO 83, CARRIED OUT EC/RA 2125-01204. REINSTALLED INNER DUCT & LT PACK LWR RECIRC FAN CHECK VALVE INTERIM REPAIRED. FLT DECK TEMP NORMAL. INSPECTED LT ECS BAY, FOUND INNER RECIRC DUCT WAS DETACHED & FLAPPER OF THE LWR RECIRCUSDR CALA2025081407711Elec Connector · damagedROW 12C EMER PATH LIGHT-DUE TO REPEAT GRIPES OF THE LIGHT OR SHROUD ASSY COMING OFF. ON DISCOVERY THE OLD LIGHT FIXTURE HARNESS HAS NO HOOK SECURING THE CONNECTOR. NEW PART HAD HOOK FOR PROPER CONNECTION. REF AMM 33-51-18/401 CONFIG 00.SDR WX0A2025081332542Power Supply · no test(AIRCRAFT NOT GROUNDED) FAILS EPSU TEST. / REMOVED AND REPLACED EPSU REF WO528339"SDR SWAA2025081300209Flashlight · failedAFT CABIN FLASHLIGHT WON'T TEST. SECURED AFT FLASHLIGHT AS PER AMM 25-64-00.OPS CK OK.SDR SWAA2025081300157Flashlight · failedINBOARD FWD F/A FLASHLIGHT NOT TESTING. ] R & R INBD FWD FLASHLIGHT BATTERY. OPS CHECK GOOD PER AMM 25-64-00.SDR SWAA2025081300248Battery · no testAFT FA EMERGENCY FLASHLIGHT WILL NOT TEST. R & R AFT LT INBD FLASHLIGHT BATTERY. OPS OK IAW AMM 25-64-00.SDR SWAA2025081300236Flashlight · not seatedAFT EMERGENCY FLASHLIGHT WILL NOT TEST. RESEATED FLASHLIGHT OPS TEST GOOD PER AMM 25-64-00.SDR SWAA2025081300235Sign · detachedEXIT SIGN MID CABIN FELL OFF DURING DEPLANING. ATTACHED EXIT OVERHEAD SIGN COVER PER AMM 33-51-01 STEP C(4). NO DEFECT FOUND.SDR DALA2025081306043Light · brokenSEAT MOUNTED EMER LIGHT AT PAX SEAT 25C BROKEN. RPLCD SEAT MOUNTED EMERG LIGHT REG B757 AMM 33-52.SDR CALA2025081307697Circuit Card · faultyWAI VALVE R EICAS STATUS RIGHT WING ANTI-ICE (WAI) VALVE FAILURE. DB ACIPS CONTROL CARD, CENTER (WAI CARD) REPLACED ACIPS P84A7 CARD IAW AMM 30-11-02 AS PER FIM TASK 30-11-811. PERFORMED SUCCESSFUL REPAIR CONFIRMATION IAW FIM 30-11-811 (G), STATUS MSG EXTINGUISDR CALA2025081307696Helicoil · damagedAFT CARGO DOOR LATCHOPENED DURING FLT PERFORMED TSM 32-31-00-810-886-A, AFT CARGO DOOR INDICATION PROXIMITY SWITCH TGT POS FAULT. WHILE PERFORMING OPERATIONAL CHECK OF THE AFT CARGO COMPARTMENT DOOR. FOUND HANDLE MECHANISM BEARING LOOSE, MISSING HARDWARE. MAKISDR CALA2025081307673Slide · no discrepancyEXESS SLIDE MATERIAL ON DOOR 1R DOOR 1R SLIDE PACK GIRT MATERIAL DOES NOT APPEAR TO BE EXCESSIVE. VERIFIED GIRT HOOK AND LOOP ATTACHED TO BUSTLE, ESCAPE SLIDE PACK IN SERVICEABLE CONDITION PER AMM 25-66-01.SDR CALA2025081307672Cover · looseCOVER OVER SLIDE AT DOOR 2R LOOSE DOOR 2R SLIDE COVER IS SECURE PER AMM 25-66-01 INSTALLATION INSTRUCTIONS.SDR CALA2025081307671Bracket · damagedFA REPORTS DOOR 2L ESCAPE SLIDE SKIRT BRACKET DAMAGED. R&R AFT GIRT BAR RELEASE STOP ASSY AND RETAPED AS REQ. IAW AMM 25-66-01-000-804.SDR CALA2025081307670Slide · no discrepancyDOOR 2L SLIDE PRESSURE SLIDE PRESSURE READING HIGH. VERIFIED 3L SLIDE PRESSURE IN THE GREEN, OK FOR SVC.SDR CALA2025081307669Slide · dislodgedBOTTOM OF L2 ESCAPE SLIDE CATCHES ON DOOR FRAME. REMOVED L2 DOOR EMERGENCY SLIDE REF AMM 25-66-01-000-801. REPACKED L2 DOOR EMERGENCY ESCAPE SLIDE REF AMM 25-66-01-000-802 REQUEST INSTALL OF L2 DOOR EMERGENCY SLIDE. INSTALLED L2 DOOR EMERGENCY ESCAPE SLIDE ISDR AALA202508130775Drive Assy · faultyAIRCRAFT WAS GROUNDED: GRINDING NOISE HEARD FROM RADOME AREA FOLLOWED BY WEATHER RADARSYS L+R FAULT. DECESION MADE TO RETURN TO PHL, EMERGENCY DECLARED AND AIRCRAFT LANDED OVERWEIGHT WITHOUT INCIDENT. MAINTENANCE NEW RADAR DRIVE UNIT INSTALLED PER AMM B787-A-3SDR AALA202508132979Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN TRANSITION PANEL ATTACH CLIP AT BS 500I, S26L. REPLACED CLIP PER AARD 51-00-05-1.SDR NACA2025081000001Pump · warning messageLEFT FORWARD FUEL PUMP CAME ON IN DESCENT. PERFORMED OPS TEST OF ENGINE FUEL FEED SYSTEM IAW AMM 28-22-00, OPS CHECKED GOOD.SDR ASAA2025081060026Lens · missingEXIT ROW LIGHT COVER AT PAX SEAT 16F IS MISSING. GROUNDED - YES. INSTALLED EXIT SIGN LENS COVER AT SEAT 16F REF AMM 33-51-01. OPS CHK GOOD.SDR ASAA2025081060006Sign · brokenEMERGENCY EXIT INFO LIGHT COVER AT 16F NEAR FLOOR BROKEN OFF. GROUNDED - YES. DURING INSTALL OF NEW COVER, FOUND LIGHT ASSEMBLY DAMAGED AS WELL. REPLACED EXIT SIGN LIGHT ASSY PER AMM 33-51-01. OPS CHECK GOOD.SDR MASA2025081400068Battery · faultedEMER LIGHTS BATT FAULT EICAS MSG - REMOVED AND REPLACED FWD LH SIDE EMER BATTERY. OPS CK GOOD.SDR DALA2025081206019Girt Bar · fodSHIP 3315 4L GIRT BAR BINDING. CORRECTIVE ACTION: REMOVED DEBRIS FROM GIRT BAR AND LUBED LINKAGES. OPS CHECK GOOD. (7065916)SDR DALA2025081206015Door · unsecureSHIP 3438 PSU DOOR AT SEAT 43AB IN NOT FULLY LATCHED. CORRECTIVE ACTION: REPLACED EMERGENCY OXYGEN CONTAINER PER A330 AMM 35-21-41 AND 35- 21-42. OPERATIONAL TEST OK PER AMM 35-21-00. (1135688)SDR AALA202508128522Coupling · wornAIRCRAFT IN BASE MAINTENANCE: AFT CABIN FLOOR BEAM INBOARD LOWER COUPLING FASTENER HOLE WORN AT FR 66 AND -Y1732. REPLACED COUPLING PER SRM 51-72-11.SDR AALA202508129905Coupling · wornAIRCRAFT IN BASE MAINTENANCE: AFT CABIN FLOOR BEAM OUTBOARD LOWER COUPLING FASTENER HOLE WORN AT FR 66 AND -Y1732. REPLACED COUPLING PER SRM 51-72-11.SDR AALA202508121187Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR 6CBA20250810001Barrel Nut · corrodedDURING CLIMB FOR A ROUTINE FLIGHT FROM KGVL TO MYAM, THE CREW REPORTED A "CNTL" CAS MESSAGE AFTER SELECTING LANDING GEAR TO THE UP POSITION. THE CREW PERFORMED THE QRH PROCEDURE AND RECEIVED 3 GREEN DOWN-AND-LOCKED INDICATIONS AND MADE A DIVERSION TO KPDK WITSDR YENA2025081200824Pressure Switch · faultedFLT#2260, MAD-BOS. (ETOPS) "CLASS II MX MSG F/CTL ON LOWER ECAM ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY F/CTL ); IN REF TO TSM 27-92-00-810-8222-B. R&R PRESS SW-B HYD FLT CTL (FIN:10CE1) IAWSDR YENA202508120823Warning Message · illuminatedFLT#2260, MAD-BOS. (ETOPS) "CLASS II MX MSG F/CTL ON LOWER ECAM ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY F/CTL ).SDR DXTA2025081204556Spoiler Sys · faultedCRUISE FLIGHT AT FL410. FLAPS FAIL AND SPOILER FAULT CAS. PER QRH, MANUAL FCE 1 RESET WAS UNSUCCESSFUL AND MESSAGES REMAINED. DURING LANDING ROLLOUT SWPS FAULT WAS OBSERVED AND IS ASSOCIATED WITH FCE 1. ARRIVED AT AC. POWERED ON AC AND ALLOWED ALL SYSTEM BOOT SDR UIEA2025081001118Tire · failedAT LANDING, #1 TIRE BLEW. FLAT SPOT FOUND. CREW HAD AUTOBRAKE SET AT 4 MINIMUM LEVEL DUE TO NO AUTOSPOILER AND BRAKE ROD. ONCE DISENGAGED, CREW MANUAL BRAKE DID NOT EXCEED LEVEL 2. A/C TAXIED & TOWED IN WITH BLOWN TIRE. R & R #1 MWA IAW AMM 32-45-01/401 & AIPSDR YENA2025081200821Unknown · odorFLT#991, FLL-SJU. LEVEL 2 FUMES EVENT ON TAKE-OFF OUT OF FLL. PERSISTENT UNTIL THRUST REDUCTION AND THEN SLOWLY DISSIPATED. BOTH ENG'S ON APU OFF. NO FUMES WHEN APU WAS ON BLEEDS ON THE GROUND, ONLY WHEN ON ENG AT TAKEOFF. SWEET CLEANER SMELL RECOGNIZED BY MULSDR REXA2025081200799Frame · corrodedCORROSION FOUND FRAME AT FS 1015 BETWEEN STGR 21L-25R. REPAIRED FRAME AT F.S.1015 BETWEEN STGR 21L TO 25R IAW ENDEAVOR AIR EA CRJ753-19701 REV IR DATED 7/10/2025.