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 AALA202211287512Lens · missingAIRCRAFT WAS GROUNDED: 17F LOWER EMERGENCY LIGHT LENS MISSING. REMOVED AND REPLACED 17F LOWER EMERGENCY EXIT LIGHT ASSEMBLY PER AMM 33-51-01.SDR AALA202211281483Bracket · damagedAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR DIFFICULT TO OPEN/CLOSE. REMOVED AND REPLACED SWITCH HOUSING BRACKET LAVATORY D IN UPPER DOOR FRAME PER CMM 25-40-64.SDR AALA202212166737Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER INSPAR RIB LOCATED AT STABILIZER STA 92.70. REPAIRED RIB PER SRM 55-10-09-2R PROCEDURE 5 AND SRM 51-40-05-0G.SDR AALA202211304264Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211306637Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211300452Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211308059Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211308842Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211309649Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211309349Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211302411Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211300097Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211302308Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 340464.SDR AALA202211280654Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT EMERGENCY EXIT DOOR LIGHT INOPERATIVE EXTERIOR LIGHT BETWEEN LEFT OVERWING EXIT DOORS. RELAMPED LEFT EMERGENCY EXIT DOOR LIGHT OVERWING. OPERATIONS CHECKED GOOD. AMM 33-51-04.SDR AALA202211302752Hinge · stickingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE AND LOCK. ADJUSTED LEFT AFT LAVATORY DOOR HINGE PER AMM 25-40-14.SDR AALA202211309851Skin · crackedAIRCRAFT WAS GROUNDED: L1 DOOR LOWER HINGE CUTOUT OUTER SKIN TEAR DAMAGED. CRACK LOCATED AT STA 312 AND WATERLINE 227.54. CUT OUT DAMAGE AND TREATED SKIN PER SRM 52-10-01.SDR AALA202211299318Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED HOLES IN FRAME 986.5 AND RIGHT BUTT LINE 50 STRINGER 17R. REMOVED AND INSTALLED FRAME SECTION PER SRM 51-40-02.SDR AALA202211294155Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON FUSELAGE SUPPORT INTERCOSTAL UPPER SURFACE APPROXIMATELY BETWEEN STA 948 AND 967 AND STR 20R. REMOVED, FABRICATED, AND INSTALLED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211252481Girt Bar · faultedAIRCRAFT WAS NOT GROUNDED: IL DOOR SLIDE IS FALLING OUT OF ITS BUSTLE. SECURED AND ADJUSTED SLIDE 1L GIRT AND GIRT BAR PER AMM 25-66-01.SDR AALA202211252752Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN OR CLOSE AND LOCK. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202211251619Retainer · missingAIRCRAFT WAS GROUNDED: LEFT FORWARD ENTRY GIRT BAR BRACKET FELL OFF. REINSTALLED L1 DOOR GIRT BAR RETAINER PER IPC 25-66-01. OK FOR SERVICESDR AALA202211254364Strap · brokenAIRCRAFT WAS NOT GROUNDED: L-2 DOOR WARNING STRAP BROKEN. REMOVED AND REPLACED L-2 DOOR WARNING STRAP PER ECO J0755AB.SDR AALA202211253024Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR LATCH DOES NOT RETRACT EASILY MAKING IT DIFFICULT TO CLOSE LATCH DOOR. LUBED DOOR LATCH MECHANISM AND PERFORMED OPERATIONS CHECK AND FOUND WORKING PROPERLY PER AMM 52 50-00.SDR AALA202211252313Sensor · inoperativeAIRCRAFT WAS GROUNDED: FLAPS DID NOT GO TO COMMAND POSITION FOR LANDING. AIRCRAFT DECLARED AN EMERGENCY INTO JFK. LANDED FLAPS LESS THAN 1. LEADING EDGE EXTENDED. TOUCHDOWN SPEED APPROXIMATELY 172 KNOTS DECLARED EMERGENCY. LANDING UNEVENTFUL. EMERGENCY EQUIPMESDR AALA202212068358Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR THRESHOLD SUPPORT ANGLE LOCATED AT BS 312 AND RBL 64. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202211291048Tee Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT UPPER T CHORD LOCATED STA 927 26 INCHES FROM BUTT LINE Ï¿½0Ï¿½ CORRODED. REMOVED FABRICATED AND REPLACED UPPER T CHORD PER SRM 53-70-51-2R-4.SDR AALA202211280044Stiffener · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND IN RADIUS OF BOTTOM STIFFENER. LOCATED AT STA 663, WATERLINE 154.5 AND RIGHT BUTT LINE 27. REMOVED AND REPLACED STIFFENER ON WHEEL WELL FORWARD WALL PER AARD 51-00-05-1.SDR AALA202211278506Computer · faultedAIRCRAFT WAS GROUNDED: ON CLIMB OUT, AUTOPILOT A AND B WOULD NOT ENGAGE. FLIGHT RETURNED TO DFW LANDING SAFELY. REPLACED FLIGHT CONTROL COMPUTER A. REPLACED AILERON POSITION SENSOR M937. ADJUSTED AILERON ACTUATOR INPUT ARM A. ACCOMPLISHED SATISFACTORY OPERSDR AALA202211273175Arm · out of adjustAIRCRAFT WAS GROUNDED: ON CLIMB OUT, AUTOPILOT A AND B WOULD NOT ENGAGE. FLIGHT RETURNED TO DFW LANDING SAFELY. REPLACED FLIGHT CONTROL COMPUTER A. REPLACED AILERON POSITION SENSOR M937. ADJUSTED AILERON ACTUATOR INPUT ARM A . ACCOMPLISHED SATISFACTORY OPERASDR AALA202211275844Sensor · faultedAIRCRAFT WAS GROUNDED: ON CLIMB OUT, AUTOPILOT A AND B WOULD NOT ENGAGE. FLIGHT RETURNED TO DFW LANDING SAFELY. REPLACED FLIGHT CONTROL COMPUTER A. REPLACED AILERON POSITION SENSOR M937. ADJUSTED AILERON ACTUATOR INPUT ARM A. ACCOMPLISHED SATISFACTORY OPERASDR AALA202211238506Autopilot Sys · malfunctionedAIRCRAFT WAS GROUNDED: ON CLIMB OUT, AUTOPILOT A AND B WOULD NOT ENGAGE. FLIGHT RETURNED TO DFW LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202211238160Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT STRINGER CLIP LOCATED AT BS 500I AND S26R. REPLACED STRINGER CLIP PER AARD 51-00-05-01.SDR AALA202211284021Compressor · stalledAIRCRAFT WAS GROUNDED: COMPRESSOR STALL #1 ENGINE ON BEGINNING OF DESCENT INTO LAX. EMERGENCY DECLARED; FLIGHT LANDED SAFELY. NR 1 ENGINE REPLACED PER JOB CARD 08L40072003.SDR AALA202211234021Compressor · stalledAIRCRAFT WAS GROUNDED: COMPRESSOR STALL #1 ENGINE ON BEGINNING OF DESCENT INTO LAX. EMERGENCY DECLARED; FLIGHT LANDED SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202211225508Cup · out of adjustAIRCRAFT WAS NOT GROUNDED: DOOR 1R RETAINER CLIPS DO NOT SECURELY HOLD GIRT BAR TO DOOR. ADJUSTED R1 DOOR SLIDE GIRT BAR RETAINER CLIPS ON DOOR PER AMM 25-66-00.SDR AALA202211223151Spring · detachedAIRCRAFT IN BASE MAINTENANCE: 1L DOOR GUST LOCK SPRING INOPERATIVE. ATTACHED GUST LOCK SPRING PER AMM 52-11-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202211228298Wire · disconnectedAIRCRAFT WAS GROUNDED: DURING EMERGENCY LIGHT TEST FOUND EXIT LIGHT ASSEMBLY NOT WORKING BESIDE LAVATORY D. FOUND WIRE W4142-0415-20 STOWED BY CONNECTOR D10744. TERMINATED WIRE PER WDM 33-51-22. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202211219696Retainer · unsecureAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR LOOSE IN RETAINER CLIPS WHEN DOOR OPEN. SECURED R1 DOOR COVER AFT GIRT BAR RETAINER CLIP PER AMM 25-66-00.SDR AALA202211215628Door · bindingAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. REMOVED AND REINSTALLED DOOR PER AMM 25-40-00. OPERATES NORMAL.SDR AALA202211213349Door Latch · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO LATCH CLOSED. ADJUSTED DOOR LATCH MECHANISM PER AMM 52-51-02. OPERATIONAL CHECK GOOD.SDR AALA202211215483Door Latch · unsecureAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO LATCH CLOSED. SECURED FLIGHT DECK DOOR LATCH PER AMM 25-00-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202212131180Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: RIGHT SIDEWALL SUPPORT CORRODED LOCATED AT STA 500D AND STR 26R. REMOVED AND REPLACED CARGO SIDEWALL SUPPORT ANGLE PER EA.SDR AALA202212132049Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION LOCATED AT RIGHT SIDEWALL SUPPORT LOCATED AT STA 500D AND STR 24R TO STR 26R. REMOVED AND REPLACED SIDEWALL SUPPORT ANGLE PER SRM 51-20-01.SDR AALA202212074098Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT AFT FLOOR SUPPORT RAIL ASSEMBLY LOCATED AT BS 500I FROM LBL 28 TO RBL 28. REPLACED RAIL ASSEMBLY PER AARD 51-00-05 PROCEDURE 1 REPAIR 1, AND SRM 51-40-02.SDR AALA202212079745Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 727B TO BS 800 AT LBL 22. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5SDR AALA202212079364Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 R1.SDR AALA202212068848Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 R1.SDR AALA202212064064Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR THRESHOLD WEB LOCATED FROM BS 790 TO BS 847 AT RBL 24. REPLACED THRESHOLD WEB PER SRM 53-60-15.SDR AALA202211296506Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON INTERCOSTAL LOCATED AT STA 312 AND RIGHT BUTT LINE 24. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202211298979Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK FOUND ON INTERCOSTAL LOCATED AT STA 312 AND LEFT BUTT LINE 24. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05.
Back to Boeing 737-823