Boeing 737-823
Service difficulty reports · 31,890
Newest first. 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' WHERE aircraft_model_key = '737823' 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' WHERE aircraft_model_key = '737823' 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 AALA202406274112Drain Valve · cloggedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ORDER FUME IN AFT OF PLANE, WORSE IN AFT GALLEY OILY MUSTY SMELL THAT MADE EYES WATER. COULD NOT DETERMINE SOURCE; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ELP. ACCOMPLISHED SOF TROUBLESHOOTING WORKCARDSDR AALA202406272465Battery Pack · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE AT ROW 26DEF THROUGH 34DEF. REMOVED AND REPLACED POWER SUPPLY BATTERY PACK M1672. PER AMM 33-51-06.SDR AALA202406275884Floorbeam · crackedAIRCARF IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY PANEL AT STA 540, FROM RBL 0 TO RBL 25. REPLACED BREAK ASSEMBLY PANEL PER AARD 51-00-05-1.SDR AALA202407180317Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663, RBL 36. REPAIRED CRACK PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202407024506Wire Harness · overheatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE OVER TEMP AT ABOUT V1 TEMPERATURE REACHED AROUND 970-990 DEGREES; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CVG. REMOVED AND REPLACED J9 (AALA202406254506) HARNESS AND J10 (ASDR AALA202407025825Wire Harness · overheatedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE OVER TEMP AT ABOUT V1 TEMPERATURE REACHED AROUND 970-990 DEGREES; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CVG. REMOVED AND REPLACED J9 (AALA202406254506) HARNESS AND J10 (SDR AALA202406254506Engine · overtempAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 1 ENGINE OVER TEMP AT ABOUT V1 TEMPERATURE REACHED AROUND 970-990 DEGREES; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT CVG. (OPEN).SDR AALA202406250431Slide · looseAIRCRAFT WAS GROUNDED: L1 DOOR SLIDE CONTAINER LOOSE. REMOVED AND REPLACED L1 SLIDE ASSEMBLY. PER AMM 25-66-01.SDR AALA202406255777Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. REPLACED BATTERIES IN MEGA PHONE. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202406250065Pin · dislodgedAIRCRAFT WAS GROUNDED: AFTER AFT LEFT SLIDE IS DISARMED, CLEANING CREW OPENED DOOR AND A PIN APPEARED WITH A RED FLAG ATTACHED FELL PART OF THE WAY OUT OFTHE SLIDE HOLDER. REINSTALLED SLIDE DISARM PIN IN SLIDE POUCH, OPERTIONAL CHECK GOOD. PER AMM 25-66-01 ANDSDR AALA202406250617Tube · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS FORWARD SERVICE DOOR RED TUBING MISSING ON GIRT BAR. INSTALLED TUBING ON RIGHT SIDE OF GIRT BAR. PER EO-2523J012.SDR AALA202406254893Lock · out of adjustAIRCRAFT WAS GROUNDED: GATE AGENT REPORTS AIRCRAFT ENTRY DOOR IS VERY DIFFICULT TO OPEN FROM OUTSIDE. CHECKED ADJUSTMENT OF SECOND FROM LOWER DOOR STOP PIN AND INSTALLED LOCK CLIP, PER AMM 52-11-00. CHECKS GOOD.SDR AALA202406258559Sliding Window · out of adjustAIRCRAFT WAS NOT GROUNDED: CAPTAINS SLIDING WINDOW RELEASE HANDLE STUCK IN FULL AFT POSITION. ADJUSTED NUMBER 2 CAPTAINS OPENABLE WINDOW RELEASE LATCH. OPERTIONAL CHECK GOOD. PER MM 56-12-11.SDR AALA202407053258Tie Down · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR FLOOR MOUNTED GIRT BAR AFT TIEDOWN FITTING AT BS 344, LBL 62. REPLACED TIEDOWN PER AARD 51-00-05-R1.SDR AALA202407034204Floor Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR PANEL FORWARD OF THE G1 GALLEY OUTBOARD FORWARD MOUNT AT STA 294.5, RBL 60. REPLACED FLOOR PANEL PER AARD 51-00-05-1.SDR AALA202406255388Tire · failedAIRCRAFT WAS GROUNDED: RIGHT OUTBOARD TIRE BLEW WHILE EXITING RUNWAY. CAPTAIN FELT RESISTANCE AT TAXI SPEED AS IF BRAKES WERE APPLIED ON THE RIGHT SIDE. A FEW SECONDS LATER THERE WAS A POP THAT WAS THOUGHT TO BE THE ANTI-SKID RELEASING. PILOTS COMMENTED THAT ISDR AALA202406252909Brake Assy · seizedAIRCRAFT WAS GROUNDED: RIGHT OUTBOARD TIRE BLEW WHILE EXITING RUNWAY. CAPTAIN FELT RESISTANCE AT TAXI SPEED AS IF BRAKES WERE APPLIED ON THE RIGHT SIDE. A FEW SECONDS LATER THERE WAS A POP THAT WAS THOUGHT TO BE THE ANTI-SKID RELEASING. PILOTS COMMENTED THAT ISDR AALA202406254157Tube · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT FRONT SERVICE DOOR GIRT BAR IS MISSING RED HEATSHRINK COLLAR. **SUPPLEMENTAL REPORT FOR (AALA202406244157): REPLACED HEAT SHRINK. PER AARD 25-66-00-4**(CLOSED).SDR AALA202406253517Toilet · leakingAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORT AN ODER FROM AFT GALLEY DURING TAKEOFF AND CLIMB. ODER AFFECTED NOSE AND THROAT AND REQUIRED MOVING AFT ROW PASSENGERS FORWARD.**SUPPLEMENTAL REPORT FOR (AALA202406243517): FOUND TOILET LEAKING, REMOVED AND REPLACSDR AALA202406241419Door · jammedAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR JAMS IN FLIGHT. LUBRICATED LAVATOR-D DOOR SLIDE AND OPERTIONAL CHECK NORMAL. PER AMM 25-45-19.SDR AALA202406243517Unknown · odorAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORT AN ODOR FROM AFT GALLEY DURING TAKEOFF AND CLIMB. ODOR AFFECTED NOSE AND THROAT AND REQUIRED MOVING AFT ROW PASSENGERS FORWARD. (OPEN).SDR AALA202406244157Collar · missingAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORT THAT FRONT SERVICE DOOR GIRT BAR IS MISSING RED HEATSHRINK COLLAR. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406243675Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS HARD TO OPEN AND IS CONTINUOUSLY GETTING STUCK. LUBRICATED DOOR HINGES. DOOR OPENS AND CLOSES SMOOTHLY. PER CMM 25-40-64.SDR AALA202406250795Transducer · faultyAIRCRAFT WAS NOT GROUNDED: A REPEAT WRITEUP. ON FINAL APPROACH FULLY CONFIGURED AUTO BREAK SET TO 2, GOT THE "AUTO BREAK DISARM" LIGHT FOLLOWED SHORTLY BY INTERMITTENT ANTI-SKID INOPERATIVE LIGHT EVEN AFTER AUTO BREAKS WERE SELECTED TO OFF. REMOVE AND REPLACEDSDR AALA202406246184Battery · no testAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLASHLIGHT ON AIRCRAFT RIGHT AFT IS SHOWING A RED BATTERY LIGHT. REPLACED FLASHLIGHT BATTERY. PER AMM 25-64-00.SDR AALA202406242478Tube · dislodgedAIRCRAFT WAS NOT GROUNDED: DURING SLIDE CHANGE, RED HEAT SHRINK ON L2 DOOR FELL OFF. INSTALLED HEAT SHRINK ON L2 DOOE SLIDE GRIT BAR. PER AARD 26-66-00-4.SDR AALA202406243723Stringer · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT WING TANK INTERTRAL UPPER AFT STRINGER U9 BETWEEN RIB 19 AND RIB 22. REPLACED STRINGER PER EA 352320.SDR AALA202406241776Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION WITH CRACK IN FUSELAGE SKIN AROUND LAVATORY BLOWER VENT AT STA 917, BETWEEN S21L AND S22L. REINFORCING REPAIR ACCOMPLISHED PER SRM 53-70-01-2R, REPAIR 3 AND EA 355418.SDR AALA202407053047Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL, FROM STA 767 TO STA 787, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202406279890Frame · out of toleranceAIRCRAFT IN BASE MAINTENANCE: OVERSIZE FASTENER HOLES IN AFT CARGO COMPARTMENT DOOR OPENING FORWARD FRAME AT STA 787 PLUS 5 INCHES, BETWEEN S21R AND S23R. REPAIRED FRAME PER EA 354789.SDR AALA202406252601Tube · missingAIRCRAFT WAS GROUNDED: DOOR L1 RIGHT SIDE OF GIRT BAR MISSING RED SHRINK WRAP. **SUPPLEMENTAL REPORT FOR (AALA202406242601): INSTALLED HEAT SHRINK ON L1 GIRT BAR. PER AARD 25-66-00-4**(CLOSED).SDR AALA202406242601Tube · missingAIRCRAFT WAS GROUNDED: DOOR L1 RIGHT SIDE OF GIRT BAR MISSING RED SHRINK WRAP. (OPEN).SDR AALA2024062477904Pump · failedAIRCRAFT WAS NOT GROUNDED: LEFT FORWARD LOW PRESSURE LIGHT ILLUMINATED AFTER TAKEOFF. REMOVE AND REPLACED LEFT FORWARD BOOST PUMP. NO LEAK FOUND PUMP OPERTIONAL CHECK GOOD. PER AMM 28-22-41.SDR AALA202406240853Slide · unpackedAIRCRAFT WAS GROUNDED: THE SLIDE PACK ON DOOR 1L IS BECOMING UNPACKED. REMOVE AND REPLACED L1 DOOR EMERGENCY ESCAPE SLIDE. PER J/C 08L22125001.SDR AALA202406217685Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION HOLE IN STRINGER S25L BETWEEN STA 867 AND STA 887. ACCOMPLISHED SPLICE REPAIR TO STRINGER PER EA 354296.SDR AALA202407092525Lock · faultedAIRCRAFT WAS NOT GROUNDED: 5 CHRONIC REPEATS, HISTORY OF BOTH AFT LAVATORY DOORS DIFFICULT TO OPEN AND CLOSE, AND LOCK. REMOVED AND REPLACE LAVATORY-D DOOR LOCK AND UNLOCK BIFOLD LATCH ASSEMBLY. LIGHTS RESTORED TO NORMAL. OPS CHECKED GOOD IAW CMM 25-40-64.SDR AALA202406256213Toilet · leakingAIRCRAFT WAS GROUNDED: PREVIOUS CREW NOTED A FUME EVENT IN AFT GALLEY ON SHUTDOWN AT GATE. THEN ON COMING CREW NOTED SOILED SOCK SMELL ALSO. **SUPPLEMENTAL REPORT FOR (AALA202406216213): FOUND TOILET LEAKING, REPLACED TOILET, OPERTIONAL CHECK GOOD. PER AMM 38-SDR AALA202406219773Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406217713Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406215167Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406217310Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406210018Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406212984Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406213499Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406213808Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406218771Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406215853Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202406218520Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: FASTENER HOLE IN CARGO DOOR FRAME MISDRILLED WITH CORROSION AT BS 797. INSTALL FREEZE PLUG FOR MISDRILLED HOLE. PER FINAL EA 354813.SDR AALA202406216213Unknown · odorAIRCRAFT WAS GROUNDED: PREVIOUS CREW NOTED A FUME EVENT IN AFT GALLEY ON SHUTDOWN AT GATE. THEN ON COMING CREW NOTED SOILED SOCK SMELL ALSO. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202406216955Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR. OPERTIONAL CHECK GOOD. PER AMM 25-40-11.
Back to Boeing 737-823