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 AALA202306290441Fitting · 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-1 AND SRM 51-40-02.SDR AALA202306290965Fitting · 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 AND SRM 51-40-02.SDR AALA202306295399Fitting · 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 AND SRM 51-40-02.SDR AALA202306290485Fitting · 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 AND SRM 51-40-02.SDR AALA202306284134Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: ROW 16 EMERGENCY EXIT LIGHT TOP BULB OUT. ROW 16 EMERGENCY EXIT LIGHT BULB REPLACED PER AMM 33-51-01.SDR AALA202306288043Bulb · inoperativeAIRCRAFT IN BASE MAINTENANCE: L2 DOOR OVERHEAD EMERGENCY EXIT LIGHTS INOPERATIVE. L2 DOOR OVERHEAD EMERGENCY EXIT LIGHT BULB REPLACED PER AMM 33-51-01. PERFORMED SATISFACTORY EMERGENCY LIGHT TEST PER AMM 33-51-00-710-801.SDR AALA202306287737Release System · out of adjustAIRCRAFT IN BASE MAINTENANCE: L2 DOOR GUST LOCK RELEASE BUTTON WILL NOT STAY IN DOWN POSITION WHEN PRESSED. ADJUSTED AND SECURED L2 DOOR GUST LOCK RELEASE BUTTON PER AMM 52-13-21.SDR AALA202306279573Fitting · 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 AND SRM 51-40-02.SDR AALA202306270890Fitting · 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 AND SRM 51-40-02.SDR AALA202306273821Fitting · 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 AND SRM 51-40-02.SDR AALA202306278071Fitting · 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 AND SRM 51-40-02.SDR AALA202306278195Fitting · 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 AND SRM 51-40-02.SDR AALA202307140778Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM LOCATED AT BS 987.5, S17L, AND LBL 61. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R PROCEDURE 6 ALTERNATIVE 3.SDR AALA202307144164Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR BEAM, AROUND FASTENER HOLE, LOCATED AT 986.5, S17R, AND RBL 61. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-6.SDR AALA202307055841Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT DOOR SILL WEB LOCATED FROM BS 787TO BS 847 AT S25R. REPLACED DOOR SILL WEB PER DWG 146A8120, SRM 51-40-02 AND AARD 51-00-05-1.SDR AALA202306294126Door Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT FOR AALA202306284126: MAINTENANCE FOUND DOOR LATCH OUT OF ADJUSTMENT. ADJUSTED AND LUBRICATED DOOR LATCH PER AMM 52-50-00.** (CLOSED)SDR AALA202306280659Screw · looseAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE IN-FLIGHT. LOWER PART OF DOOR STICKS. FOUND THRESHOLD SCREW LOOSE. TIGHTENED SCREW. CHECKS NORMAL.SDR AALA202306284126Unknown · unknownAIRCRAFT WAS NOT GROUNDED: FORWARD LAVATORY DOOR DIFFICULT TO OPEN / CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306277036Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, THIRD STIFFENER LOCATED AT STAB STA 111.10. REPLACED RIB PER SRM 51-40-02-0G.SDR AALA202306277556Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, THIRD STIFFENER LOCATED AT STAB STA 111.10. REPLACED RIB PER SRM 51-40-02-0G.SDR AALA202307145460Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 747 PLUS 14 INCHES AND S26L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202306269663Door Latch · inoperativeAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR HARD TO OPEN. REMOVED AND REPLACED COCKPIT DOOR LATCH.SDR AALA202306263285Slide · tornAIRCRAFT WAS GROUNDED: L1 DOOR SLIDE GIRT HAS 2 INCH WORN AREA IN CENTER, AND 2 INCH TEAR AT AFT END. REPLACED L1 DOOR SLIDE.SDR AALA202307200702Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR TRANSITION PANEL BETWEEN BS 500A AND BS 500I AT RBL 23. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202307145804Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 767 TO BS 787 AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202307141442Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED AT BS 727C PLUS 13 INCHES AND S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202307142369Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 420 TO BS 500I AT LBL 23. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202307050116Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I AND RBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A.SDR AALA202306266129Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT WET AREA Z ANGLE LOCATED AT BS 990 AND FROM RBL 33 TO RBL 40. REPLACED ANGLE PER SRM 51-10-02.SDR AALA202306269092Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN AFT WET AREA Z ANGLE LOCATED AT BS 990 FROM LBL 33 TO LBL 40. REPLACED ANGLE PER SRM SRM 51-40-05 AND DWG 147A5700 REV B.SDR AALA202306261571Stop · missingAIRCRAFT WAS NOT GROUNDED: L2 DOOR GIRT BAR GROMMET MISSING. INSTALEED NEW STOP ASSY ON L2 DOOR GIRT BAR.SDR AALA202306264167Slide · tornAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE HAS LARGE TEAR NEAR GIRT BAR. REMOVED & REPLACED L1 DOOR EMERGENCY ESCAPE SLIDE.SDR AALA202306268491Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHTS INOPERATIVE AT SEATS 15,16 AND 17 ABC. REMOVED AND REPLACED MID CABIN EMERGENCY LIGHT POWER SUPPLY M01694.SDR AALA202306269301Shade · jammedAIRCRAFT WAS NOT GROUNDED: EXIT 16F WINDOW SHADE JAMMED. ACCOMMODATED WINDOW SHADE PER AMM 25-21-12. OK FOR SERVICE.SDR AALA202306263624Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: 1R FLASHLIGHT NOT WORKING. REPLACED FLIGHT ATTENDANT FLASHLIGHT PER AMM 25-64-00.SDR AALA202306268085Windshield · crackedAIRCRAFT WAS GROUNDED: AT 25,000 FT AND 220 KNOTS VERY BRIGHT ARCING ON FIRST OFFICERÏ¿½S FORWARD WINDSCREEN FOLLOWED BY EXTERIOR PANE CRACKING. EMERGENCY DECLARED; FLIGHT LANDED SAFELY AT MIA. MAINTENANCE REPLACED FIRST OFFICERÏ¿½S WINDSHIELD PER JOB CARD 08LSDR AALA202307050560Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT LOCATED AT BS 540 AND RBL 1. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA202306260109Unknown · unknownAIRCRAFT WAS GROUNDED: FUMES REPORTED IN CABIN. EMERGENCY DECLARED; FLIGHT DIVERTED TO DFW LANDING SAFELY. MAINTENANCE ACCOMPLISHED JOB CARD 08L00021001. NO ODOR FOUND.SDR AALA202306265692Latch Handle · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDENT REPORTS THAT L1 DOOR HANDLE REPEATIVELY KEPT POPPING UP DURING TAKEOFF, LIGHT TURBULENCE LANDING AND GROUND OPERATION APEARS TO BE LOOSE. L1 DOOR HANDLE TORQUED TO HANDLE SHAFT.SDR AALA202306232620Light · damagedAIRCRAFT WAS NOT GROUNDED: RIGHT HAND AFT GALLEY EMERGENCY EXIT SIGN LIGHT ASSEMBLY DAMAGED. REMOVED AND REPLACED RIGHT HAND GALLEY EMERGENCY EXIT SIGN LIGHT ASSEMBLY.SDR AALA202306238601Light · damagedAIRCRAFT WAS NOT GROUNDED: LEFT HAND AFT GALLEY EMERGENCY EXIT SIGN LIGHT ASSEMBLY DAMAGED. REMOVED AND REPLACED LEFT HAND GALLEY EMERGENCY EXIT SIGN LIGHT ASSEMBLY.SDR AALA202306232922Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1016 FROM RBL 16.73 TO RBL 8.39. REMOVED, FABRICATED AND INSTALLED NEW WEB PER SRM 51-40-02.SDR AALA202306231398Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 500A TO BS 500D + 10 INCHES, AT S25R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202310122374Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G. SUPPLEMENTAL REPORT FOR AALA202306232374: QC REVIEWED THIS EVENT ANSDR AALA202307056468Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOORBOARD SUPPORT LOCATED AT BS 540 AND LBL 1. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05.SDR AALA202306308784Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCED: FLOOR PANEL 242GF HAS 3 CORNERS DELAMINATED AND HONEYCOMB DAMAGE ALONG EDGES. REPAIRED FLOOR PANEL PER SRM 53-00-50-2R.SDR AALA202306230921Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN MAIN CABIN FLOOR STRUCTURE INTERCOSTAL ANGLE LOCATED FROM BS 380 TO BS 400 AT BL 0. REPLACED ANGLE PER DWG 143A5400.SDR AALA202306231165Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 420 TO BS 440 AT S25R. REMOVED, FABRICATED, AND INSTALLED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306232374Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306233952Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN LEFT HAND MOP SILL (INNER CHORD) LOCATED AT BS 640 AND LBL 64. REMOVED, FABRICATED, AND INSTALLED MOP SILL PER SRM 51-40-02-0G.
Back to Boeing 737-823