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 SWAA2025121652018Light · inoperativeEMERGENCY AISLE LIGHT AT 25DEF INOPERATIVE. REMOVED & REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-03-960-805, & PERFORMED A GOOD OPS CHECK.SDR SWAA2025121651934Handle · brokenR1 DOOR ASSIST HANDLE BROKEN. INSTALLED A SERVICEABLE ASSIST HANDLE ONTO THE R1 DOOR FROM FWD LAVATORY IAW AMM 52-11-31. OK TO CONTINUE IAW MEL 25-10-01, SP1B AUTH 297294. R&R DOOR ASSIST HANDLE PER SIP.SDR SWAA2025121652100Fastener · missingNEED TO INSTALL FASTENERS ON FWD SERVICE DOOR AFT GIRT BAR BRACKET. INSTALLED FASTENERS ON FWD SERVICE DOOR AFT GIRT BAR BRACKET IAW AMM 70-43-11.SDR SWAA2025121652139Smoke Detector · intermittentAFT LAVATORY FIRE- SMOKE WARNING SOUNDED ONCE INTERMITTENTLY ON CAPTAIN`S SIDE OF ACFT. PAX WAS IN LAVATORY BUT NO EVIDENCE OF SMOKING. R & R THE LAVATORY SMOKE DETECTOR IAW AMM 26-14-01. OPS CHKD GOOD.SDR DALA2025121609174Fuel Control · faultedMISC/DE INTO ATL DUE TO RIGHT ENGINE INDICATION FLUX. REPLACED FUEL CONTROL UNIT AND 14TH STAGE BLEED CONVERTER VALVE.SDR AALA202512161290Bottle · low pressureAIRCRAFT WAS GROUNDED: CIDS CAUTION LIGHT ILLUMINATED. MAINTENANCE FOUND L2 EMERGENCY PASSENGER DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW AND SERVICED IT PER AMM 52-10-00.SDR AALA202512168005Pouch · tornAIRCRAFT WAS GROUNDED: SEAT 10D, LIFE VEST POUCH FRAYED AND TORN. MAINTENANCE REPLACED LIFE VEST SOFT POUCH AT SEAT 10D WITH NEW FROM STOCK PER CMM 25-21-61.SDR DXTA2025121606122Uplock Switch · faultedJUST OUTSIDE THE FINAL APPROACH FIX WE PUT LANDING GEAR INTO THE DOWN POSITION AND RECEIVED THE GEAR DISAGREE RIGHT CAS MESSAGE. WE WENT AROUND AROUND, UTILIZED THE THE LANDING GEAR BLOW DOWN AS WELL AS THE LANDING GEAR HANDLE IN THE LAV PER THE QRH, GEAR DISASDR AALA202512168420Light · brokenAIRCRAFT WAS NOT GROUNDED: ROW 12CBA SEAT MOUNTED ESCAPE PATH LIGHT BROKEN. REMOVED AND REPLACED ESCAPE PATH LIGHT AT 12CBA. PER AMM 33-51-11. OPERATIONAL CHECKED GOOD.SDR AALA202512162463Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS LAVATORY-D DOOR HARD TO OPEN. LUBED DOOR.SDR AALA202512161041Sensor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENROUTE SHORTLY AFTER TRIMMING THE AIRCRAFT, THE YOKE WAS TILTED RIGHT AND REQUIRED RETRIMMING AGAIN. SHORTLY AFTER THIS THE CREW NOTICED A FLAP ASYMMETRY. FLAP HANDLE UP, FLAP INDICATOR WAS SPLIT BETWESDR DXTA2025121606116Light · missingBOTTOM RIGHT HAND EXIT SIGN ASSEMBLY IS MISSING COMPLETELY. NO SIGN OF ANY DAMAGE ON THE SURROUNDING PLASTIC. UNABLE TO TELL IF THERE IS ANY DAMAGE TO THE CONNECTING WIRES. INSTALLED REPLACEMENT FOR MISSING FORWARD ENTRY DOOR EMERGENCY EXIT INDICATOR LIGHT ASSDR KCSA2025121374Girt Bar · detachedFOUND GIRT BAR HANGING FROM L1 DOOR. REATTACHED L1 GIRT BAR, SECURED AT THIS TIME. IAW AMM 52-11-17.SDR DALA2025121609155Window Sill · damagedFOUND TOOLING MARK ON LOWER LEFT CAPTAIN WINDOW LEDGE. COMPLIED WITH ER/A 631060-14. (8159177).SDR DALA2025121609151Seat Track · corrodedSHIP 3161 CORROSION SEAT TRACK +Y765 AT FR20 FWD GALLEY AREA: CORRECTIVE ACTION: REPLACED FLOOR BEAM (SEAT TRACK) Y765 LOCATED BTW FR 12 TO FR 24 AT FWD GALLEY AREA AS PER A319 SRM 51-42-11 AND SRM 51-72-11. (1350466).SDR CALA2025121612176Girt Bar · obstructedDOOR 1R SLIDE WILL NOT ARM. REMOVED GARBAGE DEBRIS FROM BOTTOM OF DOOR OBSTRUCTING GIRT BAR ENGAGEMENT. NO DEFECT NOTED. OK TO CONTINUE.SDR CALA2025121612175Bulb · inoperativeEMERGENCY EXIT LIGHTS NOT ARM AND NR 2 TANK FWD LOW PRESS INDICATION LIGHTS HAVE ONE LIGHT BULB INOPERATIVE EACH. R & R LIGHT BULBS PER AMM33-18-00, OPS CHECKED GOOD.SDR CALA2025121612174Light · inoperativeEMERGENCY LIGHTS ROW 21 SEATS D/E/F ARE INOP PIC ADDED WINDOW LIGHT ABOVE 21F INOPERATIVE. NOT PART OF EMERGENCY LIGHTING SYSTEM. REQUEST MEL 3302B. TOMC APPROVED COMPLIED WITH MEL 3302B DDP. INOP PLACARD APPLIED. *DM* ADDED OWE LIGHT ADDED MORE TIME TO CHANGESDR CALA2025121612173Battery Pack · no testDURING OHAR EMERGENCY LIGHT TEST, LIGHTS DO NOT TURN ON. BATTERY PACK REPLACED IAW TASK 33-51-15-800-801-C5. TEST PERFORMED OK IAW TASK 33-51-15-800-801-C3.SDR CALA2025121612172Light · no testEMERGENCY LIGHTS OPERATIONAL CHECK - ROW 8DEF OVERHEAD AISLE EMERGENCY LIGHT INOP REPLACED THE LIGHT BULB. OPS CHECKED GOOD. IAW AMM 33-51-00.SDR CALA2025121612171Power Supply · faultedAFT EMERGENCY LIGHTS WOULD RANDOMLY FLICKER ON & OFF. R&E CHANGING BATTERY AND CHARGER AT THIS TIME. ACFT INBOUND CREW REPORTED THAT AFT EMERGECY LIGHT WOULD BLINK OFF & ON, & THEN BACK OFF AT ABOUT THE TIME OF DISARMING THE DOORS DID NOT SEE ANY BLINKING SDR CALA2025121612170Bulb · inoperativeTHE EMERGENCY EXIT LIGHTS NOT ARMED INDICATOR LIGHT, ONE OF THE TWO BULBS NOT WORKING. REPLACED THE BULBS. OPS CHECK GOOD. TASK 33-18-00-960-801SDR CALA2025121612164Speed Brake · faultedSPD BRAKE DO NOT ARM LIGHT ON TAKEOFF ROLL PERFORMED FIM 27-62 TASK 802. OPS CHKS GOOD AT THIS TIME. NO FAULTS NOTED AT THIS TIME.SDR CALA2025121612163Module · faultedON FINAL GOT A GEAR DISAGREE LIGHT FOR GEAR DOOR ON RT SIDE. WENT ARND & LANDED. ONLY GEAR DISGREE AMBER LIGHT ILLUMINATED. PERFORMED PSEU BITE IAW FIM 32-09 FT 804. MEMORY RECALL FOR LAST FLT LEG HAD FAULT CODES 421, 422, 423 & 424. FIM 32-09 FT 804, TABLE 1SDR AALA202512151041Flap System · splitAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENROUTE SHORTLY AFTER TRIMMING THE AIRCRAFT, THE YOKE WAS TILTED RIGHT AND REQUIRED RETRIMMING AGAIN. SHORTLY AFTER THIS THE CREW NOTICED A FLAP ASYMMETRY. FLAP HANDLE UP, FLAP INDICATOR WAS SPLIT BETWESDR SWAA2025121552653Trim Motor · inoperativeCREW REPORTS STAB TRIM INOPERATIVE, WORKS WITH AUTOPILOT. R & R STABILIZER TRIM MOTOR IAW AMM 27-41-71. TESTED GOOD IAW AMM 27-41-71-700-801.SDR DALA2025121509147Line · unsecureMOORING LINE FROM RAFT NOT SECURE AT 2L BOARDING DOOR. RESECURED & RE-ATTACHED MOORING LINE TO RAFT AS REQ. (7664640)SDR DALA2025121509146Frame · corrodedDTA MONITOR INSPECTION LOG REF ERA 631033-14 FUSELAGE, BS 1380 FRAME, INNER CHORD RBL 23 CORRODED. REF ERA 631033-14. (1350256)SDR DALA2025121509145Frame · dentedDTA MONITOR INSPECTION LOG REF ERA 630812-14 FUSELAGE FRAME BS 1480, S26L - 27L DENTED. IAW ERA 630812-14. (1350212)SDR DALA2025121509142Seat Track · damagedSECTION OF SEAT TRACK CROWN MISSING RIGHT SIDE OUTBD BS 445. REPAIRED SEAT TRACK STA 445 RBL 45.5 IAW SRM 53-00-52- 2R, PROCEDURE 1 REMOVED STREAMER. (1350055)SDR DALA2025121509141Snubber · out of toleranceL2 DOOR SNUBBER OUT OF LIMITS. SERVICEABLE SNUBBER INSTALLED ON JOB CARD 5211-6005-2L IAW B757 AMM 52- 11-10. JOB COMPLETE. (1349097)SDR DALA2025121509140Tee Angle · corrodedCORROSION ON WING TO BODY FAIRING TEE ANGLE AT BS 900, LBL 10. FWD OF PANEL 193HL. (REF. PREVIOUS REPAIR LOG PG 1416404 & ERA 583732-14) REMOVED DAMAGE ON WING TO BODY TEE ANGLE AT BS 900, LBL 10 FWD OF PNL 193HL ADDED REPAIR CHORD AND SPLICE IAW DELTA ERA #63SDR DALA2025121509139Floorbeam · corrodedCORROSION ON MAIN DECK FLOORBEAM TOP FLANGE ON BOTH UPPER AND LOWER SURFACES AT BS 1681 LBL 12. REMOVED CORROSION AT BS 1681 LBL 12 FLOORBEAM TOP FLANGE, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGE AND REPAIRED FLOORBEAM IAW SRM 53-00-51-1A-1 AND SRM 53-60-51-SDR DALA2025121509138Stringer · corrodedCORROSION ON THE LOWER SURFACE OF STR.11L, AT BS 450, LOCATED JUST ABOVE THE CABIN WINDOW. REPAIRED AREA OF CORROSION ON LOWER SURFACE OF STRINGER 11L BS 450 IAW DELTA ER/A 630629-14 TAG REMOVED. JOB COMPLETE. (1349130)SDR WX0A2025121532666Megaphone · inoperative(AIRCRAFT NOT GROUNDED) AFT MEGAPHONE INOPERATIVE. REMOVED & REPLACED AFT MEGAPHONE UNIT REF SIP. OPS CHECKED GOOD.SDR ABXA20251213338Circuit Breaker · no discrepancyA/C TAXIED OUT WITH OPEN L/B WRITE UP. MAINTENCE PREVIOUSLY PULLED CVR C/B P11/H34 TO FOM. AIRCRAFT RETURNED TO BLOCKS (BTB). MAINTENANCE RESET P11 H34 CIRCUIT BREAKER I.A.W B767 AMM 20-60-01. AIRCRAFT RETURNED TO SERVICE.SDR HNAA2025121500857Oil System · high pressureNUMBER 1 ENGINE OIL PRESS REMAINS ABOVE 119 TO 120 PSI UNTIL POWER IS REDUDCED. R & R NR 1 ENGINE IAW WORKCARD. 71-00-00.SDR CALA2025121512132Actuator · faultyLEFT PACK EICAS ON CLIMBOUT DIDNT RESET. UPON AIRCRAFT ARRIVAL FOUND LEFT RAM AIR DOOR CLOSED. PERFORMED GROUND TEST PER FIM 21-50-F1-36A-421A,GROUND TEST FAILED &. FOUND THE FOLLOWING CODES 21-61631,21-61611. SUSPECT LT CABIN AIR COMPRESSOR INLET DEFLECTORSDR CALA2025121512121Angle · crackedRH AFT TI-ANGLE IS CRACKED. REMOVED AND REPLACED TI-ANGLE AT FR42 RH STG 42RH IAW A319 SRM 5 1-72-11-911-001.SDR CALA2025121512119Skin · corrodedRIGHT WING LOWER OUTER SURFACE I/B OF WBL 658.17 HAS PEELING PAINT. ACCOMPLISHED RIGHT WING OUTER LOWER SURFACE CORROSION DISCREPANCY COMPLIANCE WITH THE REQUIREMENTS OF ESR-WI 40-13356 AND ECRA 5720-03595 WERE ACHIEVED. REPAIRED RIGHT WING O/B LOWER INSPASDR CALA2025121512117Door Frame · corrodedR2 CUTOUT STRUCTURE INNER CHORD STA 947.5-986.5 UPPER SURFACE WITH SEVERAL CORROSION AREAS. R2 DOOR CUTOUT STRUCTURE INNER CHORD FOUND CORROSION OUT OF LIMITS, INNER CHORD WAS REMOVED AND REPLACED AS PER REF. SRM 51-40-02-0G-0 AND DWG #147A8501. REMOVED ANDSDR CALA2025121512115Battery Pack · inoperativeAFT LEFT EPSU BATTERY FAULTED. REPLACED AFT LEFT EPSU BATTERY REF AMM 33-51-38. OPS CHECK GOOD REF AMM 33-51-00. NO DEFECTS NOTED.SDR CALA2025121512113Battery Pack · malfunctionedDURING 2SVC, TEST OF EMERGENCY LIGHTS AT CIDS PANEL FAILED; -EPSU BATTERY AFT L-. REPLACED AFT EPSU BATTERY. EMER LIGHTS TEST OK.SDR DALA2025121509119Battery Pack · no testFOUND LT EXTERIOR AFT OVERWING EMER EXIT LIGHT & INTERIOR LH AFT OVERWING EMER EXIT LIGHT INOP. R/R BATTERY PACK AT ROW 26 ABC AT FLOOR SIDEWALL PER 737 AMM 33-51-06. OPS TEST OK.SDR AALA202512152915Striker · inoperativeAIRCRAFT WAS GROUNDED: COCKPIT DOOR SWUNG OPEN UPON LANDING. DOOR LIGHT OPERATED NORMALLY DURING FLIGHT. MAINTENANCE REPLACED UPPER ELECTRICAL RELEASE STRIKE IAW AMM 52-51-12.SDR UIEA2025121301342Pca · faultedHYD PRESS ENG 1. FOLLOWED FIM 29-11 TASK 803, NO CMS MESSAGE FOUND. R & R HYDIM 1 PCA PER AMM 29-11-42-004-001 & IPC 29-11-42-01B. OPS CHKD GOOD.. PFMD ENG 1 IDLE RUN IAW 71-00-00, OPS CHECK GOOD. NO 30 DAY HISTORY.SDR SIMA202512150002Light Sys · faultedL1 DOOR ENTRY EMERGENCY LIGHT PARTIALLY INOP. ONLY THE HALF OF THE DEVICE LIGHTS UP WHEN ACTUATED. L1 ENTRANCE EMERGENCY LIGHT AND ALL OTHER EMERGENCY LIGHTS ARE OPERATING NORMALLY. OPC GOOD IAW AMM 33-50-00. ONE HALF OF LIGHT EMERENCY LIGHT OTHER HALF COURTSESDR SIMA20251213001Light · inoperativeRH FWD EMERGENCY PHOTOLUMINESCENT END INDICATOR NEAR FWD CLOSET IS INOP RAR RH FWD EMERGENCY PHOTOLUMINESCENT END INDICATOR IAW AMM 33-50-21/400. OPC GOODSDR YENA2025121501203A/C Pack · odorFLT#1505, EWR-FLL. BLACK MAGIC MARKER ODOR APPROX 5,000 FT DURGIN DESCENT. ODOR ISOLATION PROCEDURE APPLIED. DISSIPATED WITH PACK 1 OFF; COMPLIED WITH INFO NOTICE 2017-T015, SECTION A, ISOLATED FAULT TO TYPE 10, PER TSM 05-50-00-810-085-B / TSM 05-50-00-810-08SDR FDEA202512132249Idg · failedON TAXI IN WE GOT A LEFT GENERATOR OFF LIGHT AND L GEN EICAS MESSAGE. PERFORMED BITE CHECK ON BPCU WITH FAULTS- DP TRIP- MAIN BUS/OVERLAP ZONE AND DP TRIP- GEN/FDR & SERVICED LEFT IDG. RAN LEFT ENGINE (#500559) AND GEN LIGHT OFF CAME RIGHT AWAY. INSP