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 AALA202309050339Guide Arm · wornAIRCRAFT WAS GROUNDED: L2 DOOR DIFFICULT TO OPERATE, WILL NOT CLOSE PROPERLY. BUSHING IS WORN TO LIMITS. REMOVED AND REPLACED L2 DOOR GUIDE ARM AND ROLLER ASSEMBLY PER AMM 52-13-21.SDR AALA202309050300Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURN TO MSP. AIRCRAFT LANDED SAFELY. AFTER TAKE OFF RIGHT FILTER BYPASS LIGHT CAME ON. THEN LEFT FILTER BYPASS ALSO CAME ON. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).SDR AALA202309076300Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND WING INBOARD LEADING EDGE AT FRONT SPAR LOWER PANEL SUPPORT LOCATED AT IFSS 160. REMOVED AND REPLACED FRONT SPAR LOWER PANEL SUPPORT STRAP ASSEMBLY PER EA 346136 .SDR AALA202309063990Door · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR INOPERATIVE, BOTTOM HINGE ROD NOT SECURED, CAUSING DOOR NOT TO OPEN. REMOVED AND REPLACED AFT LEFTHAND LAVATORY DOOR AS REQUIRED.SDR AALA202309069339Door · unserviceableAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS AND PASSENGERS ARE GETTING STUCK IN THE LAVATORY. **SUPPLEMENTAL REPORT FOR AALA202309059339: REMOVED AND REPLACED AFT LAVATORY "D" DOOR** (CLOSED)SDR AALA202309061699Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED BS 986 AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R REPAIR 6, ALTERNATIVE 4.SDR AALA202309063002Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT BS 986 AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R REPAIR 6, ALTERNATIVE 4.SDR AALA202309069629Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309066080Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202309063161Fitting · 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 AALA202309060538Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00 REPAIR 1.SDR AALA202309060258Fitting · 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 AALA202309060253Fitting · 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 AALA202309065313Fitting · 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 AALA202309061628Fitting · 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 AALA202309067520Fitting · 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 AALA202309067083Fitting · 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 AALA202309059339Unknown · unknownAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR STICKS AND PASSENGERS ARE GETTING STUCK IN THE LAVATORY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202309123848Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540, FROM BL 0 TO LBL 16. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-R1.SDR AALA202309121862Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT BREAK ASSEMBLY LOCATED AT BS 540, FROM BL 0 TO RBL 16. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-R1.SDR AALA202309065377Pressure Deck · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB LOCATED AT BS 663 AND RBL 31.83. REPAIRED WEB PER SRM 57-10-10-2R-3.SDR AALA202309064443Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE WOULD NOT ADJUST, SCRATCHINESS OUT. REMOVED AND REPLACED AFT MEGAPHONE PER MM 25-64-00.SDR AALA202309057267Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: PASSENGERS GETTING STUCK IN AFT LEFT LAVATORY, DOOR IS NOT OPENING FROM INSIDE. ADJUSTED AND LUBRICATED DOOR TRACKS AS REQUIRED.SDR AALA202309057787Filter · unserviceableAIRCRAFT WAS NOT GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO LIR DUE TO LOW PRESSURE ELECTRIC #2 HYDRAULIC PUMP LIGHT CAME ON AT CRUISE. ACRAFAT LANDED AT LIR WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED AIR PRESSURE FILTER ELEMENT IAW FSDR AALA202309085638Fitting · 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 AND SRM 51-40-02-0G.SDR AALA202309054001Engine · stalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURN TO CLT. AIRCRAFT LANDED SAFELY. IN FLIGHT SMOKE IN CABIN, LOUD BANG WITH NUMBER 2 ENGINE. REPLACED NUMBER 2 ENGINE. PER JOB CARD 08L40072003.SDR AALA202309050921Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D ENTRY DOOR DIFFICULT TO OPEN / CLOSE. ADJUSTED LAVATORY D DOOR PER AMM 25-40-00.SDR AALA202309053458Trim Motor · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT RETURNED TO MCO DUE TO CAPTAIN'S AND FIRST OFFICER'S MANUAL TRIM SWITCHED INOPERATIVE. AIRCRAFT LANDED SAFELY AT MCO WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED STAB TRIM MOTOR PER AMM 27-41-SDR AALA202309054778Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR DIFFICULT TO OPEN FROM GALLEY WITH ARMING SWITCH IN OFF POSITION. LUBRICATED DOOR LATCH.SDR AALA202309051263Packing · cutAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO IND. AIRCRAFT LANDED SAFELY. OIL LEAK SUSPECTED INFLIGHT DUE TO RAPID DECREASE IN OIL QUANTITY. OIL DISPLAY BLANK PRIOR TO LANDING. OIL CAP PACKING FOUND CUT AND LEAKING INTO DRAIN SSDR AALA202309217320Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER RIB, THIRD STIFFENER FROM FRONT, LOCATED AT STABILIZER STA 92.70. REPLACED RIB PER AARD 51-00-05-1 AND DWG 182A5301.SDR AALA202309089013Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB LOCATED AT BS 663, FROM LBL 45.64 TO LBL 54.21. REPAIRED PER SRM 57-10-10-2R-2 AND AARD 57-10-10-9.SDR AALA202309082786Fitting · 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 AND SRM 51-40-02-0G.SDR AALA202309089993Fitting · 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 AND SRM 51-40-02-0G.SDR AALA202309087192Fitting · 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-0G.SDR AALA202309085229Fitting · 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 AND SRM 51-40-02-0G.SDR AALA202309082543Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02-0G.SDR AALA202309083451Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02-0G.SDR AALA202309087907Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 AND SRM 51-40-02-0G.SDR AALA202309081135Fitting · 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-0G.SDR AALA202309084397Fitting · 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-0G.SDR AALA202309013548Handle · stickingAIRCRAFT WAS NOT GROUNDED: AGENT HAD DIFFICULTY OPENING FORWARD ENTRY DOOR. MAINTENANCE LUBED FORWARD ENTRY DOOR HANDLE AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 52-11-00.SDR AALA202309016484Door · stickingAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR STICKING. MAINTENANCE LUBED AFT LEFT LAVATORY DOOR AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA202309218390Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT FROM BS 767 TO BS 787 AT RBL 25. REPLACED TRANSITION PANEL PER SRM 53-60-15.SDR AALA202309138553Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CENTER WING SECTION CHORD ANGLE LOCATED AT BS 540 AND S20L. REPAIRED CHORD PER SRM 51-20-06 AND EA 347653.SDR AALA202309123050Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED AT BS 500, S25L. REPLACED BAFFLE PER AARD 51-00-05-1 AND SRM 51-00-05-0G.SDR AALA202309122851Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED AT BS 500, S25L. REPLACED BAFFLE PER AARD 51-00-05-1 AND SRM 51-00-05-0G.SDR AALA202309080865Pcu · leakingAIRCRAFT WAS GROUNDED: STRONG ODOR ON CLIMB OUT AND ON APPROACH. STRONG SMELL IN FLIGHT DECK AND CABIN. **SUPPLEMENTAL REPORT FOR AALA202309010865: MAINTENANCE TROUBLESHOOT HYDRAULIC FLUID LEAK TO MAIN RUDDER POWER CONTROL UNIT. MAIN RUDDER PCU WAS REMOVED ANDSDR AALA202309053599Latch · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR UPPER EMERGENCY EXIT PANEL HAS BECOME DISENGAGED AND WILL NOT RESET PROPERLY. MAINTENANCE INSTALLED LATCH CORRECTLY AT THE FLIGHT DECK UPPER EMERGENCY EXIT PANEL PER AMM 52-51-08 AND ACCOMPLISHED A SATISFACTORY OPERASDR AALA202309010865Unknown · unknownAIRCRAFT WAS GROUNDED: STRONG ODOR ON CLIMB OUT AND ON APPROACH. STRONG SMELL IN FLIGHT DECK AND CABIN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED** (OPEN).
Back to Boeing 737-823