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 SWAA2025112032385Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 242BF HAS PULLED FIBERS ON TOP SIDE. REPAIRED PASSENGER CABIN FLOOR PANEL 242BF ON UPPER SURFACE IAW SRM 53-00-50-2R-1 AND SRM 53-00-50-2R-0 REPAIR GENERAL.SDR SWAA2025112032386Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231ZF HAS PULLED FIBERS ON TOP SIDE. FLOOR PANEL 231ZF REPAIRED IAW SRM 53-00-50-2R-1 AND EA M-25-153-02385.SDR SWAA2025112032387Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 231YF HAS PULLED FIBERS ON TOP SIDE. FLOOR PANEL 231YF REPAIRED IAW SRM 53-00-50-2R-1 AND EA M-25-153-02385.SDR SWAA2025112032388Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 241AF HAS PULLED FIBERS ON TOP SIDE. FLOOR PANEL 241AF REPAIRED IAW SRM 53-00-50-2R-1, AND EA M-25-153-02385.SDR SWAA2025112032389Floor Panel · pulledPASSENGER CABIN FLOOR PANEL 241DF HAS PULLED FIBERS ON TOP SIDE. FLOOR PANEL 241DF REPAIRED IAW SRM 53-00-50-2R-1 AND EA M-25-153-02385.SDR SWAA2025112032160Angle · crackedLEFT WING UPPER TRAILING EDGE ANGLE CRACKED INBD OF MID SPAN DEFLECTION RIB. REMOVED AND REPLACED IAW SRM 51-40-02-0G-0-B00069. INSPECTION COMPLETED ON CORRECTIVE ACTION NR 1 FOR REPLACEMENT OF ANGLE.SDR JJBA20251120072Floorbeam · corrodedLH FLOOR BEAM LOWER IB LIP DOUBLER AT FR 22, STR 4L, HAS CORROSION. REMOVED CORRODED DOUBLER, FABRICATED AND INSTALLED NEW LH FLOOR BEAM LWR IB LIP DOUBLER AT FR22SDR JJBA20251120070Floorbeam · corrodedLH FLOOR BEAM LOWER IB LIP AT FR 20, STR 4L, HAS CORROSION. REMOVED CORRODED DOUBLER, FABRICATED AND INSTALLED NEW LH FLOOR BEAM LWR IB LIP DOUBLER AT FR20SDR AALA202511193627Support Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PANEL 192E AFT RIGHT SUPPORT FITTING. REPLACED SUPPORT FITTING PER SRM 51-40-02.SDR ASAA2025110662368Floor Panel · delaminatedAFT WET AREA FLOOR PANEL DELAMINATED. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR TO AFT FLOOR PANEL IAW SRM 53-00-50-2R0, 53-00-50-2R1.SDR IPXA2025110746890Doubler · corrodedLAVATORY SERVICE PANEL 121DL BLANKING PLUG REINFORCEMENT DOUBLER IS CORRODED. REMOVED AND REPLACED BLANKING PLUG AT LAV SERVICE PANEL 121DL IAW SRM 51-40-21.SDR SWAA2025111332453Filler · brokenEGPR DOOR CUT OUT REPAIR FILLER LOWER SIDE IS BROKEN. FABRICATED NEW FILLER FOR EXISTING REPAIR AND INSTALLED ON EGPR ACCESS DOOR SURROUND DOUBLER LATCH LANDING IAW SRM 53-10-15-2R-4. INSPECTED IAW SRM 53-10-15-2R-4-B00449, REPAIR 4.SDR CALA2025111211143Doubler · not reportedCOORDINATE WITH UAL REP TO BUILD A DOUBLER IDENTICAL TO THE DOUBLER INSTALLED ON FRAME 727C, S5L WITH ONE EXCEPTION, EXTEND THE DOUBLER 3 RIVET ROWS BEYOND UPPER INBD END. DO NOT DRILL INTO FRAME OR NEW DOUBLER, JUST FABRICATE DOUBLER. REMOVED AND REPLACED EXSDR CALA2025111011102Wire · chafedDURING INSPECTION OF FWD GALLEY CHILLER, MULTIPLE AREAS OF DAMAGED & BURNT WIRING FOUND IN VICINITY OF FWD GALLEY CHILLER. ONE ITEM RAISED FOR WIRE DAMAGE TO W0264-230-08. REMAINDER OF DAMAGED WIRES TO BE IDENTIFIED AND RAISED AS SEPERATE ENTRIES. IDT FLAGGSDR DALA2025111108258Skin · crackedCRACK ON EXTERNAL SKIN, BS 1087, BTW L-13R AND L-14R AT AFT FUSELAGE. PERMANENT REPAIR AND PRI 630164-14 REV. 3. (1291355)SDR SWAA2025111033650Window · failedL1 WINDOW OUTER LAYER SHATTERED AT FL350 NO CABIN PRESSURE CHANGES. R & R L1 WINDOW PER AMM 56-11-11 AND WHCU PER AMM 30-41-11. LEAK AND OP CHECKED GOOD.SDR SWAA2025111032785Fire Warning · inoperativeENG FIRE WARNING CAPT SIDE WONT CANCEL WARNING. FIRE WARNING CUTOUT WORKS OK ON FIRE CONTROL PANEL<[01] 05 - OK TO CONTINUE PER [MEL 26-10-02;BELL CUTOUT FUNCTION OF MASTER FIRE WARNING LIGHT]. WITH SP 1 AND AUTHORIZATION NUMBER 291841. REMOVED AND REPLACED SDR DXTA2025111005597Lamp · failedLEFT FORWARD DROP AISLE EMERGENCY LIGHTS ARE EXTREMELY DIM REMOVED LH FORWARD DROP AISLE EMERGENCY LIGHT P/N: 9919040-22 S/N: UNKNOWN AND INSTALLED NEW ASSY P/N: 9919040-22 5/N: 202400000039427, OPS CHECK GOOD. WORK PERFORMED PER CE 560XL AMM 33-20-04SDR DXTA2025111005606Door Seal · wornDOOR SEAL HAS AN AUDIBLE FREQUENCY THAT PRESENTS ON CLIMB STARTING AT FL200 THROUGH FL320 WITH PRESSURE DIFFERENTIALS OF 7.5-9.2 RESPECTIVELY. AIRSPEED IN CLIMB WAS 240 KIAS AND .68M. ABOVE FL320 WITH HIGHER TAS AND P DIF, THE NOISE STOPS. GAINED ACCESS TO ANDSDR GTIA2025111039166Unknown · odorSUSPECTED AIR QUALITY/ FUME EVENT PACK 2. DESCRIPTION OF ODOR/FUMES: PERSISTENT, UNFAMILIAR CHEMICAL SMELL DURING CRUISE. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-ACCOMPLISHED LEVEL A DECONTAMINATION SDR DALA2025111008166Gas Spring · inoperativeL1 DOOR GAS SPRING IS INOP. REMOVED AND INSTALLED NEW L1 GAS SPRING IAW B767 AMM-25-66-03- 004-053 AND IAW B767 AMM-25-66-03. (1291341)SDR DALA2025111008165Gas Spring · inoperativeR2 DOOR GAS SPRING IS INOP. REMOVED AND INSTALLED NEW R2 GAS SPRING IAW AMM 26-66-03- 004-053 AND IAW AMM 25-66-03 (1291338)SDR DALA2025111008164Gas Spring · inoperativeL1 DOOR GAS SPRING IS INOP. REMOVED AND INSTALLED NEW L1 GAS SPRING IAW B767 AMM-25-66-03- 004-053 AND IAW B767 AMM-25-66-03 (1291332)SDR AALA202511103184Solenoid Valve · no testAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT SHORTLY AFTER LEVEL OFF AT FL 320 THEY EXPERIENCED LIGHT WAKE TURBULENCE IMMEDIATELY FOLLOWED BY ECAM ENGINE 2 STALL AND ENGINE 2 N1 BEGAN ROLL BACK BUT RETURNED TO NORMAL WITHIN A FEW SECONDS. THE ECAM THEN SELSDR AALA202511107110Solenoid Valve · no testAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED THAT SHORTLY AFTER LEVEL OFF AT FL 320 THEY EXPERIENCED LIGHT WAKE TURBULENCE IMMEDIATELY FOLLOWED BY ECAM ENGINE 2 STALL AND ENGINE 2 N1 BEGAN ROLL BACK BUT RETURNED TO NORMAL WITHIN A FEW SECONDS. THE ECAM THEN SELSDR AALA202511100029Oxygen Mask · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASKAT SEAT 5RH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE ACCOMPLISHED SUCCESSFUL DROP TEST IAW AMM 35-21-43.SDR AALA202511100094Oxygen Mask · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASKAT SEAT 14RH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE PERFORMED DROP CHECK OF 14RH O2 MASKS. DROP CHECK GOOD IAW AMM 35-23-00.SDR AALA202511101891Actuator · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASKAT SEAT 9LH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE REMOVED AND REINSTALLED 9LH DROP ACTUATOR IAW AMM 35-21-41.SDR AALA202511104121Oxygen Mask · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASK AT FORWARD LAV FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE ACCOMPLISHED SUCCESSFUL DROP TEST IAW AMM 35-21-43 FOR FWD LAV.SDR AALA202511107329Canister · no testAIRCRAFT IN BASE MAINTENANCE: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASK AT SEAT 2LH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE REPLACED 2L O2 MASK CONTAINER HOUSING IAW AMM 35-21-41. DROP CHECK GOOD! REF AMM 35-23-00.SDR AALA202511109069Actuator · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASKAT SEAT 18LH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE REPLACED 18LH OXYGEN CONTAINER ACTUATOR IN REF TO AMM 35-21-41. OPS CHK GOOD.SDR AALA202511108508Oxygen Mask · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASK AT SEAT 3LH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE RE-PACK OXYGEN MASK ASSEMBLY IAW AMM 35-21-43.SDR AALA202511104146Oxygen Mask · no testAIRCRAFT WAS GROUNDED: REF MIC 1658268 DURING OPS CHECK OF MANUAL MASK RELEASE, O2 MASK AT SEAT 26RH FAILED TO DEPLOY. REF AMM 35-23-00-710-001-A. MAINTENANCE PERFORMED OPERATIONAL TEST OF THE PASSENGER OXYGEN SYSTEM IAW AMM 35-23-00-710-001-A.SDR YENA2025111001094Unknown · odorFLT#1033, MCO-SJU. LEVEL II FUME EVENT. STRONG PERSISTENT MELTED CRAYON SMELL FROM 10,000 UNTIL LANDING SMELLED BY BOTH PILOTS. ALSO NOTICEABLE ON APU BLEED AFTER PARKING AT THE GATE. SMELL SEEMED TO BE CONFINED TO THE COCKPIT.; C/W INFORMATION NOTICE 2017-T01SDR 2025FA0000751Wire · shortedWE TURNED THE BATTERY MASTER ON TO TEST A LANDING LIGHT THAT WAS REPORTED TO BE OUT. AFTER ABOUT ONE MINUTE OF THE BATTERY MASTER BEING ON, LARGE AMOUNTS OF SMOKE CAME FROM THE LEFT ENGINE. TROUBLESHOOTING FOUND THAT THE ALTERNATOR OUTPUT WIRE WAS SHIELDED ANDSDR CALA2025111011059Battery · dischargedFOUND THE M33096 BATTERY LOW CAPACITY. EMERGENCY LIGHT POWER PACK (M33096) REPLACED THE M33096 BATTERY AND TEST OK IAW AMM 33-51-06-960-802 REV 105.SDR CALA2025111011057Battery · dischargedEMERGENCY LIGHT POWER PACK (M33099) LOW CAPACITY. REPLACED THE M33099 BATTERY AND TESTED OK IAW AMM 33-51-06-960-802 REV105.SDR CALA2025111011055Battery · dischargedFOUND THE M33406 BATTERY LOW CAPACITY. EMERGENCY LIGHT POWER PACK. REPLACED THE M33406 BATTERY AND TEST COMPLETED. REPLACED THE M33406 BATTERY AND BATTERY CHARGER THEN TEST OK IAW AMM 33-51-06-960-802, AMM 33-51-06-9 60-803 REV105.SDR CALA2025111011053Battery · dischargedFOUND THE M33094 BATTERY LOW CAPACITY. R1 DOOR EMERGENCY LIGHT POWER PACK LOW CAPACITY REPLACED AND TESTED OK. REPLACED THE M33094 BATTERY AND TEST OK AS PER AMM 33-51-06-960-802 REV 105.SDR CALA2025111011051Oil Filter · misinstalledUPON REMOVAL OF NR 2 ENG MAIN OIL FILTER, PROTECTIVE PLASTIC CAPS ON FILTER FEET FOUND NOT REMOVED, AND DISINTGRATED. SOME DEBRIS FOUND IN FILTER. ENGINE FILTER REPLACED ON TASK 63-7921-1-0002. ENGINE IDLE RUN REQUIRED AS STATED BY POWERPLANT. ENGINE GROUND SDR CALA2025111011049Tee Angle · corrodedEXTERNAL LOWER FUSELAGE BS 900 TEE ANGLE LBL 6 WITH CORROSION. TEE ANGLE BS 900 WAS REPLACED IAW SRM 51-70-11- OG.SDR CALA2025111011047Fitting · crackedL4 DOOR UPPER FITTING CRACKED. REMOVED AND REPLACED UPPER FITTING ON L4 DOOR IAW SRM 51-40-02-06-0SDR CALA2025111011045Floor Support · crackedAFT CARGO COMPARTMENT CEILING AREA BS 1420- 1440, RBL. 0.05 INTERCOSTAL FLOOR SUPPORT CRACKED. REMOVED AND REPLACED CLIP ANGLE ON AFT PIT STA 1420 TO STA 1440 BL.0.SDR CALA2025111011031Girt Bar · out of adjustDOOR 1R GIRT BAR DIFFICULT TO REMOVE. ADJUSTED R1 DOOR GIRT BAR HOOK TORSION AS NEEDED.SDR CALA2025110911027O-Ring · leakingCONFIRMED FUEL LEAK RIGHT ENGINE. F/O WENT INTO CABIN AND VISUALLY OBSERVED FUEL SPRAYING OUT OF ENG 2. LOST APPROX 2K LBS IN LESS THAN 10 MINUTES. CREW SHUT DOWN ENG, WINDMILL TIME 23 MINUTES. . OPENED NR 2 ENG FAN COWLS. FOUND DAMAGED O-RING AND FLANGE ON SDR CALA2025110911020Slide · unpackedDOOR 1L SLIDE MATERIAL IS HANGING FROM BOTTOM OF DOOR. REINSTALLED EXCESS HANGING SLIDE MATERIAL. OK FOR CONTINUED SERVICE. REF AMM 25-66-01/401 VERIFIED RII REQUIREMENTS FOR 1L SLIDE REINSTALL PER GMM 09-25-05 & AMM 25-66-01-400-803.SDR CALA2025110911019Girt Bar · excess playDOOR 1R GIRT BAR FLAP HAS EXCESS MATERIAL. REINSTALLED EXCESS HANGING SLIDE MATERIAL. OK FOR CONTINUED SERVICE. IAW AMM 25-66-01/401. VERIFIED RII REQUIREMENTS FOR 1R SLIDE REINSTALL PER GMM 09-25-05 & AMM 25-66-01-400-803.SDR CALA2025110911018Actuator · faultedDOOR FLIGHT LOCK 3L EICAS STATUS, NR 3 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMENT. FOUND MX MESSAGES ON MAT NOT ACTIVE UPON ARRIVAL. RAN DOOR FLIGHT LOCK GROUND TEST ON MX MAT AND ALL DOORS LOCKED EXCEPT DOOR 3L. VERIFIED DOSDR CALA2025110911013Light Sys · malfunctionedFAS REPORT EMERGENCY LIGHTS CAME ON DURING T/O FOR A FEW MINS THEN SHUT OFF. EMERGENCY LIGHTS OPS CHECKED GOOD IAW AMM 33-51-00-720-801.SDR CALA2025110911012Warning Message · false activationEMERGENCY LIGHT TEST FAULTS 'EPSU BATTERY AFT L'. PREFORMED OPS CHECK OF EMERGENCY LIGHT IAW AMM 33-51-00-710-001-A. TEST PASS. NO FAULT FOR EPSU BATT AFT L.