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 AALA202510106825Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW LIGHT BELOW SEAT 12C IS BROKEN OFF. REINSTALLED LIGHT ASSEMBLY AT SEAT 12C. ACCOMPLISHED OPERATIONAL CHECKED GOOD. PER AMM 33-51-11.SDR AALA202510104078Lavatory · odorAIRCRAFT WAS NOT GROUNDED: SHORTLY AFTER TAKEOFF FLIGHT ATTENDANTS NOTICED A STRONG SMELL IN THE GALLEY, UPON FURTHER INSPECTION WE NOTICED FLUID COMING FROM THE LAVATORY WALL AND ACROSS THE ENTRY WAY TOWARDS THE CLOSET, IT SMELLED LIKE WASTE AND URINE. (OPENSDR AALA202510109255Battery · dischargedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND FLIGHT ATTENDANTS FLASHLIGHT BATTERY IS DEAD. REMOVED AND REPLACED BATTERY. PER JC 09C00005001.SDR AALA202510105188Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD SERVICE DOOR DIFFICULT TO ARM AND DISARM, ALSO THE LATCH IS DIFFICULT TO OPERATE. CLEANED AND LUBED R1 GIRT BAR FITTINGS. PER AMM 25-66-02. OPERATIONAL CHECK GOOD.SDR AALA202510100315Sign · dislodgedAIRCRAFT WAS NOT GROUNDED: 14C EMERGENCY EXIT SIGN POPPED OUT ON ONE SIDE. REINSTALLED 14C SEAT EMERGENCY EXIT LIGHT ASSEMBLY.SDR AALA202510108655Toilet · leakingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY TOILET LEAKS ON CLIMB AND DESCENT, SMELLS OF URINE. REMOVED AND REPLACED TOILET ASSEMBLY. PER AMM 38-32-01. LEAK CHECK GOOD AND OPERATIONAL CHECK GOOD.SDR AALA202510101087Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT SERVICE DOOR GIRT BAR DIFFICULT TO INSTALL IN POSITION. LUBED GIRT BAR, OPERATIONAL CHECK GOOD.SDR SCNA20251010404Flap System · faultedDURING APRROCH THE LE FLAP TRANSIT LIGHT STAYED AMBER WITH FLPAS SET TO 5 LE DEVICE IDIACTION ON OVERHEAD REMAINED GREEN RAN QRH. PERFOMRED FSEU BITE NO CURENT FAULTS MX MESSAGE IN FAULT HISTORY 27-81216. F1 PROX RETRACT. PERFOMRED FIM 27-88 TASK 805 REPAIR CSDR WX0A2025101032589Epsu · no test(AIRCRAFT NOT GROUNDED) FAILED EPSU SYSTEM TEST. / REMOVED AND REPLACED EPSU REF WO533073"SDR SCNA20251010403Unknown · unknownFA REPORT LOUD BEEPING SOUND IN AFT GALLEY NEAR L2 DOOR BY WALL THAT SEPORATS GALLEY AND LAV. PERFOMRED DOOR EARY HEATER OPS TEST AND INSPECTED AREA AROUND HEATER DUE TO RESENT REPLACMENT REF AMM 21-45-00 OPS TEST GOOD AND DEFECTS FOUND. PERFOIMRED PA OPS TESSDR DALA2025101007439Girt Bar · overservicedFA REPORTS L1 DOOR UNABLE TO ARM SLIDE. FOUND EXCESSIVE AMOUNT OF GREASE IN GIRT BAR FITTINGS, HENCE RETAINING DEBRIS. REMOVED DEBRIS & GREASE & OPS CHECK ARMING DOOR FUNCTION PER B757 AMM 51-11. (7860996)SDR DALA2025101007436Seal · out of positionDOOR 1R WILL NOT ARM. REPOSITION RUBBER SEAL OPS CKS GOOD IAW B757 AMM 52-00 OK FOR SVC. (7736540)SDR DALA2025101007432Slider · faultedTHE ENGAGEMENT BETWEEN THE GIRT BAR SLIDER AND FWD/AFT FLOOR FITTING WERE FOUND OUT LIMITS AT R2. GIRT BAR AT R2 WAS REPLACED AMDS 2561- 01257-01D AND PER B757-200 AMM 25-66-10 AND P/N VERIFY PER B757- 200 AIPC 25-66-05. AND TEST OF GIRT BAR R1 WAS PERFORMEDSDR DALA2025101007431Access Panel · crackedSHIP 6713 DURING OK TO CLOSE ACCESS PANEL 121AC. CRACK ON STRAP OF CEILING SUPPORT STA 560 LBL 44 AT FWD CARGO COMPARTMENT WAS FOUND. CORRECTIVE ACTION: SUMMARY OF NRC 00606- STRAP OF CEILING SUPPORT STA 560 LBL 44 AT FWD CARGO COMPARTMENT WAS REPAIRED PER B75SDR DALA2025101007440Slide · no testDURING SCHEDULED TEST DEPLOYMENT OF L3 SLIDE, SLIDE FAILED TO FULLY EXTEND. REPLACED SLIDE REF JOBS 4 AND 10 ON WORK PACKAGE. (7620693)SDR DALA2025101007427Wire · damagedSHIP 3309 EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE LOCATIONS:606 AND 607. REPAIRED WIRING AND REPLACED LAMP ASSY PER A330 AMM 33-52. (1242690)SDR IPXA2025101081235Door · malfunctionedL1 DOOR DOES NOT OPEN ELECTRICALLY. REPOSITIONED REAR FACING COURIER SEATS TO RETRACTED POSITION, OPERATED L1 DOOR ELECTRICALLY SEVERAL TIMES. NO FAULTS NOTED.SDR IPXA72672Panel · brokenFWD CREW DOOR PANEL 831GZ BROKEN IN CORNER. REPAIRED CREW DOOR PANEL 831GZ IAW A300 AMM 25-00-00/801 USED 1/4 OF TUBE ADHESIVE P/N: 04-001-0176 BTCH: 4433029. REVIEWEDSDR IPXA2025101073140Roller · excess playROLLER UPPER REW DOOR FWD HAS AXIAL PLAYSDR IPXA2025101073123Roller · excess playCREW DOOR ROLLER AFT SIDE HAS AXIAL PLAY DOR ALEX-04 APPROVEDSDR DALA2025101007407Doubler · crackedUPPER FUSELAGE L1 DOOR CUTOUT FR16 DOUBLE JOGGLE AREA IN THE OUTER FLANGE OF THE FRAME WITH CRACK AT DOOR STOP 7 LHS FASTENER HOLE LOCATIONS #7, #A & #C WITH CRACK. COMPLIED WITH ER/A 628831-14AD. (1243004).SDR DALA2025101007406Doubler · crackedUPPER FUSELAGE R1 DOOR CUTOUT FR20 DOUBLE JOGGLE AREA IN THE OUTER FLANGE OF THE FRAME WITH CRACK AT DOOR STOP 1 RHS FASTENER HOLE LOCATION #14 WITH CRACK. ER/A #628975-14AD. (1243972).SDR K11A2025100900355Lock · dirtyMAIN CARGO DOOR UNLOCK LIGHT ILLUMINATED IN FLIGHT, LIGHT EXTINGUISHED AFTER LANDING. CLEANED MAIN CARGO DOOR LOCKS AND SWITCH PERFORMED OPERATIONAL CHECK IAW B737-800 IAI SUP MANUAL 52-32-00. MAIN CARGO DOOR OPS CHECK GOOD NO DEFECTS NOTED AT THIS TIMESDR VNAA2025101011101Windshield · arcedFOS WINDSHIELD ARCING IN FLIGHT QRH COMPLETED. REMOVED AND REPLACED FO SIDE WINDSHIELD IAW AMM 56-11-01-000/400-801-A01-PSA. OPS TEST OF FO SIDE WINDSHIELD TEMPERATURE CONTROL PASSED IAW AMM 30-41-06-710-801-A01. PRESSURIZED THE AIRCRAFT FOR LEAK TEST OF THESDR SIMA20251009002Power Supply · no testDURING PS 2 CHECK, FOUND AFT LH EMREGENCY LIGHT AT FLOOR LEVEL TO BE INOP RAR AFT EMERGENCY LIGHT POWER UNIT (ELPU) IAW AMM 33-50-01. EMERGENCY EXIT LIGHT/ELPU OPS CHECK GOOD.SDR SIMA202510109001Battery · no testFORWARD CABIN FLASHLIGHT INOP REPLACED FLASHLIGHT BATTERY IAW AMM 33-51-01. OPS CHECKED GOODSDR FDEA202510091937Floor Panel · dentedMAIN CARGO COMP AT STA 412 TO 490 & LBL11 TO RBL11 ABOVE FLOORBOARD 241AFF SURFACE SKIN HAS INDENTATION. FABRICATED MAIN DECK FLOOR PANEL 231AFF (MPN: 143T5875-5) AT STA 412- STA 490, LBL 11- RBL 11 IN REF TO BOEING DRAWING 143T5875-5.SDR FDEA202510091936Seat Track · damagedMAIN DECK FIRST OFFICER SEAT TRACK (AFT/LH) SHOWS GROOVE ON SURFACE AND ELONGATE REMOVED/REPLACED MAIN DECK FIRST OFFICER SEAT TRACK (AFT/LH) IAW B757 SRM 51-40-02- 0G AND B757 AMM 20-11-00-2SDR FDEA202510091935Seat Track · damagedMAIN DECK PILOT AFT/RH SEAT TRACK SHOWS GOUGE ON SURFACE AND HOLES ELONGATE REMOVED & REPLACED MAIN DECK PILOT AFT/RH TRACK IAW B757 SRM 51-40-02-0G AND B757 AMM 20-11-00-2SDR UIEA2025101001266Regulator · leakingPAX OXYGEN TANK (BOTTLE 2) REGULATOR LEAK(<P>REMOVED AND REPLACED PAX OXYGEN TANK REGULATOR IAW B767 AMM 35-11-03. LEAK & PRESSURE CHK OK</P>)SDR DALA2025101007403Battery Pack · inoperativeON SVC CK EMERGENCY EXIT SIGN @ ROW 20 LT SIDE INOP. R/R EMERGENCY BATTERY IAW B737 AMM 33-51.OPS CK GOOD.SDR DALA2025101007402Skin · damagedWHILE IN ATL, MTC IS ADDRESSING LIGHTNING STRIKE DAMAGES TO THE CROWN SKIN FUSELAGE OF THE AIRCRAFT. THERE ARE A TOTAL OF FIVE (5) LIGHTING STRIKE LOCATIONS FOUND BETWEEN STR 2R 3R AND STA 380-787. MAINTENANCE REPAIRED DAMAGE PER ERA 629735-14, 629736-14 ANDSDR DALA2025101007400Skin · corrodedCORROSION ON INB SKIN FUSELAGE AND DOUBLER SUPPORT(NATS AIRPHONE ANTENNA) STA 747,STA 757 AND STA 797 BTWN S27L TO 27R (BILGIE AREA) CARGO COMPARMENT C2.SDR DALA2025101007399Skin · dentedTHREE DENTS BETWEEN STA 727F+7 TO 727E AND S2R - S3R, ALSO 8 DENTS BTW STA 727E +15 TO 727G STGR 2L/3L AT EXTERNAL FUSELAGE SKIN. FUSELAGE SKIN (VIASAT) BTW STA 727E TO 727G STGR 3L/3R WAS REPAIRED PER PRI 629345-14 REV 0 TO 4 AND ERA 629345-14AD REV. ORIGINALSDR DALA2025101007398Skin · dentedTHREE DENTS BETWEEN STA 727F+7 TO 727E AND S2R - S3R. FUSELAGE SKIN BTW STA 727E TO 727G STGR 3L /3R WAS REPAIRED PER PRI 629296-14 REV 0 TO 3 AND ERA 629296-14AD REV. A.SDR DALA2025101007397Window Frame · crackedCRACK ON AFT UPPER CORNER FRAME OF NO.1 LH WINDOW AT COCKPIT ON REFERENCE CARD 5311-2003. LH WINDOW FRAME AT COCKPIT WAS REPAIRED PER ER/A 619132-14AD.SDR DALA2025101007396Window Frame · crackedCRACK WAS FOUND OF: 0.375IN LENGTH ON RH WINDOW FRAME RADIUS AREA IN REF. CARD 5311-2003. RH WINDOW FRAME WAS REPAIRED PER ER/A 619132-14ADTR REV, A.SDR AALA202510104947Seat Track · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN CROWN TAB ON PASSENGER CABIN SEAT TRACK AT BS 1858, LBL 108. REPLACED SEAT TRACK PER EA 368647.SDR CALA2025101009904Skin · nickedRT FUSELAGE AT FWD FIRST OFFICER STATIC PORT HAS SURFACE SC RATCHES. WORKED PER UAL ECRA 5330-07628, REWORKED R/FUS FWD FIRST OFFICER STATIC PORT, NO DEVIATIONS'SDR CALA2025101009903Lamp · burned outDOOR 4L EXTERIOR EMERGENCY LIGHT INOP RELAMPED DOOR 4L EXTERIOR EMERGENCY LIGHT. OPS CHECK GOOD. REF AMM 33-51-06 PARTS USED: 99-3351-3-0014,QTY :1SDR CALA2025101009895A/C Pack · odorDANK SMELL COMING FROM PACKS AT LOW ALTITUDES W/ RAM DOORS OPEN RAN THE PACKS FOR DURATION OF 20MIN, SMELL WENT AWAY. REF FIM 21-00 TASK 806.SDR CALA2025101009894Power Supply · faultedRIGHT EMERGENCY EXIT LIGHTS POWER SUPPLY CONTROLLER HAS A FAULT. REMOVED AND REPLACED RH EMERGENCY EXIT LIGHT POWER SUPPLY ASSY 12WL, OPS CHECK OK REF AMM 33-51-38.PARTS USED: 31-3350-9-9001, QTY :1 ROTABLE PARTS CHG:TT # 1422891 SN OFF 4242 PN OFF 31-3350-9-9SDR CALA2025101009893Elec Connector · damagedALL FIRST-CLASS SEAT EMERGENCY LIGHTS INOP FOUND PIN PUSHED BACK IN SIDEWALL CONNECTOR. RE-SEATED INTO LOCKING MECHANISM & PULLED CK WIRE. CONNECTOR & WIRES GOOD EMERGENCY LIGHT NOW OPERATES NORMAL REF. ESPM 20-44-11.SDR CALA2025101009892Slide · no discrepancyENTRY DOORS R1 AND L2 SLIDE PACK PRESSURE NOT IN GREEN BAND DRS R1 AND L2 SLIDE PRESSURES OKAY REF AMM 25-66-00.SDR CALA2025101009891Slide · no discrepancy2L DOOR SLIDE COMPONENTS EXPOSED INSPECTED 2L SLIDE, NO COMPONENTS EXPOSED, OK FOR SERVICE, PER ESCAPE SLIDE PACK CHECK.REFERENCE: TASK 25-66-01-200-802SDR HALA20251010051Battery Pack · inoperativeCENTER EXIT SIGN INOP. REPLACED EMERGENCY BATTERY AND POWER SUPPLY PER AMM 33-51-03. OPS CHECK GOOD.SDR HALA20251010312Valve · faultedETOPS - TRIM AIR VALVE INDICATION FOR COCKPIT TEMP INDOCATE AMBER XX. BUT CKPT TEMP CAN BE CONTROLLED NORMALLY. REMOVED AND REPLACED COCKPIT TRIM AIR VALVE (637HK) IAW A330 AMM 21-63-51. OPS CHECK AND LEAK CHECK GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR HALA20251010311Fire Loop · faultedETOPS - ENG 1 FIRE LOOP B FAULT. NSTALLED FDU #1 AND PYLON FIRE DETECTOR 6WD1 PER 26-12-34-000-804-A & 26-12-16-000-808-A. OPS TEST OKSDR DALA2025101007392Control Unit · faultedDIV - DIVERTED TO RDU DUE TO AN ENG 2 THROTTLE LEVER DISAGREE MESSAGE. REPLACED THROTTLE CONTROL UNIT PER A320AMM 76-11. OPERATIONAL CHECK GOOD, NO FAULTS.(LP: 7403542)SDR HNAA2025101000691Inverter · inoperativeFWD FACING EMERGENCIY EXIT ROW SIGN NOT ILLUMINATING. RAR EMERGENCY LIGHT INVERTER #6