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 AALA202402146240Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402149940Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 6.14. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402148809Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 15.04. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402143692Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 32.40. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402147710Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 40.87. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202402141636Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND RBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1.SDR AALA202403115963Light · no testAIRCRAFT WAS NOT GROUNDED: PERFORM EMERGENCY LIGHT OPERATIONAL TEST. **SUPPLEMENTAL REPORT FOR (AALA202402145963): PERFORMED OPERATIONAL TEST OF EMERGENCY LIGHTS. PER B737NG AMM 33-51-00-710-801. CHECK GOOD AND TEST PASS.**(CLOSED).SDR AALA202403014315Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR STRUCTURE WEB FROM BS 1011 TO BS 1014, RBL 37. REPLACED WEB PER AARD 51-00-05-1.SDR AALA202402199139None · noneAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK INOPERATIVE. ACCOMPLISHED LEFT HAND AFT LAVATORY DOOR LATCH INSPECTION PER CMM 25-40-64; FOUND BOTH TO BE IN GOOD WORKING CONDITION.**(CLOSED).SDR AALA202402153049Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN STA 727F AND STA 727G, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402158275Pressure Deck · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON WING CENTER SECTION REAR SPAR VERTICAL PRESSURE DECK WEB AT BS 663, FROM RBL 40 TO RBL 45.6. REPAIRED WEB PER SRM 57-10-10-2R-3 ALTERNATIVE 2.SDR AALA202402141651Light · unsecureAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT IN AISLE NEAR 16D IS HANGING DOWN. RESECURED EMERGENCY OVERHEAD AISLE LIGHT IAW AMM 33-51-03.SDR AALA202402149291Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY TRACK LIGHT ON SEAT 29C IS DETACHED. REATTACHED EMERGENCY TRACK LIGHT ON SEAT 29C. PER CMM 25-23-67.SDR AALA202402145249Slide · not seatedAIRCRAFT WAS NOT GROUNDED: L1 DOOR SLIDE NOT SEATED CORRECTLY. RESEATED L1 DOOR SLIDE PACK AND COVER ASSEMBLY. PER AMM 25-66-01. NO DEFECTS NOTED.SDR AALA202402145963None · noneAIRCRAFT WAS NOT GROUNDED: PERFORM EMERGENCY LIGHT OPERATIONAL TEST. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402145792Slide · unwanted deployAIRCRAFT WAS NOTR GROUNDED: FORWARD RIGHT GALLERY DOOR SLIDE DEPLOYED AS CATERING OPEN THE DOOR. REINSTALLED R1 DOOR SLIDE AND COVER. PER AMM 25-66-01.SDR AALA202402149139Lock · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT LEFT LAVATORY DOOR LOCK INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202402137593Door · unsecureAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR JAMMED AND IS HARD TO OPEN. RESECURED UPPER DOOR TRIM. PER AMM 25-40-00.SDR AALA202403060183Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT STA 466, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202403055280Transition Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO FLOOR STRUCTURE TRANSITION PANEL AT BS 440, LBL 25.SDR AALA202403043762Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 500 TO STA 500H, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202403043871Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR STRUCTURE TRANSITION PANEL FROM STA 500E TO STA 500I, S25L. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202403018286Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 470, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202403018923Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT TRANSITION PANEL AT BS 482, LBL 25. REPLACED TRANSITION PANEL PER AARD 51-00-05-1.SDR AALA202402133649Handle · out of positionAIRCRAFT WAS NOT GROUNDED: AFT RIGHT LAVATORY HANDLE FELL OFF. REPLACED AFT RIGHT LAVATORY DOOR HANDLE. PER CMM 25-40-65.SDR AALA202402136777Lamp · unsecureAIRCRAFT WAS NOT GROUNDED: 16F EMERGENCY EXIT LIGHT ON THE LOWER LEFT SIDE IS MISSING COVER. RESECURED OVERWING EMERGENCY EXIT LIGHT LAMPS PER IPC 33-51-01, AND PERFORMED OPERTIONAL CHECK PER AMM 33-51-01.SDR AALA202402125954Handle · looseAIRCRAFT WAS NOT GROUNDED: EXIT DOOR HANDLE LOOSE, SEAT 16F. TIGHTEN EXIT HANDLE 16F.SDR AALA202402124160Hinge · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR LOCKED JAMMED. OIL LAVATORY D LOCK AND HINGE.SDR AALA202402120627Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727I PLUS 10 INCHES TO BS 747 PLUS 30 INCHES, S25L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5 AND SRM 51-40-02.SDR AALA202403011498Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR STRUCTURE INTERCOSTAL AT BS 294.5, LBL 11. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA202403019320Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR SILL INNER CHORD FROM BS 312 TO BS 326, RBL 60. REPLACED CHORD PER EA 325018.SDR AALA202403014472Transition Panel · corrodedAIRCRAFT BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL FROM BS 727 TO BS 827, LBL 25. REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202403019364Shield · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SHIELD AT BS 727, RBL 25. REPLACED SHIELD PER AARD 51-00-05-1.SDR AALA202402208047Module · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT COULD NOT STOP WITHIN RUNWAY LENGTH; OVER RAN THE RUNWAY. **SUPPLEMENTAL REPORT FOR (AALA202402128047): REMOVE AND REPLACED AUTOBRAKE CONTROL MODULE (AALA202402128047), PER AMM 32-42-81. CORRECTSDR AALA202402201276Connector · misinstalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT COULD NOT STOP WITHIN RUNWAY LENGTH; OVER RAN THE RUNWAY. **SUPPLEMENTAL REPORT FOR (AALA202402128047): REMOVE AND REPLACED AUTOBRAKE CONTROL MODULE (AALA202402128047), PER AMM 32-42-81. CORRECTSDR AALA202402209476Hydraulic Line · misinstalledAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT COULD NOT STOP WITHIN RUNWAY LENGTH; OVER RAN THE RUNWAY. **SUPPLEMENTAL REPORT FOR (AALA202402128047): REMOVE AND REPLACED AUTOBRAKE CONTROL MODULE (AALA202402128047), PER AMM 32-42-81. CORRECTSDR AALA202402147664Rod · disconnectedAIRCRAFT WAS GROPUNDED: FOUND TURNBUCKLE DISCONNECTED FROM WING TRAILING EDGE PANEL SUPPORT BEAM JUST FORWARD OF RIGHT HAND INBOARD FLAP FAIRING.**SUPPLEMENTAL REPORT FOR (AALA202402137664): REMOVED AND REPLACED DRIVE ROD. PER AMM 27-51-18**(CLOSED).SDR AALA202402137664Turnbuckle · disconnectedAIRCRAFT WAS GROUNDED: FOUND TURNBUCKLE DISCONNECTED FROM WING TRAILING EDGE PANEL SUPPORT BEAM JUST FORWARD OF RIGHT HAND INBOARD FLAP FAIRING. (OPEN).SDR AALA202402133127Unknown · unknownAIRCRAF WAS NOT GROUNDED: LEFT REAR (L4) LAVATORY ENTRY DOOR DIFFICULT TO OPEN. : FOUND NO FAULTS IN LOCK HANDLE BI-FOLD DOOR ON BOTH SIDES OF THE LOCK. PER CMM 25-40-64.SDR AALA202402135691Door · lack of lubeAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR IS DIFFICULT TO OPEN. ADJUSTED AND LUBRICATED LAVATORY DOOR PER AMM 25-40-14.SDR AALA202402125167Light · out of positionAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT 10C IS DANGLING, NOT ATTACHED. REPLACED EMERGENCY EXIT LIGHT PER AMM 33-51-11.SDR AALA202402123967Slide · out of positionAIRCRAFT WAS NOT GROUNDED: CATERING REPORTS R2 DOOR LEFT ARMED SLIDE DROPPED FROM BUSSLE. REINSTALLED R2 DOOR SLIDE. PER AMM 25-66-01.SDR AALA202402123127Door · bindingAIRCRAF WAS NOT GROUNDED: LEFT REAR (L4) LAVATORY ENTRY DOOR DIFFICULT TO OPEN. (OPEN).SDR AALA202402128918Handle · missingAIRCRAFT WAS NORT GROUNDED: RIGHT AFT LAVATORY INSIDE DOOR HANDLE FELL OFF AND IS MISSING. RESECURED RIGHT AFT LAVATORY DOOR HANDLE. PER AMM 25-40-00.SDR AALA202402128306Selector · inoperativeAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: PRESSURE UNCONTROLLABLE AFTER TAKE OFF. AIRCRAFT RETURN AND LANDED SAFELY AT MIA WITHOUT FURTHER INCIDENT. REMOVED AND REPLACED CABIN PRESSURE CONTROL PANEL AS PER AMM 21-31-02, TEST NORMAL NO FURTHER DSDR AALA202402128047Unknown · unknownAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: AIRCRAFT COULD NOT STOP WITHIN RUNWAY LENGTH, OVER RAN THE RUNWAY. (OPEN).SDR AALA202402128602Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY D DOOR VERY DIFFICULT TO GET UNLOCKED. ADJUSTED LAVATORY DOORSDR AALA202402277995Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR INOPERATIVE.**SUPPLEMENTAL REPORT FOR (AALA202402127995): ADJUSTED AFT LEFT HAND LAVATORY DOOR. PER CMM 25-40-64**(CLOSED).SDR AALA202402123220Connector · inoperativeAIRCRAFT WAS GROUNDED: DURING CLIMB LEFT GENARTOR OFF BUS ILLUMINATED, RESET UNSUCCESSFUL. REMOVED AND REPLACED T374 GENARTOR 1 DPCT (DIFFERENTIAL PROTECTION CURRENT TRANSFORMER) . PER AMM 24-21-71.SDR AALA202402127995Door · inoperativeAIRCRAFT WAS NOT GROUNDED: LEFT AFT LAVATORY DOOR INOPERTIVE. (OPEN).
Back to Boeing 737-823