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 AALA202307068760Track · lack of lubeAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR IS DIFFICULT TO OPEN DUE TO BEING STUCK AT BOTTOM. LUBRICATED DOOR TRACK PER AMM 52-00-00.SDR AALA202307051638Roll Pin · stickingAIRCRAFT WAS NOT GROUNDED: LOUD HUMMING NOISE THROUGHOUT FLIGHT AFT LEFT DOOR. FOUND ROLL PIN STICKING OUT OF THE TOP FORWARD UPPER FLAPPER DOOR. SECURED PIN. OPERATION AND LEAK CHECK GOOD.SDR AALA202307058990Panel · out of positionAIRCRAFT WAS NOT GROUNDED: COCKPIT DOOR ESCAPE PANEL OUT OF PROPER POSITION. SECURED LOWER PANEL, UPPER HALF.SDR AALA202307057255Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT MAIN FRAME FORWARD SIDE LOCATED AT BS 927 FROM S20R TO S22R. REPAIRED FRAME PER EA EA345591.SDR AALA202307054953Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING SPAR SHEAR FITTING LOCATED AT BS 545 AND RBL12. REPLACED SHEAR FITTING PER AARD 57-14-00-1.SDR AALA202307058779Spring · vibrationAIRCRAFT WAS GROUNDED: CREW REPORTS VIBRATIONS AT L1 DOOR DURING FLIGHT. UPON ARRIVAL AT AIRCRAFT EXTERIOR HANDLE WILL NOT STAY STOWED. REPLACED L1 HANDLE SPRING ASSEMBLY.SDR AALA202307053932Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: DURING AIRCRAFT REPOSITION FLIGHT TO VQQ FOR SCHEDULED MAINTENANCE THE FLIGHT CREW REPORTED THAT THE FORWARD LAVATORY SMOKE DETECTOR ALERTED ON DESCENT INTO KVQQ AND REMAINED ON AFTER LANDING, NO SMOKE EVIDENT. **SUPPLEMENTAL REPOSDR AALA202307057764Retainer · missingAIRCRAFT WAS NOT GROUNDED: RETAINING SLEEVE MISSING FROM GIRT BAR ON DOOR 1R. REINSTALLED RETAINING SLEEVE ON 1R GIRT BAR IAW AMM 25-66-01.SDR AALA202307038090Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR DIFFICULT TO OPEN/CLOSE COCKPIT TURN KNOB DIFFICULT TO ROTATE. CLEANED AND LUBRICATED COCKPIT DOOR.SDR AALA202307035060Adiru · unserviceableAIRCRAFT WAS GROUNDED: ON DESCENT, CAPTAINÏ¿½S AND FIRST OFFICERÏ¿½S AIRSPEED DID NOT MATCH. ALSO LOST FLIGHT DIRECTORS. EMERGENCY DECLARED; FLIGHT DIVERTED TO JFK LANDING SAFELY. MAINTENANCE REPLACED LEFT AIR DATA INERTIAL REFERENCE UNIT (ADIRU) PER AMM 34-21SDR AALA202307055895Latch · lack of lubeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK MAKES IT DIFFICULT TO OPEN DOOR. LUBRICATED LATCH AFT LEFT LAVATORY.SDR AALA202307058567Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT AT BS 993 AND RBL 41. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA202307053391Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT AT BS 993 AND RBL 41. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA202307039812Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM AT BS 986.5 AND LBL 44. REPAIRED FLOOR BEAM PER SRM 53-70-51.SDR AALA202307033033Tiller · out of positionAIRCRAFT WAS NOT GROUNDED: STEERING TILLER FELL OFF AFTER TAKE OFF. EMERGENCY DECLARED; FLIGHT RETURNED TO CLT LANDING SAFELY. MAINTENANCE TIGHTENED TILLER BOLT PER AMM 32-51-41.SDR AALA202307036591Spring · out of positionAIRCRAFT WAS GROUDNED: WHEN PARKING AT GATE THE GATE AGENT SAID THAT THE OUTSIDE HANDLE WAS 90 DEGREES FROM STOWED POSITION FOR THE FORWARD ENTRY DOOR. REPLACED HANDLE SHAFT SPRING.SDR AALA202307037964Battery Pack · inoperativeAIRCRAFT WAS GROUNDED: SEAT MOUNTED PROXIMITY LIGHT FROM 26 TO 33 FAIL THE CAPACITY FUNCTIONAL CHECK. REMOVED AND REPLACED BATTERY PACK POWER SUPPLY M01673.SDR AALA202307031670Battery Pack · dischargedAIRCRAFT WAS GROUNDED: L1 ENTRANCE EMERGENCY LIGHT AND SIGN FAIL THE CAPACITY FUNCTIONAL CHECK PER JOB CARD 09C20033002. ACCOMPLISHED DEEP CYCLE OF BATTERY PACKS PER AMM 33-51-06-600-801. ACCOMPLISHED SATISFACTORY EMERGENCY LIGHTS BATTERY PACK CAPACITY FUNCTIOSDR AALA202307034950Battery Pack · dischargedAIRCRAFT WAS GROUNDED: RIGHT OVER WING ESCAPE EMERGENCY LIGHT AND SIGN FAIL THE CAPACITY FUNCTIONAL CHECK PER JOB CARD 09C20033002. ACCOMPLISHED DEEP CYCLE OF BATTERY PACKS PER AMM 33-51-06-600-801. ACCOMPLISHED SATISFACTORY EMERGENCY LIGHTS BATTERY PACK CAPACSDR AALA202307033263Hose · leakingAIRCRAFT WAS GROUNDED: AIRSPEED DISAGREE AFTER TAKEOFF. EMERGENCY DECLARED; FLIGHT RETURNED TO SAP LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202306307478: MAINTENANCE REPLACED THE INTEGRATED STANDBY FLIGHT DISPLAY PER AMM 34-24-02 (AALA202306307478) AND RESDR AALA202307037478Unknown · faultyAIRCRAFT WAS GROUNDED: AIRSPEED DISAGREE AFTER TAKEOFF. EMERGENCY DECLARED; FLIGHT RETURNED TO SAP LANDING SAFELY. **SUPPLEMENTAL REPORT FOR AALA202306307478: MAINTENANCE REPLACED THE INTEGRATED STANDBY FLIGHT DISPLAY PER AMM 34-24-02 (AALA202306307478) AND RESDR AALA202307038286Indicator · false indicationAIRCRAFT WAS GROUNDED: LEADING EDGE FLAPS TRANSIT LIGHT STAYS ON WITH FLAP HANDLE EXTENDED. MANUALLY EXTENDED FLAPS. EMERGENCY DECLARED; FLIGHT LANDED SAFELY AT ORD. **SUPPLEMENTAL REPORT FOR AALA202306308286: REPLACED FLAP POSITION INDICATOR PER AMM 27-58-02SDR AALA202307037731Windshield · crackedAIRCRAFT WAS GROUNDED: R1 WINDSHIELD CRACKED IN FLIGHT. REPLACED R1 WINDSHIELD PER JOB CARD 08L21056004.SDR AALA202306307478Unknown · unknownAIRCRAFT WAS GROUNDED: AIRSPEED DISAGREE AFTER TAKEOFF. EMERGENCY DECLARED; FLIGHT RETURNED TO SAP LANDING SAFELY. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306308286Unknown · unknownAIRCRAFT WAS GROUNDED: LEADING EDGE FLAPS TRANSIT LIGHT STAYS ON WITH FLAP HANDLE EXTENDED. MANUALLY EXTENDED FLAPS. EMERGENCY DECLARED; FLIGHT LANDED SAFELY AT ORD. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306306619Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FLOOR BEAM UPPER T CHORD. LOCATED AT BS 986.5 FROM LBL 32.0 TO RBL 32.0. REPAIRED T CHORD PER SRM 53-70-51-2 PROCEDURE 4 TABLE 201.SDR AALA202306304390Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN UPPER SURFACE OF INTERCOSTAL LOCATED AT BS 287 AND BL 0. REPAIRED INTERCOSTAL PER DWG 141A5410 REV U.SDR AALA202306305230Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FLASHLIGHT AT FLIGHT ATTENDANT SEAT 1R BATTERY DEAD. REPLACED FLASHLIGHT BATTTERY AT FLIGHT ATTENDANT SEAT 1R.SDR AALA202307133988Shade · tornAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT WINDOW SHADE AT 17A WILL NOT STAY UP / TORN. REPLACED WINDOW SHADE AT 17A PER AMM 25-21-12.** (CLOSED)SDR AALA202307030757Channel · out of positionAIRCRAFT WAS NOT GROUNDED: LAVATORY D ENTRY DOOR DIFFICULT TO OPEN OR CLOSE. TIGHTENED LAVATORY D ENTRY DOOR UPPER FRAME CHANNEL.SDR AALA202307030127Hinge · unsecureAIRCRAFT WAS NOT GROUNDED: FIRST CLASS LAVATORY DOOR STICKS WHEN OPENING / CLOSING. SECURED DOOR LAVATORY HINGE PER CMM 25-40-61.SDR AALA202306303988Unknown · unknownAIRCRAFT WAS NOT GROUNDED: OVER WING EMERGENCY EXIT WINDOW SHADE AT 17A WILL NOT STAY UP / TORN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202306295147Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306299017Fitting · 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 SRM 57-14-001 PROCEDURESDR AALA202306292240Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306290109Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306293205Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306292566Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306297325Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306299269Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1SDR AALA202306294823Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202306292162Fitting · 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 SRM 57-14-001 PROCEDURE REPAIR 1.SDR AALA202307149630Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBOARD SUPPORT LOCATED FROM BS 947 TO BS 967 AT LBL 25. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA202307142796Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT LBL 45.6. REPLACED INTERCOSTAL PER AARD 51-00-01-1.SDR AALA202307143491Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 45.60. REPLACED INTERCOSTAL PER AARD 51-00-01-1.SDR AALA202307144332Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL UPPER FLANGE LOCATED FROM BS 312 TO BS 328 AT RBL 31.60. REPLACED INTERCOSTAL PER AARD 51-00-01-1.SDR AALA202307031363Connecting Rod · out of adjustAIRCRAFT WAS GROUNDED: WHEN EITHER AUTOPILOT A OR B IS ENGAGED THE CONTROL COLUMN AILERON CONTROL JERKS MOMENTARILY IN A LEFT ROLLING MOTION. MAINTENANCE FOUND AUTOPILOT SYSTEM A AILERON ACTUATOR ROD ASSEMBLY OUT OF RIG. ACCOMPLISHED ACTUATOR ADJUSTMENT PER AMSDR AALA202306300626Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 241 CF DISBONDED. REPLACED FLOORBOARD PER SRM 51-20-01-1 AND SRM 53-00-50-2R.SDR AALA202306302659Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOOR PANEL 232RF IS DELAMINATED. REPLACED FLOOR PANEL.SDR AALA202306292844Fitting · 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 AND SRM 51-40-02.
Back to Boeing 737-823