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 DXTA2025082904756G Switch · trippedON LANDING IN HYA EMERGENCY LIGHTS WERE ILLUMINATED. RESET BOTH 5G SWITCHES UNDER PILOT AND COPILOT SEATS, THE EMERGENCY LIGHTS STAYED ON AND WOULD NOT EXTINGUISH UNTIL THE EMERGENCY LIGHT BATTERIES WERE DEPLETED. FOUND AFT INERTIA SWITCHES TRIPPED. GAINED ASDR DXTA2025082904757Elec Connector · disconnectedEMERGENCY EXIT LIGHT ON RIGHT SIDE OF AIRSTAIRS NOT ILLUMINATING. FOUND LIGHT DISCONNECTED FROM CONNECTOR, CHECK WIRES FOR DAMAGAE, RECONNECTED EMERGENCY LIGHT TO WIRE CONNECTOR. OPS TESTED EMERGENCY LIGHTS. OPS TEST GOOD. NO DEFECTS NOTED AT THIS TIME. REFSDR HALA20250829264Fuel Cap · missingETOPS - DURING WALKAROUND FOUND RIGHT WING MISSING FUEL CAP. REPLACED RIGHT WING FUEL COUPLING PER AMM 28-25-41. OK FOR SVC.SDR 2025F00207Start Valve · failedENG 2 START VALVE FAULT . START VALVE NOT OPENSDR 2025F00208Megaphone · inoperativeFWD MEGA PHONE INOP. R&R MEGA PHONE.SDR IXXA20250828003Skin · corrodedRIGHT WING TOP EXTERNAL SKIN COROSION AT AFT SPAR WING STA 380.SDR FDEA202508281561Strut · corrodedENGINE #1 I/B NACELLE STRUT INTERNAL STRUCTURE AT APROX PPSTA 140.0 HAS CORROSION ON SIDE SKIN DISCRIPANCY WAS ACCOMPLISHED ON NR N00271.SDR FDEA202508281560Skin · dentedDENT ON LOWER SURFACE OF OUTBOARD FLAP, AT 70" FROM OUTBOARD EDGE AND 8" FROM TRAILING EDGE, LH WING. LOWER SURFACE OF OUTBOARD FLAP, AT 70" FROM OUTBOARD EDGE AND 8" FROM TRAILING EDGE, LH WING WAS REPAIRED IAW B767 SRM 53-53-01-2R REPAIR 1, FIG. 201, SHESDR FDEA202508281559Seat Track · corrodedMAIN DECK CABIN RBL 58.22 SEAT TRACK FROM STA 1560 TO 1620 HAS CORROSION I/B - OTBD. REMOVED AND REPLACED WITH NEW SEAT TRACK AT RBL 58, STA 1420 - 1620 IAW SRM 53-60-52-0I, AND 51-40-02. MAJOR REPAIR.SDR FDEA202508281558Angle · corrodedFLIGHT DECK, AFT LT CORNER BROWN PAINT AREA, VERTICAL WALL ANGLE CORRODED 3 AREAS, AT FLOOR LEVEL. REMOVED, FABRICATED, INSTALLED FLIGHT DECK, AFT LT CORNER ANGLE IAW SRM 51-40-02. MAJOR REPAIR.SDR FDEA202508281557Wedge · dentedLH WING O/B FLAP (MPN: 113T3100-1078) TRAILING EDGE WEDGE LWR SURFACE A (7.7-INCH X 6.7- INCH) DENT AT WS. 672. REPAIRED LH WING O/B FLAP TRAILING EDGE WEDGE LWR SURFACE A (7.7- INCH X 6.7-INCH) DENT AT WS. 672. IAW SRM 57-53-01-2R AND SRM 51-70-05-0G. THSDR FDEA202508281554Skin · damagedAGING AIRCRAFT - EXISTING REPAIR AT CENTER CARGO DOOR EXTERIOR SKIN FORWARD LOWER CORNER STATION 1710. EXISTING REPAIR AT CENTER CARGO DOOR EXTERIOR SKIN FORWARD LOWER CORNER STATION 1710 EVALUATED AND FOUND REPAIRED IN ACCORDANCE WITH EA # 1-5230-T0309224SDR FDEA202508281553Skin · dentedR/H OTBD TRAILING EDGE FLAP HAS A DENT LOCATED ON THE LOWER SURFACE INBOARD OF THE INBOARD HINGE FAIRING (MWT). REPAIRED R/H WING OTBD TRAILING EDGE FLAP LOWER SKIN SURFACE DENT (3.3" X 2.0") AT LOCATION INBD OF THE INBOARD HINGE FAIRING AT WS 601, IN REF.SDR 2025FA0000586Engine · hung startAS A RESULT OF TROUBLESHOOTING AT GE WALES DUE TO REPETITIVE ENGINE START FAILURES DURING OPERATION (“HUNG STARTS”), AN INCORRECT PART NUMBER WAS FOUND TO BE ASSEMBLED ACCORDING TO THE ENGINE CONFIGURATION. PART NUMBER 1590M22P01 WAS INSTALLED INSTEAD OF PART SDR YENA2025082800893Battery · failedFLT#47, LGA-TPA. "EMERG LIGHT BATTERY FIN 11WL FAILED TEST; REMOVED AND REPLACED EMERG LIGHT BATTERY FIN 11WL IAW AMM 33-51-38."SDR YENA2025082800890Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON EMERGENCY EXIT DOOR (844) FRAME SEGMENT (1) (1EA), CRACK LENGTH: 0.100 INCH; ACCOMPLISHED DOORS / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (AFT RH EEH) FRAME / REINFORCE DOOR STRUCTURE - MODIFICATION IASDR YENA2025082800889Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON EMERGENCY EXIT DOOR (834) FRAME SEGMENT (1) (2EA), CRACK LENGTH: 3.100 INCH; ACCOMPLISHED DOORS / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (AFT LH EEH) FRAME / REINFORCE DOOR STRUCTURE - MODIFICATION IASDR YENA2025082800888Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON EMERGENCY EXIT DOOR (833) FRAME SEGMENT (1) (2EA), CRACK LENGTH: 2.500 INCH; ACCOMPLISHED DOORS / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (FWD LH EEH) FRAME / REINFORCE DOOR STRUCTURE - MODIFICATION IASDR YENA2025082800887Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION FOUND ON EMERGENCY EXIT DOOR (843) FRAME SEGMENT (1) (2EA), CRACK LENGTH: 3.50 INCH; ACCOMPLISHED DOORS / EMERGENCY EXIT / OVERWING EMERGENCY EXIT HATCH (FWD RH EEH) FRAME / REINFORCE DOOR STRUCTURE - MODIFICATION IASDR YENA2025082800885Skin · damagedDURING HEAVY MAINTENANCE: LIGHTNING STRIKE EXTERNAL SKIN LOC. BTW FRAME 26 AND FRAME 27 AND BTW STRINGER 41L AND 42L AT LOWER FUSELAGE; WORK ACCOMPLISHED ON AEROMAN W/O:2025 194/1 NR: 2025 - 471516 REPAIR LOCATED BTW FRAME 26 AND FRAME 27 AND BTW STRINGER 41L SDR YENA2025082800886Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 LH SIDE IN OPEN FASTENER HOLE ( INBOARD LOWER HOLE ) AT DOOR STOP FITTING 1 POSITION, CRACK DIRECTION IS 5 O CLOCK; PERFORMED PERMANENT REPAIR LOCATED ON FRAME 68, L/H SIDE AT LEVEL OF DOOR STOP #1 I.A.W. SDR IXXA20250828002Skin · corrodedRW TOP EXTERNAL SKIN COROSION AT SKIN SPLICE AT WING STA 457, STR UPPER -14SDR YENA2025082800884Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 RH SIDE IN OPEN FASTENER HOLE ( INBOARD LOWER HOLE ) AT DOOR STOP FITTING 4 POSITION,CRACK DIRECTION IS 2 O CLOCK AND 7 O CLOCK; (RESOLVED ON W/O: 1402836 TASKCARD: NR-00034) REF AEROMAN WO # 2025-194/1 NSDR YENA2025082800883Door Frame · crackedDURING HEAVY MAINTENANCE: CRACK INDICATION ON FRAME 68 RH SIDE IN OPEN FASTENER HOLE ( INBOARD LOWER HOLE ) AT DOOR STOP FITTING 1 POSITION,CRACK DIRECTION IS 12 O C LOCK AND 6 O CLOCK;(RESOLVED ON W/O: 1402836 TASKCARD: NR-00035) REF AEROMAN WO # 2025-194/1 NSDR IXXA20250828001Skin · corrodedRW TOP EXTERNAL SKIN COROSION AT SKIN SPLICE AT WING STA 424, STR UPPER -14SDR IXXA20250828050Proximity Sensor · inoperativeEMERGENCY DOOR ANNUNCIATOR LIGHT FLICKERS. MAINTENANCE PLACED ON DEFERRAL 65652 MINIMUM EQUIPMENT LIST 52-71-01-01 CATEGORY C. DUE 07 SEPTEMBER 2025. IN ACCORDANCE WITH B767 FIM 52-71 FAULT TREE 816 AND B767 WDM 52-71-12 BITE PROCEDURE FOR PROXIMITY SENSOR ELESDR IXXA20250828049Bracket · brokenCENTER PEDESTAL EMERGENCY FLASHLIGHT HOLDER BROKEN. MAINTENANCE PLACED ON DEFERRAL 65656 MINIMUM EQUIPMENT LIST 25-63-04-01 CATEGORY C. DUE 07 SEPTEMBER 2025. IN ACCORDANCE WITH B767 FIM 52-71 FAULT TREE 816 AND B767 WDM 52-71-12 BITE PROCEDURE FOR PROXIMITY SSDR UIEA2025082801146Oxygen System · no discrepancy3RD SEAT OXYGEN TEST DOES NOT SHOW FULL CROSS. TOOK OUT MASK AND TESTED OXYGEN THROUGH MASK. PUT MASK BACK IN BOX AND TESTED IT, OPS CHECK GOOD PER AMM 35-00-00.SDR ABXA20250828200Warning Message · activatedDURING TAXI, AFTER ENGINE START, RIGHT HYD QTY DROPPED SIGNIFICANTLY AND REFILL INDICATION CAME ON. AIRCRAFT RETURNED TO BLOCKS. (BTB). ACCOMPLISHED WALKAROUND OF A/C, NO SIGNS OF LEAKS. SERVICED RH HYDRAULICS IAW B767 AMM 12-12-01. MONITORED ENGINE START,SDR JR2R20250828666Seat Track · corrodedSEAT TRACK BEAM AT RBL10, FR84, IS CORRODED OUT OF LIMITS ON BOTH SIDES OF SEAT TRACK. REPAIRED.SDR KCSA202508281147Trunnion · corrodedLEFT WING GEAR TRUNNION SUPPORT O/B FITTING HAS CORROSION.SDR KCSA202508281146Floorbeam · corrodedMAIN DECK FLOORBEAM BS 1580, LBL 85- 94 CORRODEDSDR SWIA2026022775381Stop Fitting · crackedPAX DOOR SURROUND FWD UPPER STOP BRACKET IS CRACKED. REMOVED AND REPLACED PAX DOOR SURROUND FWD UPPER STOP BRACKET WITH REFERENCE TO SRM 51-42-21.SDR SWI2025F01842Intercostal · corrodedPAX DOOR INTERCOSTAL DD 6 BETWEEN FS 320.163 AND FS 336.961 IS CORRODED. REMOVED AND REPLACED PAX DOOR MID INTERCOSTAL DD6 IAW SRM 51-42-06 AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMED.SDR SWI2025F01841Intercostal · corrodedPAX DOOR INTERCOSTAL DD 1 BETWEEN FS 323.361 AND FS 336.961 IS CORRODED. REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD1 MID BETWEEN FS323.61 AND FS336.961 IAW SRM 51-42-06 AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORKSDR SWI2025F01840Former · corrodedPAX DOOR AFT FORMER IS CORRODED ON THE INSIDE. REMOVED AND REPLACED PAX DOOR AFT FORMER IAW SRM 51-42-06 AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMEDSDR SWI2025F01839Former · corrodedPAX DOOR FWD FORMER IS CORRODED ON THE INSIDE. REMOVED AND REPLACED PAX DOOR FWD FORMER IAW SRM 51-42-06 AND 51-42-21. COMPLETED TASK CARD 51-900-1003-SKY. REFERENCE CONTINUATION CARD FOR WORK PERFORMEDSDR SWI2025F01838Intercostal · corrodedPAX DOOR INTERCOSTAL DD 1A BETWEEN FS 323.361 AND FS 336.961 IS CORRODED. REMOVED AND REPLACED PAX DOOR INTERCOSTAL DD1A IAW CRJ 200 SRM 51-42-06, 51-42-21 AND 51-42-11 COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337 NO WEIGHT CHANGE. REFSDR SWIA202512190827Intercostal · corrodedPAX DOOR INTERCOSTAL BETWEEN FS 320.163 AND FS 329.130 IS CORRODED. REMOVED AND REPLACED PAX DOOR MID INTERCOSTAL DD4 IAW CRJ 200 SRM 51-42-06 AND 51-42-21 COMPLETED TASK CARD 51-900-1003-SKY AND ATTACHED COMPLETED FORM 337 NO WEIGHT CHANGE. REFERENCE CONTISDR SWI2025F01793Drag Angle · crackedLEFT VERTICAL STAB TO FUSELAGE ATTACH AFT DRAG ANGLE POSSIBLY CRACKED. REMOVED CRACKED LT VERTICAL STAB TO FUSELAGE ATTACH AFT DRAG ANGLE IAW SRM 51-42-10-001-001-A01, SRM 51-42-21-001-001-A01, AND SRM 51-42-22-001-001-A01, AND INSTALLED -5 DOUBLER ANGLE ANSDR SWIA2025120900827Drag Angle · crackedLH VERTICAL STAB TO FUSELAGE ATTACH FORWARD DRAG ANGLE POSSIBLY CRACKED. AFTER DETERMINING THE END OF THE CRACK BY NDT INSP IAW NDTM PART 1 51-20-08-230 ON REPORTED FWD DRAG ANGLE, IT WAS REPAIRED BY INSTALLATION OF REINFORCEMENT ANGLE IAW SRM 55-31-00-201-00SDR SWI2025F01564Stiffener · looseR/H UPPER TRANSCOWL Z STIFFENER RIVETS ARE PULLED LOOSE (C-CHECK RO 11/22/2025)WET INSTALLED "Z" STIFFENER, -1 (REPAIR DOUBLER), -2 (SHIM), -3 (FILLER), AND -4 (EXTERNAL DOUBLER) TO R/H UPPER TRANSCOWL REF. MHIRJ REO 670-54-21-1759 REV. (--) DATED: 2025-09-0SDR SWI2025F01563Stiffener · shearedR/H LWR TRANSCOWL Z STIFFENER RIVETS ARE SHEARED (C-CHECK RO 11/22/2025)REPAIRED R/H LOWER TRANSCOWL INNER SKIN AT SHEARED RIVETS COMMON TO ZED STIFFENER, REF. REO 670-54-21-1760, REV. --, 2025-09-15. COMPLIED WITH 51-900-1002 SKYSDR SWI2025F01562Transcowl · crackedL/H UPPER TRANSCOWL INBD "A" BRACKET STANDOFF IS CRACKED (C-CHECK RO 11/22/2025)INSTALLED NEW I/B "A" BRACKET (PN CN624-2082-S1501) INTO L/H UPPER TRANSCOWL REF REO# 670-54-21-971, REV B, DATED 11/28/23. REFER TO CONTINUATION SHEET FOR DETAILS. COMPLIED W/SKSDR SWIA202511240827Transcowl · looseL/H LWR TRANSCOWL Z STIFFENER RIVETS ARE LOOSE (C-CHECK RO 11/22/2025)REPAIRED LOOSE RIVETS ON THE "Z" STIFFENER AND CRACK TO THE PERFORATED SKIN OF THE L/H LOWER TRANSCOWL. ALL STEPS OF REO 670-54-21-1763 REV -- DATED 2025-09-10 AND REO 670-54-51-1763 REV SDR SWIA20251110827Stringer · corrodedSTGR 19R BETWEEN FS 295 AND FS 310 HAS AREA OF CORROSION. (FILED CLOSED) REMOVED CORROSION ON STRG 19R FS 295 AND FS 310, EVALUATED WORKED AREA FOUND TO BE OUT OF LIMITS, LOCATED AND DRILL NEW PART, INSTALLED NEW PART ON STRG 19R ON FS295 AND FS 310, PERFORMSDR SWI2025F01525Track · out of limitsL/H UPPER THRUST REVERSER INBD TRACK NYLON INSERT HARDWARE REQUIRES REMOVAL (1EA) (C-CHECK RO 11/07/2025)REMOVED (01EA) SCREW AND REPAIRED 02 HOLES ON L/H UPPER TR INBD TRACK NYLON. IAW CRJ900 SRM 51-41-02, 51-12-00, 51-21-11 AND REO 670-78-30-921 REV B, DATSDR SWAA2025100609107Frame · crackedCRACK FRAME LOCATED STA 312 BTW STR 5L TO STR 6L AT PASSENGER CABIN. REPAIRED FRAME LOCATED STA 312 BTW STR 5L TO STR 6L AT PASSENGER CABIN IAW EA M-22-153-01244 REV: 3.SDR 2A6R2025082774106Cap · crackedDURING A 1000 HOUR INSPECTION, DAMAGE WAS FOUND IN THE FORM OF A 0.250'”CRACK LOCATED ON THE MAIN ROTOR HUB CAP PN: L662C1024101. A REPAIR PROCEDURE WAS PERFORMED IAW AIR METHODS EA# 23-5300-EA-5277 DATED 19 SEP 2025. REFERENCE MG741 ON FILE AT REPAIR STATIOSDR 2A6R2025082774102Frame · crackedDAMAGE WAS DISCOVERED ON THE TAIL CONE UPPER FRAME 7 (PN: L533M1022215) IN THE FORM OF A CRACK IN THE RADIUS ADJACENT TO THE SKIN FLANGE ON THE RH SIDE. THE CRACK MEASURES APPROXIMATELY 0.20'' IN LENGTH. A REPAIR PROCEDURE WAS PERFORMED IAW AMC EA# 23-5300-EA