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 AALA202212277267Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR LEFT HAND TRANSITION PANEL LOCATED BETWEEN BS 440 AND BS 500I AT RBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 REPAIR 5.SDR AALA202212277433Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR RIGHT HAND TRANSITION PANEL LOCATED BETWEEN BS 500A AND BS 500I AT RBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 REPAIR 5.SDR AALA202212278419Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 1018 TO BS 1028 AT RBL 17. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212272815Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 460 TO BS 480 AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212274935Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500A TO BS 500B AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212276622Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED AT BS 500I AND S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212275497Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500D TO BS 500E AT S25L. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212277895Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 967 TO BS 987 AT RBL 15. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202212235828Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986, WL 208, AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6.SDR AALA202212239188Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 134, ALONG THE AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202212238811Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 8 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202212232888Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.70, 8 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202212234644Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 16 INCHES FROM FRONT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR SWAA2022122283633Flashlight · inoperativeCOCKPIT EMERGENCY FLASHLIGHT SEAL BROKEN, LIGHT INOPERATIVE. R & R FLT DECK EMERGENCY FLASHLIGHT IAW SIP.SDR AALA202212212716Control Panel · inoperativeAIRCRAFT WAS GROUNDED: WHILE EXECUTING THE ILS 17C AT DFW, VERTICAL AND LATERAL GUIDANCE WENT AWAY, AUTO PILOT DISCONNECTED AND AT STOPPED WORKING. DIVERTED TO TUL AND EVERYTHING HAPPENED AGAIN WHILE DOING THE ILS 18L. REMOVED AND REPLACED DIGITAL FLIGHT CONTRSDR AALA202212207260Module · faultedAIRCRAFT WAS GROUNDED: ALL LAVATORIES WILL NOT FLUSH. FLIGHT DIVERTED TO CLT LANDING SAFELY. MAINTENANCE REPLACED THE VACUUM WASTE SYSTEM LOGIC CONTROL MODULE PER AMM 38-33-03-400-801 (AALA202212207260) AND WASTE TANK CONTINUOUS LEVEL SENSOR J3 PER AMM 38-33-0SDR AALA202212205147Sensor · faultedAIRCRAFT WAS GROUNDED: ALL LAVATORIES WILL NOT FLUSH. FLIGHT DIVERTED TO CLT LANDING SAFELY. MAINTENANCE REPLACED THE VACUUM WASTE SYSTEM LOGIC CONTROL MODULE PER AMM 38-33-03-400-801 (AALA202212207260) AND WASTE TANK CONTINUOUS LEVEL SENSOR J3 PER AMM 38-33-0SDR AALA202212204589Rib · crackedAIRCRAFT IN BASE MAINTENANCE, A CRACK IN LEFT HORIZONTAL STABILIZER RIB HSS 129.50, SECOND STIFFENER FROM THE FRONT SPAR. REPAIRED THE RIB IAW SRM 55-10-09-2R.SDR AALA202212209261Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500G TO 500H AND RBL 25. REPLACED BAFFLE PER SRM 51-40-02, AARD 51-00-05-1 AND DWG 143A7505.SDR AALA202212203638Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND BAFFLE LOCATED FROM BS 500F TO 500G AND RBL 25. REPLACED BAFFLE PER SRM 51-40-02, AARD 51-00-05-1, AND DWG 143A7505.SDR AALA202302064172Access Door · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LAVATORY SERVICE PANEL ACCESS DOOR LOCATED AT BS 857 AND S24L. REPLACED DOOR PER SRM 51-40-02.SDR AALA202301049416Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727A TO BS 767 AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND AARD 51-00-05-1.SDR AALA202301044596Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 727A TO BS 767 AND FROM RBL 18 TO RBL 22. REPLACED TRANSITION PANEL PER AARD 51-00-05-1, DWG 146A7502, AND SRM 51-40-02.SDR AALA202212293686Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: DELAMINATED OUTBOARD FLAP LOWER SURFACE AT LEFT WING. L= 20.00 INCH, W= 12.00 INCH. PERFORMED INTERIM DOUBLER REPAIR ON OUTBOARD AFT FLAP AT LEFT WING.SDR AALA202212287942Skin · crackedAIRCRAFT IN BASE MAINTENANCE. LOWER SKIN OF RIGHT HORIZONTAL STABILIZER HAS CRACK AT HSS 101.90, 9 INCHES FROM AFT SPAR. INSTALLED A REPAIR FILLER AND DOUBLER.SDR AALA202212281380Skin · crackedAIRCRAFT IN BASE MAINTENANCE. LOWER SKIN OF HORIZONTAL STABILIZER HAS A CRACK AT HSS 98, LOCATED ALONG THE AFT SPAR. INSTALLED A REPAIR FILLER AND DOUBLER TO SKIN.SDR AALA202212235582Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM LOCATED AT BS 986.5, WL 208, AND RBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202212233788Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202212203896Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ON SIDE OF SEAT 11C IS HANGING. RE-SECURED EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-11.SDR AALA202212205862Track · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTS AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. ADJUSTED AND LUBRICATED LEFT AFT LAVATORY DOOR TRACK PER CMM.SDR AALA202212209187Ceiling Panel · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN. FOUND CEILING PANEL ABOVE DOOR LOOSE AND RESTING ON DOOR . RESECURED PANEL PER AMM 20-00-00.SDR AALA202301125004Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301123979Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301127351Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINER LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351,SDR AALA202301120840Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301128973Retainer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT PRESSURE BULKHEAD SEAL RETAINERS LOCATED AT BS 1016 AND FROM RBL 45 TO LBL 45. REPLACED 5 SEAL RETAINERS PER DWG 65-46823. (FOR PARTS INFORMATION SEE AALA202212205004, AALA202301123979, AALA202301127351SDR AALA202301103865Bracket · looseAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR BRACKET ON RIGHT SIDE IS VERY LOOSE. IT DOES NOT SECURE GIRT BAR IN PLACE. REMOVED AND REPLACED R1 DOOR RIGHT GIRT BAR BRACKET IAW SRM 51-40-02.SDR AALA202301105834Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR THRESHOLD WEB LOCATED FROM BS 797 TO BS 847 AT RBL 24. REPLACED THRESHOLD WEB PER SRM 51-40-02SDR AALA202301061837Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO DOOR THRESHOLD WEB LOCATED FROM BS 440 TO BS 500 AT RBL 26. REPLACED THRESHOLD WEB PER SRM 51-40-02.SDR AALA202212231448Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO COMPARTMENT INTERCOSTAL AT STA 500D-500E STR 24R IS CRACKED. FABRICATED BAFFLE ASSEMBLY AND REPLACED PER AARD 20-00-00-1.SDR AALA202212205824Cap · brokenAIRCRAFT WAS NOT GROUNDED: SEAT 19C EMERGENCY LIGHT CAP BROKEN OFF. REPLACED SEAT LIGHT ASSEMBLY PER AMM 33-51-11.SDR AALA202212203865Bracket · looseAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR GIRT BAR BRACKET ON RIGHT SIDE IS VERY LOOSE. IT DOES NOT SECURE GIRT BAR IN PLACE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202212197092Girt Bar · unsecureAIRCRAFT WAS NOT GROUNDED: DOOR1 R GIRT BAR NOT SNUG ON RIGHT SIDE. RE SECURED DOOR RIGHT GIRT BAR OPERATIONS GOOD PER AMM 25-66-02.SDR AALA202212199004Lock Fastener · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO CLOSE. WILL ONLY CLOSE IF DOOR HANDLE IS TURNED TO RELEASE LATCH. SECURED LOCK FASTENERS. FLIGHT DECK DOOR OPERATIONS CHECK GOOD PER AMM 52-51-01.SDR AALA202212196904Jack · brokenAIRCRAFT WAS NOT GROUNDED: AFTER TAKEOFF WE ENCOUNTERED RADIO INTERFERENCE OVER HEADSETS (UNABLE TO HEAR ATC ) WAS INTERMITTENT, BUT VERY LOUD WHEN ACTIVE,- UNPLUGGED BOTH HEADSETS- NO HELP. AIRCRAFT DIVERTED TO DEN. EMERGENCY WAS NOT DECLARED. REMOVED AND REPSDR AALA202212199746Anti-Ice Valve · faultedAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF AT APPROXIMATELY 60 KNOTS DUE TO ILLUMINATION OF ANTI ICE LIGHT ON RIGHT SIX PACK. AIRCRAFT WEIGHT 164,400 LBS. ENGINE ANTI ICE ON FOR TAKEOFF. NO LIGHTS ON RECALL. REMOVED AND REPLACED NUMBER 1 (AALA202212199746) ENGINESDR AALA202212196876Anti-Ice Valve · faultedAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF AT APPROXIMATELY 60 KNOTS DUE TO ILLUMINATION OF ANTI ICE LIGHT ON RIGHT SIX PACK. AIRCRAFT WEIGHT 164,400 LBS. ENGINE ANTI ICE ON FOR TAKEOFF. NO LIGHTS ON RECALL. REMOVED AND REPLACED NUMBER 1 (AALA202212199746) ENGINESDR AALA202301187118Plate · crackedAIRCRAFT IN BASE MAINTENANCE: AFT PIT AFT CORNER SCUFF PLATE CRACKED ALONG THE EDGE. REMOVED AND REPLACED SCUFF PLATE ASSEMBLY.SDR AALA202301186439Plate · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO FORWARD FLOOR ANCHOR PLATE CAP STRIP HAS SURFACE CORROSION. REMOVED AND REPLACED SCUFF PLATE.SDR AALA202301183293Anchor Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO AFT FLOOR ANCHOR PLATE CAP STRIP HAS SURFACE CORROSION. REMOVED AND REPLACED SCUFF PLATE.
Back to Boeing 737-823