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 AALA202303071049Rail · out of toleranceAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT CARGO SUPPORT RAIL LOCATED AT BS 790.5 AND LBL 8 HAS ELONGATED FASTENER HOLE. REPAIRED SUPPORT RAIL PER EA 342420.SDR AALA202303070512Rail · out of toleranceAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT CARGO SUPPORT RAIL LOCATED AT BS 790.5 AND LBL 12 HAS ELONGATED FASTENER HOLE. REPAIRED SUPPORT RAIL PER EA 342420.SDR AALA202303074127Rail · out of toleranceAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT CARGO SUPPORT RAIL LOCATED AT BS 790.5 AND RBL 2.5 HAS ELONGATED FASTENER HOLE. REPAIRED SUPPORT RAIL PER EA 342420.SDR AALA202303061534Connector · inoperativeAIRCRAFT WAS NOT GROUNDED: SEATS ROWS 16-17-18-19 EMERGENCY LIGHTS INOPERATIVE. FOUND CONNECTOR LOOSE UNDER SEAT 16B, RECONNECTED AND TIGHTENED CONNECTOR.SDR AALA202303066058Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 480 TO BS 500 AT RBL 26. REMOVED AND REPLACED TRANSITION PANEL PER SRM-51-40-02-OG AND DWG 143A8126.SDR AALA202303066989Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 500I AT LBL 25. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM 51-40-02-OG.SDR AALA202303064964Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 500I AT S26R. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202303066402Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 767 AND BS 787 AT RBL 20. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G AND DWG 146A8127.SDR AALA202303063530Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 727I + 15 INCHES AND BS 807 AT S25L. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202303068205Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 727E + 10 INCHES AND BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202303062704Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE LOCATED OUTBOARD OF KEEL BEAM AT BS 663.5 AND RBL 2. REPAIRED ANGLE PER SRM 57-10-10-2R-5, SRM 51-40-02, AND SRM 51-40-03.SDR AALA202303067078Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN SUPPORT ANGLE LOCATED OUTBOARD OF KEEL BEAM AT BS 663.5 AND LBL 2. REPAIRED ANGLE PER SRM 57-10-10-2R-5, SRM 51-40-02, AND SRM 51-40-03.SDR AALA202303062258None · noneAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR LATCH GETS STUCK IN LOCKED POSITION INTERMITTENTLY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202303217491Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500E + 6 INCHES TO BS 500I AT RBL 36. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202303141834Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBOARD SUPPORT. LOCATED AT STA 500I AND 24 LEFT BUTT LINE. REPAIRED MINOR CORROSION OF FLOOR BOARD SUPPORT.SDR AALA202303067074Bracket · looseAIRCRAFT WAS NOT GROUNDED: AFT LEFT ENTRY DOOR BOLT LOOSE ON SLIDE PACK. REMOVED AND REPLACED AFT LEFT ENTRY DOOR SLIDE MOUNTING BRACKET.SDR AALA202303067338Handle · stickingAIRCRAFT WAS NOT GROUNDED: R4 DOOR LOCK DIFFICULT TO MOVE. TIGHTENED HANDLE ON R4.SDR AALA202303061055Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: MEGAPHONE INOPERATIVE. REPLACED BATTERY PER AMM 25-64-00SDR AALA202303227750Engine · failedAIRCRAFT WAS GROUNDED: BETWEEN 80 KNOTS AND 153 KNOTS WE EXPERIENCED A LEFT ENGINE FAIL INDICATION. WE ABORTED THE TAKEOFF AND RETURNED TO THE GATE. ACTUAL SPEED 92 KNOTS. **SUPPLEMENTAL REPORT FOR AALA202303037750: MAINTENANCE REMOVED AND REPLACED LEFT ENGINESDR AALA202303082461Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE BAFFLE LOCATED FROM BS 500D TO BS 500E AT S25L. REPLACED BAFFLE PER DWG 143A7505 AND AARD 51-00-05-1 AND AARD 53-00-01-6.SDR AALA202303086153Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RUDDER CONDUCTIVE FRAME, UNDER LOWER STATIC WICK BASE, LOCATED AT RUDDER STA 276.240. REPAIRED RUDDER CONDUCTIVE FRAME PER SRM 55-40-01-2R-2.SDR AALA202303076807None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE BEAM INNER CHORD LOCATED BETWEEN BS 967 AND BS 992.8 AT LBL 55. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202303077551Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 727A AND BS 727B AT LBL 24. REMOVED, FABRICATED, AND INSTALLED NEW TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202303066902Sensor · miswiredAIRCRAFT WAS GROUNDED: L1 DOOR LIGHT CAME ON PASSING FLIGHT LEVEL 250. FLIGHT RETURNED TO STL LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202303036902: MAINTENANCE FOUND L1 DOOR INDICATION ISSUED TO BE CAUSED BY L1 DOOR SENSOR SW199 WIRING HAD AN INCORRECT SDR AALA202303037750None · noneAIRCRAFT WAS GROUNDED: BETWEEN 80 KNOTS AND 153 KNOTS WE EXPERIENCED A LEFT ENGINE FAIL INDICATION. WE ABORTED THE TAKEOFF AND RETURNED TO THE GATE. ACTUAL SPEED 92 KNOTS. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202303038114Sliding Window · noisyAIRCRAFT WAS GROUNDED: ON TAKE OFF ROLL, CLIMB, CRUISE, AND DESCENT, LOUD AIR NOISE COMING FROM LEFT SIDE OF COCKPIT. PRESSURIZATION WAS NORMAL. SUSPECT L2 WINDOW. REMOVED AND REPLACED CAPTAINS SLIDING WINDOW PER AMM 56-12-11. LEAK CHECK GOOD PER AMM 05-51-91.SDR AALA202303036902None · noneAIRCRAFT WAS GROUNDED: L1 DOOR LIGHT CAME ON PASSING FLIGHT LEVEL 250. FLIGHT RETURNED TO STL LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202303026308Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01675 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303023541Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M02816 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303029667Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01673 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303023944Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01672 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303026962Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M02335 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303021242Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01695 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303021794Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01694 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303023671Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01676 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303027689Battery Pack · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01671 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303027703Battery · dischargedAIRCRAFT IN BASE MAINTENANCE: EMERGENCY LIGHTING POWER SUPPLY M01670 BATTERY PACK IS DISCHARGED. REPLACED BATTERY PACK PER AMM 33-51-06. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202303149988Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 17 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202303082821None · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540 AND LBL 3. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202303084435None · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN BREAK ASSEMBLY LOCATED AT BS 540 AND RBL 3. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202303079491Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 500C TO BS 500D AT S26R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202303060045Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT AFT BULKHEAD CENTER ACCESS PANEL LOWER SUPPORT LOCATED AT BODY STATION 947.5 AND BETWEEN RIGHT BUTT LINE 20 TO LEFT BUTT LINE 20. REMOVED AND INSTALLED NEW LOWER SUPPORT.SDR AALA202303062519Landing · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT WHEEL WELL AFT LOWER PANEL LANDING CORRODED IN MULTIPLE PLACES LOCATED AT STA 727+2 AND LEFT BUTT LINE 0 TO LEFT BUTT LINE 35. REMOVED AND REPLACED NEW PANEL LANDING PER SRM.SDR AALA202303029775Slide · low pressureAIRCRAFT WAS NOT GROUNDED: R1 SERVICE DOOR REQUIRES NEW ESCAPE SLIDE DUE TO LOW PRESSURE. REMOVED AND REPLACED R-1 SERVICE DOOR SLIDESDR AALA202303070266Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT LOCATED AT BS 922.8 AND LBL 44. REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202303075486Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON L1 DOOR ANGLE LOCATED FROM BS 328 TO BS 344 AT LBL 64. REPLACED ANGLE PER SRM 51-40-02-0G.SDR AALA202303070004None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM CHORD AT L1 DOOR SILL, LOCATED FROM BS 312 TO BS 344 AT LBL 60. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202303067504Flange · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LOWER FLANGE HAS SIGNS OF CORROSION AT STA 500I AND 25L. REMOVED AND REPLACED FLANGE.SDR AALA202303068119Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE RIGHT TRANSITION PANEL SECTION BETWEEN BODY STATION 857 AND BODY STATION 867 JUST ABOVE STR 25R. REMOVED AND REPLACED TRANSITION PANEL.SDR AALA202303069632Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX SHEAR FITTING ABOVE FORWARD UPPER SPAR LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 342705.
Back to Boeing 737-823