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 DXTA2025100305179Elec Connector · looseEMERGENCY LIGHTS IN SEAT NR 3 OVERHEAD LIGHT IS INOP, FLOOR LIGHTING ON NR 3 IS INOP AND RIGHT WING INSPECTION LIGHT IS INOP. ALL EMERGENCY LIGHTS ARE ON BATTERY NUMBER TWO. INSPECTED AND FOUND NR 2 BATTERY PACK CONNECTOR LOOSE. SECURED CONNECTOR AND PERFORMESDR DXTA2025100305178Display · inoperativeAFTER TAKE OFF-APPROX. 1500 FEET AGL BOTH LT SEAT PFD & MFD DISPLAYS FAILED. WE RETURNED TO THE FIELD. PERFORMED THE OPS CHECKS FOR THE IC-615 COMPUTER WITH STAISFACTORY RESULTS REF AMM 34-26-00 MCC HAS ELECTED TO SIGN OFF AND RELEASE.SDR DXTA2025100305177Wire · damagedEMERGENCY FLOOR LIGHT, UNDER SEAT NUMBER 3 IS INOP. DOES NOT WORK WITH BATTERY PACK OR SHIPS POWER. GAINED ACCESS TO SEAT 3 WIRING, FOUND RED AND BLACK WIRES YANKED FROM PINS. RETERMINATED SEAT 3 PATH LIGHT CONNECTOR IAW INTERIOR WDM 25-92-08. OPS CHECK GOODSDR DALA2025100307210Slide · low pressureR4 PAX. DOOR ESCAPE SLIDE LOW PRESSURE. REMOVED R4 PAX. DOOR ESCAPE SLIDE PER W/C 2566-9001-4R. INSTALLED R4 PAX DOOR ESCAPE SLIDE PE W/C 2566-9001-4R. SECURED AND OPS CK NML. RII COMPLETED.SDR DALA2025100307208Floor Support · corrodedCORROSION ON FLOOR SUPPORT BS 684 BTW RBL 59 AT W2. CORROSION LEVEL 2- FLOOR SUPPORT BS 684 BTW RBL 59 WAS REPLACED PER B757-200 SRM 51-40-02-0G AND DWG 143N5122 REV. A. (1230774)SDR IXXA20251002059Escape Reel · detachedUPON TAKE OFF EMERGENCY DESCENT DEVICE FELL DOWN. PLACED ON DEFERRAL 66712 MINIMUM EQUIPMENT LIST 25-61-01-01 CATEGORY C. DUE 12 OCTOBER 2025. REMOVED AND REPLACED DESCENT DEVICE IN ACCORDANCE WITH IAI B767 SUPPLEMENTAL MAINTENANCE MANUAL 25-61-03. DEFERRAL 6SDR DALA2025100307200Pump · overheated(LOG 5659129) SYS A ELECT HYD PUMP OVERHEAT LT ON WITH ELECT FUMES IN COCKPIT. TURNED ELECT HYD PUMP OFF + FUMES DISSAPATED. FOUND HYD PUMP A CONNECTOR DAMAGED AND SHORTING PUMP SIDE + A/C SIDE. R/R CONN D2664 REF SWPM 20-61. + B737 WDM 29-11-12. R/R SYS A HYDSDR DALA2025100307198Stringer · corroded(LOG 1231070) CORROSION ON STGR 25LH BTW STA 827 TO STA 847 AT AFT CARGO COMPARTMENT. STGR 25LH BTW STA 827 TO STA 847 AT AFT CARGO COMPARTMENT WAS REPAIRED PER B737-800 SRM 53-00-03-2R PROCEDURE 1. REPAIR 1.SDR DALA2025100307197Frame · damaged(LOG 1230927) PERFORM LEFT HAND STA 727 FRAME INNER CHORD 737 REPAIR; RII; SECTION 02. LEFT HAND STA 727 FRAME INNER CHORD 737 REPAIR; RII; SECTION 02 WAS PERFORMED IN ACCORDANCE AMDS 5311-01251-02A.SDR DALA2025100307196Frame · damagedPERFORM RIGHT HAND STA 727 FRAME INNER CHORD, 737 REPAIR; RII; SECTION 02. RIGHT HAND STA 727 FRAME INNER CHORD 737 REPAIR; RII; SECTION 02 WAS PERFORMED IN ACCORDANCE AMDS 5311-01251-02B.SDR FDEA202510021876Light · faultedL1 DOOR EMERG. EXIT FWD DOWN SPOT LIGHT WILL NOT ILLUMINATE. AMM: 33-51-13-04 SERVICED L1 EMERG DOOR EXIT LIGHT. OK FOR SERVICE.SDR FDEA202510021875Light · malfunctionedR1 DOOR EMERG. EXIT FWD DOWN SPOT LIGHT WILL NOT ILLUMINATE. SERVICED R1 DOOR EMERGANCY LIGHT. OK FOR SERVICESDR FDEA202510021874Floor Panel · crackedPUNCTURE ON FLOOR PANEL 241KFF OF MAIN DECK. FLOOR PANEL 241KFF OF MAIN DECK WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV.92 APR 15/2025SDR FDEA202510021872Control Lever · dirtyAMBER GEAR DISAGREE AND TAILSKID LIGHTS WITH CORRESPONDING EICAS ALERT WHEN GEAR EXTENDED FOR LANDING. APPROACH DISCONTINUED AND QRH CHECKLIST COMPLETED. NORMAL LANDING. ALL AMBER ALERTS EXTINGUISHED AFTER LANDING. INSTALLED GEAR PINS SDR SIMA20251002004Floorbeam · corrodedPASSENGER FLOOR STRUCTURE PANEL SUPPORT HAS CORROSION IN (2) LOCATIONS, 1 AT FR 89 +2? AND Y= +34? AND 1 AT FR 90 AND Y= +33?. LEVEL 2 CORROSION BLENDED CORROSION AT FR89-FR90 FLOOR STRUCTURE SUPPORT 2 EA LOCATIONS IAW EMB 175 SRM 51-10-03. MAX DEPTH OF BLENDSSDR HNAA2025100300657Bleed Valve · faultedBLEED 1 VALVE FAIL MESSAGE ON EICAS AFTER ADVANCING THRUST LEVERS. R+R'D #100 ENGINE BLEED VALVE IAW AMM 36-11-05. LEAK CHECK GOOD. PERFORMED BLEED 1 OPS CHECK IAW AMM 36-00-00. OPS CHECK GOOD. A/C OK FOR SERVICE.SDR SIMA20251002003Seat Track · corrodedPASSENGER FLOOR STRUCTURE, LH LONGITUDINAL SEAT TRACK HAS CORROSION AT FR84 -6" LEVEL 2 CORRSION BLENDED LH INBD SEAT TRACK AT FR 84 -6" IAW EMB 175 SRM 51-10-03. AND IS L=1" W=- 1" D=.040" DAMAGE IS INSIDE CROWN TEETH AND IS IN DAMAGE NOT ALLOWED AREA PART RESDR HNAA2025100300659Floor Support · cracked53-2069 LH OMEGA BEAM #1 IB FLANGE CRACKED AT FR21, FR22, FR23. REPAIRED OMEGA BEAM IAW ETD2025-145-928523 AND EO1-53-25-0336SDR HNAA2025010030065Bleed Valve · faultedBLEED 2 VLV FAIL CAUTION MSG ON ATTEMPTED T/O AROUND 32 KTS.SDR DALA2025100307195Seal · leakingDECLARED EMERGENCY AFTER GETTING DIRTY SOCK SMELL ON DESCENT FOR PLANNED FUEL STOP IN SLC. DONNED MASKS. PERFORMED VISUAL INSPECTION OF BOTH ENGINES AND FOUND OIL LEAKING FROM BOTH SPINNERS. REPLACED FAN SHAFT COVER SEAL ON NBR 1 AND 2 ENGINES PER A321 AMM 7SDR DALA2025100307194Seal · leakingFA'S REPORTED DIRTY SOCK SMELL ON APPROACH. DURING INSP FOUND OIL ON #1 ENG SPINNER. REPLACED SHAFT COVER SEAL REF A321 AMM 72-15. PERFORMED LEVEL B DECONTAMINATION AS PER A321 AMM 21-00-00-615-803-A, NO SMELLS NOTED. (LP 7574004)SDR CALA2025100309605Door · not closedFWD ENTRY LIGHT ILLUMINATED FOR APPROX 1 MIN ON TAKEOFF INTERROGATED OMF, FOUND TWO HITS FOR FWD ENTRY DOOR, MX MSGS 52-71001 AND 52-71111. COMPLIED WITH FIM 52-10 TASK 801 AND AMM 52-71-11-710-801, MX MSG NOT LATCHED AND SHOWS IN ACTIVE. FWD ENTRY DOOR OPENS SDR CALA2025100309581Slide · no discrepancyFA REPORTS DOOR 1R A BIT OF YELLOW SHOWING 1R DOOR SLIDE PACK MOUNTED PROPERLY, NO DEFECTS NOTED REF AMM 25-66-01.SDR CALA2025100309579Pin · installedINSTALLED L2 DOOR EMERGENCY CONTROL HANDLE SAFETY PIN IN THE DISARMED POSITION TO FACILITATE SCHEDULED L2 DOOR. R & R IAW AMM 52-10-00-860-001-A. REMOVED L2 DOOR EMERGENCY CONTROL HANDLE SAFETY PIN POST-MX ON L2 DOOR SLIDE R&R REF AMM 52-10-00-860-002-A. ASDR CALA2025100309578None · noneRIGHT OVERWING SLIDE DEACTIVATED AND PANELS OPENED. IAW AMM - 25-65-00-002-001. RIGHT OVERWING SLIDE REACTIVATED AND CLOSED PANELS. ARMED RT OVER WING SLIDE REF AMM 25-65-00. VERIFIED RH OVER WING SLIDE REACTIVATED AND ARMED PER RII REQUIREMENTSSDR CALA2025100309574Lamp · inoperativeEMERGENCY LIGHTS, LT FWD ESCAPE SLIDE EMERGENCY LIGHT INOP, ESCAPE LIGHT LAMP RESEATED AND TESTED IAW AMM 33-51-06-902-082, LIGHT NOW OPERATES.SDR CALA2025100309573Light · inoperativeSEAT 32C EMERGENCY FLOOR PROX LIGHT INOPERATIVE. REMOVED AND REPLACED SEAT 32C EMERGENCY FLOOR PROX LIGHT. OPS CHK NORMAL. REF AMM 33-51-11.SDR SIMA20251002001Seat Track · corrodedY+10? SEAT TRACKS SEGMENT THAT GOES FROM FRAME 22+8? TO 34+4? HAS A GOUGE AT FRAME 24+8? LEVEL 2 CORROSION BLENDED OUT GOUGE ON Y+10 SEAT TRACK AT FR 24+8" PER EMB-175 SRM 51-10-03. BLENDED OUT 1 MORE GOUGE ON SEAT TRACK Y+10 JUST FWD OF FR24 PER EMB-175 51-10SDR SIMA20251002002Seat Track · corrodedPASSENGER FLOOR STRUCTURE RH LONGITUDINAL SEAT TRACK HAS CORROSION IN (3) LOCATIONS FR81-3?, FR84-6? AND FR84+3?. LEVEL 2 CORROSION BLENDED SPOTS ON RH INBD SEAT TRACK (FR 82 -3" L=1" W=- 1" D=.040") (FR 84 -6" L=3" W=1" D=.050") IS OUT OF LIMITS DUE TO DEPTH SDR HNAA2025100300656Unknown · odorOIL SMELL IN CABIN WITH PACKS RUNNING. OPS CHECKED PACKS HOT AND COLD EACH. IAW AMM 21-51-00 NO SMELLS NOTED AC OK FOR SERVICESDR CALA2025100209561Life Raft · not reportedINFLATABLE LIFE RAFT REPLACE - REMOVED AND REPLACED LIFE RAFT ACT ACT REF TASK CARD 29-2560-1-9801SDR CALA2025100209560Sensor · inoperativeDOOR EPAS SENSORS 2R PASSENGER ENTRY DOOR HAS AN OPEN SENSOR FAILURE, GIRT BAR ENGAGE D SENSOR FAILURE, PRESSURE SENSOR FAILURE OR A GIRT BAR / MODE S ELECT DISAGREE. FIM TASK REF : 31-90-F8-01A-421B-A CMC MSG# 5210936 FLIGHT STATUS: A INTERMITTENCE CODE: I PSDR CALA2025100209559Warning Light · intermittentINFORMATION ONLY REPORT . FWD ENTRY LIGHT ILLMNTED AFTER TAKEOFF. WENT OUT AROUND 3K FEET. REF FIM 25-10 TASK 801, MAINT MSG 52-71001, INTERMITTEN FAULT, NOT ACTIVE NOR LATCHED, OK FOR CONTINUED SERVICE.SDR CALA2025100209558Slide · no discrepancyOFF-WING ESCAPE SLIDE PACK - INSTALLATION OFF-WING ESCAPE SLIDE PACK INSTALLATION, LT OVERWING SLIDE ETASK CARD BLOCK 8 TO BLOCK 12 ARE RII ITEMS. INSPECTION BUYBACK REQUIRED. UPGRADED TO RII. ALL STEPS ACP'D. INSPECTION WITNESSED INSTALLATION ON LH OVERWING SDR CALA2025100209557Cover · looseDOOR 4R SLIDE COVER LOOSE. DOOR 4R BUSTLE REPOSITIONED, NOW OK FOR FURTHER SERVICE PER AMM 25-66-11-404-004 REV 145.SDR CALA2025100209556Girt Bar · unsecureDOOR 1R GIRT BAR MATERIAL JAMMED IN BRACKET REMOVED GIRT BAR. INSPECTED MATERIAL. NO DEFECTS NOTED.ENGAGED GIRT. RE-STOWED GIRT WITH REF TO AMM 25-66-01. CKS OK.OPERATED DOOR. SECURED DOOR CLOSED. CHECKS GOOD.SDR CALA2025100209555Bottle · no discrepancySAFETY PIN INSTALLED AT R4 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK FOR MX REMOVED SAFETY PIN AT R4 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE C/W RII INSP. VERIFIED BOTH POWER RESERVOIR AND SLIDE INFLATION CYL VALVE PINS REMOVED AND STOWED RSDR CALA2025100209554Lanyard · loose4L DOOR WILL NOT ARM.. VISUALLY INSPECTED AND FOUND LANDYARD LOOSED. RESECURED LANDYARD AND OPS CHECKD DOOR IN REF AMM 52-13-00. DOOR OK FOR SERVICESDR CALA2025100209553Pressure Gauge · no discrepancyDOOR 3L SLIDE PRESSURE GAUGE LOW. INSPECTED SLIDE PRESS GUAGE AT DOOR 3 L, SLIDE IS IN THE GREEN. IAW 25-66-02 OK TO CONTINUE.SDR CALA2025100209552Gauge · no discrepancyR2 DOOR GAUGE IN THE RED. SLIDE GAGE 1 NEEDLE WITH ON HIGH SIDE OF RED. OK FOR SERVICE REF AMM 25-66-01SDR CALA2025100209551Girt Bar · looseGIRT BAR FWD RT GALLEY DOOR GIRT BAR CLIP LOOSE. TIGHTENED CLIP ON R1 DOOR SLIDE COVER. OPS CHECK NORMAL.SDR CALA2025100209550Slide · no discrepancyREMOVED DOOR 1R ESCAPE SLIDE PACK AND COVER TO FOM REF AMM 25-67-01-000-801. SEE L/P 6427254. INSTALLED R1 DOOR ESCAPE SLIDE PACK AND COVER REF AMM 25-66-01-400-803. OK FOR SVC -END- CW RII OF R1 DOOR ESCAPE SLIDE PACK AND COVER INSTALLATION PER AMM 25-66-01-4SDR CALA2025100209549Girt Bar · looseFA REPORTS 1R DOOR SLIDE GURT BAR FABRIC LOOSE. REINSPECTED DOOR GIRT BAR FABRIC AND PROVIDED A SMALL TUCK OF MATERIAL. SLIDE CURRENTLY IN SERVICEABLE CONDITION. OK TO CONTINUE.SDR CALA2025100209548Indicator · out of positionR1 SLIDE ARM LIGHT IS OUT OF PLACE, R1 SLIDE ARM LIGHT ON DEFERAL. DDP COMPLIED WITH. APPROVED AC OK TO CONTINUE ON 2566R KNUCKLE KNOCKER OPS NORMAL. DM ADDED LIGHT (L404) IF NEEDED. REF WDM 25-66-11-1. REPLACED SLIDE LIGHT PER WDM 25-66-11-1. OPS CHECK GOOD.SDR CALA2025100209547Handle · not seatedAFT ENTRY DOOR LIGHT ON TAKEOFF DOOR HANDLE WAS NOT SEATED MAX S PEED 58 KTS FOR REJECTED TAKEOFF, DUE TO SPEED AND WEIGHT REF AMM 05-51-07-210-801 NO SPECIAL PROCEDURES REQUIRED, GOOD FOR PUSHBACK. DOOR INSPECT SATISFACTORY, CLEANED SENSOR TARGET AND VERIFIEDSDR CALA2025100209546Slide · no discrepancyOVERWING EXIT HATCHES , BOTH RESEVOIRS PINNED , LEFT & RIGHT SIDES . REMOVED PINS FROM BOTH INFLATION RESERVOIRS (LH AND RH SIDE) FOR OVERWING EMERGENCY HATCHES REF AMM TASK 25-62-00-081-001-A.SDR CALA2025100209545Warning Message · intermittentINTRMITTANT EICAS W/ AURAL WARNING...STAYED ON 45SEC. DOOR LIST ED FWD CARGO.L/R CTR ENT. REF L/P 6470480 NO DEFECT NOTED. CARGO/BULK AND EMER DOOR EICAS CAME ON TOGETHR FOR FEW SECS...NO AURAL WARN. HAPPEN 3-4 TIMES. PSEU BITE NO DEFECTS NTED, RESET PSEU ANDSDR CALA2025100209544Slide · no discrepancySAFETY PIN INSTALLED AT R2 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK FOR MX REMOVED SAFETY PIN AT R2 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE C/W RII INSP. VERIFIED BOTH POWER RESERVOIR AND SLIDE INFLATION CYL VALVE PINS REMOVED AND STOWED RSDR CALA2025100209543Pin · installedSAFETY PIN INSTALLED AT L1 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK FOR MX. REMOVED SAFETY PIN AT L1 DOOR EMERGENCY ASSIT BOTTLE AND SLIDE PACK. OK FOR SERVICE. C/W RII INSP. VERIFIED BOTH POWER RESERVOIR AND SLIDE INFLATION CYL VALVE PINS REMOVED AND STOWEDSDR CALA2025100209542Proximity Sensor · damagedPOST FLT REP NOT SENDING WITH MCD OPEN MCDU DISPLAYED MAIN CABIN DOOR OPEN REQD WHEN CREW TRIED TO SEND POST FLIGHT REPORT. CYCLED MAIN CABIN DOOR OPEN AND CLOSED MULTIPLE TIMES, MESSAGE CLEARED. DOOR 1L DOOR SENSOR REPORTING TO ACARS INTERMITENT, NEEDS MORE T