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 IPXA2025080383490Skin · corrodedCORROSION FOUND AT SKIN AREA STA 1885.20 S-17L JUST ABOVE APU LEFT DOOR. PERFORMED EO-94659-REQ1 AND VT-MAE EA 757-5380-27-A4073, REV -.SDR SWAA2025081194618Seat Track · crackedACCOMPLISH REPAIR ON FLOOR STRUCTURE SEAT TRACK LOC BTW BS 727C TO BS 727D AND AT LBL 24.75 2025-417409<[01] PERFORMED REPAIR ON FLOOR STRUCTURE SEAT TRACK LOC BTW BS 727C TO BS 727D AND AT LBL 24.75 I.A.W EA 25-153-02012;[02] PERFORMED REPAIR ON FLOOR STRUCTUSDR IPXA2025072982984Floor Panel · brokenMAIN CARGO FLOOR PANEL 252LJ CRACKED. MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001.SDR SCNA20250811315Brake · leakingGROUND CREW STATED WHEEL SMOKING DURING TAXI IN. LOOKS LIKE BRAKES ARE LEAKING FLUID CAPTAIN SIDE MAIN LANDING GEAR. R&R #2 BRAKE ASSY LEAK AND OPS CHECK GOOD IAW AMM 32-41-41 OK FOR SERVICE.SDR IPXA2025080708252Tee Angle · corrodedAT STA 1200 LOWER T-CHORD SUUPORT CLIP HAS CORROSION ON INNER FLANGE. DOT 8-015.CLEANED INTRECOSTAL AT STA 1200 NO CORROSION NOTED FOUND TO BE PAINT DAMAGED ONLY IAW B757-200 SOPM 20-30-03 ACETONEQT P/N ACETONEQT BATCH#0004346929 1QT, MAROON HAND PAD P/N 02-00SDR IPXA2025072588319Paint · damagedINTRECOSTAL AT BS 1090, RBL 50 HAS SURFACE CORROSION ON INNER SURFACES. CLEANED INTRECOSTAL AT BS 1190, NO CORROSION NOTED FOUND TO BE PAINT DAMAGED ONLY IAW B757-200 SOPM 20-30-03 ACETONEQT P/N ACETONEQT BATCH#0004346929 1QT, MAROON HAND PAD. TREATED AND PRISDR SWIA2025080600723Spring · brokenFWD PAX DOOR AFT SLIDE FITTING HAS A BROKEN SPRING. REMOVED AND REPLACED FWD PAX AFT SLIDE FITTING SPRING REF ERJ 175 AMM 53-10-21-400-804-A.SDR IPXA2025072980019Floor Panel · damagedMAIN CARGO FLOOR PANEL 251XJ HS EXPOSED COMPOSITE IN MULTIPLE LOCATION.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR IPXA2025072980214Floor Panel · damagedMAIN CARGO FLOOR PANEL 251LJ HAS COMPOSITE DAMAGE AROUND FASTENER HOLE.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR REXA2025080600794Skin · damagedPERFORM PERMANENT REPAIR OF LIGHTNING DMG AT FS 720 ST5L-6L LIGHTNING DMG AT FS 720 ST5L-6L WAS REPAIRED PER EA CRJ953-19773 REV. IRSDR REXA2025080600793Access Panel · corrodedITIAL INSPECTION: CORROSION ON SETTLEMENT AREA OF ACCESS PANEL 195AB CORROSION ON SETTLEMENT AREA OF ACCESS PANEL 195AB (DOOR LANDING) WAS EVALUATED OUT OF LIMITS PER CRJ900 SRM 53-00-00-101-001-A01 AND WAS REPLACED PER CRJ900 SRM 51-42-10-001-001-A01 AND CRJ9SDR REXA2025080600792Bracket · corrodedCORROSION ON HYDRAULIC LINES SUPPORT PLATES (IN BK, LG EXT, LG RET) RBL 45 AND LBL45 AT RH/LH MLG WHEEL WELL. CORROSION ON HYDRAULIC LINES SUPPORT PLATES (IN BK, LG EXT, LG RET) RBL 45 AND LBL45 AT RH/LH MLG WHEEL WELL WAS REMOVED PER CRJ900 SRM 51-21-06-001-0SDR REXA2025080600791Hinge · corrodedOUT OF SCOPE: CORROSION ON AFT HINGE OF AFT CARGO STEP PLATE AFT HINGE OF AFT CARGO STEP PLATE WAS EVALUATED OUT OF LIMITS PER CRJ-900 SRM 53-00-00-101-001-A01, WAS FABRICATED PER EA CRJ953-19720 REV. IR AND WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01SDR REXA2025080600790Hinge · crackedOUT OF SCOPE: CRACK ON FWD HINGE OF AFT CARGO STEP PLATE FWD HINGE OF AFT CARGO STEP PLATE WAS EVALUATED OUT OF LIMITS PER CRJ-900 SRM 53-00-00-101-001-A01, WAS FABRICATED PER EA CRJ953-19672 REV. IR AND WAS REPLACED PER CRJ900 SRM 51-42-06-001-001-A01SDR IPXA2025072980451Floor Panel · damagedMAIN CARGO FLOOR PANEL 251EN HAS COMPOSITE DAMAGE AT CORNERS.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR IPXA2025072980861Floor Panel · damagedMAIN CARGO FLOOR PANEL 251BN HAS EXPOSED COMPOSITE.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001.SDR IPXA2025072983810Floor Panel · crackedFAULT-Z200-INT MAI CARGO FLOOR PANEL 251HM EDGE CRACKED.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR IPXA2025072981238Floor Panel · damagedFAULT-Z200-INT MAIN CARGO FLOOR PANEL 252ZG HAS COMPOSITE DAMAGE AT EDGE.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR IPXA2025072983615Floor Panel · crackedMAIN CARGO FLOOR PANEL 252FJ CRACKED.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR IPXA2025072986078Floor Panel · damagedMAIN CARGO FLOOR PANEL 251LG HAS COMPOSITE DAMAGE TO EDGE.MCD FLOOR PANEL REPAIRED IAW A300-600 SREO-42721-REQ001SDR AALA202508040410Apu · contaminatedAIRCRAFT WAS GROUNDED: APU DETERMINED TO BE SOURCE OF ODOR. PLACED ON MEL. MAINTENANCE DECONTAMINATED APU PER JC 26L00021014.SDR DALA2025080105783Iru · faultedDIVERSION TO MSP DUE TO F/O ADI DISPLAY ISSUES. R & R IRU. OPS NORMAL.SDR AALA202507318406Oven · odorAIRCRAFT WAS NOT GROUNDED: LEFT OVEN FORWARD GALLEY HAS A BURNT SMELL EMANATING FROM IT. CONFIRMED NUMBER 1 OVEN HAS BURNT SMELL. CLEAM OFF BURNT FOOD PARTILCES FROM OVEN, PER CMM 25-37-26, OPERATED OVEN AND NO BURNT SMELL NOTED.SDR DALA2025073105731Oil System · lostATB, IFSD RETURNED HNL DUE TO NR 2 ENGINE OIL LOSS AND ENGINE SHUTDOWN. REPLACED NBR 2 ENGINE.SDR DALA2025073005717Stringer Splice · damagedSHIP 3360 STRINGER S-1R SPLICE REPAIR BETWEEN FR60-FR64 & SKIN BLEND NEAR S-1R/FR60-61. MAJOR REPAIR. REPAIRED PER ERA 627744-14. (1101667)SDR JJBA20250730112Hinge Fitting · damagedINBD HINGE FITTING #1 NICKED ON LH AILERON. BUSHING REPAIRS AND ALTERNATE FASTENERS ON LH AILERON INBD FITTING.SDR DALA2025073005712Oven · odorDIVERTED TO YYR DUE TO ELECTRICAL ODOR IN AFT GALLEY. GALLEY EQUIPMENT ISOLATED BY CREW AND ODOR DISSIPATED. REPLACED NUMBER 4 AND 5 OVENS FOR PRECAUTION. NO OTHER TROUBLE FOUND.SDR AALA202507298154Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 950, LBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR MHNA20250723Dampener · brokenDURING A ROTOR TRACK AND BALANCE FLIGHT, THERE WAS AN ISSUE. AFTER COMPLETION OF THE FINAL MCP TRACKING STAGE, A MODERATE TO SEVERE VIBRATION WAS FELT THROUGHOUT THE AIRFRAME. THE DECISION WAS MADE TO RETURN IMMEDIATELY TO THE SHIP'S DECK, AT WHICH POINT THE SDR SWIA2025072800023Windshield · cracked2 CRACKS OBSERVED IN CAPTAINS SIDE WINDSHIELD. TOP RIGHT CORNER. (FLIGHT 3794 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30545140 WITH THE FOLLOWING CORRECTIVE ACTION: "REMOVED AND REPLACED CAPTAINS WINDSHIELD PER ERJ 175 AMM 56-11-00. LEAK ASDR IPXA2025072586005Profile · crackedFR80 L/H CORNER T-PROFILE WITH CRACK. REMOVED AND REPLACED T-PROFILE IAW SRM 51-40-21.SDR DALA2025072805652Stringer · not reportedSHIP 3360 DTE REQUIRED. ERA 627560-14 ISSUED FOR FUSELAGE STRINGER S-1LH / /SPLICE REPAIRS / BETWEEN FR59-64. THIS ERA IS MAJOR. CORRECTIVE ACTION: COMPLIED WITH ERA. (1101515)SDR DALA2025072805651Skin · damagedSHIP 3360 DTE REQUIRED. ERA 627916-14 ISSUED FOR FUSELAGE / SKIN / FR62-63 / STR-1R TO 2R / TOOLING DAMAGE. CORRECTIVE ACTION: COMPLIED WITH ERA 627916-14. (1102065)SDR DALA2025072805621Lamp · inoperativeSHIP 6710 1 R DOOR SLIDE INDICATION LIGHT INOP. CORRECTIVE ACTION: RELAMPED, FOUND GREASE HARDENED AND PREVENTING GIRT BAR FROM ENGAGING FULLY. REMOVED ALL DEBRIS. OPS NML. (7019104)SDR JJBA20250728100Shear Tie · crackedLH FR 71 BTW STR 5L-6L SHEAR CLIP FOUND CRACKED. SHEAR CLIP FABRICATED AND INSTALLEDSDR CALA2025072806955Cable · stretchedRIGHT OFF-WING ESCAPE SLIDE OPERATIONAL CHECK - SLIDE FAILS TO INFLATE. NR 7 SPOILER SQUIB, LATCH ACTUATOR AND BOTH DOOR ACTUATORS BLEW BUT BOTTLE FAILED TO PRESSURIZE SLIDE TO INFLATE AND DEPLOY. INSPECTED CAUSE OF SLIDE NON-INFLATION AND FOUND CROSS PIN TWISDR CALA2025072806954Transmitter · faultedCREW REPORTED LOW OIL QTY & LOW OIL PRESSURE JUST BEFORE TOP OF DESCENT WITH ENG 2. CREW SHUT DOWN #2 ENG FOR THE REMAINING FLIGHT. OIL QUANTITY RECOVERED BEFORE LANDING. SERVICED #2 ENGINE TO FULL 30 AFTER ARRIVAL TO GATE. 4 QUARTS ADDED TO NUMBER TWO ENGINE.SDR DXTA2025072804343Elec Connector · damagedALMOST IMMEDIATELY AFTER GEAR RETRACTION, WE REVEIVED EMER LIGHT NOT ARMED CAS MESSAGE. THE EMERGENCY LIGHTS WERE ALL ILLUMINATED IN THE CABIN. THE BATTERY VOLTAGE WENT FROM GREEN 28.5 VOLTS TO AMBER 25.3 VOLTS AND VERY SLOWLY DECREASED. THE SCHEMATIC SHOWED TSDR AALA202507250024Fuel Sys · out of balanceAIRCRAFT WAS NOT GROUNDED: FUEL IMBALANCE THE CENTER TANK HAS MORE THAN 1000 LBS AND WINGS TANKS ARE NOT FULL. TANK QUANTITY WIRING CHECKS ARE ALL GOOD. LEFT AND RIGHT WING QUANTITIES ARE WITHIN LIMITS. PER AMM 28-41-00-720-801 +/- 350 LBS AND PER NON ROUTINESDR 2025F00165Tire · blownON JULY 23, 2025, AT APPROXIMATELY 19:47 LOCAL TIME, FLIGHT 807, OPERATING AIRCRAFT N874SA, EXPERIENCED A LEFT-HAND MAIN LANDING GEAR (LH MLG) TIRE FAILURE DURING THE LANDING ROLLOUT. AS A RESULT OF THE TIRE BLOWOUT, THE AIRCRAFT CAME TO A STOP ON THE TAXIWAY.SDR QMLA2025072520076Profile · crackedDURING 500HR AIRFRAME INSPECTION FOUND THE LH AND RH A-PROFILES CRACKED AND A CRACK IN THE TRANSMISSION DECK FLOOR .SDR R61A2025072300315Brake · faultedPARKING BRAKE NOT RELEASED IN AIR. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. R&R EMERGENCY PARKING BRAKE PRESSURE SWITCH #2.SDR WX0A2025072532513Battery · no test(AIRCRAFT NOT GROUNDED) BATTERY FAULT INDICATION DURING EPSU BITE TEST / REMOVED AND REPLACED EPSU BATTERIES, REF WO519197"SDR WX0A2025072532511Cover · detached(AIRCRAFT NOT GROUNDED) FWD OVERWING EMERGENCY EXIT COVER FELL OFF IN FLIGHT. PERFORMED INSPECTION OF FWD OVERWING EMERGANCY EXIT COVER AND REINSTALLED COVER FLAP IAW AMM 52-21-00-200-001-A AND 52-21-11-400-001-A.SDR DALA2025072505602Apu · odorSHIP 3161 DIRTY SOCK SMELL STARTED AFT CABIN THEN SMELT THROUGHOUT CABIN. CORRECTIVE ACTION: FOUND APU AS SOURCE OF CONTAMINATION. DISCONTINUED USE. RESIDUAL CONTAMINATION FOUND ON LT ACM. REPLACED SAME. (1101511).SDR DALA2025072505601Unknown · odorSHIP 3130 BURNT POPCORN ODOR IN GALLEY. CORRECTIVE ACTION: C/W AMDS 0550-9001-A320FAM. C/W AMDS CARD 0550-2002. (1102220).SDR AALA202507254373Seal · misinstalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO LAX DUE TO THE FLIGHT CREW REPORTING THAT WHILE PASSING FL 190 NOTICED CABIN CLIMBING THROUGH 9300 FL. RATE OF CLIMB ABOUT 2500 PER MINUTE, THE FLIGHT CREW TRIED TO LEVEL OFF BUT IT SDR AALA202507259027Proximity Sensor · faultedAIRCRAFT WAS GROUNDED: FLIGHT CREW REPORTED LANDING GEAR DOORS NOT CLOSED ECAM DISPLAYED AT GEAR UP. FLIGHT CREW ACCOMPLISHED ECAM PROCEDURES AND RECYCLED THE LANDING GEAR WHICH CLEARED THE ECAM MESSAGE. MAINTENANCE ACCOMPLISHED A BITE CHECK AND NOTED A FAULT SDR AALA202507251794Strip · delaminatedAIRCRAFT IN BASE MAINTENANCE: BOTTOM OF RUDDER TRAILING EDGE DELAMED AT APEX STRIP. REPAIRED APEX STRIP PER SRM 55-41-19-300-004 AND SRM 51-75-12.SDR AALA202507250715Battery · no testAIRCRAFT WAS GROUNDED: BATTERY FAULT MESSAGE DISPLAYED FOR EMERGENCY POWER SUPPLY UNIT 15WL DURING SYSTEM TEST. REPLACED BATTERY FOR EMERGENCY POWER SUPPLY UNIT 15WL AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38.