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 AALA202309129749Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY LOCATED AT BS 540 AND LBL 2. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202309129356Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE BREAK ASSEMBLY LOCATED AT BS 540 AND RBL 2. REPLACED BREAK ASSEMBLY PER AARD 51-00-05-1.SDR AALA202309115301Mechanism · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN. CLEANED AND LUBRICATED DOOR LOCK MECHANISM AT LEFT AFT LAVATORY DOOR.SDR AALA202309115961Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT IS INOPERATIVE FROM 25ABC TO 33. REMOVED AND REPLACE EMERGENCY LIGHTING POWER SUPPLY M01672 PER AMM 33-51-06-960-806.SDR AALA202309273085Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I AT LBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02 AND AARD 51-00-05.SDR AALA202309276362Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I AT RBL 26. REPLACED TRANSITION PANEL PER AARDSDR AALA202309110531Door Latch · jammedAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR IS JAMMED CLOSED. MAINTENANCE ADJUSTED DOOR SWITCH ASSEMBLY.SDR AALA202309081320Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. LUBED HINGES.SDR AALA202310065066Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED AT BS 767, RBL 26. REPLACED TRANSITION PANEL PER SRM 51-10-02.SDR AALA202309283178Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED AT BS 727D AND RBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202309289372Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL LOCATED FROM BS 727B TO BS 727H AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53.SDR AALA202309286469Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED AT BS 966, LBL 49. REPLACED INTERCOSTAL PER AARD 51-00-05-1 AND SRM 51-40-02.SDR AALA202309280265Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 947 TO BS 967, FROM LBL 23 TO LBL 26. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202309288458Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD LOCATED AT BS 986.5, FROM LBL 42 TO LBL 43. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-6.SDR AALA202309289074Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD LOCATED AT BS 947, FROM LBL 52 TO LBL 54. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA202309283959Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 927 TO BS 947, FROM LBL 50 TO LBL 52. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202309273304Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD, LOCATED AT BS 986.5 BETWEEN RBL 42 AND RBL 43. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-6, ALTERNATIVE 3.SDR AALA202309273352Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CREASE ANGLE BELOW L2 DOOR LOCATED FROM BS 942 TO BS 992 AT WL 208. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202309273702Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD LOCATED AT BS 947 BETWEEN BL 0 AND LBL 24. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA202309272130Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD LOCATED AT BS 947 BETWEEN BL 0 AND RBL 4. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA202309121422Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION SHIELD LOCATED FROM BS 767 TO BS 787, S25R, RBL 23. REPLACED TRANSITION SHIELD PER AARD 51-00-05-1.SDR AALA202309086141Screw · unsecureAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE AND GETS STUCK. RESECURED LOOSE SCREW ON GUIDE ROLLER PER AMM 25-40-65.SDR AALA202309071861Girt Bar · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LEFT SLIDE GRIT BAR CLIP LOOSE. INSPECTED AND RESECURED L1 DOOR GRIT BAR AND GRIT BAR CLIP. PER AMM 25-66-02.SDR AALA202309077582Gust Lock · lack of lubeAIRCRAFT WAS GROUNDED: L1 DOOR GUST LOCK REQUIRES 40LBS OF DOWNWARD PRESSURE TO ACTUATE. CLEANED AND LUBED UPPER GUIDE ARM PER CMM 52-17-05.SDR AALA202309076684Handle · unsecureAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR HANDLE FELL OFF INSIDE AND OUTSIDE OF THE DOOR. RESECURED DOOR HANDLE.SDR AALA202310235392Fitting · 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 AALA202310230275Fitting · 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 AALA202310238845Fitting · 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 AALA202310238877Fitting · 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 AALA202310236343Fitting · 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 AALA202310236628Fitting · 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 AALA202310236086Fitting · 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 AALA202310232560Fitting · 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 AALA202310234486Fitting · 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 AALA202310233621Fitting · 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 AALA202309215161Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 147.9. REPLACED RIB PER AARD 51-00-05-1 AND DWG 182A5401.SDR AALA202309214357Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, LOCATED AT STABILIZER STA 138.7. REPLACED RIB PER AARD 51-00-05-1 AND DWG 182A5306.SDR AALA202309206148Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.9, 17 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202309205786Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 9 INCHES FORWARD OF AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202309200375Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 138.7, 9 INCHES AFT OF FORWARD SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202309128554Overheat Sensor · false indicationAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED AND THE AIRCRAFT DIVERTED TO ORD DUE TO LEFT ENGINE OVERHEAT DETECTOR LIGHT ILLUMINATED IN BOTH A AND B POSITIONS. FLIGHT LANDED SAFELY AT ORD WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED LEFT ENGINE UPPER FANSDR AALA202309080300Filter · faultedAIRCRAFT 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 FOR AALA202309050300: MAINTENANCE FOUND MESSASDR AALA202309088310Filter · faultedAIRCRAFT 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 FOR AALA202309050300: MAINTENANCE FOUND MESSASDR AALA202309088545Pressure Switch · faultedAIRCRAFT 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 FOR AALA202309050300: MAINTENANCE FOUND MESSASDR AALA202309084103Pressure Switch · faultedAIRCRAFT 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 FOR AALA202309050300: MAINTENANCE FOUND MESSASDR AALA202309071586Oven · odorAIRCRAFT WAS NOT GROUNDED: NUMBER 1 OVEN IN FORWARD GALLEY HAS A MILD ELECTRICAL BURNING SMELL. REMOVED AND REPLACED NUMBER 1 OVEN. PER AMM 25-32-02.OPS.SDR AALA202309069548Control Rod · out of adjustAIRCRAFT WAS GROUNDED: REJECTED TAKEOFF DUE TO MAIN CREW DOOR LITE CAME ON AT APPROXIMATELY 84 KNOTS. MAINTENANCE ADJUSTED HORIZONTAL CONTROL ROD ON LEFT HAND ENTRY DOOR.SDR AALA202309067408Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE AND HARD TO LOCK. LUBRICATED HINGES AND LOCK ON AFT LEFT LAVATORY DOOR PER AMM 25-40-00.SDR AALA202309069581Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR LATCH IS HARD TO OPEN FROM THE INSIDE. ADJUSTED AS NEEDED PER AMM 25-40-11.SDR AALA202309061896Gust Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: DOOR 1L GUST LOCK WILL NOT STAY ENGAGED. LUBRICATED 1L DOOR GUST LOCK PER AMM 52-11-00.
Back to Boeing 737-823