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 AALA202509084182Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R1 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA202509082286Bottle · low pressureAIRCRAFT IN BASE MAINTENANCE: R4 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR DALA2025090806623Battery · inoperativeBATTERY CHARGER FAIL MSG ANNUNCIATED SHORTLY AFTER TAKEOFF IN ATL IT CLEARED IN FLIGHT DURING PRE FLIGHT FOR RETURN LEG IT RE OCCURED CB WAS RESET AT MTC DIRECTION THERE WAS NO CHANGE THEN SMOKE WAS SEEN COMING FROM E AND E COMPARTMENT. REMOVED AND REPLACED SDR CALA2025090808565Stringer · corrodedAFT CARGO BILGE AREA BETWEEN FR 63 & 64 STRINGER 41R HAS CORROSI ON. REMOVED AND REPLACED STRINGER 41R FR59-61 IAW SRM 51-72-11.SDR AALA202509055050Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND AFT OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED LEFT HAND AFT OVERWING EXIT DOOR, AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509056807Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED RIGHT HAND FORWARD OVERWING EXIT AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509055193Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED RIGHT HAND AFT OVERWING EXIT AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509053749Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EXIT DOOR, AFT UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED LEFT HAND FORWARD OVERWING EXIT DOOR, AFT UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509056177Stop Pad · out of positionAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND FORWARD OVERWING EXIT DOOR, FORWARD UPPER STOP PAD ROTATED OUT OF POSITION. ROTATED RIGHT HAND FORWARD OVERWING EXIT FORWARD UPPER STOP PAD TO PROPER POSITION. PER AMM 52-22-00-820-801.SDR AALA202509054382Light · burned outAIRCRAFT WAS NOT GROUNDED: CEILING MOUNTED EMERGENCY EXIT LIGHT AT SEAT ROW 36 BURNED OUT. REPLACED EMERGENCY EXIT LIGHT AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-11.SDR SWAA2025090410166Battery · inoperativeEMERGENCY FLASHLIGHT IN AFT GALLEY CAPTS SIDE INOPERATIVE. REMOVED AND REPLACED EMERGENCY FLASHLIGHT AFT GALLEY CA SIDE #2 BATTERY IAW AMM 25-64-00. OPS CHECK GOOD.SDR SWAA2025090410151Battery · faultedFWD OUTBOARD EMERGENCY FLASHLIGHT FLASHING RED. REMOVED AND REPLACED BATTERY AND SEAL I/A/W AMM 25-64-00.SDR SWAA2025090410163Slide · dislodgedRIGHT AFT SERVICE DOOR SLIDE HANGING OUT OF CONTAINER. REPACKED AFT SERVICE DOOR SLIDE PER MT 725-61-06. A/C OK FOR SERVICE.SDR SWAA2025090410147Slide · dislodgedRAMP REPORTS L1 DOOR SLIDE FELL OUT OF BUSTLE. REINSTALLED ESCAPE SLIDE PER AMM 25-66-01 AND MT 725-61-06 REM/INSTL.SDR SWAA2025090410159Lamp · inoperativeLEFT OVER WING EXIT SIDEWALL LIGHT INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-04.SDR DALA2025090406562None · noneER/A 628630-14AD REV ORIGINAL REQUIRES SECTION II FOLLOW-ON INSPECTIONS FOR CONTINUED AIRCRAFT AIRWORTHINESS. UPDATE TERMINATING RESTRICTION IN TIME RESTRICTION BLOCK TO MATCH REQUIREMENT IN ER/A 628630-14AD REV ORIGINAL. (1174878)SDR AALA202509048097Elec Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: SEAT 2AB EMERGENCY LIGHT INOPERATIVE. TROUBLESHOOTED ROW 2AB EMERGENCY LIGHTS, FOUND SWAPED CONNECTORS J1, J2, J3 AND J4 INSIDE THE SEAT. RECONNECTED ALL CONNECTORS, PER B737NG SWPM 20-61-28, PERFORMED SATISFACTORY OPERATIONAL CHESDR 3EJA202509040024Grommet · failedSECONDARY DOOR SEAL FAILURE. PERFORMED OPERATIONAL CHECK OF PNEUMATIC CABIN ENTRY DOOR SEAL INFLATION CYCLE, OBSERVING CAUTION TO PREVENT FULL SEAL INFLATION TO AVOID GROMMET BLOW OFF)
UTILIZED TROUBLESHOOTING CHART (REF: MM 36-11:00, FIG. 101) TO ISOLATE THESDR DXTA202509040772Power Supply · defectiveTHE EMER LIGHTS STAY ON IN THE ARM POSITION : REMOVED CREW SEATS, REMOVED #1 E-LIGHT POWER UNIT PN 7450LS-00 SN 001058M AND INSTALLED A TESTED UNIT IAW MM 33-52-01-400. REMOVED LAV ACCESS PANEL 242AZ, REMOVED NR 2 E-LIGHT POWER UNIT AND INSTALLED A REPAIRED UNSDR SWAA2025090310096Battery Pack · inoperativeR1 EMERGENCY LIGHTS INOP. R&R R1 EMERGENCY BATTERY PACK. REF AMM 33-51-06. OPS CHECK GOOD.SDR SWAA2025090310141Battery Pack · inoperativeTHREE EMERGENCY LIGHTS AROUND FWD L1 DOOR INOPERATIVE. REPLACED BATTERY PACK AT M1675 POSITION. OPS CHECK GOOD. WORK DONE IAW AMM 33-51-06.SDR AALA202509039070Oil System · leakingAIRCRAFT WAS GROUNDED: UPON SOF TROUBLESHOOTING PER J/C 26L000021001. FOUND APU TO BE THE CAUSE OF THE ODOR. LEAKING FROM DRAIN MAST. MAINTENANCE REPLACED APU IAW J/C 26L31049003.SDR AALA202509036435Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK INDICATION FOUND ON FASTENER HOLE OF CORNER FITTING LOCATED AT PRESSURE DECK MEMBRANE TO CENTER WING BOX AREA, ON FR36 AND -Y1292 PLUS 3 INCHES TO OUTBOARD, RH SIDE. LOWER FUSELAGE. CRACK DIRECTION IS: 9 OCLOCK. CRACK DEPTH SDR DXTA2025090304772Light · malfunctionedTHE EMER LIGHTS STAY ON IN THE ARM POSITIONSDR DXTA2025090304776Door · faultedAS PASSENGER WAS DESCENDING DOWN THE MAIN STEPS THE PASSENGER DOOR MADE A VERY LOUD POP AND DROPPED ABOUT 1-2 INCHES. WHEN YOU STEP ON THE STAIRS THEY SAG/DROP AND THE PART OF THE STAIRS FUSELAGE NEAR THE PLANE (UNDERNEATH THE TOP OF THE STAIRS) MOVES UP AND HSDR DXTA2025090304778Latch · faultedTHE LATCH WILL NOT ENGAGE ON THE MAIN CABIN DOOR FROM THE INSIDE OR THE OUTSIDE. THE DOOR IS CURRENTLY OPEN. ARRIVED AT AIRCRAFT AND CONFIRMED PILOT WRITE UP MAIN CABIN DOOR WILL NOT LATCH. TECH ATTEMPTED TO MOVE THE INTERIOR DOOR HANDLE TO FIND THE DOOR LATSDR DALA2025090306535Elec Connector · misinstalledFOUND 41DEF OVERHEAD EMERGENCY LIGHT INOP. R/R HOUSING ASSY PER B757 AMM 32-51. UPON LOCATING BATT PACK M736 & M737 FOUND CONNECTORS INSTALLED INVERSELY. SWAPPED CONNECTORS TO CORRECT CONFIG. FAULT NOW LOCATED AC LEFT SIDE @ SEATS 40 ABC TO AFT. 41DEF NML. RSDR CALA2025090308441Gearbox · contaminatedNUMBER 1 ENG OIL FILTER BYPASS OCCURED ATFL270 300KIAS, DELCARED EMERGENCY LANDING. DURING INSPECTION, FOUND DEBRIS ON AGB/TGB SCAVENGE MCD. EXAMINED STARTER MAGNETIC PLUG CONTAMINATION REF AMM TASK 79-00-00-200-804-F00. NO PARTICLES FOUND.SDR CALA2025090308429None · noneINSTALLED SAFETY PINS AT DR 1R ESCAPE SLIDE PACK FOR OPS CK REF. AMM 52-11-20-700-803-002. REMOVED AND STOWED SAFETY PIN AT DR 1R ESCAPE SLIDE PACK REF. AMM 52-11-20-700-803-002. VERIFIED SAFETY PIN REMOVED AT DR 1R ESCAPE SLIDE PACK REF. AMM 52-11-20-700-803-SDR CALA2025090308428Plug · deterioratedLEFT MLG DOOR AFT PROX SENSOR SWITCH (35GA)HAS DETERIORATED PLUG RUBBER. REPLACED LT MLG AFT PROX SENSOR SWITCH (35GA) AND ADJUSTED GAP REF AMM 32-12-11-820-059-A UP TO STEP 3K(G). . MLG DOOR OPERATIONAL CHECK WILL BE ACCOMPLISHED ON LOG ITEM 606683.SDR CALA2025090308427Girt Bar · fodAFT DOOR 4L WONT ARM, FOUND DEBRIS AROUND GIRT BAR AREA, CLEARED DEBRIS FROM AREA. DOOR 4L ARMS AND DISARMS NORMALLY OK TO CONTINUE.SDR CALA2025090308426Girt Bar · no discrepancyDOOR 1R GIRT BAR JAMMED IN THE BRACKETS. FOUND NO DISCREPANCIES WITH THE GIRT BAR, IT WAS WRONGLY STOWED. OPERATES NORMAL.SDR CALA2025090308425Bottle · no discrepancyBOTH FWD MCD SLIDE PRESSURES INDICATE LOW PERFORMED ESCAPE SLIDE PACK INFLATION CYLINDER CHECK IAW AMM TASK 25-66-01-200-801. FOUND MEASUREMENTS WITHIN THE ALLOWABLE RANGE ACCORDING TO THE SURROUNDING OAT. CREW MEMBERS WERE BRIEFED ON THE TOPIC.SDR CALA2025090308424None · noneL AFT #4 ENTRY DOOR SLIDE PACK SAFTEY DISARMED PIN INSTALLED REMOVED AND STOWED L4 DOOR SLIDE PACK SAFETY PIN REF AMM 25-66-01/401 C/W IDT FOR SLIDE INSTALLATION AND SAFETY PIN REMOVED AND STOWED 4L.SDR CALA2025090308423None · noneL4 ENTRY DOOR SLIDE PACK BUSTLE REMOVED INSTALLED DOOR 4L SLIDE BUSTLE REF AMM 52-11-02-904-004SDR AALA202509039423Light · inoperativeAIRCRAFT WAS NOT GROUNDED: CEILING MOUNTED EMERGENCY EXIT LIGHT AT SEAT ROW 36 BURNED OUT. (OPEN)SDR DALA2025090306529Pressure Switch · faultedATO - AT LOW SPEED DUE TO A COND TRIM AIR FAULT. DEFERRED TRIM AIR PRV PER MEL AND CONTINUED. LATER, REPLACED TRIM PRESSURE SWITCH 26HK. (LP 1174517)SDR ABXA20250831211Control Panel · damagedDURING SERVICE CHECK FOUND UNARMED INDICATION OVERHEAD EMER LIGHTS/CREW OXY PANEL HAS BROKEN KORRY SWITCH R/R OVERHEAD EMERGENCY LIGHTS /CREW OXY PANEL IAW B767 AMM 33-51-08. OPS CHECK GOOD RETURNED TO SERVICE.SDR I5PA2025083119302Transceiver · faultyRIGHT HF INOPERATIVE. R & R RT HF TRANSCEIVER IAW AMM, OPS CHECK NORMAL.SDR I5PA2025083168804Transmitter · faultyAPU OIL QTY STATUS MSG. R & R APU OIL QTY TRANSMITTER PER AMM, OPS CHECK NORMAL.SDR DALA2025090206522Bottle · low pressureR2 DOOR EMERGENCY OPERATING CYLINDER PRESSURE LOW. SERVICED EMERGENCY OPERATING CYLINDER AS REQUIRED IAW AMM 52-10. (LP: 7875736)SDR DALA2025090206521Bottle · low pressureDURING SERVICE FOUND L1 & R1 DOOR ASSIST PRESSURES LOW. SERVICED L1 & R1 DOOR ASSIST PRESSURE IAW AMM 52-10. (LP: 7741961)SDR ASAA2025083160464Lens · detachedFA REPORTS LENS FOR EMERGENCY EXIT SIGN, FLOOR LEVEL 16F HAS SEPARATED FROM AIRCRAFT. GROUNDED - YES. REPLACED EMERGENCY EXIT COVER AT SEAT 16F. EMERGENCY LIGHT OPS CHECK GOOD IAW AMM 33-51-01 & 33-51-00.SDR SWI2025F01127Fadec · faultedINFLIGHT GOT A R FADAC FAULT 1 STATUS MESSAGE, THEN IT CHANGED TO A R FADEC CAUTION MESSAGE. (FLIGHT 3719) REMOVED AND REPLACED THE RH ENGINE FADEC IAW AMM CRJ 900 73-21-01. OPS CHECK GOOD AT THIS TIME. NO MESSAGES PRESENT. AC OK FOR CONTINUED SERVICE.SDR SWI2025F01126Fan · odorPILOTS INBOUND SAID THEY STILL SMELLED A BURNING PLASTIC SMELL IN FLIGHT AND THE ODOR GAVE THE FO A HEADACHE. (FLIGHT 4736) T/S IN REF WITH ERJ 175 FIM 21-20-00 STARTING ON PAGE 9-BLOCK 1, WITH APU AND ENGINES 1 & 2 RUNNING UNLATCHED BLEED APU TO ENSURE PACKSDR SWIA2025090200831Unknown · odorSTRONG SMELL OF BURNT PLASTIC IN THE FLIGHT DECK. THE SMELL WAS OVERWHELMING WHEN THE RECIRCULATION FAN WAS TURNED ON. TROUBLESHOT TO RECIRC FAN 1. STRONG SMELL OF BURNT PLASTIC IN THE FLIGHT DECK. SMELL OVERWHELMING WHEN THE RECIRCULATION FAN TURNED ON (SDR SWAA2025090210162Eec · faultedLEFT ENGINE UNRESPONSIVE AT ALTITUDE. PERFORMED BITE CHECK OF#1 EEC AND NO FAULTS CURRENT OR IN HISTORY NOTED BUT NO CHANNEL B ON GROUND TEST. REMOVED AND REPLACED #1 EEC REF AMM73-21-60. ALSO FOLLOWED FIM 73-21 801 FOR EEC DATA NOT AVAILABLE. ALL TESTS PASSDR GTIA2025090239060A/C Pack · odorFUME EVENT DURING DESCENT @ 11000 DIRTY SOCKS SMELL PACK 1 SHUT OFF PER FLAME PROCEDURE . ODOR WENT OFF -PER TSM FIG 05-50-00-991-01200-00-A DECISION TABLE , PERFORMED INSPECTION OF THE APU EXHAUST IAW AMM 49-00-00-200-811- LEVEL B/C. NO SIGN OF OIL LEAKAGE .SDR AALA202509022700Bottle · low pressureAIRCRAFT WAS NOT GROUNDED: FOUND L2 AFT DOOR PRESSURE TO BE BELOW LIMITS PER RON PS CHK AT450-500 PSI. MAINTENANCE SERVICED L2 DOOR IAW AMM 52-13-00.SDR AALA202509020047Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING J/C 78T21033001, FOUND EMERGENCY LIGHT ASSY INOP AT SEAT 20D. MAINTENANCE REPLACED 17D FLOOR PROXIMITY LIGHT ASSY IAW AMM 31-51-06.