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 AALA202509178403Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR NR 2 HINGE ARM END FITTING HAS EXCESSIVE PLAY. REPLACED HINGE ARM END FITTING PER AMM 55-16-42.SDR IPXA2025091660078Control Module · failedFOUND APU SHUTDOWN MODULE FAIL WHEN PULL THE FIRE CONTROL HANDLE ON THE APU SHUTDOWN MODULE AND PUSH AND HOLD APU DISCHARGE BUTTON NO VOLTAGE VALVE OF V1. (REPLACE) 1. I.A.W AMM 26-15-04-000-801 AND 26-15-04-400-801 REV.48. REPLACED APU FIRE SHUTDOWN MODULE,SDR IPXA2025091526093Shear Tie · crackedFRAME BASE FITTING R/H FR45 AREA 1 HAS A CRACK 1.5" LONG.SJ-30 VERIFIED REPAIR PARTS INSTALLED IAW E0-46789-JIC008 REV1(SB A300-57-6177) STEPS 51-68 COMPLETED. JOB COMPLETESDR AALA202509146633Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY PANEL LOCATED AT STA 538, LBL 10. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202509149227Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY PANEL LOCATED AT STA 538, RBL R0. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202509128488Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D ENTRY DOOR DIFFICULT TO OPEN AND CLOSE. REMOVE AND REPLACED LAVATORY-D DOOR TRIM, PER CMM 25-40-64SDR AALA202509116997Reservoir · low pressureAIRCRAFT WAS NOT GROUNDED: 2L DOOR READS CHECK SLIDE PRESSURE. MAINTENANCE REPLACED 2L DOOR SLIDE INFLATION RESERVOIR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-62-49.SDR IPXA2025090962357Profile · crackedMAIN DECK FLOOR STRUCTURE, UNDER PANEL 261PF AT FR 74 AND FR75, LT FLOOR SUPPORT HAVE 2EA CRACKS. DOT 90-095. REMOVED MAIN DECK FLOOR STRUCTURE, UNDER PANEL 261PF AT FR 74 AND FR75 L/H FLOOR SUPPORT IAW SRM 51-40-21.FABRICATED NEW Z-PROFILE, IAW GMM 09-08.INSTSDR IPXA2025090962412Profile · crackedMAIN DECK FLOOR STRUCTURE, UNDER PANEL 262PF AT FR 74 AND FR75, R/H FLOOR SUPPORT HAVE 2EA CRACKS. REMOVED Z-PROFILE AT MAIN DECK FLOOR STRUCTURE, UNDER PANEL 262PF BTW FR 74 AND FR75, IAW A300-600 SRM 51-40-21.FABRICATED NEW Z-PROFILE, IAW GMM 09-08.INSTALLESDR DALA2025091106702Oxygen Box · faultedOXYGEN PANEL MASK DEPLOYED ABOVE THE 2RC JUMPSEAT. R & R O2 MODULE CONTAINER DOOR ASSY ABOVE 2RC JUMPSEAT IN REF TO A320 CMM 35-21-74. OPS CHECK NML PER MASK DROP TEST PER A320 AMM 35-23. MEL AND PLACARD RMVD. "M" PROCEDURE RVSD. OK FOR SVC. (LP: 1176497)SDR SWIA2025091000001Wire Harness · faultedD:GEAR DISAGREE NOSE WHEEL. RAN QRH AND AFTER GEAR EXTENSION PULL, NOSE GEAR CAME DOWN AND GREEN.C: MEL 32-30-1CAT A DUE ONE FLT DAY, SMOD APROVAL FOR RTS, ODI EVENT DECLARED EMERGENCY, CAT II DOWNGRADED, GEAR DISAGREE NOSE WHEEL. RAN QRH AND AFTER GEAR EXTSDR 3EJA2025910000220Actuator · out of adjustLANDING GEAR HANDLE IN UP POSITION, LANDING GEAR INDICATES- GEAR UP, BUT THE RED GEAR UNLOCKED LIGHT REMAIN ILLUMINATED WITH AN ASSOCIATED HYDRAULIC LIGHT. FOUND THAT THE LT MAIN LANDING GEAR WAS GETTING HUNG UP JUST SHORT OF ENGAGING WITH THE UP/LOCK. FOUND SDR CALA2025090908631Floor Support · crackedFOUND CRACK ON FLOOR STRUCTURE SUPPORT AT FWD WET AREA, BTW BS 328 AND BS 344, LBL 45. REMOVED AND REPLACED DAMAGED INTERCOSTAL AT FWD WET AREA BTW BS 328 AND BS 344, LBL 45. IAW DWG 141A5410 REV U , SRM 51-40 -02-0G-0.SDR DALA2025090806617Lens · missingDOOR 1R ARMED IND LENS COVER MISSING ON P21 FAP PANEL. REPLACED 1R ARMED LENS ON FAP PANEL . MCO & PLACARD RMVD. (7622406)SDR CALA2025090808571Skin · crackedLEFT WING LOWER SKIN, STRINGER 9, OTBD MOST FASTENER CRACKED. MAJOR REPAIR, REPAIRED LT WING LOWER SKIN AT STRINGER 9 PER UAL ECRA 5730-03601 REV -.SDR CALA2025090808566Support · gougedUPON FURTHER INSPECTION AT PANEL 192DR FRAME SUPPORT 149A7177 F OUND PART TO BE BEYOND REPAIR PART REQUIRE REPLACEMENT. REMOVED AND REPLACED NEW FRAME SUPPORT UNDER PANEL 192DR IAW DRAWINGS 149A7177 REV. A AND 149A7171 REV. F, SRM 51-40-02-0G-0, 51-40-05-0G-0SDR DALA2025090806590Light · damagedROW 28DEF EMERGENCY SEAT LIGHT BOX BROKEN/INOP. C/A: TAPED BOX BACK UP TO SEAT. WILL NEED TO BE REPLACED. FWD TO MEL 33-50-03A. NO "M" PROC. MEL AND PLACARD INSTALLED. A/C OK FOR SVC. R/R EPL SHROUD ASSY AT 28DEF REF A320 CMM 25-22-53 OPS GOOD MEL PLACARD RMVDSDR QXEA2025090500301Access Panel · leakingFLIGHT 2455. FUEL ACCESS PANEL RIGHT WING SHOWS SIGNS OF LEAKING. REMOVED FROM SERVICE. INSPECTED WING FOUND NO LEAKING FUEL NO DEFECTS NOTED. COULD NOT DUPLICATE. NO PARTS REPLACED.SDR AALA202509050045Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: 2L DOOR READS CHECK SLIDE PRESSURE. (OPEN)SDR CALA2025090508525Access Panel · missingACCESS PANEL 443JL IS MISSING FROM THE INBD SIDE OF NR 2 PYLON. INSTALLED ACCESS PANEL 443JL IAW MM 54-53-01. SECURED.SDR SWAA2025090410481Hook · looseFWD ENTRY DOOR GIRT BAR HOOK LOOSE. REPLACED FASTENER IAW AMM 51-40-02.SDR SWAA2025090410245Battery Pack · dischargedAFT OVERWING EXIT LT AND RT LWR EMERGENCY SIGN LIGHT INOPERATIVE. CHARGED EMERGENCY LIGHT BATTERY PACKS OPS CHECK OK IAW AMM 33-51-06.SDR SWAA2025090410244Battery Pack · inoperativeRIGHT EMERGENCY OVERWING EXIT DOOR LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK PER AMM 33-51-06.<BR>OPS CHECK GOOD.SDR SWAA2025090410268Lamp · inoperativeRIGHT SLIDE, OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS ON THE RT FWD OVERWING EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECKED GOOD.SDR SWAA2025090410243Lamp · inoperativeAFT SERVICE DOOR OUTSIDE EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED AFT SERVICE DOOR EMERGENCY EXIT LAMP IAW AMM 33-51-04.SDR SWAA2025090410278Pump · faultedDURING CLIMB THE NUMBER 2 ENGINE WOULD MOT MAKE CLIMB POWER. AT 230 LEVEL IT RETURNED TO NORMAL INDICATIONS. R&R FUEL PUMP IAW MT 773-11-00 AND AMM 73-11-11-401-NG.SDR DXTA2025090404784Handle · malfunctionedREPEAT RIGHT UP. THE LATCHING HANDLE ON THE MAIN CABIN DOOR WILL NOT ENGAGE. THE HANDLE WILL NOT MOVE INSIDE OR OUTSIDE WHEN THE DOORS IN THE CLOSED POSITION DOOR IS CURRENTLY OPEN. CORRECTIVE ACTION: LUBED PINS AND DOUBLE CHECKED ALL HARDWARE SAFETIES. REASSESDR ABXA202509041212Battery · inoperativeDURING SERVICE CHECK FOUND FLIGHT DECK EMERGENCY LIGHT L9803 (IN CEILING, ACROSS FROM EXIT SIGN) INOP FOUND BATTERY ON PWR SUPPLY M736 FAULTY. REPLACED AND OPS CK GOOD AIW B767 AMM SUPPLEMENTAL 33-51-00 RURNED TO SERVICESDR CALA2025090408479Adiru · faultyLEFT IRS FAULT. UPDATED MAA CODE FIX USING VENDOR MAA SCREEN PLEASE CONTACT TOMC BEFORE COMMENCING ANY WORK. INTERGATED MX PAGES AND FOUND STATUS MGS "STALL WARNING SYS L". CHECKED INBOUND FAULTS, ALL FAULTS ARE NOT ACTIVE EXCEPT THE FAULT FOR STALL WARNING SYSDR CALA2025090408475Slide · partial deployPARTIAL SLIDE DEPLOYMENT. DOOR WAS OPENED FROM THE INSIDE. REMOVED ORIGINAL SLIDE ON DOOR L1 NO DAMAGE FOUND TO THE SLIDE OR COVER, REPACKED ORIGINAL SLIDE AND REINSTALLED IT ON DOOR L1 REF AMM 25-66-01.SDR CALA2025090408473Bracket · brokenPC POWER INDICATION BRACKET IS BROKEN ON SEAT 7C. WITH LIGHTS MISSING OR STOWED. OK TO APPLY NEF 2522LB SECURED IN SEAT POWER PORTS AND IN USE LIGHTS AS REQ. PLACED ON PLACARD SEAT USEABLE. INSTALLED NEW HOUSING SHROUD ASSY FOR FOR PC POWER AT SEAT 7C. LIGHTSDR CALA2025090408451Slide · no discrepancyREF ETASK CARD 25-5211-9-9001 INSTALLED 2 EACH I3 DOOR ESCAPE SLIDE PACK SAFETY PINS FOR GIRT AND INFLATION CYLINDER. REMOVED AND STOWED 2 EACH I3 DOOR ESCAPE SLIDE PACK SAFETY PINS FROM GIRT AND INFLATION CYLINDER REF ETASK CARD 25-5211-9-9001. PACK GIRT AND SDR CALA2025090408450Slide · no discrepancy2L ESCAPE SLIDE PRESS READING HIGH ON ESCAPE SLIDE, NEEDLE STILL SHOWS TO BE IN GREEN. OK FOR SVC REF 25-66-00SDR CALA2025090408449Bracket · out of adjustGIRT BAR BRACKETS ON DOOR 1L ARE LOSE ADJUSTED GIRT BAR RETAINER CLIPSAND OPS CHECK GOOD REFERENCE AMM 25-66-01.SDR CALA2025090408448Flap · exposedDOOR 1L SLIDE FLAP PROTRUDING FROM BOTTOM OF RAFT HOUSING READJUSTED SLIDE FLAP TO PREVENT FLAP FROM PROTRUDING IAW AMM 25-66-01. DOOR OPENS AND CLOSES WITH NO ISSUES AT THIS TIME.SDR CALA2025090408447Slide · no discrepancy4L DOOR SLIDE REMOVED TO FOM REF AMM 26-66-01. INSTALLED L4 DOOR SLIDE REF AMM 25-66-01/401 C/W IDT FOR SLIDE INSTALLATION AND SAFETY PIN REMOVED AND STOWED 4LSDR ASAA2025090160542Door · bindingFA REPORTS L1 DOOR DIFFICULT TO OPEN. GROUNDED - YES. PERFORMED L1 DOOR TEST REF AMM 52-11-00-700-804. NO DEFECTS NOTED AT THIS TIME. TORQUE ON HANDLE WITHIN LIMITS. CHECKED GUIDE ARM ADJUSTMENT MEASUREMENTS AND FOUND WITHIN LIMITS. REF AMM 52-11-00-820-801. LSDR ASAA2025090160529Lens · missingA/C RIGHT FWD GALLEY LOWER EXIT SIGN COVER MISSING. GROUNDED - YES. INSTALLED FWD GALLEY LOWER RH EXIT SIGN COVER AS REQUIRED. NO FURTHER DEFECTS.SDR DXTA2025090304796Door · no discrepancyMAIN CABIN DOOR REQUIRES EXCESSIVE FORCE TO CLOSE. OPENS NORMALLY. : INSPECTED DOOR WITH NO DEFECTS NOTED. FOUND DOOR TOUGH TO CLOSE INTERMITTENTLY, INSPECTED CABIN DOOR ADJUSTMENT AND VERIFIED, WITH NO CHANGES. REMOVED MAIN CABIN DOOR STAIRS AND PANEL, ADJUSTSDR DALA2025090306536Lamp · inoperative3L SLIDE ARM LIGHT NOT ILLUMINATED WHEN DOOR IS ARMED. RELAMP, ADJ. GIRT BAR MECHANISM/FLOOR FITTING. OPS CHK GOOD. I/A/W B757 AMM 52-11. (7645506)SDR DALA2025090306534Roller · out of adjustCHK L2 DOOR FOR EASE OF CLOSING. FOUND L2 DOOR HARD TO CLOSE AND DAMAGE TO FWD UPPER FITTING. ADJUSTED LATCH ROLLERS AND GUIDE ARM REF B737 AMM 52-11-04 AND R/R UPPER AND LOWER FWD LATCH CAM FITTINGS REF B757 AMM 52-11-37 OPS CHECK GOOD. (7866852)SDR YENA2025009000907Igniter · faultedFLT#1908, CDG-JFK. (ETOPS) "MX SMOKE CLASS 2 MSG IN DISPLAY ( CLASS II MAINTENANCE MESSAGES DISPLAYED ON ECAM STATUS PAGE OF ECAM SYSTEM DISPLAY 2) FAULT(S) INDICATED BY SMOKE ); ACCOMPLISHED A/C SYS RESET/TEST IAW AMM 26-16-00-810-821-A.OPS CHK GOOD.NO FAULTSSDR YENA2025009000906Unknown · odorFLT#1023, JFK-LAX. (ETOPS) "CONUS REST DUE TO ODOR EVENT. OPENSDR CALA2025090308443Wire · looseIN SEAT EMERGENCY LIGHT AT SEAT 7 C HAS WIRE LOOSE FROM CONNECTOR. LIGHT IS INOP. BOTH WIRES BROKEN FROM MOLEX CONNECTOR. SEE PIC. UPDATE: FLAGGING SDR REF ESPM 20-56-22-03 AND AMM 33-51-00 RETERMINATED WIRES. PERFORMED OPS TEST OF EMERGENCY LIGHT AT 7C. OPS SDR CALA2025090308439Battery · no testWHILE PERFORMING EMERGENCY LIGHTS TEST ON LP 6125976 FOUND SEAT ROW EMERGENCY PATH LIGHTING INOP FOR ROWS 25, 26, 29, 30, 34 AND 35. FOUND EPSU BATTERY AFT L AND EPSU BATTERY EMER L FAULT. REF TSM 33-51-00-810-802-A REPLACED 11WL AND 13WL BATTERY, REF AMM 3SDR CALA2025090308434Idg · faultedNUMBER 2 ENG GEN SOURCE OFF LIGHT ILLUMINATED. GEN 2 INDICATED 24 DC BUT NO VOLTS OR FREQ AC. DRIVE DISCONNECTED #2 IDG HAD BEEN DISCONNECTED. REMOVED LIGHT BULBS FROM #2 ENG DRIVE LIGHT AND GEN LIGHT FOR #2 ENG. FOUND #1 ENG IDG TO BE OVER SERVICED. RESERVICESDR CALA2025090308433None · noneMULTIPLE BIRDSTRIKES WINDSHIELD 10 MILES FROM THE AIRPORT. ALT 3OOO FT PERFORMED INSPECTION OF THE BIRD STRIKE IAW AMM TASK 05-51-14-200-803-A. CLEANED THE BIRD STRIKE, INSPECTED AIRCRAFT FOR DAMAGE, FOUND NO DAMAGE OR EVIDENCE OF ADDITIONAL BIRD STRIKES. COMPSDR CALA2025090308432Filter · odorMID TO AFT CABIN HAS MILD TO STRONG FOUL SMELL. REPLACE RECIRC AIR FILTERS REF IPC EQUIPMENT INSTL-CAB. AIR RECIRCULATION REFERENCE: 21-25-01-02. REMOVED AND REPLACED BOTH RECIRC AIR FILTERS PER AMM 21-25-02. PERFORMED OPS CHECK, REF AMM 21-25-02. OPS CHESDR CALA2025090308430Light · detached26C EMERGENCY EXIT LIGHT BROKEN/ DANGLING. INSTALLED NEW RACEWAY SHROUD, EPL CLOSEOUT AND LIGHT MODULE. REF IFM 25-27-46. OPS CHECK GOOD.SDR VNAA2025090311101Motor · failedHYD 3 LO PRESS, HYD PUMP 3A CAUTION. IB GNS SPLRS. ON LANDING R REV INOP CAUTION. / REMOVED AND REPLACED HYD SYS 3A ACMP IAW CRJ 900 AMM 29-12-03-000/400-801. OPS CHECK AND LEAK CHECK GOOD.