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 AALA202005189024Handle · lack of lubeAIRCRAFT IN BASE MAINTENANCE: DURING FIRE WARNING TEST NO. 1 FIRE HANDLE VERY DIFFULT TO PULL - IF ANY SIDE LOAD IS APPLIED OR IF HANDLE IS NOT PULLED EXACTLY STRAIGHT THE HANDLE WILL NOT EXTEND TO SHUTOFF. APPLIED LUBRICATION TO #1 ENGINE FIRE HANDLE AND ACSDR AALA2020051869002Latch · out of adjustAIRCRAFT IN BASE MAINTENANCE: FIRST OFFICERS WINDOW LATCH HAS PLAY WHEN IIN LOCKED POSITION. ADJUSTED WINDOW LATCH PER AMM 56-12-11.SDR AALA2020051869001Life Raft · low pressureAIRCRAFT IN BASE MAINTENANCE: LIFE RAFT PRESSURE LOW, BELOW 3000 LBS., CENTERLINE FIRST CLASS AFT POSITION. REPLACED LIFE RAFT PER AMM 25-64-00-900-810.SDR AALA2020052629009Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 276 AND BS 294 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020052629006Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FORWARD CARGO COMPARTMENT AFT SIDE BAFFLE CLIP AT BS 500H AND LBL 24. REPLACEDC BAFFLE CLIP PER AARD 51-00-05-1.SDR AALA2020052629011Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION CHANNEL PANEL BETWEEN BS 500 AND BS 500A AT RBL 21. REPLACED TRANSITION CHANNEL PANEL PER AARD 51-00-05-1SDR AALA2020052629010Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION CHANNEL PANEL BETWEEN BS 500A AND BS 500I AT RBL 21. REPLACED TRANSITION CHANNEL PANEL PER AARD 51-00-05-1 AND SRM 53-00-53-2R-5.SDR AALA2020052629007Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 328 AND BS 344 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020052629004Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND BL 0. REPLACED FLOOR SUPPORT PER SRM -51-10-02.SDR AALA2020052629002Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CABIN FLOOR SUPPORT CRACKED AT BS 540 AND BL 0. REPLACED FLOOR SUPPORT PER SRM 51-10-02.SDR AALA2020052629014Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL SHIELD BETWEEN BS 767 AND BS 787 AT RBL 21. REPLACED TRANSITION PANEL SHIELD PER AARD 51-00-05-1.SDR AALA2020052629013Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANISTION PANEL BETWEEN BS 727I AND BS 727J AT RBL 21. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA2020052629012Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROISON ON AFT CARGO DOOR CUT OUT LOWER SILL WEB BETWEEN BS 800 AND BS 843 AT RBL 24. REPLACED SILL WEB PER AARD 51-00-05-1.SDR AALA2020051219004Battery · dischargedAIRCRAFT NOT GROUNDED - L1 EMERGENCY FLASHLIGHT LEP DOES RED FLASH (BATTERY DEPLETED). REMOVED AND REPLACED L1 EMERGENCY FLASHLIGHT PER AMM 25-64-00.SDR AALA2020052629008Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 400 AND 500I AT LBL 21. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA2020051329008Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK R1 WINDOW CUT OUT UPPER OUTBOARD CORNER C-D WINDOW POST FRAME CRACK SUSPECTED AT BS 219.8 AND RBL 30. UPON ADDITIONAL EVALAUATION NO CRACK WAS FOUND AND PREVENTATIVE MODIFICATION DOUBLER WAS INSTALLED PER EA 304963 ANDSDR AALA2020051329007Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK L1 WINDOW CUT OUT UPPER OUTBOARD CORNER C-D WINDOW POST FRAME CRACK SUSPECTED AT BS 219.8 AND LBL 30. UPON ADDITIONAL EVALAUATION NO CRACK WAS FOUND AND PREVENTATIVE MODIFICATION DOUBLER WAS INSTALLED PER EA 304961 ANDSDR AALA202005129006Cable · out of rigAIRCRAFT WAS GROUNDED. DURING FUNCTIONAL CHECK FLIGHT, LANDING GEAR LEVER STICKS IN DOWN POSITION. HAS TO BE PUSHED IN TO GET RED GEAR LIGHTS TO EXTINGUISH. RIGGED LANDING GEAR CABLES LGVA AND LGVB AND ACCOMPLISHED LANDING GEAR CONTROL SYSTEM TEST PER AMM 32-3SDR AALA202005089002Unknown · malfunctionedAIRCRAFT NOT GROUNDED: DURING DESCENT AUTOPILOT KICKED OFF. LOST LNAV AND VNAV CAPABILITIES. TURNED FLIGHT DIRECTORS OFF. FOS STAYED DISPLAYED WITH INCORRECT INFORMATION. HAD TO DISCONNECT AUTOTHROTTLES BECAUSE FOS FMA ANNUNCIATED TOGA AND AUTOTHROTTLES MOVESDR AALA202005089005Door · out of adjustAIRCRAFT WAS GROUNDED: L-4 DOOR IS DIFFICULT TO ENGAGE TO OPEN DOOR AND HANDLE WILL NOT STOW. ACCOMPLISHED AFT ENTRY DOOR ADJUSTMENT IAW AMM 52-13-00, OPS CKS GOOD.SDR AALA2020050769010Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK, RIGHT HAND #3 WINDOW CUT OUT E-F WINDOW POST FRAME #2 FASTENER HOLE CRACKED AT BS 196.5. REPAIRED WINDOW POST PER EA 304965.SDR AALA2020050769008Window Frame · crackedAIRCRAFT IN BASE MAINTENANCE: FLIGHT DECK, LEFT HAND #3 WINDOW CUT OUT E-F WINDOW POST FRAME #2 FASTENER HOLE CRACKED AT BS 196.5. REPAIRED WINDOW POST PER EA 304965.SDR AALA2020051279002Cylinder · defectiveAIRCRAFT WAS GROUNDED: AFTER GEAR RETRACTION LEFT MAIN LANDING GEAR RED LIGHT REMAINED ILLUMINATED. INSTALLED MAIN GEAR TRANSFER CYLINDER PER AMM 32-32-71. INSTALLED LEFT HAND GEAR ACTUATOR FUSE (AALA202005049008). INSTALLED MAIN LANDING GEAR FLOW REGULATOR (ASDR AALA2020051279003Restrictor Valve · defectiveAIRCRAFT WAS GROUNDED: AFTER GEAR RETRACTION LEFT MAIN LANDING GEAR RED LIGHT REMAINED ILLUMINATED. INSTALLED MAIN GEAR RESTRICTOR. INSTALLED MAIN GEAR TRANSFER CYLINDER (AALA202005079002). INSTALLED MAIN LANDING GEAR FLOW REGULATOR (AALA202005079004). INSTALLSDR AALA2020051279004Regulator · defectiveAIRCRAFT WAS GROUNDED: AFTER GEAR RETRACTION LEFT MAIN LANDING GEAR RED LIGHT REMAINED ILLUMINATED. INSTALLED MAIN LANDING GEAR FLOW REGULATOR PER AMM 32-32-72. INSTALLED MAIN GEAR RESTRICTOR (AALA202005079003). INSTALLED MAIN GEAR TRANSFER CYLINDER (AALA20200SDR AALA2020051289011Link · defectiveAIRCRAFT WAS GROUNDED: AFTER GEAR RETRACTION LEFT MAIN LANDING GEAR RED LIGHT REMAINED ILLUMINATED. INSTALLED HANGER LINK PER AMM 32-32-11 INSTALLED LEFT HAND GEAR ACTUATOR FUSE (AALA202005049008). CYCLED GEAR, OPS AN LEAK CHECK GOOD PER AMM 32-32-21. INSTALLESDR AALA202005049008Fuse · defectiveAIRCRAFT WAS GROUNDED: AFTER GEAR RETRACTION LEFT MAIN LANDING GEAR RED LIGHT REMAINED ILLUMINATED. SUPPLIMENTAL REPORT: INSTALLED LEFT HAND GEAR ACTUATOR FUSE. CYCLED GEAR, OPS AN LEAK CHECK GOOD PER AMM 32-32-21. INSTALLED MAIN LANDING GEAR FLOW REGULATOR (ASDR AALA2020050429001Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT BREAK ANGLE AT BS 540 AND BL 0. REPLACED FLOOR SUPPORT BREAK ANGLE SRM 51-40-02.SDR AALA2020051329009Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL SHIELD BETWEEN BS 767 AND BS 794 AT RBL 20. REPLACED SHIELD PER AARD 51-00-05.SDR AALA2020050769009Web · wornAIRCRAFT IN BASE MAINTENANCE: E&E ACCESS DOOR CUT OUT WEB ABOVE STOP FITTING WORN AT BS 338 AND LBL 10. REPLACED WEB PER AARD 51-00-05-1 AND SRM 53-10-15-01-3.SDR AALA2020050419009Hydromech Unit · unserviceableAIRCRAFT WAS GROUNDED. FLIGHT ABORTED TWO TAKE OFFS AT LOW SPEED ACCOUNT THE NUMBER TWO ENGINE WAS UNABLE TO ACHIEVE MAX THRUST. REMOVED AND REPLACED #2 ENGINE HYDROMECHANICAL UNIT AND FUEL PUMP PER WORK CARD 73-94-12 AND AMM 73-11-01. OPS AND LEAK CHECKS GOODSDR AALA202005049010Pump · inoperativeAIRCRAFT WAS GROUNDED. FLIGHT ABORTED TWO TAKE OFFS AT LOW SPEED ACCOUNT THE NUMBER TWO ENGINE WAS UNABLE TO ACHIEVE MAX THRUST. REMOVED AND REPLACED #2 ENGINE HYDROMECHANICAL UNIT AND FUEL PUMP PER WORK CARD 73-94-12 AND AMM 73-11-01. OPS AND LEAK CHECKS GOODSDR AALA2020050429002Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT BREAK ANGLE AT BS 540 AND BL 0. REPLACED FLOOR SUPPORT BREAK ANGLE SRM 51-40-02.SDR AALA202005019001Flashlight · inoperativeAIRCRAFT NOTGROUNDED - FLIGHT ATTENDANT FLASHLIGHT, AFT RIGHTHAND INBOARD, INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT PER MCM JOB CARD 0094.SDR AALA2020051329010Threshold · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO DOOR CUT OUT LOWER THRESHOLD WEB BETWEEN BS 800 AND BS 845 RBL 30.SDR AALA2020043099004Unknown · malfunctionedAIRCRAFT WAS GROUNDED: ON TAKEOFF AND DURING GEAR RETRACTION, LEFT FORWARD GEAR REMAINED DOWN (INDICATED BY RED GEAR LIGHT) EXTENSION WAS NORMAL. ACCOMPLISHED FIM 32-32-00-810-801 AND AMM 32-32-00-710-801 ALL OPS CKS AND CONDITIONS NORMAL.SDR AALA202004309002Track · lack of lubeAIRCRAFT NOT GROUNDED. CAPTAINS SLIDING WINDOW VERY DIFFICULT TO OPEN AND CLOSE. CLEANED AND LUBRICATED SLIDING WINDOW TRACK PER MM 56-12-11 OPS CHKS OK.SDR AALA202004309005Latch · abnormalAIRCRAFT WAS GROUNDED. AFT ENTRY DOOR 4R HAS SOFT LATCH CONDITION. HANDLE HAS LITTLE TO NO RESISTANCE WHEN MOVED FROM OPEN TO CLOSE POSITIONS. ACCOMPLISHED SOFT UNLATCHING PER MM 52-13-00, OPS CHECKS GOOD.SDR AALA202004299003Engine · overtempAIRCRAFT NOT GROUNDED - ON TAKE-OFF, NO. 2 ENGINE EGT FLASHED RED. THROTTLE PULLED BACK JUST A LITTLE BY PILOT MONITORING, RED INDICATION STOPPED. NO OTHER ANOMALIES. RED BOX ON NO. 2 ENGINE UPPER ENGINE DISPLAY AT GATE UPON SHUT DOWN. ACCOMPLISHED INLET AND ESDR AALA202004309008Rod · out of adjustAIRCRAFT WAS GROUNDED. AFT ENTRY DOOR (4L) HAS A SOFT LATCH CONDITION, HANDLE MOVED TOWARD THE OPEN, POSITION. ACCOMPLISHED SOFT UNLATCHING PER AMM 52-13-10. ALSO ADJUSTED HORIZONTAL ROD ON AFT ENTRY DOOR HANDLE PER FIM 52-10-00.SDR AALA202004289002Controller · faultyAIRCRAFT NOT GROUNDED: ON DESCENT, AUTO FAIL AND ALTN LIGHTS ILLUMINATED ON PRESSURE CONTROL.***SUPPLEMENTAL ACTION SECT 4 AND 5: ACCOMPLISHED FIM 21-31-00-810, 803, 809 , AND 824. REPLACED NO.1 CAB PRESS CONTROLLER IAW AMM 21-31-01.***(CLOSED)SDR AALA202004279003Unknown · malfunctionedAIRCRAFT NOT GROUNDED: FROM TOP OF DESCENT FROM FL380, FMS IN DESCENT MODE WAS LIMITING AIRSPEED FOR FLAP RESTRICTION TO 196 KNOTS. AIRCRAFT WAS CLEAN CONFIGURATION, NO OTHER ABNORMAL. SEEMS AIRCRAFT WAS ATTEMPTING TO AUTOBUG FROM TOP OF DESCENT, IGNORING ASDR AALA2020050429005Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED CABIN FLOOR INTERCOSTAL BETWEEN BS 318 AND BS 328 AT LBL 45. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020043099012Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 312 AND BS 328 AT LBL 46. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA2020050109012Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLIGHT DECK CAPTAINS L1 WINDOW CUT OUT UPPER OUTBOARD C-D WINDOW POST AT BS 219 AND S10L. REPAIRED WINDOW POST PER EA 304419 AND 304691.SDR AALA2020042749010Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FIRST OFFICERS # 3 WINDOW POST. REPAIRED WINDOW POST PER EA # 304780.SDR AALA2020042749009Window Post · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK SUSPECTED ON CAPTAINS # 3 WINDOW POST. REPAIRED # 3 WINDOW POST PER EA #304779.SDR AALA202004239009Cable · shortedAIRCRAFT GROUNDED - EMERGENCY LIGHTS AT SEATS 15ABC, 16ABC, 17ABC INOPERATIVE. FOUND SHORTED CABLE AT SEAT 16ABC. REMOVED AND REPLACED SEAT 16ABC PER AMM 25-22-00. OPERATIONAL CHECK OKAY PER AMM 33-51-00.SDR AALA202004229001Battery · dischargedAIRCRAFT NOT GROUNDED - EMERGENCY FLASHLIGHT AT FORWARD INBOARD FLIGHT ATTENDANT SEAT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY PER AMM 25-64-00, OPERATIONAL CHECK GOOD.SDR AALA2020042219013Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND MAIN LANDING GEAR WHEEL WELL VAPOR BARRIER CRACKED. REPAIRED VAPOR BARRIER PER AARD 57-10-10-9 AND SRM 57-10-10-2R-2.
Back to Boeing 737-823