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 DALA2025091906882Light · inoperativeESCAPE PATH OVERHEAD AISLE EMERGENCY LITE INOP. REMOVED AND SWAPPED GROUND AND POWER ELCTRICAL CONNECTORS FROM ONE SIDE TO THE OTHER. PER A321 AMM 33-51 LIGHT IS OPERATIONAL. (LP 7826479)SDR CALA2025091909045Antenna · failedON CLIMBOUT WX RADAR FAIL BOTH SIDES AND WX SYS STATUS MSG OBSERVED. REPLACED LT WX RADAR TRANSCEIVER IAW AMM 34-43-01. OPS CHECK FAILED. PERFORMED WX RADAR OPS AND SYS TEST. TEST FAILED WITH FAULT WXR RT ANT . REQUIRES REPLACEMENT OF WX RADAR ANTENNA. IAW SDR CALA2025091909041Bleed Valve · inoperativeLEFT ENGINE BLEED PRESSURE INDICATES 7PSI IN CLIMB & CRUISE, OPENED NR 1 ENGINE & TR FOUND NO OBVIOUS VISIAL DESCREPENCIES. OPENED & CLOSED NR 1 ENGINE. PERFORMED HIGH POWER RUN REF FIM 36-10 TASK 804. ZERO DUCT PRESSURE ON ENG NR 1 AT ALL POWER LEVELS. PSDR DALA2025091906872Gate · out of adjustDOOR 1L DIFFICULT/ IMPOSSIBLE TO OPEN FROM OUTSIDE. ADJUSTED LOWER FWD LATCH RECEIVER AFTER PERFORMING SKIN AND FLUSHNESS MEASUREMENTS. ADJUSTED LOWER GATE TO PROPER DIMENSION OF FLUSH PER METHOD 1. ALL WORK DONE PER 52-11-00-820-804. ADJUSTED HORIZONTAL CTL RSDR DALA2025091906871Charger · inoperativeROW 28DEF-32DEF EMERGENCY PATH LIGHTING INOP. R & R CHARGER ASSY M2627 PER B737 AMM 33-51.OPC GOOD.SDR DALA2025091906877Transmitter · leakingLOST SYSTEM A HYDRAULICS DURING CRUISE AND DECLARED AN EMERGENCY. FOUND LEAK AT A SYS HYDRAULIC PRESSURE TRANSMITTER ON PRESSURE MODULE. REPLACED PACKINGS. LEAK AND OPS CHECK GOOD.SDR DALA2025091906875Battery Pack · inoperativeCEILING EMERGENCY LIGHTS AT ROWS 3, 11, AND 15 ABC INOP. REMOVED AND REPLACED M2335 BATTERY PACK REF. B737 AMM 33-51. OPS CHECKS GOOD.SDR DALA2025091906874Battery Pack · inoperativeON SERVICE CHECK R1 DOOR EMERGENCY EXIT SIGN LIGHTS AND FIRST CLASS EMERGENCY AISLE LIGHTS INOP. R & R FWD EMERGENCY BATTERY PACK (M1674) IAW B737 AMM 33-52.OPS CHECK GOOD.SDR DALA2025091906873Battery Pack · inoperativeROW 18-22 EMERGENCY LIGHTNING INOP. R & R EMERGENCY LIGHT BATTERY PACK AS PER B737 AMM 33-51. OPS TEST PASSED ALL LIGHTS COME ON. OK FOR SVC.SDR DXTA2025091904987Shutoff Valve · defectiveAT 41,000 CABIN ALTITUDE BEGAN RISING. CREW DONNED O2 MASKS AND DROPPED PAX MASKS. CABIN HI CAS ILLUMINATED AT 10,000 CABIN ALTITUDE. BEGAN EMER DECENT AND DECLARED EMERGENCY WITH ATC. DIVERTED TO KLAS. CAS MESSAGES ILLUMINATED WERE ECS VALVE 2 FAIL AND CSDR AALA202509195003Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FUSELAGE SKIN AROUND AFT LAVATORY VENT LOCATED AT BS 1947, LBL 84. ACCOMPLISHED DOUBLER REPAIR PER SRM 53-70-01-2R-1.SDR 2025F00224Piston · separatedPISTON CYLINDER BECAME SEPARATED FROM THE HUB. IT APPEARS THAT THE THREADS STRIPPED OUT OF THE HUB ABOUT 1/8 INCH. AT THIS TIME WE ARE SENDING TO H&S PROPELLER IN MICHIGAN FOR AN DETAILED TEAR DOWN INSPECTION REPORT TO DETERMINE THE FAILURE.SDR AALA202509188835Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT'S FLASHLIGHT AT 4L INOP. MAINTENACNE REPLACED FLASHLIGHT BATTERY AT 4L DOOR IAW AMM 25-64-00.SDR N6WA2025091801Cascade · damagedRIGHT ENGINE, NR 2 UPPER OTBD CASCADE DAMAGED. REMOVED AND REPLACED RT ENGINE UPPER OTBD CASCADE IAW AMM 78-34-01SDR IXXA202509187052Lamp · inoperativeEXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-16. OPS CHECKED GOOD.SDR DALA2025091806864Case · bird ingestionRETURNED TO MIA DUE TO RIGHT ENGINE BIRD STRIKE AFTER TAKEOFF. MAINTENANCE FOUND MULTIPLE FAN BLADES AND FAN CASE DAMAGED. FAN CASE DAMAGE EXCEEDS B737AMM LIMIT. ENGINE CHANGE ON LOG PAGE 1199194.SDR AALA202509180481Window · chippedAIRCRAFT WAS GROUNDED: MAINTENANCE FOUND TWO CHIPS IN THE L1 DOOR WINDOW. REPLACED WINDOW PER AMM 56-31-11.SDR YENA2025091800948Skin · ground damageDURING HEAVY MAINTENANCE: AC UNIT 12934 CAME IN CONTACT WITH AIRCRAFT AT RH FUSELAGE LOWER SKIN 1" FWD OF FR15 STR 35-36 RIGHT; (RESOLVED ON W/O: 1407010 TASKCARD: NR-00009) REF HAECO WO 440615 NR 42452 ACCOMPLISHED REPAIR OF FUSELAGE SKIN RH FR 15 STR 35-36 RSDR YENA2025091800947Floorbeam · corrodedDURING HEAVY MAINTENANCE: INSIDE CABIN FWD WET AREA FLOOR BEAM TRACK ASSY Y-1292 FR20 STR 23R HAS CORROSION; REF HAECO WO 440615 NR 42255, ACCOMPLISHED REPAIR OF FWD WET AREA RH FLOOR BEAM Y-1292 FR20 STR 23R PER A321 SRM 53-11-15-300-008. THIS IS A CAT A REPASDR YENA2025091800946Floorbeam · corrodedDURING HEAVY MAINTENANCE: INSIDE CABIN - FORWARD WET AREA, RIGHT SIDE CORROSION ON FLOOR BEAM Y-765. FR20 STR 23R; REMOVED CORROSION AT FLOOR BEAM Y-765 AT FR-20, FOUND TO BE OUT OF LIMITS IAW A321 SRM 53-11-15-283-006 FAB REPAIR IWA A-321 SRM 53-11-15-300-SDR CALA2025091809037Bracket · no discrepancyL1 DOOR GIRT BAR BRACKET IS POSSIBLY LOOSE INSPECTED GIRT BART RETAINER CLIPS AT DOOR L1 REF AMM 25-66-01. NO DEFETS FOUND. GIRT BART FITS SECURELY INSIDE OF THE BRACKETS. DOESN'T FEEL LOOSE.SDR CALA2025091809021Stub Beam · gougedSUPPORT TASK L1 DOOR, HANDLE BOX CUTOUT, UPPER TORQUE TUBE BEARING AREA, STUB BEAM IS GOUGED, REMOVED DAMAGED STUB BEAM AND INSTALLED NEW STUB BEAM REF SRM 51-40-02, NAC DWG 141A6260 AND 141A6143.SDR CALA2025091809020Housing · brokenECONOMY PASSENGER SEAT EMERGENCY PATH LIGHTING INSPECTION. EPL HOUSING MOUNTING TABS BROKEN ROWS 21, 25. R & R EPL HOUSING AT ROW 25 IAW CMM 25-21-56. ROW 21 NEEDS MFG PN 1013436-003KA06 REF CMM 25-21-56. LIGHT OPS NORMAL. REQUEST NEF 2510AG. REPLACED EMERSDR CALA2025091809019Channel · dentedAFT CARGO LT SIDE AT BS 1300 CLOSE TO TRANSITION PANEL SUPPORT BRACKET IN THE FRAME WITH DENT AND CORROSION. PANEL SUPPORT(CHANNEL) WAS REMOVED I.A.W B757-200 SRM 51-40-02, RECEIVED NEW CHANNEL TRAVELER T25/1832217, L OCATED AND DRILLED NEW CHANNEL IAW SRM 51SDR DXTA2025091804990Door · out of alignmentMAIN CABIN DOOR IS OUT OF ALIGNMENT FOUND THE FORWARD DOOR BUMPER MAKING CONTACT WITH THE DOOR WHEN CLOSING REMOVE 3 SHIMS BEHIND 4 DOOR BUMPER TO GET CLEARANCE WHEN DOOR IS CLOSING AGAIN CHECK TO MAKE SURE THE DOOR LATCHED AND UNLATCHED EASILY FOUND IT TO BE SDR AALA202509173252Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: L1 DOOR GIRT BAR WILL NOT SEAT PROPERLY IN THE BRACKETS. ADJUSTED AFT GIRT BAR FITTING. PER AMM 25-66-02. OPERATIONAL CHECK GOOD.SDR AALA202509179801Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR. PER CMM 25-40-58. OPERATIONAL CHECK GOOD.SDR AALA202509173276Fuel Filter · cloggedAIRCRAFT WAS GROUNDED: LEFT FUEL FILTER BYPASS LIGHT ILLUMINATED FOR APPROX 4 MINUTES. REMOVED AND REPLACED FUEL FILTER (AALA202509173276) AND FUEL PRESSURE SWITCH (AALA202509173475). PER AMM 73-11-02 AND AMM 73-34-01. LEAK AND OPERATIONAL CHECKS GOOD.SDR AALA202509173475Pressure Switch · cloggedAIRCRAFT WAS GROUNDED: LEFT FUEL FILTER BYPASS LIGHT ILLUMINATED FOR APPROX 4 MINUTES. REMOVED AND REPLACED FUEL FILTER (AALA202509173276) AND FUEL PRESSURE SWITCH (AALA202509173475). PER AMM 73-11-02 AND AMM 73-34-01. LEAK AND OPERATIONAL CHECKS GOOD.SDR AALA202509175897Light · disconnectedAIRCRAFT WAS NOT GROUNDED: 32C FLOOR EMERGENCY EXIT PATH LIGHTING HAS COME LOOSE AND IS DISCONNECTED. RESECURED 32C EMERGENCY LIGHT.SDR AALA202509174809Sign · missingAIRCRAFT WAS NOT GROUNDED: EXIT SIGN MISSING NEAR AFT ENTRY DOOR. REPLACED LEFT SIDE AFT GALLEY WALL MOUNTED EXIT SIGN. PER AMM 33-51-01-960-802.SDR AALA202509170801Door · out of adjustAIRCRAFT WAS GROUNDED: LAVATORY-D DOOR VERY DIFFICULT TO OPEN. REPEAT DISCREPANCY. ADJUSTED BI-FOLD DOOR. PER CMM 25-40-64. DOOR OPERATIONAL CHECK GOOD.SDR AALA202509171470Skirt · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANTS REPORT THE BOARDING DOOR SLIDE SKIRT MUST BE FOLDED UNDER FOR GIRT BAR TO FIT PROPERLY IN BRACKETS. NON-STANDARD OPERATION. ADJUSTED SKIRT ON BOARDING DOOR AS REQUIRED.SDR AALA202509172714Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR ON AFT LEFT SIDE. THE LOCKING MECHANISM IS DIFFICULT TO OPERATE AND IS LOCKING PEOPLE IN THE LAVATORY. CLEANED AND LUBED LATCH AT LAVATORY-D DOOR. OPERTIONAL CHECK GOOD. PER AMM 25-40-14.SDR AALA202509176478Life Vest · tornAIRCRAFT WAS NOT GROUNDED: LIFE VEST SOFT POUCH TORN AT SEAT 13E. REMOVED AND REPLACED LIFE VEST SOFT POUCH ASSEMBLY AT SEAT 13E. PER CMM 25-23-67.SDR HALA20250917280Control Unit · faultedETOPS - DURING T/C 330-72-HWI-01-INSTALL, INSTALLATION OF POWERPLANT STEP 41 TEST OF FADEC SYSTEM REVEALED VSV CONTROL UNIT CLASS 1 FAULT ON EEC CHANNELS A AND B. REMOVED AND REPLACED #1 ENG VSV CONTROL UNIT PER AMM 73-33-51, CONDITION SAME, STILL FAULTING ON SDR SWAA2025091715230Skin · delaminatedLEFT INBD MAIN FLAP OTBD OF NR 3 CANOE ON TRAILING EDGE OF FLAP; UPPER SIDE IS DELAMINATED. ACCOMPLISHED TAP TEST ON UPPER DISCREPANCY AREA; NO DELAM NOTED. FOUND DEFORMED AND WARPED ON UPPER SKIN FROM LOWER SKIN SEPARATION. APPLIED SPEED TAPE ON LT INBD SDR SWAA2025091715500Transfer Sys · no discrepancyAFTER LEVEL OFF AT 10;000 ABOUT 12 MINUTES INTO FLIGHT WE RECEIVED A MASTER CAUTION FOR FUEL W/FUEL IMBALANCE ON NR 1 TANK. COMPLIED WITH QRH TO BALANCE FUEL. FUEL WAS WITHIN LIMITS ON LANDING. NO OVERWEIGHT LANDING. NO ABNORMAL ENGINE INDICATIONS OBSERVED. ESDR WX0A2025091732566Light · no discrepancy(AIRCRAFT NOT GROUNDED) AFTER PUSH BACK AND ENGINE START, CABIN EMERGENCY LIGHTS WERE ON WHILE THE EMER EXIT SWITCH WAS IN THE ARMED POSTION. / PERFORMED TSM 33-51-00-810-881-A PERFORMED OPERATIONAL CHECK OF THE MANUAL OPERATION OF BOTH CONTROL PANELS IAW AMMSDR DALA2025091706840Oil System · leakingDIRTY SOCK ODOR ON SHORT FINAL, SMELL IS IN THE BACK OF AIRCRAFT. FOUND OIL DRIPPING FROM NR 2 ENGINE SPINNER REAR CONE AND OIL POOLING INSIDE SPINNER. REMOVED AND REPLACED FAN SHAFT COVER SEAL PER A321 AMM 72-15. PERFORMED LEVEL "B" DECONTAMINATION OF ECS SSDR DALA2025091706835Skin · dentedRIGHT WING INBD AFT FLAP LOWER SURFACE AT 30" FROM OTBD FAIRING INBD SIDE FOUND DENTED. RT WING INBD AFT FLAP LOWER SURFACE AT 30" FROM OTBD FAIRING INBD SIDE DENT REPAIRED IAW SRM 51-70-10-2R-3, SRM 57- 53-01-2R-1, AND SRM 51-70-10-2R. (1201666)SDR DALA2025091706834Skin · chafedFOUND RT WING NR 9 SLAT LOWER SURFACE AT INBD AUX TRACK AREA CHAFED. RT WING NR 9 SLAT LOWER SURFACE AT INBB AUX TRACK AREA REPAIRED IAW SRM 57-43-02-2R-1, SRM 51-70-10-2R-4 & SRM 51-70- 10-2R (1201654)SDR DALA2025091706833Skin · wornNUMBER 5 SLAT LOWER SURFACE AFT EDGE FOUND WEAR, 40 IN FROM INBD EDGE. NR 5 SLAT LOWER SURFACE AFT EDGE REPAIRED IAW SRM 57- 43-02-2R-1 & SRM 70-10-2R-4 & SRM 51-70-10-2R (1201639)SDR ABXA202509176229Unknown · vibrationAFTER ENGINE START, UNUSUAL AIRFRAME VIBRATION. AIRCRAFT RETURNED TO BLOCKS. (BTB). PERFORMED FLT CONTROL CHECK IAW AMM 27-00-00, NO DEFECTS FOUND. ADDED MORE FUEL TO AIRCRAFT AND PERFORMED ENGINE IDLE RUN IAW AMM 71-00-00 OPS GOOD, NO VIBRATION NOTED. AFSDR YENA2025091700945Battery · no testFLT#591. BOS-TPA. EMERGENCY LIGHT BATTERY 10WL FAILED TEST. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY 10WL IAW 33-51-38. OPS CHK GOOD.SDR VNAA2025091711103Fmu · unserviceableR FADEC CAUTION AT CRUISE. / REMOVED AND REPLACED RH ENGINE FMU IAW CRJ900 AMM 73€“21€“03€“000/400€“801. OPS CHECK AND LEAKS CHECK GOOD.SDR YENA2025091700943Gcu · faultedFLT#1621, LHR-BOS. (ETOPS) L-1 TSI ELEC GEN 1 FAULT-DUE TO ELEC GEN 1 FAULT ON PFR IN LHR & GCU1 SHOWING THE AT FAULT, REMOVED AND REPLACED GCU NR 1 IAW AMM 24-22-34. OPS CHK GOOD. TSI CLOSED. GROUND VERIFICATION C/W PER AMM 24-22-34.SDR AALA202509179482Slide Raft · unraveledAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT PASSENGER / CREW DOOR SLIDE RAFT UNFOLDED FROM CONTAINER; SLIDE WAS INTACT AND DID NOT DEPLOY. REPLACED SLIDE RAFT ASSEMBLY PER TASK CARD 26L00025011.SDR AALA202509171172Lever · misinstalledAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT PAX - CREW DOOR ARMING LEVER YELLOW PAD WITH RME SHOULD BE MOUNTED ON FORWARD SIDE OF LEVER. MAINTENANCE CORRECTLY INSTALLED SLIDE ARMING LEVER PER AMM 25-23-46.SDR AALA202509171709Lever · misinstalledAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT PAX - CREW DOOR ARMING LEVER YELLOW PAD WITH RME SHOULD BE MOUNTED ON FORWARD SIDE OF LEVER. MAINTENANCE CORRECTLY INSTALLED SLIDE ARMING LEVER PER AMM 52-13-22.