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 CALA2025102110334Skin · debondedRIGHT WING, OUTBOARD FLAP, AFTER FLAP, INBOARD END, LOWER SKIN WITH DISBOND AREAS. 11 X 1INCHES, 2.5 X 2.5 INCHES. CLEANED, PREPPED, REPAIRED AND RESTORED PAINT AT RH WING, OUTBOARD FLAP, AFTER FLAP, INBOARD END, LOWER SKIN IAW SRM 57-53-01-2R-16, SRM 51-70-SDR CALA2025102110333Skin · delaminatedRIGHT WING, OUTBOARD FLAP, AFTER FLAP, INBOARD END, UPPER SKIN WITH DISBOND AREA 4 X 3 INCHES. CLEANED, PREPPED, REPAIRED AND RESTORED PAINT AT RH WING, OUTBOARD FLAP, AFTER FLAP, INBOARD END, UPPER SKIN IAW SRM 57-53-01-2R-16, SRM 51-70-10-2R-0, AMM 51-21-41SDR CALA2025102110332Housing · gougedL-2 DOOR HANDLE BOX CUTOUT UPPER BUSHING AREA IS GOUGED. REMOVED AND REPLACED STUB BEAM IAW BAC DWG 147A6116 REV -.SDR CALA2025102110331Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1673 FAILS OPERATIONAL CHECK. REMOVED AND REPLACED WITH NEW EMERGENCY LIGHTS BATTERY PACK M1673, INSTALLATION TEST GOOD IAW B737 AMM 33-51-06-960-805.SDR DXTA2025102105355Transducer · faultedRED CAS HYD O' TEMP B MESSAGE CAME ON IN FLIGHT CORRECTIVE ACTION: REMOVED FAULTY HYDRAULIC TEMPERATURE TRANSDUCER ON SYSTEM B RESERVOIR AND REPLACED WITH A CUSTOMER SUPPLIED NEW UNIT. OPS CHECKS AND LEAK CHECKS ARE GOOD AT THIS TIME. ALL WORK DONE IN REFERENCSDR DXTA2025102105353Proximity Sensor · faultedWHILE IN FLIGHT AT FL400 RECEIVED AMBER CAS MESSAGES FOR CHECK DOORS AND CABIN DOOR OPEN. THE ORANGE LIGHT FOR CABIN DOOR OPEN WAS ALSO ILLUMINATED ON THE CABIN DOOR. WE VERIFIED THE LOCKING PINS WERE IN PLACE AND FOLLOWED THE QRH WHICH REQUIRED US TO RAISE THSDR DXTA2025102105348Control Unit · faultyAFTER TAKEOFF, WE SELECTED THE FLAP HANDLE TO FLAPS 0. IMMEDIATELY AFTER THAT, WE GOT A FLAPS FAIL AMBER CAS. FLAPS DID NOT MOVE AND REMAINED AT 20 DEGREES. NEAR FREEZING TEMPS ON RON. REMOVED FAULTY FLAP CONTROL UNIT. P/N: 600-93000-121, S/N: 431 INSTALLESDR HALA20251020323Skin · dentedETOPS - NR 2 ENGINE INLET DENT OUT OF LIMITS. REMOVED AND REPLACE NR 2 ENGINE INLET COWL PER AMM 71-61-10. RAN ENGINE PERFOM ANTI ICE LEAK CHECK PER AMM 30-31-00.LEAK CHECK OK OK ,NO DEFECT NOTED OK TO CONTINUE FOR SERVICE.SDR ASAA2025101761713Light · no discrepancyEMERGENCY LIGHTS ON WHEN EMERGENCY LIGHT SWITCH IN ARMED POSITION. GROUNDED - YES. C/W EMERGENCY LIGHT OPS CK+ NO DEFECTS NOTED REF AMM 33-51-00. SEAMC WILL NOTIFIED.SDR ASAA2025101761712Bulb · inoperativeINTERIOR EMERGENCY LIGHTS BULBS INOP ROW 16 A, B, C , AND NEAR LAV E. GROUNDED - YES. RELAMPED EMERGENCY LIGHTS AT ROW 16 ABC AND NEAR LAV E REF B737 AMM 33-51-01. OPS CHECK GOOD.SDR R61A2025101700474Strut · low pressureLG WOW SYS FAIL AFTER ROTATION. GEAR LEVER STUCK IN DOWN POSITION. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. FOUND NLG NITROGEN CHARGE LOW. PERFORMED FULL SERVICE OF NLG AND GEAR SWING ON JACKS.SDR SWI2025F01434Skin · dentedDURING REPLACEMENT OF APU INLET DOOR FRAME SUPPORT 5-OFF OVERSIZED HOLES AND DENT DAMAGE WERE FOUND BETWEEN FS654.50 - FS672.20 AT STR4L AFFECTING THE STACK UP OF STR4L, FS654.50 FRAME SECTOR, MTG FITTING AND CLIP (FILED OPEN)SDR SWI2025F01433Skin · damagedLIGHTNING SKRIKE DAMAGE TO STR 25R AFT OF FR 11 ON RH LOWER FWD FUSELAGE. (FILED OPEN)SDR SWIA2025102000017Hinge · damagedFOUND PAX DOOR HINGE (FUSELAGE SIDE) HAS SEVERAL LUGS WITH INNER SURFACE WEAR DAMAGE. (FILED CLOSED)COMPLIED WITH REO 670-53-21-2718 DATED: 2025-10-17 REV -- TEMPORARY DISPOSITION FOR WEAR DAMAGE TO PASSENGER DOOR HINGE LUGS (FUSELAGE SIDE). COMPLIED WITH TSDR DALA2025102007676Girt Bar · fodL3 DOOR WOULD NOT ARM. CLEANED DEBRIS FROM GIRT BAR. OPS GOOD. (7979254)SDR DALA2025102007674Elec Connector · looseROWS 51 AND 52 J/H E-PATH LIGHTS INOP. REPAIRED LOOSE CONNECTOR PER A330 AMM 33-51. OK FOR SERVICE. (7972212)SDR DALA2025102007663Proximity Sensor · faultedINTERMITTENT DOOR L AFT CABIN ON CLIMBOUT WITH MASTER CAUTION. R & R BOTH PROX SENSORS 23MJ/25MJ PER A330 AMM 52-71 AND ADJUSTED SENSOR CLEARANCES OPS CK GOOD. PSEU TEST PASSED NO CURRENT FAULTS. (1256974)SDR AALA202510209177Flap System · warning messageAIRCRAFT WAS GROUNDED: AFTER TAKEOFF WHEN RAISING THE FLAPS TO UP POSITION, F/CTL FLAPSFAULT CAUTION MESSAGE APPEARED. ECAM ACTIONS DID NOT RECTIFY SITUATION. AFTER TROUBLESHOOTING AND QRH PROCEDURES, IT WAS DETERMINED THAT FLAPS TWO AND THREE POSITIONS CLEASDR AALA202510201129Actuator · leakingAIRCRAFT WAS GROUNDED: D QTY LOW C APPEARS TO BE LOSING 0.01 PER 10 MINUTE INTERVALS. EMERGENCY DECLARED LANDED WITHOUT INCIDENT. MAINTENANCE REPLACED L/H GEAR TRUCK POSITION ACTUATOR IAW AMM 32-32-18.SDR AALA202510207218Union · leakingAIRCRAFT WAS GROUNDED: SOF EVENT, TO BE ACCOMPLISHED BEFORE FURTHER FLIGHT,DUE TO PIREP 1608215, POSSIBLE CABIN ODOR ON DESCENT AND TAXI IN". FOUND SOURCE OF ODOR CAUSED BY LEAKING SELECTOR VALVE 2576GM REF MIC # 1609035. MAINTENANCE REPLACED UPPER OUTBOARD LSDR AALA202510201415Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT 1L FA SEAT DAMAGED. MAINTENANCE REPLACED FLASHLIGHT IAW AMM 25-64-00.SDR AALA202510208096Sign · inoperativeAIRCRAFT WAS NOT GROUNDED: L2 DOOR OVERHEAD EXIT MARKER SIGN INOP. MAINTENANCE REPLACED OVERHEAD MARKER SIGN IAW AMM 33-51-02.SDR SWAA2025102025247Engine · fireTAIL PIPE FIRE ON SHUT DOWN OF NR 1 ENGINE. RAMP EXTINGUISHED WITH WATER. ACCOMPLISHED INSPECTION OF NR 1 ENG EXHAUST IAW EA-23-172-03308-ETOPS. OK FOR SERVICE.SDR SWAA2025102025456Autobrake Sys · no discrepancyAUTOBRAKES SET TO 3 FOR LANDING. BRAKES APPEARS NOT TO COMPLETELY DISENGAGE DURING LANDING ROLLOUT. ALL VISUAL SYSTEM INDICATIONS WERE NORMAL. SYSTEM APPEARED NORMAL AFTER CYCLEING PKG BRAKE. PERFORMED AACU BITE AND OPS CHECK REF AMM 32-42-00 AND PERFORMED ISDR SWAA2025102025305Handle · brokenL1 DOOR ASSIST HANDLE BROKEN. SWAPPED ASSIST HANDLE FROM FWD LAV TO L1 DOOR PER AMM 52-11-31. L1 DOOR ASSIST HANDLE OPS NORMAL. OK TO CONTINUE PER MEL 25-10-01. REPLACED FWD LAV EXIT ASSIST HANDLE AND HARDWARE AS REQ?D REF CMM 25-42-39.SDR SWAA2025102025156Floor Panel · crackedFWD CARGO COMPARTMENT AFT FIBERGLASS FLOOR PANEL HAS 3 SEPARATE CRACKS MEASURING 6.5'; 3.5 '; AND 5' LONG. REMOVED AND REPLACED FWD CARGO COMPARTMENT AFT FIBERGLASS FLOOR PANEL REF AMM 25-52-10 WITH FABRICATED PANEL REF AMM 25-52-01.SDR SWAA2025102025244Battery · inoperativeAFT LH OB EMERGENCY FLASHLIGHT INOP. R & R THE EMERGENCY FLASHLIGHT BATTERY PER AMM 25-64-00.SDR SWAA2025102025128Battery Pack · no testL/H AFT EMERGENCY LIGHTING BATTERY PACK FAILED THE CAPACITY CHECK. REMOVED AND REPLACED BATTERY PACK PER M/M 33-51-06SDR SWAA2025102025044Spring · brokenFA REPORT IN AFT GALLEY THE EMERGENCY EXIT LIGHT SWITCH SPRING IS BROKEN AND CUTS ON FINGERS WHEN WORK LIGHT SWITCH IS BEING USED. ADJUSTED SPRING ON SWITCH COVER REF SWPM 20-83-11SDR SWAA2025102025132Battery Pack · no testEMERGENCY EXIT LIGHT BATTERY PACK M1673 FAILED CAPACITY TEST. R&R EMERGENCY EXIT LIGHT BATTERY PACK M1673 IAW AMM 33-51-06.SDR SWAA2025102025191Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1673 FAILED CAPACITY TEST. R&R EMERGENCY LIGHT BATTERY PACK M1673 IAW AMM 33-51-06.SDR SWAA2025102025460Handle · unsecureCREW REPORTSL1 DOOR HANDLE UNSCREWED. SECURED HANDLE IAW SIP.OPS CHECKED GOODSDR SWAA2025102025454Sign · missingTHE EXIT SIGN MID CABIN OVERHEAD IS MISSING. INSTALLED MISSING MID CABIN OVERHEAD EXIT SIGN IN REFERENCE TO AMM 33-51-01SDR SWAA2025102025440Sign · detachedEMERGENCY EXIT SIGN DETACHED FROM CEILING. REATTACHED EMERGENCY SIGN PER SIP.SDR SWAA2025102025419Battery · inoperativeBOTH FWD FA FLASHLIGHTS WILL NOT TEST. RESET OB FLASHLIGHT IN HOLDER AND REPLACED BATTERIES ON IB FLASHLIGHT IN ACCORDANCE WITH AMM 25-64-00. OPERATIONAL CHECK IS SATISFACTORY AND NO DEFECTS NOTED.SDR SWAA2025102025302Battery · inoperativeAFT L/H FLIGHT ATTENDANT FLASHLIGHT NOT TESTING. R&R BATTERY PER AMM 25-64-00 OPS CHECK GOODSDR WX0A2025102032604Megaphone · no test(AIRCRAFT NOT GROUNDED) F.A.'S REPORT 1 MEGAPHONE DOES NOT TEST PROPERLY. / PERFORMED OPERATIONAL CHECK OF FWD FA MEGAPHONE PER AMM 25-65-51-710-002-A. OPS CHECK GOOD."SDR WX0A2025102032603Flashlight · inoperative(AIRCRAFT NOT GROUNDED) FWD FLIGHT ATTENDANT FLASHLIGHT RED DOES NOT WORK. / REPLACED BATTERY PER CMM 25-60-02 AT FWD F.A. FLASHLIGHT. OPS CHECK GOOD. "SDR DALA2025102007642Fitting · damagedRUDDER HINGE LINE BEARING BR4 A/C SIDE, LOWER FITTING HAS A GOUGE ON BOTTOM SIDE. COMPLIED WITH ER/A 629674-14. (1257741).SDR DALA2025102007641Fitting · damagedRUDDER HINGE LINE BEARING BR4 A/C SIDE TOP SIDE FITTING HAS DRILL START ON O/B SIDE OF #7 HOLE. COMPLIED WITH ER/A 629674-14. (1257738)SDR DALA2025102007640Plate · crackedSHIP 3124 RUDDER HINGE #3 BOTTOM PLATE HAS A CRACK INDICATION IN HOLE #7. CORRECTIVE ACTION: COMPLIED WITH ER/A 629756-14. (1257519).SDR GTIA2025102039137A/C Pack · odorSUSPECT FUME FROM AIR PACK ONE -PERFORMED TSM 05-50-00-810-831-A AND FOUND APU TO BE THE SOURCE OF THE ODOR EVENT. PERFORMED ENGINE RUNS WITH CREW USING HUFFER CART. PACK 1 AND PACK 2 CHECKS SATISFACTORY ON BOTH ENGINES; NO ODORS NOTED. A/C OK FOR SERVICE. MOCSDR AALA202510204563Locking Cam · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD ENTRY DOOR GIRT BAR VERY DIFFICULT TO DISARM. LUBRICATED FORWARD DOOR GIRT BAR FLOOR MOUNTS BRACKETS AND OPERATIONAL CHECKED GOOD. PER AMM 25-66-02.SDR AALA202510207779Sign · misinstalledAIRCRAFT WAS NOT GROUNDED: AFT ENTRY DOOR 2L EXIT SIGN ARROW POINTS IN WRONG DIRECTION. REMOVED AND REPLACE EXIT LIGHT COVER. PER AMM 33-51-01.SDR AALA202510203804Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT ROW EXIT SIGN FELL OFF. REINSTALLED FORWARD LEFT OVERWING EXIT SIGN. PER AMM 33-51-01.SDR AALA202510205297Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ABOVE OVERHEAD BIN AT ROW 17ABC IS FALLING OFF. RESECURED EMERGENCY LIGHT ABOVED 17ABC. PER AMM 33-50-00. OPERATIONAL CHECK GOOD.SDR AALA202510202150Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT GUIDE LIGHT ON SEAT 27C IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY ON SEAT 27C. PER AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA202510204795Light · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 13C EMERGENCY LIGHT ON BOTTOM OF THE SEAT BROKEN OFF. REATTACHED EMERGENCY LIGHT ON SEAT 13C. PER GPM 02-01-2B2.SDR DXTA2025102005352Pin · out of rigMAIN CABIN DOOR WILL RAISE INTO PLACE BUT THE HANDLE WILL NOT LOWER INTO THE NORMAL POSITION. ON OF THE PINS APPEARS TO NOT RETRACT FULLY. CORRECTED LOWER DOOR PIN/LINKAGE. OPS CHECK GOOD. IAW CE700 52-10-00SDR DXTA2025102005351Latch · out of rigREPEAT WRITE UP FROM 10/01. MAIN DOOR LATCH TAKES A LOT OF PRESSURE TO PUSH DOWN INTO LOCKED POSITION CORRECTIVE ACTION: PERFORMED CABIN DOOR STOP RIGGING. OPS CHECK GOOD. IAW CE680 AMM 52-10-00