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 CALA2025073007100Light · damagedSEAT MOUNTED EMERGENCY LIGHT AT SEAT ROW 15ABC DAMAGED. FORWARD AND AFT EMERGENCY EXIT LIGHT AT SEAT 15ABC. REMOVED AND REPLACED WITH SERVICEABLE EMERGENCY EXIT LIGHTS IAW CMM 25-22-56-3450. PERFORMED EMERGENCY LIGHTS OPS TEST IAW AMM 33-51-00-710-801. OPSSDR CALA2025073007097Fuse · failedEMERGENCY LIGHT BATTERY PACK M2816 REQUIRES REPLACEMENT. SUPPORT TASK NSA EMX N/R 00154. REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK M2816 IAW AMM 33-51-06. UP TO OPS CHECK. TROUBLESHOT TO A BAD FUSE ON EMERGENCY EXIT LIGHT BATTERY PACK M2816 IAW WDSDR FDEA202507251323Floor Panel · damagedBROKEN MCC FLOOR PANEL 242SFF. MCC FLOOR PANEL 242SFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92, APR 15,2025.SDR FDEA202507251322Floor Panel · damagedBROKEN MCC FLOOR PANEL 242VFF. MCC FLOOR PANEL 242VFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4B FIG 201 SHEET 2 REV 92 APR 15,2025.SDR DALA2025073005710Lens · missingEMERGENCY LIGHT LENS COVER AT ROW 17GF MISSING. INSTALLED EMERGENCY LIGHT LENS REF B767 AMM 33-51.SDR DALA2025073005709Light · no testEMERGENCY LIGHT FROM SET 50 TO 56 INOP DURING SERVICE CHECK. REMOVED AND REPLACED POWER SUPPLY BATTERY AS PER AMM 33- 51 OPS CK GOOD.SDR DALA2025073005708Indicator · inoperativeSHIP 1200 R1 DOOR SLIDE LIGHT NOT COMING ON. SHOWS ARMED ON FA CONTROL PANEL. R & R SLIDE ARM LIGHT IAW AMM 52-73.SDR SWAA2025072995100Handle · looseFORWARD ENTRY DOOR UPPER ASSIST HANDLE LOOSE. SECURED THE DOOR UPPER ASSIST HANDLE IAW AMM 20-50-11.SDR SWAA2025072995099Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. SECURED FORWARD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR AALA202507290887Relay · faultyAIRCRAFT WAS GROUNDED: LEFT CENTER FUEL BOOST PUMP LOW PRESSURE LIGHT ON WITH PUMP ON AND FUEL IN THE CENTER. FOUND D876 CONNECTOR BAD THE D876 DISINTEGRATED UPON DEPINNING. REMOVED AND REPLACED D876 CONNECTER (AALA202507299443) AND FUEL SYSTEM MODULE P5-2 PANSDR AALA202507297757Module · faultyAIRCRAFT WAS GROUNDED: LEFT CENTER FUEL BOOST PUMP LOW PRESSURE LIGHT ON WITH PUMP ON AND FUEL IN THE CENTER. FOUND D876 CONNECTOR BAD THE D876 DISINTEGRATED UPON DEPINNING. REMOVED AND REPLACED D876 CONNECTER (AALA202507299443) AND FUEL SYSTEM MODULE P5-2 PANSDR AALA202507299443Connector · inoperativeAIRCRAFT WAS GROUNDED: LEFT CENTER FUEL BOOST PUMP LOW PRESSURE LIGHT ON WITH PUMP ON AND FUEL IN THE CENTER. FOUND D876 CONNECTOR BAD THE D876 DISINTEGRATED UPON DEPINNING. REMOVED AND REPLACED D876 CONNECTER (AALA202507299443) AND FUEL SYSTEM MODULE P5-2 PANSDR AALA202507296919Pressure Switch · low pressureAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: HYDRAULIC SYSTEM-A ELECTRIC PUMP LOW PRESSURE LIGHT CAME ON DURING TAKEOFF. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED SYSTEM-A HYDRAULIC SYSTEM EMDP PRESSURE SWITCH.SDR AALA202507291283Life Vest · openAIRCRAFT WAS NOT GROUNDED: FIRST OBSERVER LIFE VEST WAS OPENED. REPLACED FIRST OBSERVERS' LIFE VEST PER AMM 25-66-00.SDR AALA202507293882Door · out of adjustAIRCRAFT WAS NOT GROUNDED: MID CABIN LEFT LAVATORY LOCK IS DIFFICULT TO LOCK AND UNLOCK. PASSENGERS KEEP GETTING LOCKED INSIDE. MAINTENANCE ADJUSTED MID CABIN LAVATORY DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-40-00.SDR CALA2025072907055Fuel Cap · missingPDA 2 RAMP REPORTS FUEL COUPLING CAP MISSING INSTALLED NEW SERVICABLE CAP IAW AMM 28-25-41-400-007-A. CAP STILL REQUIRES PAINT STRIPE INSTALLED NEW FUEL CAP. COUPLING CAP REQUIRES PAINT MARKING IAW ECRA 2820-02404.SDR CALA2025072907051Transmitter · leakingOIL FILTER BYPASS LIGHT CAME ON AT 34000 QRH REQUIRED ENG 1 TO B E SHUTDOWN. INITIAL EVALUATION BY OCMX. ENG 1 OIL QTY 70%EEC BITE HAD NO RECENT FAULTS. NO EVIDENCE OF OIL LK OIL SERVICED TO FULL AND ENG RUN AT IDLE TO SATISFY AMM REQUIREMENT FOR ENGINE WINDMISDR CALA2025072907050Toilet · leakingFWD LAV LEAKING & POOLING ON THE FLOOR LEAK CONFIRMED, TOILET DRAINED AND IMMEDIATE CLEAN UP ACTION CAR RIED OUT. NO EVIDENCE OF LEAK COMING FROM TOP OF TANK BELOW SHROUD. SUSPECT LEAK COMING FROM AREA AROUND BOTTON OF TANK AND TO ILET TANK. LAV A FLUSH MSDR CALA2025072907023Girt Bar · no discrepancyDOOR 1R GIRT BAR FAULTY SECOND WRITE UP PERFORMED ESCAPE SLIDE PACK CHECK PER AMM TASK 25-66-01-200-802. NO FAULTS FOUND AND GIRT BAR SNAPS ON J-HOOK AND IS FIRMLY ATTACHED.SDR CALA2025072907022Warning Message · false activationDOOR FLIGHT LOCK 3R EICAS STATUS #3 RIGHT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND /FLT LK RLY/SEN SOR DISAGREEMENT. FIM TASK REF : FIM TASK REFERENCE NOT FOUND CMC MSG# 5211330. PSEU 2 (R2) WHEN ACFT ARRIVAL AMT ON BOARD CHK NO EXISTING FAULT, ONLY GOT PRESSDR CALA2025072907021Slide · unpackedDOOR 1L SLIDE MATERIAL CAME UNPACKED AGAIN UPON ARMING. TUCKED LOOSE SLIDE SKIRT BACK INTO THE CLAMSHELL ASSEMBLY IN REFERENCE WITH AMM 25-66-01-200-802.SDR FDEA202507251336Skin · delaminatedLH WING #5 SPOILER CENTER I/B & O/B HINGE ARM UPR SKIN FOUND DELAMINATION. SIZE: (1)30MM*18MM, DEPTH: 2.32MM (2) 82MM*39MM, DEPTH: 1.98MM COMPLIED WITH EA 6-5750-T0384253 REPAIRED LH WING #5 SPOILER CENTER I/B & O/B HINGE ARM UPR DELAMINATED SKIN. MAJOR RESDR FDEA202507251335Skin · delaminatedLH WING #5 SPOILER CENTER I/B & O/B HINGE ARM O/B SIDE SKIN FOUND DELAMINATION. SIZE: (1)30MM*11MM, DEPTH: 1.60MM (2)150MM*15MM, DEPTH: 1.81MM COMPLIED WITH EA 6-5750-T0384253 REPAIRED LH WING #5 SPOILER CENTER I/B & O/B HINGE ARM O/B SIDE DELAMINATED SKISDR FDEA202507251334Skin · delaminatedLH WING #4 SPOILER CENTER I/B & O/B HINGE ARM O/B SIDE SKIN FOUND DELAMINATION. SIZE: (1)40MM*16MM, DEPTH: 1.76MM (2)30MM*22MM, DEPTH: 1.83MM COMPLIED WITH EA 6-5750-T0384250 REPAIRED LH WING #4 SPOILER CENTER I/B & O/B HINGE ARM O/B SIDE DELAMINATED SKINSDR FDEA202507251333Skin · delaminatedRH WING #3 SPOILER CENTER O/B HINGE ARM O/B SIDE SKIN FOUND DELAMINATION. SIZE: 50MM*15MM, DEPTH: 1.80MM COMPLIED WITH EA 6-5750-T0384249 REPAIRED RH WING #3 SPOILER CENTER O/B HINGE ARM O/B SIDE DELAMINATED SKIN. TITLE: WING - FLIGHT SURFACES - RH #3 SPOISDR DALA2025072905675Skin · crackedSHIP 9572 INITIAL INSPECTION: CRACK ON EXTERNAL FUSELAGE SKIN STA 1076 BTW. CORRECTIVE ACTION: EXTERNAL FUSELAGE SKIN STA 1076 BTW LONG 13-14 LH WAS REPAIRED PER REPAIR ERA PRI 626436-14AD (1105456)SDR DALA2025072905672Bottle · low pressureSHIP 3219 L2 DOOR EMERGENCY OPERATING CYLINDER HAS LOW PRESSURE PER SVC CHECK. SERVICED L2 DOOR EMERGENCY OPERATING CYLINDER PER A320 AMM 52-10. (LP: 7278942)SDR NACA2025071600001Apu · faultedAPU WILL NOT START, AUTO ABORTS AT 45%SDR AALA202507289666Sign · inoperativeAIRCRAFT IN BASE MAINTENANCE: AFT LEFT OVERWING DOOR EXIT LIGHT IS INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY EXIT LIGHT SIGN ASSEMBLY. OPERATIONAL CHECK GOOD. PER AMM 33-51-01.SDR AALA202507287108Striker · faultedAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR FOUND LOCKED ON PREFLIGHT. WOULD NOT OPEN WITH MULTIPLE CODE ENTRIES WITH GREEN LIGHT. WHEN PULLED HARD WHILE HOLDING FRAME, DOOR POPPED OPEN ON YELLOW LIGHT. REMOVED AND REPLACED ELECTRIC STRIKE ASSEMBLY. PER AMM 52SDR AALA202507280099Door · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENT REPORTS LAVATORY-D DOOR DIFFICULT TO OPEN AND SHUT. REMOVED AND REPLACED THE LAVATORY-D DOOR RAIL. PER CMM 25-40-65.SDR AALA202507289418Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PATH LIGHT SEAT 20C BROKEN. REATTACHED EMERGENCY EXIT PATH LIGHT COVER AT SEAT 20C.SDR SWI2025F01062Door · warning messagePASSENGER DOOR WARNING ALONGSIDE WITH PROXY SYS FAULT 1 AT F280. INDICATION APPEARED 4 TIMES AND THEN PERSISTED. INDICATION WENT AWAY ON APPROACH AT 4000FT. MDC FAIL STATUS MESSAGE THEN CAME ON DURING TAXI (FLIGHT 6314 - FILED CLOSED)THIS DISCREPANCY WAS TRANSDR SWIA202507280005Warning Message · false activationANTI ICE DUCT WARNING MESSAGE IN CRUISE. RAN QRH MESSAGE CLEARED 1-2 MINS AFTER SELECTING WING ANTI ICE OFF. SYNOPTIC PAGE SHOWED THE RIGHT WING ANTI ICE DUCT RED. (FLIGHT 4989 - FILED CLOSED)PERFORMED OPERATIONAL CHECK OF WING A/I SYSTEM PER AMM 30-12-00 OPSDR SWAA2025072895488Pcu · faultyDURING CLIMB OUT AT 14000 AND AGAIN AT 16000 FT THE RUDDER KICKED LEFT WITHOUT PILOT INPUT. OCCURRED AGAIN AT FL370 APPROX 30 MINUTES LATER. AUTOPILOT DID NOT DISENGAGE<[01] REMOVED AND REPLACED MAIN RUDDER PCU PER AMM 27-21-91. ALL OPS CHECKS NORMAL.;[02] REMSDR SWAA2025072895216Floor Panel · separatedPART FLOOR SEPARATION AFT CARGO HOLD APPROX ONE THIRD FORWARD OF CARGO DOOR LEFT SIDE<[01] REMOVED AND REPLACED AFTER CARGO PANELS 141DW AND 142DW PER AMM 50-10-02.SDR SWAA2025072895009Attach Fitting · crackedFWD CARGO A/C MIX BAY INTERCOSTAL ATTACH FITTING CRACKED AT FWD FACE OF FLOOR BEAM AT STATION 520 CENTER. SEE PIC.<[01] LOCATED AND DRILLED NEW ?L? ANGLE AT STA 520 FLOOR BEAM USING PN: 143A5410U9 PRE FORMED MATERIAL PER SRM 51-40-05;[02] INSTALLED NEW ?L? ANGSDR AALA202507282769Connector · not seatedAIRCRAFT WAS NOT GROUNDED: DURING EMERGENCY POWER SUPPLY UNIT CIDS 1 SYSTEM TEST FOUND BATTERY/EMERGENCY POWER SUPPLY UNIT 13WL AFT LEFT FAULT MESSAGE. MAINTENANCE RESEATED CONNECTOR ON EMERGENCY POWER SUPPLY UNIT 13WL AND ACCOMPLISHED A SATISFACTORY OPERATIONSDR AALA202507283075Diaphragm · leakingAIRCRAFT WAS NOT GROUNDED: LEFT HAND FORWARD EMERGENCY EXIT DOOR 835, DOOR DAMPER AND EMERGENCY OPERATIONAL CYLINDER PRESSURE IS LOW. MAINTENANCE REPLACED DAMPER AND EMERGENCY OPERATION CYLINDER DIAPHRAGM PER AMM 52-10-00.SDR YENA2025072800780Apu · odorFLT#1700, LAX-FFL. "FLIGHT ATTENDANTS NOTICED AN ODOR IN THE AFT OF THE AIRCRAFT; COMPLIED WITH INFO NOTICE 2017-7015,SECTION B2 ID ODOR AS TYPE 1 ,APU WILL BE DEFERRED FOR FURTHER EVALUATION,DECON LEVEL "B" WAS ACCOMPLISHED PER TSM 05-50-00-810-831-A ACFT OSDR YENA2025072800775Control Unit · failedFLT#1908, CDG-JFK. (ETOPS) "FCU ONE FAULT IN FLIGHT CLEARED PER FCU COMPUTER RESET TABLE MX NOTIFIED & THEY ADVISED TO MAKE MX ENTRY; REMOVED AND REPLACED FCU PER AMM 22-81-12 OPS CHK GOOD PER AMM 22-70-00."SDR YENA2025072800774Actuator · failedFLT#2260, MAD-BOS. (ETOPS) "FAN AIR VALVE ACTUATOR REQUIRES REPLACEMENT DUE TO BROKEN FAN AIR VALVE BODY CONNECTING ROD #1 ENG; REMOVED AND REPLACED #1 ENG FAN AIR VALVE ACTUATOR IAW AMM 36-11-54. OPS CHK AND GROUND VERIFICATION OK."SDR YENA2025072800773Bleed Air Sys · faultedFLT#1023, JFK-LAX. (ETOPS) CLASS II AIR BLEED MSG LOWER ECAM ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 1) FAULT(S) INDICATED BY AIR BLEED); PERFORMED OPERATIONAL CHK OF BLEED SYSTEM WITH APU OPS CHK OK PER AMM 21-31-0SDR IXXA20250725036Warning Message · illuminatedON DESCENT AT FLIGHT LEVEL 190 EICAS MESSAGE RIGHT EMERGENCY DOOR CAME ON. WENT OUT AT ABOUT 15,000 FEET. PRESSURIZATION APPEARED NORMAL. SYSTEM DEFERRED 64622, MINIMUM EQUIPMENT LIST C. ACCOMPLISHED PROXIMITY SENSOR ELECTRONICS UNIT TEST FOR TARGETS S193 ANDSDR DALA2025072805661Frame · damagedSHIP 3415 FORWARD SIDE OF FRAME 61 IB OF 1R TOOLING DAMAGE ON FRAME STIFFENER. CORRECTIVE ACTION: REMOVED AND REPLACED BRACKET AS REQUIRED PER ERA 627461-14 REV ORIG. (1105700)SDR DALA2025072805660Frame · damagedSHIP 3415 FORWARD SIDE OF FRAME 61 AT 2L TOOLING DAMAGE ON FRAME. CORRECTIVE ACTION: REPLACED SHEAR TIE PER A330 SRM 53-11. (1105558)SDR DALA2025072805650Skin · damagedSHIP 3360 DAMAGE FOUND ON INTERNAL SIDE SKIN AT FASTENER HOLE INBOARD OF STR 3L BETWEEN FR 61 AND FR 62. CORRECTIVE ACTION: REPAIRED PER ERA 627562-14 REV O. (1105056)SDR DALA2025072805649Tee Angle · mechanic errorSHIP 3360 T-CHORD P/N: F53491904239 (ITEM 25) LOCATED AT FR 61-FR 62 BETWEEN STR 2R AND STR 3R IS MISDRILLED. CORRECTIVE ACTION: REPAIRED PER ERA 627645-14 REV O. (1105041)SDR DALA2025072805648Tee Angle · mechanic errorSHIP 3360 T-CHORD P/N: F53491904238 LOCATED AT FR 61-FR 62 BETWEEN STR 2L AND STR 3L IS MISDRILLED. CORRECTIVE ACTION: REMOVED AND REPLACED REF A330 SRM 51-42-11. (1105038)SDR DALA2025072805647Stringer Clip · damagedSHIP 3360 FRAME 63 STR 1R CLIP ASSY (PN: F5349190100700) HAS TOOLING DAMAGE AND ELONGATED HOLES. CORRECTIVE ACTION: REPAIRED PER ERA 627465-14 REV O. (1105019)