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 AALA202409063270Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE IN CRUISE ENG 1 HYDRAULIC PUMP LOW PRESSURE LIGHT FLICKERED. FOUND HYDRAULIC SYSTEM A QUANTITY AT 40% AND DROPPING, SYSTEM QUANTITY DROPPED AS LOW AS 0% THEN ROSE TO 13% SHORTLY AFTER RUNNING CHECKSDR AALA202409069372O-Ring · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE IN CRUISE ENG 1 HYDRAULIC PUMP LOW PRESSURE LIGHT FLICKERED. FOUND HYDRAULIC SYSTEM A QUANTITY AT 40% AND DROPPING, SYSTEM QUANTITY DROPPED AS LOW AS 0% THEN ROSE TO 13% SHORTLY AFTER RUNNING CHECKSDR AALA202409048981Lamp · no testAIRCRAFT WAS NOT GROUNDED: R1 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMPED R1 DOOR EXTERIOR EMERGENCY LIGHT. PER AMM 33-51-04.SDR AALA202409042723Sign · brokenAIRCRAFT WAS NOT GROUNDED: EXIT SIGN OVER ROW 16 DEF BROKEN. REMOVED AND REPLACED SEAT 16DEF EXIT SIGN LIGHT ASSEMBLY, OPERTIONAL CHECKS GOOD. PER AMM 33-51-01-960-802.SDR AALA202409043270Pump · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: WHILE IN CRUISE ENG 1 HYDRAULIC PUMP LOW PRESSURE LIGHT FLICKERED. FOUND HYDRAULIC SYSTEM A QUANTITY AT 40% AND DROPPING, SYSTEM QUANTITY DROPPED AS LOW AS 0% THEN ROSE TO 13% SHORTLY AFTER RUNNING CHECKSDR AALA202409047441Valve · openAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FUEL IMBALANCE 2,000 LBS WITH NORMAL LANDING; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. AFTER DEBRIEFING OF FLIGHT CREW DISCOVERED CROSSFEED VALVE WAS LEFT OPEN. ACCOMPLISHED FUEL IMBALASDR AALA202409046587Megaphone · no testAIRCRAFT WAS NOT GROUNDED: FORWARD CABIN MEGA PHONE INOPERATIVE. REPLACED MEGAPHONE UNIT, OPERTIONAL CHECK GOOD. PER AMM 25-60-00.SDR AALA202409042823Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND R2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. RELAMP LIGHT. OPERTIONAL CHECK GOOD. PER AMM 33-51-00.SDR AALA202409048312Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR STUCK AND VERY HARD TO OPEN AND CLOSE. ADJUSTED AND TESTED LAVATORY-A DOOR OPENS AND CLOSE NOW. PER CMM 25-44-49.SDR AALA202409045990Valve · failedAIRCRAFT WAS GROUNDED: REPORTED FUEL SMELL IN CABIN CAME FROM ENGINE STARTING ISSUES. REMOVED AND REPLACED ENGINE 1 SPAR VALVE. PER AMM 28-22-11. OPERTIONAL CHECK NORMAL. ACCOMPLISHED ENGINE RUN AND FOUND PARAMETERS NORMAL. NO ODOR NOTICED IN CABIN.SDR AALA202408319598Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408319507Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408313908Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408314907Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408312689Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408315178Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408319944Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408317525Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408319668Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202408312628Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202409193639Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR SILL INNER CHORD (CREASE ANGLE) FROM STA 967 TO STA 987, RBL 55. REPLACED CHORD PER 51-00-05-01.SDR AALA202409110834Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON Z ANGLE AT STA 993, RBL 50. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202409262160Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CHORD) AT STA 947, LBL 52. REPAIRED CHORD PER SRM 53-70-51-2R-5, EA 357882, AND EA 358098.SDR AALA202409196540Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500E TO STA 500I, S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202409172875Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD AT STA 987, LBL 43. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202409136337Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM STA 500D TO STA 500I, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202409126447Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD AT STA 500, S22R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202409114869Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR THRESHOLD CREASE ANGLE FROM STA 312 TO STA 344, S17R, RBL 42. REPLACED ANGLE PER AARD 51-00-05-1.SDR AALA202409057795Vapor Barrier · crackedAIRCRAFT WAS GROUNDED: LEFT HAND WING VAPOR BARRIER IS CRACKED APPROX 16.5" LONG STARTING APPROX 5.8" LEFT LOWER CENTER FROM STIFFENER LBL 40.87 TO UPPER LEFT HAND CORNER OF VAPOR BARRIER STIFFENER LBL 24.9. **SUPPLEMENTAL REPORT FOR (AALA202408307795): DRILLESDR AALA202409055512Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT ON SEAT 14C IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR (AALA202408305512): UPON FURTHER INSPECTION FOUND TO BE IFE LIGHT. REMOVED AND REPLACED IFE LIGHT SEAT ASSY. IN REF TO AMM 44-30-00**(CLOSED).SDR AALA202409052739Wire · brokenAIRCRAFT WAS GROUNDED: ON LANDING WITHOUT ANY MANUAL BRAKE INPUT THE AUTO BRAKE DISARM LIGHT AND ANTI-SKID INOPERATIVE LIGHTS ILLUMINATED.**SUPPLEMENTAL REPORT FOR (AALA202408302739): FOUND WIRES BROKEN IN RIGHT HAND WHELL WELL PLUG D932 ANTI-SKID VALVE. REPLASDR AALA202408302739Brake Sys · malfunctionedAIRCRAFT WAS GROUNDED: ON LANDING WITHOUT ANY MANUAL BRAKE INPUT THE AUTO BRAKE DISARM LIGHT AND ANTI-SKID INOPERATIVE LIGHTS ILLUMINATED.**SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408307795Vapor Barrier · crackedAIRCRAFT WAS GROUNDED: LEFT HAND WING VAPOR BARRIER IS CRACKED APPROX 16.5" LONG STARTING APPROX 5.8" LEFT LOWER CENTER FROM STIFFENER LBL 40.87 TO UPPER LEFT HAND CORNER OF VAPOR BARRIER STIFFENER LBL 24.9. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408305512Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY ESCAPE PATH LIGHT ON SEAT 14C IS INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202408301896Slide · not reportedAIRCRAFT IN BASE MAINTENANCE: R1 SLIDE NEEDS TO BE REPLACED. R1 SLIDE REPLACED. PER AMM 25-66-01.SDR AALA202408302987Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY AISLE LIGHT FELL OFF DURING CLIMB OUT. REINSTALLED EMERGENCY AISLE LIGHT ASSEMBLY. PER AMM 33-51-03.SDR AALA202408309153Door Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED FORWARD LAVATORY DOOR LATCH.SDR AALA202408300319Lamp · no testAIRCRAFT WAS NOT GROUNDED: DURING PS CHECK FOUND L2 DOOR SLIDE EMERGENCY LIGHT INOPERATIVE. REMOVE AND REPLACE L2 DOOR SLIDE OVERWING LIGHT LAMP. PER AMM 33-51-04.SDR AALA202409235617Longeron · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LONGERON AT STA 947 PLUS 1 INCH, S26L. REPAIRED LONGERON PER EA 357720.SDR AALA202409166184Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 797 TO STA 767, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202409115018Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION SHIELD FROM STA 767 TO STA 787, S25R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202409111394Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) AT LAVATORY MOUNT AT STA 947, LBL 24. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R REPAIR 5.SDR AALA202409113150Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR INTERCOSTAL AT LAVATORY MOUNT AT STA 947, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409116932Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT LAVATORY MOUNT AT STA 947, LBL 24. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409117351Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL AT STA 947, LBL 24. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202409117687Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL AT STA 947, RBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202409116210Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBOARD SUPPORT AT STA 947, FROM RBL 17 TO RBL 24. REPLACED SUPPORT PER AARD 51-00-05-1.SDR AALA202409111066Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL FROM STA 318 TO STA 328, LBL 48. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202409113355Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE; CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727 TO STA 807, S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202408307534Anti-Skid Sys · faultyAIRCRAFT WAS NOT GROUNDED: ON LANDING AUTO BRAKES DID NOT FUNCTION. AUTO BRAKE DISARM LIGHT ILLUMINATED IMMEDIATELY. REMOVED AND REPLACED ANTI-SKID AUTO BRAKE CONTROL UNIT. PER AMM 32-42-21.
Back to Boeing 737-823