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 SWAA2025090510418Bulb · inoperativeEMERGENCY EXIT SIGN NEAR LEFT AFT DOOR HAS 1 BULB INOP. REMOVED AND REPLACED PER AMM 33-51-01-960-801-NG.SDR SWAA2025090510419Lamp · inoperativeLOWER EMERGENCY EXIT SIGN AT ROW 15ED HAD 4 BULBS INOP. REMOVED AND REPLACED PER AMM 33-51-01-960-801-NG.SDR SWAA2025090510420Lamp · inoperativeLOWER EMERGENCY EXIT SIGN AT ROW 14FED HAS 2 BULBS INOP. REMOVED AND REPLACED IAW AMM 33-51-01-960-801-NG.SDR R61A2025090200385Engine · failedENGINE 2 FAIL AND LOUD BANG ON TAKEOFF AROUND 1500 FEET. WINDMILLING AND NO OIL PRESSURE, SLIGHT ODOR IN CABIN. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. R&R E2.SDR AALA202509054121Bottle · low pressureAIRCRAFT WAS GROUNDED: R3 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509059243Bottle · low pressureAIRCRAFT WAS GROUNDED: L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509057990Bottle · low pressureAIRCRAFT WAS GROUNDED: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509059648Bottle · low pressureAIRCRAFT WAS GROUNDED: L4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509050586Bottle · low pressureAIRCRAFT WAS GROUNDED: R2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-22-00.SDR AALA202509053362Battery · no testAIRCRAFT WAS GROUNDED: R2 DOOR FLIGHT ATTENDANTS FLASHLIGHT WONT CHARGE AND IS INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR AALA202509050105Battery · no testAIRCRAFT WAS GROUNDED: L4 DOOR FLIGHT ATTENDANTS FLASHLIGHT WONT CHARGE AND IS INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 25-65-00.SDR 2025FA0000626Tire · blownAFTER LANDING INTO KBFD, AIRCRAFT STARTED DRIFTING LEFT, PILOT LOOKED OUT AND NOTICED THAT THE LEFT MAIN TIRE HAD BLOWN. PILOT CONTACTED TOWER TO PLEASE CLOSE THE RUNWAY UNTIL THEY COULD GET THE AIRCRAFT OFF SAFELY.SDR AALA202509054105Galley Mat · peelingAIRCRAFT WAS NOT GROUNDED: FLOORING IN G1 PEELING UP, FA'S TRIPPING OVER IT. MAINTENANCE REPLACED FLOOR MAT AT GALLEY G1 IAW AFMM 20-25-16.SDR DXTA2025090504799Bezel · brokenPATH LIGHTING SIGN OF EMERGENCY LIGHT SYS IN ZONE 4 NEAR FLOOR CORNER OF BED IS BROKEN AND HANGING LOOSE ON FLOOR. REMOVED BROKEN BEZEL FLOOR PATH MARKER (P/N: 625038107-001) FROM CABIN BED. INSTALLED NEW BEZEL FLOOR PATH MARKER (P/N: 625038107·001) ONTO CASDR CALA2025090508524Filter · dirty30MINS INTO FLT FA REPORTED BURNING ODOR IN CABIN. ODOR GOT WORSE, NO SMOKE OR FIRE DETECTED. FA REPORTS PUNGENT ODOR IN FWD & AFT CABIN DOOR AREAS & VENTS OF BURNING PLASTIC. FA REPORTED ODOR TO PILOTS, CONCURED WITH ODOR IN FLT DECK. ODOR MORE INTENSE ON SDR CALA2025090508492Light · broken51D EMERGENCY LIGHTING BROKEN. REMOVED LIGHT AND HOUSING AT SEAT 51D. ALL OTHER LIGHTS OP CHECK OK. REPLACED 51D EMER FLOOR PROXIMITY LIGHT ASSEMBLY. OPS CHECK GOOD IAW AMM 33-51-05-960-802.SDR CALA2025090508483View Port · detachedDOOR 1R PLASTIC VIEW COVER SLIDE OFF AND INTO SLIDE PACK. REATTACHED CLEAR PLASTIC LENS WITH BONDING AGENT IAW ECRA ECRA 2566-01215. NO DISCREPANCIES NOTED.SDR CALA2025090508482Warning Light · false activationECAM ENG 1 START VALVE FAULT REQUESTING DEFFERAL 8011M ENG 1 START VALVE INDICATION ERRONIOUS. START VALVE VERIFIED CLOSED AMM 80-11-00-040-042-A. COMPLIED WITH DDP. PERFORMED OPS TEST OF ENG 1 START VALVE IAW TSM 80-00-00-810-801-B. NO FAULTS FOUND, OPS CSDR HALA20250904048Not Reported · not reportedTOW BAR SNAPPED ON PUSH. AWAITING FULL RESOLUTION.SDR AALA202509041818Flap System · malfunctionedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLAPS STUCK AT FLAPS 5; AIRCRAFT EMERGENCY LANDED SAFELY AT EWR. UPON ARRIVAL PERFORMED BITE TEST OF FLAP AND SLAT (FSEU), PER AMM 27-51-00-810-801. NO FAULTS RECORDED. PERFORMED FLAPS AND SLAT OPERATIONSDR AALA202509049158Tube · missingAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR GIRT BAR MISSING RED HEATSHRINK. INSTALLED HEAT SHRINK ON AFT LEFT DOOR GIRT BAR, PER AMM 25-66-00. OPERATIONAL CHECK GOOD.SDR AALA202509045297Connector · dirtyAIRCRAFT WAS NOT GROUNDED: RIGHT AFT FUEL PUMP LOW PRESSURE LIGHT NOT ILLUMINATING WITH PUMP TURNED OFF. FOUND TANK NUMBER 2 AFT FUEL PUMP LOW PRESSURE LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202509035297): CLEANED CONNECTOR D872. PERFORMED AFT RIGHTSDR DALA2025090406556Flap System · lockedFCNT/DE- DECLARED EMERGENCY DUE TO TRAILING EDGE FLAPS LOCKED AT 5 DEGREES ON APPROACH TO LAND. PERFORMED GO-AROUND AND RESET FLAPS. SECOND APPROACH NORMAL. PERFORMED FSEU BITE CHECK. NO FAULTS RECORDED. PERFORMED OPERATIONAL TEST OF TRAILING EDGE FLAPS. OPSSDR DALA2025090406555O-Ring · failed(LOG 7340638) ON ARRIVAL AFTER ENG SHUTDOWN, NOTICED FLAMES COMING FROM # 1 ENG TAILPIPE. MOTORED #1 ENG TO PUT FLAME OUT. REMOVED #1 ENG AFT PLUG PER B737 AMM 78-11-02 (544643). REPLACED OIL INLET COVER O RINGAND REPLACED OIL SUPPLY TUBE PER B737 AMM 72-56-00SDR DALA2025090406545Tie Down · corroded(LOG 1178012) CORROSION ON SUPPORTS RH STA 747 AT AFT CARGO COMPARMENT. NET SUPPORTS (TIE TRACK) RH STA 747 AT AFT CARGO COMPARMENT WAS REPAIRED PER B737-800 SRM 53-00-53-2R PROCEDURE 3 REPAIR 3.SDR DALA2025090406544Plate · corroded(LOG 1178005) CORROSION ON SIDE PLATE RH STA 500 TO 500I AT FWD CARGO COMPARTMENT. SIDE PLATE RH STA 500 TO 500I AT FWD CARGO COMPARTMENT WAS REPLACED PER B737-800 SRM 51-40-02-0G.SDR DALA2025090406539Window Frame · crackedFOUND CRACKS ON STIFFENER AT UPPER ATTACHMENT OF THE RHS FR4 SLIDING WINOW FRAME. COMPLIED WITH ER/A 563906-14AD. (1177815).SDR DXTA2025090404798Brake Assy · unknownBOTH BRAKES ARE "CHATTERING" WHEN LIGHT TO MODERATE BRAKE PRESSURE IS APPLIED. MAKES TAXIING INCREDIBLY UNCOMFORTABLE. INSPECTED BRAKE ASSEMBLIES WHEN ACFT GOT MOVED INTO HANGAR. NOTED THAT BOTH BRAKES WERE AT AN EVEN TEMPERATURE, MEASURED LT BRAKE PIN AT 12SDR DXTA2025090404802Elec Connector · disconnectedFORWARD MOST WHITE EMER EXIT LIGHT INOP FOUND PIN#3 ON ELECTRICAL CONNECTOR P1389 TO BE DISCONNECTED FROM THE CONNECTOR, RESECURED THE PIN INTO CONNECTOR AS NEEDED PER PHENOM 300 SWPM 20-50-10. RH FWD WHITE EMERGENCY FLOOR LIGHT OPS CHECK GOOD AT THIS TIME.SDR DXTA2025090404803Battery · dischargedEMERGENCY LIGHTING ABOVE MAIN DOOR AND DROP AISLE LIGHTING FORWARD IS OFF WITH MAIN BATTERY CONNECTED AND EMER LTS SWITCH ON CORRECTIVE ACTION: TROUBLE SHOT TO FWD EMERGENCY BATTERY, REMOVED DEFECTIVE BATTERY AND INSTALLED CUSTOMER SUPPUED REPAIRED BATTERY. POSDR DXTA2025090404807Pin · recessedCLOSING THE MAIN CABIN DOOR FEELS LIKE ONE OF THE PINS IS BINDING. A LOT OF PRESSURE IS NEEDED TO CLOSE IT. UPON INITIAL MX INSPECTION OF MCD, FOUND THE MCD LOWER AFT TAPER PIN RECESSED SLIGHTLY TOO FAR INTO THE DOOR WHICH RESTRICTED THE OPERATION OF THE INNSDR DXTA2025090404809Battery · defectiveUPON POST FLIGHT WE NOTICED AS WE TURNED THE BATTERIES OFF AND THE EMER LIGHTS STILL ARMED THE EMER LIGHTS UNDER SEAT 5 AND 8 DID NOT STAY LIGHT. CORRECTIVE ACTION: PICKED UP PART FROM FBO. SET UP TOOLING. REMOVED FAILED BATTERY PACK #3 PN 6430028-1 SN E25-130SDR FDEA202509021611Floor Panel · damagedBROKEN PANEL 241LFF, UPPER CARGO COMPT. FLOOR PANEL 241LFF, UPPER CARGO COMPT. WAS REPAIRED IAW SRM 53-00-50-2R PAR. 4.B FIG. 201 SHEET 2 REV. 92 APR. 15, 2025.SDR FDEA202509021610Floor Panel · crackedPUNCTURE ON SURFACE OF FLOOR PANEL 251JFF SECTION 46 AT MDC PUNCTURE ON SURFACE OF FLOOR PANEL 251JFF SECTION 46 AT MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15 2025SDR FDEA202509021609Floor Panel · crackedCRACK ON SURFACE OF FLOOR PANEL 252GFF SECTION 46 AT MDC L= 2.5" CRACK ON SURFACE OF FLOOR PANEL 252GFF SECTION 46 AT MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15 2025SDR FDEA202509021608Floor Panel · crackedPUNCTURE ON FLOOR PANEL 231DFF SECT 43. MDC PUNCTURE ON FLOOR PANEL 231DFF SECT 43 MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15 2025SDR FDEA202509021607Floor Panel · crackedCRACK ON FLOOR PANEL 232MFF SECT 43 OF MDC CRACK ON FLOOR PANEL 232MFF SEC 43 OF MDC WAS REPAIRED IAW B767 SRM 53-00-50-2R PAR 4-B FIG 201 SHEET 2 REV 92 APR 15 2025SDR FDEA202509021606Floorboard · dentedMAIN DECK CARGO COMPARTMENT, FLOOR PANEL 221DFF HAS NUMEROUS DENTS. FABRICATED NEW FLOOR PANEL (PNL 221DFF MPN: 141T5856-117) AT STA 285 TO STA 400 BETWEEN RBL 11 AND RBL 33 IN REF TO BOEING DWG# 1415856-117. THIS IS A MAJOR REPAIR. SEE JPF WORK STEPS ACCOSDR REXA2025090400848Hand Rail · out of adjustMAIN CABIN DOOR STICKING CLOSED AND WOULD NOT OPEN UPON ARRIVAL. PERFORMED ADJUSTMENTS TO MAIN CABIN DOOR HAND RAIL IAW 900 AMM 52-11-05. PERFORMED MULTIPLE OPS TESTS IAW 900 AMM 52-11-00 OF MAIN CABIN DOOR, ALL OPS TESTS GOOD. NO FURTHER DEFECTS NOTED.SDR CALA2025090408477Light · detachedTRIM PIECE WITH LIGHT ON OVERHEAD AT 30ABC IS LOOSE. HANGING B Y WIRE. CURRENTLY SECURED IN O/H RESECURED OVERHEAD BIN/PSU BULLNOSE TRIM AT 30-32ABC. NO DEFECTS NOTED AT THIS TIME.SDR CALA2025090408466Smoke Detector · no discrepancyECAM LAV SMOKE. FA-S CHE KED ALL LAVS. MID LAV HA D SMOKE SMELL- REPORTED AS /WEED/ SMELL DEBRIEFED CREW. CAPT SAID ECAM LAV SMOKE MESSAGE APPEARED AT CRUISE. MESSAGE CLEARED AFTER 15 SECONDS AND COULD NOT BE RECALLED. CAPT CONTACTED FA WHO WENT TO THE MID LAVSDR CALA2025090408465Unknown · odorRELEASED BACK TO SERVICE AFTER EXPERIENCING A DIVERSION OR AIR TURN BACK DUE TO A MECHANICAL REASON. FOUND SOURCE OF FUMES SMELL WAS COMING FROM #2 ENG BLEED. INSP FAN BLADES AND BORO PLUGS, NO DEFECTS. ACCOMPLISHED #2 ENG WASH AND HIGH PWR RUN WITH ENG BLEESDR CALA2025090408464Unknown · odorSMOKE IN CABIN DURING TAKEOFF. REJECTED TO. SMOKE CEASED AND DIS SI PATED. REJECT AT 50 KTS CAPT STATED APU WAS OFF, RT AND LT PACK TURNED OFF PER A CHECKLIST. LT PACK WAS THEN TURNED BACK ON AND A SMALL AMOUNT OF SMOKE WAS EMITTED. LT PACK TURN OFF. F/O STATESDR CALA2025090408461Light · inoperativeROW 1 FORWARD SEAT MOUNTED EMERGENCY EXIT LIGHT INOP. - EMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK {B737-33-3-0235} - REMOVED AND REPLACED ROW 1 SEAT MOUNTED FLOOR PROXIMITY EMERGENCY LIGHT. REF. AMM 33-51-11. OPS CHECK GOOD.SDR CALA2025090408458Lock · faultedDOOR FLIGHT LOCK 1L EICAS STATUS #1 LEFT PASSENGER ENTRY DOOR FLIGHT LOCK COMMAND/FLT LK RLY/SENS OR DISAGREEMEN.DB PSEU 2 (R2) DB PSEU 2 (L2) STS MSG NOT ACTIVE,MAT DISPLAYS NO FAULT/MAINT MSG.DOOR OPENED AND CLOSED OKSDR CALA2025090408457Target · looseDOOR R AFT EMER EXIT INDICATION ECAM WARNING ON CLIMB. REMOVED EMERGENCY EXIT HATCH AT ROW 21DEF FOR INSPECTION AND CLEANING REF: AMM 52-21-11-000-001-A. DURING INSPECTION AND CLEANING OF THE AFT RIGHT EMERGENCY HATCH FOUND THE TARGET BRACKET ON THE COVER FLASDR CALA2025090408456Hook And Loop · wornRT AFT OVERWING EMERG EXIT DOOR HAS LOOSE ACCESS PANEL WHICH WON T SECURE FOUND OLD HOOK AND LOOP ON ACCESS PANEL ON EMERGENCY EXIT RT AFT. REPLACED WITH NEW HOOK AND LOOP AND SECURED. REF AMM 52-22-00SDR CALA2025090408455Girt Bar · no discrepancyDR 1L GIRT MATERIEL EXCESSIVE NEEDS TO BE RETUCKED REF LG PG 4100455, SLIDE SERVICEABLE, ALL MX DONE IN REF WITH 25-66-01-400-804. ACFT OK FOR SERVICE, NO MX ACTION PERFORMEDSDR CALA2025090408454Girt Bar · no discrepancyMAIN DOOR 1L GURT BAR FLAP UNRAVIELED GIRT BAR Z FOLD IS FOUND TO BE WITHIN LIMITS PER AMM 25-66-01-400-803.SDR CALA2025090408453Girt Bar · no discrepancyFLAP AT DOOR 2L ON FLOOR BY GIRT BAR IS STICKING OUT AND WONT RETRACT INSPECTED FLAPER FOUND NOT TOUCHING FLOOR OK TO CONT PER REF MM 25-66-01-400-803 ,