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 SIMA20251225001Battery Pack · inoperativeFWD ENTRY DOOR EMRGENCY LIGHT INOP RAR FWD ENTRY DOOR EMERGENCY/COURTSEY LIGHT ASSY IAW AMM 33-26-01/400. OPS CHECK BAD. NO FIX. R & R FWD LH EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01/400. OPS CHECK GOOD AT THIS TIME.SDR YENA2025122601268Unknown · odorFLT 570 MCO- RIC, AIRCRAFT N784JB OPERATING FLIGHT 570 MCO-RIC REPORTED A CABIN ODOR EVENT. THE FLIGHT CREW REPORTED THAT ON DESCENT BELOW 10,000 FT TO ABOUT 5000 FT, THE COCKPIT RECEIVED FUMES. SMELL DISAPPEARED BUT THEN REAPPEARED ON TAXI IN TILL ENGINES SHUSDR SCNA20251226507Flashlight · inoperativeFLIGHT ATTENDANT EMERGENCY FLASHLIGHT AT DOOR 2R INOP ( EMERGENCY FLASHLIGHT HOLDERS/ FLASHLIGHTS; CABIN ) (IN PROGRESS)SDR DALA2025122609409Engine · odorAFTER STARTING RT ENG WITH AIR START CART, SMELLED DIRTY SOCK ODOR, STARTED LEFT ENGINE SMELL WORSENED RAN QRH FOR SMOKE FIRE FUMES NO NOTICEABLE CHANGE ISOLATED EACH SYSTEM LEFT SEEMS WORSE , SHUTDOWN ALL BLEED AND PACK SOURCE. RAN BOTH ENGINES WITH SNIFFER HSDR DALA2025122609408Pin · inoperativeLEFT OVERWING EMERGENCY EXIT DOOR SLIDE WOULD NOT PIN. PERFORMED SLIDE DEPLOYMENT IAW WC 2561-9005. WILL REQ NEW SLIDE. DURING INSTALL IF NEW SLIDE FOUND CABLE OUT OF RIG. CHECKED RIG PER A220 AMP 52-21 THROUGH STEP F. (203641) RE-RIGGED SHORT CABLE ABD C/W RESDR YENA2025122601262Bypass Valve · warning messageFLT 133 BOS- SFO ( ETOPS). (ECAM INDICATION 3) ON BLEED PAGE B) PACK TURBINE BYPASS VALVE POSITION).; REPLACED ASCS 2 (57HH) PER TECH SUPPORT REQUEST. OPS CHECK GOOD. WORK DONE IAW AMM 21-61-34-400-002-A. MDDR CLOSED, MX-4 UPDATED, PLACARD REMOVED.SDR F3LA202512260340Power Supply · failedDURING HEAVY CHECK, EPSU UNIT 12WL FAILED PTT FLAG UNIT FAULT. NOTE: THIS FAULT WAS FOUND DURING A RON MAINTENANCE VISIT AND DID NOT CAUSE A FLIGHT DELAY. REMOVED AND REPLACED EPSU UNIT (FIN 12WL) IN REF TO AMM 33-51-38-400-001-A. OPS CHECK GOOD.SDR SWIA2026032775582Skin · dentedPROTUDING DENT IN FUSELAGE EXTERNAL SKIN BETWEEN BS 280 TO 295, STGR 24L TO 25L. REPAIRED THE SKIN IAW REO 601R-53-21-3783, REV-, SRM 51-42-06, 51-42-21, & 51-25-01.SDR SWAA2026012755312Bracket · deterioratedDETERIORATED HARDWARE ON THE GIRT BAR FLOOR BRACKETS FOR THE ENTRY DOOR. REPLACED THE HARDWARE ON THE GIRT BAR FLOOR BRACKETS IAW AMM 25-66-02-400-801.SDR SWAA2026012755313Bracket · deterioratedDETERIORATED HARDWARE ON THE GIRT BAR FLOOR BRACKETS. REPLACED HARDWARE ON THE GIRT BAR FLOOR BRACKETS AT THE SERVICE DOOR IAW AMM 25-66-02-400-801.SDR AALA202601278517Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AT AFT LAVATORY VACUUM WASTE VENT AT STA 917 BETWEEN S21L AND S22L. REPAIRED SKIN PER SRM 53-70-01-2R-3 REPAIR 3.SDR SWIA2025122475088Mount · crackedWEATHER RADAR LOWER MOUNTING BRACKET CRACKED. REMOVED AND REPLACED WEATHER RADAR LOWER MOUNTING BRACKET IAW SRM 51-40-08.SDR SWIA2026011900224Crossbeam · corrodedHIDDEN CORROSION DAMAGE FOUND AT 2 SPOTS, ON CROSSBEAM 87, AFTER REMOVAL OF THE LT AND RT AFT WET AREA BEAMS. PERFORMED PERMANENT DOUBLER/FILLER REPAIRS ON CROSSBEAM 87 AT RH AND LH FLOOR BEAM POSITIONS REF ETD2025-170-934768 AND SRM 53-00-10/ REPAIR 03P. SEESDR SWAA2026011955493Web · corrodedCORROSION ON ACD SUB THRESHOLD WEB BETWEEN BS 794- 847, RBL 26. REMOVED AND REPLACED ACB SUB THRESHOLD WEB IAW SRM 51-40-02 AND DWG 146A8340 REV-.SDR SIMA2026011224001Floorbeam · corrodedSSI 53-23-005-0100 CORROSION ON LONGITUDIAL FLOORBEAM Y-273 AT FR 87 (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED CORROSION ON LONGITUDIAL FLOORBEAM Y-273 AT FR 87 IAW SRM 51-10-03. ORIGINAL THICKNESS .040" MATERIAL REMOVED .040" MATERIAL REMAINING 0. PART FOUNSDR SIMA2026011224002Floorbeam · corrodedCORROSION ON LONGITUDIAL FLOORBEAM Y+273 AT FR 87 (MAJOR REPAIR) (LEVEL 2 CORROSION). BLENDED ON FLOORBEAM AT Y+273 AT FR 87 PER EMB 175 SRM 51-10-03. 100% MATERIAL LOST. LOCATED AND DRILLED NEW RH FLOORBEAM PER SRM 51-40-02. RESTORED FINISH TO LONGITUDIAL FLOSDR DXTA2025122906288Power Supply · faultyEMER EMER LIGHT NOT ARM CAS MESSAGE REMAINS ON WITH EMERGENCY LIGHT SWITCH IN ARM POSITION. REMOVED AND REPLACED FWD AND AFT EMERGENCY POWER SUPPLY IAW AMM33-52-01. ALL OPS CHECK GOOD NO CAS MESSAGES PRESENT.FWD E-BATTERY TESTED BY RADIANT POWER CORP., REF.FSDR CALA2026011212865Frame · corrodedAFT CARGO, FLOOR AREA, BS 1460, BTWN STG 29R TO STG 30, FRAME HAS CORROSION. PART FABRICATED IN HOUSE PER DWG146N2063 AND DWG 140N2063. PERFORMED A REPAIR IAW 757-5360-13-A4229 1 THROUGH 9 WITH NO DEVIATIONS EC/RA:5360-02086.SDR CALA2026011212864Frame · corrodedAFT CARGO, FLOOR AREA, BS 1420, BTWN S29L - 28R, FRAME HAS CORROSION. PART FABRICATED IAW DWG 146N5426, REV A. PERFORMED A REPAIR IAW 757-5360-13-A4238 F IGURES 1 THROUGH 12 WITH NO DEVIATIONS EC/RA:5360-02087.SDR SWAA2026010855439Skin · crackedNR 4 SLAT HAS CRACKED LOWER TRAILING EDGE SEAL. REMOVED & REPLACED NR 4 SLAT LOWER FLEX SKIN IAW SOPM 20-50-01.SDR SWAA2026010655448Lamp · inoperativeR2 OUTSIDE EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED R2 OUTSIDE LAMP, OPS CHECKED GOOD IAW AMM 33-51-04-960-801.SDR AALA202601056931Fmc · abnormalAIRCRAFT WAS NOT GROUNDED: WHILE DESCENDING IN VNAV FROM FL280 TO FL 220 THE AIRCRAFT DID AN UNCOMMANDED LEVEL OFF AT FL 240 (THERE WERE NO RESTRICTIONS TO MAKE THE PLANE LEVEL OFF). LATER IN THE FLIGHT WHEN AT FL220 TRYING TO DESCEND TO 11000FT, PASSING THROUSDR HNAA2026010500003Support · corrodedLEFT SUPPORT CORRODED AT BTW FR 60-65. R & R THE SUPPORT IAW SRM 51-40-02SDR SCNA20260105005Skin · ground damageCATERING TRUCK RAILING MADE CONTACT AFT OF L2 DOOR. REPAIR DAMAGE ON FUSELAGE SKIN AT FS 1006 TO FS 1016 BETWEEN STR 14L TO 15L IAW SRM 53-70-01-2R-5, REPAIR 5, ALTERNATIVE 3.SDR SCNA20251231514Skin · ground damageCATERING TRUCK RAILING MADE CONTACT AFT OF L2 DOOR. REPAIR THE DAMAGE ON FUSELAGE SKIN AT BS 1006 TO 1016 BETWEEN STR 14L TO 15L IAW SRM 53-70-01-2R-5, REPAIR 5, ALTERNATIVE 3.SDR DALA2025123109560Spar Web · crackedA CRACK WAS FOUND ON THE NR 1 PYLON AFT MID SPAR WEB. REPAIRED PER ER/A 74-630868. (1368070)SDR SWIA2025123100024Windshield · crackedNOTICED CRACK IN CAPTAIN`S WINDSHIELD ON CLIMB OUT. FOLLOWED SHORTLY BY L WINDOW HEAT AND L WSHLD HEAT CAUTION LIGHTS. FOLLOWED SHORTLY BY A POP AND WSHLD SHATTERING. (FLIGHT 3636) REMOVED AND REPLACED CA WINDSHIELD IN REFERENCE TO AMM 56-11-01. OPS CHECK OF SDR SWAA2025123055500Cradle · damagedFWD ATTENDANT SEAT INBD FLASHLIGHT BRACKET IS DAMAGED. REMOVED AND REPLACED INBD FLASHLIGHT BRACKET IAW AMM 25-64-00-SWA-807.SDR DALA2025123009517Snubber · out of toleranceOUT OF LIMITS EXTENSI N PIN ON SNUBBER AT L4 DOOR. 4L DOOR ROTARY SNNUBER WAS REPLACED BY SERVICIABLE SNUBBER PER AMM 52- 11-10 ALSO SAME 4L DOOR WAS REMOVED/INSTALLED PER AMM 52-11-01. (1367638)SDR JIKA2025123001Hydraulic Line · chafedDURING FLIGHT AFTER SHORTY AFTER LEVEL OFF, THE FLIGHT CREW EXPERIENCE A LOW HYDRAULIC PRESSURE MALFUNCTION AND AIR RETURNED BACK TO BASE. THE EMERGENCY LANDING GEAR HANDLE WAS MANUALLY ACTUATED DUE TO THE FAILURE AND THE AIRCRAFT LANDED WITHOUT FURTHER INCIDESDR CALA2025123012522Floor Support · corrodedAFT CARGO, FLOOR SUPPORT, BS 1400 - 1420, S29 - 30L., CORRODED. REMOVED IAW SRM 53-60-04-1A-0, FIG 101, SHEET 2, DETA IL II. FABRICATED A NEW FLOOR SUPPORT AND BRACKET, AND INSTALLED IAW SRM 51-40-02.SDR CALA2025123012521Floor Support · corrodedAFT CARGO, FLOOR SUPPORT, BS 1400 - 1420, S29 - 30R, CORRODED. BLENDED REPAIR WITHIN LIMITS.SDR WX0A2025122932688Cover · detached(AIRCRAFT NOT GROUNDED) L2 EXIT LIGHT COVER FELL OFF. ATTACHED LENS COVER IAW AMM 33-51-13-400-001-A. OPS TEST GOOD. THIS CLEARS NEF 25-01-A-07 MDDR #224284. NEF LOG UPDATED.SDR ASAA2025122463432Transmitter · faultyON SELECTING FLAPS 15 L FLAP INDICATOR WENT TO 7.5 AND RIGHT TO 10 RAN QRH SELECTING FLAPS 5 WITH NO FURTHER FLAP MOVEMENT LANDED IN THAT CONDITION. GROUNDED - YES. PERFORMED FSEU BITE PROCEDURE REF FIM 27-51-TASK 801 FOUND MSG 27-52-261 FLAP SENSOR DISAGREE ISDR SWAA2025122955539Flashlight · inoperativeFWD FLIGHT ATT FLASH LIGHT INOPERATIVE. REPLACED FWD INB EMERGENCY FLASHLIGHT AND BATTERY REF 25-64-00. OPS TEST GOOD.SDR SWAA2025122956411Battery · inoperativeFWD FLIGHT ATT FLASH LIGHT INOPERATIVE. REPLACED FWD INB EMERGENCY FLASHLIGHT AND BATTERY REF 25-64-00. OPS TEST GOOD.SDR SWAA2025122955363Battery Pack · inoperativeEMERGENCY EXIT RT MID-FWD AISLE LIGHTS INOP. REMOVED AND REPLACED EMERGENCY EXIT BATTERY PACK M1676 PER AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025122955381Battery Pack · inoperativeEMERGENCY LIGHTS BATTERY PACK AT POSITION M1672 WILL NOT ILLUMINATES EMERGENCY LIGHTS. REPLACED BATTERY PACK AT POSITION M1672 PER AMM 33-51-06SDR SWAA2025122955339Sign · detachedEMERGENCY EXIT SIGN MID CABIN DETACHED. PERFORMED TIME LIMIT REPAIR AT EMERGENCY EXIT SIGN MID CABIN IAW M24-133-0096. PERFORMED TIME LIMIT REPAIR AT EMERGENCY EXIT SIGN MID CABIN IAW M24-133-00396.SDR SWAA2025122955331Battery Pack · no testEMX EXIT LIGHT BATTERY PACK M01675 FAILS CAPACITANCE CHECK, REMOVED AND REPLACED EMX EXIT LIGHT BATTERY PACK M01675 PER [AMM 33-51-06-960-802-MAX.SDR SWAA2025122955330Battery Pack · failedEMX EXIT LIGHT BATTERY PACK M01673 FAILS CAPACITANCE CHECK. REMOVED AND REPLACED EMX EXIT LIGHT BATTERY PACK M01673 PER [AMM 33-51-06-960-802-MAX.SDR SWAA2025122955368Battery Pack · inoperativeSEVERAL EMERGENCY LIGHTS IN THE RT CABIN ARE INOPERATIVE. STARTING FROM OVERWING DOORS TO THE AFT GALLEY. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06.SDR SWAA2025122955603Engine · shutdownNR 2 ENG LIGHT OFF FOLLOWED BY UNCOMMANDED SHUTDOWN, WITH STEADY ENG VALVE LIGHT NR 2 ENGINE STARTED ON SECOND ATTEMPT BUT VERY SLOW TO LIGHT OFF. PERFORMED FUEL SYS MODULE P5-2, OPS TEST IAW AMM 28-22-43. NO FAULTS NOTED. FOUND OMF FAULT FOR 74-42493. T/SSDR DALA2025122909480Unknown · odorPAX AND CREW REPORTS STRONG MIX OF ODORS ON TAXI RTG PER CA/ DSPCH 3 DOOR BACK. REF LOG 8138772 FOR BOROSCOPE FINDINGS. WORK CARD 0550-9001-B757, C/W REF ERA 631308-14 FOR REPAIR. (8138770)SDR DALA2025122909478Sensor · out of adjustLEFT CENTER ENTRY DOOR EICAS MESSAGE ON LANDING. FOUND JAM NUT LOOSE AND 1 OF 3 MOUNTING BOLTS LOOSE. ADJUSTED CLEARANCE BETWEEN TARGET AND SENSOR PER AMM 52-71, TIGHTENED JAM NUT AND MOUNTING BOLT. OPS CHECK GOOD AT THIS TIME. (8143126)SDR G1IA202512294100Downlock Switch · faultyTOOK OFF PAJN FOR PANC ABOUT 1823 LCL. WHILE ON A 6 MILE FINAL EXTENDED THE LANDING GEAR AND FAILED TO GET A L MAIN LANDING GEAR INDICATION ON THE LANDING GEAR ANNUNCIATOR. CONTINUED INBOUND & TOLD TOWER WOULD LIKE THEM TO LOOK AT THE LT MAIN GEAR ON A LOW PSDR DALA2025122909457Support Channel · corrodedFOUND CORROSION AROUND HOLE FOR VHF ANTENNA AT BS 916, LONGERON 3. REPLACED ANTENNA SUPPORT CHANNEL REF BAC DWG 5936434. (1367333)SDR DXTA2025122906287Seat · faultedDURING CRUISE, AN ELECTRICAL/PLASTIC INSULATION BURNING ODOR IN CABIN, AND A VERY LIGHT HAZE OF SMOKE NOTICEABLE AGAINST INCOMING SUNLIGHT, CREW WAS ABLE TO LOCATE THE SOURCE AREA, LOWER SIDEWALL ADJACENT TO SEAT NR 4, LOCATION THAT ALSO PRESENTS AN AREA OF DSDR UIEA2025122401357Skin · puncturedLEFT WING INBD AFT FLAP LE ENGINE LOWER SURFACE HAS A PUNCTURE. 36" OUTBD OF ACCORDION SEAL. REPAIRED SMALL PUNCTURE 1/2" ON LH INBD AFT FLAP LEADING EDGE 501/2" FROM ACCORDION SEAL AND 361/4" FROM TRAILING EDGE PER B747-400 SRM 51-70-07-0G-0 PG. 15 A. NO FURSDR AALA202512296931Flt Controls · malfunctionedAIRCRAFT WAS NOT GROUNDED: WHILE DESCENDING IN VNAV FROM FL280 TO FL 220 THE AIRCRAFT DID AN UNCOMMANDED LEVEL OFF AT FL 240 (THERE WERE NO RESTRICTIONS TO MAKE THE PLANE LEVEL OFF). LATER IN THE FLIGHT WHEN AT FL220 TRYING TO DESCEND TO 11000FT, PASSING THROU