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 AALA202305095944Girt Bar · unknownAIRCRAFT NOT GROUNDED: FORWARD LEFT CABIN GIRT BAR LEFT SIDE CLIP NEEDS TO BE ADJUSTED. ADJUSTED L1 CABIN GIRT BAR HOLDER.SDR AALA202305089304Latch · out of adjustAIRCRAFT WAS GROUNDED: FLIGHT DECK DOOR HARD TO KEEP CLOSED, REQUIRED SEVERAL FIRM CLOSURES. ADJUSTED DOOR LATCH ASSEMBLY AND RESECURED DOOR.SDR AALA202305255775Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202305256965Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500D TO BS 500E AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202305258351Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500D AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202305251056Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500E TO BS 500H AT S25L. REPLACED TRANSITION PANEL PER SRM 53-00-53 2R-5.SDR AALA202305175473Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500E TO BS 500H AT S25R. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202305101211Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION FOUND ON AFT CARGO LEFT TRANSITION PANEL LOCATED BETWEEN STA 727 AND 847 AND STR 25R. REMOVED AND REPLACED TRANSITION PANEL PER SRM.SDR AALA202305085749Windshield · crackedAIRCRAFT WAS GROUNDED: R1 WINDSHIELD HAS SCRATCH/CRACK ABOUT 4 INCHES UP FROM THE BOTTOM , 3/4 OF THE WAY TO THE RIGHT. R1 WINDSHIELD REPLACED PER WORKCARD 08C21256001, ALL OPERATIONS AND LEAKS CHECK GOOD.SDR AALA202305081848Spring · unknownAIRCRAFT WAS GROUNDED. L1 DOOR ARRIVED WITH EXTERIOR HANDLE NOT STOWED. REMOVED AND REPLACED BROKEN SPRING AT DOOR HANDLE MECHANISM.SDR AALA202305087280Slide · out of positionAIRCRAFT WAS NOT GROUNDED: AFT LEFT SERVICE DOOR SLIDE ASSEMBLY FELL OUT AT CATERING TRUCK. REMOVED AND REPLACED AFT SLIDE ASSEMBLY AS REQUIRED.SDR AALA202305088258Hook And Loop · unknownAIRCRAFT WAS NOT GROUNDED. 1L DOOR DIFFICULT TO ARM. RE-ATTACHED VELCRO ON GIRP TO VELCRO ON BACKING PAN SHELF. 1L DOOR SLIDE ARMS NORMAL, OK FOR SERVICE.SDR AALA202305085251Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED: AFT RIGHT SERVICE DOOR GIRT BAR DIFFICULT TO ARM. ADJUSTED AFT RIGHT GIRT BAR BRACKET.SDR AALA202305086664Power Supply · intermittentAIRCRAFT WAS GROUNDED: EMERGENCY EXIT ROW LIGHTS OPERATE UNCOMMANDED AND INTERMITTENTLY. REMOVED AND REPLACED POWER SUPPLY ASSEMBLIES AT RIGHT AND LEFT EMERGENCY EXIT, M01694 (AALA202305086664) AND M01695 (AALA202305086370).SDR AALA202305086370Power Supply · intermittentAIRCRAFT WAS GROUNDED: EMERGENCY EXIT ROW LIGHTS OPERATE UNCOMMANDED AND INTERMITTENTLY. REMOVED AND REPLACED POWER SUPPLY ASSEMBLIES AT RIGHT AND LEFT EMERGENCY EXIT, M01694 (AALA202305086664) AND M01695 (AALA202305086370).SDR AALA202305150574Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN INTERCOSTAL, ADJACENT TO LAVATORY MOUNT, LOCATED AT BS 947 PLUS 2 INCHES AND RBL 26. REPLACE INTERCOSTAL PER AARD 53-00-05-1.SDR AALA202305150374Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM, ADJACENT TO LAVATORY MOUNT, LOCATED AT BS 947 AND RBL 26. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA202305117207Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED AT BS 767 AND RBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05.SDR AALA202305081521Latch · out of adjustAIRCRAFT WAS NOT GROUNDED: L4 LAVATORY ENTRY DOOR DIFFICULT TO OPEN FROM THE INSIDE. REMOVED AND REPLACED LAVATORY D LATCH ASSEMBLY REFERENCE CMM 25-40-58. OPERATION CHECKS GOOD.SDR AALA202305084240Door · out of adjustAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO CLOSE AND OPEN. READJUSTED RIGHT AFT LAVATORY DOOR.SDR AALA202305050326Connector · brokenAIRCRAFT IN BASE MAINTENANCE: L2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE FOUND CONNECTOR D40044P BROKEN. REPLACED CONNECTOR PER SWPM 20-72-24. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305058550Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EMERGENCY EXIT LIGHT INOPERATIVE. MAINTENANCE FOUND CONNECTOR D40046P NOT SEATED CORRECTLY. REPLACED CONNECTOR PER SWPM 20-72-24. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305052606Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EMERGENCY SIGN INOPERATIVE. MAINTENANCE FOUND CONNECTOR D12068 NOT CONNECTED. RECONNECTED CONNECTOR PER SWPM 20-30-12. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305054198Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND FORWARD OVERWING EMERGENCY SIGN INOPERATIVE. MAINTENANCE FOUND CONNECTOR D12072 NOT CONNECTED. RECONNECTED CONNECTOR PER SWPM 20-30-12. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA202305050425Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL RIB LOCATED AT STABILIZER STA 129.50; CRACK IN SECOND STIFFENER FROM THE FRONT SPAR. REPLACED RIB PER AARD 51-00-05-1 AND SRM 55-10-09-2R-5.SDR AALA202305050007Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LOWER CHORD LOCATED AT BS 227.8 AND FROM LBL 18 TO RBL 22. REPAIRED CHORD PER EA 343909 AND SRM 53-10-08-1A.SDR AALA202305047214Light · inoperativeAIRCRAFT WAS NOT GROUNDED: LIGHTS INOPERATIVE FROM AFT RIGHT EMERGENCY EXIT DOOR TO ROW 27 DEF. REPLACED AFT RIGHT EMERGENCY DOOR LIGHT ASSEMBLY.SDR AALA202305257622Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500A TO BS 500I AT S26R. REPLACED TRANSITION PANEL PER AARD 51-00-05-01.SDR AALA202305251865Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202305107130Crease Beam · corrodedAIRCRAFT IN BASE MAINTENANCE: WING CENTER SECTION STA 616 RIGHT SIDE AND RIGHT BUTT LINE 64 CREASE BEAM CORRODED. INSTALLED A DOUBLER REPAIR AT CREASE BEAM PER SRM.SDR AALA202305058998Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 184.70, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 51-40-02 AND SRM 55-10-01-2R.SDR AALA202305044193Sign · missingAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT ROW PLACARD ROW 16DEF MISSING. INSTALLED EMERGENCY EXIT SIGN AT ROW 16DEF IN ACCORDANCE WITH AMM 33-51-01.SDR AALA202305044761Skin · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN RIGHT HAND HORIZONTAL STABILIZER LOWER SKIN LOCATED AT STABILIZER STA 157.10, 9 INCHES FROM AFT SPAR. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202305252474Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR SILL INNER CHORD LOCATED FROM BS 927 TO BS 1006 AT RBL 60. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202305177264Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOORBEAM LOCATED UNDER LAVATORY MOUNT AT BS 947 AND LBL 50. REPAIRED FLOORBEAM PER SRM 53-70-51-2R-5.SDR AALA202305170906Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON INTERCOSTAL LOCATED BETWEEN BS 947 AND BS 967 AT LBL 50. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202305124623Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM T-CHORD LOCATED UNDER PASSENGER CABIN AFT LAVATORY MOUNT AT BS 947 AND RBL 24. REPAIRED T-CHORD PER SRM 53-70-51-2R-5.SDR AALA202305112262Stringer · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON STRINGER LOCATED AT BS 320 AND S23L. REPAIRED STRINGER PER SRM 51-40-02 AND EA 343673.SDR AALA202305106540Skin · brokenAIRCRAFT IN BASE MAINTENANCE: BROKEN DRAIN EXTERNAL SKIN STA1016 BETWEEN S25R AND S27R AT LOWER FUSELAGE. REPLACED DRAIN EXTERNAL SKIN STA1016 BETWEEN S25R AND S27R AT LOWER FUSELAGESDR AALA202305089948Control Rod · out of adjustAIRCRAFT IN BASE MAINTENANCE: L1 DOOR DIFFICULT TO CLOSE. ADJUSTED L1 DOOR UPPER CONTROL ROD AND HINGE COVER ASSEMBLY.SDR AALA202305044445Switch · inoperativeAIRCRAFT WAS GROUNDED: FLAP DISAGREE ON FINAL APPROACH INITIALLY CALLED FOR FLAPS 5 FLAPS WENT TO 5 BUT WE ONLY GOT FLAPS 1 AND 5 INDICATIONS ON SPEED TAPE. WHEN WE CALLED FOR FLAP 15 FLAPS STOPPED AT 12 AND WE NEVER GOT A SPEED BUG FOR 15 ON AIRSPEED TAPE. WESDR AALA202305117739Pump · unserviceableAIRCRAFT WAS GROUNDED: ON TAKEOFF THE NUMBER 1 ENGINE DID NOT DEVELOP FULL TAKEOFF THRUST AT 26 K MAX. NUMBER 1 SHOWED 98.7 SHOULD HAVE BEEN 100.7 N1 LOW SPEED REJECT AT 75 KNOTS. **SUPPLEMENTAL REPORT FOR AALA202305047739: REPLACED ENGINE 1 FUEL PUMP PER AMM SDR AALA202305115493Fuel Heater · unserviceableAIRCRAFT WAS GROUNDED: ON TAKEOFF THE NUMBER 1 ENGINE DID NOT DEVELOP FULL TAKEOFF THRUST AT 26 K MAX. NUMBER 1 SHOWED 98.7 SHOULD HAVE BEEN 100.7 N1 LOW SPEED REJECT AT 75 KNOTS. **SUPPLEMENTAL REPORT FOR AALA202305047739: REPLACED ENGINE 1 FUEL PUMP PER AMM SDR AALA202305119633Hmu · unserviceableAIRCRAFT WAS GROUNDED: ON TAKEOFF THE NUMBER 1 ENGINE DID NOT DEVELOP FULL TAKEOFF THRUST AT 26 K MAX. NUMBER 1 SHOWED 98.7 SHOULD HAVE BEEN 100.7 N1 LOW SPEED REJECT AT 75 KNOTS. **SUPPLEMENTAL REPORT FOR AALA202305047739: REPLACED ENGINE 1 FUEL PUMP PER AMM SDR AALA202305109166Baffle · elongatedAIRCRAFT IN BASE MAINTENANCE: BAFFLE BETWEEN STA 500B AND 500C AND 24R RIGHT HAND HAS ELONGATED HOLES. INSTALLED NEW BAFFLE PER AARD.SDR AALA202305047739Unknown · unknownAIRCRAFT WAS GROUNDED: ON TAKEOFF THE NUMBER 1 ENGINE DID NOT DEVELOP FULL TAKEOFF THRUST AT 26 K MAX. NUMBER 1 SHOWED 98.7 SHOULD HAVE BEEN 100.7 N1 LOW SPEED REJECT AT 75 KNOTS. **SUPPLEMENTAL REPORT REQUIRED**(OPEN)SDR AALA202305027590Latch · unknownAIRCRAFT NOT REMOVED FROM SERVICE. LAVATORY "D" LATCH/LOCK DIFFICULT TO UNLOCK. REMOVED DEBRIS AND ADJUSTED LATCH/LOCK AT LAVATORY "D" DOOR.SDR AALA202305028934Bulb · inoperativeAIRCRAFT WAS GROUNDED: RIGHT HAND SIDE AFT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. RELAMP RIGHT HAND SIDE AFT OVERWING EMERGENCY LIGHT IN ACCORDANCE WITH AMM 33-51-04. OPERATION CHECKS NORMAL.SDR AALA202306124228Shade · stuckAIRCRAFT WAS NOT GROUNDED: WINDOW SHADE EMERGENCY EXIT ROW 17F IS STUCK, WILL NOT GO UP OR DOWN. **SUPPLEMENTAL REPORT FOR AALA202305014228: REPLACED WINDOW SHADE AT 17F PER AMM 25-21-12. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202305097485Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AT STABILIZER STA 92.70, 19.5 INCHES AFT OF FORWARD SPAR. REPAIRED RIB PER SRM 55-10-09-2R PROCEDURE 4 REPAIR 4.
Back to Boeing 737-823