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 DALA2025111823571Light · inoperativeLOWER CORNER (WHITE) LIGHT FAILS TO ILLUMINATE DURING SVC CHK STEP 18-2A BUT ILLUMINATES UNDER AIRCRAFT POWER. REPLACED LIGHT ASSY. OPS CHK NML. REF B767 AMM 33-51. MEL AND PLACARD REMOVED (7923571).SDR ASAA2025102462314Crease Beam · corrodedAT PASSENGER CABIN FLOOR STRUCTURE RT CREASE BEAM FROM STA.747 THRU STA.887 HAS CORROSION IN MULTIPLE SPOTS (SOME IS MARKED). GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13-1A-1, REPAIRED DAMAGE IAW EA 900ER-53EA-29536W: 1.5 O: 0.5SDR SWAA2025111728272Slide · out of adjustFWD ENTRY DOOR SLIDE REQUIRES REPOSITIONING. ADJUSTED FWD ENTERY DOOR SLIDE IAW AMM 25-66-01-400-803.SDR AALA202511171585Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED LEFT HAND MAIN LANDING GEAR DOOR ACTUATOR FITTING, FORWARD POSITION ON THE KEEL BEAM BETWEEN FR 42 AND FR 43, BETWEEN S41L AND S42L. REPLACED FITTING PER EA 368510.SDR HNAA2025111700747Shear Tie · crackedSHEAR TIE CRACKED AT FR 73 BTW STRINGERS 8-10L. R & R THE SHEAR TIE IAW SRM 51-40-02.SDR HNAA2025111700746Shear Tie · crackedSHEAR TIE CRACKED AT FR 80 BTW STRINGERS 5-6R. R & R THE SHEAR TIE IAW SRM 51-40-02.SDR R61A2025111500509Seal Rest · corrodedDURING HEAVY CHECK AFT SERVICE DOOR (R-2) CUTOUT LOWER BEAM UPPER SURFACE SEAL REST BETWEEN FR 85 - FR 87 FOUND CORRODED. REMOVED AND REPLACED SEAL REST IAW EMB 170/175 SRM 51-41-01SDR R61A2025111500508Gusset · corrodedDURING HEAVY CHECK CF III GUSSET PLATE AT FR 90, BL 0 FOUND CORRODED. REMOVED AND REPLACED GUSSET PLATE IAW EMB 170/175 SRM 51-43-01SDR R61A2025111500507Shear Panel · corrodedDURING HEAVY CHECK CF III R/H SHEAR PANEL BETWEEN FR 87 - FR 88 RBL 12 - RBL 41 FOUND CORRODED. REMOVED AND REPLACED SHEAR PANEL IAW EMB 170/175 SRM 51-42-01SDR R61A2025111500506Splice · corrodedDURING HEAVY CHECK CF III R/H SPLICE PLATE BETWEEN FR87-FR88 RBL41 FOUND CORRODED. REMOVED AND REPLACED SPLICE PLATE IAW EMB 170/175 SRM 51-41-02SDR AALA202511135798Doubler · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON GOGO ANTENNA DOUBLER PLATE ON THE FUSELAGE LOWER SKIN PANEL BETWEEN FR 56 AND FR 57, BETWEEN S42L AND S43L. REPLACED GOGO ANTENNA DOUBLER PLATE PER SRM 51-42-11.SDR DALA202511120001Light · inoperativeLOWER CORNER (WHITE) LIGHT FAILS TO ILLUMINATE DURING SVC CHK STEP 18-2A BUT ILLUMINATES UNDER AIRCRAFT POWER. REPLACED LIGHT ASSY. OPS CHK NML. REF B767 AMM 33-51. MEL AND PLACARD REMOVED (7923571)SDR DAL20251110000Light · no testLOWER CORNER (WHITE) LIGHT FAILS TO ILLUMINATE DURING SVC CHK STEP 18-2A BUT ILLUMINATES UNDER AIRCRAFT POWER. REPLACED LIGHT ASSY. OPS CHKD NORMAL IAW AMM 33-51. MEL AND PLACARD REMOVED (7923571)SDR DAL2025F00000Light · failedLOWER CORNER (WHITE) LIGHT FAILS TO ILLUMINATE DURING SVC CHK STEP 18-2A BUT ILLUMINATES UNDER AIRCRAFT POWER. REPLACED LIGHT ASSY. OPS CHK NML. REF B767 AMM 33-51. MEL AND PLACARD REMOVED (7923571)SDR CALA2025111011079Floorbeam · corrodedAFT REMOVAL OF THE LT FLOOR SUPPORT TO FOM, CORROSION EVAL, FOUND DAMAGE CORROSION UNDER HARD POINT FITTING ON FLOORBEAM BS 947.5 LBL 54. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-5, REPAIR 5.SDR CALA2025111011077Floorbeam · corrodedAFT WET AREA FLOORBEAM BS 986.5, HAS POSSIBLE CORROSION BTW RBL 25 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4, REPAIR 4.SDR CALA2025111011075Panel · damagedPANEL 192CR HAS SEVERAL GOUGES ON THE INTERIOR SURFACE OF DOOR, WHERE IT TOUCHES WITH ACCESS PANEL 192DR (PNEUMATIC ACCESS DOOR) REMOVED AND REPLACED DAMAGE DOUBLER ON PANEL 192CR IAW SRM 51-40-02-0G-0, AIPC 52-48-11-05 AND AMM 20-50-11-910-801 TABLE 204.SDR AALA202511075870Cooling Fan · leakingAIRCRAFT WAS NOT GROUNDED: PASSING THROUGH 10K FT, SMELLED AN OILY MUSTY ODOR, AFTER LANDING & AT GATE, ODOR INTENSIFIED. APU TURNED ON AFTER LANDING & ODOR OF OIL/MUSK INCREASED MORE. AFTER OPENING DOOR, ODOR DISSIPATED BUT REMAINED EVEN AFTER DOOR REMAINESDR 2A6R1024202574601Rail · chafedCHAFING DAMAGE WAS FOUND ON THE TAIL BOOM L/H TRDS SUPPORT RAIL/STIFFENER SHEET (P/N: 350A231028.66) JUST FORWARD OF THE #3 TRDS BEARING SUPPORT. THIS DAMAGE IS A 0.25” IN LENGTH AND 0.1” IN HEIGHT SECTION THAT IS CHAFED THROUGH THE FULL THICKNESS OF THE RAIL.SDR IPXA2025103141487Rib · crackedFAULT: RH WING, CENTER FLAP, TOP SKIN RIB FLANGE, 1 EA CRACK INDICATION NOTED AT RIB 11. CIRCLED IN RED. ++PERFORM RIB 11 REPAIR IN ACCORDANCE WITH FIGURE 5, TAKING EXISTING FASTENER PATTERN INTO ACCOUNT INSTALLING SOLID RIVETS PER DRAWING REQUIREMENTS AT THESDR DALA202511060001Light · inoperativeLOWER CORNER (WHITE) LIGHT FAILS TO ILLUMINATE DURING SVC CHK STEP 18-2A BUT ILLUMINATES UNDER AIRCRAFT POWER. REPLACED LIGHT ASSY. OPS CHK NML. REF B767 AMM 33-51. MEL AND PLACARD REMOVED (7923571)SDR CALA2025110610940Seat Track · corrodedCABIN SEAT TRACK CORRODED ON CROWN INNER LOWER AREA, BS 500D+8, LBL 24. CUT OUT AND REMOVED DAMAGE SECTION OF SEAT TRACK AND INSTALLED REPAIR BETWEEN BS 500B+10 - 500E+10 SRM 53-00-52-2R-4.SDR ASAA2025102462049Support · crackedAFT CARGO LOWER BULKHEAD SUPPORT CORRODED STA 947. GROUNDED - YES. REMOVED DAMAGE, FOUND TO BE WITHIN LIMITS AND RESTORED FINISH IAW B737-900ER SRM 53-00-53-1A-2W1 O.080 R.077 L2 D.003.SDR AALA202511051983Latch · stuckAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN OFCR ESCAPE DOOR AFT LATCH HARD TO OPEN ( UNLATCH). MAINTENANCE REPLACE ESCAPE DOOR LATCH AFT IAW AMM DMC-B787-A-20-11-00-00A-03A-A.SDR IPXA2025110339883Intercostal · brokenRIGHT WING TRAILIN EDGE STA 1196 RIB17 INTERCOSTAL IS BROKEN . INSTALLED INTERCOSTALL AND FITTING AT R/H WING T/E STA 1196 RIB 17. IAW SRM 51-40-21-001.SDR SWIA2025100400024Frame · dentedCOMPLY WITH REO 601R-53-11-4030, TEMPORARY REPAIR FOR DENT DAMAGE TO FRAME WEB AT BS 241.60, RBL 5.50 - RBL 11.16. COMPLIED WITH REO 601R-53-11-4030, REV-, TEMPORARY REPAIR FOR DENT DAMAGE TO FRAME WEB AT FS 241.60 AND BETWEEN RBL 5.50 €“ RBL 11.16. ENSURESDR IPXA2025110325464Skin Panel · crackedCRACK, L1 DOOR AFT LOWER CORNER SKIN. (REPAIR) COMPLETED REPAIR I.A.W SRM 53-10-01-2R-1 REV.129 AND EGAT WORK SHEET NO. 50805 WORK INSTRUCTIONS<BR>STEP D.26(5) SAND THE OUTER SURFACES AND EDGES OF THE SCUFF PLATE AS NECESSARY TO GET A SMOOTH SURFACE.<BR>STEP DSDR IPXA2025110331356Skin Panel · crackedCRACK, R1 DOOR AFT LOWER CORNER SKIN. (REPAIR) COMPLETED REPAIR I.A.W SRM 53-10-01-2R-1 REV.129 AND EGAT WORK SHEET NO. 50807 WORK INSTRUCTIONS, STEP D.26 (5) SAND THE OUTER SURFACES AND EDGES OF THE SCUFF PLATE AS NECESSARY TO GET A SMOOTH SURFACE.<BR>STEP DSDR CALA2025110410889Skin · damagedFWD SERVICE DOOR - IT WAS FOUND CRACK INDICATION IN TWO HOLES, THE UPPER HOLE HAS A CRACK IN THE SKIN APPROXIMATELY 2 O'CLOCK POSITION. THE LOWER HOLE HAS TWO CRACKS INDICATIONS IN THE SKIN AND BEAR STRAP, APPROXIMATELY AT 1 AND 8 O'CLOCK POSITION.PERFORMED RESDR DALA2025110308039Engine · odorFUMES EVENT WHEN APU ON, ALSO WITH ENGINE BLEEDS ON. REPLACED NR 1 ENGINE. (LP 7601408, 1283162).SDR DALA202511030001Light · inoperativeLOWER CORNER (WHITE) LIGHT FAILS TO ILLUMINATE DURING SVC CHK STEP 18-2A BUT ILLUMINATES UNDER AIRCRAFT POWER. REPLACED LIGHT ASSY. OPS CHK NML. REF B767 AMM 33-51. MEL AND PLACARD REMOVED (7923571)SDR IPXA2025103135405Slide · misinstalledAPG FOUND L-1 DOOR EVACUATION SLIDE CONTAINER NOT INSTALLED PROPERLY ATA 25-61. REMOVED L1 DOOR UPPER DOOR LINER, REMOVED THE L-1 DOOR EVACUATION SLIDE/RAFT AND CONTAINER, REPOSITIONED SLIDE/RAFT AND CONTAINER IN REF TO MD11 AMM 25-23-06-000-802, AMM 25-61-01SDR DALA2025103107983Seat Track · corrodedSEAT TRACK UPPER CROWN AND SCALLOP AREA GOUGED AND TOP FLANGE HAS ABRASIONS FROM GALLEY LOCK FITTING AT STA 873 RBL 24. CHECK LIMITS AND REPAIRED SEAT TRACK AT STA 780 TO 880 R/H I/B I.A.W B757-200 SRM 53-00-52-1A-1 AND SRM 53-00-52-2R PROCEDURE 1 . JOB COMPSDR DALA2025103107982Seat Track · corrodedCABIN AREA RIGHT OUTBOARD SEAT TRACK HAS MULTIPLE LOCATIONS OF CORROSION AT STATIONS 377-410 AND AROUND FASTENER HEADS. REMOVED CORROSION ON O/B SEAT TRACK. R/H SIDE AT STA 377-STA 410 . IAW B757-200 SRM-51-10-02. FOUND TO BE OUT LIMITS, IAW B757-200 SRM 53-SDR AALA202510318069Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK CENTER WINDSHIELD FRAMING AT THE LEFT HAND WINDSHIELD FRAME CENTER POST AREA, FR 2 AND Y0. REPAIRED WINDSHIELD FRAME PER EA 367511.SDR AALA202510310728Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK CENTER WINDSHIELD FRAMING AT THE RIGHT HAND WINDSHIELD FRAME CENTER POST AREA, FR 2 AND Y0. REPAIRED WINDSHIELD FRAME PER EA 367511.SDR DALA2025103107961Fuel Cell · leakingFUEL LEAK FOUND DURING INSPECTION OF THE LT WING AFT LOWER SKIN DOUBLER XRS=164. : COMPLIED WITH PRI 629418-14AD (1268439).SDR DALA2025103107969Fuel Cell · leakingFUEL LEAK FOUND DURING INSPECTION OF RT WING AFT LOWER SKIN XRS=164. RT WING AFT LOWER SKIN DOUBLER XRS=164, & RT WING REAR SPAR LOWER CAP. COMPLIED WITH PRI 629419-14AD (1268436).SDR AALA202510302013Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEAT 2AB BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510308702Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEAT 4AB BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510303846Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 19ABC FOUND BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510301725Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 25ABC FOUND BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510303655Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEATS 12ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510305742Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING ELECTRICAL CONNECTOR UNDER SEAT 26ABC FOUND BROKEN. REMOVED AND REPLACED EMERGENCY LIGHT CONNECTOR. PER SWPM 20-61-28.SDR AALA202510302915Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: BOTH EMERGENCY LIGHTING CONNECTORS UNDER SEATS 18ABC FOUND TO BE DAMAGED AND CRACKED. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510306337Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEATS 11ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510305320Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR IN SEAT 8ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510307884Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING CONNECTOR UNDER SEATS 21ABC FOUND TO BE DAMAGED AND CRACKED. REMOVED AND REPLACED EMERGENCY LIGHTING CONNECTOR. PER SWPM 20-61-28.SDR AALA202510308606Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTNING ELECTRICAL CONNECTOR AT SEATS 17ABC BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTNING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.SDR AALA202510301562Elec Connector · damagedAIRCRAFT IN BASE MAINTENANCE: RED EMERGENCY LIGHTING CONNECTOR BENEATH PASSENGER SEAT 13CBA IS BROKEN. REMOVED AND REPLACED EMERGENCY LIGHTNING ELECTRICAL CONNECTOR. PER SWPM 20-61-28.