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 AALA202501179736Sign · missingAIRCRAFT WAS NOT GROUNDED: FORWARD EMERGENCY EXIT DOOR LOWER EXIT SIGN LENS MISSING. REPLACED FORWARD EMERGENCY EXIT DOOR LOWER EXIT SIGN LENS. PER AMM 33-51-01.SDR AALA202501174751Girt Bar · looseAIRCRAFT WAS GROUNDED: FLIGHT ATTANDENT REPORTED THAT THE AFT LEFT GIRT BAR IS LOOSE. REATTACHED BALL END OF LOWER FITTING ON SLIDE BUSTLE TO L2 DOOR SUPPORT BRACKET. PER AMM 25-66-01.SDR AALA202501171124Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT FLIGHT ATTANDENT FLASHLIGHT INOPERATIVE. REPLACED BATTERY. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202501175149Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED: FORWARD FLIGHT ATTADENT FLASHLIGHT INOPERATIVE. REPLACED BATTERY, OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202501173497Door · bindingAIRCRAFT WAS NOT GROUNDED: LEFT AFTER LAVATORY DOOR JAMS AND WILL NOT OPEN FULLY. FOLDED BACK IN INNER DOOR HANDLE. ACCORDION LEFT AFT LAVATORY DOOR OPERATES FULLY OPEN AND CLOSE POSITIONS CORRECTLY. PER CMM AIPC 25-40-64.SDR AALA202501240287Transmitter · unsecureAIRCRAFT WAS NOT GROUNDED: NUMBER 2 ENGINE FUEL FLOW INDICATOR STOPPED WORKING SHORTLY AFTER TAKEOFF. **SUPPLEMENTAL REPORT FOR (AALA202501160287): PERFORMED TROUBLESHOOTING. PER FIM 73-31-00-810-801-F00 FOUND NO FAULTS. CLEANED AND SECURED FUEL TRANSMITTERS CSDR AALA202501161017Circuit Breaker · openAIRCRAFT WAS NOT GROUNDED: FOUND CABIN EMERGENCY LIGHTS BREAKER OPEN DURING PREFLIGHT. RESET CABIN EMERGENCY LIGHTS C1949 CIRCUIT BREAKER. EMERGENCY LIGHTS OPERTIONAL CHECK GOOD. REF MM 33-51-00.SDR AALA202501167797Door · out of adjustAIRCRAFT WAS NOT GROUNDED: BI-FOLD DOOR ON LAVATORY-D AFT LEFT IS EXTREMELY DIFFICULT TO OPERATE. ADJUSTED DOOR ON LAVATORY-D AFT LEFT. OPERTIONAL CHECK GOOD. PER AMM 52-50-00.SDR AALA202501160287Indicator · inoperativeAIRCRAFT WAS NOT GROUNDED: NUMBER 2 ENGINE FUEL FLOW INDICATOR STOPPED WORKING SHORTLY AFTER TAKEOFF. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202501165198Light · inoperativeAIRCRAFT WAS NOT GROUNDED: DURING JOB CARD 08T20033001 EMERGENCY LIGHTS OPERATIONAL TEST. EMERGENCY LIGHT AT SEAT 14ABC INOPERATIVE. REMOVED AND REPLACED 14ABC EMERGENCY LIGHT AND PERFORMED OPERTIONAL CHECKED GOOD. PER AMM 33-51-11 AND TASK CARD 08T20033001.SDR AALA202501159326Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: DETERIORATED PREVIOUS REPAIR TO CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, LBL 45.64. REPAIRED PER AARD 57-10-10-9 AND SRM 57-10-10-2R-10.SDR AALA202502035745Stop Fitting · gougedAIRCRAFT IN BASE MAINTENANCE: AFT ENTRY DOOR FORWARD FRAME-MOUNTED UPPER STOP FITTING HAS A GOUGE ON FORWARD SIDE. BLENDED AND REMOVED GOUGE IN UPPER FORWARD STOP FITTING. PER B737-NG-SRM 51-10-02. AFTER BLENDING BUSHING FOUND TO BE WITHIN LIMITS. PER B737-NGSDR AALA202501277921Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD FROM STA 767 TO STA 787 AT S26R. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202501153070Fuel Filter · cloggedAIRCRAFT WAS NOT GROUNDED: LEFT FUEL FILTER BYPASS LIGHT CAME ON, LIGHT WENT OUT AFTER LEFT ENGINE SHUTDOWN AT THE GATE. REMOVE AND REPLACED LEFT ENG FUEL FILTER AND TIGHTENED BYPASS SWITCH CANNON PLUG. OPERTIONAL AND LEAK CHECKED GOOD. PER MM 73-11-02.SDR AALA202501156986Door · looseAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR IS GETTING STUCK ON TOP. INSPECTED AND SECURED A LOOSE SCREW ON LAVATORY-D DOOR FRAME. OPERTIONAL CJECK GOOD.SDR AALA202501151363Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN WING CENTER SECTION REAR SPAR VAPOR BARRIER AT STA 663.75, LBL 40. REPAIRED CRACK PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2.SDR AALA202501140838Floorbeam · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON WING CENTER SECTION LOWER SUPPORT BEAM LOWER CHORD AT STA 545, RBL 40.875. REPAIRED CHORD PER SRM 57-10-13-2R PROCEDURE 3.SDR AALA202502039453Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD (T-CAP) AT STA 947.5, RBL 23. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202501270942Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT STA 946, LBL 25. REPLACED INTERCOSTAL PER AARD 51-0-05-1.SDR AALA202501274184Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOORBEAM UPPER CHORD AT STA 947.5, LBL 23. REPAIRED CHORD PER SRM 53-70-51-2R-5.SDR AALA202501175630Light · faultyAIRCRAFT WAS NOT GROUNDED: INTERMITTENT RED WHITE FLASHING LIGHT ON EMERGENCY ROW 17ABC. **SUPPLEMENTAL REPORT FOR (AALA202501145630): REPLACED LIGHT ASSEMBLY. PER AMM 33-21-00. SOFTWARE LOADED, OPERTIONAL CHECK NORMAL**(CLOSED).SDR AALA202501145630Light · malfunctionedAIRCRAFT WAS NOT GROUNDED: INTERMITTENT RED WHITE FLASHING LIGHT ON EMERGENCY ROW 17ABC. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202501145302Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-D DOOR HARD TO OPEN. LUBRICATED HINGES, OPERTIONAL CHECK GOOD.SDR AALA202501145094Hinge · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY-2L DOOR HARD TO OPEN AND CLOSE. ADJUSTED LAVATORY-D BI-FOLD DOOR AT HINGE MOUNTING POINTS. OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202501148539Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT ABOVE 25ABC NOT SECURE. SECURED EMERGENCY AREA LIGHT. PER AMM 33-51-03.SDR AALA202501143364Door · out of adjustAIRCRAFT WAS NOT GROUNDED: AFTER RIGHT LAVATORY DOOR DIFFICULT TO OPEN. READJUSTED AFT RIGHT LAVATORY DOOR, OPERTIONAL CHECK GOOD. PER CMM 25-40-64.SDR AALA202501145414Holder · dislodgedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT HOUSING HANGING FROM SEAT 31C. REMOVED AND REPLACED EMERGENCY EXIT LIGHT SHROUD AT 31C. LIGHT OPERTIONAL CHECK GOOD. PER AMM33-51-11.SDR AALA202501146331Handle · brokenAIRCRAFT WAS GROUNDED: 16F EMERGENCY DOOR HANDLE FRAME BROKE AND CAME OFF THE BRACKET AFTER LANDING. REPLACED SCREWS ON 16F EMERGENCY DOOR LIFT HANDLE. PER AMM 52-22-51.SDR AALA202501147953Megaphone · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT MEGAPHONE INOPERATIVE. REMOVE AND REPLACED AFT MEGAPHONE. OPERTIONAL CHECK GOOD. PER AMM 25-64-00.SDR AALA202502031480Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500A TO BS 500I AT LBL 28. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202502035428Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT THRESHOLD PLATE FROM STA 440 TO STA 480 AT RBL 32. REPLACED THRESHOLD PLATE PER AARD 51-00-05-1.SDR AALA202502036253Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL FROM BS 500B PLUS 9 INCHES TO BS 500I. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202501278169Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM STA 727 TO STA 767 AT LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202501247485Pump · failedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FOLLOWING THE PREVIOUS WRITE UP REGARDING THE LOSS OF HYDRAULIC SYSTEM-B (AALA202501136707), AN ENGINE NUMBER 2 OIL FILTER BYPASS MESSAGE ILLUMINATED. AFTER RUNNING THIS ASSOCIATED QRH PROCEDURE FOLLOWINSDR AALA202501228735Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT SHIELD BETWEEN STA 480 PLUS 16 INCHES AND STA 500 AT RBL 32. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202501174081Oven · odorAIRCRAFT WAS NOT GROUNDED: REPEAT WRITE UP. STRONG BURNING SMELL FROM OVEN NUMBER 2. FLIGHT ATTENDANTS REPORT EYE IRRITATION FROM THE FUMES GENERATED INSIDE THE OVEN. REMOVED AND REPLACED NUMBER 2 OVEN. PER AMM 25-32-03.SDR AALA202501157877Compensator · inoperativeAIRCRAFT WAS GROUNDED: CENTER FUEL TANK WILL NOT BURN BELOW 0.11 LBS, TRIED CYCLING LEFT AND RIGHT FUEL PUMPS ON AND OFF, QUANTITY INCREASED TO 0.21 AND WOULD NOT BURN DOWN. DURING TROUBLESHOOTING, TRANSFERRED 5,000 LBS FUEL TO CENTER TANK. ATEMPTED TO TRANSFESDR AALA202501159236Compensator · inoperativeAIRCRAFT WAS GROUNDED: CENTER FUEL TANK WILL NOT BURN BELOW 0.11 LBS, TRIED CYCLING LEFT AND RIGHT FUEL PUMPS ON AND OFF, QUANTITY INCREASED TO 0.21 AND WOULD NOT BURN DOWN. DURING TROUBLESHOOTING, TRANSFERRED 5,000 LBS FUEL TO CENTER TANK. ATEMPTED TO TRANSFESDR AALA202501143387Control Module · faultedAIRCRAFT IN BASE MAINTENANCE: AFTER PERFORMING TRIM CHECKS WITH THE GEAR DOWN DURING FLIGHT CONFIDENCE CHECK, THE GEAR HANDLE WOULD NOT MOVE PAST THE OFF POSITION TO THE UP POSITION. PUT GEAR HANDLE TO DOWN POSITION AND RETURNED FOR LANDING. REMOVED AND REPLASDR AALA202501136707Hydraulic System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: ENGINE NUMBER 2 HYDRAULIC LOW PRESSURE AMBER CAUTION ILLUMINATED ON CLIMB OUT THROUGH FL240. CONCURRED WITH THE HYDRAULIC PUMP LOW PRESSURE; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT SLC. **SUPPLEMENTALSDR AALA202501130507Hydraulic System · faultedAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FOLLOWING THE PREVIOUS WRITE UP REGARDING THE LOSS OF HYDRAULIC SYSTEM-B (AALA202501136707), AN ENGINE NUMBER 2 OIL FILTER BYPASS MESSAGE ILLUMINATED. AFTER RUNNING THIS ASSOCIATED QRH PROCEDURE FOLLOWINSDR AALA202501137877Transfer Sys · faultedAIRCRAFT WAS GROUNDED: CENTER FUEL TANK WILL NOT BURN BELOW 0.11 LBS, TRIED CYCLING LEFT AND RIGHT FUEL PUMPS ON AND OFF, QUANTITY INCREASED TO 0.21 AND WOULD NOT BURN DOWN. DURING TROUBLESHOOTING, TRANSFERRED 5,000 LBS FUEL TO CENTER TANK. ATEMPTED TO TRANSFESDR AALA202501133387Control Handle · faultedAIRCRAFT IN BASE MAINTENANCE: AFTER PERFORMING TRIM CHECKS WITH THE GEAR DOWN DURING FLIGHT CONFIDENCE CHECK, THE GEAR HANDLE WOULD NOT MOVE PAST THE OFF POSITION TO THE UP POSITION. PUT GEAR HANDLE TO DOWN POSITION AND RETURNED FOR LANDING. **SUPPLEMENTAL REPSDR AALA202501136228Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY-E DOOR DIFFICULT TO OPEN AND CLOSE. LUBRICATED AND ADJUSTED LAVATORY-E DOOR. PER CMM 25-40-65.SDR AALA202501134004Slide · dislodgedAIRCRAFT WAS GROUNDED: SLIDE ON L1 DOOR FELL OUT OF BUSTLE WHILE AIRCRAFT CLEANERS WERE OPERATING THE DOOR. THE GIRT BAR IS CURRENTLY CAUGHT BETWEEN THE DOOR AND ENTRY STAND. REMOVED AND REPLACED L1 DOOR SLIDE. PER JC 08L22125001.SDR AALA202501131533Flashlight · usedAIRCRAFT WAS NOT GROUNDED: FORWARD JUMP SEAT FLASHLIGHTS USED. REPLACED FORWARD JUMP SEAT FLASHLIGHTS. PER AMM 25-64-00.SDR AALA202501134081Oven · odorAIRCRAFT WAS NOT GROUNDED: REPEAT WRITE UP. STRONG BURNING SMELL FROM OVEN NUMBER 2. FLIGHT ATTENDANTS REPORT EYE IRRITATION FROM THE FUMES GENERATED INSIDE THE OVEN. (OPEN).SDR AALA202501217306Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL LOCATED FROM STA 380 TO STA 400 AT LBL 14. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202501216431Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR INTERCOSTAL LOCATED FROM STA 380 TO STA 400 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202501139634Anti-Skid Valve · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS NOT DECLARED DUE TO: ANTI-SKID INOPERATIVE LIGHT ILLUMINATED AFTER TAKEOFF; AIRCRAFT DIVERTED TO AND LANDED SAFELY AT PHL. REMOVED AND REPLACED ANTI-SKID VALVE. PER JOBCARD 08L70032008.
Back to Boeing 737-823