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 SIMA20250628004Floorbeam · corrodedRH CENTER FLOOR BEAM HAS CORROSION AT FR 17, JUST FWD OF THE SEAT TRACK SSI 53-10-027. (MAJOR REPAIR) (LEVEL 2 CORROSION). ACCOMPLISHED A PERMANENT REPAIR ON RH CENTER FLOOR BEAM CORROSION AT FR 17, JUST FWD OF THE SEAT TRACK IAW ERS-EJ-53MR-5233SDR SWAA2025072386272Bracket · crackedCRACK TRAILING EDGE BRACKET LOCATED INTERNAL CAVITY IRSS 199 PLUS 12 INCHES AT LT WING. REPLACED THE BRACKET LOCATED INTERNAL CAVITY IRSS 199 PLUS 12 INCHES AT LT WING IAW SRM 51-40-02. LENGTH OF CRACK: 0.870.SDR IPXA2025071467822Angle · corrodedAPU INLET DOOR BETWEEN STA 1787.45 TO STA 1825 S-6R, LOWER ANGLE HAS CORROSION.SDR AALA202507219632Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM -Y1162.5 BTW FR68 AND FR69 AT AFT GALLEY AREA , MEASURES ARE: L= 1.08 IN, W= 0.972 IN, D= 0.0215 IN. MAINTENANCE REPLACED FLOOR BEAM -Y1162.5 BTW FR68 AND FR69 AT AFT GALLEY AREA IAW A319 SRM 51-72-11-911-00SDR AALA202507210865Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: AIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM -Y1292 BTW FR65 AND FR66 AT AFT GALLEY AREA MEASURES ARE: L= 1.141 IN, W= 0.884 IN, D= 0.0245 IN. MAINTENANCE REPLACED FLOOR BEAM -Y1292 BTW FR64 AND FR66 AT AFT GALLEY AREA IAWSDR SWAA2025072186271Strap · debondedDEBONDED TRAILING EDGE STRAP LOCATED FLAP TRACK 2 AREA WING LOWER SURFACE AT LT WING. BONDED TRAILING EDGE STRAP LOCATED FLAP TRACK 2 AREA WING LOWER SURFACE AT LT WING IAW B737-700 AMM 51-31-00-390-804. BONDED TRAILING EDGE STRAP LOCATED FLAP TRACK 2 AREA WSDR SIMA20250628003Floorbeam · corrodedSSI 53-10-027 FR 19 LH NUTPLATE SUPPORT BRACKET HAS CORROSION AROUND SCREW HOLE. (LEVEL 2 CORROSION). RAR FR 19 LH NUTPLATE SUPPORT BRACKET IAW ERJ 170 SRM 51-40-08.SDR REXA2025071600745Lamp · inoperativeON WALK-AROUND FOUND RH AFT EMERGENCY LIGHT INOP R/R AFT RIGHT EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHK GOOD.SDR SWAA2025071486304Doubler · crackedEGPR DOOR CUTOUT LOWER DOUBLER IS CRACKED. ACCOMPLISHED REPAIR ON EGPR DOOR CUTOUT LOWER DOUBLER IAW SRM 53-10-15-2R-4.SDR SWAA2025071486306Handle · looseCR RR L1 DOOR ASSIST HANDLE NEEDS SECURED. SECURED L1 DOOR ASSIST HANDLE IAW B737-800 AMM 52-11-31-400-802.SDR AALA202507141660Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM +Y1292 BTW FR65 AND FR66 AT AFT GALLEY AREA L= 3.43 IN, W= 2.00 IN, D= 0.0230 IN. MAINTENANCE REPLACED FLOOR BEAM Y1292 LOC BTW FR64 AND FR66 AT AFT GALLEY AREA IAW A319 SRM 51-42-11-801 A319 SRM 51-72-11SDR JJBA20250711028Floor Support · corrodedBETWEEN LH OB FLOOR SUPPORT AND IB FLOOR SUPPORT AT FRAME 44 IS CORRODED. REMOVED CORROSION BETWEEN LH OB FLOOR SUPPORT AND IB FLOOR SUPPORT AT FRAME 44. RECEIVED, LOCATED, DRILLED AND INSTALLED NEW PARTSDR SIMA20250628002Floor Support · corrodedFWD GALLEY STRUCTURE FR 12-14 RH FLOOR SILL HAS 3 AREAS OF CORROSION SSI 53-10-027 (LEVEL 2 CORROSION) RAR THE FWD GALLEY RH FLOOR SILL IAW ERJ 170 SRM 51-40-08SDR AALA202507086224Engine · shutdownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: INFLIGHT ENGINE SHUTDOWN DUE TO LOW OIL PRESSURE ON NUMBER 1 ENGINE. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT CHA. ACCOMPLISHED ENGINE CHANGE.SDR AALA202507080347Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM BS 277 TO BS 294, AR BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202507063452Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: ROW 17H CEILING EMERGENCY LIGHT INOP. MAINTENANCE FOUND EMERGENCY LIGHT AT ROW 17H ELECTRICAL CONNECTOR LOOSE. RECONNECTED ELECTRICAL CONNECTOR IAW AMM 33-51-03.SDR AALA202507066708Elec Connector · disconnectedAIRCRAFT WAS NOT GROUNDED: ROW 2D EMERGENCY LIGHT CEILING INOP. MAINTENANCE OUND EMERGENCY LIGHT AT ROW 2D ELECTRICAL CONNECTOR LOOSE. RECONNECTED ELECTRICAL CONNECTOR IAW AMM 33-51-03 ITEM OK.SDR AALA202507041641Skin · damagedAIRCRAFT IN BASE MAINTENANCE: CORROSION TRAILING EDGE ON TOP SKIN OVERHANG LOWER SURFACE AT LEVEL RIB 14 ON LH WING. MAINTENANCE PERFORMED INTERIM REPAIR LOC. ON TRAILING EDGE OVERHANG AREA AT LEVEL RIB 14 IAW EA 364685.SDR 454A250627095116Fadec · faultedAIRCRAFT WAS ENROUTE TO SENDING FACILITY AND EXPERIENCED A FADEC MANUAL CAUTION LIGHT WITH A FEW OTHER INDICATOR LIGHTS ON THE #2 SIDE GOING OFF. HE IMMEDIATELY DECIDED TO DIVERT AND MAKE A PRECAUTIONARY LANDING AT KINT. UPON TRYING TO LAND THE FADEC DID FAIL SDR 2WAA2025070200158Light · burned outLOW LEVEL EMERGENCY LIGHTS ON SEATS ROWS 21-32 BURNED OUTSDR WX0A2025070232482Battery Pack · no test(AIRCRAFT NOT GROUNDED) EPSU BATTERY MID R ON EMERGENCY LIGHT TEST. REMOVED AND REPLACED EPSU BATTERY AT LOCATION 12WL IAW AMM 33-51-38-000-002-A AND 33-51-38-400-002-A, OPS CHECK GOOD.SDR R61A2025062800275None · no discrepancyBIRDSTRIKE ON TAKEOFF. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. PERFORMED BIRD STRIKE INSPECTION, NO DEFECTS NOTED.SDR I5PA2025062868807Display · faultedFLT: MGE600, F/O ATTITUDE DISPLAY BLANKED OUT DURING CLIMB OUT TO FLIGHT LEVEL. AIR RETURN BACK TO HNL. R & R F/O FLAT PANEL DISPLAY PER FDS-ICA ID-07688. OPS CHECK NORMAL. ACFT RETURNED TO SERVICE.SDR CALA2025070206150Rub Strip · wornR1 DOOR LUBRICATION - R1 DOOR SLIDE RUB STRIP WORN. REMOVED AND REPLACED R1 DOOR SLIDE IAW MM 25-66-01. CORRECT INSTALLATION, SAFYETY PIN REMOVAL AND OPERATIONAL CHECK REF AMM 25-66-01SDR CALA2025070206149Proximity Switch · faultyAFT LDG FWD CARGO DOOR ECAM CAME ON BRIEFLY AND WENT OUT ITEM HAS HISTORY. REQUESTING MEL. REF AWM 31-54-46 INSPECT WIRES TO PROX SWITCH FOR CONDITION. CHECK WIRES WITHIN HARNESS 4613VB. ALSO SEE MX TIP 52-019. REMOVED PROXIMITY SWITCH PER AMM-TASK 52-35-13-SDR SIMA20250628001Slide · detachedL1 SLIDE FELL OFF DOOR AND IS SITTING IN FRONT GALLEY "TRANSFERRED TO NRWC 763-ORD-02614 ITEM-1" REPLACED EMERGENCY EVACUATION SLIDE IAW 25-65-01. NO DEFECTS NOTEDSDR DALA2025070104950Spring · damagedSHIP 6710 FT LEFT DOOR HARD TO ARM. FOUND GIRT BAR SPRINGS DAMAGED. R/R GIRT BAR PER B757 AMM 25-66. CHKS NORMAL. (1050485)SDR SWAA2025070186301Screw · missingAFT ENTRY SIDE GIRT BAR LOOSE - MISSING SCREW. REATTACHED GIRT BAR AND SCREW REF AMM 25-66-01.SDR SWAA2025070186321Battery Pack · inoperativeLH OVER WING EXIT EMER LIGHT OUT. R & R LH OVER WING EXIT EMER LIGHT BATTERY PACK IAW AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025070186298Lamp · inoperativeR-1 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED R-1 DOOR EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-04. OPS CHECKED NORMAL.SDR SWAA2025070186381Sign · looseEMERGENCY EXIT SIGN AT MID-CABIN IS LOOSE.<[01] RESECURED EMERGENCY EXIT SIGN MID-CABIN IN REFERENCE TO AMM 33-51-01. OPS CHECKS GOOD.SDR SWAA2025070186477Fairing · damagedSTRUT 4 FAIRING HAS AN ENLARGED MOUNT HOLE ON TOP AFT SIDE<[01] C/W 25-172-01732SDR SWAA2025070186231Handle · looseAFT ENTRY DOOR HANDLE IS LOOSE. TIGHTEN AFT ENTRY DOOR HANDLE PER AMM 52-13-31-400-802 STEP 3.G.(2).SDR DALA2025070104902Drain Mast · corrodedFWD FUSELAGE DRAIN MAST CUTOUT / CORROSION UNDER FWD DRAIN MAST. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0471:3833-2001/002 00525 COMPLIED WITH PRI 627174-14 REV 0, PRI 627174-14 REV 1 AND FINAL ER/A 627174-14 REV ORIGINAL. SECTION I, SEE LOG # 1036214. SDR DALA2025070104899Door Sill · corrodedAFT CARGO COMPARTMENT DOOR LOWER SILL SURROUND STRUCTURE HAS CORROSION AROUND SEVERAL FASTENER HOLES. SCEPTRE LOG PAGE ENTERED FOR SDR REPORTING. SUMMARY SEE NR FOR ADDITIONAL INFORMATION 001-0523:5300-2012/001 00269 COMPLIED WITH PRI 626953-14 REV 0, PRI 6269SDR DALA2025070104898Structure · corrodedCORROSION FOUND AROUND AND ON COUNTERSINK BOLT HOLES10L, 30L, AND 70L. COMPLIED WITH PRI 626953-14 REV 0, PRI 626953-14 REV 1, PRI 626953-14 REV 2 AND FINAL ER/A 626953-14 REV ORIGINAL. SECTION I , SEE LOG # 1048121. REP INSPECTIONS. COMPLIED WITH PRI 62695SDR DALA2025070104897Beam · corrodedFWD CARGO - LOWER SILL BEAM HAS CORROSION IN SCUFF PLATE ATTACH HOLES (M)(P). COMPLIED WITH ER/A 626994-14 PRI REV0, ER/A 626994-14 PRI REV 1 AND FINAL ER/A 626994-14 REV ORIGINAL SECTION I. SEE LOG # 1043585 FOR SECTION II REP. INSPECTION. COMPLIED WITH ER/SDR DALA2025070104884Charger · no test(LOG 6402890) ROWS 28 FED TO 33 FED EMERGENCY FLOOR LIGHTS INOP. R/R'D CHARGER ASSEMBLY M2627 PER B737 AMM 33-51. ALL CHECKS OK.SDR DALA2025070104889Battery Pack · no testON SERVICE CHECK, FOUND FWD LH EMERG EXIT LIGHTS INOP. R/R EMERG. LIGHTS BATTERY PACK M1675 PER B737 AMM 33-51. OPS CHECK GOOD.SDR REXA2025070100707Lamp · inoperativeEXTERIOR LH AFT EMERGENCY LIGHT INOP REMOVED AND REPLACED EXTERIOR EMERGENCY LIGHT BULB IAW CRJ900 AMM 33-51-15. OPS CHECKS GOODSDR AALA202507013452Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 17H CEILING EMERGENCY LIGHT INOP. (OPEN)SDR AALA202507016708Light · inoperativeAIRCRAFT WAS NOT GROUNDED: ROW 2D EMERGENCY LIGHT CEILING INOP. (OPEN)SDR AALA202507011250Light · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND L3 DOOR EMERGENCY EXIT LIGHT INOP. (OPEN)SDR CALA2025070106123Windshield · damagedVERY LOUD WIND NOISE FROM R2 WINDOW ON TAKEOF F AND CLIMB PASSIN G 10K NOISE BECAME INTOLERABLE. REMOVED AND REPLACED #2 RH OPENABLE WINDOW IN REF AMM 56-12-11. OPS CHECK GOOD, AND LEAK CHECK GOOD. NO FUTHER DEFECTS NOTED.SDR CALA2025070106122Roller · wornREVERSER LIGHT LIGHT ON, THRUST REVERSER OPS NORMALLY ENGINE 1 REQUESTING MEL 7801A FOR #1 ENGINE THRUST REVERSER. COMPLIED WITH. THRUST REVERSER LOCKED OUT. OBSERVED FOR STOW FAULT CHANGED SLEEVE STOWAGE PROX SENSOR ROLLERS REF IPC/AMM 78-34-01. NOTICED THSDR CALA2025070106113Slide · faultedACFT L OVERWING SLIDE BLOWN. REMOVED SLIDE FROM ACFT. BLOWN SLIDE PLACED IN AFT CARGO. ALL MX DONE IN REF WITH AMM 25-62-42/401 CONFIG 00 PARTS TRANSACTION ROTABLE PARTS CHG:TT # 1480754 SN OFF 4281 PN OFF 31-2561-9-0001.IPC REFERENCE # MFG SN OFF NOT ON AC M&SDR CALA2025070106112Slide · faultedEMERGENCY SLIDE DOOR 2R BAD FROM STOCK. REMOVED DOOR 2R SLIDE REF AMM 25-62-44-000-802-A UP TO AND INCLUDING STEP A 4,G. COMPLETED REMOVAL OF SLIDE PER AMM 25-62-44-000-802-A. SN A6692. REQUESTING INSPECTION VERIFICATION FOR ELECTRICAL WIRING ROUTING AND GIRTSDR CALA2025070106111Lamp · inoperativeDOOR ARM LIGHT ON 2L NOT ILLUMINATED WHEN DOOR ARMED RELAMPED OPS CKS OKSDR CALA2025070106110Slide · no discrepancyACCOMPLISHED THE REMOVAL OF THE R2 ESCAPE SLIDE IN REF WITH AMM TASK 25-62-44-000-802-A. AND RENDER A SAFE CHECK LIST. COMPLETED THE INSTALLATION OF THE R2 ESCAPE SLIDE IN REF WITH AMM 25-62-44-400-802-A. OPS CHECK GOOD. ACCOMPLISHED INSTALLATION INSPECTION OFSDR CALA2025070106109Lanyard · out of positionDOOR 4L SLIDE ARM LIGHT NOT ILLUMINATED WITH DOOR ARMED IN FLI GHT REMOVED L4 SLIDE COVER, PINNED SLIDE AND FOUND GREEN SURVIVAL LANYARD IN THE WAY OF GIRT BAR. RESECURED LANYARD, REMOVED PIN FROM SLIDE, INSTALLED SLIDE COVER REF AMM 52-11-02-904-004. OPS CH