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 DALA2026012600572Seat Track · corrodedMID CABIN SEAT TRACK FOUND CORRODED AT -Y1959, FRM 37.1 AFT SECTION. THE SEAT TRACK WAS REPLACED IAW SRM 51-72-11. (1417149)SDR DALA2026012600571Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORRODED AT -Y450, FRMS 37.2 - 37.4. : REPLACED THE SEAT TRACK IAW SRM 51-72-11. (1417137)SDR DALA2026012600570Seat Track · corrodedMID CABIN SEAT TRACK FOUND CORRODED AT Y1959 FRMS 37-37.1. REPLACED THE SEAT TRACK IAW SRM 51-72-11. (1417111)SDR DALA2026012600569Seat Track · corrodedMID CABIN SEAT TRACK FOUND CORRODED AT -Y1552.5. REPLACED THE SEAT TRACK IAW SRM 51-72-11. (1417103)SDR DALA2026012600568Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND CORROSION AT FRMS 53.4-53.5, -Y2462. THE SEAT TRACK WAS REPAIRED IAW SRM 53-31-15-300-001. (1417024)SDR DALA2026012600567Seat Track · corrodedCABIN SEAT TRACK AT Y2462, FRMS 32-33 FOUND GOUGED. REPAIRED IAW SRM 53-21-15-300-002. (1417015)SDR DALA2026012600566Seat Track · corrodedCABIN SEAT TRACK FOUND CORRODED AT -Y2462 FRMS 37-37.1. SEAT TRACK REPAIRED IAW SRM 53-21-15-300-002. (1416911)SDR DALA2026012600565Seat Track · corrodedMID CABIN SEAT TRACK FOUND CORRODED AT -Y1959 FRMS 33-34. REPAIRED IAW SRM 53-21-15-300-002. (1416901)SDR DALA2026012600564Seat Track · corrodedCABIN SEAT TRACK, FR 33, Y953 FOUND CORRODED. THE SEAT TRACK WAS REPAIRED IAW SRM 53-21-15-300-002. (1416889)SDR DALA2026012600563Seat Track · corrodedRIGHT AFT CABIN SEAT TRACK AT FR 67 -Y2462 FOUND CORRODED. REPAIRED IAW SRM 53-41-15-300-002. (1416878)SDR DALA2026012600562Seat Track · corrodedCABIN SEAT TRACK UPPER SURFACE FOUND WITH CORROSION AT Y1959 FR56. REPAIRED PER SRM 53-41-15-300-002. (1416855)SDR DALA2026012600561Seat Track · corrodedMID CABIN SEAT TRACK FOUND WITH CORROSION AT Y1959 FR33-34. SEAT TRACK REPAIRED IAW SRM 53-21-15-300-002. (1416834)SDR DALA2026012600560Seat Track · corrodedMID CABIN SEAT TRACK FOUND WITH CORROSION AT -Y1456 FR35-36. SEAT TRACK REPAIRED PER A330 SRM 53-21-15-300-002. (1416815)SDR YENA2026012600069Access Door · openFLT 995, MCO- SJO. AIRCRAFT DIVERTED TO FLL. PASSENGER RECORDED A VIDEO OF OPEN LOWER PANEL ON IMBOARD SIDE OF #1 ENGINE DURING FLIGHT. N606-FLT-MCO-SJO-DIVERSION THE A/C DIVERTED TO FLL, THE CREW REPORTED A PANEL WAS OPEN ON THE NBR 1 ENG AND SEEMED TO BE FSDR GTIA2026012639258Megaphone · inoperativeR2 DOOR MEGA PHONE IS DEAD. INSTALLED NEW R2 MEGAPHONE IAW AMM 25-63-00SDR YENA2026012600068Unknown · odorFLT 47, LGA-TPA. ON DESCENTAT APROX 12,000 FET PILOTS AND F/A NOTICED ODOR OF OIL OR DIRTY SOCKS SMELL. FOUND APU INTERNAL LEAKING OIL. PERFORMED PACK BURN PER AMM 36-10-00 AND INFO NOTICE 2017-T015M. NO ODOR NOTED."SDR GTIA2026012639257Apu · contaminatedFA IS AFT REPORTED A SMELL OF DIRTY CLOTHS DURING TAKE OFF AND THEN GOT SICK. TWO OTHER FA'S GET SICK BEFORE FUME EVENT PROCEDURE WAS APPLYED . TAKE OFF POWER AND CLIMB POWER THROUGH RAIN. -PER TSM 05-50-00-810-831-A, THE CAUSE OF THE ODOR WAS FOUND TO BE COMISDR YENA2026012600067Unknown · odorFLT 1131, CHS-FLL. FUMES EVENT DURING DESCENT AIRCRAFT CLEAN FLIGHT IDLE THRUST.;PERFORMED ENGINE RUN WITH NO ODOR PRESENT IAW FIM BD500-A-J21-22-00-04AAA-423A-A AIRCRAFT OK FOR SERVICE.SDR YENA2026012600066Unknown · odorFLT 2533 DCA-PBI. DESENDING FROM 10000 TO 4000 THE FLIGHT CREW ENCOUNTED DIRTY SOCK ODOR THRUST WAS AT NEAR IDLE AND THE APU WAS NOT RUNNING ODOR WAS MILD TO MODERATE PIC WILL COMPLETE FUME EVENT REPORT AS NECESSARY.;COMPLIED WITH INFORMATION NOTICE 2017-T015SDR IPXA2026012666283Floor Panel · damagedMAJOR REPAIR. MCD FLOOR PANEL 242XEF DAMAGED REF ATTACHED IMAGES. CRACK IS ON AFT SIDE TOP FACE OF PANEL. APPROX 15.5€? IN LENGTH. 1€?-1.5€? FROM AFT SIDE OF PANEL. 1.5€? FROM LEFT AND RIGHT SIDES OF PANELSDR IPXA2026012460816Light · inoperativeFLOOR EXIT LIGHT BY L1 DOOR NOT ILLUMINATING. PERFORMED AMM TEST PROCEDURE FOR EMERGENCY LIGHTING SYSTEM AND "EXIT" PATH SIGN. OPS CHECK WAS GOOD.SDR YENA2026012600064Apu · odorFLT 71 JFK -SLC. "AFTER LANDING SHORTLY AFTER STARTING THE APU A STRONG BURNOUT ODOR WAS DETECTED IN THE COCKPIT AND FWD GALLEY APU BLEED WAS TURNED OFF ODOR DISSAPATED. INFLIGHT REPORTED A SLIGHT HAZE IN THE CABIN. NO VISIBLE HAZE IN THE COCKPIT.;PERFORMED FISDR AALA202601262672Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS PANEL CAUTION SLIDE DISARMED CHECK DOOR PRESSURE. MAINTENANCE SERVICED THE R1 DOOR DAMPER AND EMERGENCY OPERATION CYCLINDER PER AMM 52-10-00.SDR AALA202601267043Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: CIDS CAUTION LOW PRESSURE (APPEARS TO BE DOOR 1L). MANTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-11-14.SDR AALA202601266082Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: AFT RIGHT DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DALA2026012600559Fitting · fodR1 DOOR WOULD NOT DISARM. INSPECTED GIRT BAR & FLOOR FITTINGS. FOUND DEBRIS ON FLOOR FITTINGS. CLEANED DEBRIS & ENSURED PROPER LUBRICATION. REF B757 AMM 25-66 DOOR ARM/DISARMING OPS CKS NORMAL. (7495036)SDR DALA2026012600557Repair · not reportedIN REF A.A AMDS 5300-01056-0401 STEP 4 REPAIR WAS FOUND IN S-26L STA 520-540 WITH DIMENTIONS WIDTH 10'' AND LARGE 10''. REF ERA 462819-14. (1417922)SDR UIEA2026012400016Control Valve · faultedBLD 2 OVHT/PRV EICAS MSG AT FL360. C/W QRH PROCEDURE IAW FIM 36-11 TASK 944 PERFORMED LEAK CHECK OF PRV, PRVC AND PNEUMATIC LINES, NO LEAK NOTED. R & R ENG 2 PRVC PER AMM 36-11-20, OPS CHECKS GOOD PER AMM 36-11-19</P>)SDR SIMA2026012640002Flashlight Assy · missingFWD FA EMERGENCY FLASHLIGHT MISSING RAR FA FWD EMERGENCY FLASHLIGHT AT FA# 1 STATION AND DEFERRED ORIGINAL FLASHLIGHT. AUTH# 011341D-C REF# 25-51SDR SIMA20260124001Battery · inoperativeAFT EMERGENCY CENTER EXIT LIGHT ON CEILING FOUND INOPERATIVE DURING PS2. REMOVED AND REPLACED AFT EMERGENCY BATTERY #3 IAW AMM CH 33-50-01 OPS CHK GOOD.SDR REXA2026012600023Lamp · inoperativeCABIN EMERGENCY FLOOD LIGHT OUT AT ROW 9 R/R EMERGENCY FLOOD LIGHT BULB AT ROW 9 IAW CRJ 700 AMM 33-51-09.SDR HNAA2026012600083Control Module · abnormalAT ABOUT 1000 FT DURING APPROACH E-2 FIRE DETECT FAIL WITH PACK 2 OVERHEAT DISPLAYED FOR ABOUT 2 SECONDS. DID THIS 2 MORE TIMES PRIOR TO 500 FT. R & R NR 2 ENGINE FIRE CONTROL MODULE IAW AMM 26-11-03. OPS CHK GOOD. OPS CHK OF #2 PACK GOOD IRW AMM 21-51-00.SDR DXTA2026012606667Switch · out of positionEMERGENCY EGRESS LIGHTS ON THE RIGHT SIDE OF FUSELAGE REMAINED ILLUMINATED WITH THE BATTERY OFF AND PASSENGER SAFETY OFF AND EMERGENCY LIGHTS OFF. INSIDE THE CABIN TWO EXIT LIGHTS REMAIN ON IN THE REAR OF THE CABIN AND ONE RIGHT SIDE ISLE LIGHT STAYS ILLUMINATSDR DXTA2026012606665Filter · odorWHEN STARTING RIGHT ENGINE, WE NOTICED A BRIEF CHEMICAL SMELL (SOMEWHAT LIKE ACETONE MIXED WITH ADHESIVE). THE SMELL WENT AWAY. CLIMBING THROUGH 8000', THE SMELL RETURNED BUT STRONGER. WE DONNED OXYGEN MASKS AND DIVERTED. ACCOMPLISHED APPROPRIATE QRC AND QRH SDR FDEA202601240088Floor Panel · dentedDENTS ON FLOOR PANEL 22BFF, SEC 41 OF MDC. THE FLOOR PANEL 22BFF WAS REPAIRED IAW SRM 53-00-50-2R, PAR 4 (B), PAGE 2, FIGURE 201, SHEET 2, REV 93.SDR FDEA202601240087Floor Panel · dentedDENTS ON FLOOR PANEL 222CFF, SEC 41 OF MDC. FLOOR PANEL 222CFF WAS REPAIRED IAW SRM 53-00-50-2R, PAR 4(B), PAGE 2, FIGURE 201, SHEET 2, REV 93.SDR ABXA20260124026Sequence Valve · malfunctionedDEPARTING SJU, CREW REPORTED A GEAR DISAGREE & GEAR DOOR LIGHT MESSAGE WHEN GEAR IN UP POSITION. ALSO REPORTED GEAR INDICATION LIGHTS EXTINGUISHED. FOLLOWED QRH & RETURNED TO SJU. PUT GEAR DOWN TO RETURN TO SJU, RT MLG DID NOT INDICATE DOWN & LOCKED. DID A SDR AALA202601256785Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED: 4L PASSENGER DOOR EMERGENCY CYLINDER ACCUMULATOR LOW PRESSURE. MAINTENANCE SERVICED DOOR ACCUMULATOR AS PER AMM 52-10-00.SDR DALA2026012500537Plate · corrodedAIRCRAFT 6717, CORROSION ON SIDE PLATE LT AND BS 620 AT FWD CARGO BAY. CORROSION LEVEL 2. CORROSION ON SIDE PLATE LT AND BS 620 AT FWD CARGO BAY WAS REPAIRED IAW SRM 53-00-53-2R, PROCEDURE 2, REPAIR 2. (LP 1417580)SDR AALA202601257215Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO RIGHT HAND UPPER KICK FITTING AT BS 663, S18R. REPLACED KICK FITTING PER EA 37095 AND SRM 51-40-05.SDR ABXA20260124027Pressure Switch · malfunctionedAFTER STARTING ENGINES DURING TAXI R OIL FILTER MSG CAME UP A/C RETURNED TO THE GATE AND MTX GROUNDED A/C . MTX REPLACED R ENG SCAVENGE FILTER ELEMENT AND DIFFERENTIAL PRESSURE SWITCH IAW AMM 79-21-04 + 79-35-01 LEAK + OPS CHECK GOOD ACFT REMAINS ETOPS 180. RSDR JR2R20260124397Beam · chafedNR 2 ENGINE OTBD TRANSCOWL LOWER BEAM STRUCTURE CHAFED. REPAIRED PER ETD.SDR REXA2026073101379Stringer · corrodedCORROSION ON STRINGER 21R BTWN BS 333 - 349, THE CORROSION ON THE STRINGER WAS EVALUATED OUT LIMITS IAW SRM 53-21-03-101-006-A01, AND REPLACED IAW SRM 51-42-06-001-001-A01.SDR IPXA2026022446419Frame · crackedFR 46 LH HAS CRACK AT AREA 1. ACCOMPLISHED THE REPAIR PER EO-96738-REQ1 AND EA 300-5315-27-A4350 REV. -. MAJOR REPAIR.SDR SWIA2021012376013Link · damagedMX REQUESTS REMOVAL AND REPLACEMENT OF LH ENGINE FWD YOKE LINK. REMOVED AND REPLACED LT ENGINE FWD YOKE LINK IN REFERENCE TO AMM 71-21-01. REF CP CP 22184438-1 FOR TASK CARD.SDR AALA202604098622Seat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN SEAT TRACK AT STA 1455 AND RBL 74. REPLACED SEAT TRACK PER AARD 51-00-05-1.SDR SWIA2026012375604Fitting · wornPASSENGER DOOR, EXTERNAL SURROUND, AFT CAM FITTING WORN, REMOVED AND REPLACED PAX DOOR, EXTERNAL SURROUND FS.349, AFT UPPER CAM FITTING SH670-31913-3 WITH NEW REF. SRM 51-42-21-001-001-A01 AND DWG# SH670-31810 REV. AE.SDR SWIA2026012375602Skin · wornPASSENGER DOOR, EXTERNAL SURROUND, FORWARD CAM FITTING WORN, REMOVED AND REPLACE PAX FWD DOOR SURROUND CAM FITTING (FS310) WITH NEW REF. SRM 51-42-21-001-001-A01 AND DWG #SH670-31810 REV. AE.SDR VNAA20260329008Bonding Plate · missingMISSING SHIM (1EA) ON PYLON FS 1126.00 (UPPER SKIN) AT LH ENGINE. NEW SHIM (1EA) ON PYLON FS 1126.00 (UPPER SKIN) AT LH ENGINE WAS INSTALLED PER CRJ900 SRM 51-42-10-001-001-A01SDR VNAA20260329007Hinge Fitting · corrodedCORROSION ON HINGE FITTING (2 EAS) & HINGE ARM (2 EAS) OF ACCESS DOOR 196ER (DOOR INSTALLED ON FAIRING 196DR). CORROSION ON HINGE FITTING (2 EAS) & HINGE ARM (2 EAS) OF ACCESS DOOR 196ER (DOOR INSTALLED ON FAIRING 196DR) WAS REMOVED PER CRJ-900 SRM 51-21-06-