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 YENA2025071700732Engine · stalledFLT#637, JFK-STI. (AIRCRAFT PERFORMED AN AIR TURN-BACK TO JFK AND AN EMERGENCY WAS DECLARED) "ENG 2 STALL DURING CLIMB ENG AUTO RELIGHT AND RESUMMED FULL POWER (NO IFSD); REF LOG PAGE 4310981 (INSTALLED BORO PLUG PORT C IAW AMM 72-00-00) BOROSCOPE FINDINGS FOUSDR AALA202507176763Wire · brokenAIRCRAFT WAS NOT GROUNDED: WHITE SEAT MOUNTED EMERGENCY LIGHT AT ROW 1AC IS INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE AT SEAT 2A, REPAIRED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM PER AMM 33-51-00 WITH NO ISSUES SDR AALA202507172094Engine · overtempAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO ABQ DUE TO THE FLIGHT CREW REPORTING THAT ON TAKEOFF #2 ENGINE OVERTEMP OCCURRED, FLIGHT CREW ACCOMPLISHED ECAM PROCEDURES AND SHUT DOWN THE ENGINE. THE AIRCRAFT LANDED SAFELY AT ABSDR CALA2025071706672Slide · out of positionGIRT BAR SLIDE MATERIAL DRAGGING ON GROUND DOOR R1. RESECURED R1 DOOR SLIDE PACK MATERIAL IAW AMM 25-66-01. OK FOR SERVICE.SDR CALA2025071706671Slide · out of position2L DOOR EXCESS SLIDE MATERIAL REMOVED SLIDE AT 2L, REPOSITIONED AND REINSTALLED SLIDE PER AMM 25-66-01-400-401 ACCOMPLISHED RII INSPECTION OF DR 2R GIRT REPACK PER GMM 09-25-05 AND AMM 25-66-01.SDR CALA2025071706670Girt Bar · out of positionDOOR 1R DIFFICULT TO DISARM DUE TO GIRT BAR MATERIAL BEING SHIFT ED TO ONE SIDE. REMOVED DOOR 1R SLIDE. RECENTERED DOOR SLIDE SKIRT MATERIAL, REINSTALLED SLIDE REF AMM 25-66-01. VERIFIED SLIDE GRIT BAR OPERATES NORMALLY. VERIFIED INSTALLATION OF DOOR 1R SLIDSDR DALA2025071605366Frame · damagedSHIP 3415, FORWARD SIDE OF FRAME 61 IB OF 1R TOOLING DAMAGE AT 3RD LOWER FASTENER. REPLACED UPPER FRAME SECTION AT C61 IAW 53-41.SDR DALA2025071605363Rivet · damagedSHIP 3415, FRAME 60, STR 2RT BOTTOM RIVET ON FRAME HAS TOOLING DAMAGE ON HEAD. COMPLIED WITH ER/A 627461-14.SDR DALA2025071605362Frame · damagedSHIP 3415, FRAME 60 O/B OF 1RT 4TH FASTENER BOTTOM ROW O/B TOOLING DAMAGE. COMPLIED WITH ER/A 627461-14.SDR DALA2025071605361Bracket · damagedSHIP 3415, FASTENER HOLE DOUBLE DRILLED ON BRACKET ON AFT SIDE OF FRAME 60 AT STR 2R. COMPLOIED WITH ER/A 627461-14.SDR DALA2025071605353Lock Fastener · misinstalledSHIP 3415, LOCK FASTERNER BELOW FLUSH ON STIFFENER BETWEEN FRAME 61 AND 62 I/B OF STR 3 R. COMPLIED WITH ER/A 627461-14.SDR SWAA2025071691900Cover · missingLOWER EXIT SIGN COVER ROW 14 F/O SIDE MISSING. INSTALLED EXIT SIGN COVER PER AMM 33-51-01.SDR DALA2025071605349Sensor · fodSHIP 3121, 1R DOOR WILL NOT INDICATE ARMED. REMOVED DEBRIS. IAW A319 AMM 52-20.SDR DALA2025071605344O-Ring · leakingSHIP 3142, FUMES SMELL IN FLIGHT DECK AFTER RUNNING PACKS ON APU AT GATE DURING BOARDING. COMPLETED LEAK CHECK OF AIR OIL SEPERATOR PER AMM 49-26-54. NO LEAKS FOUND. REPLACED GENERATOR SCAVENGE FILTER AND O-RING REF AMM 49-91-41.SDR LR7A2025071503772Rib · crackedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND RIB TEE CRACKED AT FS116, LBL42.6, WL230. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-22. NR# 1001291046.SDR LR7A2025071503771Fitting · corrodedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND RH CHINE ANGLE AFT END FITTING CORRODED AT FS737/737.0E, RBL61, WL144. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001290567.SDR LR7A2025071503770Fitting · corrodedDURING SCHEDULED B-1 CHECK WHILE PERFORMING OTHER MAINTENANCE, FOUND RH CHINE ANGLE FORWARD END FITTING CORRODED AT FS737/737.0E, RBL61, WL144. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH. 51-60 & 51-70. NR# 1001290433.SDR LR7A2025071503769Skin · dentedDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB2703, FOUND RH INBOARD FLAP LOWER SKIN DENTED AT CWS160R. / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE51-140-12. NR# 1001289161.SDR LR7A2025071503768Bulkhead Web · crackedDURING ULTRASONIC SPECIAL NDI INSP IAW LOCKHEED SERVICE FLO CS1370999, FOUND FS93 CANTED BULKHEAD CRACKING IN THE WEB. DOCUMENTED ON KF AERO NDT RPT NDT25-1205 TAT 49,961, TAC 26,911, LP# 54561. / REPAIR BY REPLACEMENT ACCOMPLISHED IAW LOCKHEED SMP583 SRM, CH.SDR LR7A2025071503767Skin · gougedDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB5302, FOUND RH AFT FUSELAGE SKIN GOUGED AT FS914, RBL61, WL210 / REPAIRED IAW LOCKHEED SMP583 SRM, FIGURE 51-140-12. NR# 1001288810.SDR LR7A2025071503766Doubler · crackedDURING SCHEDULED B-1 CHECK UNDER JOB CARD HB5301, FOUND WINDSHIELD FRAME DOUBLER CRACKED AT FS116, LBL42, WL232. / REPAIRED IAW LAC MEA 382-53-25-053. NR# 1001288802.SDR SWIA2025071600005Warning Message · illuminatedRECEIVED A GEAR DISAGREE WARNING MESSAGE WHEN GEAR WAS SELECTED DOWN FOR LANDING. GEAR INDICATIONS SHOWED THE NOSE WHEEL WAS STILL IN THE UP POSITION. RAN THE QRH AND THE LANDING GEAR WORKED AS NORMAL. (FLIGHT 6390) OPENSDR YENA2025071600731Battery · no testFLT#2752, SJU-TPA."EMERGENCY LIGHT BATTERY (11WL) FAILED TEST); REMOVED AND REPLACED EMERGENCY LIGHT BATTERY )11WL) IAW AMM 33-51-38 OPS CHK GOOD."SDR YENA2025071600730Battery · no testFLT#2752, SJU-TPA."EMERGENCY LIGHT BATTERY (12WL) FAILED TEST); REMOVED AND REPLACED EMERGENCY LIGHT BATTERY (12WL) IAW AMM 33-51-38 OPS CK GOOD."SDR DALA2025071605343Longeron · damagedAIRCRAFT 9559, LONGERON BETWEEN ST 256 & 275 DAMAGED. REMOVED DAMAGE SECTION OF LONGERON IAW B717 SRM 53-00-05-2R PRO 2. FABRICATED LONGERON AND HATS P717 SRM 53-00-05-2R PROCEDURE 2. PERFORMED BHEC OF REMOVED FASTENERS IAW B717 NDT SPM PART 6, 06-10-01.003 SDR DALA2025071605338Sign · looseSHIP 5642 2L EXIT SIGN ABOVE DOOR LOOSE, HITS TOP OF DOOR. CORRECTIVE ACTION: SECURED SIGN REF B757 AMM 33-51. (7344746)SDR IPXA2025071643387Connector · looseL1 DOOR UNABLE TO ARM. FOUND CONNECTOR ON SOLENOID NEAR AFT BAR RECEIVER LOOSE. TIGHTENED AS REQUIRED. DOOR OPERATES AND ARMS NORMALLY. REF AMM TASK 52-10-01-700-801.SDR ABXA20250715161Smoke Detector · defectiveBELOW 1000 FT ON FINAL APPROACH INTO CVG, RECEIVED A FWD EQPT SMOKE EICAS MESSAGE. LANDED WITHOUT INCIDENT. CALLED CFR. CFR VERIFIED THERE WAS NO SMOKE OR FIRE. MAINTENANCE T/S, DETERMINED INTERMITTENT SMOKE INDICATION FROM TS164, E/E SMOKE DETECTOR. REMOSDR WX0A2025071632501Light · inoperative(AIRCRAFT NOT GROUNDED) RH AFT OVERWING EXIT LIGHT INOP. / REMOVED AND REPLACED RH AFT OVERWING EXIT LIGHT OPS CHECK REF AMM 33-21-00-960-803."SDR IXXA20250715031Escape Reel · detachedMAINTENANCE FOUND INTERIAL ESCAPE REEL, THIRD FROM FORWARD AT L1 DOOR FELL OUT. SYSTEM DEFERRED 64323, MEL CATEGORY C INITIATED. SYSTEM DEFERRED 64323, MEL CATEGORY C INITIATED. INSTALLED L1 DOOR INERTIA ESCAPE REEL IAW B767 AMM 25-61-05. NO OTHER DEFECSDR ABXA20250715160Warning Message · false activationON TAXI, RUDDER RATIO ON EICAS MSG., ALL HYDRAULIC PRESSURES NORMAL. AIRCRAFT RETURNED TO BLOCKS. (BTB) ACCOMPLISHED OPERATIONAL TEST OF RUDDER AND RUDER TRIM CONT IAW AMM 27-21-00. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.SDR AALA202507161602Sign · missingAIRCRAFT WAS NOT GROUNDED: OVERHEAD EXIT SIGN MISSING OVER AISLE NEAR ROW 16. REPLACED COVER ASSEMBLY. PER IPC 35-51-01.SDR AALA202507168062Locking Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: THE GIRT BAR BRACKETS ON THE FORWARD SERVICE DOOR ARE STICKING AND DIFFICULT TO ARM AND DISARM THE DOOR. LUBED R1 DOOR SLIDE BRACKETS AND OPERATIONAL CHECK. PER AMM 25-66-02.SDR AALA202507162155Bulb · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT BULB INOPERATIVE IN AISLE EXIT SIGN AT OVERWING EXIT. REPLACED BULB. PER AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA202507161395Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: DURING CONFIGURATION FROM FLAPS 25 TO FLAPS 30, OBSERVED TRAILING RIDGE FLAP DISAGREE BY A NEEDLE WIDTH. RECEIVED THE AMBER LEADING EDGE FLAPS TRANSIT AND NO GREEN LEADING EDGE FLAPS LIGHT. EXECUTED A GOSDR FDEA202507151221Actuator · failedAFTER ROTATE THE AIRCRAFT BEGAN TO SHAKE IN THE RUDDER PEDALS THEN ENTERED INTO A SUSTAINED DUTCH ROLL THAT CONTINUED TO WORSEN AS WE ACCELERATED. EMERGENCY DECLARED. AMM: 22-00-02-2 AMM: 27-23-00-5 AMM: 22-21-00-5 PERFORMED MCDP TEST 30/40. RUDDER PCU SDR REXA2025071600743Stringer · corrodedSTRINGER 26L IS CORRODED BETWEEN FS 265.00 AND 280.00 REPAIRED STRINGER 26L BETWEEN F.S.265 TO F.S.280 IAW MHIRJ REO 670-53-11-2158 REV -- DATED 2025-07-14SDR REXA2025071600742Stringer · corrodedSTRINGER 19R IS CORRODED BETWEEN FS 295.00 AND 310.00. UPON FURTHER INVESTIGATION, FOUND STR 20R TO BE CORRODED BETWEEN FS 295 AND FS 310. REMOVED STGR 20R FROM FS280-FS319 FOR REPLACEMENT IAW CRJ700 SRM 51-42-06-001-001-A01. INSTALLED STGR 20R PN:SH670-312SDR AALA202507161048Battery · no testAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS FLASHLIGHT AT DOOR 2A DOES NOT TEST CORRECTLY. MAINTENANCE REPLACED BATTERY IN FLASHLIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202507165172Lever · looseAIRCRAFT WAS NOT GROUNDED: 2R DOOR ARMING LEVER LOOSE. MAINTENANCE TIGHTENED 2R DOOR ARMING LEVER PER AMM 25-23-47.SDR AALA202507160102Bottle · no testAIRCRAFT IN BASE MAINTENANCE: PASSENGER / CREW DOOR 832 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER DOES NOT PASS THE DOOR DAMPING FUNCTION OPERATIONAL TEST. REPLACED THE DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-13-14.SDR AALA202507168735Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: R1 DOOR GIRT BAR FITTINGS NEED TO BE ADJUSTED. ADJUSTED R1 DOOR, GIRT BAR FITTINGS PER ROUTINE JOB CARD 26C83152006.SDR AALA202507164941Fitting · out of adjustAIRCRAFT IN BASE MAINTENANCE: L1 DOOR GIRT BAR FITTINGS NEED TO BE ADJUSTED. ADJUSTED L1 DOOR, GIRT BAR FITTINGS PER ROUTINE JOB CARD 26C83152006.SDR JJBA20250716059Mount · crackedRH OVERWING PANEL LOWER MOUNT BRACKET IS CRACKED. REMOVED CRACKED RH OVERWING LOWER MOUNT AND INSTALLED NEW MOUNTSDR JJBA20250716058Mount · crackedLH OVERWING PANEL LOWER MOUNT BRACKET IS CRACKED. REMOVED CRACKED LH OVERWING LOWER MOUNT AND INSTALLED NEW MOUNTSDR CALA2025071606629Battery Pack · inoperativeCEILING EMERGENCY LIGHTS FROM SEAT 23 LEFT SIDE ARE INOPERATIVE, AS WELL AS THE AFT LT LAV FLOOR EMERGENCY LIGHTS INOPERATIVE. FOUND BAD EMERGENCY POWER BATTERY PACK (M1673) IN CEILING PANEL LT OF FDR ACCESS PANEL. R & R BATTERY IAW AMM 33-51-06-960-805. OSDR CALA2025071606621Charger · faultedON ARRIVAL FOUND DOOR 1L & 1R INTERNAL EMERGENCY EXIT LIGHTS ILLUMINATED WITH EMERGENCY LIGHT SWITCH IN OFF POSITION R&R BATTERY CHARGER ASSY AND BATTERY PACK AS PER AMM 33-51-07. OPS TESTED OKAY AND LIGHT TESTS OKAY. DEFECT CLEARED.SDR CALA2025071606620Floor Support · corrodedAFT CARGO COMPARTMENT, BETWEEN FRS 48-52A STRINGER 38R, FLOOR SUPPORT PROFILE HAS CORROSION AND ELONGATED FASTENER HOLES. REMOVED FLOOR SUPPORT PROFILE IAW SRM 51-44-11/001 REPLACED FLOOR PANEL IAW SRM 51-42-11/001.SDR CALA2025071606619Floor Support · crackedMAIN CABIN FWD WET AREA CRACKED AT INTERCOSTAL BL 0" BETWEEN STA 344-360. REMOVED AND REPLACED INTERCOSTAL (FLOOR SUPPORT) IAW SRM 51-40-02-0G-0.SDR CALA2025071606618Web · gougedAFT E&E BAY RT WEB GOUGED. REMOVED DAMAGED IAW SRM 51-10-02, VERIFIED MATERIAL LOSS .007 WITH SCRATCH DEPTH GAUGE, 033 MATERIAL REMAINING. REMOVED DAMAGED WEB IAW SRM 51-40-02. HFEC WAS ACCOMPLISHED IAW NDT PART 6-51-00-00, PROCEDURE 16. NO CRACKS NOTED.