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 N6WA2025101002Fitting · crackedHINGE FITTING CRACKED AT RH WS 185.11. REMOVED AND REPLACED HINGE FITTINGAT RH WS185.11 IAW CRJ SRM 51-42-21 AND 51-42-06SDR DXTA2025101005245Fuel Sys · out of balanceENROUTE FUEL LEAK UNDER RIGHT WING. FUEL MISCOMPARE CAS FOLLOWED BY FUEL IMBALANCE CAS. VISUAL CHECK OUT THE AFT CABIN WINDOW VERIFIED FUEL VENTING OVERBOARD AT A HIGH RATE. DECENDED AND BEGAN OUT DIVERSION THE FUEL LEAK SUBSIDED. ACFT WALKAROUND PERSDR DXTA2025101005246Unknown · odorDIRTY SOCK ODOR PRESENT IN COCKPIT AND CABIN WITH ACS OPERATING. RAN OZONE CONVERTER FOR MULTIPLE CYCLES WITH VCS ON AND OFF NO FURTHER DEFECTS NOTED AT THIS TIME IAW EMS 505 MM 12-23-00SDR DXTA2025101005247Lever · detachedUPON ACTUATING THE DOOR TO LET OUR OWNERS EGRESS, MAIN CABIN DOOR FORWARD LEVER FELL OUT OF PLACE AS THE MECHANICAL LINKAGE HAS GONE MISSING. DIDN'T NOTICE ANYTHING AWRY IN THE PREFLIGHT AND THE DOOR WORKED PROPERLY BEFORE DEPARTING CLT. REMOVED ALL OLD HARDWSDR DXTA2025101005248Elec Connector · damagedEMER LIGHT OVER SEAT 10 IS NOT WORKING. WE HAVE TURNED THE EMER LIGHTS TO THE ARM POSITION AND THAT LIGHT IS THE ONLY ONE THAT DOES NOT WORK. IT ALSO DOES NOT WORK WITH THE EMER SWITCH IN THE ON POSITION. CORRECTIVE ACTION: ARRIVED ON SITE AND GAINED ACCESS TOSDR UIEA2025100801261Flashlight · no testCAPT PORTABLE FLASHLIGHT TEST INOP. REMOVED AND REPLACED FLASHLIGHT IAW AMM 25-64-01, OPS CHECK GOOD. THIS CLEARS MDDR 239723.SDR UIEA2025100801262Battery · inoperativeL4 JUMPSEAT FLASHLIGHT OR BATTERY NOT CHARGING. REMOVED AND REPLACED FLASHLIGHT BATTERY REF AMM 25-64-00. OPS CHECK GOOD.SDR DALA2025101007395Plate · corrodedCORROSION ON SIDE PLATE FLOOR STRUCTURE SUPPORT UPPER SURFACE (BILGE AREA) (STA 727 TO STA 727F+10 )(STA 727F+10 TO STA 767) BTWN S26R AND S25R AND (STA 727 TO STA 727F +10)(STA 727F+10 TO STA 787+10) AND (STA 787+10 TO STA 847) BTWN S26L AND S25L CARGO COMPARSDR DALA2025101007394Battery Pack · inoperativeSEAT ROWS 11-17 & 28-37 EEPLS INOP. REPLACED BATTERY AT M1672, M2627 & M1676 REF B737 AMM 33-51. EMER LIGHTS OPS CHECK OK.SDR DALA2025101007393Plate · corrodedCORROSION ON RT SIDEPLATE FROM STA 500A TO STA 500I AT FWD CARGO COMPARTMENT. SIDE PLATE STA 500A TO 500I WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR AALA202510104705Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO PASSENGER CABIN FLOOR SUPPORT BETWEEN FR 12 AND FR 24 AT -Y254. REPLACED FLOOR SUPPORT PER SRM 51-72-11.SDR CALA2025101009907Steering Sys · malfunctionedMAIN GEAR STEERING EICAS ON T/O ROLL DID NOT CLEA REQUEST TOMC A MEL FOR STEERING EICAS 3253A DDP C/W. MLG STEERING INOP LOCKED CENTER MEL OK BY TOMC DDP C/W OK TO CONTINUE MM. 05-01. DUE TO RECENT HISTORY OF MMSG 32-63010 IN AHM AND RECENT EWIS INSPECTIONS SDR CALA2025101009906Circuit Breaker · trippedCLIMBING THRU 14K CAB ALT WARN. MAX CAB 11K VALVE L/R CKT BKRS FOUND POPPED AFTER LANDING FOUND DURING T/S SYSTEM R&L ON P-6 PANEL 2EA C/B POPPED ROW A-7 & B-7 RESET C/B'S OPENED ENG 1 & ENG 2 REVERSER HALF'S AND INSPECTED 5TH STAGE VALVES FOR CONDITION AND PSDR CALA2025101009905Pressure Switch · faultedR ENG FUEL FILT MSG AFTER LEVEL OFF... ALL OTHER ENG INDICATION NORMAL REF FIM 73-11 FAULT TREE 803 T/SHOOTING, R/H FUEL FILTER REPLACED AS PER AMM 73-11-02 NIL FINDINGS , REPLACEMENT OF FUEL FILTER DIFFERENTIAL TRANSMITTER REQUIRED. FUEL PX SWITCH R & R IAWSDR CALA2025101009902Attach Angle · crackedRIGHT WING FIXED L/E RIB 15 HAS CRACKED SMALL ANGLE AT INNER BOT TOM CORNER. REMOVED AND REPLACED RH WING FIXED L/E RIB 15 ATTACHED ANGLE IAW A319 SRM 51-42-11-001.SDR CALA2025101009901Skin · damagedRIGHT WING FUEL PANEL LANDING 604JB HAS 2EA HOLES OUT OF ROUND. REPAIRED 2 EA HOLES AT RT WING FUEL PANEL LANDING 640JB IAW A32 0 SRM 51-21-11-300-002 AND REO L2559B EC/RA 5721-01516 CAT A.SDR CALA2025101009900Cover · missingNOSE GEAR FLIGHT INPH JACK COVER DEPARTED THE A/C AND NOW MISSING. REMOVED FLT INPH JACK COVER BASE. INSTALLED NOSE GEAR FLT INPH JACK COVER ASSY PN 2C1079 PER IPC 23-43-51-01 ITEM 35. TIGHTENED NUT PER STANDARD TORQUE VALUES AMM TASK 20-50-11-910-801.SDR CALA2025101009899Charger · inoperativeL1 DOOR EXIT SIGN & FWD OVER HEAD CEILING EMERGENCY LIGHTS ARE INOP. REPLACED M1675 BATTERY CHARGER S/N 6230 WITH SERVICEABLE BATTERY CHARGER IAW B737-800 AMM 33-51-06-960-806. P//N J717-02-001 S/N 9174 IAW B737-800 OPERATIONAL TEST PASSED.SDR CALA2025101009898Control Module · faultedAPU FAULT/APU DET INOP FOUND DETECTION MODULE FAULTED, REPLACED ENGINE AND APU FIRE CONTROL MODULE REF AMM 26-10-01, GRD OPS TEST REF AMM TASK 26-11-00-710-801 AND 26-15-00-710-801 NO FAULTS NOTEDSDR CALA2025101009897Attach Angle · cracked(B737-57-3-0654)R/H ECS BAY,ANGLE ATTACHED TO THE LOWER REAR SPAR CRACKED AT BS 663 APPROX.RBL 10. REPAIRED ATTACH ANGLE AT BS663 PER SRM 57-10-10-2R-5 FIG 202 AND ECRA 5320-03017.SDR CALA2025101009896Floorbeam · corrodedMAIN CABIN AFT WET AREA,CORROSION AROUND SCREW HOLES ON FLOORBEAM AT STA 947.5,BETWEEN LBL-10 AND RBL-10. ACCOMPLISHED REPAIR AT STA 947.5 FLOOR BEAM IN REF WITH B737 -900 ER SRM 53-00-51-2R-1, AAR ESR 20-12933 AND ECRA 5370-01199, PENDING ESFR ENTRY, NO DIP SDR CALA2025101009890Slide · faultedGIRT BAR DOOR 1R SLIDE MATERIAL LOOSE MARKING FOR INSPECTION. REMOVED AND REPLACED DOOR 1R SLIDE. REF AMM 25-66-01. RII INSPECTION OF DR.# 1R SLIDE ASSY. INSTALLATION, REF. AMM 25-66-01, AND GMM 09-25-05.SDR SWAA2025100923026Flashlight · no testFWD CAPTAIN SIDE FA FLASHLIGHT WILL NOT TEST. OPS TEST OK PER 25-64-00.SDR SWAA2025100922638Flashlight · no testBOTH FLASHLIGHTS IN AFT GALLEY WONT TEST. C/W OPS CK?S OF BOTH AFT GALLEY FO SIDE FLASHLIGHTS IAW AMM 25-64-00-200-801. OPS CKD GOOD. PLACARDS REMOVED. THIS CLEARS MEL.SDR SWAA2025100923029Flashlight · no testBOTH FLASHLIGHTS IN AFT GALLEY WONT TEST.SDR SWAA2025100922437Battery Pack · inoperativeAFT LEFT HAND EMERGENCY LIGHTS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-51-06-960-805-NG.SDR SWAA2025100922606Battery Pack · inoperativeMULTIPLE EMERGENCY LIGHTS OUT IN CABIN. REPLACED BATTERY PACK AT 14ABC AND FUSES AT 14DEF REF AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025100922710Battery Pack · no testSEVERAL AFT RIGHT EMERGENCY LIGHTS WOULD NOT TEST. REMOVED AND REPLACED M1671 BATTERY PACK PER AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025100922502Lamp · inoperativeEXTERNAL EMERGENCY EXIT LIGHT BY THE REAR RT GALLEY SERVICE DOOR INOPERATIVE. REPLACED THE LAMP FOR THE EXTERNAL EMERGENCY EXIT LIGHT (SLIDE OVERWING LIGHT) BY THE REAR RH GALLEY SERVICE DOOR IAW AMM 33-51-04.SDR SWAA2025100922994Coalescer Bag · dirtyPUNGENT DIRTY SOCK SMELL IN COCKPIT DURING CLIMB AND DECENT. R & R CABIN AIR FILTER IAW AMM 21-25-01, UPON FURTHER EVALUATION; FOUND LT COALESCER BAG VERY DIRTY. R & R LT AND RT WATER SEPARATOR COALESCER BAGS IAW AMM 21-51-05. PERFORMED ENG RUN ON BOTH ENSDR DALA2025100907387Frame · damagedTOOLING DAMAGE ON FRAME 24 @ P'4 - BETWEEN BRACKET VIEWED FROM BACK SIDE REF DETAIL W-16 - DD. REPAIRED PER ERA 627851-14 REV ORIG. (1241271)SDR DALA2025100907386Light · inoperative2L AND 2R DIVIDER RED EEPL OUT. REPLACED 2L AND 2R DIVIDER EDGE-MOUNTED LIGHT ASSY IAW A330 AMM 33-51. TEST OK. (7927916)SDR DALA2025100907385Frame · damagedSHIP 3360 TOOLING DAMAGE ON FRAME 23 @ P4 - BETWEEN BRACKET VIEWED FROM BACK SIDE REF DETAIL Y - HH. CORRECTIVE ACTION: REPAIRED PER ERA 627851-14 REV O. (1241638)SDR DALA2025100907384Bottle · low pressureSHIP 3327 DOOR 3L DOOR ASSIST BOTTLE PRESSURE LOW. CORRECTIVE ACTION: SERVICED BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7922903)SDR DALA2025100907383Bottle · low pressureSHIP 3327 DOOR 2L DOOR ASSIST BOTTLE PRESSURE LOW. CORRECTIVE ACTION: SERVICED BOTTLE PER A330 AMM 52-15. OK FOR SERVICE. (7922902)SDR DALA2025100907382Bottle · low pressureSHIP 3424 3L DOOR ASSIST PRESSURE LOW. CORRECTIVE ACTION: SERVICED PER A330 AMM 52-15. OK FOR SERVICE. (6994808)SDR GTIA2025100939122Unknown · odorSTRONG SOCK SMELL IN COCKPIT & CABIN ON DESCENT PACK 1 REMOVED SMELL. DESCRIPTION OF ODOR/FUMES: TEMPORARY, DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK AND FWD CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUIRED.-CW TSSDR GTIA2025100939121Unknown · odorSTRONG SKUNK SMELL ON DESCENT THRU 5000' PACK 1 OFF ISOLATE SMELL. DESCRIPTION OF ODOR/FUMES: PERSISTENT, MUSTRY DRY/ DIRTY SOCKS SMELL. APPARENT CABIN SOURCE: CABIN AIR SUPPLY VENTS. FLIGHT DECK AND FWD CABIN. NO VISIBLE SMOKE/HAZE. NO MEDICAL ATTENTION REQUISDR AALA202510091036Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR BOTH SIDES IN BACK OF AIRCRAFT REALLY TIGHT. ADJUSTED GIRT BAR RETAINER CLIPS ON BOTH L2 (AALA202510091565) AND R2 (AALA202510091036) DOORS. OPERATIONAL CHECK GOOD. PER AMM 25-61-01.SDR AALA202510097292Anti-Ice Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: ENGINE 1 ANT-ICE FAULT LIGHT ILLUMINATED IN THE CLIMB WHEN SELECTED TO ON. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT JFK. REMOVED AND REPLACED LEFT HAND ENGINE ANTI-ICE VALVE. PER AMM 30-SDR AALA202510093573Engine · bird ingestionAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ON TAKEOFF HIT A BIRD WITH THE NUMBER 1 ENGINE THEN ENCOUNTERED A STRONG BURNING ODOR IN THE FLIGHT DECK. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT MIA. DURING INSPECTION FOUND DAMAGE TO NUMBSDR AALA202510090789Lavatory · odorAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY SMELL IS VERY BAD. ADDITIONALLY, DURING TAKEOFF, LIQUID WAS SEEPING FROM THAT LAVATORY INTO THE AFT GALLEY. VERIFIED LAVATORY-E TOILET ASSEMBLY LEAKING AT BACK FLANGE. (OPEN).SDR AALA202510091565Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR BOTH SIDES IN BACK OF AIRCRAFT REALLY TIGHT. ADJUSTED GIRT BAR RETAINER CLIPS ON BOTH L2 (AALA202510091565) AND R2 (AALA202510091036) DOORS. OPERATIONAL CHECK GOOD. PER AMM 25-61-01.SDR AALA202510094847Flashlight · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT FORWARD SEAT FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERIES. PER AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA202510094414Handle · unsecureAIRCRAFT WAS NOT GROUNDED: ROW 17DEF OVERWING EMERGENCY EXIT DOOR HAS ESCAPE GRAB HANDLE IS FALLING DOWN. RESECURED GRAB HANDLE FOR OVERWING. PER AMM 52-20-01.SDR AALA202510091836Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: GIRT BAR AFT LEFT SIDE HARD TO REMOVE. ADJUSTED AND REPOSITIONED GIRT BAR AT AFT L2 DOOR. PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA202510090527Lens · detachedAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR EXIT SIGN LENS HAS FALLEN OFF. REMOVED AND REPLACED AFT ENTRY GALLEY EXIT SIGN LIGHT ASSEMBLY. PER AMM 33-51-01. OPERATIONAL CHECKS GOOD.SDR AALA202510094872Door · stuckAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR WAS STUCK CLOSED AND WAS UNABLE TO BE OPENED FROM THE OUTSIDE. DISCOVERED FLIGHT DECK DOOR STOP ENGAGED WHILE DOOR WAS CLOSED. CLEANED DOOR STOP AND PERFORMED OPERATIONAL CHECK OF COCKPIT DOOR. PER AMM 52-51-00.SDR AALA202510094438Elec Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT EMERGENCY EXIT HATCH LOWER EMERGENCY LIGHT IS INOPERATIVE. FOUND LOOSE CONNECTION AT L1189 EMERGENCY EXIT LIGHT. RESEATED CONNECTOR OF L1189 EMERGENCY EXIT LIGHT. PERFORMED SATISFACTORY OPERATIONAL TEST OF EMERGENCY SDR HALA20251009050Filter · odorLAV SMOKE INFLIGHT. PERFORMED TSM 26-17-00-810-804-A FOUND LAV D SMOKE DET. FILTER PLUGGED. REPLACED FILTER. TEST PASSED, MESSAGE CLEARED. OK FOR SVC