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 YENA2025081200829Fitting · not reportedDURING HEAVY MAINTENANCE: REPLACE THE CONTINUITY FITTINGS IAW EA #53-0053-25 PART# 3 AND 4 ; REF AEROMAN WO# 2025-190/1 WCC# 2025-416752 FOR WORK PERFORMED. REMOVED AND REPLACED CONTINUITY FITTINGS I.A.W. EA# 53-0035-25,(COVER PLUS REV 0), PART #3 AND PART #SDR YENA2025081200828Window Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON WINDSHIELD CENTER LOWER POST ON UPPER TENSION BOLT AREA ON LH SIDE CRACK LENGTH = 0.250 INCH APPROX; AEROMAN WO#2025-190/1 WCC# 2025-416536 FOR WORK PERFORMED; PERFORMED PERMANENT REPAIR ON FUSELAGE WINDSHIELSDR YENA2025081200827Window Frame · crackedDURING HEAVY MAINTENANCE: WINDSHIELD FRAME CENTER POST LOWER NODE AREA CRACKED. POST REPAIR INSPECTIONS OF THE MIRROR FITTINGS (TBD) AEROMAN EA 53-0371-22 REV. 0. AIRBUS RDAF 81098121/004/2022#A. AIRBUS DOSSIER 81098121. AIRBUS TD/81039011/009/2022#A. SDR DXTA2025081204539Wire Harness · damagedENERGENCY LIGHTS ARE INOPERATIVE: OVERHEAD LIGHTS OVER SEATS 3 & 7, LIGHT UNDER SEAT 3. ATTEMPTED CHARGING IAW QRH, NO IMPROVEMENT. MAIN POWER ON, LIGHT UNDER SEAT 3 WOULD ILLUMINATE WHILE 2 OVERHEAD LIGHTS REMAINED OFF. WITHOUT MAIN POWER. NONE OF THE 3 LIGSDR DALA2025081206007Control Unit · faultedATB DUE TO ENG 1 & 2 BLEED STATUS FAULT AND A COND HOT AIR FAULT. NO BLEED INDICATIONS ON ECAM. CFDS FAILURE MESSAGE INDICATED NO DATA FROM ZONE TEMP CONTROL UNIT. REPLACED 8HK ZONE TEMP CONTROL.SDR CALA2025081207644Windshield · crackedDURING BIRD STRIKE INSPECTION FOUND L1 WINDSHIELD CRACKED. REMOVED AND REPLACED THE L1 WINDSHEILD PER AMM 56-11-11-000-801 AND AMM 56-11-11-400-801. OPS CHECK COMPLETE PER AMM 30-42-31-400-801.SDR CALA2025081207643Door · openAIR RETURN PERFORMED DUE HEADSET EXTRNL DOOR LEFT OPEN FOUND EXT PWR DOOR OPEN ON ARRIVAL. INSPECTED DOOR AND FOUND NO DAMAGED. OPS CKS GOOD. REF AMMRECEPTACLE ACCESS DOOR €“ INSTALLATION REFERENCE: TASK 52-49-02-400-801.SDR CALA2025081207623Lanyard · unsecureSLIDE LIGHT FOR DOOR 4L INOPERATIVE. FOUND LANYARD HANGING DOWN AND INTERFERING WITH GIRT BAR. RESTOWED LANYARD AND ARMED SLIDE. OPS CHECK GOOD. REF AMM 25-66-01. ADD EMP:U221703SDR CALA2025081207622Handle · no discrepancyCONDENSATION LEAKING THROUGH HANDLE OF EMERGENCY EXIT AT SEAT 20 A UPON ARRIVAL TO A/C. FOUND NO SIGNS OF CONDENSATION, WATER LEAKS, OR WET SPOTS IN AREA. NO NOTED HISTORY. OK FOR SERVICE REF FIM 38-10 TASK 804SDR CALA2025081207621Slide · no discrepancyDOOR 4R SLIDE OUTSIDE GREEN BAND. INSPECTED DOOR 4 R DOOR SLIDE PER AMM 25-66-01-206-041 FOUND WITH LIMITS THE GREEN TEMP CAN GO 1/2 WIDTH OF GREEN BAND OK TO CONT.SDR CALA2025081207620Slide · no discrepancy1L SLIDE HAS EXCESS MATERIAL HANGING OUT INSPECTED THE SLIDE IAW AMM26-66-01. MAINTENANCE AND ENGINERING BULLETIN. FOUND SLIDE TO BE WITHING LIMITS.SDR CALA2025081207619Lgciu · faultedFWD CARGO DOOR OPEN ECAM ON LANDING ROLL OUT. INSTALLED INOP STICKER ADJACENT TO THE LOWER ECAM. VERIFIED THE FWD CARGO DOOR IS CLOSED AND LOCKED. PROX SW AND LGCIU IN CASE NEEDED AFTER T/S. UNABLE TO DUPLICATE THE FAULT. REPLACED LGCIU 1 AS A PRECAUTION. OSDR CALA2025081207618Light · not seatedSLIDE LIGHT FOR 4L DOOR INOPERATIVE. COMPLIED WITH MEL 2566N, PLACED INOP STICKER. VERIFIED DOOR 4L IN ARMED POSITION. RESEATED 4L DOOR LIGHT, OPS CHECK GOODSDR AALA202508125356Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND SIDE OF FUSELAGE INTERNAL SKIN, AT BOTTOM OF EXTERNAL POWER PANEL CUTOUT, AT BS 235.8 FROM S21R TO S22R. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-10-15-2R-4.SDR QXEA2025081100292Unknown · smokeFLIGHT 2305. LEFT MAIN WHEEL INBOARD RIM AREA IS PRODUCING WHITE SMOKE DURING POST FLIGHT WALK AROUND. REMOVED FROM SERVICE. PERFOREMD GVI OF AREA NO DAMAGE FOUND AND SMOKE NO LONGER PRESENT PERFOREMD OPS TEST OF BRAKES IAW AMM 32-41-00-710-801-A OPS TEST GOODSDR DALA2025081105996Floor Support · corrodedCORRODED FLOOR SUPPORT Y1292 LOCATED BETWEEN FR16 TO FR20, FWD GALLEY AREA. REPLACED FLOOR BEAM Y1292 LOC. BTW. FR12 TO FR24 AT FWD GALLEY AREA IAW SRM 51-42-11 AND SRM 51-72-11.SDR WX0A2025081132539Unknown · odorAIRCRAFT NOT GROUNDED. STRANGE SMELL NOTED DURING LANDING. SMELL VERIFIED BY GATE AGENT. COMPLIED WITH TASK CARD 21-000-002 FOR STRANGE SMELL NOTED DURING LANDING.SDR WX0A2025081132537Lens · broken(AIRCRAFT NOT GROUNDED) OVERWING (14ABC) EXIT SIGN COVER FOR EXIT LIGHT LED ASSEMBLY BROKEN. REMOVED AND REPLACED BROKEN COVER FOR LIGHT ASSY AT (14ABC), IAW AMM 33-51-13-000/400-001-A.NO DEFECTS NOTED. THIS CLEARS M313 MDDR #217727 EA 10-2025-021.SDR WX0A2025081132535Flashlight · no test(AIRCRAFT NOT GROUNDED) FA NR 4 FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FA NR 4 FLASHLIGHT BATTERY IAW AMM 25-66-00-PB 201. OPS CHECK GOOD.SDR WX0A2025081132534Megaphone · no test(AIRCRAFT NOT GROUNDED) FA REPORTS FWD MEGAPHONE DOES NOT WORK. REPLACED BATTERIES IN MEGAPHONE PER AMM 25-65-51-920-001-A.SDR WX0A2025081132533Battery · no test(AIRCRAFT NOT GROUNDED) FWD LH FA FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED BATTERY.SDR SWAA2025081100138Girt Bar · looseWHILE CLOSING L1 DOOR GIRT BAR DROPPED OUT OF HOLDER<[01] RESECURED GIRT IN HOLDER AND PERFORMED GVI OF SLIDE PACK PER AMM 25-66-01. NO DEFECTS NOTED.SDR SWIA202508110009Landing Gear · warning messageGEAR DISAGREE MESSAGE AFTER GEAR SELECTOR HANDLE SELECTED IN UP POSITION ON TAKEOFF. RAN QRH. QRH DIRECTED US TO USE THE MANUAL GEAR EXTENSION. WE ULTIMATELY GOT THEN 3 GREEN DOWN AND LOCKED INDICATIONS ON ED-1. HAD A NORMAL, UNEVENTFUL LANDING AT ORD. (FLIGHSDR GTIA2025081139043Power Supply · faultedPERFORMED EPSU SYS TEST FOR SERVICE CHECK, FOUND 12WL FAULTY. PRECAUTIONARY R&R OF 12WL EPSU IAW AMM 33-51-38.SDR GTIA2025081139042Megaphone · inoperativeFWD MEGAPHONE IS INOPERATIVE. INSTALLED NEW FWD MEGAPHONE IAW AMM 25-23-00.SDR AALA202508110399Indicator · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING THE APPROACH THE FLAPS STOPPED MOVING WITH THE LEFT FLAP AT ABOUT 20 AND RIGHT FLAP AT 15. NO WARNINGS AND CAUTIONS WERE PRESENT IN THE COCKPIT. AIRCRAFT COMMENCED A GO-AROUND AND LANDED SAFELY ATSDR AALA202508118950Transmitter · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING THE APPROACH THE FLAPS STOPPED MOVING WITH THE LEFT FLAP AT ABOUT 20 AND RIGHT FLAP AT 15. NO WARNINGS AND CAUTIONS WERE PRESENT IN THE COCKPIT. AIRCRAFT COMMENCED A GO-AROUND AND LANDED SAFELY ATSDR AALA202508117877Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: LOWER ILLUMINATED EXIT SIGN BETWEEN RIGHT HAND ROW EXITS IS INOPERATIVE. FOUND LOWER ILLUMINATED EXIT SIGN BETWEEN RIGHT HAND ROW EXITS L1188 WIRES IMPROPERLY CONNECTED. RECONNECTED L1188 AND OPERATIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202508111645Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS THAT LAVATORY-D DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBRICATED LAVATORY-D DOOR. OPERATIONALCHECK GOOD. PER AMM 25-41-00.SDR AALA202508110737Locking Cam · brokenAIRCRAFT WAS NOT GROUNDED: RIGHT AFT GIRT BAR STICKS. FOUND A BROKEN GIRT BAR RELEASE STOP ASSEMBLY ON RIGHT HAND AFT GIRT BAR. REMOVE AND REPLACED GIRT BAR STOP ASSEMBLY. PER AMM 25-66-01.SDR AALA202508112442Coffeemaker · odorAIRCRAFT WAS NOT GROUNDED: NUMBER 4 COFFEE MAKER EMIT AN ELECTRICAL BURNING SMELL. REMOVED AND REPLACED NUMBER 4 COFFEE MAKER. PER CMM 25-23-28. OPERATIONAL CHECK GOOD.SDR IXXA20250809040Governor · inoperativeLEFT ENGINE TAKING APPROXIMATELY 30 SECONDS TO SHUTDOWN AFTER FUEL CONTROL SHUTOFF. IN ACCORDANCE WITH B767 FIM 73-21 FAULT TREE 807 REMOVED AND REPLACED FUEL FLOW GOVERNOR IN ACCORDANCE WITH B757 AMM 73-21-01 AND FUEL FLOW GOVERNOR SOLENOID VALVE IN ACCORDASDR AALA202508111827Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508112839Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508116438Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508115007Hydraulic System · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MIA DUE TO THE THE FLIGHT CREW REPORTING A GREEN HYDRAULIC SYSTEM FAILURE CLIMBING THROUGH 8000FT. FLIGHT CREW ACCOMPLISHED THE ECAM AND QRH PROCEDURES ALONG WITH A MANUAL GEAR EXTENSDR AALA202508117232Enclosure · dentedAIRCRAFT WAS NOT GROUNDED: R2 DOOR ESCAPE SLIDE ENCLOSURE DOOR LOWER PORTION HAS A DENT. MAINTENANCE REPAIRED THE SLIDE ENCLOSURE DOOR PER EA 367140.SDR IXXA20250809039Unknown · odorBURNING SMELL IN FLIGHT WHEN ENGINE ANTI-ICE WAS ON. ACCOMPLISHED SMOKE/FUMES IN CABIN CONDITIONAL INSPECTION PER B767 AMM 05-51-56. AFTER 30 PLUS MINTES OF DUAL ENGINE OPERATION AT IDLE NO ABNORMAL ODORS DETECTED. EXTERNAL ENGINE TUBING INSPECTION IAW AMM 75-SDR DALA2025081105982Handle · unsecureSHIP 8102 - DIV - DUE TO FORWARD CARGO DOOR CAUTION MSG FOLLOWED BY CABIN PRESSURE WARNING. EMERGENCY WAS DECLARED. CORRECTIVE ACTION: FOUND FORWARD CARGO DOOR HANDLE NOT SECURED. PERFORMED GVI NO DAMAGE NOTED. PERFORMED PRESSURIZATION CHECK, PRESSURE CHECKS GSDR DALA2025081105978Floor Support · corrodedL/H FLOOR SILL STRINGER 22 JUST AFT OF L2 DOOR SILL CORRODED ON FASTENER HOLE. BLENDED AND CHECKED LIMITS REF A220 ASRP 53-00-00-00AAA-661A-A. REMOVED .005" OF MATERIAL. NOMINAL THICKNESS IS .080" AND WITHIN LIMITS, REF A220 ASRP 53-00-00-00AAA-661A-A. (LP# 11SDR SIMA20250809001Battery · inoperativeEMERGENCY LIGHT IN THE CEILING OF FIRST CLASS NOT ILLUMINATING WHEN EMERGENCY LIGHTS ARE SET TO ON. RAR ELPU #2, OPC GOOD, IAW AMM 33-50-01SDR JJBA20250811024Connector · looseRH OVERWING EMERGENCY EXIT IDENTIFIER SIGN INOPERATIVE. UPON REMOVAL, FOUND LOOSE CONNECTION, RESECURED ELECTRICAL CONNECTIONS. OPS CHECK SATSDR JJBA20250811023Lamp · inoperativeFOUND LH EMERGENCY LIGHT ABOVE WING INOPERATIVE. REPLACED EMERGENCY LIGHT. OPS CHECK SAT.SDR DXTA2025081104545Hinge · out of adjustMAIN CABIN DOOR HAS BEEN PROGRESSIVELY GETTING DIFFICULT TO OPERATE. WHEN CLOSING, THE INTERIOR DOOR HANDLE GETS STUCK HALFWAY DOWN AND REQUIRES EXCESSIVE PRESSURE TO CONTINUE MOVING IT TO THE FULL LATCHED POSITION. WHEN OPENING THE DOOR, THE HANDLE MOVES TO SDR AALA202508117224Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 3L JUMP SEAT DOES NOT TEST PROPERLY AND SEAL BROKEN. MAINTENANCE REPLACED FLASHLIGHT AT 3L JUMP SEAT, REF AMM 33-50-00,SDR SCNA20250811314None · no discrepancyEMERGENCY RETURN OVERWEIGHT LANDING. APPROX 153K LBS. REPORTS ROUTINE LANDING, PERFORMED A/C OVERWEIGHT LANDING WALK-AROUND INSPECTION OF MLG'S, NLG, WHEEL AND TIRE ASSEMBLIES, WINGS IAW AMM 05-51-35-210-801, NO ISSUES FOUND. NO LEAKS. A/C OK FOR SERVICE.SDR SCNA20250811313Light · unsecureTHE EMERGENCY LIGHTING STRIP ON THE FLOOR IS NOT SECURED TO THE FLOOR ROW 12 & 13. RESECURED STRIP @ ROW 12 & 13 REF AMM 25-27-31. OK FOR SERVICE.SDR CALA2025081107583Indicator · faultedSTDBY ATTITUDE INDICATOR HAS FAILED REPLACED STANDBY ATTITUDE INDICATOR, OPS CHECK GOOD MM 34-22-24.APARTS USED: 31-4170-9-0001,QTY :1 ROTABLE PARTS CHG:TT # 1449521 SN OFF 2440 PN OFF 31-4170-9-0001 INDICATOR, STAN OFF 31-4170-9-0001 2440 ON 31-4170-9-0001 SDR CALA2025081107582Battery Pack · inoperativeSEAT ROWS 8-12 AND 32-38 FAIL EMERGENCY EXIT LIGHT TEST REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACKS M2503 AND M2626. OPS CHECK GOOD IAW B737 AMM 33-51-06-960-805.SDR CALA2025081107581Light · no testSEAT ROWS 8-12 AND 32-38 FAIL EMERGENCY EXIT LIGHT TEST,