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 AALA202412105380Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL LOCATED BETWEEN STA 727E + 12 INCHES AND 727G + 10 INCHES, AT S26L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5 REPAIR 5.SDR AALA202412200352Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 927 AND BS 947 AT RBL 16. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202412183113Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED FROM STA 328 TO STA 344, LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412184993Floor Support · crackedAIRCRAFT WAS GROUNDED: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN STA 276 TO STA 294, AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412180505Floor Support · crackedAIRCRAFT WAS GROUNDED: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN STA 312 TO STA 328, AT LBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412176903Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL LOCATED FROM STA 328 TO STA 344 AT LBL 51. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA202412158383Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL LOCATED BETWEEN STA 312 AND STA 320 AT RBL 38. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412114313Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE.**SUPPLEMENTAL REPORT FOR (AALA202412094313): RELAMPED, OPERTIONAL CHECK. PER AMM 33-51-04**(CLOSED).SDR AALA202412098366Oven · fodAIRCRAFT WAS NOT GROUNDED: LEFT OVEN SMELLS STRONGLY OF BURNING PLASTIC. REMOVED AND REPLACED FORWARD GALLEY NUMBER 1 OVEN. OPERTIONAL CHECK GOOD NO MORE SMELL. PER AMM 25-33-00.SDR AALA202412093102Door · unsecureAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR BINDS ON DOOR FRAME IN FLIGHT DIFFICULT TO OPEN AND CLOSE. RESECURED LOOSE SCREWS ON TRANSITION PLATE. OPERTIONAL CHECK GOOD.SDR AALA202412099248Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT SEAT 8C DETACHED. REATTACHED 8C EMERGENCY LIGHT ASSEMBLY. PER AMM 33-51-11.SDR AALA202412090507Light · dislodgedAIRCRAFT WAS NOT GROUNDED: 15C EMERGENCY PANEL HAS POPPED OFF AND IS NOT ILLUMINATING. SECURED SEAT MOUNTED FLOOR LIGHTING EMERGENCY LIGHT AND COVER ASREQUIRED AT SEAT 15C. PROPER FUNCTION VERIFIED. PER STANDARD PRACTICES OF GPM 02-01-2.SDR AALA202412090483Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT RIGHT DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. RELAMPED AFT RIGHT DOOR EXTEROIR EMERGENCY EXIT LIGHT. PER AMM 33-51-04.SDR AALA202412094313Light · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT DOOR EXTERIOR EMERGENCY EXIT LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202412097330Module · shortedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLOOD LIGHTS STARTED FLICKERING MOMENTARILY. SMOKE FILLED THE COCKPIT, FLOOD LIGHTS EXTINGUISHED. FLOOD LIGHT CIRCUIT BREAKER CONT AND FLOOD LIGHT STBY CIRCUIT BREAKER POPPED; AIRCRAFT DIVERTED TO AND LASDR AALA202501095108Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, LBL 4. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202501090938Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947, RBL 4. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202501091160Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 5OOG AND STA 500I, AT RBL 30. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202501095191Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 500A AND STA 500G, AT RBL 30. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202501096541Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 500E AND STA 500I, AT LBL 30. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202412199921Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 500I TO BS 520, BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412189545Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM UPPER CHORD (T-CAP) AT STA 986, LBL 48. REPAIRED CHORD PER SRM 53-70-51-2R-6 ALTERNATIVE 4.SDR AALA202412097347Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR DOES NOT CLOSE AND OPEN PROPERLY. LUBRICATED AFT LEFT LAVATORY DOOR TRACK AS REQUIRED. PER AMM 52-50-00.SDR AALA202412099450Unknown · odorAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: A STRONG ODOR LIKE BURNING WIRE THROUGHOUT THE ENTIRE PLANE, NO SMOKE SEEN; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT ORD. COMPLIED WITH JOB CARD 08L00021001. NO FINDINGS. PERFORMED PACK BURNSDR AALA202412105894Control Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT SIDE RAM AIR INLET MODULATION PANEL LOCATED FROM STA 500I TO STA 520, FROM S22L TO S24L. REPLACED PANEL PER SRM 51-40-02-0G.SDR AALA202412101403Fitting · 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 AALA202412106339Fitting · 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 AALA202412109003Fitting · 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 AALA202412105787Fitting · 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 AALA202412102636Fitting · 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 AALA202412108591Fitting · 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 AALA202412103933Fitting · 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 AALA202412109639Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202412090414Door · looseAIRCRAFT WAS NOT GROUNDED: AFTER LEFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. FOUND SCREW COMING LOOSE ON TOP TRACK INTERFERING WITH DOOR ROLLER, TIGHTEN SCREW, OPERTIONAL CHECK GOOD.SDR AALA202412093208Slide · no testAIRCRAFT IN BASE MAINTENANCE: R2 EMERGENCY ESCAPE SLIDE LATCH RELEASE TEST FAILED. REMOVE AND REPLACED SLIDE.SDR AALA202412096278Slide · no testAIRCRAFT IN BASE MAINTENANCE: L2 EMERGENCY ESCAPE SLIDE LATCH RELEASE TEST FAILED. REMOVED AND REPALCED SLIDE.SDR AALA202412094182Starter · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: DURING CRUISE ENGINE OIL FOR LEFT ENGINE DROPPED FROM 8 TO 5 QTS AND LOW QUANTITY INDUCATION ILLUMINATED AS WELL; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT ELP. OPENED UP ENINGE NUMBER 1 FOUND COWLINSDR AALA202412108278Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED LOCATED AT STABILIZER STA 101.90, 27 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202412065800Slide · out of positionAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANTS REPORTED THAT FORWARD GALLERY SERVICE DOOR INFLATABLE SLIDE HAS MATERIAL DRAGGING ON FLOOR IN A WAY THAT IS NOT NORMALLY SEEN. REINSTALLED FORWRD GALLEY SERVICE DOOR SLIDE. PER AMM 52-20-00.SDR AALA202412067441Sign · detachedAIRCRAFT WAS NOT GROUNDED: EXIT ROW EXIT SIGN FELL OFF. ADJUSTED EXIT ROW SIGN AS NEEDED. PER AMM 33-51-02.SDR AALA202412067262Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD SERVICE DOOR IS DIFFICULT TO ARM AND DISARM. ADJUSTED FORWARD SERVICE DOOR GIRT BAR CLIPS. OPERTIONAL CHECK GOOD. PER GPM 17-11.SDR AALA202412055229Fitting · 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 AALA202412053947Fitting · 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 AALA202412059632Fitting · 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 AALA202412185761Skin · corrodedAIRCRAFT WAS GROUNDED: FOUND DELAMINATION AND EXFOLIATION DUE TO CORROSION WITH THE FOLLOWING DIMENSIONS. 1 INCH WIDE FROM EDGE SKIN TO FORWARD, 5.250 INCHES LONG FROM INBOARD TO OUTBOARD, AND DEPTH 100 % (VERTICAL AXIS) EQUAL TO THE SKIN THICKNESS. 10 INCHES SDR AALA202412187607Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR THRESHOLD SUPPORT ANGLE AT STA 294.5, RBL 57. REPLACED SUPPORT ANGLE PER SRM 51-40-01-0G.SDR AALA202412186570Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL BETWEEN STA 947 AND STA 967, AT RBL 50. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202412169904Skin · delaminatedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND WING OUTBOARD AFT FLAP INBOARD UPPER SURFACE HAS DELAMINATION ACCOMPLISHED PERMANENT REPAIR ON LEFT HAND WING OUTBOARD AFT FLAP INBOARD UPPER SURFACE. PER B737-NG SRM 57-53-01-2R-14, SRM 51-70-10-2R REPAIR GENERAL, AND SSDR AALA202412064178Anti-Ice Valve · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENIGNE NUMBER 1 ANTI-ICE FAILED WHILE DESCENDING INTO ICING CONDITIONS, HAD TO SHUTDOWN NUMBER 1 ENGINE AS WELL; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT BWI. **SUPPLEMENTAL REPORT FOR (AALA202412054178SDR AALA202412055572Tire · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: NUMBER 2 TIRE BLOWN ON; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT PHX. REMOVE AND REPLACED NUMBER 2 TIRE.
Back to Boeing 737-823