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 HNAA202509110063Beam · corrodedCARGO DOOR CUTOUT LOWER BEAM TO FR65 PROFILE IS CORRODED. R&R CARGO DOOR CUTOUT LOWER BEAM TO FR65 PROFILE IAW EMB 145 SRM 51-40-02.SDR SWAA2025091205783Stub Frame · crackedFWD GALLEY DOOR; UPPER FWD STUB FRAME REVEAL AT STA 294.5 IS CRACKED IN JOGGLE JUST ABOVE SEAL DEPRESSOR. CRACK IS 0.6' IN LENGTH; MARKED IN BLACK. CONTACT ENGINEERING FOR REPAIR INSTRUCTIONS. REMOVED CRACKED FWD GALLEY DOOR; UPPER FWD STUB FRAME REVEAL AT SSDR HNAA2025091100613Floor Support · corrodedRH #2 FLOOR SILL CORRODED IN NUMEROUS AREAS. R&R RH #2 FLOOR SILL IAW EMB 145 SRM 51-40-02.SDR HNAA2025091000595Beam · corrodedCARGO DOOR CUTOUT LOWER BEAM TO FR65 PRIFILE IS CORRODED. R&R CARGO DOOR CUTOUT LOWER BEAM TO FR65 PROFILE IAW EMB 145 SRM 51-40-02.SDR HNAA2025090900589Beam · corrodedCARGO DOOR CUTOUT LOWER BEAM HAS MULTIPLE CORROSION SPOTS. REMOVED AND REPLACED CARGO DOOR CUTOUT LOWER BEAM IAW EMB 145 SRM 51-40-02.SDR SWAA2025090806020Handle · looseL1 DOOR ASSIST HANDLES (BOTH) LOOSE. SECURED BOTH L1 DOOR ASSIST HANDLES IAW AMM 52-11-31.SDR SWIA2025090819Shear Tie · corrodedCORROSION - SHEAR CLIP AT FR88 BETWEEN STR 27R/28R (C-CHECK RO 09/05/2025)REMOVED AND REPLACED CORRODED SHEAR CLIP AT FR 88 BETWEEN STR 27R/28R REF. EMB SRM 51-40-08. RESTORED SURFACE PROTECTION. SEE CONTINUATION CARD FOR WORK PERFORMED.SDR IXXA20250908002Skin · crackedRIGHT WING LEADING EDGE SKIN CRACKED AT OSS 570SDR AALA202509083039Support Beam · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT WING LEADING EDGE SUPPORT BEAM LOCATED BETWEEN ISS 244.08 AND ISS 321.78 INTERNAL STRUCTURE. PERFORMED PERMANENT REPAIR ON SUPPORT BEAM PER SRM 57-41-02-2R PROCEDURE 1.SDR CALA2025090808559Strap · corrodedAFT CARGO COMPARTMENT FLOOR STRUCTURE; STRAP AT RBL 25 BETWEEN STA. 787 AND STA.847, POSSIBLE CORROSION. (REF- AAR- NR - 1000050508) REMOVED AND REPLACED STRAP BETWEEN STA. 787 AND STA 847 STR 25R AT AF CARGO IAW SRM 51-40-02-0G-0 AND DWG 146A8120. REMOVED ASDR SWAA2025090406025Handle · unsecureR1 DOOR ASSIST HANDLE LOOSE DOOR SIDE. SECURED R1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR SWAA2025090406026Handle · looseR2 DOOR ASSIST HANDLE LOOSE. SECURED R2 DOOR ASSIST HANDLE IAW B737-800 AMM 52-41-31.SDR AALA202508292222Skin · crackedAIRCRAFT IN BASE MAINTENANCE: TWO CRACKS IN RUDDER SKIN LOCATED ON RIGHT SIDE, FROM RUDDER STA 254 TO STA 260. REPAIRED SKIN PER SRM 55-40-01-2R REPAIR 1 AND EA 366887.SDR AALA202508277233Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FOUND CRACKED INTERCOSTAL AT BS 312 TO 324. INSTALLED NEW INTERCOASTAL. PER AARD 51-00-05 AND BOEING DRAWING 141A5410.SDR SWIA2025082600019Windshield · crackedCA WINDSHIELD CRACKING DELAMINATING (FLIGHT 5111 - FILED CLOSED) THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30713385 WITH THE FOLLOWING CORRECTIVE ACTION: "REMOVED AND REPLACED LH WINDSHIELD REF. TASK CARD 56-220-1000-SKY. OPS CHECKED GOOD. NO LEAKS NOTED."SDR J7SA2025082600454Fce · faultedDIVERTED DUE TO PTRIM NML FAIL CAS ON CLIMBOUT. CREW FOLLOWED THE QRH, DISENGAGED THE AUTOPILOT, AND USED BACKUP PITCH TRIM BEFORE LANDING WITHOUT INCIDENT. NO FAULTS NOTED DURING INITIAL OPS CHECKS. SWAPPED FCE 1 AND FCE 2. FLAP FAIL CAS MESSAGE POSTED AFTER SDR CALA2025082608134Skin · crackedTWO CRACKS SIGNAL NOTED AT STAB RT SIDE HSS 129.50, FIRST CRACK L=0.250 INCH LOCATED TO 9.125 INCH AFT FROM FRONT SPAR, SECOND CRACK L= 0.375 INCH LOCATED TO 17.310 INCH AFT FROM FRONT SPAR REPAIRED RT HORIZONTAL LOWER SKIN HSS 129.50, LOCATED TO 9.125" AFT FSDR DALA2025082606327Door Frame · crackedDOOR JAMB AFT CARGO DOOR DAMAGE REPAIRED REF : B717-200 SRM 53-20-15 (1152187)SDR AALA202508250416Pump · low pressureAIRCRAFT WAS GROUNDED: LEFT FORWARD MAIN FUEL TANK PUMP LOW PRESSURE LIGHT CAME ON AFTER TAKEOFF AND THROUGH CRUISE. REMOVED AND REPLACED LEFT HAND FORWARD MOTOR IMPELLER ASSEMBLY. PER AMM 28-22-41. PERFORMED OPS CHECK AND LEAK CHECK GOOD.SDR AALA202508259528Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED FROM BS 500G TO BS 500H AT S26R REPLACED BAFFLE PER AARD 51-00-05-1.SDR ASAA2025081960250Handle · unsecureFLIGHT ATTENDANT REPORTS THAT DOOR L-2 SECURING LEVER WAS MOVING IN FLIGHT UPWARDS BETWEEN 1 TO 2 INCH AND SHE WOULD APPLY DOWNWARD PRESSURE TO THE LEVER BUT IT WOULD NOT STAY SECURED AT ITS BOTTOM RETENT. ADDITIONALLY SHE MENTIONED THAT THE CATERS HAD DIFFICUSDR ASAA2025081960222Elec Connector · damagedWIRE HANGING FROM CEILING OF AFT CABIN. GROUNDED - YES. REVERSED SP NR 2 MAINT. PROCEDURES- INSPECTED CONN'S AND FOUND NO ISSUES. REF SWPM 20-63-02. FULLY ATTACHED BOTH CONNECTOR HALVES AND VERIFIED LOCKED TOGETHER.EMERGENCY LIGHT NOW OPS NORMAL. REF MM 33-SDR ANCF2025081925Door · lack of lubeL/G DOORS NOT CLOSED, IAW AMM 12-32-22-640-065-A STEP A (3). CLEANING GREASE NLG UPLOCK, AND TASK 32-31-00-720-003-A FUNCTIONAL TEST OF THE NORMAL EXTENSION AND RETRACTION OF THE NLG WAS ACCOMPLISHED. TEST IS OK AND RETURN NORMAL CONDITION.SDR DXTA2025082204650Precooler · leakingIN FLIGHT CLIMBING FROM 29000 TO 35000 FT WE SMELLED AN ELECTRICAL BURNING TYPE SMELL AND HAD A RED CAS MSG PACK LEAK. WE RAN THE QRH CHECKLIST AND GOT A A/C TEMP HI AMBER CAS. WE LANDED WITHOUT EVENT. I BELIEVE THIS IS A REPEAT WRITE UP. WHILE AIRCRAFT PRESSUSDR SWAA2025082205738Isolation Mount · crackedFED GALLEY SERVICE DOOR AFT SLIDE MOUNT ISOLATOR CRACKED<[01] R&R FWD GALLEY SERVICE DOOR AFT SLIDE MOUNT ISOLATOR IAW SRM 51-40-02.;[02] C/WSDR SWAA2025082205743Bulb · inoperativePASSENGER CABIN EMERGENCY LIGHT ON SEAT ROW 16DEF INOP<[01] 01 - REMOVED AND REPLACED BULB PER [AMM 33-51-03-960-803-NG (EMERGENCY AISLE LIGHT (EAL) - LENS REPLACEMENT - PERMANENT)];[02] C/W INSPECTIONSDR SWAA2025082206080Battery Pack · inoperativeINOP EMERGENCY LIGHT ON BULLNOSE POSITION 14 17 LH AND AFT LAV AT PASSENGER CABIN 2025-448366<[01] REMOVED AND REPLACED EMERGENCY EXIT LIGHT BATTERY PACK M1670 AND PERFORMED TEST OF THE NEW BATTERY PACK IAW B737-700 AMM 33-51-06-960-805. TEST IS OK.;[02] CERTISDR SWAA2025082206039Wedge · debondedLH INBOARD MAIN FLAP (P/N: 113A2100-71; SN: 000489) TRAILING LOWER SKIN DISBOND - PERMANENT REPAIR)<[01] REMOVED L/H I/B DAMAGED FLAP WEDGE AND UPPER PANEL TO FOM PER SRM 51-40-02;[02] REMOVED L/H I/B MAIN FLAP DAMAGED TRAILING EDGE WEDGE ASSEMBLY FOR REPLACEMSDR SWAA2025082206432Acm · seizedWITH MAX COOLING FROM THE APU; AFTER ABOUT 10 MINUTES; SMOKE FILLED THE CABIN AND AN ACRID SMELL WAS NOTICED. THE PACKS AND RECIRC FAN WERE TURNED OFF AND THE SMOKE DISAPATED.<[01] DURING INSPECTION OF FAULT FOUND RIGHT ACM SEIZED.;[02] PERFORMED SMOKE OR FUMESDR R61A2025081900367Brake · overtempRIGHT INBD BRAKE OVERTEMP 445C AT HIGHEST TEMP & OTBD BRAKE 365 C. LANDED WITHOUT INCIDENT, DECLARED EMERGENCY. C/W HIGH ENERGY STOP CONDITION CHECK.SDR N6WA2025082201Light · out of positionEPL STRIP AT 11B MIGRATED. ADJUSTED AND SECURED EPL STRIP AT 11B IAW CRJ AMM 33-55-01. OPS CHECK GOOD.SDR DALA2025082206274Floorbeam · corrodedCORROSION ON FLOORBEAM AT STA 986 BTW RBL 20-RBL 50, AT PAX CABIN. T-CHORD BTW LBL 9 TO RBL 50 WAS REPLACED PER B737-800 SRM 53-70-51-2R PROCEDURE 4, REPAIR 4.SDR VNAA2025082211101Windshield · arcedLEFT FRONT WINSHIELD ARCING IN FLIGHT. / REMOVED AND REPLACED LH WINDSHIELD IAW CRJ-900 AMM 56-11-01-000/400-801-A01-PSA. OPS TEST AND LEAK TEST GOODSDR AALA202508226291Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR CALA2025082208034Light · inoperativeEMERGENCY LIGHT OUT 1F..ON FLT DECK REQUESTING MEL 3351V FOR SEAT 1F PROXIMITY LIGHT. LIGHT INOP AT THIS TIME. ADJACENT LIGHTS OPERATE AT THIS TIME. APPLIED STICKER. OK TO DEF SEAT 1F PROXIMITY LIGHT MEL 3351V APPLIED *DM* SEE PROXIMITY LIGHT & RETAINER, AS NESDR SWAA2025082106438Seat · out of adjustROW 11 SEATS B AND C WILL NOT STAY UPRIGHT. DOES NOT INTERFERE WITH ROW 12 ABC EGRESS. ADJUSTED HYDRO LOCKS ON BOTH SEATS IAW AMM 25-22-00.SDR SWAA2025082106043Battery · inoperativeFWD EMERGENCY FLASHLIGHT -BOTTOM ONE INOPERATIVE. R & R FWD EMERGENCY FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR SWAA2025082105937Megaphone · inoperativeFA REPORTS AFT MEGAPHONE INOPERATIVE. R & R AFT MEGAPHONE PER AMM 25-64-00. OPS CHECK GOOD.SDR YENA2025082100859Frame · damagedDURING HEAVY MAINTENANCE, PARTIAL REPLACEMENT OF FRAME 16 IAW TC A23-042-02. PERFORMED PERMANENT REPAIR WITH PARTIAL REPLACEMENT TO FRAME 16, S8R - 13R IAW SRM 51-42-11, DWG R531-13279-002, ISSUE E, AND EC A23-042-02.SDR YENA2025082100858Frame · deformedDURING HEAVY MAINTENANCE: DEFORMATION ON FRAME 74 BTW STR 20R TO STR 20L AREA REAR FUSELAGE ; REMOVED AND REPLACED FRAME 74 LOC. BTW STR20R TO STR 20L AREA REAR FUSELAGE I.A.W A320 SRM 51-42-11, A320 SRM 51-72-11 AND DRAWING D53572510.SDR YENA2025082100857Bushing · looseDURING HEAVY MAINTENANCE: SECONDARY FINDINGS LOOSE REPAIR BUSHING (1 EA), LOCATED BETWEEN RIB 16 TO RIB 17 FUEL TAN K AREA LH WING.; (RESOLVED ON W/O: 1391229 TASKCARD: NR-00039 ) PERFORMED BUSHING HOLE REPAIR AND REPLACED BRIDGING PLATE LOCATED BTW RIB16 TO RSDR YENA2025082100856Frame · deformedDURING HEAVY MAINTENANCE: DEFORMATION ON FRAME 73 BTW STR20R TO STR 20L AREA REAR FUSELAGE ; (RESOLVED ON W/O: 1391229 TASKCARD: NR-00040 ) REMOVED AND REPLACED DAMAGED FRAME 73 AND DAMAGED SHEAR WEBS/CLIPS LOCATED BTW STGR 20R TO STGR 20L AREA REAR FUSELAGE ISDR YENA2025082100855Skin · deformedDURING HEAVY MAINTENANCE: DEFORMATION SKIN LOCATED BETWEEN FR 72 TO FR 75 AND STR 31L TO STR 31R JACKING POINT AREA REAR FUSELAGE; (RESOLVED ON W/O: 1391229 TASKCARD: NR-00041 ) PERFORMED PERMANENT REPAIR ON THE AFT FUSELAGE BOTTOM SKIN BETWEEN FR 72 TO FR 75 SDR YENA2025082100854Structure · damagedDURING HEAVY MAINTENANCE: FUSELAGE / AFT FUSELAGE / FR72-75 AND STGR31L-31R / DEFORMATION (TAIL JACK DAMAGE) -PERMANENT REPAIR; REFERENCES: /A/ AEM EA 53-0047-25 (COVER & PART 1+2) /B/ AIRBUS DOSSIER 81633073 /C/ SRM 53-51-29-300-002 /D/ SRM 51-72-11 /E/ AIRBUSDR IPXA2025082044859Structure · delaminatedDELAMINATE- COMPOSITE, VERICAL STABILIZER AUXILIARY SPA AFT FSS 18.037 AREA. (RAPAIR) REQUEST UPS ENGINEERING DETERMINE MAJOR OR MINOR REPAIR.SDR DALA2025082106249Apu · odorAT GATE ON APU, STRANGE NOISE + BURNING SMELL, RIGHT PACK OVHT, R PACK FAIL, + PACK FAULT R BYPASS VLV INOP SMELL DISSIPATED AFTER R PACK SHUTOFF. FOUND RT ACM HOUSING CRACKED AND FAN BLADE MISSING. REMOVED ACM PER A220 AMP 21-51-03, REMOVED HEAT EXCHANGER PERSDR AALA202508210259Pressure Switch · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKEOFF THROUGH APPROXIMATELY 3000FT, GOT NUMBER 1 ENGINE OIL FILTER BYPASS. HAD TO REDUCED THRUST TO IDLE BEFORE LIGHT EXTINGUISHED. AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. ACCOSDR DALA2025082106236Light · broken31D EEPL BROKEN. REPLACED EMERGENCY LIGHT BEZEL LOC 31D PER AMM 33-51. REMOVED PLACARD CLEARED MEL OK FOR SVC. (LP: 7283492)SDR CALA2025082108008Elec Connector · disconnected20A OVERWING EMERGENCY EXIT LIGHT INOP 20A. DURING REMOVAL OF 20A SIDEWALL LIGHT ASSY, FOUND CONNECTOR FOR EMERGENCY LIGHT DISCONNECTED. RECONNECTED CONNECTOR. OPS CHECKED GOOD REF AMM 33-21-01.SDR CALA2025082108007Door Sill · corrodedFOUND EXCESSIVE DAMAGE CORROSION AT THE AFT CARGO MAIN SILL WEB BTW BS 794 AND 847. REMOVED AND REPLACED LOWER MAIN SILL WEB ON AFT CARGO IAW SRM 51-40-02-0G-0, SRM 51-40-05-0G-0, SRM 51-40-08-0G-0, & AMM 51-21-41-370-802, AMM 51-21-72-370-804 & DWG146A812