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 AALA2020024219004Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STATION 138, 9 INCHES AFT OF THE LEADING EDGE. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA2020024219002Skin · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN CRACKED AT STATION 100, 37 INCHES AFT OF THE LEADING EDGE. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA2020022059002Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED AT BS 663 BETWEEN RBL 24 AND RBL 36. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9R9 AND SRM 57-10-10-2R2.SDR AALA202002179013Retainer · missingAIRCRAFT IN BASE MAINTENANCE: LEFT HAND OVERWING HATCH ESCAPE ROPE RED VELCRO STRAP RETAINER MISSING. REPLACED RETAINER AS REQUIRED.SDR AALA2020021769011Slide · dislodgedAIRCRAFT WAS NOT GROUNDED: R1 DOOR SLIDE CAME OFF OF HOUSING UPON OPENING DOOR. FOUND R1 DOOR SLIDE DISLODGED AND RESURED SLIDE AS REQUIRED.SDR AALA2020021769017Window · out of positionAIRCRAFT WAS NOT GROUNDED: R2 SIDE WINDOW CAME OUT OF TRACKS AS WINDOW WAS BEING CLOSED. MAINTENANCE REINSTALLED R2 WINDOW PER AMM 56-12-11.SDR AALA2020021769016Window · bindingAIRCRAFT WAS NOT GROUNDED: FIRST OFFICERS SLIDING WINDOW LEVER TRIGGER DID NOT FULLY EXTEND WHEN WINDOW WAS CLOSED, MAY NOT LATCH PROPERLY. MAINTENANCE CLEANED AND LUBED WINDOW TRACK AND PERFORMED SATISAFACTORY OPERATIONAL CHECK PER AMM 56-11-00.SDR AALA2020032189027Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSIONN ON AFT CABIN FLOOR SHEAR WEB AT BS 990 AND RBL 34. REPAIRED FLOOR SHEAR WEB PER SRM 51-70-13-1R-4 AND EA 303553. **SUPPLEMENTAL REPORT TO CHANGE SECTION 7 CORROSION LEVEL TO REFLECT 2**SDR AALA2020032489023Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN SUPPORT ANGLE AT BS 1013 AND LBL 34. REPLACED SUPPORT ANGLE PER AARD 51-00-05.SDR AALA2020032489022Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR LEFT HAND CREASE ANGLE BETWEEN BS 949 AND 992. REPLACED CREASE ANGLE PER AARD 51-00-05.SDR AALA2020032489018Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CABIN FLOOR CREASE ANGLE BETWEEN BS 304 AND BS 344 BETWEEN LBL 54- AND LBL 60. REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA202002259033Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR CUT OUT THRESHOLD SUPPORT BETWEEN BS 321 AND BS 338 AT RBL 58. REPLACED SUPPORT PER SRM 51-40-02.SDR AALA202002259032Shear Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA FLOOR SHEAR WEB AT BS 986.5 AND LBL 33. REPAIRED SHEAR WEB PER EA 303378.SDR AALA202002149002Window · crackedAIRCRAFT WAS GROUNDED: FLIGHT DECK L2 WINDOW OUTER PANE CRACKED. REPLACED WINDOW PER AMM 56-94-01 AND TASK CARD 08L21056001.SDR AALA2020032489025Support Bracket · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR SUPPORT BRACKET AT BS 500I BETWEEN LBL 24 AND RBL 24. REMOVED CORROSION PER SRM 51-10-02 AND 53-00-53, TREATED, PRIMED AND PAINTED BRACKET PER SRM 51-20-01.SDR AALA2020032489020Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 747 AND BS 767 AT S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA2020032489014Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 492 AND BS 495 AT RBL 26. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA2020022049037Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN WET AREA Z ANGLE AT BS 992 BETWEEN RBL 32 AND RBL 42. REPLACED Z ANGLE PER AARD 51-00-05-1.SDR AALA2020022049034Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKEDC CABIN FLOOR INTERCOSTAL AT BS 355 AND LBL 2. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202002204044Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR SUPPORT AT BS 537 AND RBL 24. REPLACED FLOOR SUPPORT PER AARD 51-00-05SDR AALA202002129020Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED AT BS 663 AND LBL 28. REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R REPAIR 2 AND AARD 57-10-10-9 REPAIR 9.SDR AALA2020030369007Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL SHIELD BETWEEN BS 420 AND BS 440 AT RBL 24. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA2020021109042Pressure Switch · faultyAIRCRAFT NOT GROUNDED: AUTO BRAKE DISARM LIGHT ILLUMINATED AT TOUCHDOWN WHILE SET AT 3. REMOVED AND REPLACED LH RUDDER PEDAL PRESSURE SWITCHES IAW MM 32-42-71.SDR AALA2020021109045Control Valve · faultyAIRCRAFT WAS GROUNDED: AIR RETURNED TO CLT, BLEED TRIP OFF AT CLIMB POWER. RESET FIRST TIME, HAPPENED AGAIN BUT WOULDNT RESET. CABIN ALTITUDE INCREASED TO ABOUT 17,000 WITH HORN. MASKS DID NOT DEPLOY AND WE DESCENDED. EMERGENCY DECLARED. TROUBLE SHOT IAW FIM SDR AALA2020021109059Anti-Ice Valve · faultyAIRCRAFT WAS GROUNDED: AIR INTERRUPTED BACK TO DFW AT 390 R/H COWL ANTI-ICE CMAE ON. RAN THE CHECKLIST LIGHT, DID NOT EXTINGUISH. DECLARED AN EMERGENCY. REMOVED AND REPLACED # 2 ENGINE COWL ANTI-ICE VALVE IAW AMM 30-21-11. SECURE CONNECTOR ENG.ANTI - ICE ON #2SDR AALA202002119015Pressure Switch · faultyAIRCRAFT NOT GROUNDED: AUTO BRAKE DISARM LIGHT ILLUMINATED AT TOUCHDOWN WHILE SET AT 3. REMOVED AND REPLACED RH RUDDER PEDAL PRESSURE SWITCH IAW MM 32-42-71.SDR AALA2020021109035Door · bindingAIRCRAFT WAS NOT GROUNDED: AFT LEFT DOOR JAMMED, CANNOT OPEN. MAINTENANCE PERFORMED SATISFACTORY OPERATIONAL CHECK OF DOOR PER AMM 52-13-00.SDR AALA2020021109030Slide · faultyAIRCRAFT WAS NOT GROUNDED: DOOR L1 SLIDE WAS ARMED WHEN DOOR WAS OPENED. SLIDE DID NOT DEPLOY. MAINTENANCE REINSTALLED SLIDE PACK PER AMM 25-66-01.SDR AALA2020021109036Motor · faultyAIRCRAFT NOT GROUNDED: AUTO-THROTTLE UNCOMMANDED DISCONNECT WITH RED LIGHT FLASHING. ATTEMPTED RECONNECT FAILED. REMOVED AND REPLACED LEFT AUTOTHROTTLE SERVO MOTOR IAW AMM 22-31-91.SDR AALA2020021109046Outflow Valve · malfunctionedAIRCRAFT WAS GROUNDED: AIR INTERRUPTED INTO SMF ACCOUNT PRESSURIZATION ISSUE.ON CLIMBOUT ONLY 1 DIFFERENTIAL PRESSURE. OUTFLOW VALVE NOT FULLY CLOSED. LEVELED OFF AT 13,000 THEN CABIN ALTITUDE REACHED 10,000. WARNING SOUNDED. O2 UTILIZED. APU BLEED AIR ADDED.SDR AALA2020021109054Trim Motor · failedAIRCRAFT WAS GROUNDED: DIVERTED JFK ACCOUNT FLAP OVERSPEED STABILIZER TRIM ISSUE. STABILIZER TRIM INOPERATIVE. ON GO AROUND STAB TRIM FAILED. COMPLIED WITH QRH PROCEDURE - STAB TRIM, CUT-OUT SWITCHES LEFT IN CUT-OUT. EMERGENCY DEALARED. REMOVED AND REPLACED STSDR AALA2020022049031Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 500A AND BS 500B AT LBL 26. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5, AARD 51-00-05, SRM 51-40-02.SDR AALA202002109031Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT OVERWING AFT EMERGENCY LIGHT INOPERATIVE. MAINTENANCE RELAMPED LIGHT PER AMM 3-51-04.SDR AALA2020022049028Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL AT BS 312 AND LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1SDR AALA2020021329028Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CABIN FLOOR INTERCOSTAL AT BS 321 AND LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA202002109048Receptacle · faultyAIRCRAFT WAS GROUNDED: FA REPORTS OUTSIDE MAIN DOOR AIRCRAFT SKIN GIVING ELECTRIC SHOCKS. REPLACED EXTERNAL PWR RECEPTACLE PER AMM 24-42-11.SDR AALA202002079010Warning Light · false activationAIRCRAFT WAS NOT GROUNDED: LAVATORY SMOKE LIGHT CAME ON IN COCKPIT AND BEEPER CAME ON IN FORWARD LAVATORY, DURING CRUISE. ALL INDICATIONS WENT OUT, CEASED, WITHIN ABOUT 10 SECONDS. NO SMELL, HEAT, OR SMOKE PRESENT IN FORWARD LAVATORY. MAINTENANCE PERFORMED SATSDR AALA2020030369011Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT AFT BAFFLE CLIP AT BS 500H AND S26R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2020030369010Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT FORWARD BAFFLE CLIP AT BS 500H AND S26R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2020030369009Stringer Clip · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT STRINGER CLIP AT BS 500I AND S26R. REPLACED STRINGER CLIP PER AARD 51-00-05-1.SDR AALA2020022049030Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT FORWARD BAFFLE CLIP AT BS 500H AND S26L.REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2020022049029Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT AFT BAFFLE CLIP AT BS 500H AND S26L. REPLACED BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA2020022049052Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 927 AND BS 947 AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA2020022049049Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK FIRST OFFIICERS R1 1 WINDOW POST (C-D) UPPER OUTBOARD CORNER CRACKED AT BS 219.8 ANDS10R. REPAIRED WINDOW POST PER EA 302726.SDR AALA2020022049046Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK CAPTAINS L1 1 WINDOW POST (C-D) UPPER OUTBOARD CORNER CRACKED AT BS 219.8 ANDS10L. REPAIRED WINDOW POST PER EA 302722.SDR AALA202002069012Girt Bar · out of positionAIRCRAFT NOT GROUNDED: 1R GIRT BAR NEEDS TO BE INSPECTED. GIRT BAR WONT STAY IN BRACKET. POSITIONED GIRT BAR PROPERLY ON 1R DOOR. NO DISCREPANCIES NOTED.SDR AALA2020022049035Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM T CAP FASTENER HOLE FOR THE GIRT BAR FITTING AT BS 986 AND LBL 45. REPAIRED FLOOR BEAM PER EA 302861 AND SRM 53-70-51-2R-6.SDR AALA2020021329026Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500G AND S25R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2020021329024Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT BAFFLE CLIP AT BS 500H AND S25R. REPLACED CLIP PER AARD 51-00-05-1.SDR AALA2020020759019Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: DURING FUNCTIONAL CHECK OF EMERGENCY LIGHTS, FOUND DOOR R2 EXTERIOR LIGHT INOPERATIVE. REPLACED BULB AT R2 AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04-960-801.
Back to Boeing 737-823