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 SWAA2025092216795Unknown · unknownON TAKEOFF JUST PRIOR TO ROTATION AIRCRAFT HAD SUDDEN MOVEMENT TO THE RIGHT. PERFORMED EXTERNAL GVI LOWER FUSELAGE IAW AMM 05-41-01. PERFORMED GVI OF NOSE AND MLG IAW AMM 05-41-07. NO DEFECTS NOTED.SDR SWIA202509220001Warning Message · illuminatedRIGHT 14TH DUCT WARNING MESSAGE WHEN CLIMBING THROUGH ABOUT 8000FT. RAN QRH. MESSAGE CLEARED. RETURNED TO ORD. (FLIGHT 5610) OPEN.SDR AALA202509222313Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FWD OUTBOARD FLIGHT ATTENDANT SEAT BY L1 DOOR / FLASHLIGHT FAILED TO FLASH. MAINTENANCE REPLACED L1 DOOR OUTBOARD FA SEAT FLASHLIGHT ASSEMBLY IAW CMM 25-60-02.SDR AALA202509229161Bottle · low pressureAIRCRAFT WAS GROUNDED: L1 DOOR ACCUMULATOR REQUIRES SERVICING. MAINTENANCE SERVICED L1 DOOR IAW AMM 52-10-00.SDR AALA202509223318Wire · brokenAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY AISLE LIGHT AT SEAT 9C INOP. MAINTENANCE FOUND BROKEN WIRES FROM CONNECTOR 7260VC3 THAT PROVIDES POWER TO EMERGENCY AISLE LIGHTS ON SEAT ROWS 9ABC AND TO 10ABC. REPAIRED WIRES IAW ESPM 20-48-21.SDR AALA202509226692Elec Connector · looseAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY AISLE LIGHT AT SEAT 17C INOP. MAINTENANCE SECURED ELECTRICAL CONNECTOR FOR SEAT MOUNTED EMERGENCY AISLE LIGHT AT SEAT 17C OPERATIONAL CHECK GOOD IAW AMM 33-51-00.SDR GTIA2025092239085Pump · faultedHYD Y ENG 2 PUMP LO PR ECAM IN FLIGHT ( ECAM WARNINGS & CAUTIONS PUMP LO PR - ENG PUMP LO PR )-FOLLOWING TSM 29-13-00-810-804-A, PERFORMED OPERATIONAL TEST OF YELLOW HYD SYSTEM IAW AMM 29-13-00-710-002-A. YELLOW SYS GOOD DURING ENG RUN. NO FAULTS. THIS CLEARS SDR DALA2025092206930Indication Sys · faultedR2 MAIN ENTRY/SERVICE DOOR ARMED INDICATORS. R/R R2 ALARM SIGNAL MODULE IAW B767 AMM 52-73. OPS CHK TEST OK. (1208799)SDR AALA202509223703Plate · looseAIRCRAFT WAS NOT GROUNDED: 3L DOOR HANDLE APPEARS LOOSE. MAINTENANCE RE-SECURED 3L EMERGENCY EXIT DOOR ARM/DISARM UNIT GRIP PLATE HANDLE PER AMM 52-22-22.SDR AALA202509228703Wire · brokenAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS ROWS 32 AND 33 ABC ARE INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE, REPAIRED WIRE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00.SDR MASA2025092000076Life Vest · missingONE INFANT LIFEVEST MISSING/REPLACED/INSTALLED NEW LIFEVESTSDR IPXA2025092255412Unknown · odorON DEPARTURE AT HIGH POWER SETTING STRONG SMELL OF DIRTY SOCK .SMELL DISSUPTED APPROX 10000FT. ++PERFORMED OPS CHECKS IAW FIM 21-00 TASK SUPPORT - AIR CONDITIONING SYSTEM OIL SMOKE/FUME CONTAMINATION. NO DEFECTS NOTEDSDR IPXA2025092256108Door · inoperativeL-1 ENTRY DOOR BINDING WHEN CLOSING. LOUD CREAKING/ POPPING NOISE COMING FROM CENTER OF DOOR. REPLACED L1 DOOR AFT INTERNAL CONTROL ROD REF CMM 52-11-12SDR FDEA202509201749Skin · wornLEFT WING SLAT AT APPROXIMATELY STA 441, INNER SKIN HAS WEAR/CHAFE MARKS FROM FASTENER. REPAIRED LH WING L/E #5 SLAT TRAILING EDGE WEDGE AT APPROS 43" FROM IB EDGE IN REF TO 767 SRM 57-43-02-2R FIG 201 SHT 2 AND 767 SRM 51-70-10-2R. THIS IS A MAJOR REPAIR. SSDR DALA2025092206928Strut · excess playLEFT FLAP INTERCONNECT STRUT NOTED WITH EXCESSIVE RADIAL AND AXIAL PLAY. REMOVED AND REPLACED INTERCONNECTING STRUT REF A319 AMM 27-51-44. (1208556).SDR DALA2025092206927Strut · excess playRIGHT FLAP INTERCONNECT STRUT NOTED WITH EXCESSIVE RADIAL AND AXIAL PLAY. REMOVED AND REPLACED INTERCONNECTING STRUT REF A319 AMM 27-51-44. (1208555).SDR DALA2025092206913Girt Bar · fodF/A REPORTS TROUBLE ARMING 4L DOOR. CLEANED FOD FROM LINKAGES AND GIRT BAR. OK FOR SERVICE. (7857368)SDR DALA2025092206911Switch · leakingHYD - DECLARED EMERGENCY DUE TO GREEN HYDRAULIC SYSTEM QUANTITY LOSS (HYD G RSVR LO LVL ECAM WARNING). FOUND SOLENOID SWITCH ON THE GREEN EDP LEAKING. REPLACED GREEN HYDRAULIC EDP. OPS CHECK GOOD. (LP 7820938)SDR DALA2025092206900Lens · missingON WALKAROUND DURING SVC CK. FOUND LAV DS (AFT LEFT) AUX EMERGENCY FLOOR LIGHT LENS MISSING. INSTALLED LENS INTO AFT LH LAV PER A321 AMM 33-50, CHECKS GOOD. (LP 7859416)SDR DALA2025092206906Lanyard · unsecureR1 DOOR WILL NOT ARM. STOWED LANYARD-DOOR ARMS NML. (7549844)SDR DALA2025092206905Drive System · lack of lubeDE- DUE TO TRAILING EDGE FLAP DISAGREE MESSAGE. T/S PER FIM. C/W EVENT FOLLOW UP LOG. LUBED FLAP DRIVE SYSTEM.SDR SWAA2025092216600Rivet · brokenDOOR R1 SLIDE COVER GIRT BAR HOOK HAS A BROKEN RIVET<[01] COMPLIED WITH EA M-23-125-01839SDR DALA2025092206898Bottle · low pressureL2 DOOR EMERGENCY OPERATING CYLINDER/ACCUMULATOR PRESSURE LOW. SERVICED L2 DOOR EMERGENCY CYLINDER/ACCUMULATOR PRESSURE PER A320 AMM TASK 52-10-00-610-881C1. LEAK CHECK GOOD. A/C OK FOR SVC. (LP: 7342882)SDR SIMA20250920001Sign · inoperativeAFT SERVICE DOOR R2 EXIT IDENTIFIER SIGN INOP/HALF LIT. R & R AFT SERVICE DOOR R2 EXIT IDENTIFIER SIGN IAW AMM 33-50-15. OPS CHK GOOD.SDR SCNA20250922386Heat Exchanger · dirtyL/H PACK FUME SMELL ( AIR CONDITIONING PACKS (PRESSURIZED) ) R&R OF RECIRCULATION FILTERS ACCOMPLISHED ON W/O 98445 N/R-00001 PERFORMED L/H PACK HEAT EXCHANGER CLEAN IAW AMM 21-51-00 PERFORMED FIM 21-00 TASK 802 NO SIGN OF CABIN FUMES THIS CLEARS MELSDR CALA2025092209111Skin · dentedLH WING LE NR 2 SLAT REQUIRE PERMANET REPAIR PER LP 7868289. PERFORMED PERMANENT REPAIR ON LH WING NR 2 SLAT LEADING EDGE SKIN, PERFORMED IAW SRM 57-42-01-2R-1, AMM 30-11- 31-000-802, 30-11-31-400-802, NDTM PART 6, 51-00-00 PROCEDURE 23 , GMM 07-35-05.SDR CALA2025092209081Battery Pack · no testPROCEDURE - EPSU FWD BATTERY FAULT FOUND ON EMERGENCY LIGHTING CHECK. R & R FWD EPSU BATTERY ABOVE FWD ENTRY DOOR. REF: AMM TASK 33-51-38-000-002-A & TASK 33-51-38-400-002-A. OP CHECK GOOD, NO MORE FAULTS SHOWING ON TEST.SDR CALA2025092209080Light · malfunctionedDURING DESCENT BELOW 10K, EMERGENCY EXIT LIGHTS AT ROW 3 AND ROW AHEAD O F WING EXITS ILLUM 5 TIMES. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS REF AMM 33-51-00. UNABLE TO DUPLICATE FAULT. OPS CHECKS GOOD.SDR AALA202509216501Shade · inoperativeAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVER WING EXIT DOOR SHADE DOES NOT COME DOWN CORRECTLY. REPLACED EXIT WINDOW SHADE ASSEMBLY IAW AMM 25-21-12SDR DALA2025092106897Battery Pack · inoperativeFOUND ENTRANCE DOOR EXIT SIGN LIGHT INOP. REPLACED BATTERY PACK REF. B757 AMM 33-51. (LP 7275678)SDR AALA202509214597Battery · inoperativeAIRCRAFT WAS GROUNDED: FORWARD FLIGHT ATTENDANT'S FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00.SDR AALA202509215824Cover · looseAIRCRAFT WAS NOT GROUNDED: RIGHT HAND SIDE EMERGENCY EXIT ROW HANDLE LOOSE. RESECURED THE LOOSE COVER PER AMM 25-21-12.SDR AALA202509210271Lamp · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS NOT ARMED LIGHT BULB BURNT OUT. MAINTENANCE RELAMPED AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-18-00.SDR AALA202509213304Lamp · burned outAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHTS NOT ARMED LIGHT BULB BURNT OUT. MAINTENANCE RELAMPED AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-18-00.SDR DALA2025092006894Oil System · leakingDIRTY SOCK SMELL NUMEROUSE TIMES LASTING AROUND 1-2 MINS. EACH TIME. REF QRH+ USED OXY MASKS UNABLE TO ISOLATE DUE TO QUICK DURATION OF SMELL. FOUND NOSE CONE SPINNER SEAL LEAKING. REPLACED NOSE CONE SPINNER SEAL IAW PW 1100G ENG MANUAL 72-11. PERFORMED DECOSDR ABXA20250920234Module · faultedON TAXI OUT, WARN ELEX MSG APPEARED AND WAS UNABLE TO RESET. ACFT RETURNED TO THE GATE (BTB) AND MAINTENANCE GROUNDED ACFT , MTX PERFORMED BITE PROCEDURES 31-51 TREE 801 MSG CLEARED A/C OK FOR SERVICE. ACFT RETURUNED A SECOND TIME AND MESSAGE WAS CLEARED, FOSDR KCSA202509201168Bulb · inoperativeLADDER EMERGENCY LIGHT INOPSDR KCSA202509201167Battery Pack · inoperativeUPPER DECK STA 410 EXIT SIGN FOUND INOP.SDR SWIA2025091976604Roller · out of limitsTRACK ROLLER SLAT 2-2 900 RT, COMPLY WITH TASK CARD 27-630-809 RT TRACK ROLLER SEALED, TRACK 2-2, TOP FORWARD - SLAT 2. COMPLIED WITH TASK CARD 27-630-809 RH TRACK ROLLER SEALED, REMOVED TOP FWD TRACK ROLLER ON RT TRACK 2-2 IAW AMM 27-81-43-000-801-A01 AND INSDR SWIA2025091976602Roller · out of limitsTRACK ROLLER SLAT 1-3 900 RT. COMPLY WITH TASK CARD 27-630-809 RT TRACK ROLLER SEALED, TRACK 1-3, TOP FORWARD, SLAT 1, COMPLIED WITH TASK CARD 27-630-809 RT TRACK ROLLER SEALED, REMOVED TOP FWD TRACK ROLLER ON RT TRACK 1-3 IAW AMM 27-81-43-000-801-A01 AND ISDR REXA2026052800863Stringer · corrodedIN REFERENCE TO NRC 00604: CORROSION ON STRINGER 19RH, 20RH AND 21RH IN STA. FS= 437 TO FS= 453 AT MAIN AVIONICS COMPARTMENT. (E/E) SUMMARY OF NRC 677 CORROSION ON STRINGER 20RH AND 21RH IN STA. FS= 437 TO FS= 453 AT MAIN AVIONICS COMPARTMENT WERE EVALUATED OSDR REXA2026052800861Hinge · corrodedCORROSION ON BOTH HINGES OF AFT LAVATORY WASTE SERVICE ACCESS PANEL 196ER (2 EAS) SUMMARY: BOTH HINGES OF AFT LAVATORY WASTE SERVICE ACCESS PANEL 196ER (2 EAS) WERE REMOVED PER CRJ900 AMM 52-45-01 AND INSTALLED PER CRJ900 AMM 52-45-01 AND FABRICATED HINGE OF SDR REXA2026052800860Frame · corrodedCORROSION ON FRAME FS 847.00+32 BTWN STGR 25LH TO 25RH CORROSION ON FRAME FS 847.00+32 BTWN STGR 25LH TO 25RH WAS REPAIRED PER REO 690-53-51-526 REV --SDR REXA2026052800859Stringer · corrodedIN REFERENCE TO NRC 00604: CORROSION ON STRINGER 19RH, 20RH AND 21RH IN STA. FS= 437 TO FS= 453 AT MAIN AVIONICS COMPARTMENT. (E/E) SUMMARY OF NRC 677 CORROSION ON STRINGER 20RH AND 21RH IN STA. FS= 437 TO FS= 453 AT MAIN AVIONICS COMPARTMENT WERE EVALUATED OSDR REXA2026052800858Stringer · corrodedIN REFERENCE TO NRC 00604: CORROSION ON STRINGER 19RH, 20RH AND 21RH IN STA. FS= 437 TO FS= 453 AT MAIN AVIONICS COMPARTMENT. (E/E) SUMMARY OF NRC 677 CORROSION ON STRINGER 20RH AND 21RH IN STA. FS= 437 TO FS= 453 AT MAIN AVIONICS COMPARTMENT WERE EVALUATED OSDR REXA2026052800857Hinge · crackedCRACKED FWD / MID & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT FWD / MID & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT REPLACED IAW SRM 51-42-06-001-001-A01 (FWD & AFT HINGES) WERE MANUFACTURED PER EA NO. CRJ953-20605 REV IR SDR REXA2026052800856Hinge · crackedCRACKED FWD / MID & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT FWD / MID & AFT HINGES OF FLAP STEP PLATE AT AFT BAGGAGE BAY DOOR CUTOUT REPLACED PER CRJ 900 SRM 51-42-06-001-001-A01 (FWD & AFT HINGES) WERE MANUFACTURED PER EA NO. CRJ953-20605SDR REXA2026052800853Bracket · corrodedCORROSION ON WEB FLOOR PROTECTOR THEIR ANGLES (8 EAS) AT SERVICE DOOR SURROUND STRUCTURE BTW FS 319.70 TO FS 349.00. CORROSION ON WEB FLOOR PROTECTOR THEIR ANGLES (8 EAS) AT SERVICE DOOR SURROUND STRUCTURE BTW FS 319.70 TO FS 349.00. WAS REMOVED PER CRJ900 SRSDR REXA2026052800852Fitting · corrodedINITIAL INSPECTION: CORROSION ON CLOSING FITTINGS (2EAS) BTW FS 314.00 AND FS 342.00 AND STGR 18L. CORROSION ON CLOSING FITTINGS (2EAS) BTW FS 314.00 AND FS 342.00 AND STGR 18L WERE REMOVED PER CRJ900 SRM 51-21-06-001-001-A01, CLOSING FITTINGS FWD WAS EVALUATSDR REXA2026052800851Frame · corrodedINITIAL INSPECTION: CORROSION ON FRAME FS= 310.00 BETWEEN STRG 24LH TO 24RH AT MAIN AVIONIC COMPARTMENT DUE TO EXCESIVE CORROSION ON FRAME IN STA. FS= 310 BETWEEN STRG 25RH TO STRG 24LH AT MAIN AVIONIC COMPARTMENT WAS REPAIRED PER CRJ-900 SRM 53-21-06-101-0