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 AALA202509018801Lever · lack of lubeAIRCRAFT WAS NOT GROUNDED: 4L DOOR ARMING LEVER HARD TO MOVE. MAINTENANCE LUBRICATED THE ARMING LEVER AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-10-00.SDR AALA202509017600Slide · low pressureAIRCRAFT WAS NOT GROUNDED: DOOR SLIDE 3L HAS LOW PRESSURE INDICATION. (OPEN)SDR IXXA20250831002Skin · corrodedRIGHT WING TOP EXTERNAL SKIN CORRODED AT SKIN SPICE AT WING STA 383.5-395SDR IXX2025F00016Skin · delaminatedVERTICAL STAB PANEL LEFT SIDE DELAMINATEDSDR SWI2025F01762Stringer · corrodedSTRINGER 25R BETWEEN BS 280 TO 295 HAD CORROSION. REMOVED AND INSTALLED A NEW STRINGER BETWEEN BS 280 AND BS 333 IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG SH670-31630, REV K. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LESDR SWI2025F01761Anchor Fitting · corrodedBS 517 - 533, S22 - 23L, ANCHOR FITTING TOP PLATE CORRODED. REMOVED AND INSTALLED A NEW ANCHOR FITTING TOP PLATE. IAW SRM 51-42-21-001-001-A01, SRM 51-42-10-001-001-A01, SRM 51-42-22-001-001-A01, AND DWG SH670-33600, REV AD. COMPLIED WITH TASK CARD 51-900-1002SDR SWI2025F01760Stringer · corrodedSTRINGER 25L BETWEEN BS 280 AND 295 CORRODED. REMOVED AND INSTALLED A NEW STRINGER IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01 AND DWG SH670-31630, REV K. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKED GOOD. COMPLIED WITH SDR SWI2025F01759Anchor Fitting · corrodedFS 581, S27 - 26L THE ANCHOR FITTING TOP PLATE CORRODED. BLENDED DAMAGE ON FS 581, S27 - 26L ANCHOR FITTING AND FOUND OUT OF LIMITS. REPLACED WITH 1 EA OF NEW ANCHOR FITTING. IAW SRM 51-42-22-001-001-A01 AND SRM 51-42-21-001-001-A01, REV 38. AND DWG SH670-33SDR SWI2025F01758Anchor Fitting · corrodedFS549.00 - FS565.00 STRG 25 - 24RH THE ANCHOR FITTING TOP PLATE CORRODED. REMOVED AND INSTALLED NEW FS549.00 - FS565.00 STRG 25 - 24R ANCHOR FITTING TOP PLATE/ BRACKET P/N:SH670-33852-1 REF SRM 51-42-21-001-001-A01 AND DWG SH670-33600 REV AD. COMPLIED WITH TASDR SWI2025F01757Anchor Fitting · corrodedFS 533, S26L THE ANCHOR FITTING TOP PLATE CORRODED. REMOVED AND INSTALLED NEW FITTING AT BS 533, S26L IAW SRM 51-42-21-001-001-A01, SRM 51-42-10-001-001-A01, AND DRAWING SH670-33600 REV AD. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWI2025F01756Doubler · corrodedFS 985, STRG 26L - 26R, THE DOUBLER UNDER THE SACRIFICIAL RUB PLATE, ON THE EXTERIOR SKIN, IS CORRODED. REMOVED AND INSTALLED NEW DOUBLER & TRIPLER UNDER THE SACRIFICIAL RUB PLATE ON BS 985, S26L-26R. IAW SRM 51-42-21-001-001-A01 & REO 670-53-00-290 REV F. SDR SWI2025F01755Doubler · corrodedTHE INTERNAL ANTENNA DOUBLER AND DOME NUTS BELOW FLOOR BETWEEN FS295 AND FS310 AND STR26 TO STR26R HAS CORROSION IN MULTIPLE LOCATIONS. REMOVED AND INSTALLED NEW INTERNAL ANTENNA DOUBLER BETWEEN FS295 AND FS310 AND STR26L TO STR26R REF SRM 51-42-06-001-001-A0SDR SWI2025F01754Frame · corrodedFS280 LOWER FRAME HAS FRETTING CORROSION JUST INBD OF RBL9. REPAIRED CORROSION ON FS280 LOWER FRAME JUST INBD OF RBL9 IAW REO 670-53-11-2188 REV -. COMPLIED WITH ALL STEPS OF REO 670-53-11-2188 REV -. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWI2025F01753Floorbeam · crackedTHE FLOORBEAM AT LBL9 AND FS280 OUTBD ATTACHMENT ANGLE IS CRACKED. INSTALLED NEW OUTBOARD ATTACH ANGLE AT LBL 9 FS 280.00 IAW SRM 51-42-21-001-001-A01, REVISION 38, AND DWG CC670-34010 REV -K. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR SWI2025F01752Intercostal · corrodedINTERCOSTAL STGR 27R IS CORRODED FWD OD BS 364. REMOVED AND INSTALLED A NEW INTERCOSTAL S27R FWD OF BS 364 IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG SH670-32050 REV J. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHSDR SWI2025F01751Frame · crackedFS333.00 CRACKED AT STGR0. PERFORMED FRAME SPLICE REPAIR AT FS333.00 CRACKED AT STGR0 REF REO 670-53-21-2708 REV -. COMPLIED WITH ALL STEPS OF REO 670-53-21-2708 REV -. COMPLIED WITH TASK CARD 51-900-1002-SKY.SDR SWI2025F01750Lintel · corrodedFS549.00 BETWEEN STRG 17L AND THE LINTEL, FRAME CORRODED. REMOVED AND REPLACED FS 549.00 BETWEEN STRG 17L AND THE LINTEL CORRODED FRAME WITH NEW FRAME REF REO 670-53-31-1096 REV -. COMPLOIED WITH 51-900-1002-SKYSDR SWI2025F01749Stringer · corrodedSTR26R BETWEEN APPROX FS280 TO FS310 HAS CORROSION. REMOVED AND INSTALLED NEW STR26R BETWEEN FS280 AND FS333 REF SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG SH670-31630 REV K. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK SDR SWI2025F01748Stringer · corrodedSTR26L BETWEEN FS280 AND FS333 HAS CORROSION. (C-CHECK RO 12/07/2025)REMOVED AND INSTALLED NEW STR26L BETWEEN FS280 AND FS333 REF SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG SH670-31630 REV K. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-SDR SWI2025F01747Floorbeam · corrodedTHE FLOORBOARD ATTACHMENT ANGLE ON THE LOWER FRAME OF FS280 HAS CORROSION BETWEEN LBL9 AND RBL9. REMOVED AND INSTALLED NEW THE FLOORBOARD ATTACHMENT ANGLE ON THE LOWER FRAME OF FS280 REF SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND DWG CC670-3401SDR SWI2025F01746Floorbeam · corrodedTHE FLOOR SUPPORT ANGLE AT FLOOR LEVEL AT FS280 BETWEEN LBL9 AND RBL9 IS CORRODED IN MULTIPLE LOCATIONS. REMOVED AND INSTALLED NEW ANGLE FLOOR SUPPORT BETWEEN LBL9 - RBL 9 AT FS 280.00 REF SRM 51-42-06-001-001-A01 AND DWG CC670-34010 REV -K. COMPLIED WITH TASSDR SWI2025F01745Frame · corrodedBS 295 FRAME HAS CORROSION BETWEEN STR27 AND STR26R. REMOVED AND INSTALLED NEW LOWER FRAME FS 295 FROM STR 25R TO STR 25L REF SRM 53-00-06-201-006-A01. PERFORMED PRESSURE LEAK CHECK IAW AMM 21-31-00-910-801-A01. LEAK CHECKS GOOD. COMPLIED WITH TASK CARD 51-90SDR SWIA202512080030Stringer · corrodedSTRINGER 27 BETWEEN APPROX BS 280 TO JUST AFT OF BS 295 HAS CORROSION. REMOVED AND INSTALLED NEW S27 FROM BS 280 TO JUST AFT OF BS 295 IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01, AND DWG SH670-31630 REV K. PERFORMED PRESSURE LEAK CHECK IAW AMMSDR SWIA202511240830Canister · crackedRH WING SLAT TRACK CANNISTER 1-3 ATTACH BRACKET INSIDE FUEL PANEL 651AB IS CRACKED. COMPLIED WITH REPAIR OF THE RH WING SLAT TRACK 1-3 CANNISTER ATTACH BRACKET REF REO 670-57-42-577 REV-- DATE: 2016-12-02. COMPLIED WITH ALL STEPS , COMPLIED WITH TASK CARD 51SDR AALA202511183580Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON LH CONTINUITY FITTING OF THE WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE. CRACK L= 0.200 INCH. MAINTENANCE REPLACED CONTINUITY FITTINGS LH OF THE WINDSHIELD CENTER POST LOWER ATTACHMENT ARSDR AALA202511187384Fitting · migratedAIRCRAFT IN BASE MAINTENANCE: BUSH MIGRATED LOCATED ON LOWER LATERAL FITTING OF 80VU RACK ON LH SIDE MEASURES OF WEAR ARE: L: 0.380IN, W:0.235IN D: 0.017IN. MAINTENANCE PERFORMED INTERIM REPAIR LOCATED ON LOWER LATERAL FITTING OF 80VU RACK BTW FR23 AND FR24 STSDR AALA202511185682Fitting · migratedAIRCRAFT IN BASE MAINTENANCE: BUSH MIGRATED LOCATED ON LOWER LATERAL FITTING OF 80VU RACK ON RH SIDE MEASURES OF WEAR ARE: L: 0.400IN, W:0.250IN D: 0.020IN. MAINTENANCE PERFORMED INTERIM REPAIR LOCATED ON LOWER LATERAL FITTING OF 80VU RACK BTW FR23 AND FR24 SDR AALA202511119386Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON LH UPPER RADIUS OF THE WINDSHIELD CENTER POST LOWER ATTACHMENT AREA INTERNAL SIDE. CRACK L= 0.160 INCH. MAINTENANCE PERFORMED TIME LIMITED REPAIR LOCATED LH UPPER RADIUS OF THE WINDSHIELD CENTER POST LOWESDR CALA2025111011067Floorbeam · corrodedMAIN CABIN FLOORBEAM BS 344, LBL 55 UPPER TEE SURFACE CORRODED. INSTALLED THE UPPER TEE REPAIR IAW SRM 53-10-51-2R-18, REPAIR 18,SDR AALA202511070510Skin Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING TRAILING EDGE TOP SKIN PANEL UPPER SURFACE BETWEEN RIB 3 AND RIB 4, BETWEEN S16 AND S17. REPAIRED SKIN PANEL PER EA 368862.SDR ASAA2025083061644Floor Panel · delaminatedIN FWD GALLEY, FLOOR PANEL 222CF (PN: 141A5810-767) HAS DELAMINATION. GROUNDED - YES. ACCOMPLSIHED PERMANENT REPAIR TO FWD GALLEY FLOOR PANEL 222CF PN:141A5810-767, IAW ASA B737-900 SRM 53-00-50-2R-1 + 53-00-50-2R-0.SDR ASAA2025083061643Floor Panel · delaminatedIN FWD GALLEY, FLOOR PANEL 222DF (PN: 141A5810-766) HAS DELAMINATION & SEVERAL AREAS OF CORROSION IN FASTNER HOLES. GROUNDED - YES. ACCOMPLISHED PERMANENT REPAIR TO FWD GALLEY FLOOR PANEL 222DF PN: 141A5810-766 IAW ASA B737-900 SRM 53-00-50-2R-1 + 53-00-50-2R-SDR ASAA2025083061480Floor Panel · delaminatedMULTIPLE CORRODED FASTENERS AND AREAS OF DELAMINATION ON FLOORBOARD 242UF. GROUNDED - YES. REPAIRED DELAMINATION AND REPLACED INSERTS ON FLOORBAORD 242UF IAW B737-900 SRM 53-00-50-2R-1, 53-00-50-212-0.SDR 2025F00234Wire Harness · burnedAIRCRAFT LANDED NORMALLY ON THE ROOFTOP HELIPAD AT 7XA7 WITH NO ABNORMAL INDICATIONS ON CAD OR VEMD IN FLIGHT OR UPON LANDING. ENGINES WERE BROUGHT TO IDLE, PASSENGERS WERE BRIEFED AND LOADED, BAGGAGE SECURED, AND DOORS CLOSED. SHORTLY AFTER ACTIVATION OF THE SDR SWAA2025100610048Support Bracket · crackedCRACK ON SUPPORT BRACKET LOCATED BS540 LBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS540 LBL 6 AT AIR CONDITIONING BAY IAW SRM 51-40-02-0G AND DWG 212A1101, SHEET 3 REV -.SDR SWAA2025100610049Support Angle · crackedCRACK ON SUPPORT BRACKET LOCATED BS 540, RBL 6 AT AIR CONDITIONING BAY. REPLACED SUPPORT BRACKET LOCATED BS 540, RBL 6 AT AIR CONDITIONING BAY IAW SRM 51-40-02-0G AND DWG 212A1101, SHEET 3 REV -.SDR SWAA2025100610051Angle · crackedCRACK ANGLE INBOARD TRAILING EDGE LOCATED IRSS 188 AT RT WING. REPLACED ANGLE LOCATED INBOARD TRAILING EDGE IRSS 188 AT RT WING IAW SRM 51-10-02 ITEM 9; SRM 51-40-02 AND DWG 115A2510 SHEET 12 REV -.SDR SWAA2025100609916Access Panel · crackedCRACK ON AFT RETAINER SEAL ACCESS PANEL 543BB AT LT WING (2 EA). REPLACED AFT RETAINER SEAL ACCESS PANEL 543BB AT LT WING 2 EA IAW SRM 51-40-02-0G DWG 113A9250 SHEET 5. REV. AND SHEET 6. REV.SDR SWAA2025100609911Access Panel · crackedCRACK ON INTERNAL AREA ACCESS PANEL 542BB AT LT WING. REPAIRED INTERNAL AREA ON ACCESS PANEL 542BB AT LT WING IAW SWA EA M-21-157-01063.SDR CALA2025100609624Floor Support · crackedFORWARD PASSENGER CABIN FLOOR INTERCOSTAL CRACKED AT FASTENER HOLES B.S. 380 - B.S.400 RBL. 10". (51-023) ESFR ENTERED REMOVED AND REPLACED INTERCOSTAL AT PASSENGER CABIN FLOOR STA 380 TO STA 400 RBL 10" IAW SRM 51-40-02-0G-0 AND DWG # 143A5400.SDR CALA2025100609623Floor Support · crackedFORWARD PASSENGER CABIN FLOOR INTERCOSTAL CRACKED AT FASTENER HOLES B.S. 380 - B.S. 400 BL. 0 (51-022) ESFR ENTERED REMOVED AND REPLACED INTERCOSTAL AT FORWARD PASSENGER CABIN FLOOR STA 380 TO 400 LB 0 IAW SRM 51-40-02-0G-0 AND DWG # 143A5400 WORK ACCOMPLISHEDSDR SWAA2025100310054Light · deterioratedDETERIORATED PHOTOLUMINESCENT STRIP ALONG PAX CABIN (10 EA). REPLACED PHOTOLUMINESCENT STRIP ALONG PAX CABIN (10 EA) IAW AMM 33-51-15-400-802 AND DWG 33500007 REV 2SDR SWAA2025100210026Floorbeam · corrodedCORROSION ON FLOORBEAM LOCATED BS 947.5 RBL 48 WL 208.1 AT AFT GALLEY AREA. PERFORMED REPAIR ON FLOORBEAM LOCATED BS 947.5 RBL WL 208.1 AT AFT GALLEY AREA RBL2 TO RBL58 IAW SRM 53-70-51-2R-5 REPAIR 5 AND EA M-24-153-02031.SDR SWAA2025100110042Frame · crackedCRACKED BS 328 FRAME AT S-6L. REPAIRED PER EA 25-153-02396.SDR ASAA2025083061091Floor Panel · delaminatedIN FWD GALLEY, FLOOR PANEL HAS DELAMINATION & AN AREA OF CORROSION IN FASTENER HOLE. GROUNDED - YES. APPLIED PERMANENT REPAIRS TO DAMAGED AREAS OF FLOOR BOARD 141A5810-768 IAW SRM 53-00-50-2R-0, & SRM 53-00-50-2R-7.SDR AALA202509252958Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE, CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL IN AF OUTBOARD LAVATORY MOUNT LOCATED AT BS 950, LBL 51. REPLACED FLOOR SUPPORT IAW AARD 51-00-05-1.SDR AALA202509254420Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT, BS 951, RBL 33. REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1.SDR IPXA2025092340743Fitting · gougedLARGE VISIBLE GOUGE NOTED IN HOLE A AT 5 O'CLOCK DIRECTION. REAMED RH HOLE "A" TO 1ST OVERSIZE THROUGH ALL 5 LAYERS I.A.W EO-68606-JIC002 STEP 24 AND SRM 51-40-40. ACCOMPLISH THE REPAIR PER EO-95176-REQ1 AND EA 300-5710-27-A4116.SDR IPXA2025092043577Support Bracket · damagedFAULT-Z600-APG-RH WING ACCESS PANEL 672PB CHAFFING ON VERTICAL SUPPORT BRACKET DOT 55-060. INSTALLED RIB ATTACHMENT ON RH WING ACCESS PANEL 672PB IAW A300-600 SRM 51-40-21. REVIEWEDSDR AALA202509238525Light · burnedAIRCRAFT IN BASE MAINTENANCE: BURN EMERGENCY LIGHT ASSY ON FWD CLOSET LH. MAINTENANCE REPLACED EMERGENCY LIGHT ASSY ON FWD CLOSET LH IAW AMM 33-51-18-000-001-A STEP 4.B(1)(A)(B)(C) AND AMM 33-51-18-400-001-ASTEP 4.C(1)(B)(C). AND STEP F.