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 AALA202210247692Windshield · delaminatedAIRCRAFT WAS GROUNDED: FIRST OFFICERÏ¿½S WINDSHIELD DELAMINATED AT THE HEATING ELEMENT. REPLACED WINDOW PER JOB CARD 08L21056004SDR AALA202210244417Windshield · delaminatedAIRCRAFT WAS GROUNDED: CAPTAINÏ¿½S WINDSHIELD DELAMINATED AT THE HEATING ELEMENT. REPLACED WINDOW PER JOB CARD 08L21056003.SDR AALA202211161922Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO LEFT HAND TRANSITION PANEL CORRODED AT STA 500A TO STA 500I AND STR 25L AND LEFT BUTT LINE 23. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202211165483Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO RIGHT HAND TRANSITION PANEL CORRODED STA 500H TO STA 500I STR 25R AND RIGHT BUTT LINE 23. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202211105999Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: NUT PLACE LOCATION HOLE DAMAGE FOR CORROSION LOCATED PER STA 986 AND RIGHT BUTT LINE 44. REMOVED AND REPLACED CORROSION DAMAGED AND FABRICATED NEW PART INSTALLED PER SRM 53-70-51-2R-6.SDR AALA202211101750Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: NUT PLATE HOLE ON FLOOR BEAM DAMAGE FROM CORROSION LOCATED AT STA 986 AND LEFT BUTT LINE 44. REMOVED CORROSION DAMAGE AND FABRICATED NEW DOUBLER REPAIR PER SRM 53-70-51-2R-6.SDR AALA202211085898Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211089261Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 129.50, 17 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211080058Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211086415Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 18 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211086586Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 101.90, 27 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211081784Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 147.90, 16 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211083686Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 98, ALONG AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202211072087Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN RIGHT HAND DOOR FORWARD DRAIN SUPPORT INTERCOSTAL LOCATED AT BS 978 AND RBL 48. REPLACED INTERCOSTAL PER DWG 815A0010 AND AARD 51-00-05.SDR AALA202211074754Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN CREASE ANGLE LOCATED FROM BS 947 TO BS 1010 AT RBL 47. REPLACED CREASE ANGLE PER AARD 51-00-05 AND DWG 147A8501.SDR AALA202211047132Switch · unsecureAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED DURING CLIMB OUT AT 7 PSID. FLIGHT ATTENDANT CONFIRMED DOOR CLOSED, HANDLE DOWN, AND NO UNUSUAL NOISE. PRESSURIZATION NORMAL. LIGHT CAME ON AND WENT OUT A FEW TIMES DURING FLIGHT. INSTALLED GROMMETS SDR AALA202211045679Connector · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY LIGHT AT ROW 12DEF INOPERATIVE. REPLACED CONNECTOR ON OVERHEAD BIN EMERGENCY LIGHT AT ROW 12DEF PER SWPM 20-63-01.SDR AALA202210257766Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 120.3. REPLACED RIB PER AARD 55-10-00-2 AND SRM 51-40-02.SDR AALA202210247132Warning Message · illuminatedAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR LIGHT ILLUMINATED DURING CLIMB OUT AT 7 PSID. FLIGHT ATTENDANT CONFIRMED DOOR CLOSED, HANDLE DOWN, AND NO UNUSUAL NOISE. PRESSURIZATION NORMAL. LIGHT CAME ON AND WENT OUT A FEW TIMES DURING FLIGHT. **SUPPLEMENTAL REPORSDR AALA202210245679Light · inoperativeAIRCRAFT WAS NOT GROUNDED: OVERHEAD EMERGENCY LIGHT AT ROW 12DEF INOPERATIVE. **SUPPLEMENTAL REPORT REQUIRED** (OPEN)SDR AALA202210251009Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210259395Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 32.40. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210254860Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210258808Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210256605Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210256909Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210253669Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210213747Door · out of adjustAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR IS DIFFICULT TO CLOSE. IT JAMS AND REQUIRES A LOT OF FORCE TO GET IT TO LATCH. ADJUSTED FLIGHT DECK DOOR PER AMM 52-51-01.SDR AALA202211148365Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND FORWARD SIDE WEB INNER CHORD LOCATED FROM BS 312 TO BS 344 AT LBL 53. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202211075418Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT FIRST STIFFENER FROM THE FRONT SPAR, STABILIZER STA 129.50. REPAIRED RIB PER SRM 55-10-09-2R-4.SDR AALA202211047565Floorbeam · crackedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR PANEL SUPPORT ANGLE IS CRACKED LOCATED AT STA 540 AND RIGHT BUTT LINE 2. REMOVED AND REPLACED BOEING PART BREAK PER SRM 51-40-02-OG.SDR AALA202210215719Transceiver · false indicationAIRCRAFT WAS GROUNDED: FALSE WINDSHEAR ALERT DURING TAKEOFF ROLL. REJECTED TAKEOFF BETWEEN 90 AND 100 KNOTS. SAFELY RETURNED TO GATE. REPLACED WEATHER RADAR TRANSCEIVER PER AMM 34-43-41. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210216150Computer · faultyAIRCRAFT WAS GROUNDED: DURING CLIMB OUT SPEED LIMIT INDICATION ON CAPTAINÏ¿½S SIDE. STICK SHAKER BECAME MORE FREQUENT. FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO ATL, LANDING SAFELY. REPLACED THE STALL MANAGEMENT YAW DAMPER (SMYD) COMPUTER #1 PER AMM 27-32-4SDR AALA202210209177Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR EMERGENCY SLIDE GIRT BAR WILL NOT STAY IN DISARMED BRACKET. ADJUSTED GIRT BAR CLIP. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210207987Light · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT HOUSING AT SEAT 33C DAMAGED. REPLACED SEAT 33C SEAT MOUNTED FLOOR PROXIMITY LIGHT PER AMM 33-51-11.SDR AALA202210202081Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: R1 DOOR GIRT BAR HARD TO ARM / DISARM. ADJUSTED GIRT BAR DOOR CLIP PER AMM 25-66-01.SDR AALA202210204262Light · damagedAIRCRAFT WAS NOT GROUNDED: SEAT 10C FLOOR PROXIMITY EMERGENCY LIGHT DAMAGED. REPLACED SEAT 10C FLOOR PROXIMITY LIGHT PER AMM 33-51-11. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202210201837Vapor Barrier · crackedAIRCRAFT WAS GROUNDED: CRACK ON LOWER FORWARD BULKHEAD VAPOR BARRIER NEXT TO KEEL BEAM IN LEFT WHEEL WELL. ACCOMPLISHED REPAIR PER AARD 57-10-10-9 STEP 3.SDR AALA202210215352Control Unit · faultedAIRCRAFT WAS GROUNDED: TAKEOFF CONFIGURATION HORN SOUNDED AT 110 KNOTS DURING TAKEOFF ROLL. ABORTED TAKEOFF. REMOVED AND REPLACED FLAP/SLAT ELECTRONIC UNIT PER AMM 27-51-01.SDR AALA202211157021Shear Tie · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 339611. **SUPPLEMENTAL REPORT FOR AALA202210257021: UPDATED CRACK LOCATION TO CORRECT LOCATION SECTION 4 AND 7 UPDASDR AALA202210198463Door · stickingAIRCRAFT WAS NOT GROUNDED: AFT LAVATORY DOOR IS STICKING AND DIFFICULT TO OPEN. ADJUSTED AFT LAVATORY DOOR AS REQUIRED PER AMM 25-40-00.SDR AALA202210204997Lock · lack of lubeAIRCRAFT WAS NOT GROUNDED: L4 DOOR LOCK DIFFICULT TO OPERATE. LUBRICATED DOOR LOCK. OPERATIONAL CHECK GOOD.SDR AALA202210209101Latch · looseAIRCRAFT WAS NOT GROUNDED: FLIGHT DECK DOOR HARD TO CLOSE FROM CABIN SIDE. SECURED LOOSE FLIGHT DECK DOOR LATCH ASSEMBLY. OPERATES NORMAL.SDR AALA202210207627Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD FLIGHT ATTENDANT STATION FLASHLIGHT #1 DOES NOT TEST. REPLACED FLASHLIGHT.SDR AALA202210201897Flashlight · inoperativeAIRCRAFT IN BASE MAINTENANCE: FORWARD FLIGHT ATTENDANT STATION FLASHLIGHT #2 DOES NOT TEST. REPLACED FLASHLIGHT.SDR AALA202210254576Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 15.04. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210257021Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 40.87. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210250921Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR SHEAR FITTING LOCATED AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER EA 339611.SDR AALA202210212090Handle · lack of lubeAIRCRAFT WAS GROUNDED: FORWARD ENTRY DOOR ANNUNCIATOR LIGHT CAME ON AFTER LANDING. FLIGHT ATTENDANT REPORTS THE DOOR HANDLE POPPED UP OUT OF THE CLOSED POSITION. LIGHT WENT OUT WHEN HANDLE RUSHED DOWN. INSPECTED L1 DOOR HANDLE AND FOUND HANDLE NEEDING LUBRICATSDR AALA202210197905Life Raft · tornAIRCRAFT IN BASE MAINTENANCE: TORN FORWARD LIFE RAFT COVER AT PASSENGER CABIN. REPLACED LIFE RAFT LOCATED BETWEEN ROW 3 AND ROW 4 AT PASSENGER CABIN PER AMM 25-64-00-900-810.
Back to Boeing 737-823