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 CALA2025070906409Power Supply · no testEMERGENCY LIGHTS OPERATIONAL CHECK, EMERGENCY PATH LIGHTING INOP IN ROWS 1-5. R&R POWER SUPPLY #2816 PER AMM 33-51-06-960-803. OPS CHECK GOOD.SDR CALA2025070906406Unknown · odorFA REPORTED SMELL OF SMOKE IN CABIN DEBRIEFED CREW SMELL WAS LIMITED TO FWD GALLEY ONLY LASTING UNDER 3 MINUTES NO OTHER AREAS WERE AFFECTED ACP REF 05-50-00-810-831-A RAN APU PACKS NO SMELL OVENS COFFEE MAKERS AND CHILLER ALL TURNED ON WITH NO SMELL ALSO OPESDR DXTA2025071004164Warning Message · false indicationRECIVED CHECK DOORS CAS. FOLLOW CHECK DOORS QRH AND CYCLED ALL DOORS ASSOCIATED ALSO COMPLETED POWER UP ANOMALY CHECKLIST. CAS REMAINS WITH THE MAIN CABIN DOOR CLOSED. DOOR OPEN LIGHT ALSO REMAINS ON.(HANDLE STIFF AND NOT STOWING) POWERED UP ACFT. CONFIRMED ASDR DXTA2025071004166Engine · no discrepancyRH ENGINE - POTENTIAL FOD ISSUE WITH POSSIBLE BIRDSTRIKE (10'CLOCK POSITION WHEN FACING RH ENGINE). REQUESTING INSPECTION FOR POTENTIAL DAMAGE. CORRECTIVE ACTION; COMPLIED WITH ENGINE INSPECTIONS REF GECF34BJ SM72·0!HL0 M(L), NO EVIDENCE OF BIRD STRIKE ATTHISDR DXTA2025071004171Support · out of adjustWHEN THE MAIN CABIN DOOR IS CLOSED THE SUPPORT LEG THAT THE DOOR RESTS ON WHEN OPEN IS NOT FULLY RECESSED WHEN THE DOOR IS CLOSED. IT¿S STICKING OUT APPROX THE WIDTH OF THE FOOT PLATE. CORRECTIVE ACTION; ADJUSTED MAIN DOOR SUPPORT LEG AS REQUIRED IAW AMM 52SDR N6WA2025071006Stringer · corrodedSTGR21R CORRODED AT FS394-FS409. REPAIRED STGR21R IAW GOJET EO-C550-53MR-005-OSDR N6WA2025071005Escape Rope · out of alignmentRH EMERG EXIT ROPE DOOR MIS-ALIGNED. SECURED RH EMERG EXIT ROPE DOOR IAW CRJ AMM 25-63-04SDR N6WA2025071004Skin · damagedLH INBD FLAP IS DAMAGED AND NEEDS EVALUATED. REPAIRED LH INBD FLAP IAW GOJET EO-C550-57MR-010-OSDR N6WA2025071003Former · corrodedCORROSION ON FWD FORMER AT FS311.72 ON PAX DOOR. REMOVE AND REPLACED THE FWD FORMER AT FS311 IAW DRAWING 601R31702 AND CRJ SRM 51-42-06SDR N6WA2025071002Link · corrodedLH AILERON PCU LINKS HAVE CORROSION INSIDE DIAMETER. REMOVED AND REPLACED LH AILERON PCU LINKS, BUSHINGS AND HARDWARE IAW CRJ AMM 27-15-14.SDR N6WA2025071001Bushing · corrodedRH AILERON PCU LINK HAVE CORROSION ON THE INSIDE DIAMETER. REMOVED AND REPLACED AILERON BUSHINGS AND HARDWARE IAW CRJ AMM 27-14-15.SDR DALA2025071005189Test Panel · no testSHIP 3221 DISC: CABIN EMER LIGHT TEST NO STARTING FROM CIDS PROGRAMMING AND TEST PANEL MEMBRANE SWITCH. C/A: REMOVED AND REPLACED CIDS P&T PANEL 110RH PER A320 AMM 23-73-18. BITE TEST GOOD. EMER LIGHT TEST FUNCTION GOOD. OK FOR SERVICE. (LP: 7502190)SDR SWIA202507090008Connector · shortedANTI ICE DUCT WARNING AT CRUISE. QRH COMPLETED. MESSAGE CLEARED. (FLIGHT 5135 - FILED CLOSED)THIS DISCREPANCY WAS TRANSFERRED TO CAMP ITEM 30455056 WITH THE FOLLOWING CORRECTIVE ACTION: "TORUBLESHOT THE A/I DUCT WARNING IN REFERENCE TO WM 36-21-00. CHECKED PISDR FDEA202507081146Floorboard · dentedMAIN DECK FLOOR PANEL 222BFF HEAVILY DENTED. FABRICATED NEW FLOOR PANEL 222BFF, MPN: 141T5856-106, RBL 33-RBL 54.75, STATION 285-412 IN REF TO BOEING DWG 141T5856-106. SEE JPF FOR ALL WORK PERFORMED. THIS IS A MAJOR REPAIR. INSTALLATION OF THIS PANEL WILL SDR FDEA202507081145Floor Panel · dentedMAIN DECK FLOOR PANEL 222AFF HEAVILY DENTED. MARKED FABRICATED NEW FLOOR PANEL 222AFF, MPN:141T5856-107, RBL 33 RBL 11, STATION 412 IN REF TO BOEING DWG 145T5856-107. SEE JPF FOR ALL WORK PERFORMED. SEE WO:90406, NR#0130 FOR INSTALL AND REINSTALL. THIS IS SDR FDEA202507081143Sensor · failedEMERGENCY DECLARED FOR LE SLAT ASYM INDICATION. AT APPROXIMATELY 1500 AFE AND 160 KNOTS, WE WERE AT FLAPS 25 WITH NORMAL INDICATIONS. WHEN SELECTING FLAPS 30, THE LE SLAT ASYM EICAS MESSAGE APPEARED ALONG WITH THE LEADING EDGE DISCRETE LIGHT. WENT AROUND SDR FDEA202507081142Skin · dentedDENT ON RH WING, INBD TE FLAP, AFT FLAP LOWER SURFACE, AT 60" FROM INBD EDGE AND 2" FROM TE DENT ON RH WING, INBD TE FLAP, AFT FLAP LOWER SURFACE WAS REPAIRED IAW B767 SRM 51- 70-10-2R AND SRM 51-70-03-0G REV 92 APR 15 2025 AND SRM 57-53-01-2R FIG 201 SHEETSDR FDEA202507081141Skin · damagedDENT ON INBOARD AFT FLAP, INNER SURFACE LH WING INBOARD AFT FLAP, INNER SURFACE LH WING WAS REPAIRED IAW B767 SRM 57-53-01-2R FIG 201 SHEET 4 DETAIL III NOTE A, SRM 51-70-10-2R REPAIR 4 FIGURE 201 SHEET 1 AND SRM 51-70-03-0G PARAGRAPH 5L FIGURE 16 SHEET 1SDR YENA2025070900716Valve · failedFLT#1908, CDG-JFK. (ETOPS) "REF T/C A3625040-01 ON WO 1423764 FAN AIR VALVE REQ REPLACEMENT; REMOVED AND REPLACED FAN AIR VALVE IAW AMM 36-11-54 OPS CHK GOOD."SDR IPXA2025070918111Panel · crackedPANEL 831BZ HAS CRACK (.500 IN).SDR IPXA2025070918116Panel · crackedPANEL 831AZ HAS CRACK (.600 IN).SDR IPXA2025070922065Sight Glass · scratchedL-1 CREW DOOR EMERGENCY SLIDE COVER LOOKING GLASS IS SCRATCHED AND UNABLE TO SEE THROUGHSDR DALA2025070905185A/C Pack · corrodedSHIP 3146 RT A/C PACK ACM WITH INNER CORROSION. CORRECTIVE ACTION: REPLACE RT A/C PACK AIR CYCLE MACHINE IAW AMM 21-52-21-000-001-A & 21-52-21-400-001-A. (1070953).SDR DALA2025070905182Seat Track · corrodedSHIP 3130 CORROSION SEAT TRACK +Y1292 LOCATED BETWEEN FR16 TO FR20 FWD GALLEY AREA. REPLACED SEAT TRACK Y1292 LOC.BETWEEN FR12 TO FR24 FWD GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM 51-72-11. (1071301).SDR DALA2025070905181Door Frame · crackedSHIP 3130 CRACK INDICATION FOUND ON HOLE 3 OF THE DOOR STOP FITTING 7 AT FRAME 1 6 RH SIDE. REPLACED INTERCOSTAL FITTING (1 E/A) LOC. AT LEVEL DOOR STOP #7 ON FR16 RH IN FWD GALLEY AREA AS PER A319 SRM 51-42-11, A319 SRM51-72-11.SDR DALA2025070905180Elec Connector · corrodedSHIP 6702 CREW REPORT EMERGENCY ESCAPE L LIGHT ON PANEL P61. PER B757 SSM 25-65-01 SHT 1 FOUND GRD BTWN COCKPIT TEST PNL M32 CONN D1164 PIN 7 AND PRESS SWTICH S10463 PIN A. REMOVING PRESS SWITCH CONN D5530 LIGHT GOES OUT. FOUND CORRODED CONNECTOR PINS. CLEANSDR DALA2025070905177Skin · corrodedSHIP 663 A.D.//A.A. DAMAGES WERE FOUND ON OPEN HOLES AT RH ENG DRAG FTG CLAMP-UP & DRAG BRACE AS FOLLOW: HOLE #2 CORROSION ON SKIN AND FITTING BTW 2-4 & 8-10 HRS POS. HOLE #3 CORROSION ON SKIN AND FITTING BTW 12-3 & 6-11 HRS POS. HOLE #4 CORROSION ON SKIN AND SDR AALA202507095361Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR HARD TO OPEN. ADJUSTED FORWARD LAVATORY DOOR, OPERATIONAL CHECK GOOD.SDR AALA202507094845Slide · low pressureAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE PRESSURE OUTSIDE OF GREEN BAND. REMOVED AND REPLACED L1 DOOR SLIDE. PER J/C 08L22125001.SDR AALA202507090379Trim Panel · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LEFT BOTTOM TRIM LOOSE. INTERFERES WITH DOOR OPENING AND CLOSING. SECURED TRIM IN PLACE, LAVATORY DOOR OPERATIONAL CHECK NORMAL. PER AMM 25-40-11.SDR AALA202507091583Flashlight · inoperativeAIRCRAFT WAS GROUNDED: FORWARD FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT INOPERATIVE. INSTALLED NEW BATTERY FLASHLIGHT. OPERATIONAL CHECKED NORMAL. PER AMM 25-00-00.SDR AALA202507090171Unknown · odorAIRCRAFT WAS GROUNDED: SOF EVENT OCCURRED DURING TAXI OUT, SEVERAL MINUTES AFTER ENGINE START. IDENTIFIED VIA AFT GALLEY FLIGHT ATTENDANT, (DIRTY SOCK, ELECTRICAL ODOR). STRONGEST ODOR IN AFT RIGHT GALLEY GASPER. NO OTHER AIRCRAFT JET ENGINE EXHAUST IN VICINITSDR DALA2025070905176Stringer · damagedSHIP 3360 STGR 1L HAS DAMAGED FASTENER HOLES FWD OF FR60. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-42-11. (1071464)SDR DALA2025070905175Stringer · gougedSHIP 3360 STGR 1R IS GOUGED AT THE 4TH HORIZONTAL STRINGER FASTENER HOLE FORWARD OF FR62. CORRECTIVE ACTION: REPAIRED PER A330 SRM 51-42-11. (1071461)SDR AALA202507097520Light · brokenAIRCRAFT WAS GROUNDED: EMERGENCY LIGHT ON FLOOR, WALL SIDE OF FWD CLOSET BY 1L JUMP SEAT IS BROKEN. MAINTENANCE REPLACED PROX LIGHT.SDR AALA202507099411Transducer · faultyAIRCRAFT WAS GROUNDED: HYD B RSV HOT ECAM RETURNED IN FLIGHT (REPEAT). MAINTENANCE REPLACED BLUE SYSTEM TEMP TRANSDUCER IAW AMM 29-33-11.SDR AALA202507092443Coffeemaker · odorAIRCRAFT WAS NOT GROUNDED: FLIGHT CREW COMPLAINING OF ELECTRICAL ODOR IN AFT GALLEY. DURING PREFLIGHT. ACCOMPLISHED SOF JOB CARD 26L00021001 SUSPECT 5-7 AFT GALLEY COFFEE MAKER SOURCE OF SOF.MAINTENANCE REPLACED COFFEEMAKER.SDR AALA202507097252Fan · odorAIRCRAFT WAS GROUNDED: DUE TO REPORTED SMOKE ODOR IN FLIGHT. MAINTENANCE REPLACE LEFT LOWER AIR CIRCULATION FAN IAW AMM 21-25-17.SDR AALA202507098993Door Latch · bindingAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR TOOK TWO OFF US TO GET OPEN AND WILL NOT CLOSE NOW THAT THE DOOR IS OPEN. MAINTENANCE ADJUSTED COCKPIT DOOR LATCH MECHANISM REF. AMM 52-51-21.SDR AALA202507095435Seal · leakingAIRCRAFT WAS GROUNDED: CLIMBING THROUGH 35,000', A LOUD HUMMING SQUEAL WAS HEARD FROM DOOR 1R. DECESION MADE TO DIVERT TO LAX. NO EMERGENCY DECLARED AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE EXTRUDER SEAL PER AMM 52-11-18 AND PERFORMED LEAK CHECK PER AMM 0SDR CALA2025070906385Fseu · faultedEMERGENCY DECLARED DUE TO FLAPS STUCK AT 25. REPLACED FSEU #1 IAW AMM 27-51-01-422-011. OP CHECK GOOD IAW AMM 27-51-01-422-005.SDR CALA2025070906384Support Beam · wornRIGHT PACK BAY CUTOUT OUTBOARD FRAME HAS GOUGE FROM FWD O/B HIGH PRESSURE DOOR LATCHCOMPLETED REPAIR STEPS 4 PARA A-E. REF SRM 57-10-13-2R-3. REQ HFEC ALONG CUTOUT TO VERIFY NO CRACK PER STEP F. REQ HFEC FOR ALL FASTENER HOLES TO VERIFY NO CRACKS PER STEP G. ASDR CALA2025070906383Crease Beam · corrodedMAIN CABIN CREASE BEAM INNER CHORD UPPER SURFACE HAS CORROSION AT STA 294, RBL 53. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS PER ECRA 5321-01330 REV H. ORIGINAL MAT .094, REMOVED .017, REMAINING .077. INSTALLED NEW CREASE BEAM IAW SRM 51-SDR AALA202507095754Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202507096888Bottle · no testAIRCRAFT IN BASE MAINTENANCE: EMERGENCY EXIT DOOR 844, DOOR DAMPER AND EMERGENCY OPERATION CYLINDER STRIKER LEVER MECHANISM DOES NOT WORK CORRECTLY. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-14/SDR SCNA20250709251Glowstrip · damagedDAMAGED PHOTOLUMINESCENT FLOOR PATH MARKING BETWEEN ROWS 9-11. REMOVED AND REPLACED DAMAGED PHOTOLUMINESCENT FLOOR PATH STRIP. NO OTHER DEFECTS NOTED. REF CMM 33-51-07.SDR UIEA2025070800866Hook And Loop · wornEVAS HOOK AND LOOP STRIP SEEMS WORN. R & R CAPT & FO GLARESHIELD HOOK AND LOOP IAW EO 6725A287. NO FURTHER DEFECTS NOTED.SDR DXTA2025070904173Light · malfunctionedEMERGENCY LIGHTS CAME ON WHILE AT CRUISE IN ARM POSITION. LIGHTS TURNED OFF DECENDONG THROUGH 10,000. NO CAS MESSAGE ASSOCIATED. CORRECTIVE ACTION: FOUND TO BE TRANSITORY CONDITION OF THE LIGHT CONTROL PANEL. OPS CHECK GOOD. IAW PHENOM 300 FIM 4885 33-50-00.SDR DXTA2025070904168Bellcrank · out of adjustTHE DOOR COMES UP, BUT THE LATCHING HANDLE WILL NOT ENGAGE, STUCK IN THE OPEN POSITION CORRECTIVE ACTION: REALIGNED PIN BELL CRANK. IAW CE680A AMM 52-10-04. OPS CHECK GOOD.SDR DXTA2025070904167Brake · malfunctionedRIGHT BRAKE WAS GRABBING WHEN DOING A RIGHT TURN DURING TAXI. TRIED TO TAXI BACK TO THE FBO BUT IT BECAME WORSE AND STARTED GRABBING WHILE GOING IN A STRAIGHT LINE. WE STOPPED IN PLACE AND GOT A TUG. CORRECTIVE ACTION: PERFORMED MAIN HYDRAULIC SYSTEM BLEEDING