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 SWAA2026012965202Battery Pack · inoperativeRIGHT EMERGENCY SLIDE LIGHT INOPERATIVE. R & R THE POWER SUPPLY IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2026012965201Handle · looseFA REPORT AFT RT SERVICE DOOR HANDLE IS LOOSE & UP ABOUT 1 INCH IN FLT. PERFORMED AFT GALLEY SERVICE DOOR (SOFT UNLATCHING) INSPECTION AND ADJUSTED BOTTOM GATE CONTROL ROD CRANK IAW AMM 52-41-00. OPS CHECKED GOOD.SDR SWIA2026012875100Insulation · damagedBLEED DUCT WARNING AND ASSOCIATED LT BLEED DUCT CAUTION MESSAGE DURING CLIMB THROUGH FL300. RAN QRH & MESSAGE CLEARED. (FLIGHT 6281) SEE ML 1808395 FOR PREVIOUS TROUBLESHOOTING.PERFORMED AN OPS TEST OF THE AIR-CONDITIONING DISTRIBUTION SYSTEM IAW AMM 21-51-00SDR IXXA20260128008Switch · inoperativeEMERGENCY GUARD SWITCH IS NOT TURNING THE EMERGENCY LIGHTS TO ARM OR OFF WHEN ACTIVATED. ACCOMPLISHED OPERATIONAL CHECK OF EMERGENCY LIGHTS IN ACCORDANCE WITH B767 AIRCRAFT MAINTENANCE MANUAL 33-51-00, NO FAULTS NOTED.SDR AALA202601297662Roller · inoperativeAIRCRAFT IN BASE MAINTENANCE: REPEAT ITEM L2 DOOR GUST LOCK DOES NOT STAY DOWN AFTER PUSHING TO RELEASE THE DOOR. REMOVED BUSHING AND ROLLER ASSEMBLY AND REPLACED WITH NEW SERVICEABLE BUSHING (AALA202601299595) AND ROLLER (AALA202601297662) ASSEMBLY AND REINSTSDR AALA202601299595Bushing · inoperativeAIRCRAFT IN BASE MAINTENANCE: REPEAT ITEM L2 DOOR GUST LOCK DOES NOT STAY DOWN AFTER PUSHING TO RELEASE THE DOOR. REMOVED BUSHING AND ROLLER ASSEMBLY AND REPLACED WITH NEW SERVICEABLE BUSHING (AALA202601299595) AND ROLLER (AALA202601297662) ASSEMBLY AND REINSTSDR AALA202601294108Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: THE AFT LEFT INBOARD EMERGENCY FLASHLIGHT UNDER THE FLIGHT ATTENDANTS JUMP SEAT PRESS TO TEST BUTTON RESULTS IN A RED THEN GREEN FLASHING LIGHT. REPLACED FLASHLIGHT ASSEMBLY. PER AMM 25-64-00-200-802, OPS CHECK GOOD.SDR AALA202601295864Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT DOOR 3L (JUMPSEAT) NEEDS TO BE REPLACED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202601291182Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR PANEL AT SEAT ROW 30D IS DELAMINATED. REMOVED AND REPLACED CABIN FLOOR PANEL AT SEAT ROW 30D. PER BOEING AMM B787-A-53-01-01-02A-520A-A/720A-A.SDR AALA202601293346Unknown · odorAIRCRAFT WAS GROUNDED: DURING DESCENT LEVELING AT FL290 WITH THROTTLE ADVANCED ON THE FLIGHT DECK THERE WAS A CABIN FUME SMELL NOTICED BY ALL CREW MEMBERS. SEEMED MORE PREDOMINATE ON FLIGHT DECK. IT SMELLED LIKE OIL. FLIGHT CREW HAD TO PUT ON OXYGEN MASKS. PESDR FDEA202601280097Crossbeam · misrepairedEXISTING REPAIR ON MDCC CROSSBEAM LOWER FLANGE AT FR60 BETWEEN -Y1456 AND -Y1959 REQUIRES EVALUATION FOR CONFORMITY THE EXISTING REPAIR ON MDCC CROSSBEAM LOWER FLANGE AT FR60 BETWEEN -Y1456 AND - Y1959. NO RECORD FOUND. REMOVED THE EXISTING REPAIR AND RE-RESDR FDEA202601280096Floorboard · dentedFLOORBOARD 242VFF IS DAMAGED VFF SHOULD BE 242UFF. FABRICATED FLOOR PANEL 242UFF (MPN: 145T5874-34) AT STA 980.95 - STA1114.82, RBL 54.75 - RBL 74.25 IN REF TO BOEING DRAWING 145T5874-34., AND SR67-53-009. SEE JPF FOR ALL THE WORK PERFORMED. THIS IS A MAJORSDR FDEA202601280095Skin · dentedUPPER FUSELAGE BETWEEN BS 1941 AND 1963.8 TWO DENTS, APPLIED PERMANENT REPAIR AT UPPER FUSELAGE BETWEEN BS 1941 AND 1963.8 IAW SRM 53-80-01-1A, FIG 101, SHEET 2, NOTE C, & SRM 51-70-10-2R.SDR FDEA202601280094Seat Track · corrodedMAIN DECK SEAT TRACK LBL 58.00 FROM BS 1180 TO 900 MULTIPLES SPOTS CORRODED. REMOVED SEAT TRACK SECTION MAIN DECK STA 900 TO 1180 LBL 58.00 IAW B757 SRM 51-40-02-0G TRIMMED, LOCATED AND DRILLED NEW SEAT TRACK IAW B757 SRM 51-40-02-0G AND BOEING DWG # 657NSDR FDEA202601280093Seat Track · corrodedMAIN CARGO COMPARTMENT BETWEEN BS 1280 AND 1320 RBL 45.50 SEAT TRACK WITH CORROSION. REMOVED AND REPLACED SEAT TRACK MAIN CARGO COMPARTMENT BETWEEN BS 1280-1320 RBL 45.50 IAW B757 SRM 51-40-02-0G BOEING DWG 657N3318 REV - BOEING DWG PL 657N3318 REV BSDR FDEA202601280092Seat Track · corrodedMAIN DECK SEAT TRACK RBL 45 BTW BS 1180 TO 1200 CORRODED. REMOVED SEAT TRACK MAIN DECK RBL 45 BETWEEN STA 1180 TO 1280 IAW B757 SRM 51-40-02-0G TRIMMED, LOCATED AND DRILLED NEW SEAT TRACK SECTION IAW B757 SRM 51-40-02-0G AND BOEING DWG # 146N5130 REV J INSDR FDEA202601280091Seat Track · corrodedMAIN DECK SEAT TRACK RBL 58.00 BTW STA 900 TO STA 1180 MULTIPLES SPOTS WITH CORROSION.SDR DALA2026012900711Oxygen Mask · unwanted deployOXYGEN PANEL MASK DEPLOYED LOCATION 4L. RESECURED 4L JUMPSEAT O2 MASK CONTAINER REF A330 AMM 35-21. OK FOR SERVICE. (1424393)SDR REXA2026012900027Battery Pack · inoperativeLT & RT AFT OVERWING EMERGENCY LIGHTS INOPERATIVE. R & R BATTERY AT BATTERY CHARGER PS43 IAW AMM 33-51-17. OPS CHECKED GOOD. OK FOR SERVICE.SDR N6WA2026012901Filter · odorACIDIC SMOKE ODOR IN CABIN AFTER DEICE-RTG. R & R RT & LT RECIRCULATION FAN FILTERS IAW AMM 21-22-21. OPS CHECKED GOOD. NO SMOKE DETECTED.SDR YENA2026012900091Warning Message · false activationFLT 32, AMS -BOS (ETOPS). ENG 2 OIL CHIP DETECTED ECAM MSG.; PER TSM 79-35-00-810-808A INSPECTED ENG 2 CHIP DETECTORS WITH NO FINDINGS. 5 MIN IDLE RUN C/W NO ECAM FAULTS.SDR YENA2026012900090A/C Pack · odorFLT 1691, JFK-LIR. DIRTY SOCK ODOR NOTED DURING DESCENT ON PREVIOUS FLIGHT. FA REPORTED SMELL IN CABIN. UPON ENTERING AIRCRAFT, SMELLED SIMILAR ODOR. ISOLATED BLEED L AND PACK L. ODOR DISSIPATED. (SUPPLEMENTAL INFORMATION TO FOLLOW).SDR HNAA2026012900096Actuator · failedSPOILER FAIL AT FL240 AT 310KNTS WITH SPOILER INDICATING OPEN ON EICAS. CREW REPORTED NO CONTROL PROBLEMS WHEN SPOILERS INDICATED OPEN. FOLLOWED QRH AND PULLED C/BS AS REQ. INSTALLED LT INBD SPOILER ACTUATOR IAW AMM 27-62-01 OPS AND LEAK CHECKED GOOD.SDR YENA2026012900089Unknown · odorFLT 583, KJF-MCO. FLIGHT ATTENDANTS REPORTED A CABON ODOR JUST BEFORE TOUCH DOWN. THEY REPORTED THE ODOR LASTED APPROXIMATELY TEN SECONDS.; COMPLIED WITH INFORMATION NOTICE 2017-T015, STEP 1, ISOLATED FAULT TO TYPE 10, AMBIENT AIR & RAN PACKS AND NO FAULTS SDR HNAA2026012900095Fan · odorBURNING SMELL WITH PACK 2 SELECTED. INSPECECTED AND FOUND PACK 2 RUNNING FINE WITHOUT SMELL. FOUND GASPER FAN TO BE CAUSE OF BURNING SMELL. SEE SEQ 3 FOR NEW WRITEUP. ALSO R/RD ROW 12A BALLAST IAW AMM 33-21-05.A/C OK FOR SERVICE. RAN PACKS FOR 30 MIN NO SMESDR YENA2026012900087None · noneFLT 851, BOS-MCO. INFLIGHT REPOERTED A CHAMICAL ODOR WAS BURNING EYES, PILOTS DID NOT PERCEIVE ANY ODOR. ODOR WAS STRONGER IN THE FRONT OF THE AIRCRAFT AND DISSIPATED WITH THE PACK OFF.; COMPLIED WITH INFORMATION NOTICE 2017-T015 STEP 1 ISOLATED FAULT TO TYSDR YENA2026012900086Unknown · odorFLT 866, FLL-BUF. RECEIVED REPORT FROM NR 1 FA SHE SMELLED BURNT PLASTIC IN FWD GALLEY AND A CHEMICAL SMELL FROM THE AFT GALLEY. THE #1 REPORTED IT TO THE PREVIOUS PILOTS. NO ENTRY IN THE LOG BOOK WAS MADE FROM THE PREVIOUS CREW.; ACCOMPLISHED TSM: 05-50-00-8SDR HNAA2026012900094Valve · faultedRAM AIR VALVE FAIL EICAS MESSAGE INFLIGHT. MESSAGE CLEARED DURING TAXI. NO RELEVANT CMC MESSAGES NOTED. PERFORMED OPS CHECK OF RAM AIR VALVES IRT AMM 21-25-01. OPS GOOD. T/S PER FIM TASK 21-25-00-810-801-A, BLOCK 1, 2, 3, 4, 22. R/R PACK 1 VALVE IAW AMM 21-5SDR SIMA20260128001Actuator · trippedFLAP FAIL EICAS INDICATION ON DEPARTURE DECLARED EMERGENCY LANDED SLATS 3/FLAPS0 NOT OVER WT NO LANDING ISSUES NOT OVER WT FLAPS FOUND AT NORMAL ZERO POSITION, PER CREW FLAP FAIL AT RETRACTION. CMC = R OUTBD FLAP ACTUATOR DISCONNECTED RESET INHIBITS AND FLAPSSDR YENA2026012900084Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EMERGENCY EXIT DOOR 843 INSIDE OF INNER FRAME SEGMENT 1 IN PASSENGER CABIN (CRACK L:0.45"); REF AEROMAN WO 2025 415/1 NR 2025-750909; REMOVED AND REPLACED FRAME SEGMENTS ON EMERGENCY EXIT DOOR 843, IAW EC A320-52-1SDR YENA2026012900083Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EXIT DOOR 834 INSIDE OF INNER FRAME SEGMENT 1 IN PASSENGER CABIN ( CRACK L= 0.590"); REF AEROMAN WO 2025 415/1 NR 2025-750908; REMOVED AND REPLACED FRAME SEGMENTS ON THE EMERGENCY DOOR 834 IAW A320-52-1144 AND SRMSDR YENA2026012900082Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON EMERGENCY EXIT DOOR 844 INSIDE OF THE INNER FRAME SEGMENT 1 IN PASSENGER CABIN (CRACK L:0.650 INCH); REF AEROMAN WO 2025 415/1 NR 2025-750907; REMOVED AND REPLACED FRAME SEGMENTS ON THE EMERGENCY EXIT DOOR 844 IAW SDR YENA2026012900081Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER INB HOLE OF DOOR STOP FITTING Ñ1 FR 68 LH. CRACK DIRECTION 7 AND 12 OCLOCK LOOKING AFT. CRACK D= 0.170 INCH; (RESOLVED ON W/O: 1427178 TASKCARD: NR-00041) REF AEROMAN WO 2025 415/1 NR 2025-762622, PERFOSDR YENA2026012900080Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER IB HOLE OF DOOR STOP FITTING N2 FR 66 LH CRACK DIRECTION 7 OCLOCK LOOKING FWD CRACK D=0.170 INCH; REF AEROMAN WO 2025 415/1 NR 2025-762623 PERFORMED PERMANANT REPAIR LOC ON LWR IB HOLE OF DOOR STOP FITTSDR YENA2026012900079Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LWR IB HOLE OF DOOR STOP FITTING N1 FR68 CRACK DIRECTION 1 AND 7 OCLOCK LOOKING AFT CRACK D=0.170 INCH; REF AEROMAN WO 2025 415/1 NR 2025-762624 PERFORMED PERMANENT REPAIR LOC ON LWR IB HOLE DOOR STOP FITTINGSDR DXTA2026012906709Handle · bindingMAIN CABIN DOOR HANDLE WILL NOT MOVE AFTER CLOSING DOOR. WE ARRIVED TO THIS AIRCRAFT AFTER OT WAS IN MAINTENANCE. WHEN CLOSING THE DOOR FROM THE INSIDE, THE HANDLE WOULD NOT MOVE. UPON FURTHER INSPECTION OF THE DOOR PINS, WE NOTICED A LOWER AFT PIN IS MISALIGNSDR DALA2026012900710Floor Support · corrodedCORRODED FLOOR SUPPORT FR 16 & FR 20, Y 254 FWD GALLEY AREA. REPLACED THE FLOOR SUPPORT Y254 BTWN FRS 12 - 24 IAW SRM 51-72-11, SRM 51-42-11, & DWG D53112816 ISSUE G00, DWG D53135202 & DWG D5311092. MEASUREMENT OF CORROSION: P.1 L= 0.720 IN; W= 0.336 IN; SDR DALA2026012900709Support · corrodedCORRODED LOWER SILL, FR 68 RT AT AFT GALLEY AREA. PERFORMED REPAIR INSTRUCTIONS ON LOWER SILL LOCATED AT FR 68 RT IAW SRM 53-41-14-300-001; PARAGRAPH 2.A; FIGURE 001; PRINCIPLE 7. MEASUREMENT OF REWORK ARE L = 6.589 IN, W= 1.481 IN. (LP: 1424365)SDR CALA2026012913426Skin · gougedRAMP REPORTED GOUGE ON FUSELAGE BY AFT SERVICE DOOR DOOR 2L, INSPECTED GOUGE AND DENT IAW SRM 51-10-02 . GOUGE AND DENT OUT OF LIMITS IAW SRM 53-00-1-1A-1. ACCOMPLISHED STEPS 4A, B, ,C, AND D OF SRM 53-80-01-2R-5, REMOVED DAMAGE & FASTENERS. REPAIR AREA REQUSDR CALA2026012913425Stringer · corrodedAFT CARGO AREA, FOUND ADDITIONAL CORROSION ON STRINGER 22R, BS 887. MAJOR REPAIR. DIP LPS 7747663 & 7747714. WORK ACCOMPLISHED ON HAECO N/R 9281113.SDR CALA2026012913424Light · damagedCOACH SEAT 30F, 35F, 42F, 47F, & 48F, FOUND ESCAPE PATH LIGHT (SEAT-MOUNTED) BROKEN. REMOVED AND REPLACED ESCAPE PATH LIGHTS. LIGHT POSITIONS 30F,35F,42F,47F, & 48F IAW AMM 33-51-10-962-104. ACCOMPLISHED OPS TEST, ITEMS GOOD FOR SERVICE.SDR CALA2026012813420Wire · detachedWHILE T/S MEL 7400Q. FOUND WIRE BUNDLE BURNT ON EMERGENCY LIGHTS PANEL. MEL 7400Q RELATED TO LP 7743774, NR 2 ENG IGNITION ISSUES. REMOVED EMERGENCY LIGHTS CONTROL PANEL IAW 33-51-08 FOR AVIONICS SUPPORT. RETERMINATED PIN THREE WIRE 1003 OF CONNECTOR D838J (SDR DALA2026012800695Panel · missingCLIMBING THROUGH 10K FT, RECEIVED A DOORS FWD CARGO ECAM CABIN PRESSURE WAS NORMAL ENTIRE FLIGHT . COMPLIED WITH ECAM POST FLIGHT INSPECTION FOUND PANEL MISSING ON CARGO DOOR . MCC NOTIFIED 0455Z. FWD THE FWD CARGO DOOR ACCESS COVER PANEL 825AR TO CDL 52-00-2SDR DALA2026012800680Shear Tie · corrodedCABIN INTERIOR STRUCTURE FOUND SHEAR TIE CORROSION AT BS 1329 , S14 - 15L. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423572)SDR DALA2026012800679Shear Tie · corrodedBULK CARGO SHEAR TIE FOUND CORRODED BS 1540, S38-39R, DAMAGED AREA REPAIRED IAW SRM 53-00-07. (1423086)SDR DALA2026012800678Shear Tie · corrodedBULK CARGO SHEAR TIE FOUND CORRODED BS 1540, S38 - 39L. DAMAGED AREA REPAIRED IAW SRM 51-40-02. (1423072)SDR IPXA2026012802866Processing Unit · faultedDIVERTED, ON GEAR RETRACTION, ECAM MLG DOORS NOT CLOSED. ? (LEFT MAIN DOOR). TROUBLESHOT IAW TSM 32-61-00/101. FOUND PROXIMITY DETECTOR PROCESSING UNIT FAILING (54GB). REMOVED AND REPLACED PROXIMITY DETECTOR PROCESSING UNIT IAW AMM 32-31-71-401. SYSTEM OP CHESDR QR9R2026012800001Bolt · crackedNDI INSPECTION REVEALED HEX BOLT WAS CRACKED ON THREADS.SDR VNAA202601280032Skin · dentedDENT ON INTERNAL SKIN OF INBD FLAP LOWER SIDE FLS120.00 APPROX AT RH WING. DENT ON INTERNAL SKIN OF INBD FLAP LOWER SIDE FLS120.00 APPROX AT RH WING WAS REPAIRED PER CRJ-900 SRM 57-52-01-201-001-A01."SDR VNAA202601280031Floorbeam · crackedCRACK ON FLOOR BEAM RBL 12.0 BTW FS 221.73 TO FS 229.00 AT FWD FUSELAGE INTERNAL STRUCTURE ( FLIGHT COMPARTMENT FLOOR STRUCTURE BELOW WATER LINE 79.50). FLOOR BEAM RBL 12.0 BTW FS 221.73 TO FS 229.00 AT FWD FUSELAGE INTERNAL STRUCTURE ( FLIGHT COMPARTMENT FL