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 AALA202511173919Light · unsecureAIRCRAFT WAS NOT GROUNDED: 16D EMERGENCY LIGHT DANGLING LOOSE. SECURED EMERGENCY ILLUMINATION LIGHT. PER AMM 33-51-03. OPERATIONAL CHECKS GOOD.SDR AALA202511175088Locking Cam · faultedAIRCRAFT WAS NOT GROUNDED: GIRT BAR ON R1 COMES UNDONE WHEN YOU ARM ONE SIDE. RECOILED BOTTOM SECTION AND RETACKED. PERFRMED SEVERAL ARM AND DISARM OPERATIONAL CHECK GOOD. PER AMM 25-66-00.SDR SWAA2025111735710Flashlight · no testALL FOUR AFT F/A FLASHLIGHTS WILLNOT TEST. FOUND ALL SEALS BROKEN AND FLASHLIGHTS NOT PROPERLY SECURED IN CRADLES. RESECURED AFT F/A FLASHLIGHTS INTO THEIR CRADLES. OPS CHECKS GOOD. RESAFETIED FLASHLIGHTS IAW AMM 33-55-00.SDR AALA202511177653Transceiver · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: PWS FAIL WEATHER RADAR RIGHT AMBER CAUTION ILLUMINATED ON BOTH PFDS. AIRCRAFT DIVERTED TO AND LANDED SAFELY AT DFW. RESET WEATHER RADAR TRANSCEIVER ACCOMPLISHED. PER FIM 34-41-00-810-818.SDR AALA202511172205Anti-Skid Sys · faultedAIRCRAFT WAS GROUNDED: DURING TAXI IN AIRCRAFT BEHIND US ADVISED THE TOWER WE HAD SMOKE COMING FROM LEFT MAIN NR 1 TIRE. STOPPED THE AIRCRAFT AND CALLED FOR ARFF, WAS ADVISED TIRE WAS FLAT. WHILE PARKED AFTER 15 MINS, ANTI-SKID INOPERATIVE LIGHT CAME ON. (OPESDR AALA202511173892Light · unsecureAIRCRAFT WAS NOT GROUNDED: EXIT AISLE LIGHTING MECHANISM IS DANGLING AT SEAT 31C. SECURED EMERGENCY EXIT AISLE LIGHT AT SEAT 31C. PER AMM 33-51-00.SDR GTIA2025111739184Knob · missingFWD MEGAPHONE VOLUME KNOB MISSING. R & R FWD MEGAPHONE IAW NKS DRAWING EMER EQUIPSDR VNAA2025111711104Windshield · crackedFO WINDSHIELD ARCED AND CRACKED IN FLIGHT /REMOVED AND INSTALLED COPILOT SIDE WINDSHIELD IAW AMM TASK 56-11-01-400-801-A01-PSA. PERFORMED LEAK TEST OF THE WINDSHIELD IAW AMM 21-31-00-910-801-A02 AND NO LEAKS OBSERVED. REMOVED & REPLACED WINDSHIELD CONTROLLER ASDR VNAA2025111711103Computer · unserviceableDURING CLIMB OUT, LEFT PFD ATTITUDE INDICATOR REMOVED, RED FD, ATT ,AND HDG FLAGS DISPLAYED ON PFD, ACCOMPANIED WITH AUTOPILOT DISCONNECT AND YD 1 INOPERATIVE AND PITCH FEEL FAULT STATUS MESSAGES. INTERROGATED MDC FOUND B1 CODE 005923 AND MULTIPLE OTHER ONES WSDR AALA202511172036Bottle · low pressureAIRCRAFT WAS GROUNDED: CIDS FAULT SHOWS LEFT MID CABIN EMERGENCY DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. MAINTENANCE SERVICEDDAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR YEN2025F00009Sensor · faultedFLT#2220, LHR-JFK. (ETOPS) "EXTERNAL POWER WAS INTERRUPTED 3 TIMES, CAUSING ENGINE SENSOR FAULT TO OCCUR; ENG 1&2 GROUND SCAN DUE MULTIPLE FAILURE MESSAGES, TSM 77-31-00-810-801-A REV 108 FOLLOW UP TO AND INCLUDING STEP 3 ENG GROUND RN CARRIED OUT IAW AMM 71-SDR YENA2025111701105Unknown · odorFLT#1797, ATL-FLL. "OIL FUMES IN COCKPIT ON TAKEOFF, DISSIPATED AFTER A COUPLE OF MINUTES; COMPLIED WITH INFORMATION NOTICE 2017-T015 SECTION A, ISOLATED FAULT TO TYPE 10: MISCELLANEOUS CABIN ODOR, SMOKE OR FUME. INSPECTED APU AND BOTH ENGINES. RAN ALL. NOSDR DALA2025111708393Girt Bar · fodL4 DOOR SHOWS OPEN ON FAP WHEN LATCH IS CLOSED. SLIDE ARMED LIGHT BLINKS WHEN DOOR IS ARMED. REMOVED FOD FROM 4L DOOR GIRT BAR MECHANISM. OPS CHK GOOD PER A330 AMM 52-13. (7921274)SDR HNAA2025111700742Charger · inoperativeRIGHT FWD EXIT EMERGENCY LIGHT INOPERATIVE. R & R NR 2 EMERGENCY BATTERY AND CHARGER ASSY IAW AMM 33-50-04. OPS CHECKED GOOD.SDR HNAA2025111700741Warning Message · false activationRUDDER SYS 1 INOP MESSAGE ON T/O ROLL AND REJECTED T/O. PERFORMED RUDDER SYSTEM OPERATIONAL TEST IAW AMM 27-23-00. OPS CHECK GOOD. A/C OK FOR SERVICESDR HNAA2025111700740Pressure Switch · faultedRUDDER SYSTEM 2 INOP DISPLAYED DURING TAKE-OFF AT ABOUT 50 KNOTS. R&R RUDDER PRESSURE SWITCH IN REF WITH 27-23-04-000-A/400-801-A. R&R RELAY K0387 IN REF WITH AMM TASK 20-13-02-000/400-801-A. R&R RUDDER SHUTOFF SYS 2 PB SWITCH IN REF WITH AMM 20-13-04-000/4SDR DALA2025111708380Bmc · faultedATB - DUE TO AN AIR ENG 1 BLEED FAULT WITH RT PACK ALREADY DEFERRED PER MEL. REPLACED BMC 1 AND LT ENGINE PRV. (LP 8138300)SDR DALA2025111708379Seal · leakingTHE TWO FWD FA'S REPORTED DIRTY SOCK SMELL TAXIING TO GATE. FOUND OIL PUDDLE FROM BACK OF ENGINE 2 SPINNER. REPLACED NR 2 ENG FAN HUB SEAL AND LEAK CHK NML PER A321 AMM 72-11. (LP 7658248)SDR AALA202511172511Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION TO FORWARD CARGO COMPARTMENT DOOR CUTOUT LOWER SILL INNER CHORD BETWEEN STA 466 AND STA 655. REPLACED INNER CHORD PER SRM 51-40-02-0GSDR ABXA20251116302Warning Message · false activationON PUSHBACK, ENG EEC PROBE LIGHT REMAINED ILLUMINATED. AIRCRAFT RETURNED TO BLOCKS. (BTB). ACCOMPLISHED SYS OPS CK IAW AMM 30-34-00, ALL CKS NORMAL. VERIFIED WITH ENG IDLE RUN ON BOTH ENGINES. AIRCRAFT RETURNED TO SERVICE.SDR DXTA2025111705719Oil System · leakingWHEN STARTING APU, THERE IS A MILDLY NOXIOUS ODOR THAT FILLS THE COCKPIT AND CABIN. IT SMELLS LIKE BURNING OIL. ODOR REMAINS FOR THE ENTIRE FLIGHT, EVEN WITH APU OFF. SUSPECT COMING FROM THE APU AND RESIDUAL FUMES ARE LINGERING FOR REMAINDER OF FLIGHT, BUT NOTSDR SIMA20251116001Glowstrip · deterioratedPASSENGER ENTRYWAY EMERGENCY PHOTOLUMINESCENT STRIP DETERIORATED. RAR PASSENGER ENTRYWAY EMERGENCY PHOTOLUMINESCENT STRIP LIGHT IAW ERJ-175 AMM 33-50-21/400. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED.SDR SIMA20251116002Lever · malfunctionedGEAR LEVER WILL NOT MOVE UP AFTER TAKEOFF. EMERGENCY DECLARED CONTINUE TO ORD. PREFORMED FIM 32-33-00-810-802 BLOCK DIADRAM 1 BLOCK 1(ANSWER NO) BLOCK 15 (ANSWER YES) BLOCK 10 (ANSWER YES). TRANSITORY CONDITIONS. PERFORMED OPERATIONAL TEST OF LANDING GEAR EXTESDR SIMA20251116003Rod · weakPAX DOOR VERY DIFFICULT TO OPEN AND CLOSE. MAIN HANDLE SEEMS LOOSE. FOUND COUNTER BALANCE RODS TO BE WEAK ON FWD PASSENGER DOOR. REMOVED AND REPLACED BOTH COUNTER BALANCE RODS ON FWD PASSENGER DOOR IAW AMM 52-11-20. OPS CHECK GOODSDR JJBA20251117102Lamp · inoperativeRIGHT EMERGENCY LIGHT OF FORWARD LOWER FAIRING INOPERATIVE. REMOVED AND REPLACED RT EMERGENCY LIGHT LAMP. OPS CHECK SAT.SDR CALA2025111711261Slide · unwanted deployWHEN CATERING TRY TO GET ACCESS, 1R DOOR EMERGENCY SLIDE DEPLOYED INSIDE THE GALLEY. NOTE THAT SLIDE IS IN DISARM POSITION ATTACHED ATTACHED UPDATE TO FOLLOW UP WITH SDR INFORMATION. WHEN CATERING TRIED TO CLOSE R1 DOOR FROM THE OUTSIDE THE DOOR MOVED DOWN A BSDR CALA2025111711228Check Valve · faultedLEAK CHECK OF NITROGEN GENERATION SYSTEM, RESIDUAL FUEL & FUEL ODOR AT BOTH DRAIN PORTS, REQUIRES PRIMARY AND SECONDARY BACKFLOW PREVENTION CHECK VALVES TO BE CHANGED IAW AMM 47-21-04. R & R SECONDARY BACK FLOW PREVENTER PER AMM TASK 47-21-04. PERFORMED OSDR SWIA2025111576508Former · chafedPAX DOOR FWD FORMER IS CHAFED. REMOVED AND INSTALLED NEW PAX DOOR FWD FORMER IAW SRM 51-42-06-001-001-A01, SRM 51-42-21-001-001-A01, AND DWG 601R31702, REV N. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY. LEAK CHECKED GOOD.SDR REXA2026052800803Floor Support · crackedCRACK ON FLOOR SUPPORT ANGLE (1EA) BTW FS 280.00 TO FS 265.00, AND LBL 9. FLOOR SUPPORT ANGLE (1EA) BTW FS 280.00 TO FS 265.00, AND LBL 9 WAS REPLACED PER EA NO.CRJ953-20368 REV. IR & CRJ-900 SRM 51-42-21-001-001-A01SDR REXA2026052800802Floorbeam · crackedCRACKED CENTER COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE *BELOW* FLIGHT COMPARTMENT. COCKPIT FLOOR BEAM RBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE *BELOW* FLIGHT COMPARTMENT WAS REPAIRED PER CRJ900 SRM 53-11-43-201-003-A01SDR REXA2026052800801Floorbeam · crackedCRACKED CENTER COCKPIT FLOOR BEAM LBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE *BELOW* FLIGHT COMPARTMENT. COCKPIT FLOOR BEAM LBL12 AT FS 280.00 FLOOR INTERNAL SUPPORT STRUCTURE *BELOW* FLIGHT COMPARTMENT WAS REPAIRED PER CRJ900 SRM 53-11-43-201-003-A01SDR SWIA2026030275397Beam · corrodedSIGNS OF CORROSION BETWEEN THE 280 BULKHEAD AFT SKIN AND THE BULKHEAD BEAM AT LBL9.00 STR17LH PERFORMED REPAIR BETWEEN THE 280 BULKHEAD AFT SKIN AND THE BULKHEAD BEAM AT LBL 9.00, STRG 17LH, FOUND TO BE WITHIN LIMITS IAW BOMBARDIER REO 670-53-11-594, REV -A,SDR SWIA2025111575266Door Frame · damagedFORWARD BAGGAGE BAY DOOR SURROUND STRUCTURE, FWD AND AFT LOWER HINGES ARE MARRED, BLENDED OUT DAMAGE ON FORWARD BAGGAGE BAY DOOR SURROUND STRUCTURE, FWD & AFT LOWER HINGES IAW SRM 51-12-00-001-001-A01 AND PERFORMED REPAIRS IAW REO 670-53-31-1141 REV-. COMPLISDR SWIA2025111575265Door Frame · chafedRIGHT OVERWING EMERGENCY EXIT SURROUND STRUCTURE, FWD AND AFT UPPER AREA IS CHAFED. BLENDED THE CHAFING ON FWD & AFT UPPER AREA OF RIGHT OVERWING EMERGENCY EXIT SURROUND STRUCTURE. IAW SRM 51-12-00-001-001-A01, AND PERFORMED REPAIRS PER REO 670-53-41-785 REV SDR SWIA2026021375258Stringer · corrodedCORROSION AT APPROX. BS 365 OTBD SIDE OF S26R. REMOVED AND INSTALLED A NEW STRINGER 26R SECTION BETWEEN BS 333 - 364 IAW SRM 51-42-06-001-001-A01, AND DWG SH670-31350, REV A. COMPLIED WITH TASK CARD 51-900-1002-SKY. ALL CHECKED GOOD.SDR SWIA2025111575257Door Frame · chafedLEFT OVERWING EMERGENCY EXIT SURROUND STRUCTURE, AFT UPPER CORNER IS CHAFED. REPAIRED CHAFE ON LT OVERWING EMERGENCY EXIT SURROUND STRUCTURE, AFT UPPER CORNER IAW REO 670-53-41-788, REV -. COMPLIED WITH SKYWEST TASK CARD 51-900-1002-SKY.SDR VNAA202601180012Strap · crackedCORROSION AT SUPPORT STRUCTURE STRAP BTW FAIRING ACCESS PANEL 193AL & 193AR TO FAIRING ACCESSPANEL 193AB. SUPPORT STRUCTURE STRAP FAIRING ACCESS PANEL 193AL AND 193AR WERE REPLACED PER CRJ 900 SRM 51-42-10-001-001-A01 AND CRJ900 SRM 51-42-06-001-001-A01SDR VNAA202601180010Bracket · corrodedCORROSION ON INTERNAL ANGLES OF REFUEL/DEFUEL CONTROL PANEL SUPPORT STRUCTURE. CORROSION ON INTERNAL ANGLE P/N: CC670-39182-8 WAS REMOVED PER CRJ-900 SRM 51-21-06-001-001-A01 AND EVALUATED WITHIN LIMITS PER CRJ-900 SRM 53-00-01-101- 001-A01 AND ANGLE 1EA (BRSDR KY72026F00003Relay · faultedAUTO FEATHER AURAL WARNING ALERT ON TAKEOFF WITH AUTO FEATHER ON. REMOVED & REPLACED RELAY K0161 IAW EMB120 WM 20-20-00 OPS CHECK GOOD IAW EMB120 MM 61-23-20 WPB RTC CHECK GOOD.SDR ASAA2025111563434Beam · crackedR1 DOOR LOWER HOUSING SUPPORT BEAM HAS A CRACK BY FWD MOUNT BLOCK. GROUNDED - YES. REMOVED AND REPLACED SUPPORT BEAM IAW B737-700 SRM 51-40-02-0G-0.SDR AALA202512228081Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23R. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR SWAA2025121935673Web · crackedCRACKED WEB LOCATED AT THE CEILING AREA BTW BS 847 - 867, LBL 20 IN THE AFT CARGO BAY. REPLACED THE WEB IAW SRM 51-40-02-0G, AND DWG 149A8100, SHEET 1, REV-.SDR SWAA2025121735652Seat Track · corrodedCORROSION ON SEAT TRACK LBL 25 AT BS 500+6, BS 500A+18, BS 500B+16. THE SEAT TRACK WILL BE REPLACED IN CUSTOMER CARD # TTG8Q018W4P4.SDR SWAA2025121735658Seat Track · corrodedCORROSION ON SEAT TRACK LBL 45 AT BS 500+6, BS 500A+18, BS 500B+16. THE SEAT TRACK WILL BE REPLACED ON CUSTOMER CARD TTG8Q018W4PU.SDR AALA202512157981Shear Plate · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED AFT CABIN FLOOR SHEAR PLATE BETWEEN FR 69 AND FR 70 AT S23L. REPLACED SHEAR PLATE PER SRM 51-72-11.SDR AALA202512127151Sign · no testAIRCRAFT IN BASE MAINTENANCE: R2 DOOR OVERHEAD EMERGENCY EXIT SIGN IS INOP DURING LIGHT TEST. MAINTENANCE FOUNDE LOOSE CONNECTOR AND SECURED IT IAW B787 FI 33-50-F1-W4A-421A-A.SDR SWAA2025121035632Stiffener · crackedCRACK ON STIFFENER LOCATED ON STAB STA 129.50 AT FRONT SPAR RT HORIZONTAL STABILIZER. REPLACED STIFFENER ON STAB STA 129.50 AT FRONT SPAR RT HORIZONTAL STABILIZER IAW SRM 51-40-02-0G-0, SRM 51-10-02-0G-0, ITEM 9, AND DWG 182A5305, SHEET 1, REV C.SDR SWI2025F01716Flap Track · wornRIGHT WING FLAP TRACK 2A OTBD HAS WIDTH REDUCTION WEAR OF 1.16MM MAX ALONG ENTIRE LENGTH. REMOVED AND REPLACED RT WING FLAP TRACK 2A OTBD IAW AMM 57-54-25.SDR SWI2025F01715Flap Track · wornLEFT WING FLAP TRACK 1A HAS THICKNESS REDUCTION WEAR OF .98MM MAX ALONG FWD SIDE. REMOVED AND REPLACED THE LT WING FLAP TRACK 1A IAW AMM 57-54-25.SDR SWI2025F01714Seat Track · corrodedAFT WET AREA CORROSION AT AFT END OF LT INBD SEAT TRACK FRS 84 - 85. REPAIRED THE LT INBD SEAT TRACK BETWEEN FR 83-85 IAW SRM 53-00-10, REPAIR 01, AND ETD2022-170-022163, REV C.