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 FDEA202509151703Skin · ground damageAFT CGO LOADER WENT UP (BY ITSELF PER RAMP) AND HITTED THE AFT FUSELAGE BELOW DOOR FRAME, LOADER STILL IN CONTACT CURRENTLY, BUT A HOLE IS VISIBLE ALREADY ABOUT 5 SQUARE INCHES. WILL EVALUATE WHEN LOADER IS REMOVED. OMPLIED WITH EA 1-5330-T0384834 PART 2 SDR FDEA202509151702Seat Track · unknownEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1831 TO STATION 1887 X = 8.5 LEFT HAND SIDE. EXISTING SEAT TRACK REPAIR AT MAIN DECK CARGO COMPARTMENT BETWEEN STATION 1831 TO STA 1887 X = 8.5 LEFT HAND SIDE EVALUATED AND FOSDR FDEA202509151701Seat Track · wornEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1209 TO STATION 1247 X = -47.5 RIGHT HAND SIDE. EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT SEAT TRACK BETWEEN STATION 1209 TO STATION 1247 X = -47.5 RIGHT HAND SIDE EVALUATSDR FDEA202509151700Seat Track · wornEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1129 / 6-0 TO STATION 1129 / 6-100 X = -47.5 RIGHT HAND SIDE EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT SEAT TRACK BETWEEN STATION 1129/6-0 TO STATION 1129/6-100 X = - 47.5SDR FDEA202509151699Seat Track · wornEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 6-60 TO STATION 6-100 / 1129 X = 8.5 LEFT HAND SIDE. EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT SEAT TRACK BETWEEN STATION 6-60 TO STATION 6-100/1129 X = 8.5 LEFT HAND SIDESDR FDEA202509151698Seat Track · wornEXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BETWEEN STATION 1611 TO STATION 1671 X = -8.5 RIGHT HAND SIDE. EXISTING REPAIR AT MAIN DECK CARGO COMPARTMENT FLOOR SEAT TRACK BERWEEN STATION 1611 TO STATION 1671 X= -8.5 RIGHT HAND SIDE EVALSDR QR9R2025091500002Control Lever · out of limitsRECEIVED CONTROL LEVER ASSEMBLY FROM AIRBUS UNSERVICEABLE. CONTROL LEVER MEASURED .045" AROUND SLIP BUSHING. MAX ALLOWED IS .019".SDR QR9R2025091500001Air Data Module · inaccurateCOPILOT ALTIMETER HAS 80 FOOT ERROR. 30.15 READ IN KOLSMANN WINDOW WITH FIELD ELEVATION OF 301 SET. CURRENT ALTIMETER AT TIME OF CHECK WAS 30.07. REMOVED AND REPLACED #1 ADC IAW 34-11-00, 4-1.SDR JR2R20250915729Seat Track · corrodedAFT WET AREA, SEAT TRACK AT RBL10 IS CORRODED AT FR84 AT AFT SIDE OF TRACK, OUT OF LIMITS. REPAIREDSDR JR2R20250915753Skin · dentedLOWER AFT FUSELAGE SKIN BETWEEN FR97-FR97 AND STR27L-STR28L HAS A PROTUDING DENT. REPAIRED.SDR CALA2025091508872Fuse · failedL2 EXTERNAL EMERGENCY EXIT LIGHT DOES NOT ILLUMINATE DURING TEST. REPLACED FUSE ON POWER SUPPLY, REF LP 6251118 FOR WORK PERFORMED. OPS CHECK GOOD.SDR NACA2025091400001Pressure Switch · no testE/E COOLING SYSTEM DIFFERENTIAL PERSSURE SWITCH FAILED FUNCTIONAL CHECK. REMOVED AND REPLACED PRESSURE SWITCH E/E COOLING SYSTEM IAW 21-58-29-004-001 AND 21-58-29-404-013. OPS CHECKED GOOD AMM 21-58-00-705174-008.SDR SWIA2025120800914Web · corrodedLEFT LOWER WEB HAS CORROSION. REMOVED AND REPLACED LT LOWER WEB WITH NEW WEB IAW SRM 53-11-10-201-004-A01.SDR SWAA2025102314618Strap · corrodedCORROSION STRAP LOCATED BETWEEN BS787 TO BS794 AND WL154 FROM STR25R TO STR26R AFT CARGO COMPARTMENT. REPLACED STRAP LOCATED BETWEEN BS787 TO BS794 AND WL154 FROM STR25R TO STR26R AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 SDR SWAA2025102314619Strap · corrodedCORROSION STRAP LOCATED BETWEEN BS794 TO BS807 AND WL154 FROM STR25R TO STR26R AFT CARGO COMPARTMENT. REPLACED STRAP LOCATED BETWEEN BS794 TO BS807 AND WL154 FROM STR25R TO STR26R AFT CARGO COMPARTMENT IAW B737-700 SRM 51-10-02-0G-0 ITEM 9; SRM 51-40-02-0G-0 SDR SWAA2025102314554Access Panel · crackedCRACK ANGLE ACCESS PANEL 844DZ AT AFT GALLEY DOOR. REPLACED ANGLE ACCESS PANEL 844DZ AT AFT GALLEY DOOR DUE TO ALLOWABLE DAMAGE NOT FOUND IN SRM 52-10-02-1A-4; MEASURE OF CRACK IS: 0.310'. ANGLE REPLACED IAW SRM 51-40-02; SRM 51-10-02 PARAGRAPH 9 AND DRAWINSDR SWAA2025102214613Cargo Track · crackedCRACK TRACK LBBL 17.24 LOCATED BS767 AFT CARGO COMPARTMENT. REPAIRED CARGO TRACK LOC LBL17.24 BTW BS 747 TO BS 787 IAW B737-700 SRM 53-00-53-2R-3 REPAIR 3.SDR SWAA2025102114568Angle · corrodedCORROSION ON ANGLE LOCATED BTW BS 294.5 TO BS 332.1 RBL 58 WL 208.1 AT FWD GALLEY AREA (3 POINTS). REPLACED ANGLE LOCATED BTW BS 294.5 TO BS 332.1 RBL 58 WL 208.1 AT FWD GALLEY AREA IAW B737-800 SRM 51-10-02 ITEM 9 AND DWG 141A8310; SHEET 23; REV -.SDR SWAA2025102114563Angle · corrodedCORROSION INNER CHORD LOCATED BTW BS 294.5 TO BS 332.1 RBL 57 WL 208.1 (5POINTS) AT FWD GALLEY AREA. REPLACED NEW INNER CHORD AND FASTENERS LOCATED BTW BTW BS 277 TO BS 332.1 RBL 57 WL 208.1 IAW B737-800 SRM 51-40-02 SRM 51-10-02 ITEM 9 AND DWG 141A8310 SHEETSDR SWAA2025102014339Circuit Breaker · brokenBROKEN CIRCUIT BREAKER ON POSITION A9 PANEL P6-11 CABIN EMERGENCY LIGHTS AT FLIGHT COMPARTMENT. REMOVED AND REPLACED CIRCUIT BREAKER ON POSITION A9 PANEL P6-11 CABIN EMERGENCY LIGHTS AT FLIGHT COMPARTMENT IAW WDM 33-51-11 AND SWPM 20-83-11 AND PERFORMED OPERASDR SWAA2025101614663Strap · crackedCRACK ON STRAP LOCATED BS727 AND RBL35 BULKHEAD AREA AT AFT CARGO COMPARTMENT. REPLACED STRAP LOCATED BS727 AND RBL 10 TO RBL 45.57 BULKHEAD AREA AT AFT CARGO COMPARTMENT IAW B737-800 SRM 51-10-02-0G-0 ITEM 9; AND DWG 144A2600 SHEET 1060 REV - .SDR SWIA2025100700914Skin · ground damageEXTERIOR DAMAGE FROM LAV SERVICING TRUCK NEAR AFT POTABLE WATER PANEL: UPON INSPECTION, FOUND DAMAGE TO FUSELAGE STRUCTURE BETWEEN FS574 €“ FS589.00 AND BTW STR 17R-18R. IMPACT (LAVATORY CART) CAUSED DAMAGE TO MULTIPLE PARTS. REFER TO REO 601R-53-61-8383 TABSDR SWAA2025100614211Bracket · brokenBROKEN BRACKET ON LOWER SIDE OF EMERGENCY EXIT 832. REPLACED BRACKET ON LOWER SIDE OF EMERGENCY EXIT 832 IAW AMM 52-22-51-400-801 STEP 3.D (2) (D).SDR IPXA2025093000592Floorboard · crackedMDC AFT FLOORBOARD 261DM BROKEN. .SREO 16407-REQ001 C/WSDR CALA2025100609631Floorbeam · corrodedFLOOR BEAM AT STA 1640 HAS VARIOUS SPOTS OF CORROSION. WORK ACCOMPLISHED ON BAM N/R 002799053 REMOVED DAMAGED SECTION OF FLOOR BEAM FABRICATED NEW SECTION, AND REPAIR PARTS TREATED PRIMED AND INSTALLED REF SRM 53-00-51-2R-8 AND ECRA 5360-02013 .SDR IPXA2025100103715Skin · crackedUPON WORKING EO-88069-REQ047 REV1, TASK CARD T3F18E0054EL6, FOUND EVIDENCE OF POSSIBLE CRACK AT HOLE LOCATION NUMBER 10 L/W UPPR SKIN OF #1 ENG. PYLON. ATA-54-00.PERFORMED BLEND-OUT ON CORRODED AREAS LOCATED AT UPPER FACE SURFACES OF INBD AND OUTB DRAG FITTINSDR SWAA2025093014344Light · deterioratedDETERIORATE PHOTOLUMINESCENT AT PASSENGER CABIN RH SIDE (7EA). THE REPLACEMENT PHOTOLUMINESCENT STRIP RH SIDE AT PASSENGER CABIN (7 EA) WILL BE ACCOMPLISHED IN TASK 733-080-00-01 (TTG8Q003FNTQ)SDR SWAA2025093014343Light · deterioratedDETERIORATE PHOTOLUMINESCENT STRIP AT PASSENGER CABIN LH SIDE (7EA). THE REPLACEMENT PHOTOLUMINESCENT STRIP AT PASSENGER CABIN LH SIDE (7EA) WILL BE ACCOMPLISHED IN TASK 733-080-00-01 (TTG8Q003FNTQ).SDR SWAA2025093014560Light · damagedFWD CLOSE OUT EXIT LIGHT HOUSING ASSEMBLY DAMAGED. REMOVED AND REPLACED A NEW FWD CLOSE OUT PANEL EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-01-960-802.SDR SWAA2025093014561Light · damagedFWD CLOSE OUT CALL LIGHT HOSUING ASSEMLY DAMAGED. REMOVED AND REPLACED A NEW FWD CLOSE OUT PANEL EXIT SIGN LIGHT ASSEMBLY IAW AMM 33-51-01-960-802. OPS CHECKED OK.SDR BAGA2025092900009Pump · failedDUE TO GRADUAL INCREASE IN HYD 1 TEMP TO 126 C ABOVE REDLINE, PERFORMED QRH SHUTTING OFF HYD SYSTEM 1 SOV AND PTU, REQUIRING DIVERSION AND EMERGENCY LANDING AT NEAREST SUITABLE AIRPORT. HYD SYSTEM 1 EDP, CASE DRAIN FILTER, PRESSURE FILTER, RETURN FILTER, AND SSDR SWIA2025F01400Fitting · brokenAFT PASSENGER DOOR AFT GIRT BAR FLOOR FITTING FLAP SLIDE SPRING HAS 1 BROKEN OFF TAB. (C-CHECK RO 09/28/2025)REMOVED AND REPLACED AFT PASSENGER DOOR AFT GIRT BAR FLOOR FITTING FLAP SLIDE SPRING. REF AMM 53-23-21SDR SWIA2025F01399Fitting · damagedAFT SERVICE DOOR FORWARD AND AFT GIRT BAR FLOOR FITTING FLAP SLIDE SPRINGS EACH HAVE 1 BROKEN OFF TAB. (C-CHECK RO 09/28/2025)REMOVED AND REPLACED AFT SERVICE DOOR FORWARD AND AFT GIRT BAR FLOOR FITTING FLAP SLIDE SPRINGS. REF AMM 53-23-25SDR SWIA2025092900014Beam · corrodedAFT WET AREA RH BEAM CORRODED AT FR 87.SDR DALA2025092306962Skin · damagedEXISTING REPAIR FOUND THAT IMPACTS INSPECTION ACCOMPLISHMENT. REPAIR INVESTIGATION REQUIRED BEFORE FURTHER FLIGHT. RH WING XRS 14- XRS 177. REF. EA 619064-14AD REV. B SECT II. DVI OF AFT SIDE OF SPAR CAP AT STOP DRILL SHOWS NO DISCREPANCY. (1199238)SDR CALA2025092209085Cartridge · crushedTAIL STRIKE REPORTED ON ARRIVAL.DPI POPPED. PERFORMED PART OF TAIL STRIKE INSPECTION PER AMM 05-51-32-212-011. FOUND POPPET POPPED. RESET POPPET. INSPECTED EXTERNAL FUSELAGE FROM AREA NEAR AFT BULKHEAD OF AFT CARGO PIT TO TAIL, INSPECTED APU BAY, INSPECTED LOWSDR CALA2025092209084Angle · crackedLEFT AIR CONDITIONER BAY AFT UPPER ANGLE CRACKED ON IB SIDE. REMOVED FASTENERS AT STA 663 LT VAPOR BARRIER ANGLE FROM LBL 5 TO LBL 30 FOR ACCESS TO REPAIR PER SRM 51-40-02-0G-0.CUT AND REMOVED BARRIER ANGLE FROM LBL 5 TO LBL 20 FOR ACCESS TO REPAIR PER SRM 5SDR 2025FA0000656Hydraulic Line · leakingPILOT REPORTED: ON TAKEOFF AT KPHL, WE LOST A SYSTEM HYDRAULICS WHEN RAISING THE GEAR. LOST VOLUME ON THE A SIDE. WE LANDED AT KPNE AFTER RUNNING APPROPRIATE EMERGENCY CHECK LISTS. ON INSPECTING THE AIRCRAFT AFTER LANDING, WE DISCOVERED HYDRAULIC FLUID LEAKINGSDR CALA2025091809040Actuator · trippedDURING FINAL APPR FLAPS GOT STUCK AT FLAPS 5. PERFROMED CHECKLIST. USED ALTERNATE FLAPS SWITCH. CREW STATES, FLAPS 30 SELECTED ON APPROACH INTO ORD. SOMETHING FELT WRONG AND LOOKED AT FLAP MECHANICAL INDICATOR ON FWD PANEL & FLAPS LOCKED AT 5 DEGREES & NEESDR CALA2025091809039Radome · no discrepancyREJECTED T/O FOR BIRDSTRIKE TO THE NOSE AT AROUND 115 KNOTS PERFORMED BIRDSTRIKE INSPECTION REF AMM 05-51-18-210-801. FOUND SMALL BLOOD SPOT ON UPPER RIGHT SIDE OF NOSE RADOME. CLEANED BIRDSTRIKE AND INSPECTED AREA WITH NO DEFECTS NOTED,SDR SWAA2025091714751Lamp · inoperativeSIDEWALL LIGHT AT SEAT ROW 11 ABC IS INOPERATIVE. OK TO CONTINUE PER MEL 33-2-03 SP1B. REPLACED THE LAMP IN SIDEWALL LIGHT AT 11ABC IAW AMM 33-51-04.SDR SWAA2025091714603Flashlight · inoperativeFWD INBOARD FA FLASHLIGHT WILL NOT CHARGE. REPLACED THE FWD INBOARD FA FLASHLIGHT PER AMM 25-64-00. OPC GOOD.SDR AALA202509174089Oil System · leakingAIRCRAFT WAS GROUNDED: MUSTY, DIRTY SOCK ODOR THROUGHOUT ENTIRE AIRCRAFT IN FLIGHT REPORTED BY FLIGHT ATTENDANTS. THE ODOR WAS ALSO FAIRLY STRONG IN THE FLIGHT DECK. IT WASN'T NOTICEABLE ON THE GROUND WITH THE APU RUNNING. MAINTENANCE FOUND THE PLENUM SEAL LEASDR N6WA2025091703Skin · corrodedCORROSION ON FUSELAGE SKIN UNDER UPPER TCAS ANTENNA. REPAIRED FUSELAGE SKIN UNDER UPPER TCAS ANTENNA IAW REO-670-53-21-1250SDR VNAA2025091711102Windshield · sparksLH WINDSHIELD HEAT POPPED SPARKS, SMOKE, FUMES IN CRUISE FLIGHT / LH WINDSHIELD IAW CRJ 700 AMM 56-11-01-400-801-A01-PSA. ALL OPS AND LEAK CHECKS GOOD.SDR DXTA2025091704958Battery Pack · no testALL FORWARD EMERGENCY EXIT LIGHTS INOP IN ARM OR ON POSITION WITH BATTERY OFF. BATTERY PACK #1 RESET INERTIAL SWITCH VERIFIED CONNECTIONS TO BATTERY PACK #1 ARE GOOD, NO CHANGE, ALL FORWAR LIGHTING STILL INOP, SWAPPED BATTERY PACK #2 AND REPOSITIONED INTO #SDR DXTA2025091704961Actuator · defectiveDURING LANDING GEAR EXTENSION WE RECEIVED GEAR DISAGREE L CAS MESSAGE FOLLOWED BY CROSS HATCHED LEFT MAIN GEAR INDICATION. FOLLOWED THE QRH USING THE LANDING GEAR BLOWDOWN AND MAIN MANUAL RELEASE HANDLE. WE NEVER GOT A 3 GREEN, LANDED NORMALLY. REPLACED LT MLSDR DXTA2025091704973Precatch · malfunctionedDOOR PRECATCH DOES NOT RELEASE THE DOOR WHEN PULLED TO RELEASE, THE PRECATCH HOLDS THE DOOR WHEN PRECATCH HANDLE IS NORMAL BUT DOES NOT RELEASE IT WHEN PULLED TO RELEASE. COMPLETED MULTIPLE OPS CHECKS OF MED PRE-CATCH RELEASE FROM INTERIOR AND EXTERIOR, NO DESDR DALA2025091706829Panel · stuckAFT GALLEY OXYGEN MASK COVER NEAR DOOR 2L STUCK BEHIND DOOR PANEL. APPEARS IT WILL NOT DEPLOY. PANEL IS SECURED PER A320 AMM 35-23 OK FOR SVC. (LP: 1199291)SDR DALA2025091706826None · noneINSPECTION ER/A 624251-14AD REVISION ORIGINAL. REPAIR AT TOP SKIN PANEL 2, UPPER SURFACE, BETWEEN RIBS 14-16 REQUIRES FOLLOW ON INSPECTIONS PER ER/A 624251-14AD SECTION II PRIOR TO 46,131 TOTAL FLIGHT CYCLES OR 94,851 TOTAL FLIGHT HOURS, WHICHEVER COMES FIRST,