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 IXXA20250817045Reservoir · unserviceableFOUND L1 DOOR ACTUATOR EMERGENCY RESERVIOIR UNSERVICABLE. REMOVED AND REPLACED L1 DOOR ACTUATOR EMERGENCY RESERVOIR IN ACCORDANCE WITH BOEING 757 AIRCRAFT MAINTENANCE MANUAL 52-11-30.SDR SIMA20250817001Light · fadedDURING GVI OF EMERGENCY PHOTOLUMINESCENT LIGHTS FOUND FIRST CLASS PHOTOLUMINESCENT LIGHT FADED RAR FIRST-CLASS FIRST-CLASS EMERGENCY PHOTOLUMINESCENT LIGHT IAW AMM 30-50-21. NO OTHER FAULTS NOTED.SDR DALA2025081806140Dummy Rail · corrodedCORROSION RAIL DUMMY Y503.2 AT FR15 FWD GALLEY AREA (SSI 531189). REPLACED RAIL DUMMY Y503.2 AND FASTENERS LOC ON FR12 TO FR16 FWD GALLEY AREA AS PER A321 SRM 51-72-11. (LP 1148892)SDR DALA2025081806136Bracket · damagedNUMBER 16 BRACKET AT FRAME 20 FWD SIDE OF FRAME HAS TOOLING MARKS. REPLACED BRACKET PER A330 SRM 53-11. (1148675)SDR DALA2025081806135Frame · damagedSHIP 3412 TOOLING DAMAGE AT C57.4 BETWEEN STR 5R. CORRECTIVE ACTION: REPAIRED PER ERA 628417-14 REV A. (1148569)SDR AALA202508189457Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 46. REPLACED INTERCOSTAL PER SRM 41-40-02.SDR SCNA20250818324Battery Pack · inoperative2L EMERGENCY EXIT PLACARDS (TOP AND BOTTOM) AND FLOOR EXIT LIGHTING IN THE AFT CABIN DID NOT ILLUMINATE WITH AC POWER OFF. REMOVED AND REPLACED BATTERY PACK PER AMM 33-51-06.SDR CALA2025081807866Unknown · odorBURNT PLASTIC SMELL WITH APU BLEED AIR ON. OPERATED APU AND PACKS, OPS NORMAL, NO ODOR.SDR AALA202508182878Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 270 TO BS 294 AT BL0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR JR2R20250817660Beam · corrodedAFT WET AREA, RBL10, LONG BEAM IS CORRODED FROM FR 87- FR 88. OUT OF LIMITS. REPLACEDSDR JR2R20250817656Doubler · corroded"TEXAS" GUSSET AT FRAME 90, RBL24, IS CORRODED. OUT OF LIMITS. REPLACEDSDR SWIA2025081675161Hinge · scratchedSCRATCHES NOTED ON PAX DOOR HINGE HALF(DOOR SIDE) LUGS AFT TO FWD LUGS 1-10 AND 27 (MARKED) (C-CHECK RO 02/01/2026)REPAIRED PAX DOOR PIANO HINGE FUSELAGE SIDE OUTER SURFACE LUGS IAW CRJ 900 SRM 52-11-01-201-007-A01 TYPE I STEPS 1, 2, 3, 4. AND COMPLIED WITH TSDR SWIA2025081675142Hinge · chafedCHAFING AND CORROSION NOTED ON PAX DOOR HINGE HALF (FUS SIDE) (MARKED) (C-CHECK RO 02/01/2026)BLENDED LANDS ON THE FUSELAGE SIDE PAX DOOR HINGE. BLENDED LANDS MATERIAL LOSS OF 0.007" OR LESS EXCEPT FOR THE AFT LAND. THE AFT LAND BLEND DEPTH MEASURES 0.048" DESDR SWIA2025081675124Stringer · corrodedCORROSION NOTED ON STRG 19R BETWEEN FS437-FS453 (MARKED) (C-CHECK RO 02/01/2026)STRG 19R BETWEEN FS437-FS453 HAS A PREVIOUS REPAIR AND IS IN A NO DAMAGE ALLOWED AREA THEREFORE FOUND TO BE OUT OF LIMITS REPLACE PART REF CRJ-900 SRM 53-21-03-101-007-A04REMOVED SDR SWI2025F01820Stringer · corrodedSTRINGER 20R FOUND TO BE CORRODED BETWEEN BS 319.70 - 333, BEHIND ELECTRICAL CONNECTOR BRACKET. REMOVED THE STRINGER IAW SRM 51-42-06-001-001-A01, REV OA, AND 51-42-21-001-001-A01, REV OA. FABRICATED LOCATED AND DRILLED A NEW STRINGER IAW DRAWING SH670-32428SDR SWIA2025120900816Frame · no discrepancyFRAME BS 319 BETWEEN STGR 18L - STGR 21L REQUIRES REMOVAL TO FOM. REMOVED AND REINSTALLED FS319 STUB FRAME 18L-21L IAW SRM 51-42-06-001-001-A01 AND 51-42-21-001-001-A01AND 51-25-16-001-001-A01 REV 38.SDR SWAA2025093005229Battery Pack · failedEMERGENCY EXIT LIGHT BATTERY PACK M1675 FAIED CAPACITANCE CHECK. REMOVED AND REPLACED SERVICEABLE EMERGENCY EXIT LIGHT BATTERY PACK M1675 IAW AMM 33-51-06-960-805. PERFORMED GOOD BATTERY PACK M1675 IAW AMM 33-51-06-960-805.SDR SWAA2025092905140Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 13 WL 208.1 AT PASSENGER CABIN. REPLACED ANGLE AND FASTENERS LOC. BTW BS 380 TO BS 400 LBL 13 WL 208.1 AT PASSENGER CABIN IAW B737-800 SRM 51-40-02; B737-800 SRM 51-10-02 AND DWG 143A5400 SHEET 138 REV SDR SWAA2025092905135Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 500I TO BS 520 BL 0 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 500I TO BS 520 BL 0 WL 208.1 AT PASSENGER CABIN IAW SRM-51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G AND DWG:143A5400 SHEET:11SDR SWAA2025092605139Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 BL 0 WL 208.1 AT PASSENGER CABIN. REPLACED ANGLE LOC. BTW BS 380 TO BS 400 BL 0 WL 208.1 AT PASSENGER CABIN IAW B737-800 SRM 51-40-02; B737-800 SRM 51-10-02 AND DWG 143A5400 SHEET 154 REV-.SDR SWAA2025092605141Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 RBL 39 WL 208.1 AT PASSENGER CABIN. INSTALLED NEW SUPPORT ANGLE AND FASTENERS LOCATED BTW BS 380 TO BS 400 RBL 39 WL 208.1 AT PASSENGER CABIN IAW SRM-51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G AND DWG:143A5400 SSDR SWAA2025092605134Support Angle · crackedCRACK ON SUPPORT ANGLE LOCATED BTW BS 380 TO BS 400 LBL 50 WL 208.1 AT PASSENGER CABIN. REPLACED SUPPORT ANGLE UPPER CHORD AND FASTENERS LOCATED BTW BS 380 TO BS 400 LBL 50 WL 208.1 AT PASSENGER CABIN IAW SRM-51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G AND DWG:143ASDR SWAA2025092305210Web · corrodedCORROSION DOOR CUTOUT WEB UPPER POSITION LOCATED BETWEEN BS 794 AND BS 847 AFT CARGO COMPARTMENT. REPLACED WEB LOCATED ON DOOR CUT OUT UPPER POSITION BETWEEN BS 794 AND BS 847 AFT CARGO BAY IAW SRM 51-40-02, AND DWG 146A0081, SHEET 37, REV-, DWG 146A8300, SHSDR SWAA2025092205127Web · corrodedCORROSION FLOOR STRUCTURE LOCATED BS1016 TO BS1016 PLUS 14 INCH BETWEEN BL0 TO LBL14 AT AFT GALLEY AREA. REPLACED WEB AND FASTENERS FLOOR LOCATED BS1016 TO BS1016 PLUS 14 INCH BETWEEN BL0 TO LBL14 AT AFT GALLEY AREA IAW B737-700 SRM 51-40-02 AND DWG 147A5600 SDR SWAA2025092205131Floorbeam · corrodedCORROSION ON EXISTING REPAIR FLOORBEAM LOCATE BS986.5, LBL 44, WL 208 IN AFT GALLEY AREA. REPLACED FILLER ON EXISTING FLOORBEAM REPAIR IAW SRM 53-70-51-2R-6, REPAIR 6, ALTERNATIVE 4, FIGURE 205, SHEET 1.SDR SWAA2025092205126Floorbeam · corrodedCORROSION EXISTING REPAIR FLOORBEAM LOCATED BS 986.5, RBL 44, WL 208 IN AFT GALLEY AREA. REPLACED THE FILLER ON EXISTING FLOORBEAM REPAIR IAW SRM 53-70-51-2R-6, REPAIR 6, ALTERNATIVE 4, FIGURE 205, SHEET 1.SDR SWAA2025092205128Intercostal · crackedCRACK WEB - INTERCOSTAL CEILING AREA LOCATED BS847 TO BS867 AT LEVEL LBL30 AT AFT CARGO COMPARTMENT 2025-499739<[01] REPLACED WEB - INTERCOSTAL CEILING AREA LOCATED BS847 TO BS867 AT LEVEL LBL30 AT AFT CARGO COMPARTMENT IAW B737-700 SRM 51-40-02-0G AND DWG 149SDR IPXA2025083001008Skin · dentedMAJOR REPAIR, DENT FOUND FUSELAGE SKIN BS 1760 BETWEEN S20R AND S22R . ACCOMPLISHED UPS EO-94971-REQ1 REV1. 2. JOB COMPLETED.SDR 2025FA0000641Connecting Rod · failedNR 6 CONECTING ROD FAILED IN FLIGHT.SDR AALA202509112079Oxygen Mask · missingAIRCRAFT IN BASE MAINTENANCE: YELLOWISH MASK IN EMERGENCY OXYGEN CONTAINER ALONG PASSENGER CABIN RH SIDE EXCEPT ROW 25. FINAL REPAIR UPDATED: REPLACED MASK IN EMERGENCY OXYGEN CONTAINER ALONG PASSENGER CABIN RH SIDE EXCEPT ROW 25. IAW AMM 35-21-43-000-001-A ANSDR IPXA2025082301209Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 INBOARD IN BULK CARGO COMPARTMENT LEFT AREA. REMOVED DAMAGE ANGLE IAW SRM 51-40-02-0G, REV 93. INSTALL NEW ANGLE IAW SRM 51-40-02-0G, REV 93 AND DWG 146T5650 SH 5, REV C.SDR IPXA2025082301719Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 RBL 80 OUTBOARD IN BULK CARGO COMPARTMENT RIGHT AREA. REMOVED FLOOR PANEL 252YFF I.A.W AMM 53-01-06-000-801 REV. 145, G.V.I AND CONDITION CHECK NORMAL. REMOVED FLOOR PANEL SEALANT I.A.W AMM 53-01-06-000-801 REV. 145, COMPLETSDR IPXA2025082301758Angle · crackedFOUND THE ANGLE CRACK AT STA 1578 LBL 80 OUTBOARD IN BULK CARGO COMPARTMENT LEFT AREA. REMOVED FLOOR PANEL NO. 251CGF IAW AMM 53-01-06-000-801 REV. 145, GVI AND CONDITION CHECK NORMAL. REMOVED FLOOR PANEL SEALANT IAW AMM 53-01-06-000-801 REV. 145, COMPLETED ANSDR IPXA2025090801808Hinge · damagedFOUND THE ENTRY DOOR DOORWAY ARMING LEVER HINGE ASSY WITH DEFORM DAMAGE. REPLACED HINGE ASSY. I.A.W AMM 20-11-00-910-802 REV.146. INSTALLED PLACARD I.A.W AMM 20-10-13-964-001 REV.146. INSTALLED DOORWAY LINING OF THE ENTRY DOOR. I.A.W AMM 52-12-02-404-025 REV.1SDR IXXA20250909003Attach Angle · cracked#2 PYLON, AFT FAIRING SUPPORT BULKHEAD ATTACH ANGLE IS CRACKED I/BSDR IXXA20250909002Channel · cracked#2 PYLON,AFT FAIRING SUPPORT BULKHEAD ATTACH ANGLE IS CRACKED O/BSDR IXX2025F00022Support Angle · cracked#2 PYLON,DOOR 447BR CUTOUT, AFT SIDE SUPPORT ANGLE IS CRACKEDSDR IXXA20250909001Support Angle · cracked#2 PYLON,DOOR 447BR CUTOUT, AFT SIDE SUPPORT ANGLE IS CRACKEDSDR SWAA2025090805146Plate · crackedCRACK CORRUGATED PLATE TRAILING EDGE ORSS 261 AT LT WING. REPLACED CORRUGATED PLATE LOCATED TRAILING EDGE ORSS 261 AT LT WING IAW SRM 51-10-02 -0G-0 ITEM 9 AND SRM 51-40-02; DRAWING # 115A2001 REV. -. MEASURE OF CRACK IS: 2.102.SDR SWAA2025090805147Support Bracket · crackedCRACK SUPPORT BRACKET TRAILING EDGE ORSS 271 AT LT WING. REPLACED SUPPORT BRACKET AND FASTENERS LOCATED TRAILING EDGE ORSS 271 AT LT WING I.A.W B737-700 SRM 51-40-02; SRM 51-10-02 ITEM 9 AND DWG: 115A2900 SHEET: 1 REV: E.SDR IXX2025F00020Shear Tie · cracked#2 PYLON, UNDER DOOR 447BR FWD SIDE BELOW FITTING, SHEAR TIE IS CRACKEDSDR SCNA20250905363Floor Support · damagedAFTER REMOVAL DAMAGE IN REFERENCE NRC 285 ELONGATED HOLES WERE FOUND IN FOLLOWING COMPONENTS • FLOOR SUPPORT AT STA 993, LBL 32 TO 44 • FLOOR SUPPORT AT STA 993, RBL 32 TO 44 • ANGLE FLOOR SUPPORT AT LBL 46, STA 966-986 • FLOOR SUPPORT AT LBL 16, STA 967-986SDR 3EJA2025090401225Smoke Warning · false activationAT FL260 GOT BAGGAGE SMOKE INDICATOR. MAINTENANCE RAN AC COMPRESSOR FOR 1HR, RAN ENGINES AND AVIONICS FOR 30 MIN. NO VISIBLE SMOKE NOTED AND NO SMOKE CASS MESSAGE. COMPLIED WITH BAGGAGE COMPARTMENT FIRE DETECTION ADJ, TEST PER AMM. COULD NOT DUPLICATE.SDR IPXA2025090201008Skin · dentedFOUND FUSELAGE SKIN DENTED AT BS 1760 BETWEEN S20R AND S22R.SDR IPXA2025090201013Skin · dentedDENT & SCRATCH - FOUND FUSELAGE SKIN PANEL NEAR STA 2638 AND 2658 AT S-25R. PEFORMED EGAT EI F2025A53M-1836, SEQUENCE A, STEP 17. INSTALL THE REPAIR PART WITH BMS 5-95 SEALANT BETWEEN THE MATING SURFACES. 18. INSTALL FASTENERS IAW SRM 51-40-02 AND SRM 51-4SDR AALA202509029915Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: 2L DOOR LEFT OVERWING EXIT CAUTION MESSAGE. MAINTENANCE ADJUSTED DETECTOR PROXIMITY SENSORS 31WN1, 32WN1 (AALA202509029146), 33WN1(AALA202509023058) AND 34WN1 (AALA202509029915) PER AMM 52-71-00-820-805-A. A SATISFACTORY OPERATIONAL CHESDR AALA202509029146Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: 2L DOOR LEFT OVERWING EXIT CAUTION MESSAGE. MAINTENANCE ADJUSTED DETECTOR PROXIMITY SENSORS 31WN1, 32WN1 (AALA202509029146), 33WN1(AALA202509023058) AND 34WN1 (AALA202509029915) PER AMM 52-71-00-820-805-A. A SATISFACTORY OPERATIONAL CSDR AALA202509023058Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: 2L DOOR LEFT OVERWING EXIT CAUTION MESSAGE. MAINTENANCE ADJUSTED DETECTOR PROXIMITY SENSORS 31WN1, 32WN1 (AALA202509029146), 33WN1(AALA202509023058) AND 34WN1 (AALA202509029915) PER AMM 52-71-00-820-805-A. A SATISFACTORY OPERATIONAL CHESDR AALA202509023891Proximity Sensor · out of adjustAIRCRAFT WAS GROUNDED: 2L DOOR LEFT OVERWING EXIT CAUTION MESSAGE. **SUPPLEMENTAL REPORT FOR AALA202508203891: MAINTENANCE ADJUSTED DETECTOR PROXIMITY SENSORS 31WN1, 32WN1 (AALA202509029146), 33WN1(AALA202509023058) AND 34WN1 (AALA202509029915) PER AMM 52-71-0SDR 2025FA0000583Pump · out of tolerancePULLED DATA AND AT SOME POINT DURING ENGINE OPERATION THE LT ENG ECU A FUEL PUMP DROPPED 600HPA AND NEVER RETURNED TO NORMAL. PERFORMED RUN UP TO TEST THE SYSTEM AND WHEN THE LT ENG ECU SWITCH WAS SET TO A THE ENGINE SHUT OFF. THE LOW-PRESSURE FUEL PUMP ASSEMB