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 CALA2025081807862Unknown · odorFAS REPORT STRONG ODOR AT DOOR 2R FROM 3000 FT TO LANDING, FOUND NO DISCRIPINCES. RAN APU AND PACKS FOR AN HOUR NO ODOR DETECTED.SDR CALA2025081807861Oil System · overservicedFAULT LIGHT ON DURING APU START. SECOND ATTEMPT MADE AFTER CLEARING FAULT. PERFORMED APU ECB BITE IAW FIM 49-11 TASK 875 & NOTED LOW OIL PRESSURE FLAG ON LAST 3 RUNS. REJECTED HMG MUST WORK DISREGARD PREVIOUS CALL, CONFIG ISSUE, HMG CURRENTLY FUNCTIONAL OPSSDR CALA2025081807860Warning Light · illuminatedEQUIP COOLING OVERHEAT ON DEPARTURE. STBY UNABLE TO COOL EQUIP. OVERHEAT LIGHT RETURND AFTER OVERIDE IN FLIGHT FOLLOWED FM NON-NORMALS 2.20.43 TO OVERRIDE FOR 30 MIN UTES, BACK TO AUTO OVERHEAT LIGHT FLICKERED BUT EXTINGUISHED. CREW OPTED TO DIVERT INTO DUB. ASDR AALA202508188799Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN R1 DOOR BEAM LOCATED FROM BS 300 TO BS 328. REPLACED BEAM PER CMM 52-41-05.SDR CALA2025081507842Battery · no testALL 4 EPSU BATTERIES REQUIRE REPLACEMENT. REMOVED AND REPLACED THE EPSU BATTERIES IAW AMM 33-51-38-400-002-A. OPS CHECKED GOOD.SDR CALA2025081507840Battery · inoperativeALL FWD GALLEY EMERGENCY EXIT AISLE PATH LIGHTS NOT WORKING EMERGENCY LIGHT POWERPACK REPLACED AT PLUG LOCATION M730 AS PER AMM 33-51-07/201, EMERGENCY PATHWAY LIGHTS NOW OPERATE AS NORMAL.SDR CALA2025081507839Hook And Loop · looseL2 DOOR SLIDE EXCESSIVE MATERIAL HANGING OUT. SECURED HOOK AND LOOP STRIP ON GIRT BAR.SDR CALA2025081507838Indication Sys · faultedENG 1 BLEED NOT CLOSED ECAM. CREW VERIFIED ENGINE BLEED CYCLES NORMALLY, INDICATION PROBLEM ONLY. DEFERRED, CHECKED BMC1 LAST LEG REPORT AND INDICATED DIFF-PRESS XDCR ( 18HA1 ). FOLLOWED TSM 36-11-00-810-980-A AND ACCOMPLISHED TASK 36-11-00-810-A20-A ON BMSDR CALA2025081507837D-Ring · looseL4 DOOR D-RING INACESSABLE, REATTACHED D-RING AT L4 DOOR. OPS CHECKS NORMAL AT THIS TIME. OK TO CONTINUESDR CALA2025081507836Door · no discrepancyDOOR FLIGHT LOCK 4L STATUS MESSAGE, MSG NOT ACTIVE, CYCLED DOOR OPEN AND CLOSED. PERFORMED FLT LOCK MAT TEST . TEST PASSEDSDR CALA2025081507835Cover · crackedEMERGENCY EXIT DOOR COVER 21A CRACKED AND WILL NOT STAY IN PLACE. PERFORMED INTERIM REPAIR OF THE OVERWING EXIT DOOR HANDLE COVER OVER 21A.SDR CALA2025081507834Rope · unsecureL1 DOOR ROPE HANGING FROM BOTTOM OF DOOR REINSTALLED SLIDE COVER LOWER STRAP, REF AMM 25-26-01.SDR CALA2025081507833Warning Message · false activationDOOR FLIGHT LOCK 1L EICAS STATUS L1 DOOR FLIGHT LOCK COMMAND, FLT LK RLY/SENSOR DISAGREEMENT. A INTERMITTENCE CODE: H PH. TROUBLESHOT IAW FIM 52-11 TASK 805, FOR MMSG 52-11280, FAULT NOT ACTIVE, NO MAINTENANCE REQUIRED.SDR CALA2025081507832Brace · looseFA REPORTS METAL BRACE UNDER 34D IS LOOSE. REMOVED BAGGAGE BAR FROM ROW 34DEF AND DEFERRED PER MEL 2521Y OK TO MEL. REMOVED AND ROUTED TO TERMINAL A STORES M&E 31-2526-3-0025 (139-00-293-21).SDR CALA2025081507831Slide · looseDURING WALK AROUND FOUND FWD SERVICE DOOR R1 ,SLIDE ROPE LOOSE. FWD SERVICE DOOR 1R SLIDE ROPE FIXED AND ADJUST IAW AMM 25-66-01-404-044 REV137SDR CALA2025081507830Slide · looseDOOR 2L SLIDE PACK BRACKET SCREWS ARE LOOSE INSPECTED DOOR 2L FLOOR-MOUNTED ESCAPE SLIDE BRACKET IN REFERENCE AMM TASK 25-66-02-400-801, BRACKET SECURED. OPS CHECK GOOD.SDR CALA2025081507829Cover · pulledFAS REPORT DOOR 2L SLIDE COVER HOUSING BOLT PULLING OUT. FOUND BOLT TO BE TIGHT AND SLIDEPACK SECURE. NO DEFECTS NOTEDSDR CALA2025081507828Sensor · out of adjustREPEAT LEVEL 2 CHRONIC FWD CARGO DOOR ECAM, WIRE HARNESS, 28WV, AND 30WV SENSORS HAVE BEEN REPLACED, SENSOR GAPS HAVE BEEN CHECKED SEVERAL TIMES, PROBLEM SEEMS TO HAPPEN A LOT ON TAXI WHEN A/C IS SHAKING, REF TSM 52-31-00-810-801-A. CLOSE AND LATCH THE DOOR ANSDR CALA2025081507827Lanyard · unpackedCHRONIC HISTORY OF DOOR 4-L DIFFICULT TO ARM PER CABIN CREW. LOG HISTORY SHOWS ISSUE IS CAUSED BY DOOR SLIDE LANYARD UNSECURE, HINDERING GIRT BAR MECHANISM ENGAGEMENT. . DOOR ARMED PROPERLY ON ARRIVAL WITH GOOD INDICATION. FOUND GREEN LANYARD, CARABINER UNRAVSDR CALA2025081507826Warning Light · false activationON TAKEOFF AROUND 110KTS GOT MC FWD ENTRY DOOR LIGHT.WENT OUT I N AIR DOOR HANDLE CONFIRMED DOWN. PERFORMED OP CHECK IAW AMM 52-11-00-700-801 STEP E.(1). NO DEFECTS NOTEDSDR CALA2025081507825View Port · dirtyGIRT BAR INDICATOR VIEW PORT IN 1L IS DIRTY, CLEANED VIEW PORT FOR GIRT BAR BOTH SIDES FWD AND AFT OF DOOR. CAN SEE YELLOW INDICATOR IN VIEW PORT, ALSO CLEANED DOOR 1R FWD AND AFT VIEW PORT.SDR CALA2025081507824Girt Bar · dirtyGIRT BAR INDICATOR VIEW PORTS IN 1L IS DIRTY CLEANED VIEW PORT FOR GIRT BAR BOTH SIDES FWD AND AFT. OF DOOR. CAN SEE YELLOW INDICATOR.SDR CALA2025081507823Cover · looseDOOR 2L SLIDE COVER LOOSE ADJUSTED 2L DOOR BUSSLE, INSTALLATION AND RIGGING NOT AFFECTEDSDR CALA2025081507822Ceiling Panel · no discrepancyREMOVED CEILING PANELS FROM L2 TO OVERWING EMER DOORS ROW 20 AND 21 INSTALLED CEILING PANELS FROM L2 TO OVERWING EMER DOORS ROW 20 AND 21 IAW AMM 25-22-01-404-067SDR CALA2025081507821Snubber · weakL1 DOOR SNUBBER IS WEAK, INOPERATIVE. REMOVED L1 DOOR SLIDE IAW AMM 25-66-01, REMOVED LINER IAW AMM 52-11-31, REMOVED AND INSTALLED SNUBBER IAW AMM 52-11-51, REINSTALLED DOOR LINER IAW 52-11-31 AND REINSTALLED DOOR SLIDE IAW AMM 25-66-01. SUBMITTED ESCAPE SLIDSDR CALA2025081507820Slide · abnormalR2 SERVICE DOOR , ESCAPE SLIDE BUSSEL IS STRIKING THE THRESHOLD. REQUIRES OPEN UP AND RESTOW OF SLIDE BUSSEL. REMOVED SLIDE AT THE R2 SERVICE DOOR, OPENED UP THE SLIDE PACK, RESTOWED THE SLIDE BUSSEL/GIRT, CLOSED SLIDE PACK AND RE-INSTALLED ONTO AIRCRAFT PER ASDR CALA2025081507819Door · lack of lubeDOOR 2L SLIDE WILL NOT DISARM. CREW VERIFIED FAS ABLE TO DISARM SLIDE. CHECKED GIRT FITTINGS AND LUBED ARM. NO DEFECTS NOTED IAW AMM 52-10-00. OK FOR SERVICE.SDR CALA2025081507818Slide · no discrepancyPLEASE PROVIDE DATAPLATE VISUAL FOR THE FOLLOWING PART BELOW: SLIDE, B757-200, #1 LH & RH FWD DOOR ($) LOCATED IN THE L1 POSITION. SPECIFICALLY LOOKING FOR INFORMATION REGARDING RESERVOIR AND VALVE ASSY P/N ON THIS SLIDE. PLS ACCMP AS SOON AS THE MX SCH ALLOWSSDR CALA2025081507816Rib · crackedRIGHT HORIZONTAL STAB. LEADING EDGE PANEL , RIB 4 FROM I/B SIDE HAS A CRACK. REMOVED AND REPLACED RT HORIZONTAL STAB LEADING EDGE RIB 4 IAW 51-40-02-0G-0 AND DWG 186A1001.SDR CALA2025081507815Lens · damagedEMERGCY EXIT LIGHT ON CRNR OF FWD CLOSET BROKEN. REPLACED EMERGENCY EXIT LIGHT LENS BY 1L.SDR CALA2025081507814Wire Harness · brokenPROCEDURE - SEAT 38C EMERGENCY LIGHT IS INOP. FOUND HARNESS, P/N: BR9631-60, UNDER SEAT BROKEN FROM CONNECTOR. HARNESS IS NSU IN SAT, RECONNECT HARNESS. ALL ADJACENT EMERGENCY LIGHTS OPERATE NORMALLY, PLACED ON MEL 3350C.SDR CALA2025081507813Light · no discrepancyFA ADVISES ALL EMERGENCY LIGHTS ILLUMINATED PRIOR TO LANDING. NO EMER LIGHT INDICATION IN FLT PER CABIN CREW, ONLY OVHD AND PAX DOOR EXIT SIGNS ILLUMINATED PRIOR TO LANDING. PER CABIN EMERGENCY LIGHTING DESCRIPTION AND OPERATION AMM 33-51-00/001, THIS IS NORMSDR CALA2025081507812Battery · no testCOMPLIED WITH CABIN EMERGENCY LIGHT TEST, AFTER TEST WAS PERFORMED FAULT EPSU BATTERY EMER L WAS SHOWN ON CIDS PANEL. TESTED SYSTEM TWICE, FAULT SHOWED BOTH TIMES. REMOVED AND CLEANED FWD LEFT BATTERY CONTACTS AND REINSTALLED BATTERY IAW MM 33-51-38. OPS CHECSDR CALA2025081507811Toilet · leakingTOILET BOWL SMELLS BAD AFT RH LAV E RMOVED AND REPLACED TOILET VACUUM LAV E IAW AMM 38-32-01-000-802, THE NEW TOILET IS LEAKING REQUSET REPLACE WITH NEW ONE. GROUND LUG BROKEN NEED AVIONIC. RINSTALLED GROUND TERMINAL REF. SWPM20-30-00 TOILET AND LAV WAS DEEP SDR CALA2025081507810Unknown · odorRAMP REPORT FWD AND AFT PIT SMELLS LIKE FISH. RAMP CLEANED BOTH FWD AND AFT CARGO PIT. NO OTHER MX ACTION NEEDED.SDR CALA2025081507809Unknown · odorBAD ODOR COMING FROM AC SYSTEM. FOUND APU RUNNING AND EXTERNAL AIR HOOKED UP ON ARRIVAL. DISCONNECTED EXT AIR AND RAN BOTH PACKS. WALKED CABIN AND FLIGHT DK NOTICED NO BAD ODOR, NOTE TURBO PROP RUNNING ADJACENT GATE AND SUSPECT THAT WAS THE ODOR IN THE FLT DK.SDR CALA2025081507808Toilet · odorTOILET BOWL SMELLS BAD, AFT LT LAV D TOILET AND LAV WAS DEEP CLEANED BY CONTRACT VENDOR CLEANERS. OK TO CONTINUE IN SERVICE.SDR CALA2025081507807Smoke Detector · false activationFWD LAV SMOKE DETECTOR TRIGGERED. NO SMOKE OR FUMES OF ANY SORT IN LAV NOBODY VAPED/SMOKED. PERFORMED LAV. SMOKE SELF TEST. TEST PASSED IAW AMM-26-14-00-710-801. PERFORMED SMOKE TEST, TEST PASSED. IAW AMM-26-14-00-730-801, COULD NOT DUPLICATE PROBLEM.SDR CALA2025081507806Circuit Breaker · trippedVENT BLOWER FAULT ECAM O N TAXI IN. FOUND VENT EXTRACT AND BLOWER CIRCUIT BREAKERS OPEN. NO REPORT OF ELECTRICAL ODOR. RESET CIRCUIT BREAKERS WITH NO ISSUES. ACCOMPLISHED AVEC SYSTEM TEST REF AMM 21-26-00-710-001-A, WITH NO FAULTS REPORTED.SDR CALA2025081507805Unknown · odorHOT PLASTIC ODOR NOTED THROUGHOUT ACFT. OVENS CHECKED AND NOT THE SOURCE. DEBRIEFED CREW, & FLIGHT ATTENDANTS, REPORTED ODOR STARTING AROUND ROW 35 , EMINATING FROM UPPER CABIN AND MOVING FORWARD UNTIL FLT CREW SMELLED IT. REPORTED ODOR WAS MORE OF A PLASTIC SDR CALA2025081507804Circuit Breaker · openVENT EXTRACT FAULT ECAM ON TAXI IN, FOUND VENT EXTRACT AND BLOWER CIRCUIT BREAKERS OPEN. NO REPORT OF ELECTRICAL ODOR. RESET CIRCUIT BREAKERS WITH NO ISSUES. ACCOMPLISHED AVEC SYSTEM TEST REF AMM 21-26-00-710-001-A WITH NO FAULTS REPORTED.SDR CALA2025081507803Filter · odorSECOND HALF OF FLT NOTICED AN ACCRID OR SMELLY GYM SOCKS WITH PACKS ON. NO SMOKE PRESENT. PER CREW ODOR CONTINOUS WITH APU RUNNING & IN FLIGHT DECK, REF TSM 05-50-810-831-A. APU NEEDS INSPECTION IAW AMM 49-00-00-200-816. NOTED BY MAINT. NO PRIOR HISTORY. SDR CALA2025081507802Wheel · faultedLANDING GEAR DISAGREE LIGHT ON AT GEAR RETRACTION, HAD SIGNIFIC ANT NOSE WHEEL VIBRATION, SPOKE WITH CREW & SAID SOUNDED LIKE ONE OF NOSE TIRES WERE WOBBLING & SAID HAD RED & GREEN MLG LGHTS ON ALL GEAR & AFTER CYCLING GEAR HANDLE, LIGHT WENT AWAY. PUT ACFTSDR CALA2025081507801Transceiver · inoperativeRADAR WAS WORKING MOST OF FLT, THEN RECEIVED WXR FAIL MSG. PERFORM FIM 34-43 TASK 801. REMOVED AND REPLACED WX RADAR R/T UNIT IAW AMM 34-43-41-000-801. WX RADAR SYSTEM TEST GOOD OK FOR SERVICE.SDR CALA2025081507800Processor · faultedTOTAL FUEL QTY IND ERRATIC BEFORE DEP TOTAL FUEL QTY IND ERATIC DUE TO CTR TANK FUEL QTY IND ERRATIC TOTAL FUEL QUANTITY INDICATION HAS BEEN DEFERRED IN COMPLIANCE WITH MEL CARD 28220. MEL 2841J, ACCMPLISHED DRIPSTICK METHOD AND CHECKED OK, DUE TO CTR TANK ISDR DALA2025081506125Gust Lock · dirtyGUST LOCK ON L2 DOOR INOPERATIVE. PERFORMED GUST LOCK CLEANING IAW AMM 52-10, THEN PERFORMED OPS CHECK IAW AMM 52-13, SATISFACTORY. (7296710)SDR DALA2025081506130Screw · missingCAPTAIN`S OXYGEN MASK COVER LID INOPERATIVE, PARTIALLY BROKEN. REINSTALLED SCREW AMM 35-11. (7751780).SDR DALA2025081506118Seat Track · corrodedCORRODED SEAT TRACK +Y765 AT FR 66 AFT GALLEY AREA. REPLACED SEAT TRACK Y765 AND FASTENERS FR 64 TO FR 66 AFT GALLEY AREA, IAW SRM 51-42-11 AND SRM 51-72-11.SDR DALA2025081506117Floor Support · corrodedCORRODED FLOOR SUPPORT +Y765 AT FR70 AT AFT GALLEY AREA. REPLACED THE FLOOR SUPPORT Y765 AND FASTENERS AT FR 66 TO FR 70 IAW SRM 51-42-11, SRM 51-72-11.SDR SWAA2025081504621Light · out of adjustSTORAGE BIN LOWER TRIM, EMERGENCY LIGHT IS LOOSE AT ROWS 7, 8, & 9 FED. ADJUSTED STORAGE BIN LOWER TRIM WITH EMERGENCY LIGHT IAW CMM 25-24-02.