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 AALA202507255446Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTANDENT SEAT BY L2 AFT SERVICE DOOR OUTBOARD HAS ONE EACH FLASHLIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202507185446): REMOVED AND REPLACED FLIGHT ATTANDENT AFT SEAT FLASHLIGHT. PER AMM 25-64-00.SDR AALA202507241913Bracket · looseAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EMERGENCY EXIT DOOR FRAME BRACKET LOOSE AT TOP OF OPENING. REATTACHED EMERGENCY DOOR BRACKET TO THE DOOR FRAME. PER AMM 52-22-00.SDR JJBA20250723086Gusset · corrodedLH GUSSET BTW FR 59-61 FOUND CORRODED. LH GUSSET BTW FR 59-61 FOUND CORRODED OUT OF LIMIT. LH GUSSET BTW FR 59-61 REMOVED AND REPLACEDSDR JJBA20250723085Shear Tie · corrodedSHEAR CLIP AT FR 58 AND BTW STR 20R-21R FOUND CORRODED. SHEAR CLIP AT FR 58 AND BTW STR 20R-21R REMOVED AND REPLACEDSDR AALA202507236104Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK ON H1 AND H3 INTERCOSTAL FITTING LOC. FR 16 AT LEVEL DOOR STOP FITTING 7 LH SIDE FWD GALLEY AREA, CRACK LENGTH L=0.102 INCH. MAINTENANCE REPLACED INTERCOSTAL FITTING LOC. ON FR 16LH AT LEVEL DOOR STOP 7, FWD GALLEY AREA I.ASDR VNAA2025072311101Duct · leakingL BLEED DUCT CAUTION MSG IN FLIGHT. / UPON LEAK CHECK FOUND LEAK AT LH CONNECTOR DUCT FWD OF FLOW CONTROL VALVE AND AT APU BLEED AIR CHECK VALVE. REMOVED AND REPLACED CONNECTOR DUCT IAW AMM 36-19-03-000/400. PERFORMED LEAK TEST IAW AMM 36-10-00-790-801. LEAK SDR DALA2025072305523Wire · brokenSHIP 3262, BROKEN EXPOSED WIRING AT ROW 24 DEF. REPAIRED EMERGENCY PATH LIGHTING WIRING AT ROW 24DEF IAW A320 AMM 20-90. (LP: 7455352)SDR SWAA2025072292313Fuse · blownEMERGENCY EXIT INDICATOR L1208 AND L1207 ARE INOPERATIVE. REPLACED FUSE ON EMEREGENCY PACK M1694 FOR EXIT INDICATOR L1208 AND L1207; PERFORMED GOOD TEST PER AMM 33-51-06-960-801.SDR YENA2025072200745Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER INB FASTENER HOLE DOOR STOP FITTING #1 FR 68 LH. CRACK DIRECTION 12 OCLOCK. CRACK D= 0.160 INCH; (RESOLVED ON W/O: 1396415 TASKCARD: NR-00049) REF AEROMAN WO 2025 187/1 NR 2025-367243 PERFORMED PERMANENSDR AALA202507225665Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: AFT RIGHT HAND DOOR EMERGENCY EXIT SIGN DOES NOT ILLUMINATE RECONNECTED EMERGENCY LIGHT CONNECTOR. OPS CHECK GOOD. AMM 33-51-00.SDR YENA2025072200743Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE 3 (LOWER/INBOARD POSITION) LOCATED AT FR16 LH, DOOR STOP FITTING 1. AT PASSENGER CABIN. CRACK DEPTH = 0.080 INCHES, CRACK DIRECTION: 7 OCLOCK; (RESOLVED ON W/O: 1396415 TASKCARD: NR-00032) REF ASDR YENA2025072200742Skin · dentedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON LOWER INB FASTENER HOLE DOOR STOP FITTING #1 FR 68 LH. CRACK DIRECTION 12 OCLOCK. CRACK D= 0.160 INCH; REF AEROMAN WO 2025 187/1 NR 2025-367243 PERFORMED PERMANENT REPAIR LOCATED ON FRAME 68, LT SIDE AT LEVESDR YENA2025072200741Doubler · corrodedDURING HEAVY MAINTENANCE: REAR FUSELAGE, FR 75-76 & S32-36L, FWD HALF OF THE WASTE ACCESS DOUBLER CORROSION. REFERENCES: AIRBUS CANADA REO 500-53-61-1980 REV -- AVIANOR DAMAGE REPORT JB-3118-C01-3018 REV 00. DESCRIPTION: DURING THE CURRENT (06/2025) C1 CHECK SDR YENA2025072200740Doubler · corrodedDURING HEAVY MAINTENANCE: WASTE ACCESS DOUBLER FOUND CORRODED AT FWD RH CORNER; (RESOLVED ON W/O: 1388309 TASKCARD: NR-00062) REFERENCE AVIANOR WO JB-3118-C01 NRC 3018. WASTE ACCESS DOUBLER FOUND OUT OF LIMITS IAW ASRP BD500-A-J53-61-01-04AAB-661A-A DOUBLER RESDR CALA2025072206839Skin · damagedPER ECRA 5360-01825 REV C STEP 4, INITIATE DIP FOR PERMANENT REPAIR. ( REF L/P 8387154) "ACCOMPLISH A PERMANENT REPAIR TO THE SECTION 46 SKIN BETWEEN BS 827 & BS 867/ S-25R & S-26R REPAIRED AREA AS PER PART 3 OF THE LATEST REVISION OF ECRA 5360-01825.SDR SWAA2025072192320Seat · out of limitsCABIN SEAT 13D (EXIT ROW ) SHOULD NOT RECLINE. ADJUSTED SEAT RECLINE AT CABIN SEAT 13D IN REFERENCE TO AMM 25-22-00.SDR SWAA2025072192344Flashlight · no testAFT GALLEY CAPTAINS SIDE FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED LFT AFT INBD FLASHLIGHT PER AMM 25-64-00. THIS CLEARS MEL 25-12-01.SDR SWAA2025072192364Sign · detachedF/A REPORTS BACK COVER OF OVERWING EXIT SIGN HAS FALLEN OFF. SIGN SECURED OK TO CONTINUE ON TLD PER EA M-24-133-00396SDR SWAA2025072192658Light · dislodgedCENTER AISLE OVERWING EXIT LIGHT. DISLOGED AND HANGING. RESECURED OVERHEAD EMERGENCY EXIT LT ASSY PER AMM 33-51-01.SDR SWAA2025072192254Handle · looseFWD GALLEY SERVICE DOOR ASSIST HANDLE LOOSE. RE SECURED FWD GALLEY SERVICE DOOR ASSIST HANDLE REF AMM 20-50-11.SDR MTNA20250721001Frame · crackedDURING COMPLETION OF NDT TASK ATR-A-53-57-XX-03001-350A-A, FOUND SUBSURFACE CRACK IN HOLE #8 AS IDENTIFIED IN FIGURE ICN-ATR-A-535700-A-FB429-06PSI-A-001-1 (SHEET 1), THIS IS AT STATION 12791/FR27 ON THE LH SIDE
CRACK EXTENDS AFT FROM THE CENTER OF THE HOLE ASDR GTIA2025072138995Unknown · odorROTTEN EGG SMELL REPORTED AFT CABIN BY THE FAS ISOLATED PACK 2 ODOR WENT AWAY FOR ABOUT 40 MINS. THE SMELL CAME BACK, PROCEDING TO ISOLATE PACK 1, SMELL DISSIPATED FOR A FEW MINS. EVENTUALLY ODOR CAME BACK SO WE PERFORMED THE AIR PACK 1+2 PROCEDURE AND DESCENDSDR JJBA20250721071Shear Tie · crackedSHEAR TIE CRACKED AT FRAME 80 BETWEEN STR 4L AND 6L. REMOVED CRACKED SHEAR TIE. LOCATED, DRILLED AND INSTALLEDSDR DALA2025072105465Skin · corroded(LOG 1090759) CORROSION ON UPPER/LOWER SKIN OF RH SIDE PLATE BTW STA 887-907 RBL 20.0 AT AFT CARGO COMPARTMENT (C2). NEW SIDE PLATE WAS MANUFACTURED PER BOEING DWG 147A7501 REV B AND WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025072105464Plate · corroded(LOG 1090743) CORROSION ON LH SIDE PLATE FROM STA 727 TO STA 727B +7, FROM STA 727B +7 TO STA 727G +13 AND STA 727G+13 TO STA 847 AT AFT CARGO COMPARTMENT. NEW FLOOR SPLICE STRAP WAS FABRICATED PER DWG BAC1505-100581 REV: (-) AND WAS REPLACED PER B737-800 SRM SDR DALA2025072105463Plate · corroded(LOG 1090695) CORROSION ON LH SIDE PLATE FROM STA 727 TO STA 727B +7, FROM STA 727B +7 TO STA 727G +13 AND STA 727G+13 TO STA 847 AT AFT CARGO COMPARTMENT. SIDE PLATE LH ON FROM STA 727 TO STA 847 WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025072105462Stringer · corroded(LOG 1090414) CORROSION ON STRINGERS (6 EA) STA 767 + 6, FROM RBL 8 TO LBL 17 AT AFT CARGO COMPARTMENT. STRINGERS (5 EA) STA 767 + 6, FROM RBL 8 TO LBL 12.5 AT AFT CARGO COMPARTMENT WERE REPAIRED PER B737-800 SRM 53-00-53-2R PROCEDURE 2 REPAIR 2 AND STRINGER (SDR DALA2025072105461Floorbeam · corroded(LOG 1090403) AFT CABIN FLOOR STRUCTURE HAS CORROSION ON UPPEER SURFACE, STA 947 LBL 52. ACCOMPLISHED MAIN CABIN FLOOR BEAM REPAIR AT STA 947 FROM RBL 9'' TO RBL 60'' IAW B 737 SRM 53-70-51-2R-5.SDR DALA2025072105460Support · corroded(LOG 1090110) RT SIDE AFT CABIN FLOOR DRAIN SUPPORT HAS CORROSION ON UPPER SURFACE, STA 959 RBL 49. REMOVED AND REPLACED INTERCOSTAL AT MAIN CABIN STA 967 RBL 49 IAW B 737 SRM 51-40-02.SDR DALA2025072105459Strap · corroded(LOG 1089936) MAIN CABIN AFT WET AREA HAS CORROSION ON UPPER SURFACE STA 1016 RBL 17. REMOVED AND REPLACED MAIN CABIN AFT WET AREA UPPER SURFACE (STRAP) AT STA 1016 RBL 17, IAW B 737 SRM 51-40-02.SDR DALA2025072105458Seat · unsecure(LOG 7391466) SEAT LOOSE IN TRACK 31ABC. SECURED SEAT REF B737 AMM 25-22SDR DALA2025072105450Light · inoperativeLT AFT OVERWING EMERGENCY LIGHT INOP. R/R LT AFT OVERWING EMERGENCY LIGHT PER A220 AMP 33-55. OPS GOOD OKAY FOR SVC. (LP# 7397144)SDR DALA2025072105449Skin · corrodedCORROSION FOUND ON EXTERNAL SKIN FR79, AFT LAP JOINT, STRINGER 36 TO 37L. BLENDED CORROSION ON EXTERNAL SKIN @ LAP JOINT FR 79, STGR 36R- 36L IAW A220 ASRP 31-21-06-01. FOUND OUT OF LIMITS IAW A220 ASRP 53-61-01. RESTORED FINISH TO AFFECTED AREA IAW ERA 627700SDR DALA2025072105448Skin · corrodedCORROSION FOUND ON EXTERNAL SKIN FR77 TO FR78 AROUND STRINGER 36. BLENDED OUT CORROSION ON EXTERNAL SKIN @ FR 77-78 @ STGR 36 IAW A220 ASRP 51-21-06-01AAA. FOUND OUT OF LIMITS IAW A220 ASRP 53- 61-01. RESTORED FINISH TO AFFECTED AREA IAW ERA 627700-14 REV. O PSDR DALA2025072105446Seat Track · corrodedFOUND CORROSION ON SEAT TRACK AT FR74 LBL23. REMOVED AND REPLACED SEAT TRACK FROM FR62 TO FR74 LBL23 IAW A220 ASRP BD500-J51-42-21-00AAA-078A-A AND BOMBARDIER DWG# C01342701 REV-G. (LP# 1090283)SDR DXTA2025072104287Acm · smokeDURING CLIMB AT 1500 FEET AND AFTER SWIRCHING THE BLEEDS FROM APU TO ENGINES, WE SAW SMOKE COMING OUT OF ALL VENTS IN THE COCKPIT AND SMELLED WHAT WE BELIVE IS ENVIRENMENTAL SMOKE. WE DECLARED AN EMERGENCY AND LANDED ABIUT 10 MINUTES LATER. THE TEMPERATURE IN SDR DXTA2025072104286Control Unit · faultedFIRE DETECT CH B - BATT - TRIP CAME ON IN FLIGHT ON EMS. ATTEMPTED RESET ON BATTERY POWER ON THE GROUND. BUT DID NOT RESET. REMOVED FIDEX AND INSTALLED INSPECTED/TESTED FIDEX CU IAW AMM 26-10-01. COMPLIED WITH OPERATIONAL TEST OF THE FIRE DETECTION AND EXSDR CALA2025072106797Pcb · faultedLOST AIR DRIVEN PUMP ON TAKE OFF-AIR PRESSURE LIGHT ON WITH SWITCH POSITION AT ON OR AUTO. PER CREW UPDATED ON TAKE OFF GEARS SELECTED HYDRAULICS PRESSURE WENT TO LOW , CREW FOLLOWED CHECKLIST FOR EICAS MESSAGES. ADP SWITCH AUTO TO ON PRESSURE LIGHT ON THE SDR CALA2025072106796Proximity Sensor · faultedFLAPS LE TRANS LIGHT DID NOT GO OUT ON DEPARTURE W FLAPS UP. SLATS NR 8 LIGHT WAS ON. LE SLAT 8 INBOARD SENSOR SIGNAL DOES NOT AGREE WITH OTHER LE SLAT INBOARD SENSOR SIGNALS. MAINT MSG 27-81215. CAPTURED ON 6 OF LAST 7 LEGS. CYCLED FLAPS AND COULD NOT REPSDR CALA2025072106776Battery Pack · no testEMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK. M1670 BATTERY PACKS FAILS FUNCTION CHECK REPLACED EMERGENCY LIGHT BATTERY PACK M1670. OP CKS GOOD. MM 33-51-06-960-805.SDR CALA2025072106775Battery Pack · no testEMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK. M1668 BATTERY PACKS FAILS FUNCTION CHECK REPLACED EMEGENCY LIGHT BATTERY PACK M1668. OP CKS GOOD. MM 33-51-06-960-805.SDR CALA2025072106774Battery Pack · no testEMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK. M1673 BATTERY PACKS FAILS FUNCTION CHECK REPLACED EMERGENCY LIGHT BATTERY PACK M1673. OP CKS GOOD. MM 33-51-06-960-805.SDR CALA2025072106773Battery Pack · no testEMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK. M1672 BATTERY PACKS FAILS FUNCTION CHECK REPLACED EMERGENCY LIGHT BATTERY PACK M1672. OP CKS GOOD. MM 33-51-06-960-805.SDR CALA2025072106772Battery Pack · no testEMERGENCY LIGHTING SYSTEM FUNCTIONAL CHECK. M1669 BATTERY PACKS FAILS FUNCTION CHECK REPLACED EMERGENCY LIGHT BATTERY PACK M1669. OP CKS GOOD. M.M. 33-51-06-960-805.SDR CALA2025072106750Skin · scratchedLEFT FUSELAGE SKIN APPOX. STA 418 TO STA. 428. HAS SCRATCH IN SKIN BETWEEN STR.17L AND 18L. FWD OF TAT SENSOR. REF LOG PAGE 5581101 BLENDED, REMOVED DAMAGE REF SRM 51-10-02. NEEDS HFEC INSP FOR CRACKS AND ULTRA SOUND INSP. FOR MATERIAL LOSS. REF SRM 53-00-01-SDR CALA2025072106748Skin · dentedPERFORM PERMANENT REPAIR AT THE FUSELAGE SKIN. DENT IS LOCATED 11" BELOW THE AFT CARGO DOOR BETWEEN STR24R AND STR25R AT APPROXIMATELY STA830 REF TO LP 8387154 (REF: AAR NR 1000038586) PERMANENT REPAIR ACCOMPLISHED AT FUSELAGE SKIN DENT IS LOCATED 11" BELOW AFSDR CALA2025072106747Skin · damagedREMOVE AND REPLACE FWD CARGO DOOR EXTERIOR SKIN AS REF AAR N/R 9983191 REMOVED AND REPLACE FORWARD CARGO DOOR SKIN REF DWG 143A6110, SRM 52-30-01-2R-3 AND SRM 51-40-02-0G-0. REMOVED AND REPLACED FWD CARGO DOOR EXTERNAL SKIN PER SRM 51-40-02-0G-0 SRM 52-30-01-SDR UIEA2025071700966Oxygen Box · openROW 17 SEAT H/K OXYEGEN MASK OPENS ON LANDING.(<P>ADJUSTED THE LATCH ON THE OXYGEN MODULE IN THE PSU AT LOCATION 17 H/K. OPS CHECK NORMAL IAW B767 AMM 35-21-00. THIS CLEARS DMI 234377, PLACARD REMOVED. </P>)SDR DALA2025071905438Cover · detachedAIRCRAFT 5642, CABIN ENTRY DOOR AT 2L NEED EXIT LIGHT PANEL COVER POPPED OFF. RESECURED COVER. (LP 7344762)SDR HALA20250717039Smoke Detector · false activationSMOKE LAVATORY SMOKE MESSAGE CONFIRMED WITH FA FALSE ALERT. FFA DID RESET AND MESSAGE CLEARED. NO SMOKE/VAPE/FIRE PRESENT