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 AALA202307269921Shear Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307260042Shear Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307289930Transformer · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED. AIRCRAFT RETURN TO DFW DUE TO TRAILING FLAPS DISAGREE. AIRCRAFT LANDED SAFELY AT DFW. **SUPPLEMENTAL REPORT FOR AALA202307269930: REMOVED AND REPLACED T52 TRANSFORMER, RESET CIRCUIT BREAKER.** (CLOSED)SDR AALA202307266318Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN MAIN CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540 BETWEEN BL0 AND RBL 24. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202307260040Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN MAIN CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540 BETWEEN BL0 AND LBL 24. REPLACED BREAK ASSEMBLY PER SRM 51-40-02-0G.SDR AALA202307263918Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AT ALTITUDE. CLEANED AND LUBRICATED DOOR LATCH.SDR AALA202307269732Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: LEFT AFT EXTERIOR L2 EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED LEFT AFT L2 EXTERIOR EMERGENCY EXIT LIGHT PER AMM 33-51-04.SDR AALA202307267270Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD LOCATED AT BS 947.4 FROM LBL 6.0 TO RBL 7.5. REPAIRED FLOORBEAM PER EA 346396 AND SRN 53-70-51-2R-5.SDR AALA202307261503Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO BURNING PLASTIC SMELL THROUGHOUT CABIN DURING CLIMB. THE AIRCRAFT LANDED SAFELY AT DFW. NO ODORS NOTED WITH APU OR ENGINE POWER RUNS. MAINTENANCE FOUND NO FAULTS.SDR AALA202307262411Shear Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307261157Shear Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307267559Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307263925Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202307269930Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED. AIRCRAFT RETURN TO DFW DUE TO TRAILING FLAPS DISAGREE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202307268254Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309016259Slat Track · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT WING NUMBER 5 SLAT INBOARD MAIN TRACK FLANGE HAS CORROSION. REMOVED AND REPLACE RIGHT HAND NUMBER 5 INBOARD MAIN SLAT TRACK PER AMM 27-81-21-400-802.SDR AALA202307253008Door · stuckAIRCRAFT WAS NOT GROUNDED: LAVATORY DOOR ON AFT LEFT SIDE STUCK. FREED LEFT AFT LAVATORY DOOR PER AA STANDARD PRACTICES.SDR AALA202307255305Connector · unserviceableAIRCRAFT IN BASE MAINTENANCE: EMERGENCY FLOOR PROXIMITY EMERGENCY LIGHTS INOPERATIVE ON FIRST CLASS SEATS. REPLACED EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M02816 (AALA202307255728) AND REPLACED CONNECTOR D95031P PER WDM 33-51-21 (AALA202307255305). ACCOMSDR AALA202307255728Power Supply · inoperativeAIRCRAFT IN BASE MAINTENANCE: EMERGENCY FLOOR PROXIMITY EMERGENCY LIGHTS INOPERATIVE ON FIRST CLASS SEATS. REPLACED EMERGENCY LIGHTING BATTERY PACK POWER SUPPLY M02816 (AALA202307255728) AND REPLACED CONNECTOR D95031P PER WDM 33-51-21 (AALA202307255305). ACCOMSDR AALA202307252417Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500I TO BS 500A AT S25R. REMOVED, FABRICATED, AND INSTALLED NEW TRANSITION PANEL PER SRM 53-00-53-2R-6.SDR AALA202307251303Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 ENTRY DOOR SILL INNER CHORD LOCATED FROM BS 951 TO BS 992.8 AT LBL 54. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202307245020Lock · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LATCH LOCK HARD TO UNLOCK. ADJUSTED FORWARD LAVATORY LATCH LOCK.SDR AALA202307244065Sliding Window · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK L2 SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. ACCOMPLISHED ADJUSTMENT OF L2 SLIDING WINDOW PER AMM 56-12-11.SDR AALA202307311913Actuator · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DO TO FUEL IMBALANCE. AIRCRAFT DIVERTED TO AZO, LANDING SAFELY. FOUND FUEL LEAK FROM INLET GUIDE VANE (IGV) ACTUATOR. REPLACED IGV ACTUATOR PER AMM 49-52-12.SDR AALA202307245174Switch · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED DOOR SWITCH PER CMM 25-40-65.SDR AALA202307255047Flashlight Assy · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTENDANT SEAT FLASHLIGHT ASSEMBLY BROKEN. REMOVE AND REPLACED FORWARD FLIGHT ATTENDANT SEAT FLAHSLIGHT ASSEMBLY PER AMM 25-64-00.SDR AALA202307247501Sensor · out of adjustAIRCRAFT WAS GROUNDED: REJECTED TAKE OFF DUE TO AFT ENTRY DOOR LIGHT ILLUMINATED. L4 DOOR WARNING SENSOR OUT OF RIG. ADJUSTED SENSOR PER AMM: 52-71-11.SDR AALA202307244762Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED AND ADJUSTED FORWARD LAVATORY DOOR PER CMM 25-46-96.SDR AALA202307246156Door Latch · brokenAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR LATCH BROKEN ON THE INSIDE. REINSTALLED FORWARD LAVATORY DOOR LATCH. PER CMM 25-46-96.SDR AALA202307249917Stop · missingAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR MISSING ROUND WHITE PLASTIC COLLAR ON LEFT SIDE OF BAR. REPLACED RELEASE STOP ON R1 DOOR GIRT BAR PER AMM 25-66-01.SDR AALA202307213392Rib · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER RIB CRACKED AT STABILIZER STATION 92.70 AT THE 2ND STIFFENER AFT OF THE FRONT SPAR. REPAIRED RIB PER SRM 55-10-09-2R R4.SDR AALA202307214125Module · no testAIRCRAFT WAS GROUNDED: THE EMERGENCY LIGHTS SWITCH ON AFT ATTENDANT PANEL DOES NOT TURN EMERGENCY EXIT LIGHTS ON. REMOVED AND REPLACED AFT FLIGHT ATTENDANT PANEL LIGHTING MODULE.SDR AALA202307216954Lamp · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE: EMERGENCY LIGHT CABIN CEILING AREA 21 CBA INOPERATIVE. RELAMPED.SDR AALA202307218615Shade · malfunctionedAIRCRAFT WAS NOT GROUNDED: SUNSHADE AT WINDOW L3 WILL NOT ROLL UP. REMOVED AND REPLACED CAPTAIN L3 SHADE.SDR AALA202307212489Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD OF ROW 1 CEILING EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED FWD EMERGENCY LIGHT BATTERY PER AMM 33-51-00.SDR AALA202307211539Bolt · unsecureAIRCRAFT WAS GROUNDED: CAPTAINS SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. RESECURED AFT LOWER BEARING BOLT PER AMM 56-12-11.SDR AALA202307210197Door Frame · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR WILL NOT LOCK (AT TIMES WILL NOT OPEN). AFT RIGHT LAVATORY DOOR FRAME ADJSUTED PER CMM 25-40-59.SDR AALA202307241104Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO TPA DUE TO AT CRUISE, LEFT ENGINE OIL TEMPERATURE ROSE TO YELLOW ARC EVENTUALLY RISING TO RED LINE. OIL QUANTITY DROPPED TO A LOW OF 3 QUARTS. OIL TEMP INDICATION FAILED. CREW SHUTDOSDR AALA202307213790Skin Panel · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN PANEL CRACKED AT STABILIZER STATION 92.70 AND 14 INCHES AFT OF THE FRONT SPAR. REPAIRED SKIN PANEL PER SRM 55-10-01-2R 11.SDR AALA202307213161Trim Motor · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO DFW DUE TO ELECTRIC TRIM FAILED IN CRUISE AND STAB OUT OF TRIM LIGHT ILLUMINATED. THE AIRCRAFT LANDED SAFELY AT DFW WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED STAB TRIM MOTOR M01SDR AALA202307201551Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCED: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500B TO BS 500I AT S25R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5 AND SRM 51-40-02-0G.SDR AALA202307206136Lamp · inoperativeAIRCRAFT IN BASE MAINTENANCE: R4 DOOR EXTERIOR EMERGENCY EXIT LIGHT IS INOPERATIVE. REPLACED LAMP PER AMM 33-51-04. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202307201104Engine · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO TPA DUE TO AT CRUISE, LEFT ENGINE OIL TEMPERATURE ROSE TO YELLOW ARC EVENTUALLY RISING TO RED LINE. OIL QUANTITY DROPPED TO A LOW OF 3 QUARTS. OIL TEMP INDICATION FAILED. CREW SHUTDOSDR AALA202307206490Handle · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED FORWARD LAVATORY DOOR HANDLE PER AMM 52-50-01A.SDR AALA202307197262Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307192950Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307198968Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02.SDR AALA202307214841Sliding Window · out of adjustAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICER SLIDING WINDOW DIFFICULT TO OPEN AND CLOSE. ADJUSTED FIRST OFFICER WINDOW AS REQUIRED PER AMM 56-12-11-820-801.SDR AALA202307204786Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM AT BS 420 , BETWEEN LBL 34 AND LBL 75. REPAIRED FLOOR BEAM PER SRM 53-00-51-2R-1.SDR AALA202307206453Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR AREA INNER CHORD STRAP LOCATED FROM BS 305 TO BS 310 AT RBL 59.5. REPLACED STRAP PER SRM 51-40-02.
Back to Boeing 737-823