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 SWAA2025071691156Flashlight · inoperativeCREW REPORTS AFT FO INBOARD FLASHLIGHT NOT TESTING. REPLACED FLASHLIGHT IAW AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025071691216Battery · inoperativeCOCKPIT FLASHLIGHT DOES NOT TEST. REPLACED FLASHLIGHT BATTERY IAW AMM 25-64-00.SDR SWAA2025071691115Flashlight · inoperativeFLIGHT DECK EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLIGHT DECK EMERGENCY FLASHLIGHT IN REFERENCE WITH AMM 25-64-00.SDR SWAA2025071691149Girt Bar · out of adjustFWD SERVICE DOOR GIRT BAR FALLS FROM STOWED POSITION WHEN DOOR IS OPEN. ADJUSTED AND RESECURED FWD SERVICE DOOR GIRT BAR IN REF TO AMM 25-66-01. NO DEFECTS NOTED.SDR SWAA2025071691140Bulb · burned outMASTER CAUTION BULB ON CAPTAINS SIDE BURNED OUT. NO SPARES. RELAMPED CA MASTER CAUTION REF. AMM.33-18-00.<BR>REPLENISHED SPARE BULB KIT PER SIP.SDR DALA2025071605340Door Frame · fodSHIP 676 FA DISARMED 1R DOOR AND SLIDE LIGHT REMAINED ILLUMINATED. CORRECTIVE ACTION: PERFORMED OPEN/CLOSE PASSENGER DOOR - INTERNAL HANDLE ON 1R IAW B757 AMM 52-11 & REMOVED UNWANTED MATERIAL FROM THE DOORWAY, OPS CK GOOD ON SLIDE LIGHT. (5694134)SDR DALA2025071605339Cover · looseSHIP 6807 DOOR 1R WILL NOT ARM DURING PRE DEPARTURE CHECK. CORRECTIVE ACTION: FOUND GRIT BAR COVER LOOSE. REATTACHED & SECURED GRIT BAR COVER. OPS CHK GOOD PER B757 AMM 52-12. (6794428)SDR DALA2025071605337Girt Bar · unsecureSHIP 6710 DOOR 3L WILL NOT ARM SLIDE LIGHT DOES NOT ILLUMINATE. CORRECTIVE ACTION: RESECURED GIRT BAR ENGAGEMENT AND OPS CHECK GOOD PER B757 AMM 52-11. (7281950)SDR DXTA2025071604250Battery Pack · faultedOVERWING AND FLOOR LIGHT AT SEAT 5 WILL NOT ILLUMINATE WITH EMERGENCY POWER SELECTED ON. BATTERIES WERE SUFFICIENTLY CHARGED. LIGHTS ILLUMINATE WITH MAIN BATTERY POWER AND EMER POWER ON. REMOVED #3 EMERGENCY BATTERY AND INSTALLED A REPAIRED EMERGENCY BATTERY OSDR DXTA2025071604254Window Frame · crackedTHERE APPEARS TO BE A CRACK IN THE LOWER PORTION OF THE AFT EMERGENCY EXIT HATCH WINDOW. AFTER INSPECTION FOUND OUTER FROST PAIN TO BE SCRATCHED. REMOVED PANE AND REPLACED WITH CUSTOMER PROVIDED OUTER FROST PANE PER 680A AMM 5-20-20SDR DXTA2025071604255G Switch · trippedEMERGENCY LIGHTS REMAIN ON AFTER SHUTDOWN. RESET 5G SWITCH PER ORH AND LIGHTS REMAIN ON GAINED ACCESS TO ALL 4 G-SWITCHES, RESET ALL, LIGHTS EXTINGUISH ALL WORK IN REF TO CE-700AMM 33-50-00.SDR HALA20250715216Transceiver · faultedETOPS - PRED W/S DET FAULT #1 SIDE. REMOVED AND REPLACED WXR #1 RTU XCVR OER AMM 34-41-51. BITE TEST GOOD. OK FOR SVCSDR HALA20250715214Fuel Control · faultedETOPS - APU AUTO SHUTDOWN @ 80%. REMOVED & REPLACED APU FUEL CONT UNIT IAW AMM 49-32-51-000/400-801A. BLEED/LEAK /OPS CHECK GOOD. OK FOR SVCSDR HALA20250715213Fmu · faultedETOPS - #1 ENGINE LEAKING FUEL OUT THE DRAIN MAST. PER TSM 71-00-00-810-914-A REMOVED AND REPLACED FMU PER AMM 73-21-52. PERFORMED 4 ENGINE RUNS. NO LEAKS NOTED. OPS CHECK NORMAL. A/C OK FOR SERVICE.SDR HALA20250715212Wire Harness · faultedETOPS - ON CLIMB OUT MOMENTERY ECAM FOR ENG 1 LOOP B FAULT MESSAGE CLEAR ON ITS OWN AFTER A FEW MINUTES. REMOVED AND REPLACED ENGINE 1 HARNESS 4166KS PER AMM 26-12-62 AND REPLACED ENGINE 1 CORE AGB LOOP B FIN 4002WD2 PER AMM 26-12-17 OPS CHECK OKSDR HEEA202507160001Unknown · noiseWHILE CLIMBING THROUGH APPROXIMATELY 300 TO 400 FEET AGL, A LOUD BANG WAS OBSERVED, COINCIDING WITH A BRIEF UNCOMMANDED YAW TO THE LEFT.SDR AALA202507166580Unknown · odorAIRCRAFT WAS GROUNDED: STRONG SMELL ON TAKEOFF ROLL, SIMILAR TO DIRTY SOCKS. NOTICABLE AT 40% N1, BECAME WORSE AS WE INCREASED THRUST. (OPEN).SDR AALA202507162470Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK VERY DIFFICULT TO LOCK AND UNLOCK. LUBRICATED LEFT HAND AFT LAVATORY DOOR. OPERATIONAL CHECK NORMAL.SDR AALA202507161247Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #1 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202507165297Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #3 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202507163674Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #2 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR AALA202507164101Hinge Arm · excess playAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER ELEVATOR #4 HINGE ARM HAS EXCESSIVE PLAY. REPLACED HINGE ARM PER AMM 55-16-42.SDR JJBA20250716056Window Frame · crackedLOWER SIDE WINDOW CUT-OUT AREA, RH FR10 ANGLE FOUND CRACKED. AT LOWER SIDE WINDOW CUT-OUT AREA, RH FR10 ANGLE REMOVED AND REPLACED.SDR CALA2025071606630Lamp · inoperativeEMERGENCY LIGHTING SYSTEM OPERATIONAL CHECK. EMERGENCY LIGHT INOPERATIVE AT EXTERIOR OF L1 DOOR . RELAMPED L1 DOOR SLIDE EMERGENCY LIGHT IAW AMM 33-51-04-960-801. OPS NORMAL, OK TO CONTINUE.SDR CALA2025071606628Power Supply · no testEMERGENCY LIGHTING SYSTEM OPS CHECK , ROW 1-5 EMERGENCY EXIT AISLE LIGHTS INOPERATIVE. R & R POWER SUPPLY M2816 IAW AMM 33-51-06-960-806. OPS CHECKED GOOD.SDR CALA2025071606627Light · damagedSEAT 9D FLOOR EMERGENCY LIGHT IS LOOSE, FOUND LIGHT COVER MISSING, FOUND FWD EMERGENCY LIGHT NOT ILLUMINATED APPLIED MEL 3351V FOR BASE ACTION 3351V APPROVED, APPLIED PLACARD DM IAW DWG 2500DD15846. REMOVED AND REPLACED SEAT 9 D EMERGENCY FLOOR LIGHT IAW 33SDR CALA2025071606624Counter · contaminatedAT DEPARTURE FLIGHT ATTENDANTS REPORT BURNING ODOR THROUGHOUT CABIN. MX TO COMPLETE TSM 05-50-00-810-831-A RAN BOTH PACKS 1 AND 2 FOR 40 MINUTES NO BURNING SMELL THROUGHOUT CABIN AT THIS TIME. FOUND POSSIBLE BURNING SMELL IN THE AFT GALLEY WHILE OPERATING ASDR CALA2025071606623Heat Exchanger · faultedLEFT PACK INOP DUE TO CONSTANT PACK TRIP AND SMOKE SMELL ON APPROACH SUSPECT ACM FAILURE. THIS SECOND DEF IS IN ACCORDANCE WITH LOG PAGE 5556666 WITH INOP TCV FAILURE ALSO WITH ITEM 21450 MEL2133D. REPLACED LEFT PACK TCV VALVE DUE TO BITE CK FAULT FOR TCV ON ZSDR CALA2025071606617Flashlight · inoperativeFLIGHT DECK FLASHLIGHT INOPERATIVE. REPLACED THE FLASHLIGHT, OPS CHECKED NORMAL.SDR CALA2025071606616Floorbeam · corrodedMAIN CABIN, BS 344, BL 0 - LBL 12 FLOORBEAM CORRODED ON UPPER SURFACE. ACCOMPLISHED PERMANENT REPAIR IAW G25507 STAGE 5, REO-G25507 REV IR, AND ECRA 5310-08638, CATEGORY A REPAIR.SDR AALA202507157128Adiru · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AFTER TAKE OFF APPROX 5000FT BOTH CAPTAIN AND FIRST OFFICER PFD GOT PITCH AMBER FLAG AND THEN ROLL FLAG, AND SCRATCH PAD MESSAGE THE IRS DISAGREE FOLLOWED BY LEFT IRS FAULT LIGHT. CAPTAINS PFD WAS UNRELISDR AALA202507152645Unknown · odorAIRCRAFT WAS NOT GROUNDED: A REPORTED MILD TO MODERATE TRANSIENT ODOR THAT SMELT LIKE A DIRTY SOCK IN A LOCKER ROOM, DURING DESCENT APPROXIMATELY 5 TO 10 MINUTES. (OPEN).SDR SWIA2025071500014Light · burnedSMALL AMOUNT OF SMOKE EMITTED FROM OUTBOARD READING LIGHT AT SEAT 3A DURING DESCENT. FA REPORTS SMOKE WAS LIGHT GRAY AND SMELLED LIKE BURNING PLASTIC. (FLIGHT 3697) TROUBLESHOT SMOKE AND ABNORMAL SMELL IN PASSENGER CABIN PER CRJ 900 FIM 21-22-00. NO SMOKE OSDR DALA2025071505335Switch · faultedSHIP 0190 RECEIVED RT OIL PRESSURE LIGHT AND EICAS. R & R SWITCH S1584 RT OIL PRESSURE INSPECT CONNECTOR PLUG AND WIRING IAW B767-300 IPC 79-33-01-07. (1081099).SDR AALA202507155839Connector · looseAIRCRAFT IN BASE MAINTENANCE: MAINTENANCE FOUND EMERGENCY POWER SUPPLY BATTERY ELECTRICAL CONNECTOR 7260VC13 LOOSE, SECURED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM PER AMM 33-51-00.SDR AALA202507156817Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT DISPLAY PANEL INDICATES A CAUTION TO CHECK DOOR PRESSURE 1L. MAINTENANCE SERVICED L1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202507153952Duct · rupturedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO SFO DUE TO THE FLIGHT CREW REPORTING THAT A VENT SKIN VALVE FAULT CAME ON AFTER TAKEOFF. THE FLIGHT CREW APPLIED ECAM PROCEDURES AND WAS UNABLE TO MAINTAIN CABIN PRESSURE ALTITUDE VISDR AALA202507152822Lanyard · out of positionAIRCRAFT WAS NOT GROUNDED: ROPE HANGING FROM FORWARD SERVICE DOOR WHILE DOOR IS OPEN. MAINTENANCE RESTOWED R1 DOOR SLIDE ROPE / LANYARD PER CMM 25-61-20.SDR AALA202507155859Connector · looseAIRCRAFT IN BASE MAINTENANCE: MAINTENANCE FOUND EMERGENCY POWER SUPPLY BATTERY ELECTRICAL CONNECTOR 7260VC8 LOOSE, SECURED CONNECTOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK OF THE EMERGENCY LIGHTING SYSTEM PER AMM 33-51-00.SDR AALA202507153968Handle · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK LEFT HAND SLIDING WINDOW HANDLE CRACKED. REPLACED HANDLE PER CMM 56-12-12.SDR AALA202507153820Handle · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK RIGHT HAND SLIDING WINDOW HANDLE CRACKED. REPLACED HANDLE PER CMM 56-12-12.SDR DALA2025071505317Idg · damagedSHIP 3269 - DIV - TO AUS DUE APU ON MEL AND #2 IDG OIL TEMPERATURE ABOVE 147 DEGREES. CORRECTIVE ACTION: REPLACEMENT OF IDG #2 IN PROGRESS. (LP: 7809135)SDR DALA2025071505326Flap System · faultedSHIP 5008 - MISC - DECLARED EMERGENCY AND PERFORMED GO-AROUND DUE TO A FLAPS SYS 1 FAULT DURING THE APPROACH. CORRECTIVE ACTION: REPLACED SFCC 1. (LP 7558796)SDR DALA2025071505315Warning Message · illuminatedSHIP 3128 ECAM DR PAGE IND - PASSENGER DRS / CABIN EMERG EXIT - OPEN IND. CORRECTIVE ACTION: VERIFIED DOOR CLOSED ON ECAM PAGE. ONLY SHOWED FAULT ONCE IN SKYWISE AND NO 30 DAY HISTORY. (7281722).SDR DALA2025071505312Frame · crackedSHIP 3130 CRACK INDICATIONS FOUND IN HOLES #6 AND #C OF FR16 LHS DBL JGL AREA. CORRECTIVE ACTION: REPAIRED PER ER/A 626760-14AD. (1083055)SDR DALA2025071505311Window Frame · crackedSHIP 3130 CRACK INDICATION WAS FOUND AT LWR RADIUS OF RH WINDSHIELD CTR NODE IN THE LOWER RADIUS. CORRECTIVE ACTION: COMPLIED WITH ER/A 626818-14AD. (1082255).SDR DALA2025071505310Window Frame · crackedSHIP 3130 CRACK INDICATION WAS FOUND AT LWR RADIUS OF RH WINDSHIELD CTR NODE IN THE LOWER RADIUS. CORRECTIVE ACTION: COMPLIED WITH ER/A 626818-14AD. (1082250).SDR DALA2025071505309Window Frame · crackedSHIP 3130 CRACK INDICATION WAS FOUND AT LWR RADIUS OF RH WINDSHIELD CTR NODE IN THE LOWER RADIUS. CORRECTIVE ACTION: COMPLIED WITH ER/A 626727-14AD. (1081877).SDR DALA2025071505308Windshield · crackedSHIP 3130 CRACK INDICATION WAS FOUND AT LWR RADIUS OF RH WINDSHIELD CTR NODE IN THE LOWER RADIUS. CORRECTIVE ACTION: COMPLIED WITH ER/A 626727-14AD. (1081867).SDR DALA2025071505307Floor Support · corrodedSHIP 3146 AFT FUSELAGE PASSENGER CABIN FLOOR STRUCTURE AREA BETWEEN FR67+ 340MM AND FR68 AT Y1243. AFT PASSENGER DOOR SILL BEAM WITH CORROSION. CORRECTIVE ACTION: PERFORMED PERMANENT CATEGORY A REPAIR AT AFT FUSELAGE PASSENGER CABIN FLOOR STRUCTURE SILL BEAM S