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 AALA202508120159Landing Gear · abnormalAIRCRAFT WAS GROUNDED: AFTER TAKEOFF, WHEN PUTTING LANDING GEAR LEAVER IN OFF POSITION, LANDING GEAR STARTING EXTENDING. PERFORMED BITE TEST OF PSEU IAW AMM 32-09-10. NO FAULTS FOUND. PERFORMED MAIN AND NOSE LANDING GEAR OPERATIONAL TEST, PER AMM 32-32-00. LANSDR AALA202508120888Door · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. SECURED LOOSE JAM FASTENERS. OPERATIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202508125931Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN AND CLOSE. SEEMS TO GET CAUGHT ON A LOOSE BRACKET IN TOP CORNER. LUBRICATED FLIGHT DECK LOWER DOOR STOP. PER AMM 20-20-21.SDR AALA202508122663Marker · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 25C EMERGENCY EXIT LIGHTING PANEL BROKEN. RESECURED SEAT 25A EMERGENCY LIGHT ASSEMBLY.SDR AALA202508121711Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING WALK AROUND FOUND EXTERIOR EMERGENCY LIGHT AFT OF WING EXIT DOOR INOPERATIVE AT RIGHT SIDE JOB CARD 09C0005001. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK. PER 33-51-06.SDR AALA202508129884Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING WALK AROUND FOUND EXTERIOR EMERGENCY LIGHT FORWARD OF AFT CARGO DOOR INOPERATIVE AT RIGHT SIDE JOB CARD 09C0005001. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK. PER 33-51-06.SDR AALA202508123959Flashlight · inoperativeAIRCRAFT WAS GROUNDED: FLASHLIGHT UNDER FORWARD FLIGHT ATTENDANT JUMP SEAT FAILED TEST. REPLACED BATTERY UNDER FORWARD FLIGHT ATTENDANT JUMPSEAT PER STANDARD MAINT PRACTICES.SDR AALA202508129736Landing Gear · activation errorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. ACCOMPLISHED MAIN LANDING GEAR OPERATIONAL TEST, PER AMM 32-32-00. MAIN GEAR MANUAL EXTENSION SYSTSDR HNAA2025081200566A/C Pack · overheatedSMOKE IN RHE CABIN DURING TAKEOFF. PACK 1 OVERHEAT MSG NOTICED AFTER LANDING. FACT 11AUG25 00:37 CLT RAN PACKS FOUND PACK 1 TO CONSTANTLY OVERHEAT AFTER 30 SECS AND COCKPIT RECIRC SMOKING WHILE TRYING TO RUN PACK 1 SOUNDS VERY WEAK AND ONLY BLOWS SUPER HOTSDR YENA2025081200823Ecs · odorFLT#1691, JFK-LIR. INFLIGHT REPORTED DIRTYSOCK SMELL AS AIRCRAFT DESCENDED BELOW 10000 ( PACKS ); COMPLIED WITH INFORMATION NOTICE 2017-T015L, SECTION B1. DECONTAMINATION LEVEL A WAS ACCOMPLISHED PER TSM 05-50-00-810-831-A. NO FURTHER ODOR WHEN OPERATING BOTSDR SCNA20250812316Fitting · corrodedCORROSION IN FLOOR FITTINGS ESCAPE SLIDE (2 EAS), DOOR L1. FLOOR FITTINGS ESCAPE SLIDE (2 EAS), DOOR L1 WERE REPLACED PER B737-800 SRM 51-40-02-0G-0SDR SIMA20250811001Light · inoperativeEMERGENCY PHOTOLUMINESCENT STRIPS AT THE PASSENGER ENTRYWAY, ROWS 1 AND 2A, AND 2DF INOP. RAR EMERGENCY PHOTOLUMINESCENT STRIPS AT THE PASSENGER ENTRYWAY, ROWS 1 AND 2A, AND 1 2DF IAW ERJ-175 AMM 33-50-21/400. OPS CHECKS GOOD. NO FURTHER DEFECTS NOTED.SDR YENA2025081200822Unknown · odorFLT#1770, GYE-JFK. FUMES SIMILAR TO PINE NEEDLES NOTICED BY F1 AND F2 ON FINAL DESCENT INTO JFK; COMPLIED WITH INFO NOTICE 2017-T015, SECTION A. ISOLATED FAULT TO TYPE 10 CABIN ODOR. PERFORMED VISUAL INSPECTION OF APU FOR EVIDENCE OF OIL LEAKS AND SEEPAGE, RANSDR CALA2025081207642Light · inoperativeEMERGENCY LIGHTS OPERATIONAL CHECK, AISLE PATH WAY LIGHTS OUT AT ROW 37 SEAT F AND D FULLY SEATED EEL CONNECTION UNDER SEAT 35D. OPS NML, REF AMM 33-51-00-715-019-001. CORRECTION: FULLY SEATED EEL CONNECTION UNDER SEAT 37D. OPS NML, REF AMM 33-51-00-715-019-0SDR CALA2025081207641Bulb · inoperativeEMERGENCY LIGHTS OPERATIONAL CHECK, RT OVERWING EMERGENCY LIGHT OUT REPLACED AFT BULB OF AFT EXTERIOR OVER WING EMERGENCY LIGHT, OPS CKS GOOD IAW AMM 33-51-06.SDR CALA2025081207640Light · deterioratedWHITE EMERGENCY LIGHT COVERS MISSING AT ROWS 25 AND 34 REPLACED LENSES ON EMERGENCY SEAT LIGHTS AT ROW 25 AND 34.SDR CALA2025081207639Lens · damagedEMERGENCY LIGHTS OPERATIONAL CHECK, SEATS 37F AND 31F SEAT- MOUNTED EMERGENCY LIGHT INOP. 37F AND 31F MOUNTED EMERGENCY LIGHT REPLACED AS PER AMM 33-51-10-962-104.SDR CALA2025081207638Girt Bar · unsecure1R GIRT BAR MATERIAL NEE DS TO BE ADJUSTED RESECURED SLIDE MATERIAL IN REF TO AMM 25-66-01SDR CALA2025081207637Lamp · blownR/H EXTERIOR EMERGENCY SLIDE LIGHT FWD OF CARGO DOOR IS INOPERATIVE. LAMP REPLACED AS PER AMM 33-51-06-902-082. LIGHT NOW OPERATES CORRECTLY.SDR CALA2025081207617Battery Pack · inoperativeAFT LEFT SECTION OF CABIN EMERGENCY LIGHT INOP. POWER SUPPLY BATTERY PACK REPLACED REF AMM 33-51-06-960-805, OPS CHECK GOOD.SDR CALA2025081207615Duct · dislodgedDOOR3 GALLEY SMELL LIKE OVENS VERY HIGH BUT OVENS WERE OFF. CARRIED OUT EC/RA 2125-01204. RE-INSTALLED INNER DUCT AND LT PACK LOWER RECIRCULATION FAN CHECK VALVE INTERIM REPAIRED. CABIN TEMP NORMAL.SDR AALA202508120664Attach Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR LOWER CHORD VAPOR BARRIER ATTACH ANGLE AT STA 663, FROM RBL 8 TO RBL 20, RIGHT HAND ECS BAY AFT BULKHEAD. REPAIRED PER SRM 57-10-10-2R-5.SDR AALA202508129910Stringer · damagedAIRCRAFT WAS GROUNDED: HEAT DAMAGE TO STRINGER 18R OUTER CHORD (SEE AALA202505290407) LOCATED FROM BS 747 TO BS 888. REPLACED STRINGER OUTER CHORD. WORK ACCOMPLISHED IN ACCORDANCE WITH BOEING WORK ORDER AAL-RE-2501866, ALSO EA 365018 AND EA 365033.SDR AALA202508127278Stringer · damagedAIRCRAFT WAS GROUNDED: HEAT DAMAGE TO STRINGER 17R OUTER CHORD (SEE AALA202505290407) LOCATED FROM BS 747 TO BS 888. REPLACED CHORD. WORK ACCOMPLISHED IN ACCORDANCE WITH BOEING WORK ORDER AAL-RE-2501866, ALSO EA 365018 AND EA 365033.SDR AALA202508129424Skin · damagedAIRCRAFT WAS GROUNDED: HEAT DAMAGE TO FUSELAGE SKIN (SEE AALA202505290407) LOCATED AT BS 727E PLUS 10 INCHES, FROM S23R TO S24R, AT WL 167. REPLACED SKIN. WORK ACCOMPLISHED IN ACCORDANCE WITH BOEING WORK ORDER AAL-RE-2501866, ALSO EA 365018 AND EA 365033.SDR QXEA2025081100290Control Column · malfunctionedWHEN MOVING CONTROL COLUMN AFT OR FORWARD FEELING A CLICK IN THE CONTROLS. NO BINDING WAS FELT.. REMOVED FROM SERVICE AND FERRIED FOR REPAIRS. REMOVED AND REPLACED CONTROL DISCONNECT DEVICE REF E175 AMM TASK 27-31-06-000-801-A, 27-31-06-400-801-AOPS CK GOOD NOSDR IPXA2025081107546Seal · brokenFOUND THE CREW ENTRY DOOR AFT DOORWAY LINING SEAL BROKEN. OK TO WORK. OPENSDR IPXA2025081104151Sensor · out of adjustBTD DUE TO FWD ENTRY DOOR EICAS L FWD ENTRY DOOR ON PUSH BACK. ADJUSTED SENSOR AND TESTED SATIS PER AMM TASK 52-12-00-715-119 REV 137.SDR IPXA2025081102208Pump · no discrepancyAIR TURN BACK, CENTER TANK RIGHT FUEL PUMP PRESSURE IS LOW PERFORMED QRH PROCEDURE DID NOT RETURN A/C TO NORMAL OPERATION RESULTED IN AN ATB IAW AMM 28-31-01. REPLACE RH CTR TANK JETT PUMP. BONDING RESISTANCE CHECK AND PUMP FUNCTIONAL/OPERATION CHECK NORMAL.SDR JR2R20250811861Frame · chafedLEFT HAND PYLON FAIRING, FRAME 5, BOTH MOUNTING LUGS ARE CHAFED OUT OF LIMITS. REPAIREDSDR 2025FA0000541Oil Filter · out of alignmentTEMPEST OIL FILTER FOUND DEFECTIVE AT INSPECTION. NEW OIL FILTER HAS A MANUFACTURING DEFECT. THE MOUNT THREADS ARE NOT TRUE TO CENTERLINE OF THE FILTER. THIS IS A SPIN ON OIL FILTER. WHEN INSTALLING IT IS EASY TO SEE THAT IT IS NOT TRUE SO IT WOBBLES WHILESDR JR2R20250811934Skin · corrodedFUSELAGE SKIN BELOW FWD CARGO DOOR UNDER SCUFF PLATE HAS MULTIPLE SPOTS OF CORROSION OUT OF LIMITS FROM FRAME 24 TO FRAME 27 AT STRINGER 23R. REPAIREDSDR 2025F00188Skin · corroded1 AREA OF CORROSION FOUND ON E-EXIT OUTER SKIN, UPPER /AFT CORNER. MECHANICALLY REMOVED 1 AREA OF CORROSION LOCATED ON E-EXIT, EXTERIOR SKIN, UPPER AFT CORNER AREA IAW C680 SRM 51-70-02. FOUND CORROSION BLEND TO BE BEYOND SRM LIMITS IAW C680 SRM 51-70-02 EXCEESDR 2025F00187Thrust Reverser · faultedDURING INSPECTION OF THE LH TR NOTED MULTIPLE SPOTS OF CORROSION ON THE INSIDE SIDES OF THE UPPER BUCKET. MECHANICALLY BLENDED 13 EA. AREAS OF CORROSION ON THE LH THRUST REVERSER UPPER DOOR, INBD AND OUTBD AREAS IAW CE680A SRM 51-10-01 AND SRM 51-70-03. AFTER SDR 2025F00180Structure · corrodedFOUND THAT LH EMERGENCY BRAKE CARRY THROUGH CORRODED AROUND FITTING ON RIB LOCATED AT W.S. 37.00. DISCONNECTED EXISTING LH MLG EMERGENCY BRAKE PNEUMATIC LINE AND REMOVED EXISTING CARRY-THROUGH FITTING ON RIB LOCATED AT W.S. 37.00 FOR ACCESS. MECHANICALLY BLENDSDR JR2R20250811972Gusset · corrodedAFT WET AREA TEXAS GUSSET AT FR90 RBL24 CORRODED. REPLACEDSDR CALA2025081107551Fuel Sys · out of balanceAT FL320 NOTICED SIGIFICANT FUEL IMBALANCE RT TANK DROPPED 900LBS WITHIN 15 MINS TOTAL DROPED 1700LBS , CAPT REPORTED FUEL INDICATION ON RT SIDE DROPPED 900 LBS AND TOTALIZER DROPPED 1700 LBS IN FLT. CAPT CHECKED CROSS FEED VALVE IN FLT VERIFIED IT WAS CLOSEDSDR CALA2025081107548Hydraulic Line · leakingHYD SYSTEM G RESERVOIR LOW LEVEL. PILOTS VERBALLY REPORTED THE SYSTEM WENT TO ZERO. THEY FOLLOWED PROTOCOL AND TURNED OFF THE NR 1 ENGINE PUMP & ISOLATED THE SYSTEM. SERVICED GREEN HYD SYS IAW AMM 12-12-29. PRESSURIZED ELECTRIC PUMP & MOVED GREEN RELATED SYSDR CALA2025081107547Warning Light · false activationRIGHT ENGINE BLEED OFF LIGHT THRU 10000. CLB PWR AND TAT +20. ASSOCIATED, OFF.DISCONNECTED CONNECTORS FROM N2 SPEED SENSOR ON NR 2 ENGINE IAW AMM 77-12-02, REMOVED LT & RT DCU IAW AMM. 31-63-06, DISCONNECTED CONNECTORS D5552P & D8032P. JUMPED PINS 3 & 4 ON P7SDR CALA2025081107527Exciter · faultedHUNG START ON NUMBER 1 ENGINE AFTER STARTER CUT OUT. STRONG FUEL ODOR IN FLTDECK AFTER CRANK CLASS 3 FUEL DEPULSE ACTIVATED 1. LEADS TO TSM 80-00-00-810-819-A. ENG START INITIAL TO IDLE SPEED TOOK 2 PLUS MINUTES ON 2 STARTS. ODOR OF FUEL SMELL IN FLIGHT DECK USDR DALA2025081105963Duct · obstructedSHIP 3162 - MISC - DECLARED EMERGENCY DUE TO HOT CABIN CAUSING F/A SICKNESS. ALSO HAD FUEL SMELL REPORTED BY A CUSTOMER. CORRECTIVE ACTION: FOUND L2 DOOR COOLING DUCT OBSTRUCTED. CLEANED AIR DIFFUSER AND RESTORED NORMAL AIR FLOW. FOUND AIR COND FLOW CTL/IND C/SDR FDEA202508111407Trunnion · crackedDURING HIGH FREQUENCY EDDY CURRENT INSPECTION ON LEFT HAND NOSE LANDING GEAR TRUNNION FITTING AFT OF NOSE LANDING GEAR DOOR AFT HINGE FITTING AT STATION 583, FOUND 01 EACH CRACK INDICATION PROPAGATE FROM THE SLOT OUT AREA APPROXIMATELY 1/8" LENGTH. LEFT SDR FDEA202508111406Profile · crackedMAIN DECK FLOOR STRUCTURE WAS FOUND PROFILE-Z CRACK AT FR80/82, Y1448. REPLACED THE CRACK PROFILE-Z WITH NEW PART.LOCATE AT MAIN DECK FLOOR FR80/82 Y1448.I.A.W A300-600F SRM 51-72-10-001 PAGE 2 AND 51-40-21-001 PARA 6 PAGE 7B~PAGE 23.REPAIR CLASSIFIED AS SDR FDEA202508111404Actuator · faultedCARGO DOOR, HYD SYS, DETAILED VISUAL INSPECTION OF THE MAIN DECK CARGO DOOR ACTUATOR BEARING FITTINGS AT FRAME 23 AND 24. COMPLIED WITH EO 6-5230-E0378588 B P5. TITLE: DOORS - CARGO DOOR/HYD SYS - DETAILED VISUAL INSPECTION OF THE MAIN DECK CARGO DOOR (MDSDR FDEA202508111403Seat Track · wornCABIN-SEAT TRACK AT STATION 889, X= -27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 889, X= -27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEATSDR FDEA202508111402Seat Track · wornSEAT TRACK AT STATION 889, X= -47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 889, X= -47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACKSDR FDEA202508111401Seat Track · wornCABIN-SEAT TRACK AT STATION 889, X= 27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 869, X= 27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TSDR FDEA202508111400Seat Track · wornCABIN-SEAT TRACK AT STATION 889, X= 47.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 889, X= 47.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT SDR FDEA202508111399Seat Track · wornSEAT TRACK AT STATION 999, X= -8.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 999, X= -8.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK SDR FDEA202508111398Seat Track · wornSEAT TRACK AT STATION 999, X= -27.5 FOUND CROWN WORN. CABIN-AT SEAT TRACK STATION 999, X= -27.5 WORN CROWN EVALUATED AND FOUND EXCEEDED LIMIT AS PER MD-11 SRM 53-00-52-1A FIGURE 101 ALLOWABLE DAMAGE 1. CROWN WORN SEAT TRACK REPAIRED BY SECTIONAL SEAT TRACK