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 DALA2025082806353Seat Track · corrodedAIRCRAFT 3767, CORROSION ON SEAT TRACK RBL 24.75 BTW STA 520 THICKNESS CROWN IS 0.188" AND MINIMUM REMAINING THICKNESS CROWN IS 0.050" THEREFORE AREA OUT OF LIMITS PER B737-800 SRM 53-00-52-1A PROCEDURE 1 ALLOWABLE DAMAGE 1, PAR. 4. A (2) (A) FIG.103 DETAIL A.SDR SWIA2025082700005Door · dentedCOMPLY WITH SCHEDULED MAINTENANCE CODE: RA99531-ETD2025-170-906479 MXCODEID110241-PR - COMPLY WITH PERMANENT REPAIR ON RA ID: 99531CATERING HIT THE AIRPLANE TOO HARD AS THEY PULLED UP TO THE AFT PASSENGER DOOR. COMPLY WITH ETD 2025-170-906479 PERMINANT REPAISDR SWAA2025082708034None · noneFLIGHT ATTENDANT REPORTED CHEMICAL SMELL IN CABIN. C/W CONDITIONAL INSPECTION IAW AMM 05-51-56 WITH NO DEFECTS OR ODORS NOTED. A/C OK FOR SERVICE.SDR SWAA2025082708386Knob · missingCREW REPORTS AFT MEGAPHONE IS MISSING THE KNOB. REMOVED AND REPLACED AFT MEAGAPHONE IAW AMM 25-64-00SDR SWAA2025082708381Slide · out of positionFWD GALLEY DOOR SLIDE NEEDS TO BE REPOSITIONED. REPOSITIONED FWD SERVICE DOOR SLIDE PER MM 25-66-01 AND MT 725-61-06. OK FOR SERVICE.SDR SWAA2025082708098Power Supply · inoperativeEMERGENCY LIGHTS AT ROWS 3 AND 6 DEF INOPERATIVE. R & R THE BATTERY PACK AND POWER SUPPLY M01674 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR SWAA2025082708376Cover · detachedEXIT LIGHT COVER ON FO SIDE OVER WING EXIT FELL OFF. SECURED THE COVER IAW AMM SIP.SDR SWAA2025082708003Lamp · inoperativeRIGHT AFT OVERWING EMERGENCY EXIT LIGHT LAMP OUT. RELAMPED RT AFT OVERWING EMERGENCY EXIT LIGHT IAW AMM 33-51-04.SDR SWAA2025082708038Sign · detachedOVERHEAD EXIT SIGN BETWEEN ROWS 15 AND 16 FELL FROM CEILING. REINSTALL OVERHEAD EXIT SIGN AS PER AMM 33-51-00. REINSTALLED OVERHEAD EXIT SIGN IAW AMM 33-51-01.SDR SWAA2025082708028Lens · damagedEMERGENCY LIGHT LENS NEAR AFT LIFE RAFT IS DAMAGED. REMOVED AND INSTALLED NEW EMERGENCY LIGHT LENS PER SIPSDR N6WA2025082710Beam · corrodedBULKHEAD BEAMS AT FS693 LBL9 AND RBL9 HAS CORROSION ON TOP FLANGE EDGES. REMOVED AND REPLACED BEAMS AT FS693 LBL9 AND RBL9 IAW CRJ SRM 51-42-06SDR N6WA2025082709Beam · corrodedBULKHEAD BEAM AT FS847 LBL9 HAS CORROSION ON TOP FLANGE EDGES. REMOVED AND REPLACED LBL9 BULKHEAD BEAM AT FS847 IAW CRJ SRM51-42-06 AND SRM 51-42-21SDR WX0A2025082732551Unknown · odor(AIRCRAFT NOT GROUNDED) DIRTY SOCK SMELL IN CABIN AND FLIGHT DECK ON DESCENT / PERFORMED AMM 21-00-00-615-803-B REMOVAL OF THE CONTAMINATION OF THE ECS, NO FAULTS NOTED AND NO SMELL DETECTED. THIS CLEARS MEL 21-52-01-G, CAT C, MDDR#218679 'M' PROCEDURE REVERSESDR N6WA2025082708Angle · corrodedCORROSION ON ANGLE AT FS909-FS393 LBL17.63 OF WING TO FUSELAGE FAIRING STRUCTURE. REMOVED AND REPLACED ANGLE ON FS909-FS393 LBL17.63 IAW CRJ SRM 51-42-06SDR AALA202508279305Oil System · emptyAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: APU FAILED IN FLIGHT COULD NOT PROVIDED ENOUGH ELECTRICAL POWER WITH AN ENGINE GENERATOR ALREADY ON MEL. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT MIA.PARTIAL WORK ACCOMPLISHED BITE CHECK OF THE ECU FOUNSDR VNAA2025082711102Tire · blownRTF-NO 2 MLG TIRE BLOWN ON TO. REMOVED AND REPLACED LIB MAIN TIRE IAW CRJ AMM 32-41-01-000-801-A01-PSA.SDR DXTA2025082704720Light · intermittentLAV FLOOR EMERGENCY LIGHT ILLUMINATES ONLY INTERMITTENTLY. LAV EMER LIGHT STRIP INTERMITTENT: REMOVED LIGHT STRIP AND INSTALLED ABOVE UNIT. OPS CHECKS GOOD. IAW AMM 33-50-00.SDR DXTA2025082704721Battery Pack · malfunctionedIN THE ARM POSITION, EMER LIGHTS ON/FLASHING DURING FLIGHT. REMOVED AND REPLACED ELB FWD AND AFT.SDR DXTA2025082704724Battery Pack · malfunctionedDURING CRUISE FLIGHT, NOTICED ALL CABIN EMERGENCY LIGHTS TURNED ON AND A FEW MINUTES LATER, TURNED OFF EXCEPT RED LIGHT LEADING TO THE MAIN CABIN DOOR WHICH CONTINUE BLINKING FOR THE DURATION OF THE FLIGHT. REMOVED AND REPLACED ELB'S #1 AND #2 PN 7450LS-00 RSDR CALA2025082708192Floor Support · corrodedFWD CARGO COMPT, FRAME 28 STR33 LH TO 33 RH FLOOR PROFILE PANEL HAS CORROSION. REMOVED AND REPLACED FWD CARGO PROFILE PANEL AT FR28 STR33 LH TO 33 RH IAW A320 SRM 51-42-11.SDR CALA2025082708191Floor Support · corrodedAFT CABIN WET AREA FLOOR BEAM Y765 FR 66-70 L/H HAS CORROSION. REMOVED CORRODED FLOOR BEAM AND REPLACED WITH NEW FLOOR BEAM AT Y765 FR 66-70 LH IAW A320 SRM 51-42-11/001.SDR CALA2025082708190Floor Support · cracked2 EA CRACKS AT FWD WET AREA INTERCOSTAL BETWEEN FLOOR SUPPORTS STA 312 AND STA 328 RBL 31 APROX MKD 252-012 (REF AAR N/R 99949067) REMOVED AND REPLACED INTERCOSTAL FROM STA 312 TO STA 328 RBL 45 AS PER B737-800 SRM 51-40-02-0G-0 AND DWG# 141A5400.SDR CALA2025082708170Light · inoperativeRIGHT AFT OVERWING EXTERIOR EMERGENCY LIGHT OUT RELAMPED. RH AFT OVERWING EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECKED GOOD.SDR CALA2025082708169Light · detached14C EMERGENCY EXIT GUIDE LIGHT IS DANGELING DOWN TOWARD THE AISL E. REMOVED EMERGENCY PATH LIGHT HOUSING DUE TO ITBEING BROKEN. NO LIGHT AT 14C. ALL OTHER LIGHTS OK. REQUEST TO PLACE ON MEL. MEL 3319E ALL LIGHTS WITHIN TWO SEAT ROWS OF THE TYPE III EXIT (OVERWSDR CALA2025082708161Unknown · odorSTRONG FUEL/HYD SMELL DEBRIEF CREW. THEY SAID THEY HAD A STRONG SMELL IN COCKPIT WHEN ENGINES SHUT SMELL WENT AWAY. THE F/A ONY ONE SMELLED SOMETHING WASN'T SURE WHAT IT WAS. CAM ABOARD THE PLANE DID NOT NOTIVED ANY SMELL.SDR CALA2025082708160Engine · bird ingestionPOTENTIAL SMALL BIRD STRIKE IN ENG PRIOR TO ROTATION. BRIEF ODOR OB SERVED. ENG IND NORMAL PERFORMED BIRD STRIKE INSPECTION AS PER AMM 05-51-18. FOUND NO EVIDENCE OF BIRD STRIKE. CREW VERBALLY STATED THAT THERE WAS A STRANGE SMELL/ ODOR ON TAKE OFF ROLL. ALL ESDR HALA20250826262Wire Harness · faultedETOPS - ENG 1 LOOP B FAULT. REPLACED ENG 1 LOOP B FIRE HARNESS PER A321 AMM 26-12-62 OPS CHECK GOOD , OK FOR SERVICESDR DALA2025082606342Stop Fitting · deterioratedDETERIORATED DOOR STOP PASSENGER CREW DOOR 842 POSITION 3, 4, 5, 6, 7 FWD SIDE AND 5, 6, 7 AFT SIDE. R/R DOOR STOPS AT PASSENGER CREW DOOR 842. POSITIONS 3,4,5,6,7 FWD SIDE, AND 5,6,7 AFT SIDE AS PER A320 FAM AMM 52-13-31-000-002-A AND AS PER A320 FAM AMM 52SDR AALA202508266352Stator · faultedAIRCRAFT WAS GROUNDED: ENG 1 FADEC ALTERNATOR FAULT. DECESION MADE TO RETURN TO CLT, NO EMERGENCY DECLARED AIRCRAFT LANDED WITHOUT INCIDENT. T/S IAW TSM 77-10-00-810-839-A FOUND THAT PREVIOUS TROUBLESHOOTING SHOWS HARNESS TO BE GOOD. SAME FAULT RETURNED, FOUNDSDR YENA2025082600880A/C Pack · odorFLT#373, BOS-AUA. PERSISTENT OIL SMELL ODOR ROW 20 AND AFT WITH PACK 1+2 ON ( PACKS ); COMPLIED WITH INFORMATION NOTICE 2017-T015, SECTION B2. IDENTIFIED ODOR TO APU (FOUND OIL IN INLET, LOAD COMPRESSOR & DRAIN). DECONTAMINATION LEVEL "A" WAS ACCOMPLISHED PESDR DALA2025082606340Pump · faultedRETURNED TO HND DUE TO LEFT ENGINE OIL QUANTITY AT ZERO. OIL PRESSURE AND TEMPERATURE GOOD. R & R LEFT ENGINE OIL PUMP AND SCAVENGE FILTER. SERVICED LEFT ENGINE OIL TANK. (LP# 7295079)SDR YENA2025082600879A/C Pack · odorFLT 2104, BOS-BOS. IMMEDIATALLY AFTER TAKE OFF, THE FLIGHT SMELLED ABNORMAL FUMES. CONTACTED DX MTC TO DISCUSS, MTC ADVISES TO SWITCH PACKS ON - OFF TO ISOLATE. DETERMINED IT WAS FROM PACK 2. AIR RETURN DUE TO ETOPS RESTRICTION, COMPLIED WITH INGO NOSDR UIEA2025082501135Oxygen Bottle · detachedCREW WALK AROUND, O2 BOTTLE BROKE OFF THE WALL. REATTACHED O2 BOTTLE BRACKET IAW AMM 20-30-01. NO FURTHER DEFECTS NOTED.SDR UIEA2025082501141Oxygen Bottle · emptyFOUND CREW OXYGEN BOTTLE IS ZERO PSI. R & R CREW OXYGEN CYLINDER, VALVE ASSY AND IND AND LEAK CHECK OK PER AMM 35-12-15-08.SDR 2025F00202Seal · brokenPILOT REPORTED THAT AFTER LANDING, WHEN IN LANDING ROLL BRAKING, HE EXPERIENCED A RIGHT BRAKES LOSS BUT WAS ABLE TO STOP THE AIRCRAFT. WHEN PERFORMING A 180 TURN TO TAXI BACK TO THE TERMINAL, THE LEFT BRAKES LOOSE EFFECTIVENESS CAUSING LOSS OF DIRECTIONAL CONSDR AALA202508266682Battery · no testAIRCRAFT WAS GROUNDED: EMERGENCY POWER SUPPLY UNIT 11WL FAILED SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 11WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.SDR AALA202508265607Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS AT SEAT 5A INOPERATIVE. MAINTENANCE RE-SECURED THE EMERGENCY EXIT LIGHT AT SEAT 5A AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-18.SDR AALA202508263880Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202508263975Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-00.SDR AALA202508268184Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202508262999Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTED THAT THE 2R DOOR ARM HANDLE IS LOOSE. MAINTENANCE TIGHTENED ARMING HANDLE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-22-22.SDR FDEA202508251536Skin · damagedPREVIOUS REWORK ON FUSELAGE SKIN, BTW STA 522 AND 544, AT STG 39R FUSELAGE SKIN, BTW STA 522 AND 544, AT STG 39R DAMAGE WAS REPAIRED I.A.W. SRM 53-00-01- 2R FIG 201 REP 29 SHEET 9 REV 92 APR 15, 2025SDR REXA2025082600837Fitting · out of limits"ON THE RH AILERON, FOUND BOTH CENTER UPPER LUG BORE DIAMETERS TO BE OUT OF LIMITS. IB LUG IS .986"" AND OB LUG IS .985"", NOMINAL LIMIT IS .975 +- .0005 REPAIRED OVERSIZED BORES AND PITTING CORROSION TO THE AILERON ACTUATOR CENTER HINGE FITTING LUGS AT AIL STSDR REXA2025082600836Lug · corrodedTHE L/H AILERON PCU LUG L2 HAS CORROSION INSIDE THE BORE FOR THE BUSHING COMPLIED WITH REPAIR TO RTM AILERON CENTRE HINGE FITTING LUGS IAW BOMBARDIER REO 670-57-61-237 REV-- DATED 2017-07-25.SDR ABXA20250825198Warning Message · activatedDURING TAXI, STAB TRIM MESSAGE BEFORE TAKE-OFF. AIRCRAFT RETURNED TO BLOCKS (BTB). DEFERRED IAW MEL 27-41-2. MTX PROCEDURES CW. PLACARD INSTALLED. SEE LP 39094-01/2 FOR RALM DOWNGRADE. AIRCRAFT RETURNED TO SERVICE.SDR BAGA2025082600008Floorbeam · corrodedFWD PASSENGER DOOR LOWER BEAM CORRODED BY GIRT BAR FITTINGS. REPLACED FWD PAX DOOR LWR BEAM.SDR AALA202508261164Slide · dislodgedAIRCRAFT WAS GROUNDED: RIGHT AFT ENTRY DOOR SLIDE HOUSING SEPARATING FROM DOOR. REMOVED AND REPLACED ESCAPE SLIDE PACK COVER. PER AMM 25-66-01-400-803.SDR AALA202508260809Megaphone · malfunctionedAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTANDENTS REPORTS MEGAPHONE HAS MADE A SQUEALING SOUND AND MAY NOT BE OPERATING CORRECTLY. INSTALLED NEW BATTERIES, OPERATIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202508263408Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO SLIDE OPEN. LUBRICATED LAVATORY-D DOOR HINGES. PER AMM 25-40-14.SDR AALA202508261960Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT OVERWING EMERGENCY EXIT LIGHT NOT ILLUMINATING. RELAMPED THE LEFT HAND AFT OVERWING EMERGENCY EXIT LIGHT. PER AMM 33-51-04.