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 AALA202508180993Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 5OOD TO BS 500I AT LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND AARD 51-00-05-1.SDR AALA202508189145Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I AT RBL 24. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202508186849Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT, AFT BULKHEAD, LOWER LOBE RAIL ASSEMBLY LOCATED AT BS 500I FROM RBL 25 TO LBL 25L. REPLACED RAIL ASSEMBLY PER AARD 51-00-05-1.SDR IPXA2025081430185Rib · crackedCRACKED RIB, INBD SIDE OF LT WING INBD AILERON UPPER FLANGE, WBL 445. EI NO.F2025A57M-1675 SEQUENCE A STEP 20.SDR IPXA2025081246933Latch · inoperativeCREW ENTRY DOOR UPPER LATCH IS OUT OF LIMITS. INSTALLED CREW ENTRY DOOR UPR LATCH, IAW CMM 52-11-08 AND AMM 20-11-00-912-001.SDR ASAA2025080159935Baffle · crackedFWD CARGO STA 440 BAFFLE CLIP CRACKED LBL 26. GROUNDED - YES. FWD CARGO STA 440 BAFFLE CLIP LBL 26 REMOVED AND REPLACED IAW SRM 51-40-02-0G-0.SDR SWAA2025081197141Battery Pack · inoperativeALL ASSOCIATED LIGHTS WITH M1674 EMERGENCY BATTERY PACK INOP<[01] REMOVED AND REPLACED EMERGENCY BATTERY PACK POWER SUPPLY AND CHARGER M1674 PER AMM 33-51-06-960-806 AND TEST GOOD PER AMM 33-51-06-960-806;[02] VERIFIED CORRECTIVE ACTIONSDR SWAA2025081197142Battery Pack · inoperativeALL ASSOCIATED LIGHTS WITH EMERGENCY BATTERY PACK M1675 INOPERATIVE REMOVED AND REPLACED EMERGENCY BATTERY PACK POWER SUPPLY AND CHARGER M1675 PER AMM 33-51-06-960-806 AND TEST GOOD PER AMM 33-51-06-960-806;[02] VERIFIED CORRECTIVE ACTIONSDR IPXA2025081144210Power Supply · inoperativeEMERGENCY LIGHTS POWER SUPPLY UNITS FAILED BITE CHECK -ER AMM 33-51-00-0501 REF PS1 STEP 23. C/W BITE CHECK IAW AMM 33-51-00-0501, NO FAULTS FOUND, CHECK OK AT THIS TIMESDR AALA202508118148Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508113294Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 312 TO BS 328 AT RBL 30 REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202508111601Hinge Fitting · excess playAIRCRAFT IN BASE MAINTENANCE: EXCESSIVE PLAY ELEVATOR HINGE ARM END FITTING # 1 ON RH HORIZONTAL STABILIZER. MAINTENANCE REPLACED HINGE ARM END FITTING #1 ON RH ELEVATOR IAW AMM 55-16-42-400-001-A.SDR CALA2025081107557Seat Track · corrodedMAIN CABIN GOUGE AT SEAT TRACK CROWN TOP STA 520 RBL 24.75. INSTALLED SEAT TRACK SECTION AND CHANNEL AT STA 520 TO 500I+12 RBL24.75 IAW B737 SRM 51-40-02 AND 53-00-52-2R4. ACCOMPLISHED REPAIR OF SEAT TRACK SECTION AND CHANNEL AT STA 520 TO 500I+12 RBL 24.75SDR CALA2025081107556Seat Track · corrodedMAIN CABIN GOUGE AT SEAT TRACK CROWN TOP STA 520 LBL 24.75 INSTALLED SEAT TRACK SECTION AND CHANNEL AT STA 520 TO 500I+12 LBL24.75 IAW B737 SRM 51-40-02 AND 53-00-52-2R4SDR CALA2025081107555Seat Track · corrodedMAIN CABIN GOUGE AT SEAT TRACK CROWN TOP BS 520 LBL 45.50. COMPLETED INSTALLATION OF SEAT TRACK SECTION AND CHANNEL AT STA 520 LBL 45.50" PER SRM 51-40-02-0G-0 AND SRM-53-00-52-2R-4 DWG 143A5400. ACCOMPLISHED REPAIR OF SEAT TRACK SECTION AND CHANNEL AT BS 5SDR TAMF20250708052Engine · failedDURING THE TAKE-OFF ROLL, A THRUST LOSS OCCURRED ON ENGINE NO. 2, ALONG WITH AN ABNORMAL INDICATION FROM THE ENGINE ANTI-ICE SYSTEM. THE ECAM DISPLAYED: "A. ICE ENG 2 VALVE OPEN". AN OPERATIONAL CHECK OF THE ENGINE AIR INTAKE ICE PROTECTION SYSTEM WAS PERFORMESDR JJBA20250808018Bracket · crackedINSIDE RH FUEL PANEL 631DB, 2 BRACKETS FOUND CRACKED. RH WING LOWER SKIN AT RIB 8 PAINT REMOVED. RH FUEL PANEL 631DB RIB 8, 2 BRACKETS REPLACED.SDR JJBA20250808016Floor Support · damagedCENTER OMEGA BEAM DAMAGED ON RH SIDE UNDER CENTER GUSSET BETWEEN FRAME 16 AND 17. REPAIRED CENTER OMEGA BEAM BETWEEN 16 AND 17 INSTALLED A U CHANNEL DOUBLER AND FILLER.SDR DALA2025080705930Skin · debondedER/A 601550-14 REV A. A220 / RH HORIZONTAL STABILIZER / UPPER AND LOWER SKINS / @ REAR SPAR / HINGE RIB 2 TO HINGE RIB 3 / DISBOND. SUBJECT REPAIR REQUIRES FOLLOW-ON ACTION. ACCOMPLISH ER/A 601550-14 REV A, SEC. V WITHIN 18,500 FH FROM 7,614 TOTAL FH (WITHIN 1SDR DALA2025080705928Longeron · crackedWHILE WORKING LOG 6823744, REMOVED WHEEL WELL BIN F.O.M. FOUND LONGERON CRACKED. REMOVED AND REPLACED LONGERON. OK FOR SERVICE. (LP# 1119309)SDR DALA2025080705925Seat Track · corrodedAFT GALLEY CENTER F/A SEAT MOUNTING FLANGE CORRODED. REMOVED AND REPLACED FLOOR FITTINGS WITH REF CMM 25-30-18.SDR DALA2025080705924Door Frame · corrodedEVIDENCE OF CORROSION AT FWD R/H EMERGENCY EXIT CUT-OUT. COMPLIED WITH ER/A 628114-14 REV ORIGINAL SECTION 1 TEMPORARY REPAIR.SDR DALA2025080705923Floor Panel · corrodedCORROSION ON AFT SERVICE DOOR LOWER ENTRY FLOOR PANEL AFT CORNER. REMOVED AND INSTALLED AFT SERVICE DOOR LOWER ENTRY FLOOR PANEL PER A220 AMP BD500-A-J53-00-47-14AAA-720A-A.SDR DALA2025080705922Floor Panel · corrodedCORROSION ON AFT SERVICE DOOR LOWER ENTRY FLOOR PANEL AFT CORNER . REMOVED AND INSTALLED AFT SERVICE DOOR LOWER ENTRY FLOOR PANEL PER A220 AMP BD500-A-J53-00-47-14AAA-720A-A.SDR DALA2025080705921Floor Panel · corrodedCORROSION ON AFT SERVICE DOOR LOWER ENTRY FLOOR PANEL AFT CORNER. REMOVED AND INSTALLED AFT SERVICE DOOR LOWER ENTRY FLOOR PANEL PER A220 AMP BD500-A-J53-00-47-14AAA-720A-A.SDR SCNA20250807295Generator · trippedWHILE BOARDING APU GENERATOR KICKED OFF LINE. MANUALLY PUT GENERATOR BACK ON LINE. DISTINCT ELECTRICAL SMELL IN FLIGHT DECK CABIN. PERFORMED FUMES IN CABIN FIM 21-00 TASK 806 NO DEFECTS NOT AT THIS TIME A/C OK FOR SERVICESDR FDEA202508011354Access Panel · puncturedFLOOR ACCESS PANEL 242 VFF WITH SEVERAL PUNCTURE ON MAIN DECK CARGO COMPARTMENT. FLOOR PANEL 242 VFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR4-B FIG 201 SHEET 2 REV. 92 APR 15,2025SDR FDEA202508011353Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 241AGF AT MDC FLOOR PANEL 241AGF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG. 201 SHEET 2 REV. 92 APR 15,2025SDR FDEA202508011352Floor Panel · crackedCRACKS ON FLOOR PANEL 241WFF FLOOR PANEL 241WFF WAS REPAIRED IAW B767 SRM 53-00-50 2R PAR 4.B FIG 201 SHEET 2 REV.92 APR 15,2025SDR FDEA202508011351Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 242GFF AT MDC FLOOR PANEL 242GFF AT MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4.B FIGURE 201 SHEET 2 REV.92 APR 15,2025SDR FDEA202508011350Floor Panel · puncturedPUNCTURE ON FLOOR PANEL 251FFF AT MDC FLOOR PANEL 251FFF AT MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR4.B FIGURE 201 SHEET 2 REV. 92 APR 15,2025SDR FDEA202508011348Floor Panel · crackedCRACK ON FLOOR PANEL 251AFF FLOOR PANEL 251AFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG.201 (SHEET 2) REV. 92 APR 15,2025SDR FDEA202508011347Floor Panel · crackedCRACKS ON FLOOR PANEL 251QFF FLOOR PANEL 251QFF WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR. 4-B FIG.201 (SHEET 2) REV. 92 APR 15,2025SDR CALA2025080607383Floorbeam · corrodedFOWARD WET AREA STA.294.5 RBL 10" FLOORBEAM STRUCTURE HAS CORROSION. ACCOMPLISHED ESFR FORM AS PER UAL GMM 04-20-05.REMOVED AND REPLACED UPPER T-CHORD AT FLOORBEAM STA 294.5 BETWEEN LBL 35 TO RBL 57 REF SRM 53-10-51-2R-16 AND SRM 51-40-02-0G-0 PARAGRAPH 4 ANSDR CALA2025080607381Skin · damagedLIGHTNING STRIKE STATIC DISCHARGE NOTED AT SKIN STA 1040 +16" AND 0.5" ABOVE STR 25R, LOWER EXTERNAL FUSELAGE SECTION 48 DOT 223-030. REF AAR N/R 9983881 ACCOMPLISHED REPAIR AT LIGHTNING STRIKE DAMAGE FUSELAGE SKIN BETWEEN STA 1040 - 1064 AT STRINGER 25R PERSDR CALA2025080607366Wire Harness · faultedLEVEL 2 CHRONIC FWD CARGO DOOR DISPLAYED ON UPPER ECAM. AVIATAR IS NOT REPORTING ANY CORRELATED CMS FAILURE MESSAGES. SENSORS 28 WV AND 30WV HAVE BEEN REPLACED & ADJUSTED MULTIPLE TIMES. INSPECTED FWD CARGO DOOR HANDLE LATCH ASSY & HOOK, NO DEFECTS FOUND, SDR ASAA2025080159827Glowstrip · missingFIRST SECTION OF PHOTOLUMINESCENT FLOOR PATH MARKING MISSING ON RIGHT SIDE. GROUNDED - YES. REPLACED MISSING SECTION OF PHOTLUMINESCENT FLOOR MARKING REF AMM 33-51-15.SDR ASAA2025080159822Cover · detachedAFT GALLEY EXIT SIGN COVER FELL OFF. GROUNDED - YES. RE-INSTALLED AFT GALLEY EXIT SIGN COVER.SDR QXEA2025080500288Door · no discrepancyFLIGHT 2223. MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED FROM SERVICE. PERFORMED FUNCTIONAL CHECK OF L1 DOOR PER AMM 52-11-20-720-801-A. CHECK GOOD. NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SWIA2025080500001Ballast · failedBURNING ELECTRICAL SMELL THROUGH OUT THE AIRPLANE. (FLIGHT 6240) UPON ARRIVAL TO AC, INTERROGATED EVIDENCE OF ELECTRICAL BURNING SMELL AND COULD NOT SMELL OR SEE ANY EVIDENCE OF SAID ELECTRICAL SMELLS IN AC. HAD SERVAL MXS COME ON BOARD TO VERIFY, AND EVERY MSDR SWAA2025080597183Slide · displacedFORWARD SERVICE DOOR ESCAPE SLIDE DISPLACED AND DRAGGING<[01] REPACKED FORWARD SERVICE DOOR ESCAPE SLIDE REF AMM 25-66-01.SDR SWAA2025080597692Slide · out of adjustESCAPE SLIDE ON THE FORWARD SERVICE DOOR LOOKS LIKE IT IS NOT STRAIGHT IN ITS CONTAINER<[01] R1 SERVICE DOOR ESCAPE SLIDE IS INSTALLED CORRECTLY & GAUGE IS EASILY VISABLE REF AMM 25-66-01SDR SWAA2025080597173Light · dimAFT GALLEY AFT WALL L/H AND R/H SEAT BELT LIGHTS ARE DIM.<[01] 01 - REMOVED AND REPLACED PER [AMM 33-51-14-201-MAX (FLOOR PROXIMITY LIGHTS ON GALLEYS; LAVATORIES; CLOSETS; AND WINDSCREENS - MAINTENANCE PRACTICES - PERMANENT)]SDR SWAA2025080597352Battery Pack · failedEMERGENCY LIGHTS AT ROWS 1CBA THROUGH 4CBA WILL NOT COME ON<[01] REPLACED EMERGENCY ROW POWER SUPPLY AND BATTERY AT M1675 REF AMM 33-51-06.SDR SWAA2025080597318Battery Pack · inoperativeSEVERAL FWD EMERGENCY LIGHTS INOP<[01] REMOVED AND REPLACED BATTERY AND POWER SUPPLY AT POSITION M1674 PER AMM 33-51-06.SDR SWAA2025080597277Light · inoperativeEMERGENCY LIGHTS DO NOT COME ON WHEN COMMANDED TO ON FROM THE FLIGHT DECK.<[01] UPON FURTHER INSPECTION FOUND LOOSE TERMINAL LUG ON THE BACK OF THE EMERGENCY LIGHT SWITCH. TIGHTENED DOWN TERMINAL PER SWPM 20-30-00. OPS CHECK GOOD.SDR SWAA2025080597346Handle · looseFORWARD ENTRY DOOR ASSIST HANDLE IS LOOSE<[01] TIGHTENED FORWARD ENTRY DOOR ASSIST HANDLE IAW AMM 52-11-31-400-801-MAX.;[02] TASK C/WSDR SWAA2025080597347Handle · looseFORWARD GALLEY SERVICE DOOR ASSIST HANDLE IS LOOSE<[01] TIGHTENED FORWARD ENTRY DOOR ASSIST HANDLE IAW AMM 52-11-31-400-801-MAX.;[02] TASK C/WSDR SWAA2025080597311Seal · crackedLH HORIZONTAL STAB UPPER SLIDER SEAL IS CRACKED<[01] REMOVED AND REPLACED LH STABILIZER FRONT UPPER SPAR SLIDING SEAL IAW AMM 53-31-31. NO DEFECT NOTED;[02] C/W INSPECTION OF REMOVED AND REPLACED LH STABILIZER FRONT UPPER SPAR SLIDING SEAL; OPS CHECKED GOOD PESDR SWAA2025080597542Skin · delaminatedLEFT WING OB AFT FLAP LOWER FACE SHEET DELAMINATED AT IB TE 19.5' X 10'(PICS ATTACHED)<[01] R/R LEFT WING OUT BOARD AFT FLAP PER AMM 27-51-22